PostgreSQL Observability: The Log Configuration That Changes Everything
summary
How to configure PostgreSQL logging to turn default sparse logs into a rich, queryable observability source. It explains which postgresql.conf and logging settings to enable so logs record waiting locks, client activity, slow queries and query types per user, allowing historical performance analysis and targeted optimizations without needing Prometheus or complex dashboards.
AI-written summary · about
chapters (7)
- 0:00Introduction
- 2:26PostgreSQL observability
- 6:01Classic observability tools
- 14:29Logs as observability
- 19:46Advanced log config
- 27:10Demo: Kelog analysis
- 29:57Conclusion
related talks
43mLogging Not Just for Lumberjacks
28mScaling the Wall of Text: Logging Best Practices in PostgreSQL
47mIdentifying Slow Queries and Fixing Them!
57mQuery Logging and Workload Analysis
53mThe Future of Observability in Postgres
34mPglog: a flexible log analyser
50mPostgreSQL Query Performance Insights
53mPostgreSQL Configuration for Humans
