Announcing general availability of pg_stat_monitor

Posted on 2022-05-06 by Percona
Related Open Source

Percona is happy to announce the general availability of pg_stat_monitor.

Pg_stat_monitor provides a deeper and richer set of query analytics than has been available before. In addition to several additional metrics on previously run queries pg_stat_monitor introduces the ability to store query metrics in time series buckets as well as store metadata like explain plans from previous iterations of the queries.

Key features:

  • End-to-end traceability: Allowing you to track query times and statistics across the various steps within a queries execution.
  • Aggregated stats across configurable time windows: Query statistics are aggregated in time series buckets across a variety of dimensions to give finer grain control.
  • Histogram of query execution time: Track and visualize query execution variability to gain better insight.

Other Features include:

  • Multi-Dimensional Grouping: Groups counters by userid, dbid, queryid, client_ip, and planid for higher precision. This allows a user to drill down into the performance of queries on a more granular level.
  • Capture Actual Parameters in the Queries: pg_stat_monitor allows you to choose if you want to see queries with placeholders for parameters or actual parameter data. This simplifies debugging and analysis processes by enabling users to execute the same query.
  • Query Plan: Each SQL is now accompanied by its actual plan that was constructed for its execution. That’s a huge advantage if you want to understand why a particular query is slower than expected.
  • Tables Access Statistics for a Statement: This allows us to easily identify all queries that accessed a given table.

You can read more about the features in our release blog.