等待事件
等待事件是 PostgreSQL的重要优化工具。当您能查明会话为什么在等待资源以及会话在做什么时,您就能更好地减少瓶颈。您可以使用本节中的信息来查找可能的原因和纠正措施。
目录
- 等待事件概述
- BufferPin
- Client – ClientRead
- Client – ClientWrite
- CPU
- Extension
- IO – BufFileRead
- IO – BufFileWrite
- IO – ControlFileWriteUpdate
- IO – DataFileImmediateSync
- IO – DataFileRead
- IO – DSMFillZeroWrite
- IO – WALSync
- IO – WALWrite
- IPC – ExecuteGather
- IPC – ParallelBitmapScan
- IPC – ParallelCreateIndexScan
- IPC – ParallelFinish
- Lock – advisory
- Lock – extend
- Lock – relation
- Lock – transactionid
- Lock – tuple
- LWLock – buffer_content
- LWLock – buffer_io
- LWLock – buffer_mapping
- LWLock – lock_manager
- LWLock – WALWriteLock
- Timeout – PgSleep