pg_stat_monitor

This Release
pg_stat_monitor 1.1.0
Date
Status
Stable
Other Releases
Abstract
PostgreSQL Query Performance Monitoring Tool
Description
pg_stat_monitor is a PostgreSQL Query Performance Monitoring tool, based on PostgreSQL's contrib module pg_stat_statements. PostgreSQL’s pg_stat_statements provides the basic statistics, which is sometimes not enough. The major shortcoming in pg_stat_statements is that it accumulates all the queries and their statistics and does not provide aggregated statistics nor histogram information. In this case, a user would need to calculate the aggregates, which is quite an expensive operation.
Released By
ibrar
License
PostgreSQL
Resources
Special Files
Tags

Extensions

pg_stat_monitor 1.1.0
PostgreSQL Query Performance Monitoring Tool

Documentation

RELEASE_NOTES
Release Notes
CONTRIBUTING
Contributing guide
ADOPTERS
List of pg_stat_monitor Adopters
code-of-conduct
Percona Distribution for PostgreSQL Operator Code of Conduct

README

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).