Search PostgreSQL documentation
PG 18 · Browse by category, or enter a name or keyword
Category index302
SyncRepSyncRep
LWLock
10
Waiting to read or update information about synchronous replicas.
11
12
13
Waiting to read or update information about the state of synchronous replication.
14
15
16
17
18
…Wait Events · LWLock
SyncScanSyncScan
LWLock
10
Waiting to get the start location of a scan on a table for synchronized scans.
11
12
13
Waiting to select the starting location of a synchronized table scan.
14
15
16
17
1…Wait Events · LWLock
SysloggerMainSysloggerMain
Activity
10
Waiting in main loop of syslogger process.
11
12
13
14
15
16
17
18
19
20
This is normally expected idleness for the matching background process.
Investigate only wh…Wait Events · Activity
TablespaceCreateTablespaceCreate
LWLock
10
Waiting to create or drop the tablespace.
11
12
13
Waiting to create or drop a tablespace.
14
15
16
17
18
19
20
9.6
A brief sample is normal around short internal …Wait Events · LWLock
TimelineHistoryFileSyncTimelineHistoryFileSync
IO
10
Waiting for a timeline history file received via streaming replication to reach durable storage.
11
12
13
14
15
16
17
18
19
20
The wait is normal when the workl…Wait Events · IO
TimelineHistoryFileWriteTimelineHistoryFileWrite
IO
10
Waiting for a write of a timeline history file received via streaming replication.
11
12
13
14
15
16
17
18
19
20
The wait is normal when the workload is expect…Wait Events · IO
TimelineHistoryReadTimelineHistoryRead
IO
10
Waiting for a read of a timeline history 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, all…Wait Events · IO
TimelineHistorySyncTimelineHistorySync
IO
10
Waiting for a newly created timeline history 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 perfor…Wait Events · IO
TimelineHistoryWriteTimelineHistoryWrite
IO
10
Waiting for a write of a newly created timeline history 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
transactionidtransactionid
Lock
10
Waiting for a transaction to finish.
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-f…Wait Events · Lock
tupletuple
Lock
10
Waiting to acquire a lock on a tuple.
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 w…Wait Events · Lock
TwophaseFileReadTwophaseFileRead
IO
10
Waiting for a read of a two phase state 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
TwophaseFileSyncTwophaseFileSync
IO
10
Waiting for a two phase state 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…Wait Events · IO
TwophaseFileWriteTwophaseFileWrite
IO
10
Waiting for a write of a two phase state 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, alloc…Wait Events · IO
TwoPhaseStateTwoPhaseState
LWLock
10
Waiting to read or update the state of prepared transactions.
11
12
13
14
15
16
17
18
19
20
9.6
A brief sample is normal around short internal critical sections.
Inve…Wait Events · LWLock
userlockuserlock
Lock
10
Waiting to acquire a user lock.
11
12
13
14
15
16
17
18
19
20
9.6
Waiting to acquire a userlock.
Sub-second handoff during ordinary writes or planned DDL can be normal.
Inve…Wait Events · Lock
VacuumDelayVacuumDelay
Timeout
13
Waiting in a cost-based vacuum delay point.
14
15
16
17
18
19
20
The wait is normal when the configured policy is intentional and useful work advances at the expected …Wait Events · Timeout
VacuumTruncateVacuumTruncate
Timeout
15
Waiting to acquire an exclusive lock to truncate off any empty pages at the end of a table vacuumed.
16
17
18
19
20
The wait is normal when the configured policy is…Wait Events · Timeout
VersionFileSyncVersionFileSync
IO
15
Waiting for the version file to reach durable storage while creating a database.
16
17
18
19
20
The wait is normal when the workload is expected to perform this read, w…Wait Events · IO
VersionFileWriteVersionFileWrite
IO
15
Waiting for the version file to be written while creating a database.
16
17
18
19
20
The wait is normal when the workload is expected to perform this read, write, sync…Wait Events · IO
virtualxidvirtualxid
Lock
10
Waiting to acquire a virtual xid lock.
11
12
13
Waiting to acquire a virtual transaction ID lock.
14
15
16
Waiting to acquire a virtual transaction ID lock; see Section 74…Wait Events · Lock
WaitEventCustomWaitEventCustom
LWLock
17
Waiting to read or update custom wait events information.
18
19
20
A brief sample is normal around short internal critical sections.
Investigate when the same tranc…Wait Events · LWLock
WaitForStandbyConfirmationWaitForStandbyConfirmation
Client
17
Waiting for WAL to be received and flushed by the physical standby.
18
19
20
Idle ClientRead sessions are normal connection-pool inventory.
Investigate a…Wait Events · Client
WaitForWalFlushWaitForWalFlush
IPC
19
Waiting for WAL flush to reach a target LSN on a primary or standby.
20Wait Events · IPC
WaitForWalReplayWaitForWalReplay
IPC
19
Waiting for WAL replay to reach a target LSN on a standby.
20Wait Events · IPC
WaitForWalWriteWaitForWalWrite
IPC
19
Waiting for WAL write to reach a target LSN on a standby.
20Wait Events · IPC
WaitLSNWaitLSN
LWLock
19
Waiting to read or update shared Wait-for-LSN state.
20Wait Events · LWLock
WalBootstrapSyncWalBootstrapSync
IO
10
Waiting for WAL to reach durable storage during bootstrapping.
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
WalBootstrapWriteWalBootstrapWrite
IO
10
Waiting for a write of a WAL page during bootstrapping.
11
12
13
14
15
16
17
18
19
20
The wait is normal when the workload is expected to perform this read, write, sy…Wait Events · IO
WALBufMappingWALBufMapping
LWLock
10
Waiting to replace a page in WAL buffers.
11
12
13
14
15
16
17
18
19
20
9.6
Short waits appear as WAL generation advances through buffer pages.
Sustained contention s…Wait Events · LWLock
WalCopyReadWalCopyRead
IO
10
Waiting for a read when creating a new WAL segment by copying an existing one.
11
12
13
14
15
16
17
18
19
20
The wait is normal when the workload is expected to perform thi…Wait Events · IO
WalCopySyncWalCopySync
IO
10
Waiting a new WAL segment created by copying an existing one to reach durable storage.
11
12
13
Waiting for a new WAL segment created by copying an existing one to reach du…Wait Events · IO
WalCopyWriteWalCopyWrite
IO
10
Waiting for a write when creating a new WAL segment by copying an existing one.
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
WalInitSyncWalInitSync
IO
10
Waiting for a newly initialized WAL 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, writ…Wait Events · IO
WalInitWriteWalInitWrite
IO
10
Waiting for a write while initializing a new WAL 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, al…Wait Events · IO
WALInsertWALInsert
LWLock
10
Waiting to insert WAL into a memory buffer.
11
12
13
Waiting to insert WAL data into a memory buffer.
14
15
16
17
18
19
20
9.6
Transient waits are normal during concurren…Wait Events · LWLock
WalReadWalRead
IO
10
Waiting for a read from a WAL 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 completion …Wait Events · IO
WalReceiverExitWalReceiverExit
IPC
14
Waiting for the WAL receiver to exit.
15
16
17
18
19
20
Brief rendezvous is normal when every participant continues to advance.
Investigate when the same phase persist…Wait Events · IPC
WalReceiverMainWalReceiverMain
Activity
10
Waiting in main loop of WAL receiver process.
11
12
13
14
15
16
17
18
19
20
This is normally expected idleness for the matching background process.
Investigate on…Wait Events · Activity
WalReceiverUpstreamCatchupWalReceiverUpstreamCatchup
IPC
17
Waiting for upstream server WAL flush position to catch up to requested start point.
18
19
20
Brief rendezvous is normal when every participant continues to…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