PostgreSQL 13 等待事件变动

空闲等待6

• ArchiverMain空闲等待

  Waiting in main loop of the archiver process.Waiting in main loop of archiver process.

• BgwriterMain空闲等待

  Waiting in main loop of background writer process background worker.Waiting in main loop of background writer process.

• LogicalApplyMain空闲等待

  Waiting in main loop of logical apply process.Waiting in main loop of logical replication apply process.

• LogicalLauncherMain空闲等待

  Waiting in main loop of logical launcher process.Waiting in main loop of logical replication launcher process.

• PgStatMain空闲等待

  Waiting in main loop of the statistics collector process.Waiting in main loop of statistics collector process.

• 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.

缓冲区1

• BufferPin缓冲区

  Waiting to acquire a pin on a buffer.Waiting to acquire an exclusive pin on a buffer.

客户端1

• 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.

文件 I/O9

• ControlFileRead文件 I/O

  Waiting for a read from the control file.Waiting for a read from the pg_control file.

• ControlFileSync文件 I/O

  Waiting for the control file to reach durable storage.Waiting for the pg_control file to reach durable storage.

• ControlFileSyncUpdate文件 I/O

  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.

• ControlFileWrite文件 I/O

  Waiting for a write to the control file.Waiting for a write to the pg_control file.

• ControlFileWriteUpdate文件 I/O

  Waiting for a write to update the control file.Waiting for a write to update the pg_control file.

• DsmFillZeroWrite文件 I/O

  Waiting to write zero bytes to a dynamic shared memory backing file.Waiting to fill a dynamic shared memory backing file with zeroes.

• WalCopySync文件 I/O

  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.

• WalsenderTimelineHistoryRead文件 I/O

  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.

• WalSyncMethodAssign文件 I/O

  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.

进程间16

• ExecuteGather进程间

  Waiting for activity from child process when executing Gather node.Waiting for activity from a child process while executing a Gather plan node.

• HashBatchElect进程间

  Electing a Parallel Hash participant to allocate a hash table.Waiting to elect a Parallel Hash participant to allocate a hash table.

• HashBuildElect进程间

  Electing a Parallel Hash participant to allocate the initial hash table.Waiting to elect a Parallel Hash participant to allocate the initial hash table.

• HashGrowBatchesDecide进程间

  Electing a Parallel Hash participant to decide on future batch growth.Waiting to elect a Parallel Hash participant to decide on future batch growth.

• HashGrowBatchesElect进程间

  Electing a Parallel Hash participant to allocate more batches.Waiting to elect a Parallel Hash participant to allocate more batches.

• HashGrowBatchesRepartition进程间

  Waiting for other Parallel Hash participants to finishing repartitioning.Waiting for other Parallel Hash participants to finish repartitioning.

• HashGrowBucketsElect进程间

  Electing a Parallel Hash participant to allocate more buckets.Waiting to elect a Parallel Hash participant to allocate more buckets.

• 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.

• LogicalSyncStateChange进程间

  Waiting for logical replication remote server to change state.Waiting for a logical replication remote server to change state.

• MessageQueueInternal进程间

  Waiting for other process to be attached in shared message queue.Waiting for another process to be attached to a shared message queue.

• 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.

• 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.

• 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.

• SafeSnapshot进程间

  Waiting for a snapshot for a READ ONLY DEFERRABLE transaction.Waiting to obtain a valid snapshot for a READ ONLY DEFERRABLE transaction.

• SyncRep进程间

  Waiting for confirmation from remote server during synchronous replication.Waiting for confirmation from a remote server during synchronous replication.

• XactGroupUpdate进程间

  Waiting for group leader to update transaction status at transaction end.Waiting for the group leader to update transaction status at transaction end.

重量级锁2

• page重量级锁

  Waiting to acquire a lock on page of a relation.Waiting to acquire a lock on a page of a relation.

• virtualxid重量级锁

  Waiting to acquire a virtual xid lock.Waiting to acquire a virtual transaction ID lock.

轻量级锁48

• AddinShmemInit轻量级锁

  Waiting to manage space allocation in shared memory.Waiting to manage an extension's space allocation in shared memory.

• Autovacuum轻量级锁

  Autovacuum worker or launcher waiting to update or read the current state of autovacuum workers.Waiting to read or update the current state of autovacuum workers.

• AutovacuumSchedule轻量级锁

  Waiting to ensure that the table it has selected for a vacuum still needs vacuuming.Waiting to ensure that a table selected for autovacuum still needs vacuuming.

• BufferContent轻量级锁

  Waiting to read or write a data page in memory.Waiting to access a data page in memory.

• Checkpoint轻量级锁

  Waiting to perform checkpoint.Waiting to begin a checkpoint.

• CommitTs轻量级锁

  Waiting to read or update the last value set for the transaction timestamp.Waiting to read or update the last value set for a transaction commit timestamp.

• CommitTsBuffer轻量级锁

  Waiting for I/O on commit timestamp buffer.Waiting for I/O on a commit timestamp SLRU buffer.

• CommitTsSLRU轻量级锁

  Waiting to read or update transaction commit timestamps.Waiting to access the commit timestamp SLRU cache.

• ControlFile轻量级锁

  Waiting to read or update the control file or creation of a new WAL file.Waiting to read or update the pg_control file or create a new WAL file.

• DynamicSharedMemoryControl轻量级锁

  Waiting to read or update dynamic shared memory state.Waiting to read or update dynamic shared memory allocation information.

• LockFastPath轻量级锁

  Waiting to read or update the fast-path lock information.Waiting to read or update a process' fast-path lock information.

• LockManager轻量级锁

  Waiting to add or examine locks for backends, or waiting to join or exit a locking group (used by parallel query).Waiting to read or update information about “heavyweight” locks.

