pg_profile: a strategic PostgreSQL monitoring utility
summary
Presentation introduces the pg_profile (pgpro_pwr) PostgreSQL extensions for strategic monitoring, which collect quantitative data about the database’s most resource-intensive activities to help analyze load during scenarios like performance testing. It covers the extensions’ architecture, features, operational behavior, and practical ways to apply them for DBAs, load-test engineers, and application developers working with Postgres.
AI-written summary · about
chapters (15)
- 0:00Introduction
- 1:47Strategic monitoring
- 5:49pg_profile goals
- 8:20Architecture and requirements
- 10:30Data collection
- 14:08Storage policies and parallelism
- 17:02Creating baselines
- 18:19Report generation
- 25:03Incident investigation
- 30:29Comparative reports
- 33:23Dashboard integration
- 34:50Advanced features
- 36:37Vacuum statistics
- 39:08Limitations and future
- 41:25Q&A
related talks
25mpg_stat_monitor: A cool extension for better monitoring using PMM
51mHow to improve PostgreSQL Monitoring and ...
49mProfessional PostgreSQL monitoring made easy
42mProfessional PostgreSQL monitoring made easy
51mWhen Postgres Can't, You Can!
50mHow To Improve PostgreSQL Monitoring and Observability With PMM - Part 2
53mThe Future of Observability in Postgres
46mPGTracer: A Tracing Tool for Postgres Backends