Search PostgreSQL documentation
PG 18 · Browse by category, or enter a name or keyword
Category index302
BuffileTruncateBuffileTruncate
IO
14
Waiting for a buffered file to be truncated.
15
16
17
18
19
20
The wait is normal when the workload is expected to perform this read, write, sync, allocation, or comple…Wait Events · IO
BuffileWriteBuffileWrite
IO
10
Waiting for a write to a buffered 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, allocation, or co…Wait Events · IO
CheckpointCheckpoint
LWLock
10
Waiting to perform checkpoint.
11
12
13
Waiting to begin a checkpoint.
9.6
A brief sample is normal around short internal critical sections.
Investigate when the same tr…Wait Events · LWLock
CheckpointDelayCompleteCheckpointDelayComplete
IPC
17
Waiting for a backend that blocks a checkpoint from completing.
18
19
20
Brief rendezvous is normal when every participant continues to advance.
Investigate wh…Wait Events · IPC
CheckpointDelayStartCheckpointDelayStart
IPC
17
Waiting for a backend that blocks a checkpoint from starting.
18
19
20
Brief rendezvous is normal when every participant continues to advance.
Investigate when th…Wait Events · IPC
CheckpointDoneCheckpointDone
IPC
12
Waiting for a checkpoint to complete.
13
14
15
16
17
18
19
20
Brief rendezvous is normal when every participant continues to advance.
Investigate when the same phase pe…Wait Events · IPC
CheckpointerCommCheckpointerComm
LWLock
10
Waiting to manage fsync requests.
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 same tra…Wait Events · LWLock
CheckpointerMainCheckpointerMain
Activity
10
Waiting in main loop of checkpointer process.
11
12
13
14
15
16
17
18
19
20
This is normally expected idleness for the matching background process.
Investigate o…Wait Events · Activity
CheckpointerShutdownCheckpointerShutdown
Activity
18
Waiting for checkpointer process to be terminated.
19
20
This is normally expected idleness for the matching background process.
Investigate only when queued…Wait Events · Activity
CheckpointStartCheckpointStart
IPC
12
Waiting for a checkpoint to start.
13
14
15
16
17
18
19
20
Brief rendezvous is normal when every participant continues to advance.
Investigate when the same phase pers…Wait Events · IPC
CheckpointWriteDelayCheckpointWriteDelay
Timeout
14
Waiting between writes while performing a checkpoint.
15
16
17
18
19
20
The wait is normal when the configured policy is intentional and useful work advances …Wait Events · Timeout
ChecksumEnableStartconditionChecksumEnableStartcondition
IPC
19
Waiting for data checksums enabling to start.
20Wait Events · IPC
ChecksumEnableTemptableWaitChecksumEnableTemptableWait
IPC
19
Waiting for temporary tables to be dropped for data checksums to be enabled.
20Wait Events · IPC
ClientReadClientRead
Client
10
Waiting to read data from the client.
11
12
13
14
15
16
17
18
19
20
Idle ClientRead sessions are normal connection-pool inventory.
Investigate active writes, handshakes,…Wait Events · Client
ClientWriteClientWrite
Client
10
Waiting to write data to the client.
11
12
13
14
15
16
17
18
19
20
Idle ClientRead sessions are normal connection-pool inventory.
Investigate active writes, handshakes,…Wait Events · Client
CommitDelayCommitDelay
Timeout
19
Waiting for commit delay before WAL flush.
20Wait Events · Timeout
CommitTsCommitTs
LWLock
10
Waiting to read or update the last value set for the transaction timestamp.
11
12
13
Waiting to read or update the last value set for a transaction commit timestamp.
14
15…Wait Events · LWLock
CommitTsBufferCommitTsBuffer
LWLock
10
Waiting for I/O on commit timestamp buffer.
11
12
13
Waiting for I/O on a commit timestamp SLRU buffer.
14
15
16
17
18
19
20
9.6
A brief sample is normal around shor…Wait Events · LWLock
CommitTsSLRUCommitTsSLRU
LWLock
10
Waiting to read or update transaction commit timestamps.
11
12
13
Waiting to access the commit timestamp SLRU cache.
14
15
16
17
18
19
20
9.6
A brief sample is normal …Wait Events · LWLock
ControlFileControlFile
LWLock
10
Waiting to read or update the control file or creation of a new WAL file.
11
12
13
Waiting to read or update the pg_control file or create a new WAL file.
14
15
16
17
1…Wait Events · LWLock
ControlFileReadControlFileRead
IO
10
Waiting for a read from the control file.
11
12
13
Waiting for a read from the pg_control file.
14
15
16
17
18
19
20
The wait is normal when the workload is expected to…Wait Events · IO
ControlFileSyncControlFileSync
IO
10
Waiting for the control file to reach durable storage.
11
12
13
Waiting for the pg_control file to reach durable storage.
14
15
16
17
18
19
20
The wait is normal when t…Wait Events · IO
ControlFileSyncUpdateControlFileSyncUpdate
IO
10
Waiting for an update to the control file to reach durable storage.
11
12
13
Waiting for an update to the pg_control file to reach durable storage.
14
15
16
17
18…Wait Events · IO
ControlFileWriteControlFileWrite
IO
10
Waiting for a write to the control file.
11
12
13
Waiting for a write to the pg_control file.
14
15
16
17
18
19
20
The wait is normal when the workload is expected to …Wait Events · IO
ControlFileWriteUpdateControlFileWriteUpdate
IO
10
Waiting for a write to update the control file.
11
12
13
Waiting for a write to update the pg_control file.
14
15
16
17
18
19
20
The wait is normal when the work…Wait Events · IO
CopyFileCopyCopyFileCopy
IO
18
Waiting for a file copy operation.
19
20
The wait is normal when the workload is expected to perform this read, write, sync, allocation, or completion operation at the obs…Wait Events · IO
CopyFileReadCopyFileRead
IO
10
Waiting for a read during a file copy operation.
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, allocati…Wait Events · IO
CopyFileWriteCopyFileWrite
IO
10
Waiting for a write during a file copy operation.
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, alloca…Wait Events · IO
CopyFromReadCopyFromRead
IO
19
Waiting to read data from a pipe, a file or a program during COPY FROM.
20Wait Events · IO
CopyToWriteCopyToWrite
IO
19
Waiting to write data to a pipe, a file or a program during COPY TO.
20Wait Events · IO
DataChecksumsWorkerDataChecksumsWorker
LWLock
19
Waiting for data checksums worker.
20Wait Events · LWLock
DataFileExtendDataFileExtend
IO
10
Waiting for a relation data file to be extended.
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, alloca…Wait Events · IO
DataFileFlushDataFileFlush
IO
10
Waiting for a relation data 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 read, write, syn…Wait Events · IO
DataFileImmediateSyncDataFileImmediateSync
IO
10
Waiting for an immediate synchronization of a relation data file to durable storage.
11
12
13
14
15
16
17
18
19
20
The wait is normal when the workload is expecte…Wait Events · IO
DataFilePrefetchDataFilePrefetch
IO
10
Waiting for an asynchronous prefetch from a relation data file.
11
12
13
14
15
16
17
18
19
20
The wait is normal when the workload is expected to perform this read, wr…Wait Events · IO
DataFileReadDataFileRead
IO
10
Waiting for a read from a relation data 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, allocation,…Wait Events · IO
DataFileSyncDataFileSync
IO
10
Waiting for changes to a relation data 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 read, …Wait Events · IO
DataFileTruncateDataFileTruncate
IO
10
Waiting for a relation data file to be truncated.
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, all…Wait Events · IO
DataFileWriteDataFileWrite
IO
10
Waiting for a write to a relation data 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, allocation,…Wait Events · IO
DsmAllocateDsmAllocate
IO
16
Waiting for a dynamic shared memory segment to be allocated.
17
18
19
20
The wait is normal when the workload is expected to perform this read, write, sync, allocation, or …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