Get free storage space of a RDS using python

0

Hello,

How to get free storage space of a RDS using python SDK?

Regards,
Kandarp Bhatt

kandarp
asked 5 years ago1057 views
2 Answers
0

Hi,
Here you go. This will print out a list of the Minimum FreeStorageSpace in Bytes for the last 15 minutes (5 minute intervals). You will need to modify the DBInstanceIdentifier Value to match your database instance indentifier...

import boto3
from datetime import datetime,timedelta
import json

# Create CloudWatch client
cloudwatch = boto3.client('cloudwatch')

response = cloudwatch.get_metric_data(
    MetricDataQueries=[
        {
            'Id': 'fetching_FreeStorageSpace',
            'MetricStat': {
                'Metric': {
                    'Namespace': 'AWS/RDS',
                    'MetricName': 'FreeStorageSpace',
                    'Dimensions': [
                        {
                            "Name": "DBInstanceIdentifier",
                            "Value": "database-1"
                        }
                    ]
                },
                'Period': 300,
                'Stat': 'Minimum'
            }
        }
    ],
    StartTime=(datetime.now() - timedelta(seconds=300 * 3)).timestamp(),
    EndTime=datetime.now().timestamp(),
    ScanBy='TimestampDescending'
) 
print(response['MetricDataResults'][0]['Values'])

Hope this helps!
-randy

answered 5 years ago
0

Hi Randy,

Thanks for the reply and worked.

Thanks
Kandarp Bhatt

kandarp
answered 5 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions