Archives: Wait Events

WaitEventCustom wait event (LWLock) — PostgreSQL

PostgreSQL LWLock wait event WaitEventCustom: Waiting to read or update custom wait events information.

WaitLSN wait event (LWLock) — PostgreSQL

PostgreSQL LWLock wait event WaitLSN: Waiting to read or update shared Wait-for-LSN state.

WrapLimitsVacuum wait event (LWLock) — PostgreSQL

PostgreSQL LWLock wait event WrapLimitsVacuum: Waiting to update limits on transaction id and multixact consumption.

XactBuffer wait event (LWLock) — PostgreSQL

PostgreSQL LWLock wait event XactBuffer: Waiting for I/O on a transaction status SLRU buffer.

XactSLRU wait event (LWLock) — PostgreSQL

PostgreSQL LWLock wait event XactSLRU: Waiting to access the transaction status SLRU cache.

XactTruncation wait event (LWLock) — PostgreSQL

PostgreSQL LWLock wait event XactTruncation: Waiting to execute pg_xact_status or update the oldest transaction ID available to it.

XidGen wait event (LWLock) — PostgreSQL

PostgreSQL LWLock wait event XidGen: Waiting to allocate a new transaction ID.

advisory wait event (Lock) — PostgreSQL

PostgreSQL Lock wait event advisory: Waiting to acquire an advisory user lock.

applytransaction wait event (Lock) — PostgreSQL

PostgreSQL Lock wait event applytransaction: Waiting to acquire a lock on a remote transaction being applied by a logical replication…

extend wait event (Lock) — PostgreSQL

PostgreSQL Lock wait event extend: Waiting to extend a relation.