pgwatch
pgwatch: A broad self-hosted monitoring toolkit for PostgreSQL-focused teams. Ranked #13 of 24 in Database Performance Monitoring Software by our editors (7.9/10); pricing: Open source; best for free self-hosted PostgreSQL monitoring.
At a glance
- Editor score7.9 / 10
- PricingOpen source
- Best forFree self-hosted PostgreSQL monitoring
- Paid fromFree
- Wait and lock analysisYes
- Founded2000 · Wöllersdorf, Austria
- Facts checked20 Sep 2026
Where it wins
- Detailed PostgreSQL activity, query, lock, log, and system metrics
- Custom SQL metrics with Grafana dashboards and optional alerting
- Broad discovery and storage support across PostgreSQL ecosystems
Where it doesn't
- Self-hosted deployment requires teams to manage operations and infrastructure
- Monitoring scope is centered on PostgreSQL and related database systems
- No AI features are included
Our verdict on pgwatch
pgwatch is an open-source, self-hosted monitoring tool for PostgreSQL databases. It is aimed at teams that need database activity, health, query performance, lock, I/O, replication, log, and operating-system metrics without adopting a hosted monitoring service. The product provides a built-in WebUI and internal REST API, while Grafana dashboards provide another way to view collected measurements. Its positioning suits PostgreSQL operators, platform teams, and organizations that want control over deployment and metric storage.
The monitoring depth is its clearest strength. pgwatch uses pg_stat_statements for SQL query performance statistics, supports query-plan capture, and includes lock contention and blocking-session analysis. Teams can define custom metrics with SQL, monitor server-log errors, and collect OS-level metrics through helper procedures. Metric storage can use PostgreSQL, TimescaleDB, CitusDB, or CockroachDB sinks, with Prometheus also supported in its ecosystem. Discovery support covers PgBouncer, Pgpool2, AWS RDS, Patroni, Kubernetes, and OpenShift, giving the tool useful reach across PostgreSQL deployments.
The published product model is open source rather than a tiered SaaS offering. Deployment options include Docker, Kubernetes, YAML, and environment-based configuration, so adoption can fit different infrastructure practices but leaves setup and ongoing operations with the team running pgwatch. Grafana integration and optional alerting add flexibility, while the built-in interface and REST API support direct access. Choose pgwatch when self-hosting, PostgreSQL-specific analysis, and configurable metrics are priorities. Teams seeking a hosted, database-agnostic service or AI-assisted monitoring should consider an alternative.
Your product? Our editors can test pgwatch in depth and publish a review, labelled as paid · from $149/mo →
pgwatch pricing
pgwatch fact sheet
| Free plan | Not verified |
|---|---|
| Paid from | Free |
| Supported databases | PostgreSQL |
| Query analysis | Yes |
| Wait and lock analysis | Yes |
| Resource metrics | Yes |
| History retention | Not verified |
| Deployment model | Self_hosted |
| Query plan capture | Yes |
| Deployment | Self-hosted |
| Platforms | Web |
| Support | Email, Tickets, Docs |
| Built for | Small business, Mid-market, Enterprise (editorial estimate) |
| Integrations | 12 integrations: Grafana, Prometheus, PostgreSQL, TimescaleDB, CitusDB, CockroachDB … |
| Pricing | Open source |
| Website | cybertec-postgresql.com |
| Facts checked | 20 Sep 2026 |
pgwatch integrations
pgwatch lists 12 integrations on its own site.
- Grafana
- Prometheus
- PostgreSQL
- TimescaleDB
- CitusDB
- CockroachDB
- PgBouncer
- Pgpool2
- AWS RDS
- Patroni
- Kubernetes
- OpenShift
Alternatives to pgwatch
- Redgate MonitorA broad monitoring platform for teams managing mixed database estates across hybrid infrastructure.9.4
- Quest Foglight for DatabasesA strong fit for teams managing diverse databases, with contact-sales pricing.9.2
- Percona Monitoring and ManagementA broad, free monitoring platform with deep query analysis and hybrid deployment.9.1
See all pgwatch alternatives →
Used pgwatch? Be the first to review it
The editor score above is our own research. What this page doesn't have yet is a reader's view — what you used pgwatch for, what worked and what didn't. No stars are seeded and no review is paid for; an editor reads every one before it appears.
Write a reviewTwo minutes · verified accounts only · read by an editor before it appears
Featured on iTechGuides
pgwatch is listed in our Database Performance Monitoring Software directory. Add the badge to your site — it links back to this page.
<a href="https://www.itechguides.com/products/pgwatch/"><img src="https://www.itechguides.com/best/badge/pgwatch.svg" alt="Featured on iTechGuides" width="230" height="46"></a>
Reviewed by iTechGuides Editors · Editorial team · Updated Oct 2026
Advertiser disclosure: iTechGuides is reader-supported. Vendors can pay for top positions in our rankings and for a place on other products' pages, and we may earn a commission when you click some links. Bought places stand at the number bought; this page and our disclosure say so. Paying vendors may get a fuller, more detailed review from our editors, and that review can change their score. How we rank.
Last updated · How we research and update