Back To Schedule
Tuesday, October 20 • 23:00 - 23:30
pg_stat_monitor: A cool extension for better monitoring using PMM

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Feedback form is now closed.

pg_stat_monitor is a statistics collection tool authored by Percona and contributed to the community. It is based on pg_stat_statements, an existing PostgreSQL contrib module. The major shortcoming in pg_stat_statements is that it accumulates all the queries and their statistics but does not provide aggregated statistics nor histogram information. In this case, a user needs to calculate the aggregate, which is quite expensive. pg_stat_monitor provides the pre-calculated aggregates.
pg_stat_monitor collects and aggregates data on a bucket basis. The size and number of buckets is configured using GUC (Grand Unified Configuration). The buckets are used to collect the statistics and aggregate them into a bucket. This talk covers the usage of pg_stat_monitor and how it is an improvement on pg_stat_statements.
pg_stat_monitor is added to Percona Monitoring and Management to collect query metrics. This provides users the ability to see examples instead of fingerprints. pg_stat_monitor provides more accurate data because of bucket based logic. Also, collecting data from pg_stat_monitor provides better performance than pg_stat_statements.

avatar for Ibrar Ahmed

Ibrar Ahmed

Sr. Software Architect, Percona
Ibrar Ahmed is a Software Architect in Percona LLC. Prior to coming to open source development, he had vast experience in software design and development. His main focus was on system-level embedded development. After joining EnterpriseDB in 2006, an Enterprise PostgreSQL company... Read More →
avatar for Nurlan Moldomurov

Nurlan Moldomurov

Software Engineer, Percona

avatar for Ann Schlemmer

Ann Schlemmer

President, Percona
Ann joined Percona in 2013 and has held various leadership positions in the Services Organization. Prior to Percona, Ann was part of the MySQL Professional Services team at Sun Microsystems and later Oracle. Before entering the world of Open Source Databases, Ann had a career in retail... Read More →

Tuesday October 20, 2020 23:00 - 23:30 EDT
  • Speaker Location Pakistand & Kyrgystan