finds.dev

lesovsky/pgcenter

Command-line admin tool for observing and troubleshooting Postgres.

View on GitHub

★ 1,631GoNOASSERTIONupdated Sep 2026

// the take

pgcenter is a top-like terminal tool for watching and troubleshooting a running Postgres instance, merging Postgres's own stat views (pg_stat_activity, pg_stat_statements, replication, vacuum/index progress, etc.) with OS-level procfs stats in one screen. It's aimed at DBAs and ops engineers who currently bounce between psql and iostat/vmstat/top during an incident.

Per-process screen (Shift+S) ties a specific backend's CPU and IO numbers directly to its query text, which is the actual question you have mid-incident (is this query CPU-bound or IO-bound) and most tools make you correlate manually. The record/report mode captures a time series including per-process data and lets you replay it afterward, so you're not stuck eyeballing a live screen during the actual outage. It covers a genuinely wide set of Postgres statistics views (including the progress-reporting views for vacuum, index builds, and basebackup) that most GUI tools skip. Packaged as deb/rpm/apk and a Docker image, with real CI, so install friction is low.

Linux-only and leans on /proc for most of its distinguishing features, so on anything else the per-process and system screens just don't work. Getting full value wants superuser or near-superuser privileges, which won't fly on most managed Postgres setups, and on RDS specifically the README admits system stats and some functions are unavailable because untrusted procedural languages are blocked. It's designed to run on the same host as Postgres; used remotely against a production database some functions silently degrade, which is exactly the deployment pattern most people reach for a CLI monitoring tool for. It's an interactive/point-in-time tool, not a metrics pipeline - no alerting and no long-term storage beyond its own record format, so it sits alongside Prometheus/Grafana-style monitoring rather than replacing it.

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,631
Forks
106
Language
Go
License
NOASSERTION
Last commit
10 Sep 2026

// nearby

If pgcenter isn't quite it.

All repos →