CODEWITHSUNDEEP
storagemonitoringamazon-rdsaws-cli
Adam Matan
Adam Matan

Reputation: 136271

Query storage status on an RDS DB using AWS CLI

I have a few RDS servers I'd like to monitor for insufficient disk space. For simplicity sake, I prefer using my current monitoring system rather than an AWS solution like cloudwatch.

I've been reading the documentation and the nearest solution was describe-db-instances, which gives the allocated storage, but not the space left / amount of storage used:

"SecondaryAvailabilityZone": "us-east-1a",
"ReadReplicaDBInstanceIdentifiers": [],
"AllocatedStorage": 100,
...

How do I query a specific RDS DB instance for the amount of free space left or used?

Upvotes: 0

Views: 2445

Answers (1)

Adam Matan
Adam Matan

Reputation: 136271

The right tool is the cloudwatch CLI:

aws cloudwatch get-metric-statistics             \
               --metric-name FreeStorageSpace    \
               --start-time 2017-02-27T23:00:00Z \ 
               --end-time 2017-02-28T23:00:00Z   \
               --period 3600                     \
               --namespace AWS/RDS               \
               --statistics Average              \  
               --dimensions Name=DBInstanceIdentifier,Value=<DB-NAME>

<DB-NAME> and the metric name FreeStorageSpace can be found using:

aws cloudwatch list-metrics

Upvotes: 1

Related Questions