- pg_stat_monitor 1.1.0
- PostgreSQL Query Performance Monitoring Tool
pg_stat_monitor: Query Performance Monitoring Tool for PostgreSQL
The pg_stat_monitor is a Query Performance Monitoring tool for PostgreSQL. It attempts to provide a more holistic picture by providing much-needed query performance insights in a single view.
pg_stat_monitor provides improved insights that allow database users to understand query origins, execution, planning statistics and details, query information, and metadata. This significantly improves observability, enabling users to debug and tune query performance. pg_stat_monitor is developed on the basis of pg_stat_statements as its more advanced replacement.
While pg_stat_statements provides ever-increasing metrics, pg_stat_monitor aggregates the collected data, saving user efforts for doing it themselves. pg_stat_monitor stores statistics in configurable time-based units – buckets. This allows focusing on statistics generated for shorter time periods and makes query timing information such as max/min/mean time more accurate.
To learn about other features, available in pg_stat_monitor, see the Features section and the User Guide.
pg_stat_monitor supports PostgreSQL versions 11 and above. It is compatible with both PostgreSQL provided by PostgreSQL Global Development Group (PGDG) and Percona Distribution for PostgreSQL.
The RPM (for RHEL and CentOS) and the DEB (for Debian and Ubuntu) packages are available from Percona repositories for PostgreSQL versions 11, 12, 13, 14 and 15.
The RPM packages are also available in the official PostgreSQL (PGDG) yum repositories.
Note: Complete README file can be found at (https://github.com/percona/pg_stat_monitor/blob/REL_1_1_1/README.md).