Skip to content

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

asked 7 years ago1.5K 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

EXPERT

answered 7 years ago

0

Hi Randy,

Thanks for the reply and worked.

Thanks
Kandarp Bhatt

answered 7 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.