(EN) pg_stat_monitor: A cool extension for better database (PostgreSQL) monitoring
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 basic statistics, which is sometimes not enough. The major shortcoming in pg_stat_statements is that it accumulates all the queries and statistics, but does not provide aggregated statistics or 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 should be configured using GUC (Grand Unified Configuration). The buckets are used to collect the statistics and aggregate them in a bucket. The talk will cover the usage of pg_stat_monitor and how it is better than pg_stat_statements.
Denys KondratenkoPercona LLC
Denys Kondratenko is an engineering manager in Percona LLC. He works
on Percona Monitoring and Managent (PMM) product. Before Percona he
had extensive experience in opensource development for storage
technologies like Ceph and Lustre. He loves Linux and runs openSUSE
sway on daily basis.