pgwatch
cybertec-postgresql.com
- Free plan
- Web
- Self-hosted
What pgwatch is
pgwatch collects and visualizes metrics for PostgreSQL databases. Its remote daemon periodically connects to databases and reads PostgreSQL statistics using a normal database user, without requiring special privileges or extensions on the database server. Grafana presents the metrics and supports additional graphs, while optional alerts can use Mail, Slack, or PagerDuty. Metrics can be extended using SQL, with storage options including PostgreSQL, Prometheus, JSON File, and RPC. A built-in web interface manages monitored databases and metric definitions and displays logs. pgwatch supports PostgreSQL 14 and newer, including single instances, high-availability clusters, pooled environments using PgBouncer or Pgpool II, and Patroni cluster managers. It is open-source, free, and self-hosted, with Docker and custom installation options. The FAQ says it can be deployed fully on premises for organizations with data-residency requirements. Some operating-system metrics may not be available when monitoring cloud-managed PostgreSQL services because of platform restrictions.
Who it suits
It suits teams that need to monitor PostgreSQL across individual instances, high-availability clusters, or pooled environments. On-premises deployment may fit organizations with data-residency requirements.
Good to know, and what to watch
- Collects PostgreSQL statistics without special database privileges.
- Grafana dashboards support additional graphs.
- Custom metrics can be defined in SQL.
- Supports PostgreSQL 14 and newer.
- Some operating-system metrics may be unavailable on managed cloud services.
- Monitoring is limited to PostgreSQL databases.
Plans
Every plan and priceOpen Source
Open source
Getting started
- Open the pgwatch product page
- Deploy the Docker installation or choose a custom installation
- Configure a normal PostgreSQL database user for metric collection
- Connect the PostgreSQL 14-or-newer databases to monitor
- Select metric storage and configure Grafana dashboards
- Define custom metrics in SQL when needed
Limits to check
The open-source plan supports PostgreSQL versions 14 and newer. On cloud-managed PostgreSQL services, provider restrictions can prevent collection of some operating-system metrics.
The Club's review
pgwatch is a free, open-source monitoring system for PostgreSQL operators who want to keep collection and storage under their own control. It is particularly suited to teams managing multiple servers, clusters or pooled connections, provided their managed-cloud provider exposes the metrics they require.
Overview
A remote daemon connects to each database on a schedule and reads PostgreSQL statistics. It authenticates as an ordinary database user and needs neither elevated privileges nor an extension installed on the server, which limits the operational changes required for monitoring.
PostgreSQL 14 and later are supported. The deployment model covers standalone databases, high-availability clusters, PgBouncer and Pgpool II pools, and Patroni-managed environments. CYBERTEC describes the software as suitable for infrastructures containing thousands of systems. It can also run entirely on premises, an important option for organizations with strict residency requirements.
The main qualification is cloud-provider visibility. Some operating-system measurements cannot be collected from managed PostgreSQL services when the platform prevents that access, so teams depending on host-level telemetry should confirm their provider's boundaries first.
Key features
Collection, analysis and extension
pgwatch includes query analysis, wait and lock analysis, resource metrics and query-plan capture. Operators can add metrics by writing SQL, either through the configuration database or YAML files. That makes the system useful when PostgreSQL's standard statistics do not answer a particular operational question, although it places responsibility for query design and maintenance on the team.
Dashboards and alerts
Grafana is the presentation layer, with support for creating additional graphs beyond the supplied views. Optional Grafana alerting can send notifications through Mail, Slack or PagerDuty. This is a capable route for teams already comfortable with Grafana; organizations wanting a single, tightly integrated interface may find the split between collection, web management and Grafana less consolidated.
Storage and administration
Metrics can be stored in PostgreSQL, Prometheus, JSON files or through RPC. The built-in web interface manages monitored databases and metric definitions, controls presets and shows logs. That combination gives administrators flexibility over architecture while retaining a central place to review configuration and collection activity.
Pricing
Open Source — free. This is open-source software, with support for PostgreSQL 14 and newer. There are no seat, host or time limits stated for the free plan, so its economic advantage is strongest for teams able to operate the monitoring stack themselves and absorb infrastructure and maintenance work.
CYBERTEC also sells support packages. Standard, Professional and Enterprise tiers include bug fixes for extensions, while access to the ticket system is listed for Professional and Enterprise customers. These packages suit organizations that need a formal support route; the open-source distribution remains the practical choice for teams with in-house PostgreSQL expertise. Support is backed by CYBERTEC's stated international 24/7 technical coverage.
Platforms
pgwatch is self-hosted and web-based. The product page advertises a Docker installation that can be running in about a minute, while custom installation methods are also supported. Self-hosting permits on-premises placement and control of metric storage, but it also means your team must provide the runtime environment, upgrades and availability of the monitoring service.
Who it's for
Choose pgwatch when you run PostgreSQL 14+ across individual servers, HA or Patroni clusters, or connection pools and want a low-privilege collector with SQL-defined extensions. It is a strong fit for platform and database teams responsible for large estates, data-residency controls or existing Grafana and Prometheus practices.
It is less suitable when you need guaranteed host-level metrics from a restrictive managed service, or when you want a fully hosted monitoring product with no collector and dashboard infrastructure to maintain.
Pros and cons
- Pro: Collection uses a normal database account, avoiding special rights and server-side extensions.
- Pro: SQL-defined metrics, multiple storage backends and custom Grafana graphs support tailored observability.
- Pro: Coverage includes standalone, clustered, pooled and Patroni deployments, with a stated ability to scale to thousands of systems.
- Pro: Fully on-premises deployment helps meet residency and control requirements.
- Con: Cloud-managed PostgreSQL may hide operating-system metrics, limiting the picture available to operators.
- Con: Self-hosting and Grafana integration leave infrastructure, maintenance and dashboard administration with the customer.
Alternatives
MySQL is the better direction when your estate is built around MySQL or you need its freemium distribution and broader platform coverage rather than a PostgreSQL-specific collector.
Amazon RDS suits teams that prefer a paid managed database service with a free tier and trial rather than operating monitoring infrastructure themselves.
Grafana Cloud Application Observability is worth choosing when a hosted Grafana-based service, an always-free allowance and usage-priced expansion are preferable to self-hosting.
Site24x7 Database Monitoring is an alternative for organizations seeking a commercial, multi-platform monitoring service with a free trial and paid server-based plans.
Google Cloud SQL is for teams that want a managed Google database service instead of a self-hosted PostgreSQL monitoring layer.
Percona Monitoring and Management is another free, open-source self-hosted database observability option; its installation infrastructure may carry separate costs.
Redgate SQL Provision is a paid choice for teams whose priority is provisioning or masking production data across capacity tiers.
DBmarlin is an alternative database performance-monitoring product with freemium plans and self-hosted platform support.
Verdict
pgwatch is a compelling choice for PostgreSQL specialists who need extensible monitoring, broad cluster and pooling support, and full control of where telemetry lives without granting elevated database access. Its free open-source model keeps licensing out of the way. Look elsewhere if your managed service blocks the host metrics you depend on, or if you want a vendor-hosted experience instead of running Grafana, storage and the collector yourself.
The verdict
pgwatch offers free, self-hosted PostgreSQL monitoring with several storage and deployment options. Check whether your managed database service exposes the operating-system metrics you need.
Questions people ask
What does pgwatch cost?
pgwatch is open-source and free. The listed Open Source plan costs nothing.
How does pgwatch collect metrics?
A remote daemon periodically connects to PostgreSQL databases and reads their statistics using a normal database user without special privileges or server-side extensions.
Where can pgwatch store metrics?
Listed storage options are PostgreSQL, Prometheus, JSON File, and RPC.
Which PostgreSQL deployments are supported?
The FAQ lists single instances, high-availability clusters, PgBouncer or Pgpool II pooled environments, and Patroni cluster managers.
Can pgwatch send alerts?
Optional Grafana alerting supports Mail, Slack, and PagerDuty.
Can pgwatch run on premises?
Yes. The FAQ states that it can be deployed fully on premises for organizations with strict data-residency rules.
What the maker publishes
- Alerting
- Optional alerting through Grafana supports Mail, Slack, and PagerDuty. source
- Alerting
- Optional alerting through Grafana supports Mail, Slack and PagerDuty. source
- Collection model
- It runs as a remote metrics-gathering daemon that periodically connects to databases and reads PostgreSQL statistics. source
- Collection model
- It runs as a remote metrics-gathering daemon that connects periodically as a normal database user. source
- Compatibility
- The product page states that PostgreSQL versions 14 and newer are supported. source
- Custom metrics
- Metrics can be extended by defining them in pure SQL. source
- Dashboards
- pgwatch uses Grafana for metrics presentation and lets users create additional graphs. source
- Dashboards
- Grafana provides the metrics presentation layer and users can create additional graphs alongside predefined ones. source
- Data residency
- The product FAQ states that pgwatch can be deployed fully on premises for organizations with strict data-residency rules. source
- Deployment
- The product page advertises a one-minute Docker installation and custom installations are also possible. source
- Deployment models
- pgwatch supports single instances, high-availability clusters and pooled environments using PgBouncer or Pgpool II, plus Patroni cluster managers. source
- Deployment support
- The FAQ says pgwatch supports single instances, high-availability clusters, PgBouncer or Pgpool II pooled environments, and Patroni cluster managers. source
- Enterprise support
- CYBERTEC support packages for pgwatch include bug fixes for extensions in Standard, Professional and Enterprise tiers, while ticket-system access is listed for Professional and Enterprise tiers. source
- Extensibility
- Metrics can be defined in pure SQL and custom metrics can be added through the configuration database or YAML files. source
- Founded
- 2000 source
- Headquarters
- Wöllersdorf, Austria source
- Installation
- The product page describes a one-minute Docker installation, while custom installations are also possible. source
- Known limitation
- The product FAQ says some operating-system metrics may be unavailable when monitoring cloud-managed PostgreSQL services, depending on platform restrictions. source
- Maker security
- CYBERTEC says it holds ISO/IEC 27001:2022 certification and has completed the TISAX information-security assessment. source
- Managed-service limitation
- CYBERTEC notes that some operating-system-level metrics may be unavailable on cloud-managed PostgreSQL services because of platform restrictions. source
- Privileges
- The collector works as a normal database user without special user rights or extensions installed on the database server. source
- Privileges
- It does not require special user rights or extensions installed on the database server, enabling use in restricted environments such as AWS RDS. source
- Purpose
- pgwatch is a metrics collector and visualization solution for PostgreSQL databases. source
- Purpose
- pgwatch is a metrics collector and visualization solution for PostgreSQL databases. source
Checked against the maker's pages on 1 Oct 2026.