Trying to decide how to deal with the Amazon RDS Performance Insights end-of-life?
Continue below for a comparison of the new Database Insights with pganalyze, or read our post on Performance Insights vs Database Insights.
Continue below for a comparison of the new Database Insights with pganalyze, or read our post on Performance Insights vs Database Insights.
Compare pganalyze to | Database Insights | pganalyze |
|---|---|---|
| Top-Level Query Metrics | For Top 25 Queries | For All Queries (Unlimited) |
| Drill Into Per-Query Metrics | Only with Advanced Mode | |
| EXPLAIN Plan Statistics | Only with Advanced Mode and Amazon Aurora | |
| EXPLAIN Plan Samples with execution details | | |
| Automatic EXPLAIN ANALYZE through auto_explain | | |
| EXPLAIN Insights ("Why is this query slow?") | | |
| EXPLAIN Plan Comparison | Plan text side-by-side view for Plan Statistics | Purpose-built diff of plan structure and metrics |
| Query Rewrite Recommendations | | |
| Index Recommendations | | |
| VACUUM Recommendations | | |
| Overall System Metrics | | |
| Integration with APM tools / Tracing | AWS ApplicationSignals integration only | Integrate APM tool of choice through OpenTelemetry Tracing |
| Integration with Third-Party Dashboards | | Through API |
| Active Session History | | |
| Wait Event Monitoring | | |
| Lock Analysis (Blocked Queries) | Only for AWS Aurora with Advanced Mode | |
| Schema Monitoring | | Built-In |
| VACUUM Monitoring | | Built-In In-Depth Monitoring |
| Replication Monitoring | | Built-In |
| Log Monitoring | (charged extra) | Built-In |
| Pre-Configured Log Filters | | 100+ Log Events Detected Automatically |
| PII obfuscation for sensitive log data | PII in logs filtered using ML-based data protection policies | PII in logs filtered specifically for each log event, unknown log text masked by default |
| Supported Databases | MySQL/Postgres/SQL Server/Oracle | Postgres |
| Hybrid Monitoring of on-premise databases and Postgres in VM/Kubernetes | RDS and Aurora only | Fully supports mixed environments |
| Deployment Method | Cloud | Cloud or Self-Hosted (behind firewall) |
Hundreds Of Companies Monitor Their Production PostgreSQL Databases With pganalyze
