June 29 - 30, 2023
Switzerland
Kai Wagner (Senior Software Engineering Manager, Percona) will be presenting a talk , pg_stat_monitor: A feature-rich and enhanced version of pg_stat_statements at Swiss PGDay 2023 on June 30th at 11:30 am CEST (09:30 am UTC).
The pg_stat_monitor is the statistics collection tool based on PostgreSQL’s contrib module pg_stat_statements. PostgreSQL’s pg_stat_statements provides only detailed statistics from the last time it was reset, which is often not enough. This makes it harder to observe query performance patterns during specific times. Those patterns are what’s needed when debugging degraded query and server performance. pg_stat_monitor collects and aggregates data on time window basis. Additionally, it differentiates between queries originating from different applications, clients and users. And I haven’t even mentioned the queries execution timing histogram. These features make it especially useful in analyze query behavior generally and during specific time of a day. With plenty of configuration options, turning off actual query parameters, pg_stat_monitor covers observability from all different aspects without compromising on security. pg_stat_monitor is added to Percona Monitoring and Management to collect query metrics. It gives users the ability to see examples instead of fingerprints. Pg_stat_monitor provides more accurate data because of the bucket-based logic. The talk will cover the usage of pg_stat_monitor, its features, and how it can help to enhance your database inspection and monitoring.
Also, Percona is thrilled to support the PGDay Swiss 2023 on the Supporter level.
About the event.
This conference is all about PostgreSQL – the world’s most advanced open source database. Take the opportunity to meet other people with an interest in PostgreSQL in the Swiss community.
