Search PostgreSQL documentation
PG 18 · Browse by category, or enter a name or keyword
Category index302
ParallelBitmapScanParallelBitmapScan
IPC
10
Waiting for parallel bitmap scan to become initialized.
11
12
13
14
15
16
17
18
19
20
Brief rendezvous is normal when every participant continues to advance.
Invest…Wait Events · IPC
ParallelBtreeScanParallelBtreeScan
LWLock
18
Waiting to synchronize workers during Parallel B-tree scan plan execution.
19
20
A brief sample is normal around short internal critical sections.
Investigate whe…Wait Events · LWLock
ParallelCreateIndexScanParallelCreateIndexScan
IPC
11
Waiting for parallel CREATE INDEX workers to finish heap scan.
12
13
14
15
16
17
18
19
20
Brief rendezvous is normal when every participant continues to advanc…Wait Events · IPC
ParallelFinishParallelFinish
IPC
10
Waiting for parallel workers to finish computing.
11
12
13
14
15
16
17
18
19
20
Brief rendezvous is normal when every participant continues to advance.
Investigate when…Wait Events · IPC
ParallelHashJoinParallelHashJoin
LWLock
11
Waiting to allocate or exchange a chunk of memory or update counters during Parallel Hash plan execution.
12
13
Waiting to synchronize workers during Parallel Hash…Wait Events · LWLock
ParallelQueryDSAParallelQueryDSA
LWLock
10
Waiting for parallel query dynamic shared memory allocation lock.
11
12
13
Waiting for parallel query dynamic shared memory allocation.
14
15
16
17
18
19
20
A brie…Wait Events · LWLock
ParallelVacuumDSAParallelVacuumDSA
LWLock
17
Waiting for parallel vacuum dynamic shared memory allocation.
18
19
20
A brief sample is normal around short internal critical sections.
Investigate when the same…Wait Events · LWLock
PerSessionDSAPerSessionDSA
LWLock
13
Waiting for parallel query dynamic shared memory allocation.
14
15
16
17
18
19
20
A brief sample is normal around short internal critical sections.
Investigate when t…Wait Events · LWLock
PerSessionRecordTypePerSessionRecordType
LWLock
13
Waiting to access a parallel query's information about composite types.
14
15
16
17
18
19
20
A brief sample is normal around short internal critical sections.
…Wait Events · LWLock
PerSessionRecordTypmodPerSessionRecordTypmod
LWLock
13
Waiting to access a parallel query's information about type modifiers that identify anonymous record types.
14
15
16
17
18
19
20
A brief sample is normal aro…Wait Events · LWLock
PerXactPredicateListPerXactPredicateList
LWLock
12
Waiting to perform an operation on a serializable transaction in a parallel query.
13
Waiting to access the list of predicate locks held by the current seriali…Wait Events · LWLock
PgSleepPgSleep
Timeout
10
Waiting in process that called pg_sleep.
11
12
13
Waiting due to a call to pg_sleep or a sibling function.
14
15
16
17
18
19
20
The wait is normal when the configured poli…Wait Events · Timeout
PgStatMainPgStatMain
Activity
10
Waiting in main loop of the statistics collector process.
11
12
13
Waiting in main loop of statistics collector process.
14
This is normally expected idleness for the …Wait Events · Activity
PgStatsDataPgStatsData
LWLock
15
Waiting for shared memory stats data access
16
17
Waiting for shared memory stats data access.
18
19
20
A brief sample is normal around short internal critical sections…Wait Events · LWLock
PgStatsDSAPgStatsDSA
LWLock
15
Waiting for stats dynamic shared memory allocator access
16
17
Waiting for stats dynamic shared memory allocator access.
18
19
20
A brief sample is normal around short i…Wait Events · LWLock
PgStatsHashPgStatsHash
LWLock
15
Waiting for stats shared memory hash table access
16
17
Waiting for stats shared memory hash table access.
18
19
20
A brief sample is normal around short internal criti…Wait Events · LWLock
PredicateLockManagerPredicateLockManager
LWLock
10
Waiting to add or examine predicate lock information.
11
12
13
Waiting to access predicate lock information used by serializable transactions.
14
15
16
17
18
1…Wait Events · LWLock
ProcArrayProcArray
LWLock
10
Waiting to get a snapshot or clearing a transaction id at transaction end.
11
12
13
Waiting to access the shared per-process data structures (typically, to get a snapshot…Wait Events · LWLock
ProcarrayGroupUpdateProcarrayGroupUpdate
IPC
10
Waiting for group leader to clear transaction id at transaction end.
11
12
13
Waiting for the group leader to clear the transaction ID at transaction end.
14
15
1…Wait Events · IPC
ProcSignalBarrierProcSignalBarrier
IPC
13
Waiting for a barrier event to be processed by all backends.
14
15
16
17
18
19
20
Brief rendezvous is normal when every participant continues to advance.
Investigate…Wait Events · IPC
PromotePromote
IPC
12
Waiting for standby promotion.
13
14
15
16
17
18
19
20
Brief rendezvous is normal when every participant continues to advance.
Investigate when the same phase persists across …Wait Events · IPC
RecoveryApplyDelayRecoveryApplyDelay
Timeout
10
Waiting to apply WAL at recovery because it is delayed.
11
12
13
Waiting to apply WAL during recovery because of a delay setting.
14
15
16
17
18
19
20
The wait …Wait Events · Timeout
RecoveryConflictSnapshotRecoveryConflictSnapshot
IPC
13
Waiting for recovery conflict resolution for a vacuum cleanup.
14
15
16
17
18
19
20
Brief rendezvous is normal when every participant continues to advance.
In…Wait Events · IPC
RecoveryConflictTablespaceRecoveryConflictTablespace
IPC
13
Waiting for recovery conflict resolution for dropping a tablespace.
14
15
16
17
18
19
20
Brief rendezvous is normal when every participant continues to adva…Wait Events · IPC
RecoveryEndCommandRecoveryEndCommand
IPC
15
Waiting for recovery_end_command to complete.
16
17
18
19
20
Brief rendezvous is normal when every participant continues to advance.
Investigate when the same phase…Wait Events · IPC
RecoveryPauseRecoveryPause
IPC
13
Waiting for recovery to be resumed.
14
15
16
17
18
19
20
Brief rendezvous is normal when every participant continues to advance.
Investigate when the same phase persists…Wait Events · IPC
RecoveryRetrieveRetryIntervalRecoveryRetrieveRetryInterval
Timeout
13
Waiting during recovery when WAL data is not available from any source (pg_wal, archive or stream).
14
15
16
17
18
19
20
The wait is normal when the …Wait Events · Timeout
RecoveryWalAllRecoveryWalAll
Activity
10
Waiting for WAL from a stream at recovery.
11
12Wait Events · Activity
RecoveryWalStreamRecoveryWalStream
Activity
10
Waiting when WAL data is not available from any kind of sources (local, archive or stream) before trying again to retrieve WAL data, at recovery.
11
12
13
Waiti…Wait Events · Activity
RegisterSyncRequestRegisterSyncRequest
Timeout
12
Waiting while sending synchronization requests to the checkpointer, because the request queue is full.
13
14
15
16
17
18
19
20
The wait is normal when the conf…Wait Events · Timeout
relationrelation
Lock
10
Waiting to acquire a lock on a relation.
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 a user-fa…Wait Events · Lock
RelationMappingRelationMapping
LWLock
10
Waiting to update the relation map file used to store catalog to filenode mapping.
11
12
13
Waiting to read or update a pg_filenode.map file (used to track the file…Wait Events · LWLock
RelationMapReadRelationMapRead
IO
10
Waiting for a read of the relation map 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, sync, allocatio…Wait Events · IO
RelationMapReplaceRelationMapReplace
IO
16
Waiting for durable replacement of a relation map file.
17
18
19
20
The wait is normal when the workload is expected to perform this read, write, sync, allocation, o…Wait Events · IO
RelationMapSyncRelationMapSync
IO
10
Waiting for the relation map file to reach durable storage.
11
12
13
14
15
The wait is normal when the workload is expected to perform this read, write, sync, allocatio…Wait Events · IO
RelationMapWriteRelationMapWrite
IO
10
Waiting for a write to the relation map 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, sync, allocat…Wait Events · IO
RelCacheInitRelCacheInit
LWLock
10
Waiting to read or write relation cache initialization file.
11
12
13
Waiting to read or update a pg_internal.init relation cache initialization file.
14
15
16
17
18
1…Wait Events · LWLock
ReorderBufferReadReorderBufferRead
IO
10
Waiting for a read during reorder buffer management.
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,…Wait Events · IO
ReorderBufferWriteReorderBufferWrite
IO
10
Waiting for a write during reorder buffer management.
11
12
13
14
15
16
17
18
19
20
The wait is normal when the workload is expected to perform this read, write, syn…Wait Events · IO
ReorderLogicalMappingReadReorderLogicalMappingRead
IO
10
Waiting for a read of a logical mapping during reorder buffer management.
11
12
13
14
15
16
17
18
19
20
The wait is normal when the workload is expected to pe…Wait Events · IO
More results
Find definitions in the PostgreSQL manuals, reference library, and extension catalogue.
pg17: choose a version ex: extensions only ↑↓ select ↵ open