You signed in with another tab or window.Reload to refresh your session.You signed out in another tab or window.Reload to refresh your session.You switched accounts on another tab or window.Reload to refresh your session.Dismiss alert
Use more consistent names for wait event objects and types
The event names use the same case-insensitive characters, hence applyinglower() or upper() to the monitoring queries allows the detection of thesame events as before this change. It is possible to cross-check thedata with the system view pg_wait_events, for instance, with a querylike that showing no differences:SELECT lower(type), lower(name), description FROM pg_wait_events ORDER BY 1, 2;This will help in the introduction of more simplifications in the formatof wait_event_names. Some of the enum values in the code had to berenamed a bit to follow the same convention naming across the board.Reviewed-by: Bertrand DrouvotDiscussion:https://postgr.es/m/ZOxVHQwEC/9X/p/z@paquier.xyz
WAIT_EVENT_CLIENT_READClientRead"Waiting to read data from the client."
73
73
WAIT_EVENT_CLIENT_WRITEClientWrite"Waiting to write data to the client."
74
-
WAIT_EVENT_GSS_OPEN_SERVERGSSOpenServer"Waiting to read data from the client while establishing a GSSAPI session."
75
-
WAIT_EVENT_LIBPQWALRECEIVER_CONNECTLibPQWalReceiverConnect"Waiting in WAL receiver to establish connection to remote server."
76
-
WAIT_EVENT_LIBPQWALRECEIVER_RECEIVELibPQWalReceiverReceive"Waiting in WAL receiver to receive data from remote server."
77
-
WAIT_EVENT_SSL_OPEN_SERVERSSLOpenServer"Waiting for SSL while attempting connection."
78
-
WAIT_EVENT_WAL_SENDER_WAIT_WALWalSenderWaitForWAL"Waiting for WAL to be flushed in WAL sender process."
74
+
WAIT_EVENT_GSS_OPEN_SERVERGssOpenServer"Waiting to read data from the client while establishing a GSSAPI session."
75
+
WAIT_EVENT_LIBPQWALRECEIVER_CONNECTLibpqwalreceiverConnect"Waiting in WAL receiver to establish connection to remote server."
76
+
WAIT_EVENT_LIBPQWALRECEIVER_RECEIVELibpqwalreceiverReceive"Waiting in WAL receiver to receive data from remote server."
77
+
WAIT_EVENT_SSL_OPEN_SERVERSslOpenServer"Waiting for SSL while attempting connection."
78
+
WAIT_EVENT_WAL_SENDER_WAIT_FOR_WALWalSenderWaitForWal"Waiting for WAL to be flushed in WAL sender process."
79
79
WAIT_EVENT_WAL_SENDER_WRITE_DATAWalSenderWriteData"Waiting for any activity when processing replies from WAL receiver in WAL sender process."
80
80
81
81
@@ -93,10 +93,10 @@ WAIT_EVENT_ARCHIVE_CLEANUP_COMMANDArchiveCleanupCommand"Waiting for <xref link
93
93
WAIT_EVENT_ARCHIVE_COMMANDArchiveCommand"Waiting for <xref linkend="guc-archive-command"/> to complete."
94
94
WAIT_EVENT_BACKEND_TERMINATIONBackendTermination"Waiting for the termination of another backend."
95
95
WAIT_EVENT_BACKUP_WAIT_WAL_ARCHIVEBackupWaitWalArchive"Waiting for WAL files required for a backup to be successfully archived."
96
-
WAIT_EVENT_BGWORKER_SHUTDOWNBgWorkerShutdown"Waiting for background worker to shut down."
97
-
WAIT_EVENT_BGWORKER_STARTUPBgWorkerStartup"Waiting for background worker to start up."
96
+
WAIT_EVENT_BGWORKER_SHUTDOWNBgworkerShutdown"Waiting for background worker to shut down."
97
+
WAIT_EVENT_BGWORKER_STARTUPBgworkerStartup"Waiting for background worker to start up."
98
98
WAIT_EVENT_BTREE_PAGEBtreePage"Waiting for the page number needed to continue a parallel B-tree scan to become available."
99
-
WAIT_EVENT_BUFFER_IOBufferIO"Waiting for buffer I/O to complete."
99
+
WAIT_EVENT_BUFFER_IOBufferIo"Waiting for buffer I/O to complete."
100
100
WAIT_EVENT_CHECKPOINT_DONECheckpointDone"Waiting for a checkpoint to complete."
101
101
WAIT_EVENT_CHECKPOINT_STARTCheckpointStart"Waiting for a checkpoint to start."
102
102
WAIT_EVENT_EXECUTE_GATHERExecuteGather"Waiting for activity from a child process while executing a <literal>Gather</literal> plan node."
@@ -119,14 +119,14 @@ WAIT_EVENT_LOGICAL_APPLY_SEND_DATALogicalApplySendData"Waiting for a logical r
119
119
WAIT_EVENT_LOGICAL_PARALLEL_APPLY_STATE_CHANGELogicalParallelApplyStateChange"Waiting for a logical replication parallel apply process to change state."
120
120
WAIT_EVENT_LOGICAL_SYNC_DATALogicalSyncData"Waiting for a logical replication remote server to send data for initial table synchronization."
121
121
WAIT_EVENT_LOGICAL_SYNC_STATE_CHANGELogicalSyncStateChange"Waiting for a logical replication remote server to change state."
122
-
WAIT_EVENT_MQ_INTERNALMessageQueueInternal"Waiting for another process to be attached to a shared message queue."
123
-
WAIT_EVENT_MQ_PUT_MESSAGEMessageQueuePutMessage"Waiting to write a protocol message to a shared message queue."
124
-
WAIT_EVENT_MQ_RECEIVEMessageQueueReceive"Waiting to receive bytes from a shared message queue."
125
-
WAIT_EVENT_MQ_SENDMessageQueueSend"Waiting to send bytes to a shared message queue."
122
+
WAIT_EVENT_MESSAGE_QUEUE_INTERNALMessageQueueInternal"Waiting for another process to be attached to a shared message queue."
123
+
WAIT_EVENT_MESSAGE_QUEUE_PUT_MESSAGEMessageQueuePutMessage"Waiting to write a protocol message to a shared message queue."
124
+
WAIT_EVENT_MESSAGE_QUEUE_RECEIVEMessageQueueReceive"Waiting to receive bytes from a shared message queue."
125
+
WAIT_EVENT_MESSAGE_QUEUE_SENDMessageQueueSend"Waiting to send bytes to a shared message queue."
126
126
WAIT_EVENT_PARALLEL_BITMAP_SCANParallelBitmapScan"Waiting for parallel bitmap scan to become initialized."
127
127
WAIT_EVENT_PARALLEL_CREATE_INDEX_SCANParallelCreateIndexScan"Waiting for parallel <command>CREATE INDEX</command> workers to finish heap scan."
128
128
WAIT_EVENT_PARALLEL_FINISHParallelFinish"Waiting for parallel workers to finish computing."
129
-
WAIT_EVENT_PROCARRAY_GROUP_UPDATEProcArrayGroupUpdate"Waiting for the group leader to clear the transaction ID at end of a parallel operation."
129
+
WAIT_EVENT_PROCARRAY_GROUP_UPDATEProcarrayGroupUpdate"Waiting for the group leader to clear the transaction ID at end of a parallel operation."
130
130
WAIT_EVENT_PROC_SIGNAL_BARRIERProcSignalBarrier"Waiting for a barrier event to be processed by all backends."
131
131
WAIT_EVENT_PROMOTEPromote"Waiting for standby promotion."
132
132
WAIT_EVENT_RECOVERY_CONFLICT_SNAPSHOTRecoveryConflictSnapshot"Waiting for recovery conflict resolution for a vacuum cleanup."
@@ -170,12 +170,12 @@ WAIT_EVENT_VACUUM_TRUNCATEVacuumTruncate"Waiting to acquire an exclusive lock
170
170
171
171
Section: ClassName - WaitEventIO
172
172
173
-
WAIT_EVENT_BASEBACKUP_READBaseBackupRead"Waiting for base backup to read from a file."
174
-
WAIT_EVENT_BASEBACKUP_SYNCBaseBackupSync"Waiting for data written by a base backup to reach durable storage."
175
-
WAIT_EVENT_BASEBACKUP_WRITEBaseBackupWrite"Waiting for base backup to write to a file."
176
-
WAIT_EVENT_BUFFILE_READBufFileRead"Waiting for a read from a buffered file."
177
-
WAIT_EVENT_BUFFILE_WRITEBufFileWrite"Waiting for a write to a buffered file."
178
-
WAIT_EVENT_BUFFILE_TRUNCATEBufFileTruncate"Waiting for a buffered file to be truncated."
173
+
WAIT_EVENT_BASEBACKUP_READBasebackupRead"Waiting for base backup to read from a file."
174
+
WAIT_EVENT_BASEBACKUP_SYNCBasebackupSync"Waiting for data written by a base backup to reach durable storage."
175
+
WAIT_EVENT_BASEBACKUP_WRITEBasebackupWrite"Waiting for base backup to write to a file."
176
+
WAIT_EVENT_BUFFILE_READBuffileRead"Waiting for a read from a buffered file."
177
+
WAIT_EVENT_BUFFILE_WRITEBuffileWrite"Waiting for a write to a buffered file."
178
+
WAIT_EVENT_BUFFILE_TRUNCATEBuffileTruncate"Waiting for a buffered file to be truncated."
179
179
WAIT_EVENT_CONTROL_FILE_READControlFileRead"Waiting for a read from the <filename>pg_control</filename> file."
180
180
WAIT_EVENT_CONTROL_FILE_SYNCControlFileSync"Waiting for the <filename>pg_control</filename> file to reach durable storage."
181
181
WAIT_EVENT_CONTROL_FILE_SYNC_UPDATEControlFileSyncUpdate"Waiting for an update to the <filename>pg_control</filename> file to reach durable storage."
@@ -191,15 +191,15 @@ WAIT_EVENT_DATA_FILE_READDataFileRead"Waiting for a read from a relation data
191
191
WAIT_EVENT_DATA_FILE_SYNCDataFileSync"Waiting for changes to a relation data file to reach durable storage."
192
192
WAIT_EVENT_DATA_FILE_TRUNCATEDataFileTruncate"Waiting for a relation data file to be truncated."
193
193
WAIT_EVENT_DATA_FILE_WRITEDataFileWrite"Waiting for a write to a relation data file."
194
-
WAIT_EVENT_DSM_ALLOCATEDSMAllocate"Waiting for a dynamic shared memory segment to be allocated."
195
-
WAIT_EVENT_DSM_FILL_ZERO_WRITEDSMFillZeroWrite"Waiting to fill a dynamic shared memory backing file with zeroes."
196
-
WAIT_EVENT_LOCK_FILE_ADDTODATADIR_READLockFileAddToDataDirRead"Waiting for a read while adding a line to the data directory lock file."
197
-
WAIT_EVENT_LOCK_FILE_ADDTODATADIR_SYNCLockFileAddToDataDirSync"Waiting for data to reach durable storage while adding a line to the data directory lock file."
198
-
WAIT_EVENT_LOCK_FILE_ADDTODATADIR_WRITELockFileAddToDataDirWrite"Waiting for a write while adding a line to the data directory lock file."
194
+
WAIT_EVENT_DSM_ALLOCATEDsmAllocate"Waiting for a dynamic shared memory segment to be allocated."
195
+
WAIT_EVENT_DSM_FILL_ZERO_WRITEDsmFillZeroWrite"Waiting to fill a dynamic shared memory backing file with zeroes."
196
+
WAIT_EVENT_LOCK_FILE_ADDTODATADIR_READLockFileAddtodatadirRead"Waiting for a read while adding a line to the data directory lock file."
197
+
WAIT_EVENT_LOCK_FILE_ADDTODATADIR_SYNCLockFileAddtodatadirSync"Waiting for data to reach durable storage while adding a line to the data directory lock file."
198
+
WAIT_EVENT_LOCK_FILE_ADDTODATADIR_WRITELockFileAddtodatadirWrite"Waiting for a write while adding a line to the data directory lock file."
199
199
WAIT_EVENT_LOCK_FILE_CREATE_READLockFileCreateRead"Waiting to read while creating the data directory lock file."
200
200
WAIT_EVENT_LOCK_FILE_CREATE_SYNCLockFileCreateSync"Waiting for data to reach durable storage while creating the data directory lock file."
201
201
WAIT_EVENT_LOCK_FILE_CREATE_WRITELockFileCreateWrite"Waiting for a write while creating the data directory lock file."
202
-
WAIT_EVENT_LOCK_FILE_RECHECKDATADIR_READLockFileReCheckDataDirRead"Waiting for a read during recheck of the data directory lock file."
202
+
WAIT_EVENT_LOCK_FILE_RECHECKDATADIR_READLockFileRecheckdatadirRead"Waiting for a read during recheck of the data directory lock file."
203
203
WAIT_EVENT_LOGICAL_REWRITE_CHECKPOINT_SYNCLogicalRewriteCheckpointSync"Waiting for logical rewrite mappings to reach durable storage during a checkpoint."
204
204
WAIT_EVENT_LOGICAL_REWRITE_MAPPING_SYNCLogicalRewriteMappingSync"Waiting for mapping data to reach durable storage during a logical rewrite."
205
205
WAIT_EVENT_LOGICAL_REWRITE_MAPPING_WRITELogicalRewriteMappingWrite"Waiting for a write of mapping data during a logical rewrite."
@@ -216,10 +216,10 @@ WAIT_EVENT_REPLICATION_SLOT_READReplicationSlotRead"Waiting for a read from a
216
216
WAIT_EVENT_REPLICATION_SLOT_RESTORE_SYNCReplicationSlotRestoreSync"Waiting for a replication slot control file to reach durable storage while restoring it to memory."
217
217
WAIT_EVENT_REPLICATION_SLOT_SYNCReplicationSlotSync"Waiting for a replication slot control file to reach durable storage."
218
218
WAIT_EVENT_REPLICATION_SLOT_WRITEReplicationSlotWrite"Waiting for a write to a replication slot control file."
219
-
WAIT_EVENT_SLRU_FLUSH_SYNCSLRUFlushSync"Waiting for SLRU data to reach durable storage during a checkpoint or database shutdown."
220
-
WAIT_EVENT_SLRU_READSLRURead"Waiting for a read of an SLRU page."
221
-
WAIT_EVENT_SLRU_SYNCSLRUSync"Waiting for SLRU data to reach durable storage following a page write."
222
-
WAIT_EVENT_SLRU_WRITESLRUWrite"Waiting for a write of an SLRU page."
219
+
WAIT_EVENT_SLRU_FLUSH_SYNCSlruFlushSync"Waiting for SLRU data to reach durable storage during a checkpoint or database shutdown."
220
+
WAIT_EVENT_SLRU_READSlruRead"Waiting for a read of an SLRU page."
221
+
WAIT_EVENT_SLRU_SYNCSlruSync"Waiting for SLRU data to reach durable storage following a page write."
222
+
WAIT_EVENT_SLRU_WRITESlruWrite"Waiting for a write of an SLRU page."
223
223
WAIT_EVENT_SNAPBUILD_READSnapbuildRead"Waiting for a read of a serialized historical catalog snapshot."
224
224
WAIT_EVENT_SNAPBUILD_SYNCSnapbuildSync"Waiting for a serialized historical catalog snapshot to reach durable storage."
225
225
WAIT_EVENT_SNAPBUILD_WRITESnapbuildWrite"Waiting for a write of a serialized historical catalog snapshot."
@@ -232,18 +232,18 @@ WAIT_EVENT_TWOPHASE_FILE_READTwophaseFileRead"Waiting for a read of a two phas
232
232
WAIT_EVENT_TWOPHASE_FILE_SYNCTwophaseFileSync"Waiting for a two phase state file to reach durable storage."
233
233
WAIT_EVENT_TWOPHASE_FILE_WRITETwophaseFileWrite"Waiting for a write of a two phase state file."
234
234
WAIT_EVENT_VERSION_FILE_WRITEVersionFileWrite"Waiting for the version file to be written while creating a database."
235
-
WAIT_EVENT_WALSENDER_TIMELINE_HISTORY_READWALSenderTimelineHistoryRead"Waiting for a read from a timeline history file during a walsender timeline command."
236
-
WAIT_EVENT_WAL_BOOTSTRAP_SYNCWALBootstrapSync"Waiting for WAL to reach durable storage during bootstrapping."
237
-
WAIT_EVENT_WAL_BOOTSTRAP_WRITEWALBootstrapWrite"Waiting for a write of a WAL page during bootstrapping."
238
-
WAIT_EVENT_WAL_COPY_READWALCopyRead"Waiting for a read when creating a new WAL segment by copying an existing one."
239
-
WAIT_EVENT_WAL_COPY_SYNCWALCopySync"Waiting for a new WAL segment created by copying an existing one to reach durable storage."
240
-
WAIT_EVENT_WAL_COPY_WRITEWALCopyWrite"Waiting for a write when creating a new WAL segment by copying an existing one."
241
-
WAIT_EVENT_WAL_INIT_SYNCWALInitSync"Waiting for a newly initialized WAL file to reach durable storage."
242
-
WAIT_EVENT_WAL_INIT_WRITEWALInitWrite"Waiting for a write while initializing a new WAL file."
243
-
WAIT_EVENT_WAL_READWALRead"Waiting for a read from a WAL file."
244
-
WAIT_EVENT_WAL_SYNCWALSync"Waiting for a WAL file to reach durable storage."
245
-
WAIT_EVENT_WAL_SYNC_METHOD_ASSIGNWALSyncMethodAssign"Waiting for data to reach durable storage while assigning a new WAL sync method."
246
-
WAIT_EVENT_WAL_WRITEWALWrite"Waiting for a write to a WAL file."
235
+
WAIT_EVENT_WALSENDER_TIMELINE_HISTORY_READWalsenderTimelineHistoryRead"Waiting for a read from a timeline history file during a walsender timeline command."
236
+
WAIT_EVENT_WAL_BOOTSTRAP_SYNCWalBootstrapSync"Waiting for WAL to reach durable storage during bootstrapping."
237
+
WAIT_EVENT_WAL_BOOTSTRAP_WRITEWalBootstrapWrite"Waiting for a write of a WAL page during bootstrapping."
238
+
WAIT_EVENT_WAL_COPY_READWalCopyRead"Waiting for a read when creating a new WAL segment by copying an existing one."
239
+
WAIT_EVENT_WAL_COPY_SYNCWalCopySync"Waiting for a new WAL segment created by copying an existing one to reach durable storage."
240
+
WAIT_EVENT_WAL_COPY_WRITEWalCopyWrite"Waiting for a write when creating a new WAL segment by copying an existing one."
241
+
WAIT_EVENT_WAL_INIT_SYNCWalInitSync"Waiting for a newly initialized WAL file to reach durable storage."
242
+
WAIT_EVENT_WAL_INIT_WRITEWalInitWrite"Waiting for a write while initializing a new WAL file."
243
+
WAIT_EVENT_WAL_READWalRead"Waiting for a read from a WAL file."
244
+
WAIT_EVENT_WAL_SYNCWalSync"Waiting for a WAL file to reach durable storage."
245
+
WAIT_EVENT_WAL_SYNC_METHOD_ASSIGNWalSyncMethodAssign"Waiting for data to reach durable storage while assigning a new WAL sync method."
246
+
WAIT_EVENT_WAL_WRITEWalWrite"Waiting for a write to a WAL file."