finds.dev

rapidloop/pgmetrics

Collect and display information and stats from a running PostgreSQL server

View on GitHubHomepage ↗

★ 1,112GoApache-2.0updated Sep 2026

// the take

pgmetrics is a single Go binary that connects to a running Postgres instance and dumps a comprehensive diagnostic snapshot — config, replication, bloat, vacuum/autovacuum state, locks, wait events, and more — as either a human-readable report or JSON. It's built for DBAs and SREs doing one-off troubleshooting or wiring quick checks into scripts, not for teams wanting a dashboard.

Ships as a static Go binary with no runtime dependencies, so you can drop it on a box and run it against a server you don't control the environment of. The metric coverage is genuinely wide — table/index bloat, replication lag, lock waits, checkpoint stats — things that otherwise mean chaining several psql queries from memory. It has dedicated collectors for PgBouncer, Pgpool-II, and Citus (separate files per extension), plus AWS and Azure-specific collection, so it understands the quirks of managed Postgres rather than assuming a vanilla install. JSON output mode makes it usable in automation, not just for a human reading a terminal report.

It's a point-in-time snapshot tool, not continuous monitoring — there's no built-in alerting or history, so you still need Prometheus/Grafana or similar if you want trends rather than a one-shot diagnosis. Full collection needs fairly broad read access to system catalogs and stats views; on locked-down managed instances (no superuser/pg_monitor) several sections will just come back empty with no clear indication of what was skipped versus what's genuinely zero. The extension-aware collectors (PgBouncer, Pgpool, Citus) mean the depth of what you get varies a lot depending on what's actually deployed alongside Postgres, so results aren't uniform across setups. It's effectively a single-vendor (RapidLoop) project — worth checking how actively it's maintained and whether PRs from outside the company land before depending on it for anything long-term.

We read the README, the directory tree and a key source file in October 2026. Nobody pays to be listed. How we judge →

// at a glance

Stars
1,112
Forks
83
Language
Go
License
Apache-2.0
Last commit
9 Sep 2026

// nearby

If pgmetrics isn't quite it.

All repos →