WAIT EVENTS / VERSION COMPARISON
What changed?
Wait Events · PostgreSQL 16 → 17
20 added · 1 removed · 45 changed · 0 coverage changes. These are changes in the pinned reference snapshots.
changedAutovacuumMain
--- 16 +++ 17 @@ -1,2 +1,2 @@ -Activity/AutoVacuumMain +Activity/AutovacuumMain Waiting in main loop of autovacuum launcher process.
changedBgwriterHibernate
--- 16 +++ 17 @@ -1,2 +1,2 @@ -Activity/BgWriterHibernate +Activity/BgwriterHibernate Waiting in background writer process, hibernating.
changedBgwriterMain
--- 16 +++ 17 @@ -1,2 +1,2 @@ -Activity/BgWriterMain +Activity/BgwriterMain Waiting in main loop of background writer process.
addedReplicationSlotsyncMain
--- 16 +++ 17 @@ -0,0 +1,2 @@ +Activity/ReplicationSlotsyncMain +Waiting in main loop of slot sync worker.
addedReplicationSlotsyncShutdown
--- 16 +++ 17 @@ -0,0 +1,2 @@ +Activity/ReplicationSlotsyncShutdown +Waiting for slot sync worker to shut down.
changedSysloggerMain
--- 16 +++ 17 @@ -1,2 +1,2 @@ -Activity/SysLoggerMain +Activity/SysloggerMain Waiting in main loop of syslogger process.
addedWalSummarizerWal
--- 16 +++ 17 @@ -0,0 +1,2 @@ +Activity/WalSummarizerWal +Waiting in WAL summarizer for more WAL to be generated.
changedGssOpenServer
--- 16 +++ 17 @@ -1,2 +1,2 @@ -Client/GSSOpenServer +Client/GssOpenServer Waiting to read data from the client while establishing a GSSAPI session.
changedLibpqwalreceiverConnect
--- 16 +++ 17 @@ -1,2 +1,2 @@ -Client/LibPQWalReceiverConnect +Client/LibpqwalreceiverConnect Waiting in WAL receiver to establish connection to remote server.
changedLibpqwalreceiverReceive
--- 16 +++ 17 @@ -1,2 +1,2 @@ -Client/LibPQWalReceiverReceive +Client/LibpqwalreceiverReceive Waiting in WAL receiver to receive data from remote server.
changedSslOpenServer
--- 16 +++ 17 @@ -1,2 +1,2 @@ -Client/SSLOpenServer +Client/SslOpenServer Waiting for SSL while attempting connection.
addedWaitForStandbyConfirmation
--- 16 +++ 17 @@ -0,0 +1,2 @@ +Client/WaitForStandbyConfirmation +Waiting for WAL to be received and flushed by the physical standby.
changedWalSenderWaitForWal
--- 16 +++ 17 @@ -1,2 +1,2 @@ -Client/WalSenderWaitForWAL +Client/WalSenderWaitForWal Waiting for WAL to be flushed in WAL sender process.
changedBasebackupRead
--- 16 +++ 17 @@ -1,2 +1,2 @@ -IO/BaseBackupRead +IO/BasebackupRead Waiting for base backup to read from a file.
changedBasebackupSync
--- 16 +++ 17 @@ -1,2 +1,2 @@ -IO/BaseBackupSync +IO/BasebackupSync Waiting for data written by a base backup to reach durable storage.
changedBasebackupWrite
--- 16 +++ 17 @@ -1,2 +1,2 @@ -IO/BaseBackupWrite +IO/BasebackupWrite Waiting for base backup to write to a file.
changedBuffileRead
--- 16 +++ 17 @@ -1,2 +1,2 @@ -IO/BufFileRead +IO/BuffileRead Waiting for a read from a buffered file.
changedBuffileTruncate
--- 16 +++ 17 @@ -1,2 +1,2 @@ -IO/BufFileTruncate +IO/BuffileTruncate Waiting for a buffered file to be truncated.
changedBuffileWrite
--- 16 +++ 17 @@ -1,2 +1,2 @@ -IO/BufFileWrite +IO/BuffileWrite Waiting for a write to a buffered file.
changedDsmAllocate
--- 16 +++ 17 @@ -1,2 +1,2 @@ -IO/DSMAllocate +IO/DsmAllocate Waiting for a dynamic shared memory segment to be allocated.
changedDsmFillZeroWrite
--- 16 +++ 17 @@ -1,2 +1,2 @@ -IO/DSMFillZeroWrite +IO/DsmFillZeroWrite Waiting to fill a dynamic shared memory backing file with zeroes.
changedLockFileAddtodatadirRead
--- 16 +++ 17 @@ -1,2 +1,2 @@ -IO/LockFileAddToDataDirRead +IO/LockFileAddtodatadirRead Waiting for a read while adding a line to the data directory lock file.
changedLockFileAddtodatadirSync
--- 16 +++ 17 @@ -1,2 +1,2 @@ -IO/LockFileAddToDataDirSync +IO/LockFileAddtodatadirSync Waiting for data to reach durable storage while adding a line to the data directory lock file.
changedLockFileAddtodatadirWrite
--- 16 +++ 17 @@ -1,2 +1,2 @@ -IO/LockFileAddToDataDirWrite +IO/LockFileAddtodatadirWrite Waiting for a write while adding a line to the data directory lock file.
changedLockFileRecheckdatadirRead
--- 16 +++ 17 @@ -1,2 +1,2 @@ -IO/LockFileReCheckDataDirRead +IO/LockFileRecheckdatadirRead Waiting for a read during recheck of the data directory lock file.
changedSlruFlushSync
--- 16 +++ 17 @@ -1,2 +1,2 @@ -IO/SLRUFlushSync +IO/SlruFlushSync Waiting for SLRU data to reach durable storage during a checkpoint or database shutdown.
changedSlruRead
--- 16 +++ 17 @@ -1,2 +1,2 @@ -IO/SLRURead +IO/SlruRead Waiting for a read of an SLRU page.
changedSlruSync
--- 16 +++ 17 @@ -1,2 +1,2 @@ -IO/SLRUSync +IO/SlruSync Waiting for SLRU data to reach durable storage following a page write.
changedSlruWrite
--- 16 +++ 17 @@ -1,2 +1,2 @@ -IO/SLRUWrite +IO/SlruWrite Waiting for a write of an SLRU page.
changedWalBootstrapSync
--- 16 +++ 17 @@ -1,2 +1,2 @@ -IO/WALBootstrapSync +IO/WalBootstrapSync Waiting for WAL to reach durable storage during bootstrapping.
changedWalBootstrapWrite
--- 16 +++ 17 @@ -1,2 +1,2 @@ -IO/WALBootstrapWrite +IO/WalBootstrapWrite Waiting for a write of a WAL page during bootstrapping.
changedWalCopyRead
--- 16 +++ 17 @@ -1,2 +1,2 @@ -IO/WALCopyRead +IO/WalCopyRead Waiting for a read when creating a new WAL segment by copying an existing one.
changedWalCopySync
--- 16 +++ 17 @@ -1,2 +1,2 @@ -IO/WALCopySync +IO/WalCopySync Waiting for a new WAL segment created by copying an existing one to reach durable storage.
changedWalCopyWrite
--- 16 +++ 17 @@ -1,2 +1,2 @@ -IO/WALCopyWrite +IO/WalCopyWrite Waiting for a write when creating a new WAL segment by copying an existing one.
changedWalInitSync
--- 16 +++ 17 @@ -1,2 +1,2 @@ -IO/WALInitSync +IO/WalInitSync Waiting for a newly initialized WAL file to reach durable storage.
changedWalInitWrite
--- 16 +++ 17 @@ -1,2 +1,2 @@ -IO/WALInitWrite +IO/WalInitWrite Waiting for a write while initializing a new WAL file.
changedWalRead
--- 16 +++ 17 @@ -1,2 +1,2 @@ -IO/WALRead +IO/WalRead Waiting for a read from a WAL file.
changedWalsenderTimelineHistoryRead
--- 16 +++ 17 @@ -1,2 +1,2 @@ -IO/WALSenderTimelineHistoryRead +IO/WalsenderTimelineHistoryRead Waiting for a read from a timeline history file during a walsender timeline command.
addedWalSummaryRead
--- 16 +++ 17 @@ -0,0 +1,2 @@ +IO/WalSummaryRead +Waiting for a read from a WAL summary file.
addedWalSummaryWrite
--- 16 +++ 17 @@ -0,0 +1,2 @@ +IO/WalSummaryWrite +Waiting for a write to a WAL summary file.
changedWalSync
--- 16 +++ 17 @@ -1,2 +1,2 @@ -IO/WALSync +IO/WalSync Waiting for a WAL file to reach durable storage.
changedWalSyncMethodAssign
--- 16 +++ 17 @@ -1,2 +1,2 @@ -IO/WALSyncMethodAssign +IO/WalSyncMethodAssign Waiting for data to reach durable storage while assigning a new WAL sync method.
changedWalWrite
--- 16 +++ 17 @@ -1,2 +1,2 @@ -IO/WALWrite +IO/WalWrite Waiting for a write to a WAL file.
changedBgworkerShutdown
--- 16 +++ 17 @@ -1,2 +1,2 @@ -IPC/BgWorkerShutdown +IPC/BgworkerShutdown Waiting for background worker to shut down.
changedBgworkerStartup
--- 16 +++ 17 @@ -1,2 +1,2 @@ -IPC/BgWorkerStartup +IPC/BgworkerStartup Waiting for background worker to start up.
changedBufferIo
--- 16 +++ 17 @@ -1,2 +1,2 @@ -IPC/BufferIO +IPC/BufferIo Waiting for buffer I/O to complete.
addedCheckpointDelayComplete
--- 16 +++ 17 @@ -0,0 +1,2 @@ +IPC/CheckpointDelayComplete +Waiting for a backend that blocks a checkpoint from completing.
addedCheckpointDelayStart
--- 16 +++ 17 @@ -0,0 +1,2 @@ +IPC/CheckpointDelayStart +Waiting for a backend that blocks a checkpoint from starting.
addedMultixactCreation
--- 16 +++ 17 @@ -0,0 +1,2 @@ +IPC/MultixactCreation +Waiting for a multixact creation to complete.
changedProcarrayGroupUpdate
--- 16 +++ 17 @@ -1,2 +1,2 @@ -IPC/ProcArrayGroupUpdate +IPC/ProcarrayGroupUpdate Waiting for the group leader to clear the transaction ID at transaction end.
addedWalReceiverUpstreamCatchup
--- 16 +++ 17 @@ -0,0 +1,2 @@ +IPC/WalReceiverUpstreamCatchup +Waiting for upstream server WAL flush position to catch up to requested start point.
addedWalSummaryReady
--- 16 +++ 17 @@ -0,0 +1,2 @@ +IPC/WalSummaryReady +Waiting for a new WAL summary to be generated.
changedvirtualxid
--- 16 +++ 17 @@ -1,2 +1,2 @@ Lock/virtualxid -Waiting to acquire a virtual transaction ID lock; see Section 74.1. +Waiting to acquire a virtual transaction ID lock; see Section 66.1.
addedDSMRegistry
--- 16 +++ 17 @@ -0,0 +1,2 @@ +LWLock/DSMRegistry +Waiting to read or update the dynamic shared memory registry.
addedDSMRegistryDSA
--- 16 +++ 17 @@ -0,0 +1,2 @@ +LWLock/DSMRegistryDSA +Waiting to access dynamic shared memory registry's dynamic shared memory allocator.
addedDSMRegistryHash
--- 16 +++ 17 @@ -0,0 +1,2 @@ +LWLock/DSMRegistryHash +Waiting to access dynamic shared memory registry's shared hash table.
addedInjectionPoint
--- 16 +++ 17 @@ -0,0 +1,2 @@ +LWLock/InjectionPoint +Waiting to read or update information related to injection points.
removedOldSnapshotTimeMap
--- 16 +++ 17 @@ -1,2 +0,0 @@ -LWLock/OldSnapshotTimeMap -Waiting to read or update old snapshot control information.
addedParallelVacuumDSA
--- 16 +++ 17 @@ -0,0 +1,2 @@ +LWLock/ParallelVacuumDSA +Waiting for parallel vacuum dynamic shared memory allocation.
changedPgStatsData
--- 16 +++ 17 @@ -1,2 +1,2 @@ LWLock/PgStatsData -Waiting for shared memory stats data access +Waiting for shared memory stats data access.
changedPgStatsDSA
--- 16 +++ 17 @@ -1,2 +1,2 @@ LWLock/PgStatsDSA -Waiting for stats dynamic shared memory allocator access +Waiting for stats dynamic shared memory allocator access.
changedPgStatsHash
--- 16 +++ 17 @@ -1,2 +1,2 @@ LWLock/PgStatsHash -Waiting for stats shared memory hash table access +Waiting for stats shared memory hash table access.
addedSerialControl
--- 16 +++ 17 @@ -0,0 +1,2 @@ +LWLock/SerialControl +Waiting to read or update shared pg_serial state.
addedWaitEventCustom
--- 16 +++ 17 @@ -0,0 +1,2 @@ +LWLock/WaitEventCustom +Waiting to read or update custom wait events information.
addedWALSummarizer
--- 16 +++ 17 @@ -0,0 +1,2 @@ +LWLock/WALSummarizer +Waiting to read or update WAL summarization state.
addedWalSummarizerError
--- 16 +++ 17 @@ -0,0 +1,2 @@ +Timeout/WalSummarizerError +Waiting after a WAL summarizer error.