pganalyze
pganalyze.com
What it is
pganalyze monitors PostgreSQL production workloads and supports performance tuning. It tracks query slowdowns over time and collects execution plans for slow queries. The Index Advisor identifies missing indexes and provides information about unused ones. Its VACUUM Advisor offers workload-aware autovacuum guidance, while Alerts & Check-Up detects common database problems and can notify teams through email, Slack, or PagerDuty. The service is available through API, Linux, web, and self-hosted deployments. Installation guidance covers AWS RDS and Aurora, Azure Flexible Server, Google Cloud SQL and AlloyDB, self-managed systems, Heroku Postgres, Crunchy Bridge, Aiven, Supabase, and Neon. An open-source collector sends metrics and metadata snapshots periodically. In its recommended setup, a restricted role reads statistics and metadata without reading user data or modifying the database. pganalyze says sensitive query information is filtered, offers Docker-based on-premise deployment, and is SOC 2 Type 2 certified. Production costs $149 a month.
Spec sheet
- Purpose
- pganalyze provides PostgreSQL monitoring, observability, and performance tuning for production workloads.Read 2 Oct 2026 · pganalyze.com
- Privacy
- pganalyze normalizes query information so that only structural data is stored and presented, with sensitive information filtered out ahead of time.Read 2 Oct 2026 · pganalyze.com
- Compliance
- pganalyze states that it is SOC 2 Type 2 certified.Read 2 Oct 2026 · pganalyze.com
- Headquarters
- San Francisco, California, United StatesRead 28 Sep 2026 · pganalyze.com
- Founded
- 2012Read 28 Sep 2026 · pganalyze.com
- Maker
- The site footer identifies Duboce Labs, Inc. as the company behind pganalyze.Read 2 Oct 2026 · pganalyze.com
- Alerts
- Alerts & Check-Up detects common database problems and can notify via email, Slack, and PagerDuty.Read 2 Oct 2026 · pganalyze.com
- Collector
- The collector is open-source and periodically sends database metrics and metadata snapshots to the pganalyze app.Read 2 Oct 2026 · pganalyze.com
- 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.Read 2 Oct 2026 · pganalyze.com
- Company history
- pganalyze says it began in 2012 when Lukas Fittl set out to build a Postgres monitoring tool for production workloads.Read 2 Oct 2026 · pganalyze.com
- 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.Read 2 Oct 2026 · pganalyze.com
- Index Advisor
- The Index Advisor finds missing indexes and provides insights about unused indexes.Read 2 Oct 2026 · pganalyze.com
- Integration limitation
- Log Insights and dependent features require the database provider to export Postgres logs via syslog.Read 2 Oct 2026 · pganalyze.com
- Query analysis
- It identifies slowdowns for specific queries over time and collects query plans for slow queries.Read 2 Oct 2026 · pganalyze.com
- Self-hosting
- The on-premise version runs in a Docker container behind the customer's firewall and keeps data within the customer's systems.Read 2 Oct 2026 · pganalyze.com
- VACUUM Advisor
- The VACUUM Advisor provides workload-aware autovacuum tuning and insights for Postgres.Read 2 Oct 2026 · pganalyze.com
Plans and prices
Strong points and limits
Strong points
- Query slowdown tracking and execution plans
- Index and VACUUM advisors
- Alerts through email, Slack, and PagerDuty
- Open-source collector with restricted access
- Self-hosted deployment behind the firewall
Limits
- No free plan
- Production plan costs $149 a month
- Log Insights requires provider syslog export
- Supports PostgreSQL only
Who it suits
pganalyze is for teams operating PostgreSQL databases in production that need query analysis, index and vacuum guidance, alerts, or self-hosted deployment. It supports managed providers as well as self-managed installations.
Verdict
pganalyze provides focused PostgreSQL observability with query, index, vacuum, and alerting tools. Its self-hosted option and restricted collector permissions suit organizations with control or privacy requirements, while log integration depends on provider support.
Where Specifiction places it
- Database Monitoring#8 of 388.1
- Database Performance Monitoring Software#8 of 258.1