pgstats
A collection of command-line tools for real-time PostgreSQL statistics monitoring and reporting, similar to vmstat.
What is pgstats?
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.
Overview
Collects PostgreSQL statistics, and either saves them in CSV files or print them on the stdout
Use Cases
Best For
Related Projects
Found a gem we're missing?
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
