A command-line admin tool for observing and troubleshooting PostgreSQL with a top-like interface and system statistics.
pgCenter is a command-line administration tool for PostgreSQL that provides real-time monitoring and troubleshooting capabilities. It aggregates PostgreSQL runtime statistics and system metrics into an interactive, top-like interface, helping database administrators observe database performance and identify issues efficiently. The tool addresses the lack of native PostgreSQL tools for working with statistics views by offering a consolidated, user-friendly CLI experience.
PostgreSQL database administrators and DevOps engineers who need to monitor, troubleshoot, and optimize PostgreSQL instances in real-time, especially in Linux environments.
Developers choose pgCenter for its comprehensive, all-in-one CLI interface that combines PostgreSQL statistics with system metrics, eliminating the need to switch between multiple tools. Its top-like interactive display, wait events profiling, and statistics recording provide unique insights for performance tuning and issue diagnosis.
Command-line admin tool for observing and troubleshooting Postgres.
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
The top-like interface provides continuous, real-time updates on PostgreSQL and system statistics, as demonstrated in the demo GIF, allowing immediate observation of performance changes.
Supports a wide range of PostgreSQL statistics views (e.g., activity, replication, WAL) and integrates system metrics from /proc, covering CPU, memory, I/O, and network usage for holistic monitoring.
Includes wait events profiling to identify bottlenecks, configuration management for editing files, and logfile access, enabling direct diagnosis and adjustments without switching tools.
Works with a wide range of PostgreSQL versions, gracefully handling differences in statistics and showing descriptive errors for unsupported features, as noted in the usage notes.
Developed and tested only on Linux; usage on other operating systems is not recommended and may not operate properly, limiting deployment in heterogeneous environments.
When connecting to remote PostgreSQL instances, some functions like system metrics retrieval require additional SQL functions and may not work, reducing utility in distributed setups.
Requires SUPERUSER or equivalent database privileges (introduced in PostgreSQL 10), which can be a security concern or barrier in locked-down or legacy environments.