How To Improve PostgreSQL Monitoring and Observability With PMM
summary
Shows how PMM stores one-second-resolution metrics in VictoriaMetrics and query analytics in ClickHouse, demos live dashboards and a custom dashboard that surfaces checkpoint spikes every ~3 minutes, explains switching Prometheus to VictoriaMetrics push model for firewall-friendly collection, and adds custom queries and a text-file collector to emit new metrics. Demonstrates pg_stat_statement vs pg_stat_monitor, an example query sped from ~700 ms down to ~120 ms without indexes, and working alerts/advisors.
AI-written summary · about
chapters (15)
- 0:00PostgreSQL monitoring intro
- 1:07What is PMM
- 2:51PMM architecture & install
- 6:03Why monitor PostgreSQL
- 6:24PMM dashboards overview
- 8:36Query analytics for PostgreSQL
- 13:15Live PMM demo
- 14:44Troubleshooting PostgreSQL
- 19:44OS metrics in PMM
- 23:38Interpreting PMM data
- 24:18PostgreSQL optimization case
- 36:32Custom PMM queries
- 42:04Extending PMM metrics
- 46:57PMM alerts & advisors
- 49:05Closing & resources
related talks
51mHow to improve PostgreSQL Monitoring and ...
28mThe "411" on PMM
25mpg_stat_monitor: A cool extension for better monitoring using PMM
49mProfessional PostgreSQL monitoring made easy
42mProfessional PostgreSQL monitoring made easy
11h 43mPercona Community Live Conference - Day 1 - Open Source Databases Conference
34mSpecifics of Data Analysis in Time Series Databases
21mEasy way of application monitoring