Open-source PostgreSQL diagnostic tooling
Self-hosted, privacy-first. Understand what your database is doing without giving up control of your data.
From The Postgres Guy
View pgtools on GitHubpgtools
PostgreSQL diagnostics that speak the language
A Go CLI that surfaces actionable signals from your Postgres instance — no agents, no cloud, no noise.
Session & lock analysis
Real-time pg_stat_activity monitoring. Identify blocking chains, long-running transactions, and idle-in-transaction sessions before they become incidents.
EXPLAIN plan parsing
Parse and interpret query execution plans. Surface sequential scans, missing indexes, and join order issues with context — not just raw JSON.
Vacuum & bloat health
Track autovacuum progress, dead tuple accumulation, and table bloat. Know when your vacuum strategy is falling behind before it shows up in query latency.
Self-hosted, privacy-first
Distributed as a Go binary. No data leaves your infrastructure. No API keys, no telemetry, no vendor dependency.