Search PostgreSQL documentation
PG 18 · Browse by category, or enter a name or keyword
Category index302
LogicalChangesReadLogicalChangesRead
IO
14
Waiting for a read from a logical changes file.
No live core occurrence is expected on the audited release.
If telemetry shows it, verify the exact patch version, ex…Wait Events · IO
LogicalChangesWriteLogicalChangesWrite
IO
14
Waiting for a write to a logical changes file.
No live core occurrence is expected on the audited release.
If telemetry shows it, verify the exact patch version, ex…Wait Events · IO
LogicalDecodingControlLogicalDecodingControl
LWLock
19
Waiting to read or update logical decoding status information.
20Wait Events · LWLock
LogicalLauncherMainLogicalLauncherMain
Activity
10
Waiting in main loop of logical launcher process.
11
12
13
Waiting in main loop of logical replication launcher process.
14
15
16
17
18
19
20
This is normally…Wait Events · Activity
LogicalParallelApplyMainLogicalParallelApplyMain
Activity
16
Waiting in main loop of logical replication parallel apply process.
17
18
19
20
This is normally expected idleness for the matching background process.
I…Wait Events · Activity
LogicalParallelApplyStateChangeLogicalParallelApplyStateChange
IPC
16
Waiting for a logical replication parallel apply process to change state.
17
18
19
20
Brief rendezvous is normal when every participant continues to ad…Wait Events · IPC
LogicalRepLauncherDSALogicalRepLauncherDSA
LWLock
16
Waiting to access logical replication launcher's dynamic shared memory allocator.
17
18
19
20
A brief sample is normal around short internal critical sections…Wait Events · LWLock
LogicalRepLauncherHashLogicalRepLauncherHash
LWLock
16
Waiting to access logical replication launcher's shared hash table.
17
18
19
20
A brief sample is normal around short internal critical sections.
Investigate…Wait Events · LWLock
LogicalRepWorkerLogicalRepWorker
LWLock
10
Waiting for action on logical replication worker to finish.
11
12
13
Waiting to read or update the state of logical replication workers.
14
15
16
17
18
19
20
A bri…Wait Events · LWLock
LogicalRewriteCheckpointSyncLogicalRewriteCheckpointSync
IO
10
Waiting for logical rewrite mappings to reach durable storage during a checkpoint.
11
12
13
14
15
16
17
18
19
20
The wait is normal when the workload is ex…Wait Events · IO
LogicalRewriteMappingSyncLogicalRewriteMappingSync
IO
10
Waiting for mapping data to reach durable storage during a logical rewrite.
11
12
13
14
15
16
17
18
19
20
The wait is normal when the workload is expected to …Wait Events · IO
LogicalRewriteMappingWriteLogicalRewriteMappingWrite
IO
10
Waiting for a write of mapping data during a logical rewrite.
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
LogicalRewriteSyncLogicalRewriteSync
IO
10
Waiting for logical rewrite mappings 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 read, w…Wait Events · IO
LogicalRewriteTruncateLogicalRewriteTruncate
IO
10
Waiting for truncate of mapping data during a logical rewrite.
11
12
13
14
15
16
17
18
19
20
The wait is normal when the workload is expected to perform this rea…Wait Events · IO
LogicalRewriteWriteLogicalRewriteWrite
IO
10
Waiting for a write of logical rewrite mappings.
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, a…Wait Events · IO
LogicalSubxactReadLogicalSubxactRead
IO
14
Waiting for a read from a logical subxact file.
No live core occurrence is expected on the audited release.
If telemetry shows it, verify the exact patch version, ex…Wait Events · IO
LogicalSubxactWriteLogicalSubxactWrite
IO
14
Waiting for a write to a logical subxact file.
No live core occurrence is expected on the audited release.
If telemetry shows it, verify the exact patch version, ex…Wait Events · IO
LogicalSyncDataLogicalSyncData
IPC
10
Waiting for logical replication remote server to send data for initial table synchronization.
11
12
13
Waiting for a logical replication remote server to send data for…Wait Events · IPC
LogicalSyncStateChangeLogicalSyncStateChange
IPC
10
Waiting for logical replication remote server to change state.
11
12
13
Waiting for a logical replication remote server to change state.
14
15
16
17
18
19
20
Br…Wait Events · IPC
MessageQueueInternalMessageQueueInternal
IPC
10
Waiting for other process to be attached in shared message queue.
11
12
13
Waiting for another process to be attached to a shared message queue.
14
15
16
17
18
19…Wait Events · IPC
MessageQueuePutMessageMessageQueuePutMessage
IPC
10
Waiting to write a protocol message to a shared message queue.
11
12
13
14
15
16
17
18
19
20
Brief rendezvous is normal when every participant continues to adva…Wait Events · IPC
MessageQueueReceiveMessageQueueReceive
IPC
10
Waiting to receive bytes from a shared message queue.
11
12
13
14
15
16
17
18
19
20
Brief rendezvous is normal when every participant continues to advance.
Investi…Wait Events · IPC
MessageQueueSendMessageQueueSend
IPC
10
Waiting to send bytes to a shared message queue.
11
12
13
14
15
16
17
18
19
20
Brief rendezvous is normal when every participant continues to advance.
Investigate whe…Wait Events · IPC
MultixactCreationMultixactCreation
IPC
17
Waiting for a multixact creation to complete.
18
19
20
No live core occurrence is expected on the audited release.
If telemetry shows it, verify the exact patch vers…Wait Events · IPC
MultiXactGenMultiXactGen
LWLock
10
Waiting to read or update shared multixact state.
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
MultiXactMemberBufferMultiXactMemberBuffer
LWLock
10
Waiting for I/O on a multixact_member buffer.
11
12
13
Waiting for I/O on a multixact member SLRU buffer.
14
15
16
17
18
19
20
9.6
A brief sample is normal ar…Wait Events · LWLock
MultiXactMemberSLRUMultiXactMemberSLRU
LWLock
10
Waiting to read or update multixact member mappings.
11
12
13
Waiting to access the multixact member SLRU cache.
14
15
16
17
18
19
20
9.6
Brief waits occur in w…Wait Events · LWLock
MultiXactOffsetBufferMultiXactOffsetBuffer
LWLock
10
Waiting for I/O on a multixact offset buffer.
11
12
13
Waiting for I/O on a multixact offset SLRU buffer.
14
15
16
17
18
19
20
9.6
A brief sample is normal ar…Wait Events · LWLock
MultiXactOffsetSLRUMultiXactOffsetSLRU
LWLock
10
Waiting to read or update multixact offset mappings.
11
12
13
Waiting to access the multixact offset SLRU cache.
14
15
16
17
18
19
20
9.6
A brief sample is norm…Wait Events · LWLock
MultiXactTruncationMultiXactTruncation
LWLock
10
Waiting to read or truncate multixact information.
11
12
13
14
15
16
17
18
19
20
9.6
A brief sample is normal around short internal critical sections.
Investiga…Wait Events · LWLock
NotifyBufferNotifyBuffer
LWLock
10
Waiting for I/O on an async (notify) buffer.
11
12
13
Waiting for I/O on a NOTIFY message SLRU buffer.
14
15
16
17
18
19
20
9.6
A brief sample is normal around short i…Wait Events · LWLock
NotifyChannelHashNotifyChannelHash
LWLock
19
Waiting to access the NOTIFY channel hash table.
20Wait Events · LWLock
NotifyQueueNotifyQueue
LWLock
10
Waiting to read or update notification messages.
11
12
13
Waiting to read or update NOTIFY messages.
14
15
16
17
18
19
20
9.6
A brief sample is normal around short inte…Wait Events · LWLock
NotifyQueueTailNotifyQueueTail
LWLock
10
Waiting to update limit on notification message storage.
11
12
13
Waiting to update limit on NOTIFY message storage.
14
15
16
17
18
19
20
9.6
A brief sample is norm…Wait Events · LWLock
NotifySLRUNotifySLRU
LWLock
10
Waiting to read or update shared notification state.
11
12
13
Waiting to access the NOTIFY message SLRU cache.
14
15
16
17
18
19
20
9.6
A brief sample is normal around s…Wait Events · LWLock
objectobject
Lock
10
Waiting to acquire a lock on a non-relation database object.
11
12
13
14
15
16
17
18
19
20
9.6
Sub-second handoff during ordinary writes or planned DDL can be normal.
Investig…Wait Events · Lock
OidGenOidGen
LWLock
10
Waiting to allocate or assign an OID.
11
12
13
Waiting to allocate a new OID.
14
15
16
17
18
19
20
9.6
A brief sample is normal around short internal critical sections.
Inve…Wait Events · LWLock
OldSnapshotTimeMapOldSnapshotTimeMap
LWLock
10
Waiting to read or update old snapshot control information.
11
12
13
14
15
16
9.6
A brief sample is normal around short internal critical sections.
Investigate w…Wait Events · LWLock
pagepage
Lock
10
Waiting to acquire a lock on page of a relation.
11
12
13
Waiting to acquire a lock on a page of a relation.
14
15
16
17
18
19
20
9.6
Sub-second handoff during ordinary writes o…Wait Events · Lock
ParallelAppendParallelAppend
LWLock
11
Waiting to choose the next subplan during Parallel Append plan execution.
12
13
14
15
16
17
18
19
20
A brief sample is normal around short internal critical sections…Wait Events · LWLock
More results
Find definitions in the PostgreSQL manuals, reference library, and extension catalogue.
pg17: choose a version ex: extensions only ↑↓ select ↵ open