PostgreSQL数据库所有的等待事件讲解

• 生活家

postgresql所有的等待事件讲解

wait event type wait event name description
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.

赞 (0)
上一篇 2022年3月21日
下一篇 2022年3月21日

相关推荐