等待事件

等待事件是 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