LWLock |
ShmemIndexLock |
Waiting to find or allocate space in shared memory. |
OidGenLock |
Waiting to allocate or assign an OID. |
XidGenLock |
Waiting to allocate or assign a transaction id. |
ProcArrayLock |
Waiting to get a snapshot or clearing a transaction id at transaction end. |
SInvalReadLock |
Waiting to retrieve or remove messages from shared invalidation queue. |
SInvalWriteLock |
Waiting to add a message in shared invalidation queue. |
WALBufMappingLock |
Waiting to replace a page in WAL buffers. |
WALWriteLock |
Waiting for WAL buffers to be written to disk. |
ControlFileLock |
Waiting to read or update the control file or creation of a new WAL file. |
CheckpointLock |
Waiting to perform checkpoint. |
CLogControlLock |
Waiting to read or update transaction status. |
SubtransControlLock |
Waiting to read or update sub-transaction information. |
MultiXactGenLock |
Waiting to read or update shared multixact state. |
MultiXactOffsetControlLock |
Waiting to read or update multixact offset mappings. |
MultiXactMemberControlLock |
Waiting to read or update multixact member mappings. |
RelCacheInitLock |
Waiting to read or write relation cache initialization file. |
CheckpointerCommLock |
Waiting to manage fsync requests. |
TwoPhaseStateLock |
Waiting to read or update the state of prepared transactions. |
TablespaceCreateLock |
Waiting to create or drop the tablespace. |
BtreeVacuumLock |
Waiting to read or update vacuum-related information for a B-tree index. |
AddinShmemInitLock |
Waiting to manage space allocation in shared memory. |
AutovacuumLock |
Autovacuum worker or launcher waiting to update or read the current state of autovacuum workers. |
AutovacuumScheduleLock |
Waiting to ensure that the table it has selected for a vacuum still needs vacuuming. |
SyncScanLock |
Waiting to get the start location of a scan on a table for synchronized scans. |
RelationMappingLock |
Waiting to update the relation map file used to store catalog to filenode mapping. |
AsyncCtlLock |
Waiting to read or update shared notification state. |
AsyncQueueLock |
Waiting to read or update notification messages. |
SerializableXactHashLock |
Waiting to retrieve or store information about serializable transactions. |
SerializableFinishedListLock |
Waiting to access the list of finished serializable transactions. |
SerializablePredicateLockListLock |
Waiting to perform an operation on a list of locks held by serializable transactions. |
OldSerXidLock |
Waiting to read or record conflicting serializable transactions. |
SyncRepLock |
Waiting to read or update information about synchronous replicas. |
BackgroundWorkerLock |
Waiting to read or update background worker state. |
DynamicSharedMemoryControlLock |
Waiting to read or update dynamic shared memory state. |
AutoFileLock |
Waiting to update the postgresql.auto.conf file. |
ReplicationSlotAllocationLock |
Waiting to allocate or free a replication slot. |
ReplicationSlotControlLock |
Waiting to read or update replication slot state. |
CommitTsControlLock |
Waiting to read or update transaction commit timestamps. |
CommitTsLock |
Waiting to read or update the last value set for the transaction timestamp. |
ReplicationOriginLock |
Waiting to setup, drop or use replication origin. |
MultiXactTruncationLock |
Waiting to read or truncate multixact information. |
OldSnapshotTimeMapLock |
Waiting to read or update old snapshot control information. |
BackendRandomLock |
Waiting to generate a random number. |
LogicalRepWorkerLock |
Waiting for action on logical replication worker to finish. |
CLogTruncationLock |
Waiting to truncate the write-ahead log or waiting for write-ahead log truncation to finish. |
clog |
Waiting for I/O on a clog (transaction status) buffer. |
commit_timestamp |
Waiting for I/O on commit timestamp buffer. |
subtrans |
Waiting for I/O a subtransaction buffer. |
multixact_offset |
Waiting for I/O on a multixact offset buffer. |
multixact_member |
Waiting for I/O on a multixact_member buffer. |
async |
Waiting for I/O on an async (notify) buffer. |
oldserxid |
Waiting to I/O on an oldserxid buffer. |
wal_insert |
Waiting to insert WAL into a memory buffer. |
buffer_content |
Waiting to read or write a data page in memory. |
buffer_io |
Waiting for I/O on a data page. |
replication_origin |
Waiting to read or update the replication progress. |
replication_slot_io |
Waiting for I/O on a replication slot. |
proc |
Waiting to read or update the fast-path lock information. |
buffer_mapping |
Waiting to associate a data block with a buffer in the buffer pool. |
lock_manager |
Waiting to add or examine locks for backends, or waiting to join or exit a locking group (used by parallel query). |
predicate_lock_manager |
Waiting to add or examine predicate lock information. |
parallel_query_dsa |
Waiting for parallel query dynamic shared memory allocation lock. |
tbm |
Waiting for TBM shared iterator lock. |
Lock |
relation |
Waiting to acquire a lock on a relation. |
extend |
Waiting to extend a relation. |
page |
Waiting to acquire a lock on page of a relation. |
tuple |
Waiting to acquire a lock on a tuple. |
transactionid |
Waiting for a transaction to finish. |
virtualxid |
Waiting to acquire a virtual xid lock. |
speculative token |
Waiting to acquire a speculative insertion lock. |
object |
Waiting to acquire a lock on a non-relation database object. |
userlock |
Waiting to acquire a user lock. |
advisory |
Waiting to acquire an advisory user lock. |
BufferPin |
BufferPin |
Waiting to acquire a pin on a buffer. |
Activity |
ArchiverMain |
Waiting in main loop of the archiver process. |
AutoVacuumMain |
Waiting in main loop of autovacuum launcher process. |
BgWriterHibernate |
Waiting in background writer process, hibernating. |
BgWriterMain |
Waiting in main loop of background writer process background worker. |
CheckpointerMain |
Waiting in main loop of checkpointer process. |
LogicalLauncherMain |
Waiting in main loop of logical launcher process. |
LogicalApplyMain |
Waiting in main loop of logical apply process. |
PgStatMain |
Waiting in main loop of the statistics collector process. |
RecoveryWalAll |
Waiting for WAL from any kind of source (local, archive or stream) at recovery. |
RecoveryWalStream |
Waiting for WAL from a stream at recovery. |
SysLoggerMain |
Waiting in main loop of syslogger process. |
WalReceiverMain |
Waiting in main loop of WAL receiver process. |
WalSenderMain |
Waiting in main loop of WAL sender process. |
WalWriterMain |
Waiting in main loop of WAL writer process. |
Client |
ClientRead |
Waiting to read data from the client. |
ClientWrite |
Waiting to write data from the client. |
LibPQWalReceiverConnect |
Waiting in WAL receiver to establish connection to remote server. |
LibPQWalReceiverReceive |
Waiting in WAL receiver to receive data from remote server. |
SSLOpenServer |
Waiting for SSL while attempting connection. |
WalReceiverWaitStart |
Waiting for startup process to send initial data for streaming replication. |
WalSenderWaitForWAL |
Waiting for WAL to be flushed in WAL sender process. |
WalSenderWriteData |
Waiting for any activity when processing replies from WAL receiver in WAL sender process. |
Extension |
Extension |
Waiting in an extension. |
IPC |
BgWorkerShutdown |
Waiting for background worker to shut down. |
BgWorkerStartup |
Waiting for background worker to start up. |
BtreePage |
Waiting for the page number needed to continue a parallel B-tree scan to become available. |
ExecuteGather |
Waiting for activity from child process when executing Gather node. |
LogicalSyncData |
Waiting for logical replication remote server to send data for initial table synchronization. |
LogicalSyncStateChange |
Waiting for logical replication remote server to change state. |
MessageQueueInternal |
Waiting for other process to be attached in shared message queue. |
MessageQueuePutMessage |
Waiting to write a protocol message to a shared message queue. |
MessageQueueReceive |
Waiting to receive bytes from a shared message queue. |
MessageQueueSend |
Waiting to send bytes to a shared message queue. |
ParallelFinish |
Waiting for parallel workers to finish computing. |
ParallelBitmapScan |
Waiting for parallel bitmap scan to become initialized. |
ProcArrayGroupUpdate |
Waiting for group leader to clear transaction id at transaction end. |
ReplicationOriginDrop |
Waiting for a replication origin to become inactive to be dropped. |
ReplicationSlotDrop |
Waiting for a replication slot to become inactive to be dropped. |
SafeSnapshot |
Waiting for a snapshot for a READ ONLY DEFERRABLE transaction. |
SyncRep |
Waiting for confirmation from remote server during synchronous replication. |
Timeout |
BaseBackupThrottle |
Waiting during base backup when throttling activity. |
PgSleep |
Waiting in process that called pg_sleep . |
RecoveryApplyDelay |
Waiting to apply WAL at recovery because it is delayed. |
IO |
BufFileRead |
Waiting for a read from a buffered file. |
BufFileWrite |
Waiting for a write to a buffered file. |
ControlFileRead |
Waiting for a read from the control file. |
ControlFileSync |
Waiting for the control file to reach stable storage. |
ControlFileSyncUpdate |
Waiting for an update to the control file to reach stable storage. |
ControlFileWrite |
Waiting for a write to the control file. |
ControlFileWriteUpdate |
Waiting for a write to update the control file. |
CopyFileRead |
Waiting for a read during a file copy operation. |
CopyFileWrite |
Waiting for a write during a file copy operation. |
DataFileExtend |
Waiting for a relation data file to be extended. |
DataFileFlush |
Waiting for a relation data file to reach stable storage. |
DataFileImmediateSync |
Waiting for an immediate synchronization of a relation data file to stable storage. |
DataFilePrefetch |
Waiting for an asynchronous prefetch from a relation data file. |
DataFileRead |
Waiting for a read from a relation data file. |
DataFileSync |
Waiting for changes to a relation data file to reach stable storage. |
DataFileTruncate |
Waiting for a relation data file to be truncated. |
DataFileWrite |
Waiting for a write to a relation data file. |
DSMFillZeroWrite |
Waiting to write zero bytes to a dynamic shared memory backing file. |
LockFileAddToDataDirRead |
Waiting for a read while adding a line to the data directory lock file. |
LockFileAddToDataDirSync |
Waiting for data to reach stable storage while adding a line to the data directory lock file. |
LockFileAddToDataDirWrite |
Waiting for a write while adding a line to the data directory lock file. |
LockFileCreateRead |
Waiting to read while creating the data directory lock file. |
LockFileCreateSync |
Waiting for data to reach stable storage while creating the data directory lock file. |
LockFileCreateWrite |
Waiting for a write while creating the data directory lock file. |
LockFileReCheckDataDirRead |
Waiting for a read during recheck of the data directory lock file. |
LogicalRewriteCheckpointSync |
Waiting for logical rewrite mappings to reach stable storage during a checkpoint. |
LogicalRewriteMappingSync |
Waiting for mapping data to reach stable storage during a logical rewrite. |
LogicalRewriteMappingWrite |
Waiting for a write of mapping data during a logical rewrite. |
LogicalRewriteSync |
Waiting for logical rewrite mappings to reach stable storage. |
LogicalRewriteWrite |
Waiting for a write of logical rewrite mappings. |
RelationMapRead |
Waiting for a read of the relation map file. |
RelationMapSync |
Waiting for the relation map file to reach stable storage. |
RelationMapWrite |
Waiting for a write to the relation map file. |
ReorderBufferRead |
Waiting for a read during reorder buffer management. |
ReorderBufferWrite |
Waiting for a write during reorder buffer management. |
ReorderLogicalMappingRead |
Waiting for a read of a logical mapping during reorder buffer management. |
ReplicationSlotRead |
Waiting for a read from a replication slot control file. |
ReplicationSlotRestoreSync |
Waiting for a replication slot control file to reach stable storage while restoring it to memory. |
ReplicationSlotSync |
Waiting for a replication slot control file to reach stable storage. |
ReplicationSlotWrite |
Waiting for a write to a replication slot control file. |
SLRUFlushSync |
Waiting for SLRU data to reach stable storage during a checkpoint or database shutdown. |
SLRURead |
Waiting for a read of an SLRU page. |
SLRUSync |
Waiting for SLRU data to reach stable storage following a page write. |
SLRUWrite |
Waiting for a write of an SLRU page. |
SnapbuildRead |
Waiting for a read of a serialized historical catalog snapshot. |
SnapbuildSync |
Waiting for a serialized historical catalog snapshot to reach stable storage. |
SnapbuildWrite |
Waiting for a write of a serialized historical catalog snapshot. |
TimelineHistoryFileSync |
Waiting for a timeline history file received via streaming replication to reach stable storage. |
TimelineHistoryFileWrite |
Waiting for a write of a timeline history file received via streaming replication. |
TimelineHistoryRead |
Waiting for a read of a timeline history file. |
TimelineHistorySync |
Waiting for a newly created timeline history file to reach stable storage. |
TimelineHistoryWrite |
Waiting for a write of a newly created timeline history file. |
TwophaseFileRead |
Waiting for a read of a two phase state file. |
TwophaseFileSync |
Waiting for a two phase state file to reach stable storage. |
TwophaseFileWrite |
Waiting for a write of a two phase state file. |
WALBootstrapSync |
Waiting for WAL to reach stable storage during bootstrapping. |
WALBootstrapWrite |
Waiting for a write of a WAL page during bootstrapping. |
WALCopyRead |
Waiting for a read when creating a new WAL segment by copying an existing one. |
WALCopySync |
Waiting a new WAL segment created by copying an existing one to reach stable storage. |
WALCopyWrite |
Waiting for a write when creating a new WAL segment by copying an existing one. |
WALInitSync |
Waiting for a newly initialized WAL file to reach stable storage. |
WALInitWrite |
Waiting for a write while initializing a new WAL file. |
WALRead |
Waiting for a read from a WAL file. |
WALSenderTimelineHistoryRead |
Waiting for a read from a timeline history file during walsender timeline command. |
WALSyncMethodAssign |
Waiting for data to reach stable storage while assigning WAL sync method. |
WALWrite |
Waiting for a write to a WAL file. |