Compare pganalyze to | Solarwinds DPM | pganalyze |
|---|---|---|
| Top-Level Query Metrics | Unknown Query Limit | For All Queries (Unlimited) |
| Drill Into Per-Query Metrics | ||
| EXPLAIN Plans | Only based on pg_stat_activity (sampling) | Log-based, captures all slow statements through log-based EXPLAIN or auto_explain |
| EXPLAIN Plans for long query texts | (only queries up to 4096 characters) | 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 | ||
| Integration with APM tools / Tracing | Through Query Tags | Through Query Tags |
| Integration with Third-Party Dashboards | Yes (through API) | Yes (through API) |
| Active Session History | ||
| Wait Event Monitoring | ||
| Schema Monitoring | Built-in | Built-in |
| VACUUM Monitoring | Built-in in-depth monitoring | |
| Replication Monitoring | Built-in | |
| Log Monitoring | Built-in | |
| Pre-Configured Log Filters | 100+ Log Events Detected Automatically | |
| PII obfuscation | Yes (configurable) | |
| Supported Databases | SQL Server, MongoDB, MySQL, PostgreSQL and others | PostgreSQL |
| Deployment Method | Cloud only | Cloud or On-Premise (behind firewall) |
Hundreds Of Companies Monitor Their Production PostgreSQL Databases With pganalyze
