How to improve PostgreSQL Monitoring and ...
summary
Percona Monitoring and Management (PMM) is shown working end to end: metrics and dashboards pull Postgres stats, OS counters and query samples, alerts fire, and custom collectors push Prometheus-format files. Query aggregation and a new PG stat monitor histogram reveal time-of-day slowdowns, a textfile exporter measures WAL write bytes so max_wal_size sizing stops repeated checkpoints, and node-level OS signals (swap, context switches, CPU saturation) explain surprising performance drops. Custom extensions are straightforward and open source.
AI-written summary · about
chapters (7)
- 0:00Start
- 3:00What is Percona Monitoring and Management
- 6:02PMM's Interface
- 10:18Analyzing Query Information
- 33:54Customizing PMM
- 35:27Optimizing WAL size
- 38:44Replication Lag
related talks
50mHow To Improve PostgreSQL Monitoring and Observability With PMM - Part 2
50mHow To Improve PostgreSQL Monitoring and Observability With PMM
53mExtending Percona Monitoring and Management With Custom Collectors
28mThe "411" on PMM
21mEasy way of application monitoring
25mpg_stat_monitor: A cool extension for better monitoring using PMM
58mBetter MySQL With Percona PMM
49mProfessional PostgreSQL monitoring made easy