Wait Events
Wait events are an important tuning tool for Redrock Postgres. When you can find out why sessions are waiting for resources and what they are doing, you’re better able to reduce bottlenecks. You can use the information in this section to find possible causes and corrective actions.
Table of Contents
- Wait Events Overview
- 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