Cloud Database Services

# Inspect EBS BurstBalance and DiskQueueDepth across RDS instances
aws cloudwatch get-metric-data --metric-data-queries '[
  {"Id":"m1","MetricStat":{"Metric":{"Namespace":"AWS/RDS","MetricName":"BurstBalance","Dimensions":[{"Name":"DBInstanceIdentifier","Value":"production-db"}]},"Period":300,"Stat":"Average"}},
  {"Id":"m2","MetricStat":{"Metric":{"Namespace":"AWS/RDS","MetricName":"DiskQueueDepth","Dimensions":[{"Name":"DBInstanceIdentifier","Value":"production-db"}]},"Period":300,"Stat":"Average"}}
]' --start-time $(date -u -v-1H +%Y-%m-%dT%H:%M:%SZ) --end-time $(date -u +%Y-%m-%dT%H:%M:%SZ)

# Inspect active connections and buffer memory hit ratio
SELECT count(*) AS total_connections,
       state,
       wait_event_type,
       wait_event
FROM pg_stat_activity
GROUP BY state, wait_event_type, wait_event
ORDER BY total_connections DESC;