WAIT EVENTS / VERSION COMPARISON
What changed?
Wait Events · PostgreSQL 9.6 → 10
Historical documentation for a PostgreSQL version that is no longer supported.
115 added · 0 removed · 61 changed · 0 coverage changes. These are changes in the pinned reference snapshots.
addedArchiverMain
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +Activity/ArchiverMain +Waiting in main loop of the archiver process.
addedAutovacuumMain
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +Activity/AutoVacuumMain +Waiting in main loop of autovacuum launcher process.
addedBgwriterHibernate
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +Activity/BgWriterHibernate +Waiting in background writer process, hibernating.
addedBgwriterMain
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +Activity/BgWriterMain +Waiting in main loop of background writer process background worker.
addedCheckpointerMain
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +Activity/CheckpointerMain +Waiting in main loop of checkpointer process.
addedLogicalApplyMain
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +Activity/LogicalApplyMain +Waiting in main loop of logical apply process.
addedLogicalLauncherMain
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +Activity/LogicalLauncherMain +Waiting in main loop of logical launcher process.
addedPgStatMain
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +Activity/PgStatMain +Waiting in main loop of the statistics collector process.
addedRecoveryWalAll
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +Activity/RecoveryWalAll +Waiting for WAL from a stream at recovery.
addedRecoveryWalStream
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +Activity/RecoveryWalStream +Waiting when WAL data is not available from any kind of sources (local, archive or stream) before trying again to retrieve WAL data, at recovery.
addedSysloggerMain
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +Activity/SysLoggerMain +Waiting in main loop of syslogger process.
addedWalReceiverMain
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +Activity/WalReceiverMain +Waiting in main loop of WAL receiver process.
addedWalSenderMain
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +Activity/WalSenderMain +Waiting in main loop of WAL sender process.
addedWalWriterMain
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +Activity/WalWriterMain +Waiting in main loop of WAL writer process.
addedClientRead
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +Client/ClientRead +Waiting to read data from the client.
addedClientWrite
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +Client/ClientWrite +Waiting to write data to the client.
addedLibpqwalreceiverConnect
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +Client/LibPQWalReceiverConnect +Waiting in WAL receiver to establish connection to remote server.
addedLibpqwalreceiverReceive
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +Client/LibPQWalReceiverReceive +Waiting in WAL receiver to receive data from remote server.
addedSslOpenServer
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +Client/SSLOpenServer +Waiting for SSL while attempting connection.
addedWalSenderWaitForWal
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +Client/WalSenderWaitForWAL +Waiting for WAL to be flushed in WAL sender process.
addedWalSenderWriteData
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +Client/WalSenderWriteData +Waiting for any activity when processing replies from WAL receiver in WAL sender process.
addedExtension
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +Extension/Extension +Waiting in an extension.
addedBuffileRead
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/BufFileRead +Waiting for a read from a buffered file.
addedBuffileWrite
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/BufFileWrite +Waiting for a write to a buffered file.
addedControlFileRead
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/ControlFileRead +Waiting for a read from the control file.
addedControlFileSync
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/ControlFileSync +Waiting for the control file to reach durable storage.
addedControlFileSyncUpdate
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/ControlFileSyncUpdate +Waiting for an update to the control file to reach durable storage.
addedControlFileWrite
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/ControlFileWrite +Waiting for a write to the control file.
addedControlFileWriteUpdate
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/ControlFileWriteUpdate +Waiting for a write to update the control file.
addedCopyFileRead
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/CopyFileRead +Waiting for a read during a file copy operation.
addedCopyFileWrite
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/CopyFileWrite +Waiting for a write during a file copy operation.
addedDataFileExtend
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/DataFileExtend +Waiting for a relation data file to be extended.
addedDataFileFlush
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/DataFileFlush +Waiting for a relation data file to reach durable storage.
addedDataFileImmediateSync
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/DataFileImmediateSync +Waiting for an immediate synchronization of a relation data file to durable storage.
addedDataFilePrefetch
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/DataFilePrefetch +Waiting for an asynchronous prefetch from a relation data file.
addedDataFileRead
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/DataFileRead +Waiting for a read from a relation data file.
addedDataFileSync
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/DataFileSync +Waiting for changes to a relation data file to reach durable storage.
addedDataFileTruncate
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/DataFileTruncate +Waiting for a relation data file to be truncated.
addedDataFileWrite
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/DataFileWrite +Waiting for a write to a relation data file.
addedDsmFillZeroWrite
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/DSMFillZeroWrite +Waiting to write zero bytes to a dynamic shared memory backing file.
addedLockFileAddtodatadirRead
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/LockFileAddToDataDirRead +Waiting for a read while adding a line to the data directory lock file.
addedLockFileAddtodatadirSync
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/LockFileAddToDataDirSync +Waiting for data to reach durable storage while adding a line to the data directory lock file.
addedLockFileAddtodatadirWrite
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/LockFileAddToDataDirWrite +Waiting for a write while adding a line to the data directory lock file.
addedLockFileCreateRead
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/LockFileCreateRead +Waiting to read while creating the data directory lock file.
addedLockFileCreateSync
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/LockFileCreateSync +Waiting for data to reach durable storage while creating the data directory lock file.
addedLockFileCreateWrite
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/LockFileCreateWrite +Waiting for a write while creating the data directory lock file.
addedLockFileRecheckdatadirRead
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/LockFileReCheckDataDirRead +Waiting for a read during recheck of the data directory lock file.
addedLogicalRewriteCheckpointSync
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/LogicalRewriteCheckpointSync +Waiting for logical rewrite mappings to reach durable storage during a checkpoint.
addedLogicalRewriteMappingSync
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/LogicalRewriteMappingSync +Waiting for mapping data to reach durable storage during a logical rewrite.
addedLogicalRewriteMappingWrite
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/LogicalRewriteMappingWrite +Waiting for a write of mapping data during a logical rewrite.
addedLogicalRewriteSync
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/LogicalRewriteSync +Waiting for logical rewrite mappings to reach durable storage.
addedLogicalRewriteTruncate
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/LogicalRewriteTruncate +Waiting for truncate of mapping data during a logical rewrite.
addedLogicalRewriteWrite
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/LogicalRewriteWrite +Waiting for a write of logical rewrite mappings.
addedRelationMapRead
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/RelationMapRead +Waiting for a read of the relation map file.
addedRelationMapSync
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/RelationMapSync +Waiting for the relation map file to reach durable storage.
addedRelationMapWrite
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/RelationMapWrite +Waiting for a write to the relation map file.
addedReorderBufferRead
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/ReorderBufferRead +Waiting for a read during reorder buffer management.
addedReorderBufferWrite
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/ReorderBufferWrite +Waiting for a write during reorder buffer management.
addedReorderLogicalMappingRead
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/ReorderLogicalMappingRead +Waiting for a read of a logical mapping during reorder buffer management.
addedReplicationSlotRead
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/ReplicationSlotRead +Waiting for a read from a replication slot control file.
addedReplicationSlotRestoreSync
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/ReplicationSlotRestoreSync +Waiting for a replication slot control file to reach durable storage while restoring it to memory.
addedReplicationSlotSync
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/ReplicationSlotSync +Waiting for a replication slot control file to reach durable storage.
addedReplicationSlotWrite
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/ReplicationSlotWrite +Waiting for a write to a replication slot control file.
addedSlruFlushSync
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/SLRUFlushSync +Waiting for SLRU data to reach durable storage during a checkpoint or database shutdown.
addedSlruRead
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/SLRURead +Waiting for a read of an SLRU page.
addedSlruSync
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/SLRUSync +Waiting for SLRU data to reach durable storage following a page write.
addedSlruWrite
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/SLRUWrite +Waiting for a write of an SLRU page.
addedSnapbuildRead
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/SnapbuildRead +Waiting for a read of a serialized historical catalog snapshot.
addedSnapbuildSync
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/SnapbuildSync +Waiting for a serialized historical catalog snapshot to reach durable storage.
addedSnapbuildWrite
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/SnapbuildWrite +Waiting for a write of a serialized historical catalog snapshot.
addedTimelineHistoryFileSync
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/TimelineHistoryFileSync +Waiting for a timeline history file received via streaming replication to reach durable storage.
addedTimelineHistoryFileWrite
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/TimelineHistoryFileWrite +Waiting for a write of a timeline history file received via streaming replication.
addedTimelineHistoryRead
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/TimelineHistoryRead +Waiting for a read of a timeline history file.
addedTimelineHistorySync
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/TimelineHistorySync +Waiting for a newly created timeline history file to reach durable storage.
addedTimelineHistoryWrite
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/TimelineHistoryWrite +Waiting for a write of a newly created timeline history file.
addedTwophaseFileRead
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/TwophaseFileRead +Waiting for a read of a two phase state file.
addedTwophaseFileSync
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/TwophaseFileSync +Waiting for a two phase state file to reach durable storage.
addedTwophaseFileWrite
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/TwophaseFileWrite +Waiting for a write of a two phase state file.
addedWalBootstrapSync
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/WALBootstrapSync +Waiting for WAL to reach durable storage during bootstrapping.
addedWalBootstrapWrite
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/WALBootstrapWrite +Waiting for a write of a WAL page during bootstrapping.
addedWalCopyRead
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/WALCopyRead +Waiting for a read when creating a new WAL segment by copying an existing one.
addedWalCopySync
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/WALCopySync +Waiting a new WAL segment created by copying an existing one to reach durable storage.
addedWalCopyWrite
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/WALCopyWrite +Waiting for a write when creating a new WAL segment by copying an existing one.
addedWalInitSync
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/WALInitSync +Waiting for a newly initialized WAL file to reach durable storage.
addedWalInitWrite
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/WALInitWrite +Waiting for a write while initializing a new WAL file.
addedWalRead
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/WALRead +Waiting for a read from a WAL file.
addedWalsenderTimelineHistoryRead
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/WALSenderTimelineHistoryRead +Waiting for a read from a timeline history file during walsender timeline command.
addedWalSyncMethodAssign
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/WALSyncMethodAssign +Waiting for data to reach durable storage while assigning WAL sync method.
addedWalWrite
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IO/WALWrite +Waiting for a write to a WAL file.
addedBgworkerShutdown
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IPC/BgWorkerShutdown +Waiting for background worker to shut down.
addedBgworkerStartup
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IPC/BgWorkerStartup +Waiting for background worker to start up.
addedBtreePage
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IPC/BtreePage +Waiting for the page number needed to continue a parallel B-tree scan to become available.
changedBufferIo
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ -LWLockTranche/buffer_io +LWLock/buffer_io Waiting for I/O on a data page.
addedExecuteGather
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IPC/ExecuteGather +Waiting for activity from child process when executing Gather node.
addedLogicalSyncData
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IPC/LogicalSyncData +Waiting for logical replication remote server to send data for initial table synchronization.
addedLogicalSyncStateChange
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IPC/LogicalSyncStateChange +Waiting for logical replication remote server to change state.
addedMessageQueueInternal
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IPC/MessageQueueInternal +Waiting for other process to be attached in shared message queue.
addedMessageQueuePutMessage
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IPC/MessageQueuePutMessage +Waiting to write a protocol message to a shared message queue.
addedMessageQueueReceive
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IPC/MessageQueueReceive +Waiting to receive bytes from a shared message queue.
addedMessageQueueSend
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IPC/MessageQueueSend +Waiting to send bytes to a shared message queue.
addedParallelBitmapScan
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IPC/ParallelBitmapScan +Waiting for parallel bitmap scan to become initialized.
addedParallelFinish
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IPC/ParallelFinish +Waiting for parallel workers to finish computing.
addedProcarrayGroupUpdate
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IPC/ProcArrayGroupUpdate +Waiting for group leader to clear transaction id at transaction end.
addedReplicationOriginDrop
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IPC/ReplicationOriginDrop +Waiting for a replication origin to become inactive to be dropped.
addedReplicationSlotDrop
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IPC/ReplicationSlotDrop +Waiting for a replication slot to become inactive to be dropped.
addedSafeSnapshot
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IPC/SafeSnapshot +Waiting for a snapshot for a READ ONLY DEFERRABLE transaction.
addedSyncRep
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +IPC/SyncRep +Waiting for confirmation from remote server during synchronous replication.
addedWalReceiverWaitStart
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +Client/WalReceiverWaitStart +Waiting for startup process to send initial data for streaming replication.
changeduserlock
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ Lock/userlock -Waiting to acquire a userlock. +Waiting to acquire a user lock.
changedAddinShmemInit
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ -LWLockNamed/AddinShmemInitLock +LWLock/AddinShmemInitLock Waiting to manage space allocation in shared memory.
changedAutoFile
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ -LWLockNamed/AutoFileLock +LWLock/AutoFileLock Waiting to update the postgresql.auto.conf file.
changedAutovacuum
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ -LWLockNamed/AutovacuumLock +LWLock/AutovacuumLock Autovacuum worker or launcher waiting to update or read the current state of autovacuum workers.
changedAutovacuumSchedule
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ -LWLockNamed/AutovacuumScheduleLock +LWLock/AutovacuumScheduleLock Waiting to ensure that the table it has selected for a vacuum still needs vacuuming.
addedBackendRandomLock
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +LWLock/BackendRandomLock +Waiting to generate a random number.
changedBackgroundWorker
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ -LWLockNamed/BackgroundWorkerLock +LWLock/BackgroundWorkerLock Waiting to read or update background worker state.
changedBtreeVacuum
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ -LWLockNamed/BtreeVacuumLock +LWLock/BtreeVacuumLock Waiting to read or update vacuum-related information for a B-tree index.
changedBufferContent
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ -LWLockTranche/buffer_content +LWLock/buffer_content Waiting to read or write a data page in memory.
changedBufferMapping
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ -LWLockTranche/buffer_mapping +LWLock/buffer_mapping Waiting to associate a data block with a buffer in the buffer pool.
changedCheckpoint
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ -LWLockNamed/CheckpointLock +LWLock/CheckpointLock Waiting to perform checkpoint.
changedCheckpointerComm
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ -LWLockNamed/CheckpointerCommLock +LWLock/CheckpointerCommLock Waiting to manage fsync requests.
changedCommitTs
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ -LWLockNamed/CommitTsLock +LWLock/CommitTsLock Waiting to read or update the last value set for the transaction timestamp.
changedCommitTsBuffer
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ -LWLockTranche/commit_timestamp +LWLock/commit_timestamp Waiting for I/O on commit timestamp buffer.
changedCommitTsSLRU
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ -LWLockNamed/CommitTsControlLock +LWLock/CommitTsControlLock Waiting to read or update transaction commit timestamps.
changedControlFile
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ -LWLockNamed/ControlFileLock +LWLock/ControlFileLock Waiting to read or update the control file or creation of a new WAL file.
changedDynamicSharedMemoryControl
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ -LWLockNamed/DynamicSharedMemoryControlLock +LWLock/DynamicSharedMemoryControlLock Waiting to read or update dynamic shared memory state.
changedLockFastPath
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ -LWLockTranche/proc +LWLock/proc Waiting to read or update the fast-path lock information.
changedLockManager
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ -LWLockTranche/lock_manager +LWLock/lock_manager Waiting to add or examine locks for backends, or waiting to join or exit a locking group (used by parallel query).
addedLogicalRepWorker
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +LWLock/LogicalRepWorkerLock +Waiting for action on logical replication worker to finish.
changedMultiXactGen
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ -LWLockNamed/MultiXactGenLock +LWLock/MultiXactGenLock Waiting to read or update shared multixact state.
changedMultiXactMemberBuffer
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ -LWLockTranche/multixact_member +LWLock/multixact_member Waiting for I/O on a multixact_member buffer.
changedMultiXactMemberSLRU
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ -LWLockNamed/MultiXactMemberControlLock +LWLock/MultiXactMemberControlLock Waiting to read or update multixact member mappings.
changedMultiXactOffsetBuffer
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ -LWLockTranche/multixact_offset +LWLock/multixact_offset Waiting for I/O on a multixact offset buffer.
changedMultiXactOffsetSLRU
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ -LWLockNamed/MultiXactOffsetControlLock +LWLock/MultiXactOffsetControlLock Waiting to read or update multixact offset mappings.
changedMultiXactTruncation
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ -LWLockNamed/MultiXactTruncationLock +LWLock/MultiXactTruncationLock Waiting to read or truncate multixact information.
changedNotifyBuffer
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ -LWLockTranche/async +LWLock/async Waiting for I/O on an async (notify) buffer.
changedNotifyQueue
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ -LWLockNamed/AsyncQueueLock +LWLock/AsyncQueueLock Waiting to read or update notification messages.
changedNotifyQueueTail
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ -LWLockNamed/NotifyQueueTailLock +LWLock/NotifyQueueTailLock Waiting to update limit on notification message storage.
changedNotifySLRU
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ -LWLockNamed/AsyncCtlLock +LWLock/AsyncCtlLock Waiting to read or update shared notification state.
changedOidGen
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ -LWLockNamed/OidGenLock +LWLock/OidGenLock Waiting to allocate or assign an OID.
changedOldSnapshotTimeMap
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ -LWLockNamed/OldSnapshotTimeMapLock +LWLock/OldSnapshotTimeMapLock Waiting to read or update old snapshot control information.
addedParallelQueryDSA
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +LWLock/parallel_query_dsa +Waiting for parallel query dynamic shared memory allocation lock.
changedPredicateLockManager
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ -LWLockTranche/predicate_lock_manager +LWLock/predicate_lock_manager Waiting to add or examine predicate lock information.
changedProcArray
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ -LWLockNamed/ProcArrayLock +LWLock/ProcArrayLock Waiting to get a snapshot or clearing a transaction id at transaction end.
changedRelationMapping
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ -LWLockNamed/RelationMappingLock +LWLock/RelationMappingLock Waiting to update the relation map file used to store catalog to filenode mapping.
changedRelCacheInit
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ -LWLockNamed/RelCacheInitLock +LWLock/RelCacheInitLock Waiting to read or write relation cache initialization file.
changedReplicationOrigin
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ -LWLockNamed/ReplicationOriginLock +LWLock/ReplicationOriginLock Waiting to setup, drop or use replication origin.
changedReplicationOriginState
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ -LWLockTranche/replication_origin +LWLock/replication_origin Waiting to read or update the replication progress.
changedReplicationSlotAllocation
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ -LWLockNamed/ReplicationSlotAllocationLock +LWLock/ReplicationSlotAllocationLock Waiting to allocate or free a replication slot.
changedReplicationSlotControl
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ -LWLockNamed/ReplicationSlotControlLock +LWLock/ReplicationSlotControlLock Waiting to read or update replication slot state.
changedReplicationSlotIO
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ -LWLockTranche/replication_slot_io +LWLock/replication_slot_io Waiting for I/O on a replication slot.
changedSerialBuffer
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ -LWLockTranche/oldserxid +LWLock/oldserxid Waiting to I/O on an oldserxid buffer.
changedSerializableFinishedList
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ -LWLockNamed/SerializableFinishedListLock +LWLock/SerializableFinishedListLock Waiting to access the list of finished serializable transactions.
changedSerializablePredicateList
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ -LWLockNamed/SerializablePredicateLockListLock +LWLock/SerializablePredicateLockListLock Waiting to perform an operation on a list of locks held by serializable transactions.
changedSerializableXactHash
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ -LWLockNamed/SerializableXactHashLock +LWLock/SerializableXactHashLock Waiting to retrieve or store information about serializable transactions.
changedSerialSLRU
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ -LWLockNamed/OldSerXidLock +LWLock/OldSerXidLock Waiting to read or record conflicting serializable transactions.
addedSharedTidBitmap
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +LWLock/tbm +Waiting for TBM shared iterator lock.
changedShmemIndex
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ -LWLockNamed/ShmemIndexLock +LWLock/ShmemIndexLock Waiting to find or allocate space in shared memory.
changedSInvalRead
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ -LWLockNamed/SInvalReadLock +LWLock/SInvalReadLock Waiting to retrieve or remove messages from shared invalidation queue.
changedSInvalWrite
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ -LWLockNamed/SInvalWriteLock +LWLock/SInvalWriteLock Waiting to add a message in shared invalidation queue.
changedSubtransBuffer
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ -LWLockTranche/subtrans +LWLock/subtrans Waiting for I/O a subtransaction buffer.
changedSubtransSLRU
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ -LWLockNamed/SubtransControlLock +LWLock/SubtransControlLock Waiting to read or update sub-transaction information.
changedSyncRep
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ -LWLockNamed/SyncRepLock +LWLock/SyncRepLock Waiting to read or update information about synchronous replicas.
changedSyncScan
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ -LWLockNamed/SyncScanLock +LWLock/SyncScanLock Waiting to get the start location of a scan on a table for synchronized scans.
changedTablespaceCreate
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ -LWLockNamed/TablespaceCreateLock +LWLock/TablespaceCreateLock Waiting to create or drop the tablespace.
changedTwoPhaseState
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ -LWLockNamed/TwoPhaseStateLock +LWLock/TwoPhaseStateLock Waiting to read or update the state of prepared transactions.
changedWALBufMapping
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ -LWLockNamed/WALBufMappingLock +LWLock/WALBufMappingLock Waiting to replace a page in WAL buffers.
changedWALInsert
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ -LWLockTranche/wal_insert +LWLock/wal_insert Waiting to insert WAL into a memory buffer.
changedWALWrite
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ -LWLockNamed/WALWriteLock +LWLock/WALWriteLock Waiting for WAL buffers to be written to disk.
changedWrapLimitsVacuum
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ -LWLockNamed/WrapLimitsVacuumLock +LWLock/WrapLimitsVacuumLock Waiting to update limits on transaction id and multixact consumption.
changedXactBuffer
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ -LWLockTranche/clog +LWLock/clog Waiting for I/O on a clog (transaction status) buffer.
changedXactSLRU
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ -LWLockNamed/CLogControlLock +LWLock/CLogControlLock Waiting to read or update transaction status.
addedXactTruncation
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +LWLock/CLogTruncationLock +Waiting to execute txid_status or update the oldest transaction id available to it.
changedXidGen
--- 9.6 +++ 10 @@ -1,2 +1,2 @@ -LWLockNamed/XidGenLock +LWLock/XidGenLock Waiting to allocate or assign a transaction id.
addedBaseBackupThrottle
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +Timeout/BaseBackupThrottle +Waiting during base backup when throttling activity.
addedPgSleep
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +Timeout/PgSleep +Waiting in process that called pg_sleep.
addedRecoveryApplyDelay
--- 9.6 +++ 10 @@ -0,0 +1,2 @@ +Timeout/RecoveryApplyDelay +Waiting to apply WAL at recovery because it is delayed.