pganalyze
pganalyze monitors PostgreSQL production workloads and helps investigate query performance and database health.
What pganalyze is
pganalyze monitors PostgreSQL production workloads and helps investigate query performance and database health. It tracks slowdowns for individual queries over time and collects plans for slow queries. Its Index Advisor identifies missing indexes and offers insight into unused ones; the VACUUM Advisor provides workload-aware autovacuum guidance. Alerts & Check-Up detects common database problems and can notify teams through email, Slack, or PagerDuty. Installation guidance covers managed providers including AWS RDS and Aurora, Azure Flexible Server, Google Cloud SQL and AlloyDB, as well as self-managed Postgres, Heroku Postgres, Crunchy Bridge, Aiven, Supabase, and Neon. Log Insights and features that depend on it require a provider to export Postgres logs through syslog. An open-source collector periodically sends metrics and metadata snapshots to the app. In the recommended setup, its restricted role can read system statistics and metadata but cannot query user data or alter the database. pganalyze says it filters sensitive information from normalized query data.
Good
- Tracks query slowdowns over time and collects query plans
- Advisors cover indexes and autovacuum
- Alerts can reach email, Slack, and PagerDuty
- Self-hosted version keeps data within customer systems
Watch out
- No free plan is available
- Log Insights requires provider syslog log export
- Production plan includes 14 days of historic stats
Who it suits
pganalyze is suited to teams responsible for PostgreSQL production databases who need query analysis, tuning guidance, and alerts. It also offers a self-hosted option for organizations that want data kept within their systems.
Verdict
pganalyze brings query monitoring, database advice, and alerting together for PostgreSQL workloads. Check provider log-export support and the plan's included retention before choosing it.
Plans and prices
From pganalyze's own pricing page, checked 2 Oct 2026.
| Plan | Price | What it gives you |
|---|---|---|
| Production | $149 a month | 1 database server · 14 days historic stats · 5,000 tables per server · Unlimited users · $149 per month |
| Scale | $399 a month | Up to 4 database servers included · $100/month for each additional billable server · 35 days historic statistics · 5,000 tables per server · 1 GB/day Log Insights per server · Unlimited users · $399 per month |
| Enterprise | Priced on request | 10+ database servers · 100 days historic statistics · 25,000+ tables per server · 2 GB/day Log Insights per server for Enterprise Cloud · On-premise or own-cloud deployment · Contact Sales; annual payment term |
The facts
Each one read from pganalyze's own pages, with the date it was checked.
What it does
- Alerts
- Alerts & Check-Up detects common database problems and can notify via email, Slack, and PagerDuty.checked 2 Oct 2026
- Collector
- The collector is open-source and periodically sends database metrics and metadata snapshots to the pganalyze app.checked 2 Oct 2026
- Collector access
- In the recommended configuration, the collector uses a limited-access database role that can read system statistics and metadata but cannot query user data or modify the database.checked 2 Oct 2026
- Compliance
- pganalyze states that it is SOC 2 Type 2 certified.checked 2 Oct 2026
- Hosting integrations
- The installation guides list AWS RDS and Aurora, Azure Flexible Server, Google Cloud SQL and AlloyDB, self-managed installations, Heroku Postgres, Crunchy Bridge, Aiven, Supabase, and Neon.checked 2 Oct 2026
- Index Advisor
- The Index Advisor finds missing indexes and provides insights about unused indexes.checked 2 Oct 2026
- Integration limitation
- Log Insights and dependent features require the database provider to export Postgres logs via syslog.checked 2 Oct 2026
- Privacy
- pganalyze normalizes query information so that only structural data is stored and presented, with sensitive information filtered out ahead of time.checked 2 Oct 2026
- Purpose
- pganalyze provides PostgreSQL monitoring, observability, and performance tuning for production workloads.checked 2 Oct 2026
- Query analysis
- It identifies slowdowns for specific queries over time and collects query plans for slow queries.checked 2 Oct 2026
- Self-hosting
- The on-premise version runs in a Docker container behind the customer's firewall and keeps data within the customer's systems.checked 2 Oct 2026
- VACUUM Advisor
- The VACUUM Advisor provides workload-aware autovacuum tuning and insights for Postgres.checked 2 Oct 2026
The company
- Company history
- pganalyze says it began in 2012 when Lukas Fittl set out to build a Postgres monitoring tool for production workloads.checked 2 Oct 2026
- Founded
- 2012checked 28 Sep 2026
- Headquarters
- San Francisco, California, United Stateschecked 28 Sep 2026
- Maker
- The site footer identifies Duboce Labs, Inc. as the company behind pganalyze.checked 2 Oct 2026
Alternatives to pganalyze
- 1
Grafana Cloud Application Observability
Free planAndroidiOSWebAPI8.4From $0.03 a month - 2
MySQL
Free planAPILinuxmacOSSelf-hosted7.9Free plan - 3
Paessler PRTG Database Monitoring
Free planAndroidiOSWebSelf-hosted7.4Free plan - 4
ManageEngine Applications Manager
Free planAndroidiOSWebLinux7.1From $395 a year - 5
Site24x7 Database Monitoring
AndroidiOSWebAPI7.0From $9 a month - 6
eG Enterprise
WebLinuxSelf-hostedWindows6.8From $100 a month