From 3048898e73c75f54bb259323382e0e7f6368cb6f Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Sat, 16 May 2020 21:00:05 -0400 Subject: Mop-up for wait event naming issues. Synchronize the event names for parallel hash join waits with other event names, by getting rid of the slashes and dropping "-ing" suffixes. Rename ClogGroupUpdate to XactGroupUpdate, to match the new SLRU name. Move the ProcSignalBarrier event to the IPC category; it doesn't belong under IO. Also a bit more wordsmithing in the wait event documentation tables. Discussion: https://postgr.es/m/4505.1589640417@sss.pgh.pa.us --- doc/src/sgml/monitoring.sgml | 128 ++++++++++++++++++++++++------------------- 1 file changed, 72 insertions(+), 56 deletions(-) (limited to 'doc/src') diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml index cd526128983..acc6e2bc316 100644 --- a/doc/src/sgml/monitoring.sgml +++ b/doc/src/sgml/monitoring.sgml @@ -1178,24 +1178,28 @@ postgres 27093 0.0 0.0 30096 2752 ? Ss 11:34 0:00 postgres: ser ControlFileRead - Waiting for a read from the control file. + Waiting for a read from the pg_control + file. ControlFileSync - Waiting for the control file to reach stable storage. + Waiting for the pg_control file to reach + stable storage. ControlFileSyncUpdate - Waiting for an update to the control file to reach stable - storage. + Waiting for an update to the pg_control file + to reach stable storage. ControlFileWrite - Waiting for a write to the control file. + Waiting for a write to the pg_control + file. ControlFileWriteUpdate - Waiting for a write to update the control file. + Waiting for a write to update the pg_control + file. CopyFileRead @@ -1207,8 +1211,8 @@ postgres 27093 0.0 0.0 30096 2752 ? Ss 11:34 0:00 postgres: ser DSMFillZeroWrite - Waiting to write zero bytes to a dynamic shared memory backing - file. + Waiting to fill a dynamic shared memory backing file with + zeroes. DataFileExtend @@ -1308,11 +1312,6 @@ postgres 27093 0.0 0.0 30096 2752 ? Ss 11:34 0:00 postgres: ser LogicalRewriteWrite Waiting for a write of logical rewrite mappings. - - ProcSignalBarrier - Waiting for a barrier event to be processed by all - backends. - RelationMapRead Waiting for a read of the relation map file. @@ -1464,7 +1463,7 @@ postgres 27093 0.0 0.0 30096 2752 ? Ss 11:34 0:00 postgres: ser WALSenderTimelineHistoryRead - Waiting for a read from a timeline history file during walsender + Waiting for a read from a timeline history file during a walsender timeline command. @@ -1473,8 +1472,8 @@ postgres 27093 0.0 0.0 30096 2752 ? Ss 11:34 0:00 postgres: ser WALSyncMethodAssign - Waiting for data to reach stable storage while assigning WAL sync - method. + Waiting for data to reach stable storage while assigning a new + WAL sync method. WALWrite @@ -1497,7 +1496,7 @@ postgres 27093 0.0 0.0 30096 2752 ? Ss 11:34 0:00 postgres: ser BackupWaitWalArchive - Waiting for WAL files required for the backup to be successfully + Waiting for WAL files required for a backup to be successfully archived. @@ -1521,98 +1520,100 @@ postgres 27093 0.0 0.0 30096 2752 ? Ss 11:34 0:00 postgres: ser CheckpointStart Waiting for a checkpoint to start. - - ClogGroupUpdate - Waiting for group leader to update transaction status at - transaction end. - ExecuteGather - Waiting for activity from child process while - executing Gather node. + Waiting for activity from a child process while + executing a Gather plan node. - Hash/Batch/Allocating + HashBatchAllocate Waiting for an elected Parallel Hash participant to allocate a hash table. - Hash/Batch/Electing - Electing a Parallel Hash participant to allocate a hash table. + HashBatchElect + Waiting to elect a Parallel Hash participant to allocate a hash + table. - Hash/Batch/Loading + HashBatchLoad Waiting for other Parallel Hash participants to finish loading a hash table. - Hash/Build/Allocating + HashBuildAllocate Waiting for an elected Parallel Hash participant to allocate the initial hash table. - Hash/Build/Electing - Electing a Parallel Hash participant to allocate the initial hash table. + HashBuildElect + Waiting to elect a Parallel Hash participant to allocate the + initial hash table. - Hash/Build/HashingInner + HashBuildHashInner Waiting for other Parallel Hash participants to finish hashing the inner relation. - Hash/Build/HashingOuter + HashBuildHashOuter Waiting for other Parallel Hash participants to finish partitioning the outer relation. - Hash/GrowBatches/Allocating + HashGrowBatchesAllocate Waiting for an elected Parallel Hash participant to allocate more batches. - Hash/GrowBatches/Deciding - Electing a Parallel Hash participant to decide on future batch growth. + HashGrowBatchesDecide + Waiting to elect a Parallel Hash participant to decide on future + batch growth. - Hash/GrowBatches/Electing - Electing a Parallel Hash participant to allocate more batches. + HashGrowBatchesElect + Waiting to elect a Parallel Hash participant to allocate more + batches. - Hash/GrowBatches/Finishing + HashGrowBatchesFinish Waiting for an elected Parallel Hash participant to decide on future batch growth. - Hash/GrowBatches/Repartitioning - Waiting for other Parallel Hash participants to finishing + HashGrowBatchesRepartition + Waiting for other Parallel Hash participants to finish repartitioning. - Hash/GrowBuckets/Allocating + HashGrowBucketsAllocate Waiting for an elected Parallel Hash participant to finish allocating more buckets. - Hash/GrowBuckets/Electing - Electing a Parallel Hash participant to allocate more buckets. + HashGrowBucketsElect + Waiting to elect a Parallel Hash participant to allocate more + buckets. - Hash/GrowBuckets/Reinserting + HashGrowBucketsReinsert Waiting for other Parallel Hash participants to finish inserting tuples into new buckets. LogicalSyncData - Waiting for logical replication remote server to send data for + 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. MessageQueuePutMessage @@ -1641,7 +1642,13 @@ postgres 27093 0.0 0.0 30096 2752 ? Ss 11:34 0:00 postgres: ser ProcArrayGroupUpdate - Waiting for group leader to clear transaction id at transaction end. + Waiting for the group leader to clear the transaction ID at + end of a parallel operation. + + + ProcSignalBarrier + Waiting for a barrier event to be processed by all + backends. Promote @@ -1649,11 +1656,13 @@ postgres 27093 0.0 0.0 30096 2752 ? Ss 11:34 0:00 postgres: ser RecoveryConflictSnapshot - Waiting for recovery conflict resolution on a vacuum cleanup. + Waiting for recovery conflict resolution for a vacuum + cleanup. RecoveryConflictTablespace - Waiting for recovery conflict resolution on dropping tablespace. + Waiting for recovery conflict resolution for dropping a + tablespace. RecoveryPause @@ -1661,22 +1670,29 @@ postgres 27093 0.0 0.0 30096 2752 ? Ss 11:34 0:00 postgres: ser 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 + Waiting for confirmation from a remote server during synchronous replication. + + XactGroupUpdate + Waiting for the group leader to update transaction status at + end of a parallel operation. + -- cgit v1.2.3