WAIT EVENTS / VERSION COMPARISON
What changed?
Wait Events · PostgreSQL 12 → 13
Historical documentation for a PostgreSQL version that is no longer supported.
11 added · 1 removed · 114 changed · 0 coverage changes. These are changes in the pinned reference snapshots.
changedArchiverMain
--- 12 +++ 13 @@ -1,2 +1,2 @@ Activity/ArchiverMain -Waiting in main loop of the archiver process. +Waiting in main loop of archiver process.
changedBgwriterMain
--- 12 +++ 13 @@ -1,2 +1,2 @@ Activity/BgWriterMain -Waiting in main loop of background writer process background worker. +Waiting in main loop of background writer process.
changedLogicalApplyMain
--- 12 +++ 13 @@ -1,2 +1,2 @@ Activity/LogicalApplyMain -Waiting in main loop of logical apply process. +Waiting in main loop of logical replication apply process.
changedLogicalLauncherMain
--- 12 +++ 13 @@ -1,2 +1,2 @@ Activity/LogicalLauncherMain -Waiting in main loop of logical launcher process. +Waiting in main loop of logical replication launcher process.
changedPgStatMain
--- 12 +++ 13 @@ -1,2 +1,2 @@ Activity/PgStatMain -Waiting in main loop of the statistics collector process. +Waiting in main loop of statistics collector process.
removedRecoveryWalAll
--- 12 +++ 13 @@ -1,2 +0,0 @@ -Activity/RecoveryWalAll -Waiting for WAL from a stream at recovery.
changedRecoveryWalStream
--- 12 +++ 13 @@ -1,2 +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. +Waiting in main loop of startup process for WAL to arrive, during streaming recovery.
changedBufferPin
--- 12 +++ 13 @@ -1,2 +1,2 @@ BufferPin/BufferPin -Waiting to acquire a pin on a buffer. +Waiting to acquire an exclusive pin on a buffer.
changedGssOpenServer
--- 12 +++ 13 @@ -1,2 +1,2 @@ Client/GSSOpenServer -Waiting to read data from the client while establishing the GSSAPI session. +Waiting to read data from the client while establishing a GSSAPI session.
changedControlFileRead
--- 12 +++ 13 @@ -1,2 +1,2 @@ IO/ControlFileRead -Waiting for a read from the control file. +Waiting for a read from the pg_control file.
changedControlFileSync
--- 12 +++ 13 @@ -1,2 +1,2 @@ IO/ControlFileSync -Waiting for the control file to reach durable storage. +Waiting for the pg_control file to reach durable storage.
changedControlFileSyncUpdate
--- 12 +++ 13 @@ -1,2 +1,2 @@ IO/ControlFileSyncUpdate -Waiting for an update to the control file to reach durable storage. +Waiting for an update to the pg_control file to reach durable storage.
changedControlFileWrite
--- 12 +++ 13 @@ -1,2 +1,2 @@ IO/ControlFileWrite -Waiting for a write to the control file. +Waiting for a write to the pg_control file.
changedControlFileWriteUpdate
--- 12 +++ 13 @@ -1,2 +1,2 @@ IO/ControlFileWriteUpdate -Waiting for a write to update the control file. +Waiting for a write to update the pg_control file.
changedDsmFillZeroWrite
--- 12 +++ 13 @@ -1,2 +1,2 @@ IO/DSMFillZeroWrite -Waiting to write zero bytes to a dynamic shared memory backing file. +Waiting to fill a dynamic shared memory backing file with zeroes.
changedWalCopySync
--- 12 +++ 13 @@ -1,2 +1,2 @@ IO/WALCopySync -Waiting a new WAL segment created by copying an existing one to reach durable storage. +Waiting for a new WAL segment created by copying an existing one to reach durable storage.
changedWalsenderTimelineHistoryRead
--- 12 +++ 13 @@ -1,2 +1,2 @@ IO/WALSenderTimelineHistoryRead -Waiting for a read from a timeline history file during walsender timeline command. +Waiting for a read from a timeline history file during a walsender timeline command.
changedWalSyncMethodAssign
--- 12 +++ 13 @@ -1,2 +1,2 @@ IO/WALSyncMethodAssign -Waiting for data to reach durable storage while assigning WAL sync method. +Waiting for data to reach durable storage while assigning a new WAL sync method.
addedBackupWaitWalArchive
--- 12 +++ 13 @@ -0,0 +1,2 @@ +IPC/BackupWaitWalArchive +Waiting for WAL files required for a backup to be successfully archived.
changedBufferIo
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/buffer_io +LWLock/BufferIO Waiting for I/O on a data page.
changedExecuteGather
--- 12 +++ 13 @@ -1,2 +1,2 @@ IPC/ExecuteGather -Waiting for activity from child process when executing Gather node. +Waiting for activity from a child process while executing a Gather plan node.
changedHashBatchAllocate
--- 12 +++ 13 @@ -1,2 +1,2 @@ -IPC/Hash/Batch/Allocating +IPC/HashBatchAllocate Waiting for an elected Parallel Hash participant to allocate a hash table.
changedHashBatchElect
--- 12 +++ 13 @@ -1,2 +1,2 @@ -IPC/Hash/Batch/Electing -Electing a Parallel Hash participant to allocate a hash table. +IPC/HashBatchElect +Waiting to elect a Parallel Hash participant to allocate a hash table.
changedHashBatchLoad
--- 12 +++ 13 @@ -1,2 +1,2 @@ -IPC/Hash/Batch/Loading +IPC/HashBatchLoad Waiting for other Parallel Hash participants to finish loading a hash table.
changedHashBuildAllocate
--- 12 +++ 13 @@ -1,2 +1,2 @@ -IPC/Hash/Build/Allocating +IPC/HashBuildAllocate Waiting for an elected Parallel Hash participant to allocate the initial hash table.
changedHashBuildElect
--- 12 +++ 13 @@ -1,2 +1,2 @@ -IPC/Hash/Build/Electing -Electing a Parallel Hash participant to allocate the initial hash table. +IPC/HashBuildElect +Waiting to elect a Parallel Hash participant to allocate the initial hash table.
changedHashBuildHashInner
--- 12 +++ 13 @@ -1,2 +1,2 @@ -IPC/Hash/Build/HashingInner +IPC/HashBuildHashInner Waiting for other Parallel Hash participants to finish hashing the inner relation.
changedHashBuildHashOuter
--- 12 +++ 13 @@ -1,2 +1,2 @@ -IPC/Hash/Build/HashingOuter +IPC/HashBuildHashOuter Waiting for other Parallel Hash participants to finish partitioning the outer relation.
changedHashGrowBatchesDecide
--- 12 +++ 13 @@ -1,2 +1,2 @@ -IPC/Hash/GrowBatches/Deciding -Electing a Parallel Hash participant to decide on future batch growth. +IPC/HashGrowBatchesDecide +Waiting to elect a Parallel Hash participant to decide on future batch growth.
changedHashGrowBatchesElect
--- 12 +++ 13 @@ -1,2 +1,2 @@ -IPC/Hash/GrowBatches/Electing -Electing a Parallel Hash participant to allocate more batches. +IPC/HashGrowBatchesElect +Waiting to elect a Parallel Hash participant to allocate more batches.
changedHashGrowBatchesFinish
--- 12 +++ 13 @@ -1,2 +1,2 @@ -IPC/Hash/GrowBatches/Finishing +IPC/HashGrowBatchesFinish Waiting for an elected Parallel Hash participant to decide on future batch growth.
changedHashGrowBatchesReallocate
--- 12 +++ 13 @@ -1,2 +1,2 @@ -IPC/Hash/GrowBatches/Allocating +IPC/HashGrowBatchesAllocate Waiting for an elected Parallel Hash participant to allocate more batches.
changedHashGrowBatchesRepartition
--- 12 +++ 13 @@ -1,2 +1,2 @@ -IPC/Hash/GrowBatches/Repartitioning -Waiting for other Parallel Hash participants to finishing repartitioning. +IPC/HashGrowBatchesRepartition +Waiting for other Parallel Hash participants to finish repartitioning.
changedHashGrowBucketsElect
--- 12 +++ 13 @@ -1,2 +1,2 @@ -IPC/Hash/GrowBuckets/Electing -Electing a Parallel Hash participant to allocate more buckets. +IPC/HashGrowBucketsElect +Waiting to elect a Parallel Hash participant to allocate more buckets.
changedHashGrowBucketsReallocate
--- 12 +++ 13 @@ -1,2 +1,2 @@ -IPC/Hash/GrowBuckets/Allocating +IPC/HashGrowBucketsAllocate Waiting for an elected Parallel Hash participant to finish allocating more buckets.
changedHashGrowBucketsReinsert
--- 12 +++ 13 @@ -1,2 +1,2 @@ -IPC/Hash/GrowBuckets/Reinserting +IPC/HashGrowBucketsReinsert Waiting for other Parallel Hash participants to finish inserting tuples into new buckets.
changedLogicalSyncData
--- 12 +++ 13 @@ -1,2 +1,2 @@ IPC/LogicalSyncData -Waiting for logical replication remote server to send data for initial table synchronization. +Waiting for a logical replication remote server to send data for initial table synchronization.
changedLogicalSyncStateChange
--- 12 +++ 13 @@ -1,2 +1,2 @@ IPC/LogicalSyncStateChange -Waiting for logical replication remote server to change state. +Waiting for a logical replication remote server to change state.
changedMessageQueueInternal
--- 12 +++ 13 @@ -1,2 +1,2 @@ IPC/MessageQueueInternal -Waiting for other process to be attached in shared message queue. +Waiting for another process to be attached to a shared message queue.
changedProcarrayGroupUpdate
--- 12 +++ 13 @@ -1,2 +1,2 @@ IPC/ProcArrayGroupUpdate -Waiting for group leader to clear transaction id at transaction end. +Waiting for the group leader to clear the transaction ID at transaction end.
addedProcSignalBarrier
--- 12 +++ 13 @@ -0,0 +1,2 @@ +IPC/ProcSignalBarrier +Waiting for a barrier event to be processed by all backends.
addedRecoveryConflictSnapshot
--- 12 +++ 13 @@ -0,0 +1,2 @@ +IPC/RecoveryConflictSnapshot +Waiting for recovery conflict resolution for a vacuum cleanup.
addedRecoveryConflictTablespace
--- 12 +++ 13 @@ -0,0 +1,2 @@ +IPC/RecoveryConflictTablespace +Waiting for recovery conflict resolution for dropping a tablespace.
addedRecoveryPause
--- 12 +++ 13 @@ -0,0 +1,2 @@ +IPC/RecoveryPause +Waiting for recovery to be resumed.
changedReplicationOriginDrop
--- 12 +++ 13 @@ -1,2 +1,2 @@ IPC/ReplicationOriginDrop -Waiting for a replication origin to become inactive to be dropped. +Waiting for a replication origin to become inactive so it can be dropped.
changedReplicationSlotDrop
--- 12 +++ 13 @@ -1,2 +1,2 @@ IPC/ReplicationSlotDrop -Waiting for a replication slot to become inactive to be dropped. +Waiting for a replication slot to become inactive so it can be dropped.
changedSafeSnapshot
--- 12 +++ 13 @@ -1,2 +1,2 @@ IPC/SafeSnapshot -Waiting for a snapshot for a READ ONLY DEFERRABLE transaction. +Waiting to obtain a valid snapshot for a READ ONLY DEFERRABLE transaction.
changedSyncRep
--- 12 +++ 13 @@ -1,2 +1,2 @@ IPC/SyncRep -Waiting for confirmation from remote server during synchronous replication. +Waiting for confirmation from a remote server during synchronous replication.
changedXactGroupUpdate
--- 12 +++ 13 @@ -1,2 +1,2 @@ -IPC/ClogGroupUpdate -Waiting for group leader to update transaction status at transaction end. +IPC/XactGroupUpdate +Waiting for the group leader to update transaction status at transaction end.
changedpage
--- 12 +++ 13 @@ -1,2 +1,2 @@ Lock/page -Waiting to acquire a lock on page of a relation. +Waiting to acquire a lock on a page of a relation.
changedspectoken
--- 12 +++ 13 @@ -1,2 +1,2 @@ -Lock/speculative token +Lock/spectoken Waiting to acquire a speculative insertion lock.
changedvirtualxid
--- 12 +++ 13 @@ -1,2 +1,2 @@ Lock/virtualxid -Waiting to acquire a virtual xid lock. +Waiting to acquire a virtual transaction ID lock.
changedAddinShmemInit
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/AddinShmemInitLock -Waiting to manage space allocation in shared memory. +LWLock/AddinShmemInit +Waiting to manage an extension's space allocation in shared memory.
changedAutoFile
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/AutoFileLock +LWLock/AutoFile Waiting to update the postgresql.auto.conf file.
changedAutovacuum
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/AutovacuumLock -Autovacuum worker or launcher waiting to update or read the current state of autovacuum workers. +LWLock/Autovacuum +Waiting to read or update the current state of autovacuum workers.
changedAutovacuumSchedule
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/AutovacuumScheduleLock -Waiting to ensure that the table it has selected for a vacuum still needs vacuuming. +LWLock/AutovacuumSchedule +Waiting to ensure that a table selected for autovacuum still needs vacuuming.
changedBackgroundWorker
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/BackgroundWorkerLock +LWLock/BackgroundWorker Waiting to read or update background worker state.
changedBtreeVacuum
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/BtreeVacuumLock +LWLock/BtreeVacuum Waiting to read or update vacuum-related information for a B-tree index.
changedBufferContent
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/buffer_content -Waiting to read or write a data page in memory. +LWLock/BufferContent +Waiting to access a data page in memory.
changedBufferMapping
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/buffer_mapping +LWLock/BufferMapping Waiting to associate a data block with a buffer in the buffer pool.
changedCheckpoint
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/CheckpointLock -Waiting to perform checkpoint. +LWLock/Checkpoint +Waiting to begin a checkpoint.
changedCheckpointerComm
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/CheckpointerCommLock +LWLock/CheckpointerComm Waiting to manage fsync requests.
changedCommitTs
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/CommitTsLock -Waiting to read or update the last value set for the transaction timestamp. +LWLock/CommitTs +Waiting to read or update the last value set for a transaction commit timestamp.
changedCommitTsBuffer
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/commit_timestamp -Waiting for I/O on commit timestamp buffer. +LWLock/CommitTsBuffer +Waiting for I/O on a commit timestamp SLRU buffer.
changedCommitTsSLRU
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/CommitTsControlLock -Waiting to read or update transaction commit timestamps. +LWLock/CommitTsSLRU +Waiting to access the commit timestamp SLRU cache.
changedControlFile
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/ControlFileLock -Waiting to read or update the control file or creation of a new WAL file. +LWLock/ControlFile +Waiting to read or update the pg_control file or create a new WAL file.
changedDynamicSharedMemoryControl
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/DynamicSharedMemoryControlLock -Waiting to read or update dynamic shared memory state. +LWLock/DynamicSharedMemoryControl +Waiting to read or update dynamic shared memory allocation information.
changedLockFastPath
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/proc -Waiting to read or update the fast-path lock information. +LWLock/LockFastPath +Waiting to read or update a process' fast-path lock information.
changedLockManager
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/lock_manager -Waiting to add or examine locks for backends, or waiting to join or exit a locking group (used by parallel query). +LWLock/LockManager +Waiting to read or update information about “heavyweight” locks.
changedLogicalRepWorker
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/LogicalRepWorkerLock -Waiting for action on logical replication worker to finish. +LWLock/LogicalRepWorker +Waiting to read or update the state of logical replication workers.
changedMultiXactGen
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/MultiXactGenLock +LWLock/MultiXactGen Waiting to read or update shared multixact state.
changedMultiXactMemberBuffer
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/multixact_member -Waiting for I/O on a multixact_member buffer. +LWLock/MultiXactMemberBuffer +Waiting for I/O on a multixact member SLRU buffer.
changedMultiXactMemberSLRU
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/MultiXactMemberControlLock -Waiting to read or update multixact member mappings. +LWLock/MultiXactMemberSLRU +Waiting to access the multixact member SLRU cache.
changedMultiXactOffsetBuffer
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/multixact_offset -Waiting for I/O on a multixact offset buffer. +LWLock/MultiXactOffsetBuffer +Waiting for I/O on a multixact offset SLRU buffer.
changedMultiXactOffsetSLRU
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/MultiXactOffsetControlLock -Waiting to read or update multixact offset mappings. +LWLock/MultiXactOffsetSLRU +Waiting to access the multixact offset SLRU cache.
changedMultiXactTruncation
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/MultiXactTruncationLock +LWLock/MultiXactTruncation Waiting to read or truncate multixact information.
changedNotifyBuffer
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/async -Waiting for I/O on an async (notify) buffer. +LWLock/NotifyBuffer +Waiting for I/O on a NOTIFY message SLRU buffer.
changedNotifyQueue
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/AsyncQueueLock -Waiting to read or update notification messages. +LWLock/NotifyQueue +Waiting to read or update NOTIFY messages.
changedNotifyQueueTail
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/NotifyQueueTailLock -Waiting to update limit on notification message storage. +LWLock/NotifyQueueTail +Waiting to update limit on NOTIFY message storage.
changedNotifySLRU
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/AsyncCtlLock -Waiting to read or update shared notification state. +LWLock/NotifySLRU +Waiting to access the NOTIFY message SLRU cache.
changedOidGen
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/OidGenLock -Waiting to allocate or assign an OID. +LWLock/OidGen +Waiting to allocate a new OID.
changedOldSnapshotTimeMap
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/OldSnapshotTimeMapLock +LWLock/OldSnapshotTimeMap Waiting to read or update old snapshot control information.
changedParallelAppend
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/parallel_append +LWLock/ParallelAppend Waiting to choose the next subplan during Parallel Append plan execution.
changedParallelHashJoin
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/parallel_hash_join -Waiting to allocate or exchange a chunk of memory or update counters during Parallel Hash plan execution. +LWLock/ParallelHashJoin +Waiting to synchronize workers during Parallel Hash Join plan execution.
changedParallelQueryDSA
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/parallel_query_dsa -Waiting for parallel query dynamic shared memory allocation lock. +LWLock/ParallelQueryDSA +Waiting for parallel query dynamic shared memory allocation.
addedPerSessionDSA
--- 12 +++ 13 @@ -0,0 +1,2 @@ +LWLock/PerSessionDSA +Waiting for parallel query dynamic shared memory allocation.
addedPerSessionRecordType
--- 12 +++ 13 @@ -0,0 +1,2 @@ +LWLock/PerSessionRecordType +Waiting to access a parallel query's information about composite types.
addedPerSessionRecordTypmod
--- 12 +++ 13 @@ -0,0 +1,2 @@ +LWLock/PerSessionRecordTypmod +Waiting to access a parallel query's information about type modifiers that identify anonymous record types.
changedPerXactPredicateList
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/serializable_xact -Waiting to perform an operation on a serializable transaction in a parallel query. +LWLock/PerXactPredicateList +Waiting to access the list of predicate locks held by the current serializable transaction during a parallel query.
changedPredicateLockManager
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/predicate_lock_manager -Waiting to add or examine predicate lock information. +LWLock/PredicateLockManager +Waiting to access predicate lock information used by serializable transactions.
changedProcArray
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/ProcArrayLock -Waiting to get a snapshot or clearing a transaction id at transaction end. +LWLock/ProcArray +Waiting to access the shared per-process data structures (typically, to get a snapshot or report a session's transaction ID).
changedRelationMapping
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/RelationMappingLock -Waiting to update the relation map file used to store catalog to filenode mapping. +LWLock/RelationMapping +Waiting to read or update a pg_filenode.map file (used to track the filenode assignments of certain system catalogs).
changedRelCacheInit
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/RelCacheInitLock -Waiting to read or write relation cache initialization file. +LWLock/RelCacheInit +Waiting to read or update a pg_internal.init relation cache initialization file.
changedReplicationOrigin
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/ReplicationOriginLock -Waiting to setup, drop or use replication origin. +LWLock/ReplicationOrigin +Waiting to create, drop or use a replication origin.
changedReplicationOriginState
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/replication_origin -Waiting to read or update the replication progress. +LWLock/ReplicationOriginState +Waiting to read or update the progress of one replication origin.
changedReplicationSlotAllocation
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/ReplicationSlotAllocationLock +LWLock/ReplicationSlotAllocation Waiting to allocate or free a replication slot.
changedReplicationSlotControl
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/ReplicationSlotControlLock +LWLock/ReplicationSlotControl Waiting to read or update replication slot state.
changedReplicationSlotIO
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/replication_slot_io +LWLock/ReplicationSlotIO Waiting for I/O on a replication slot.
changedSerialBuffer
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/oldserxid -Waiting for I/O on an oldserxid buffer. +LWLock/SerialBuffer +Waiting for I/O on a serializable transaction conflict SLRU buffer.
changedSerializableFinishedList
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/SerializableFinishedListLock +LWLock/SerializableFinishedList Waiting to access the list of finished serializable transactions.
changedSerializablePredicateList
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/SerializablePredicateLockListLock -Waiting to perform an operation on a list of locks held by serializable transactions. +LWLock/SerializablePredicateList +Waiting to access the list of predicate locks held by serializable transactions.
changedSerializableXactHash
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/SerializableXactHashLock -Waiting to retrieve or store information about serializable transactions. +LWLock/SerializableXactHash +Waiting to read or update information about serializable transactions.
changedSerialSLRU
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/OldSerXidLock -Waiting to read or record conflicting serializable transactions. +LWLock/SerialSLRU +Waiting to access the serializable transaction conflict SLRU cache.
changedSharedTidBitmap
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/tbm -Waiting for TBM shared iterator lock. +LWLock/SharedTidBitmap +Waiting to access a shared TID bitmap during a parallel bitmap index scan.
addedSharedTupleStore
--- 12 +++ 13 @@ -0,0 +1,2 @@ +LWLock/SharedTupleStore +Waiting to access a shared tuple store during parallel query.
changedShmemIndex
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/ShmemIndexLock +LWLock/ShmemIndex Waiting to find or allocate space in shared memory.
changedSInvalRead
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/SInvalReadLock -Waiting to retrieve or remove messages from shared invalidation queue. +LWLock/SInvalRead +Waiting to retrieve messages from the shared catalog invalidation queue.
changedSInvalWrite
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/SInvalWriteLock -Waiting to add a message in shared invalidation queue. +LWLock/SInvalWrite +Waiting to add a message to the shared catalog invalidation queue.
changedSubtransBuffer
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/subtrans -Waiting for I/O a subtransaction buffer. +LWLock/SubtransBuffer +Waiting for I/O on a sub-transaction SLRU buffer.
changedSubtransSLRU
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/SubtransControlLock -Waiting to read or update sub-transaction information. +LWLock/SubtransSLRU +Waiting to access the sub-transaction SLRU cache.
changedSyncRep
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/SyncRepLock -Waiting to read or update information about synchronous replicas. +LWLock/SyncRep +Waiting to read or update information about the state of synchronous replication.
changedSyncScan
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/SyncScanLock -Waiting to get the start location of a scan on a table for synchronized scans. +LWLock/SyncScan +Waiting to select the starting location of a synchronized table scan.
changedTablespaceCreate
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/TablespaceCreateLock -Waiting to create or drop the tablespace. +LWLock/TablespaceCreate +Waiting to create or drop a tablespace.
changedTwoPhaseState
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/TwoPhaseStateLock +LWLock/TwoPhaseState Waiting to read or update the state of prepared transactions.
changedWALBufMapping
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/WALBufMappingLock +LWLock/WALBufMapping Waiting to replace a page in WAL buffers.
changedWALInsert
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/wal_insert -Waiting to insert WAL into a memory buffer. +LWLock/WALInsert +Waiting to insert WAL data into a memory buffer.
changedWALWrite
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/WALWriteLock +LWLock/WALWrite Waiting for WAL buffers to be written to disk.
changedWrapLimitsVacuum
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/WrapLimitsVacuumLock +LWLock/WrapLimitsVacuum Waiting to update limits on transaction id and multixact consumption.
changedXactBuffer
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/clog -Waiting for I/O on a clog (transaction status) buffer. +LWLock/XactBuffer +Waiting for I/O on a transaction status SLRU buffer.
changedXactSLRU
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/CLogControlLock -Waiting to read or update transaction status. +LWLock/XactSLRU +Waiting to access the transaction status SLRU cache.
changedXactTruncation
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/CLogTruncationLock -Waiting to execute txid_status or update the oldest transaction id available to it. +LWLock/XactTruncation +Waiting to execute pg_xact_status or update the oldest transaction ID available to it.
changedXidGen
--- 12 +++ 13 @@ -1,2 +1,2 @@ -LWLock/XidGenLock -Waiting to allocate or assign a transaction id. +LWLock/XidGen +Waiting to allocate a new transaction ID.
changedPgSleep
--- 12 +++ 13 @@ -1,2 +1,2 @@ Timeout/PgSleep -Waiting in process that called pg_sleep. +Waiting due to a call to pg_sleep or a sibling function.
changedRecoveryApplyDelay
--- 12 +++ 13 @@ -1,2 +1,2 @@ Timeout/RecoveryApplyDelay -Waiting to apply WAL at recovery because it is delayed. +Waiting to apply WAL during recovery because of a delay setting.
addedRecoveryRetrieveRetryInterval
--- 12 +++ 13 @@ -0,0 +1,2 @@ +Timeout/RecoveryRetrieveRetryInterval +Waiting during recovery when WAL data is not available from any source (pg_wal, archive or stream).
addedVacuumDelay
--- 12 +++ 13 @@ -0,0 +1,2 @@ +Timeout/VacuumDelay +Waiting in a cost-based vacuum delay point.