Performance Insights
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
Since PostgreSQL 10.
Where
-
Databases > your-database-name > Monitoring (tab) > Monitoring (dropdown middle right) > Enhanced Monitoring
-
CloudWatch Logs > Log groups > RDSOSMetrics
CloudWatch
CloudWatch metrics and alarms. Performance Insights actually exports metrics to CloudWatch.
Other Monitoring
- Regular snapshots for statistical data from PostgreSQL