• LogicalRepWorker轻量级锁

  Waiting for action on logical replication worker to finish.Waiting to read or update the state of logical replication workers.

• MultiXactMemberBuffer轻量级锁

  Waiting for I/O on a multixact_member buffer.Waiting for I/O on a multixact member SLRU buffer.

• MultiXactMemberSLRU轻量级锁

  Waiting to read or update multixact member mappings.Waiting to access the multixact member SLRU cache.

• MultiXactOffsetBuffer轻量级锁

  Waiting for I/O on a multixact offset buffer.Waiting for I/O on a multixact offset SLRU buffer.

• MultiXactOffsetSLRU轻量级锁

  Waiting to read or update multixact offset mappings.Waiting to access the multixact offset SLRU cache.

• NotifyBuffer轻量级锁

  Waiting for I/O on an async (notify) buffer.Waiting for I/O on a NOTIFY message SLRU buffer.

• NotifyQueue轻量级锁

  Waiting to read or update notification messages.Waiting to read or update NOTIFY messages.

• NotifyQueueTail轻量级锁

  Waiting to update limit on notification message storage.Waiting to update limit on NOTIFY message storage.

• NotifySLRU轻量级锁

  Waiting to read or update shared notification state.Waiting to access the NOTIFY message SLRU cache.

• OidGen轻量级锁

  Waiting to allocate or assign an OID.Waiting to allocate a new OID.

• ParallelHashJoin轻量级锁

  Waiting to allocate or exchange a chunk of memory or update counters during Parallel Hash plan execution.Waiting to synchronize workers during Parallel Hash Join plan execution.

• ParallelQueryDSA轻量级锁

  Waiting for parallel query dynamic shared memory allocation lock.Waiting for parallel query dynamic shared memory allocation.

• PerXactPredicateList轻量级锁

  Waiting to perform an operation on a serializable transaction in a parallel query.Waiting to access the list of predicate locks held by the current serializable transaction during a parallel query.

• PredicateLockManager轻量级锁

  Waiting to add or examine predicate lock information.Waiting to access predicate lock information used by serializable transactions.

• ProcArray轻量级锁

  Waiting to get a snapshot or clearing a transaction id at transaction end.Waiting to access the shared per-process data structures (typically, to get a snapshot or report a session's transaction ID).

• RelationMapping轻量级锁

  Waiting to update the relation map file used to store catalog to filenode mapping.Waiting to read or update a pg_filenode.map file (used to track the filenode assignments of certain system catalogs).

• RelCacheInit轻量级锁

  Waiting to read or write relation cache initialization file.Waiting to read or update a pg_internal.init relation cache initialization file.

• ReplicationOrigin轻量级锁

  Waiting to setup, drop or use replication origin.Waiting to create, drop or use a replication origin.

• ReplicationOriginState轻量级锁

  Waiting to read or update the replication progress.Waiting to read or update the progress of one replication origin.

• SerialBuffer轻量级锁

  Waiting for I/O on an oldserxid buffer.Waiting for I/O on a serializable transaction conflict SLRU buffer.

• SerializablePredicateList轻量级锁

  Waiting to perform an operation on a list of locks held by serializable transactions.Waiting to access the list of predicate locks held by serializable transactions.

• SerializableXactHash轻量级锁

  Waiting to retrieve or store information about serializable transactions.Waiting to read or update information about serializable transactions.

• SerialSLRU轻量级锁

  Waiting to read or record conflicting serializable transactions.Waiting to access the serializable transaction conflict SLRU cache.

• SharedTidBitmap轻量级锁

  Waiting for TBM shared iterator lock.Waiting to access a shared TID bitmap during a parallel bitmap index scan.

• SInvalRead轻量级锁

  Waiting to retrieve or remove messages from shared invalidation queue.Waiting to retrieve messages from the shared catalog invalidation queue.

• SInvalWrite轻量级锁

  Waiting to add a message in shared invalidation queue.Waiting to add a message to the shared catalog invalidation queue.

• SubtransBuffer轻量级锁

  Waiting for I/O a subtransaction buffer.Waiting for I/O on a sub-transaction SLRU buffer.

• SubtransSLRU轻量级锁

  Waiting to read or update sub-transaction information.Waiting to access the sub-transaction SLRU cache.

• SyncRep轻量级锁

  Waiting to read or update information about synchronous replicas.Waiting to read or update information about the state of synchronous replication.

• SyncScan轻量级锁

  Waiting to get the start location of a scan on a table for synchronized scans.Waiting to select the starting location of a synchronized table scan.

• TablespaceCreate轻量级锁

  Waiting to create or drop the tablespace.Waiting to create or drop a tablespace.

• WALInsert轻量级锁

  Waiting to insert WAL into a memory buffer.Waiting to insert WAL data into a memory buffer.

• XactBuffer轻量级锁

  Waiting for I/O on a clog (transaction status) buffer.Waiting for I/O on a transaction status SLRU buffer.

• XactSLRU轻量级锁

  Waiting to read or update transaction status.Waiting to access the transaction status SLRU cache.

• XactTruncation轻量级锁

  Waiting to execute txid_status or update the oldest transaction id available to it.Waiting to execute pg_xact_status or update the oldest transaction ID available to it.

• XidGen轻量级锁

  Waiting to allocate or assign a transaction id.Waiting to allocate a new transaction ID.

超时2

• PgSleep超时

  Waiting in process that called pg_sleep.Waiting due to a call to pg_sleep or a sibling function.

• RecoveryApplyDelay超时

  Waiting to apply WAL at recovery because it is delayed.Waiting to apply WAL during recovery because of a delay setting.