29th September 2022: PostgreSQL 15 RC 1 Released!

Announcing the release of pg_stat_monitor 1.1.0

Posted on 2022-09-22 by Percona
Related Open Source

Percona is happy to announce the 1.1.0 release of pg_stat_monitor. You can install it from the Percona repositories following the installation instructions.

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.

Key enhancements in this release:

  • The bucket start times are now aligned according to bucket time size units.
  • pgsm_normalized_query GUC has been enabled by default now, allowing query parameter values to be available for improved observability. (Note: This option can be disabled at the server start if this behavior is not required, as it does incur a small performance penalty)
  • Histogram of query execution time: Track and visualize query execution variability to gain better insight.

For a complete list of changes, please refer to the release notes.

About Percona

Percona is widely recognized as a world-class open source database software, support, and services company. The organization is dedicated to helping businesses make databases and applications run better through a unique combination of expertise and open source software. Percona works with numerous global brands across many industries creating a unified experience to monitor, manage, secure, and optimize database environments on any infrastructure.

Percona equips organizations with the freedom to choose, the freedom to create, and the freedom to make a difference - helping them scale and innovate with speed as they grow. For more information, visit www.percona.com.

Databases run better with Percona