A collection of command-line tools for real-time PostgreSQL statistics monitoring and reporting, similar to vmstat.
pgstats is a suite of lightweight command-line utilities for PostgreSQL database administrators and developers. It provides real-time monitoring, detailed reporting, and CSV export capabilities for PostgreSQL's extensive statistics views, helping users understand database performance and behavior. The suite includes tools like pgstat for live statistics display, pgcsvstat for CSV exports, pgwaitevent for wait event monitoring, pgreport for comprehensive reporting, and pgdisplay for experimental table data display.
PostgreSQL database administrators and developers who need to monitor, analyze, and troubleshoot database performance directly from the command line. It is particularly useful for those managing PostgreSQL versions from 8.x to the latest releases.
Developers choose pgstats for its simplicity, broad PostgreSQL version compatibility (from 8.x to the latest), and Unix-style practicality without complex dependencies. It offers specialized tools like pgwaitevent for query-level wait event analysis and pgcsvstat for easy data export, which are not always available in standard PostgreSQL tooling.
Collects PostgreSQL statistics, and either saves them in CSV files or print them on the stdout
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
Supports PostgreSQL from ancient 8.x to the latest 18.x releases, ensuring usability across diverse environments, as stated in the README's compatibility notes.
pgstat provides vmstat-like live updates for statistics like connections, tables, and statements at configurable intervals, demonstrated in the detailed usage examples.
Tools like pgwaitevent offer unique query-level wait event aggregation, and pgcsvstat enables easy CSV export for graphing, addressing specific DBA needs not always covered by core PostgreSQL.
Emphasizes lightweight, dependency-free tools that compile with just 'make', aligning with the philosophy of practicality and ease of use for command-line workflows.
Requires PostgreSQL development libraries (e.g., libpq, header files) and a build step, which adds complexity compared to pre-packaged monitoring solutions.
The README is minimal, lacking comprehensive tutorials, configuration guides, or troubleshooting help, relying heavily on --help output for usage.
Some components like pgdisplay are labeled experimental, and the suite focuses narrowly on statistics without broader features like replication monitoring or alerting.
Purely command-line based with no web interface or APIs for automation, limiting its appeal in modern DevOps pipelines that rely on dashboards and alerts.