From 030273b7ea468ed4b3073dfd1f2ad88e3129df6a Mon Sep 17 00:00:00 2001 From: Alvaro Herrera Date: Tue, 8 Aug 2017 15:37:44 -0400 Subject: Fix inadequacies in recently added wait events In commit 9915de6c1cb2, we introduced a new wait point for replication slots and incorrectly labelled it as wait event PG_WAIT_LOCK. That's wrong, so invent an appropriate new wait event instead, and document it properly. While at it, fix numerous other problems in the vicinity: - two different walreceiver wait events were being mixed up in a single wait event (which wasn't documented either); split it out so that they can be distinguished, and document the new events properly. - ParallelBitmapPopulate was documented but didn't exist. - ParallelBitmapScan was not documented (I think this should be called "ParallelBitmapScanInit" instead.) - Logical replication wait events weren't documented - various symbols had been added in dartboard order in various places. Put them in alphabetical order instead, as was originally intended. Discussion: https://postgr.es/m/20170808181131.mu4fjepuh5m75cyq@alvherre.pgsql --- doc/src/sgml/monitoring.sgml | 32 ++++++++++++++++++++++++++++++-- 1 file changed, 30 insertions(+), 2 deletions(-) (limited to 'doc/src') diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml index be3dc672bcc..eb20c9c543b 100644 --- a/doc/src/sgml/monitoring.sgml +++ b/doc/src/sgml/monitoring.sgml @@ -1175,6 +1175,14 @@ postgres 27093 0.0 0.0 30096 2752 ? Ss 11:34 0:00 postgres: ser 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. @@ -1212,6 +1220,14 @@ postgres 27093 0.0 0.0 30096 2752 ? Ss 11:34 0:00 postgres: ser 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. @@ -1250,6 +1266,14 @@ postgres 27093 0.0 0.0 30096 2752 ? Ss 11:34 0:00 postgres: ser 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. @@ -1271,13 +1295,17 @@ postgres 27093 0.0 0.0 30096 2752 ? Ss 11:34 0:00 postgres: ser Waiting for parallel workers to finish computing. - ParallelBitmapPopulate - Waiting for the leader to populate the TidBitmap. + ParallelBitmapScan + Waiting for parallel bitmap scan to become initialized. ProcArrayGroupUpdate Waiting for group leader to clear transaction id at transaction end. + + ReplicationSlotDrop + Waiting for a replication slot to become inactive to be dropped. + SafeSnapshot Waiting for a snapshot for a READ ONLY DEFERRABLE transaction. -- cgit v1.2.3