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