Compare pganalyze to RDS Performance InsightsYou can download this comparison as a PDF and share it with your team | RDS Performance Insights | pganalyze |
---|---|---|
Top-Level Query Metrics | For Top 25 Queries | For All Queries (Unlimited) |
Drill Into Per-Query Metrics | ||
EXPLAIN Plans | Log-based, captures all slow statements through log-based EXPLAIN or auto_explain | |
EXPLAIN Plans for long query texts | No limit on query text length | |
EXPLAIN Insights (“Why is this query slow?”) | ||
Automatic EXPLAIN ANALYZE through auto_explain | Optionally available | |
Index Recommendations | With pganalyze Index Advisor | |
VACUUM Recommendations | With pganalyze VACUUM Advisor | |
Overall System Metrics | Yes (through Cloudwatch) | |
Integration with APM tools / Tracing | Through Query Tags | |
Integration with Third-Party Dashboards | Yes (through API) | |
Active Session History | ||
Wait Event Monitoring | ||
Schema Monitoring | Built-in | |
VACUUM Monitoring | Built-in in-depth monitoring | |
Replication Monitoring | Yes (through Cloudwatch) | Built-in |
Log Monitoring | Yes (through Cloudwatch, charged extra) | Built-in |
Pre-Configured Log Filters | 100+ Log Events Detected Automatically | |
PII obfuscation | Yes (configurable) | |
Supported Databases | MySQL and PostgreSQL | PostgreSQL |
Deployment Method | Cloud only | Cloud or On-Premise (behind firewall) |