- pg_stat_monitor 1.0.1
- PostgreSQL Query Performance Monitoring Tool
- 404 - Not found
- Percona Distribution for PostgreSQL Operator Code of Conduct
- Comparing pg_stat_monitor and pg_stat_statements
- Contributing guide
- User Guide
- Release Notes
- pg_stat_monitor view reference
- Setting up pg_stat_monitor
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 and 14.
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/main/README.md).