Search PostgreSQL documentation
PG 18 · Browse by category, or enter a name or keyword
Category index302
DsmFillZeroWriteDsmFillZeroWrite
IO
10
Waiting to write zero bytes to a dynamic shared memory backing file.
11
12
13
Waiting to fill a dynamic shared memory backing file with zeroes.
14
15
16
17
18
19
20
Th…Wait Events · IO
DSMRegistryDSMRegistry
LWLock
17
Waiting to read or update the dynamic shared memory registry.
18
19
20
A brief sample is normal around short internal critical sections.
Investigate when the same tranc…Wait Events · LWLock
DSMRegistryDSADSMRegistryDSA
LWLock
17
Waiting to access dynamic shared memory registry's dynamic shared memory allocator.
18
19
20
A brief sample is normal around short internal critical sections.
Invest…Wait Events · LWLock
DSMRegistryHashDSMRegistryHash
LWLock
17
Waiting to access dynamic shared memory registry's shared hash table.
18
19
20
A brief sample is normal around short internal critical sections.
Investigate when th…Wait Events · LWLock
DynamicSharedMemoryControlDynamicSharedMemoryControl
LWLock
10
Waiting to read or update dynamic shared memory state.
11
12
13
Waiting to read or update dynamic shared memory allocation information.
14
15
16
17
18
19…Wait Events · LWLock
ExecuteGatherExecuteGather
IPC
10
Waiting for activity from child process when executing Gather node.
11
12
13
Waiting for activity from a child process while executing a Gather plan node.
14
15
16
17
18…Wait Events · IPC
extendextend
Lock
10
Waiting to extend 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-facing wait bre…Wait Events · Lock
ExtensionExtension
10
Waiting in an extension.
11
12
13
14
15
16
17
18
19
20
Normality depends on the exact extension, version, and operation documented by its author.
Investigate when the custom nam…Wait Events · Extension
frozenidfrozenid
Lock
10
Waiting to update pg_database.datfrozenxid and pg_database.datminmxid.
11
12
13
14
15
16
17
18
19
20
9.6
Sub-second handoff during ordinary writes or planned DDL can be norm…Wait Events · Lock
GssOpenServerGssOpenServer
Client
12
Waiting to read data from the client while establishing the GSSAPI session.
13
Waiting to read data from the client while establishing a GSSAPI session.
14
15
16
17
1…Wait Events · Client
HashBatchAllocateHashBatchAllocate
IPC
11
Waiting for an elected Parallel Hash participant to allocate a hash table.
12
13
14
15
16
17
18
19
20
Brief rendezvous is normal when every participant continues to …Wait Events · IPC
HashBatchElectHashBatchElect
IPC
11
Electing a Parallel Hash participant to allocate a hash table.
12
13
Waiting to elect a Parallel Hash participant to allocate a hash table.
14
15
16
17
18
19
20
Brief r…Wait Events · IPC
HashBatchLoadHashBatchLoad
IPC
11
Waiting for other Parallel Hash participants to finish loading a hash table.
12
13
14
15
16
17
18
19
20
Brief rendezvous is normal when every participant continues to ad…Wait Events · IPC
HashBuildAllocateHashBuildAllocate
IPC
11
Waiting for an elected Parallel Hash participant to allocate the initial hash table.
12
13
14
15
16
17
18
19
20
Brief rendezvous is normal when every participant con…Wait Events · IPC
HashBuildElectHashBuildElect
IPC
11
Electing a Parallel Hash participant to allocate the initial hash table.
12
13
Waiting to elect a Parallel Hash participant to allocate the initial hash table.
14
15
16…Wait Events · IPC
HashBuildHashInnerHashBuildHashInner
IPC
11
Waiting for other Parallel Hash participants to finish hashing the inner relation.
12
13
14
15
16
17
18
19
20
Brief rendezvous is normal when every participant cont…Wait Events · IPC
HashBuildHashOuterHashBuildHashOuter
IPC
11
Waiting for other Parallel Hash participants to finish partitioning the outer relation.
12
13
14
15
16
17
18
19
20
Brief rendezvous is normal when every participant…Wait Events · IPC
HashGrowBatchesDecideHashGrowBatchesDecide
IPC
11
Electing a Parallel Hash participant to decide on future batch growth.
12
13
Waiting to elect a Parallel Hash participant to decide on future batch growth.
14
15…Wait Events · IPC
HashGrowBatchesElectHashGrowBatchesElect
IPC
11
Electing a Parallel Hash participant to allocate more batches.
12
13
Waiting to elect a Parallel Hash participant to allocate more batches.
14
15
16
17
18
19
20
B…Wait Events · IPC
HashGrowBatchesFinishHashGrowBatchesFinish
IPC
11
Waiting for an elected Parallel Hash participant to decide on future batch growth.
12
13
14
15
16
17
18
19
20
Brief rendezvous is normal when every participant c…Wait Events · IPC
HashGrowBatchesReallocateHashGrowBatchesReallocate
IPC
11
Waiting for an elected Parallel Hash participant to allocate more batches.
12
13
14
15
16
17
18
19
20
Brief rendezvous is normal when every participant conti…Wait Events · IPC
HashGrowBatchesRepartitionHashGrowBatchesRepartition
IPC
11
Waiting for other Parallel Hash participants to finishing repartitioning.
12
13
Waiting for other Parallel Hash participants to finish repartitioning.
14
15…Wait Events · IPC
HashGrowBucketsElectHashGrowBucketsElect
IPC
11
Electing a Parallel Hash participant to allocate more buckets.
12
13
Waiting to elect a Parallel Hash participant to allocate more buckets.
14
15
16
17
18
19
20
B…Wait Events · IPC
HashGrowBucketsReallocateHashGrowBucketsReallocate
IPC
11
Waiting for an elected Parallel Hash participant to finish allocating more buckets.
12
13
14
15
16
17
18
19
20
Brief rendezvous is normal when every particip…Wait Events · IPC
HashGrowBucketsReinsertHashGrowBucketsReinsert
IPC
11
Waiting for other Parallel Hash participants to finish inserting tuples into new buckets.
12
13
14
15
16
17
18
19
20
Brief rendezvous is normal when every part…Wait Events · IPC
InjectionPointInjectionPoint
LWLock
17
Waiting to read or update information related to injection points.
18
19
20
A brief sample is normal around short internal critical sections.
Investigate when the sa…Wait Events · LWLock
IoWorkerMainIoWorkerMain
Activity
18
Waiting in main loop of IO Worker process.
19
20
This is normally expected idleness for the matching background process.
Investigate only when queued work or a shutd…Wait Events · Activity
LibpqwalreceiverConnectLibpqwalreceiverConnect
Client
10
Waiting in WAL receiver to establish connection to remote server.
11
12
13
14
15
16
17
18
19
20
Idle ClientRead sessions are normal connection-pool inventor…Wait Events · Client
LibpqwalreceiverReceiveLibpqwalreceiverReceive
Client
10
Waiting in WAL receiver to receive data from remote server.
11
12
13
14
15
16
17
18
19
20
Idle ClientRead sessions are normal connection-pool inventory.
Inv…Wait Events · Client
LockFastPathLockFastPath
LWLock
10
Waiting to read or update the fast-path lock information.
11
12
13
Waiting to read or update a process' fast-path lock information.
14
15
16
17
18
19
20
9.6
A brief sa…Wait Events · LWLock
LockFileAddtodatadirReadLockFileAddtodatadirRead
IO
10
Waiting for a read while adding a line to the data directory lock file.
11
12
13
14
15
16
17
18
19
20
The wait is normal when the workload is expected to perfo…Wait Events · IO
LockFileAddtodatadirSyncLockFileAddtodatadirSync
IO
10
Waiting for data to reach durable storage while adding a line to the data directory lock file.
11
12
13
14
15
16
17
18
19
20
The wait is normal when the worklo…Wait Events · IO
LockFileAddtodatadirWriteLockFileAddtodatadirWrite
IO
10
Waiting for a write while adding a line to the data directory lock file.
11
12
13
14
15
16
17
18
19
20
The wait is normal when the workload is expected to per…Wait Events · IO
LockFileCreateReadLockFileCreateRead
IO
10
Waiting to read while creating the data directory lock file.
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
LockFileCreateSyncLockFileCreateSync
IO
10
Waiting for data to reach durable storage while creating the data directory lock file.
11
12
13
14
15
16
17
18
19
20
The wait is normal when the workload is expected…Wait Events · IO
LockFileCreateWriteLockFileCreateWrite
IO
10
Waiting for a write while creating the data directory lock file.
11
12
13
14
15
16
17
18
19
20
The wait is normal when the workload is expected to perform this read…Wait Events · IO
LockFileRecheckdatadirReadLockFileRecheckdatadirRead
IO
10
Waiting for a read during recheck of the data directory lock file.
11
12
13
14
15
16
17
18
19
20
The wait is normal when the workload is expected to perform …Wait Events · IO
LockManagerLockManager
LWLock
10
Waiting to add or examine locks for backends, or waiting to join or exit a locking group (used by parallel query).
11
12
13
Waiting to read or update information about …Wait Events · LWLock
LogicalApplyMainLogicalApplyMain
Activity
10
Waiting in main loop of logical apply process.
11
12
13
Waiting in main loop of logical replication apply process.
14
15
16
17
18
19
20
This is normally expected…Wait Events · Activity
LogicalApplySendDataLogicalApplySendData
IPC
16
Waiting for a logical replication leader apply process to send data to a parallel apply process.
17
18
19
20
Brief rendezvous is normal when every participant con…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