Archives: Wait Events

ShmemIndex wait event (LWLock) — PostgreSQL

PostgreSQL LWLock wait event ShmemIndex: Waiting to find or allocate space in shared memory.

SubtransBuffer wait event (LWLock) — PostgreSQL

PostgreSQL LWLock wait event SubtransBuffer: Waiting for I/O on a sub-transaction SLRU buffer.

SubtransSLRU wait event (LWLock) — PostgreSQL

PostgreSQL LWLock wait event SubtransSLRU: Waiting to access the sub-transaction SLRU cache.

SyncRep wait event (LWLock) — PostgreSQL

PostgreSQL LWLock wait event SyncRep: Waiting to read or update information about the state of synchronous replication.

SyncScan wait event (LWLock) — PostgreSQL

PostgreSQL LWLock wait event SyncScan: Waiting to select the starting location of a synchronized table scan.

TablespaceCreate wait event (LWLock) — PostgreSQL

PostgreSQL LWLock wait event TablespaceCreate: Waiting to create or drop a tablespace.

TwoPhaseState wait event (LWLock) — PostgreSQL

PostgreSQL LWLock wait event TwoPhaseState: Waiting to read or update the state of prepared transactions.

WALBufMapping wait event (LWLock) — PostgreSQL

PostgreSQL LWLock wait event WALBufMapping: Waiting to replace a page in WAL buffers.

WALInsert wait event (LWLock) — PostgreSQL

PostgreSQL LWLock wait event WALInsert: Waiting to insert WAL data into a memory buffer.

WALSummarizer wait event (LWLock) — PostgreSQL

PostgreSQL LWLock wait event WALSummarizer: Waiting to read or update WAL summarization state.