pgmetrics.io

What It Is

pgmetrics is an open-source PostgreSQL metrics collection and reporting tool from RapidLoop. It is distributed as a zero-dependency, statically linked single binary and does not require installing PostgreSQL extensions in the database. This makes it well suited for health checks, troubleshooting, and automated collection in production environments, managed databases, or restricted-permission setups.

Core Capabilities

Its main strength is broad coverage: according to the description, it can collect 350+ metrics, including server version, transaction ID wraparound, checkpoints, replication, WAL archiving, BG Writer, Vacuum, tablespaces, database size and bloat, locks, blocking queries, slow queries, table and index statistics, and system CPU/memory/disk metrics. Output formats include human-readable text, JSON, and CSV; the latter two are useful for scripts, CI operations tasks, or custom monitoring pipelines. It can also analyze PostgreSQL log files to extract execution plans, autovacuum, and deadlock information.

Compatibility and Ecosystem

pgmetrics supports PostgreSQL 9.3 through 18 and covers managed services such as AWS RDS, Aurora, Azure Database for PostgreSQL, Azure Cosmos DB for PostgreSQL, and Google GCP SQL. It also supports Citus, PgBouncer, Pgpool, and Odyssey. Its command-line arguments and environment variables follow a psql-like style, so the learning curve is relatively low. If you need real-time dashboards, alerting, and diagnostics, reports can be sent to the commercial product pgDash.

Pricing and Open Source

pgmetrics itself is an Apache License 2.0 open-source tool. No pricing information is shown in the source text, making it highly cost-effective. The related pgDash is a commercial product with a 14-day free trial and offers both SaaS and self-hosted/on-premises deployment options, though specific pricing is not disclosed.

Pros, Cons, and Who It’s For

Its advantages are simple deployment, no extension requirement, detailed metrics, and good compatibility with managed PostgreSQL. It is especially suitable for DBAs, SREs, and backend teams handling incident snapshots, health checks, capacity analysis, and script-based automation. The limitation is that pgmetrics itself is not a full monitoring platform: it does not handle long-term storage, trend analysis, alerting, or visualization. Enterprise support and SLA information are also not reflected in the source text.

Access from China

The source text does not provide information about access, mirrors, or payment options for mainland China, so availability should be considered unknown. If access to GitHub or the official download site is unstable, alternatives or complementary tools such as Prometheus PostgreSQL Exporter, pgBadger, PMM, and Zabbix PostgreSQL templates may be worth considering.