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) |
Hundreds Of Companies Monitor Their Production PostgreSQL Databases With pganalyze
