Monitoring Waits in PostgreSQL
summary
Describes methods for monitoring what individual PostgreSQL backend processes are waiting on in highly concurrent, multicore high-load systems. Covers detection of waits for high-level locks (table locks), internal synchronization locks, I/O waits, and other wait events, and discusses tools/approaches to identify and diagnose those wait sources in PostgreSQL.
AI-written summary · about
chapters (5)
related talks
48mUnderstanding and Reducing Application Contention
45mPostgreSQL monitoring fundamentals
47mAnatomy of concurrent data access in PostgreSQL
51mHow to improve PostgreSQL Monitoring and ...
30mQueues in PostgreSQL
49mProfessional PostgreSQL monitoring made easy
32mDesigning and implementing a monitoring feature in PostgreSQL
35mUnderstanding and Optimizing commit sychronization for maximum performance