Amazon RDS

Performance Insights

Official Documentation

Activity of RDS. Top SQL / most expensive queries. Adjustable to 5m, 1h, 5h, 24h, 1w, all. OS Metrics.

  • Counter metrics
  • Database load
  • Top waits / Top SQL / Top hosts / Top users

Enhanced Monitoring

Official Documentation

Since PostgreSQL 10.

Where

  1. Databases > your-database-name > Monitoring (tab) > Monitoring (dropdown middle right) > Enhanced Monitoring

  2. CloudWatch Logs > Log groups > RDSOSMetrics

OS metrics

CloudWatch

CloudWatch metrics and alarms. Performance Insights actually exports metrics to CloudWatch.

Other Monitoring

  • Regular snapshots for statistical data from PostgreSQL