Search PostgreSQL documentation
PG 18 · Browse by category, or enter a name or keyword
Category index302
RepackWorkerExportRepackWorkerExport
IPC
19
Waiting for decoding worker to export a new output file.
20Wait Events · IPC
ReplicationOriginReplicationOrigin
LWLock
10
Waiting to setup, drop or use replication origin.
11
12
13
Waiting to create, drop or use a replication origin.
14
15
16
17
18
19
20
9.6
A brief sample is normal …Wait Events · LWLock
ReplicationOriginDropReplicationOriginDrop
IPC
10
Waiting for a replication origin to become inactive to be dropped.
11
12
13
Waiting for a replication origin to become inactive so it can be dropped.
14
15
16
17…Wait Events · IPC
ReplicationOriginStateReplicationOriginState
LWLock
10
Waiting to read or update the replication progress.
11
12
13
Waiting to read or update the progress of one replication origin.
14
15
16
17
18
19
20
9.6
A bri…Wait Events · LWLock
ReplicationSlotAllocationReplicationSlotAllocation
LWLock
10
Waiting to allocate or free a replication slot.
11
12
13
14
15
16
17
18
19
20
9.6
A brief sample is normal around short internal critical sections.
Invest…Wait Events · LWLock
ReplicationSlotControlReplicationSlotControl
LWLock
10
Waiting to read or update replication slot state.
11
12
13
14
15
16
17
18
19
20
9.6
A brief sample is normal around short internal critical sections.
Investi…Wait Events · LWLock
ReplicationSlotDropReplicationSlotDrop
IPC
10
Waiting for a replication slot to become inactive to be dropped.
11
12
13
Waiting for a replication slot to become inactive so it can be dropped.
14
15
16
17
18
19…Wait Events · IPC
ReplicationSlotIOReplicationSlotIO
LWLock
10
Waiting for I/O on a replication slot.
11
12
13
14
15
16
17
18
19
20
9.6
A brief sample is normal around short internal critical sections.
Investigate when the sa…Wait Events · LWLock
ReplicationSlotReadReplicationSlotRead
IO
10
Waiting for a read from a replication slot control file.
11
12
13
14
15
16
17
18
19
20
The wait is normal when the workload is expected to perform this read, write,…Wait Events · IO
ReplicationSlotRestoreSyncReplicationSlotRestoreSync
IO
10
Waiting for a replication slot control file to reach durable storage while restoring it to memory.
11
12
13
14
15
16
17
18
19
20
The wait is normal when the …Wait Events · IO
ReplicationSlotSyncReplicationSlotSync
IO
10
Waiting for a replication slot control file to reach durable storage.
11
12
13
14
15
16
17
18
19
20
The wait is normal when the workload is expected to perform this…Wait Events · IO
ReplicationSlotsyncMainReplicationSlotsyncMain
Activity
17
Waiting in main loop of slot sync worker.
18
19
Waiting in main loop of slot synchronization.
20
This is normally expected idleness for the matching backg…Wait Events · Activity
ReplicationSlotsyncShutdownReplicationSlotsyncShutdown
Activity
17
Waiting for slot sync worker to shut down.
18
19
20
This is normally expected idleness for the matching background process.
Investigate only when queu…Wait Events · Activity
ReplicationSlotWriteReplicationSlotWrite
IO
10
Waiting for a write to a replication slot control file.
11
12
13
14
15
16
17
18
19
20
The wait is normal when the workload is expected to perform this read, write,…Wait Events · IO
RestoreCommandRestoreCommand
IPC
15
Waiting for restore_command to complete.
16
17
18
19
20
Brief rendezvous is normal when every participant continues to advance.
Investigate when the same phase persists…Wait Events · IPC
SafeSnapshotSafeSnapshot
IPC
10
Waiting for a snapshot for a READ ONLY DEFERRABLE transaction.
11
12
13
Waiting to obtain a valid snapshot for a READ ONLY DEFERRABLE transaction.
14
15
16
17
18
19
20
Br…Wait Events · IPC
SerialBufferSerialBuffer
LWLock
10
Waiting to I/O on an oldserxid buffer.
11
Waiting for I/O on an oldserxid buffer.
12
13
Waiting for I/O on a serializable transaction conflict SLRU buffer.
14
15
16
17…Wait Events · LWLock
SerialControlSerialControl
LWLock
17
Waiting to read or update shared pg_serial state.
18
19
20
A brief sample is normal around short internal critical sections.
Investigate when the same tranche affects…Wait Events · LWLock
SerializableFinishedListSerializableFinishedList
LWLock
10
Waiting to access the list of finished serializable transactions.
11
12
13
14
15
16
17
18
19
20
9.6
A brief sample is normal around short internal critical…Wait Events · LWLock
SerializablePredicateListSerializablePredicateList
LWLock
10
Waiting to perform an operation on a list of locks held by serializable transactions.
11
12
13
Waiting to access the list of predicate locks held by seria…Wait Events · LWLock
SerializableXactHashSerializableXactHash
LWLock
10
Waiting to retrieve or store information about serializable transactions.
11
12
13
Waiting to read or update information about serializable transactions.
14
15…Wait Events · LWLock
SerialSLRUSerialSLRU
LWLock
10
Waiting to read or record conflicting serializable transactions.
11
12
13
Waiting to access the serializable transaction conflict SLRU cache.
14
15
16
17
18
19
20
9.6
A …Wait Events · LWLock
SharedTidBitmapSharedTidBitmap
LWLock
10
Waiting for TBM shared iterator lock.
11
12
13
Waiting to access a shared TID bitmap during a parallel bitmap index scan.
14
15
16
17
18
19
20
A brief sample is nor…Wait Events · LWLock
SharedTupleStoreSharedTupleStore
LWLock
13
Waiting to access a shared tuple store during parallel query.
14
15
16
17
18
19
20
A brief sample is normal around short internal critical sections.
Investigate wh…Wait Events · LWLock
ShmemIndexShmemIndex
LWLock
10
Waiting to find or allocate space in shared memory.
11
12
13
14
15
16
17
18
19
20
9.6
A brief sample is normal around short internal critical sections.
Investigate when …Wait Events · LWLock
SInvalReadSInvalRead
LWLock
10
Waiting to retrieve or remove messages from shared invalidation queue.
11
12
13
Waiting to retrieve messages from the shared catalog invalidation queue.
14
15
16
17
18
1…Wait Events · LWLock
SInvalWriteSInvalWrite
LWLock
10
Waiting to add a message in shared invalidation queue.
11
12
13
Waiting to add a message to the shared catalog invalidation queue.
14
15
16
17
18
19
20
9.6
A brief samp…Wait Events · LWLock
SlruFlushSyncSlruFlushSync
IO
10
Waiting for SLRU data to reach durable storage during a checkpoint or database shutdown.
11
12
13
14
15
16
17
18
19
20
The wait is normal when the workload is expected to…Wait Events · IO
SlruReadSlruRead
IO
10
Waiting for a read of an SLRU page.
11
12
13
14
15
16
17
18
19
20
The wait is normal when the workload is expected to perform this read, write, sync, allocation, or completion…Wait Events · IO
SlruSyncSlruSync
IO
10
Waiting for SLRU data to reach durable storage following a page write.
11
12
13
14
15
16
17
18
19
20
The wait is normal when the workload is expected to perform this read, wri…Wait Events · IO
SlruWriteSlruWrite
IO
10
Waiting for a write of an SLRU page.
11
12
13
14
15
16
17
18
19
20
The wait is normal when the workload is expected to perform this read, write, sync, allocation, or completi…Wait Events · IO
SnapbuildReadSnapbuildRead
IO
10
Waiting for a read of a serialized historical catalog snapshot.
11
12
13
14
15
16
17
18
19
20
The wait is normal when the workload is expected to perform this read, write…Wait Events · IO
SnapbuildSyncSnapbuildSync
IO
10
Waiting for a serialized historical catalog snapshot to reach durable storage.
11
12
13
14
15
16
17
18
19
20
The wait is normal when the workload is expected to perform t…Wait Events · IO
SnapbuildWriteSnapbuildWrite
IO
10
Waiting for a write of a serialized historical catalog snapshot.
11
12
13
14
15
16
17
18
19
20
The wait is normal when the workload is expected to perform this read, wri…Wait Events · IO
spectokenspectoken
Lock
10
Waiting to acquire a speculative insertion lock.
11
12
13
14
15
16
17
18
19
20
9.6
Sub-second handoff during ordinary writes or planned DDL can be normal.
Investigate once …Wait Events · Lock
SpinDelaySpinDelay
Timeout
16
Waiting while acquiring a contended spinlock.
17
18
19
20
The wait is normal when the configured policy is intentional and useful work advances at the expected rate.
Inv…Wait Events · Timeout
SslOpenServerSslOpenServer
Client
10
Waiting for SSL while attempting connection.
11
12
13
14
15
16
17
18
19
20
Idle ClientRead sessions are normal connection-pool inventory.
Investigate active writes, h…Wait Events · Client
SubtransBufferSubtransBuffer
LWLock
10
Waiting for I/O a subtransaction buffer.
11
12
13
Waiting for I/O on a sub-transaction SLRU buffer.
14
15
16
17
18
19
20
9.6
A brief sample is normal around short in…Wait Events · LWLock
SubtransSLRUSubtransSLRU
LWLock
10
Waiting to read or update sub-transaction information.
11
12
13
Waiting to access the sub-transaction SLRU cache.
14
15
16
17
18
19
20
9.6
A brief sample is normal aro…Wait Events · LWLock
SyncRepSyncRep
IPC
10
Waiting for confirmation from remote server during synchronous replication.
11
12
13
Waiting for confirmation from a remote server during synchronous replication.
14
15
16
17
…Wait Events · IPC
More results
Find definitions in the PostgreSQL manuals, reference library, and extension catalogue.
pg17: choose a version ex: extensions only ↑↓ select ↵ open