Archives: Wait Events

SInvalRead wait event (LWLock) — PostgreSQL

PostgreSQL LWLock wait event SInvalRead: Waiting to retrieve messages from the shared catalog invalidation queue.

SInvalWrite wait event (LWLock) — PostgreSQL

PostgreSQL LWLock wait event SInvalWrite: Waiting to add a message to the shared catalog invalidation queue.

SerialBuffer wait event (LWLock) — PostgreSQL

PostgreSQL LWLock wait event SerialBuffer: Waiting for I/O on a serializable transaction conflict SLRU buffer.

SerialControl wait event (LWLock) — PostgreSQL

PostgreSQL LWLock wait event SerialControl: Waiting to read or update shared pg_serial state.

SerialSLRU wait event (LWLock) — PostgreSQL

PostgreSQL LWLock wait event SerialSLRU: Waiting to access the serializable transaction conflict SLRU cache.

SerializableFinishedList wait event (LWLock) — PostgreSQL

PostgreSQL LWLock wait event SerializableFinishedList: Waiting to access the list of finished serializable transactions.

SerializablePredicateList wait event (LWLock) — PostgreSQL

PostgreSQL LWLock wait event SerializablePredicateList: Waiting to access the list of predicate locks held by serializable transactions.

SerializableXactHash wait event (LWLock) — PostgreSQL

PostgreSQL LWLock wait event SerializableXactHash: Waiting to read or update information about serializable transactions.

SharedTidBitmap wait event (LWLock) — PostgreSQL

PostgreSQL LWLock wait event SharedTidBitmap: Waiting to access a shared TID bitmap during a parallel bitmap index scan.

SharedTupleStore wait event (LWLock) — PostgreSQL

PostgreSQL LWLock wait event SharedTupleStore: Waiting to access a shared tuple store during parallel query.