WAIT EVENTS / VERSION COMPARISON
What changed?
Wait Events · PostgreSQL 9.5 → 9.6
Historical documentation for a PostgreSQL version that is no longer supported.
72 added · 0 removed · 0 changed · 0 coverage changes. These are changes in the pinned reference snapshots.
addedBufferPin
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +BufferPin/BufferPin +Waiting to acquire a pin on a buffer.
addedBufferIo
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +LWLockTranche/buffer_io +Waiting for I/O on a data page.
addedadvisory
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +Lock/advisory +Waiting to acquire an advisory user lock.
addedextend
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +Lock/extend +Waiting to extend a relation.
addedfrozenid
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +Lock/frozenid +Waiting to update pg_database.datfrozenxid and pg_database.datminmxid.
addedobject
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +Lock/object +Waiting to acquire a lock on a non-relation database object.
addedpage
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +Lock/page +Waiting to acquire a lock on page of a relation.
addedrelation
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +Lock/relation +Waiting to acquire a lock on a relation.
addedspectoken
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +Lock/speculative token +Waiting to acquire a speculative insertion lock.
addedtransactionid
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +Lock/transactionid +Waiting for a transaction to finish.
addedtuple
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +Lock/tuple +Waiting to acquire a lock on a tuple.
addeduserlock
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +Lock/userlock +Waiting to acquire a userlock.
addedvirtualxid
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +Lock/virtualxid +Waiting to acquire a virtual xid lock.
addedAddinShmemInit
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +LWLockNamed/AddinShmemInitLock +Waiting to manage space allocation in shared memory.
addedAutoFile
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +LWLockNamed/AutoFileLock +Waiting to update the postgresql.auto.conf file.
addedAutovacuum
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +LWLockNamed/AutovacuumLock +Autovacuum worker or launcher waiting to update or read the current state of autovacuum workers.
addedAutovacuumSchedule
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +LWLockNamed/AutovacuumScheduleLock +Waiting to ensure that the table it has selected for a vacuum still needs vacuuming.
addedBackgroundWorker
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +LWLockNamed/BackgroundWorkerLock +Waiting to read or update background worker state.
addedBtreeVacuum
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +LWLockNamed/BtreeVacuumLock +Waiting to read or update vacuum-related information for a B-tree index.
addedBufferContent
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +LWLockTranche/buffer_content +Waiting to read or write a data page in memory.
addedBufferMapping
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +LWLockTranche/buffer_mapping +Waiting to associate a data block with a buffer in the buffer pool.
addedCheckpoint
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +LWLockNamed/CheckpointLock +Waiting to perform checkpoint.
addedCheckpointerComm
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +LWLockNamed/CheckpointerCommLock +Waiting to manage fsync requests.
addedCommitTs
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +LWLockNamed/CommitTsLock +Waiting to read or update the last value set for the transaction timestamp.
addedCommitTsBuffer
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +LWLockTranche/commit_timestamp +Waiting for I/O on commit timestamp buffer.
addedCommitTsSLRU
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +LWLockNamed/CommitTsControlLock +Waiting to read or update transaction commit timestamps.
addedControlFile
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +LWLockNamed/ControlFileLock +Waiting to read or update the control file or creation of a new WAL file.
addedDynamicSharedMemoryControl
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +LWLockNamed/DynamicSharedMemoryControlLock +Waiting to read or update dynamic shared memory state.
addedLockFastPath
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +LWLockTranche/proc +Waiting to read or update the fast-path lock information.
addedLockManager
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +LWLockTranche/lock_manager +Waiting to add or examine locks for backends, or waiting to join or exit a locking group (used by parallel query).
addedMultiXactGen
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +LWLockNamed/MultiXactGenLock +Waiting to read or update shared multixact state.
addedMultiXactMemberBuffer
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +LWLockTranche/multixact_member +Waiting for I/O on a multixact_member buffer.
addedMultiXactMemberSLRU
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +LWLockNamed/MultiXactMemberControlLock +Waiting to read or update multixact member mappings.
addedMultiXactOffsetBuffer
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +LWLockTranche/multixact_offset +Waiting for I/O on a multixact offset buffer.
addedMultiXactOffsetSLRU
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +LWLockNamed/MultiXactOffsetControlLock +Waiting to read or update multixact offset mappings.
addedMultiXactTruncation
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +LWLockNamed/MultiXactTruncationLock +Waiting to read or truncate multixact information.
addedNotifyBuffer
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +LWLockTranche/async +Waiting for I/O on an async (notify) buffer.
addedNotifyQueue
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +LWLockNamed/AsyncQueueLock +Waiting to read or update notification messages.
addedNotifyQueueTail
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +LWLockNamed/NotifyQueueTailLock +Waiting to update limit on notification message storage.
addedNotifySLRU
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +LWLockNamed/AsyncCtlLock +Waiting to read or update shared notification state.
addedOidGen
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +LWLockNamed/OidGenLock +Waiting to allocate or assign an OID.
addedOldSnapshotTimeMap
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +LWLockNamed/OldSnapshotTimeMapLock +Waiting to read or update old snapshot control information.
addedPredicateLockManager
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +LWLockTranche/predicate_lock_manager +Waiting to add or examine predicate lock information.
addedProcArray
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +LWLockNamed/ProcArrayLock +Waiting to get a snapshot or clearing a transaction id at transaction end.
addedRelationMapping
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +LWLockNamed/RelationMappingLock +Waiting to update the relation map file used to store catalog to filenode mapping.
addedRelCacheInit
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +LWLockNamed/RelCacheInitLock +Waiting to read or write relation cache initialization file.
addedReplicationOrigin
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +LWLockNamed/ReplicationOriginLock +Waiting to setup, drop or use replication origin.
addedReplicationOriginState
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +LWLockTranche/replication_origin +Waiting to read or update the replication progress.
addedReplicationSlotAllocation
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +LWLockNamed/ReplicationSlotAllocationLock +Waiting to allocate or free a replication slot.
addedReplicationSlotControl
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +LWLockNamed/ReplicationSlotControlLock +Waiting to read or update replication slot state.
addedReplicationSlotIO
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +LWLockTranche/replication_slot_io +Waiting for I/O on a replication slot.
addedSerialBuffer
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +LWLockTranche/oldserxid +Waiting to I/O on an oldserxid buffer.
addedSerializableFinishedList
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +LWLockNamed/SerializableFinishedListLock +Waiting to access the list of finished serializable transactions.
addedSerializablePredicateList
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +LWLockNamed/SerializablePredicateLockListLock +Waiting to perform an operation on a list of locks held by serializable transactions.
addedSerializableXactHash
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +LWLockNamed/SerializableXactHashLock +Waiting to retrieve or store information about serializable transactions.
addedSerialSLRU
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +LWLockNamed/OldSerXidLock +Waiting to read or record conflicting serializable transactions.
addedShmemIndex
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +LWLockNamed/ShmemIndexLock +Waiting to find or allocate space in shared memory.
addedSInvalRead
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +LWLockNamed/SInvalReadLock +Waiting to retrieve or remove messages from shared invalidation queue.
addedSInvalWrite
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +LWLockNamed/SInvalWriteLock +Waiting to add a message in shared invalidation queue.
addedSubtransBuffer
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +LWLockTranche/subtrans +Waiting for I/O a subtransaction buffer.
addedSubtransSLRU
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +LWLockNamed/SubtransControlLock +Waiting to read or update sub-transaction information.
addedSyncRep
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +LWLockNamed/SyncRepLock +Waiting to read or update information about synchronous replicas.
addedSyncScan
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +LWLockNamed/SyncScanLock +Waiting to get the start location of a scan on a table for synchronized scans.
addedTablespaceCreate
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +LWLockNamed/TablespaceCreateLock +Waiting to create or drop the tablespace.
addedTwoPhaseState
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +LWLockNamed/TwoPhaseStateLock +Waiting to read or update the state of prepared transactions.
addedWALBufMapping
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +LWLockNamed/WALBufMappingLock +Waiting to replace a page in WAL buffers.
addedWALInsert
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +LWLockTranche/wal_insert +Waiting to insert WAL into a memory buffer.
addedWALWrite
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +LWLockNamed/WALWriteLock +Waiting for WAL buffers to be written to disk.
addedWrapLimitsVacuum
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +LWLockNamed/WrapLimitsVacuumLock +Waiting to update limits on transaction id and multixact consumption.
addedXactBuffer
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +LWLockTranche/clog +Waiting for I/O on a clog (transaction status) buffer.
addedXactSLRU
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +LWLockNamed/CLogControlLock +Waiting to read or update transaction status.
addedXidGen
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +LWLockNamed/XidGenLock +Waiting to allocate or assign a transaction id.