Compare pganalyze to pgDashYou can download this comparison as a PDF and share it with your team | pgDash | pganalyze |
|---|---|---|
| Top-Level Query Metrics | For Top 100 Queries | For All Queries (Unlimited) |
| Drill Into Per-Query Metrics | Query text limited to 500 characters | Unlimited query text |
| EXPLAIN Plans | auto_explain | auto_explain or log-based EXPLAIN |
| EXPLAIN Plans for extended query protocol | ||
| EXPLAIN Plans for long query texts | ||
| EXPLAIN Insights ("Why is this query slow?") | ||
| Automatic EXPLAIN ANALYZE through auto_explain | ||
| Index Recommendations | With pganalyze Index Advisor | |
| VACUUM Recommendations | With pganalyze VACUUM Advisor | |
| Overall System Metrics | ||
| Integration with APM tools / Tracing | Through Query Tags | |
| Integration with Third-Party Dashboards | Yes (through API) | |
| Active Session History | ||
| Wait Event Monitoring | ||
| Schema Monitoring | ||
| VACUUM Monitoring | Basic table statistics only | In-depth monitoring |
| Replication Monitoring | ||
| Log Monitoring | Limited, only collects 3 event types | Supports all event types |
| Pre-Configured Log Filters | Limited Log Events Detected | 100+ Log Events Detected Automatically |
| PII obfuscation | Yes (configurable) | |
| Supported Databases | PostgreSQL | PostgreSQL |
| Deployment Method | Cloud or On-Premise (behind firewall) | Cloud or On-Premise (behind firewall) |
Frequently asked questions
How long does pganalyze retain my data?
Historic statistics are kept for 14 days on the Production plan, 35 days on Scale, and 100 days on Enterprise. When you remove a server from pganalyze, its data ages out within that retention window, and support can delete it immediately on request. Metadata as well as information in pganalyze Workbooks is kept until you delete them or request deletion.
How much does pganalyze cost?
pganalyze Production is $149 per month for one Postgres server with 14 days of history. Scale is $399 per month for four billable servers, then $100 per month per additional server, with 35 days of history, auto_explain plans, Query Advisor, VACUUM Advisor, and Log Insights. Enterprise is priced per engagement, billed annually, with 100 days of history and the option to self-host. Every plan includes unlimited users and a 14-day free trial.
Can I self-host pganalyze on-premise?
Yes. pganalyze Enterprise Server is a fully self-contained version of pganalyze that runs behind your firewall on Docker, on Kubernetes with EKS or AKS, or on a VM, with the same query monitoring, Index and Query Advisor, EXPLAIN analysis, and Log Insights as the cloud service. No monitoring data leaves your network. It is part of the Enterprise plan; contact pganalyze for a trial.
How does the pganalyze Index Advisor decide which indexes to recommend?
The pganalyze Index Advisor looks at every query on a table, not one query at a time, and models how Postgres would use each candidate index with planner logic and a constraint programming solver. It weighs the read time an index saves against the write overhead it adds, so it can avoid an index that speeds up one query but slows down the table writes significantly. Recommendations appear within 48 hours and include the reasoning; nothing is created automatically.
Does pganalyze send alerts to Slack and PagerDuty?
Yes. pganalyze checks run every 30 minutes, near real time for connection and lock issues, or daily, and alert rules route them to email, Slack, or PagerDuty. Slack receives every severity; email and PagerDuty receive critical issues. Acknowledging or resolving an issue in pganalyze syncs to PagerDuty.
How does pganalyze compare with pgDash?
pgDash shows Postgres metrics and the top 100 queries, with query text cut at 500 characters. pganalyze tracks every query up to your pg_stat_statements limit with the full text, and adds the Index Advisor and VACUUM Advisor, EXPLAIN plan insights with PII obfuscation, every Postgres log event type, and wait-event history for finding blocking queries.
Hundreds Of Companies Monitor Their Production PostgreSQL Databases With pganalyze
