pg_stat_monitor: A cool extension for better monitoring using PMM
summary
pg_stat_monitor claims to replace pg_stat_statements by providing pre-calculated aggregates and bucketed timing histograms so aggregates and latency distributions are ready instead of expensive to compute. It installs as an extension (shared_preload_libraries), ships Debian/RPM packages, is tech‑preview 0.6.0 and is integrated into PMM (requires PMM ≥2.11). It optionally captures actual parameter values, extracts table names, reports CPU user/sys times, and uses circular time buckets — the demo shows lower overhead and more accurate, time-sliced metrics.
AI-written summary · about
chapters (6)
- 0:00Introduction
- 1:53PostgreSQL Architecture
- 3:39PostgreSQL 13 Updates
- 8:00pgstatmonitor
- 11:46pgstackmonitor
- 19:33PMM integration
related talks
51mHow to improve PostgreSQL Monitoring and ...
50mHow To Improve PostgreSQL Monitoring and Observability With PMM - Part 2
50mHow To Improve PostgreSQL Monitoring and Observability With PMM
38mAdvanced PMM Usage
49mProfessional PostgreSQL monitoring made easy
47mpg_profile: a strategic PostgreSQL monitoring utility
51mPostgreSQL Query Performance Insights
50mRedgate Monitor and pgNow