Search PostgreSQL documentation
PG 18 · Browse by category, or enter a name or keyword
Category index302
AddinShmemInitAddinShmemInit
LWLock
10
Waiting to manage space allocation in shared memory.
11
12
13
Waiting to manage an extension's space allocation in shared memory.
14
15
16
17
18
19
20
9.6
A brief sa…Wait Events · LWLock
advisoryadvisory
Lock
10
Waiting to acquire an advisory user lock.
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
AioIoCompletionAioIoCompletion
IO
18
Waiting for another process to complete IO.
19
20
The wait is normal when the workload is expected to perform this read, write, sync, allocation, or completion operatio…Wait Events · IO
AioIoUringExecutionAioIoUringExecution
IO
18
Waiting for IO execution via io_uring.
19
20
The wait is normal when the workload is expected to perform this read, write, sync, allocation, or completion operation…Wait Events · IO
AioIoUringSubmitAioIoUringSubmit
IO
18
Waiting for IO submission via io_uring.
19
20
The wait is normal when the workload is expected to perform this read, write, sync, allocation, or completion operation a…Wait Events · IO
AioUringCompletionAioUringCompletion
LWLock
18
Waiting for another process to complete IO via io_uring.
19
20
A brief sample is normal around short internal critical sections.
Investigate when the same tranch…Wait Events · LWLock
AioWorkerControlAioWorkerControl
LWLock
19
Waiting to update AIO worker information.
20Wait Events · LWLock
AioWorkerSubmissionQueueAioWorkerSubmissionQueue
LWLock
18
Waiting to access AIO worker submission queue.
19
20
A brief sample is normal around short internal critical sections.
Investigate when the same tranche af…Wait Events · LWLock
AppendReadyAppendReady
IPC
14
Waiting for subplan nodes of an Append plan node to be ready.
15
16
17
18
19
20
Brief rendezvous is normal when every participant continues to advance.
Investigate when th…Wait Events · IPC
applytransactionapplytransaction
Lock
16
Waiting to acquire a lock on a remote transaction being applied by a logical replication subscriber.
17
18
19
20
Sub-second handoff during ordinary writes or planned…Wait Events · Lock
ArchiveCleanupCommandArchiveCleanupCommand
IPC
15
Waiting for archive_cleanup_command to complete.
16
17
18
19
20
Brief rendezvous is normal when every participant continues to advance.
Investigate when the same…Wait Events · IPC
ArchiveCommandArchiveCommand
IPC
15
Waiting for archive_command to complete.
16
17
18
19
20
Brief rendezvous is normal when every participant continues to advance.
Investigate when the same phase persists…Wait Events · IPC
ArchiverMainArchiverMain
Activity
10
Waiting in main loop of the archiver process.
11
12
13
Waiting in main loop of archiver process.
14
15
16
17
18
19
20
This is normally expected idleness for the matc…Wait Events · Activity
AutoFileAutoFile
LWLock
10
Waiting to update the postgresql.auto.conf file.
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 s…Wait Events · LWLock
AutovacuumAutovacuum
LWLock
10
Autovacuum worker or launcher waiting to update or read the current state of autovacuum workers.
11
12
13
Waiting to read or update the current state of autovacuum worke…Wait Events · LWLock
AutovacuumMainAutovacuumMain
Activity
10
Waiting in main loop of autovacuum launcher process.
11
12
13
14
15
16
17
18
19
20
This is normally expected idleness for the matching background process.
Investig…Wait Events · Activity
AutovacuumScheduleAutovacuumSchedule
LWLock
10
Waiting to ensure that the table it has selected for a vacuum still needs vacuuming.
11
12
13
Waiting to ensure that a table selected for autovacuum still needs …Wait Events · LWLock
BackendRandomLockBackendRandomLock
LWLock
10
Waiting to generate a random number.
11Wait Events · LWLock
BackendTerminationBackendTermination
IPC
14
Waiting for the termination of another backend.
15
16
17
18
19
20
Brief rendezvous is normal when every participant continues to advance.
Investigate when the same …Wait Events · IPC
BackgroundWorkerBackgroundWorker
LWLock
10
Waiting to read or update background worker state.
11
12
13
14
15
16
17
18
19
20
9.6
A brief sample is normal around short internal critical sections.
Investigate …Wait Events · LWLock
BackupWaitWalArchiveBackupWaitWalArchive
IPC
13
Waiting for WAL files required for a backup to be successfully archived.
14
15
16
17
18
19
20
Brief rendezvous is normal when every participant continues to advan…Wait Events · IPC
BasebackupReadBasebackupRead
IO
14
Waiting for base backup to read from a file.
15
16
17
18
19
20
The wait is normal when the workload is expected to perform this read, write, sync, allocation, or complet…Wait Events · IO
BasebackupSyncBasebackupSync
IO
15
Waiting for data written by a base backup to reach durable storage.
16
17
18
19
20
The wait is normal when the workload is expected to perform this read, write, sync, al…Wait Events · IO
BaseBackupThrottleBaseBackupThrottle
Timeout
10
Waiting during base backup when throttling activity.
11
12
13
14
15
16
17
18
19
20
The wait is normal when the configured policy is intentional and useful work …Wait Events · Timeout
BasebackupWriteBasebackupWrite
IO
15
Waiting for base backup to write to a file.
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
BgworkerShutdownBgworkerShutdown
IPC
10
Waiting for background worker to shut down.
11
12
13
14
15
16
17
18
19
20
Brief rendezvous is normal when every participant continues to advance.
Investigate when the…Wait Events · IPC
BgworkerStartupBgworkerStartup
IPC
10
Waiting for background worker to start up.
11
12
13
14
15
16
17
18
19
20
Brief rendezvous is normal when every participant continues to advance.
Investigate when the s…Wait Events · IPC
BgwriterHibernateBgwriterHibernate
Activity
10
Waiting in background writer process, hibernating.
11
12
13
14
15
16
17
18
19
20
This is normally expected idleness for the matching background process.
Investi…Wait Events · Activity
BgwriterMainBgwriterMain
Activity
10
Waiting in main loop of background writer process background worker.
11
12
13
Waiting in main loop of background writer process.
14
15
16
17
18
19
20
This is normall…Wait Events · Activity
BtreePageBtreePage
IPC
10
Waiting for the page number needed to continue a parallel B-tree scan to become available.
11
12
13
14
15
16
17
18
19
20
Brief rendezvous is normal when every participant co…Wait Events · IPC
BtreeVacuumBtreeVacuum
LWLock
10
Waiting to read or update vacuum-related information for a B-tree index.
11
12
13
14
15
16
17
18
19
20
9.6
A brief sample is normal around short internal critical secti…Wait Events · LWLock
BufferCleanupBufferCleanup
Buffer
19
Waiting to acquire an exclusive pin on a buffer. Buffer pin waits can be protracted if another process holds an open cursor that last read data from the buffer in que…Wait Events · Buffer
BufferContentBufferContent
LWLock
10
Waiting to read or write a data page in memory.
11
12
13
Waiting to access a data page in memory.
14
15
16
17
18
9.6
Short samples are routine while concurrent reader…Wait Events · LWLock
BufferExclusiveBufferExclusive
Buffer
19
Waiting to acquire a exclusive lock on a buffer.
20
Waiting to acquire an exclusive lock on a buffer.Wait Events · Buffer
BufferIoBufferIo
IPC
10
Waiting for I/O on a data page.
11
12
13
14
Waiting for buffer I/O to complete.
15
16
17
18
19
20
9.6
Brief rendezvous is normal when every participant continues to advance.
…Wait Events · IPC
BufferMappingBufferMapping
LWLock
10
Waiting to associate a data block with a buffer in the buffer pool.
11
12
13
14
15
16
17
18
19
20
9.6
Brief waits occur when pages enter or leave shared buffers.
Sust…Wait Events · LWLock
BufferPinBufferPin
Buffer
10
Waiting to acquire a pin on a buffer.
11
12
13
Waiting to acquire an exclusive pin on a buffer.
14
15
16
17
18
9.6
An isolated sub-second sample can occur during scans or…Wait Events · Buffer
BufferSharedBufferShared
Buffer
19
Waiting to acquire a shared lock on a buffer.
20Wait Events · Buffer
BufferShareExclusiveBufferShareExclusive
Buffer
19
Waiting to acquire a share exclusive lock on a buffer.
20Wait Events · Buffer
BuffileReadBuffileRead
IO
10
Waiting for a read from 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
More results
Find definitions in the PostgreSQL manuals, reference library, and extension catalogue.
pg17: choose a version ex: extensions only ↑↓ select ↵ open