pgterm is an interactive terminal UI designed to monitor multiple PostgreSQL databases simultaneously, functioning much like 'htop' for database health. It leverages pgbot's read-only diagnostics to provide real-time visibility into connections, locks, queries, indexes, and replication status across a tabbed interface.
Highlights
Multi-tabbed interface allows for monitoring several PostgreSQL databases in a single view
Provides real-time health metrics including locks, query regressions, unused indexes, and replication lag
Uses pgbot as a read-only diagnostic engine to ensure monitoring is non-intrusive and safe
Security-focused design with masked connection strings and no SQL console or shell access
Easy installation via shell script or building from source using Rust/Cargo
auto-generated
pgrundev · via GitHub
Context
Audience
Database Administrators, DevOps Engineers, and Backend Developers