PostgreSQL Source Code  git master
wait_event.c
Go to the documentation of this file.
1 /* ----------
2  * wait_event.c
3  * Wait event reporting infrastructure.
4  *
5  * Copyright (c) 2001-2023, PostgreSQL Global Development Group
6  *
7  *
8  * IDENTIFICATION
9  * src/backend/utils/activity/wait_event.c
10  *
11  * NOTES
12  *
13  * To make pgstat_report_wait_start() and pgstat_report_wait_end() as
14  * lightweight as possible, they do not check if shared memory (MyProc
15  * specifically, where the wait event is stored) is already available. Instead
16  * we initially set my_wait_event_info to a process local variable, which then
17  * is redirected to shared memory using pgstat_set_wait_event_storage(). For
18  * the same reason pgstat_track_activities is not checked - the check adds
19  * more work than it saves.
20  *
21  * ----------
22  */
23 #include "postgres.h"
24 
25 #include "storage/lmgr.h" /* for GetLockNameFromTagType */
26 #include "storage/lwlock.h" /* for GetLWLockIdentifier */
27 #include "utils/wait_event.h"
28 
29 
30 static const char *pgstat_get_wait_activity(WaitEventActivity w);
31 static const char *pgstat_get_wait_client(WaitEventClient w);
32 static const char *pgstat_get_wait_ipc(WaitEventIPC w);
33 static const char *pgstat_get_wait_timeout(WaitEventTimeout w);
34 static const char *pgstat_get_wait_io(WaitEventIO w);
35 
36 
39 
40 
41 /*
42  * Configure wait event reporting to report wait events to *wait_event_info.
43  * *wait_event_info needs to be valid until pgstat_reset_wait_event_storage()
44  * is called.
45  *
46  * Expected to be called during backend startup, to point my_wait_event_info
47  * into shared memory.
48  */
49 void
51 {
52  my_wait_event_info = wait_event_info;
53 }
54 
55 /*
56  * Reset wait event storage location.
57  *
58  * Expected to be called during backend shutdown, before the location set up
59  * pgstat_set_wait_event_storage() becomes invalid.
60  */
61 void
63 {
65 }
66 
67 /* ----------
68  * pgstat_get_wait_event_type() -
69  *
70  * Return a string representing the current wait event type, backend is
71  * waiting on.
72  */
73 const char *
75 {
76  uint32 classId;
77  const char *event_type;
78 
79  /* report process as not waiting. */
80  if (wait_event_info == 0)
81  return NULL;
82 
83  classId = wait_event_info & 0xFF000000;
84 
85  switch (classId)
86  {
87  case PG_WAIT_LWLOCK:
88  event_type = "LWLock";
89  break;
90  case PG_WAIT_LOCK:
91  event_type = "Lock";
92  break;
93  case PG_WAIT_BUFFER_PIN:
94  event_type = "BufferPin";
95  break;
96  case PG_WAIT_ACTIVITY:
97  event_type = "Activity";
98  break;
99  case PG_WAIT_CLIENT:
100  event_type = "Client";
101  break;
102  case PG_WAIT_EXTENSION:
103  event_type = "Extension";
104  break;
105  case PG_WAIT_IPC:
106  event_type = "IPC";
107  break;
108  case PG_WAIT_TIMEOUT:
109  event_type = "Timeout";
110  break;
111  case PG_WAIT_IO:
112  event_type = "IO";
113  break;
114  default:
115  event_type = "???";
116  break;
117  }
118 
119  return event_type;
120 }
121 
122 /* ----------
123  * pgstat_get_wait_event() -
124  *
125  * Return a string representing the current wait event, backend is
126  * waiting on.
127  */
128 const char *
130 {
131  uint32 classId;
132  uint16 eventId;
133  const char *event_name;
134 
135  /* report process as not waiting. */
136  if (wait_event_info == 0)
137  return NULL;
138 
139  classId = wait_event_info & 0xFF000000;
140  eventId = wait_event_info & 0x0000FFFF;
141 
142  switch (classId)
143  {
144  case PG_WAIT_LWLOCK:
145  event_name = GetLWLockIdentifier(classId, eventId);
146  break;
147  case PG_WAIT_LOCK:
148  event_name = GetLockNameFromTagType(eventId);
149  break;
150  case PG_WAIT_BUFFER_PIN:
151  event_name = "BufferPin";
152  break;
153  case PG_WAIT_ACTIVITY:
154  {
155  WaitEventActivity w = (WaitEventActivity) wait_event_info;
156 
157  event_name = pgstat_get_wait_activity(w);
158  break;
159  }
160  case PG_WAIT_CLIENT:
161  {
162  WaitEventClient w = (WaitEventClient) wait_event_info;
163 
164  event_name = pgstat_get_wait_client(w);
165  break;
166  }
167  case PG_WAIT_EXTENSION:
168  event_name = "Extension";
169  break;
170  case PG_WAIT_IPC:
171  {
172  WaitEventIPC w = (WaitEventIPC) wait_event_info;
173 
174  event_name = pgstat_get_wait_ipc(w);
175  break;
176  }
177  case PG_WAIT_TIMEOUT:
178  {
179  WaitEventTimeout w = (WaitEventTimeout) wait_event_info;
180 
181  event_name = pgstat_get_wait_timeout(w);
182  break;
183  }
184  case PG_WAIT_IO:
185  {
186  WaitEventIO w = (WaitEventIO) wait_event_info;
187 
188  event_name = pgstat_get_wait_io(w);
189  break;
190  }
191  default:
192  event_name = "unknown wait event";
193  break;
194  }
195 
196  return event_name;
197 }
198 
199 /* ----------
200  * pgstat_get_wait_activity() -
201  *
202  * Convert WaitEventActivity to string.
203  * ----------
204  */
205 static const char *
207 {
208  const char *event_name = "unknown wait event";
209 
210  switch (w)
211  {
213  event_name = "ArchiverMain";
214  break;
216  event_name = "AutoVacuumMain";
217  break;
219  event_name = "BgWriterHibernate";
220  break;
222  event_name = "BgWriterMain";
223  break;
225  event_name = "CheckpointerMain";
226  break;
228  event_name = "LogicalApplyMain";
229  break;
231  event_name = "LogicalLauncherMain";
232  break;
234  event_name = "LogicalParallelApplyMain";
235  break;
237  event_name = "RecoveryWalStream";
238  break;
240  event_name = "SysLoggerMain";
241  break;
243  event_name = "WalReceiverMain";
244  break;
246  event_name = "WalSenderMain";
247  break;
249  event_name = "WalWriterMain";
250  break;
251  /* no default case, so that compiler will warn */
252  }
253 
254  return event_name;
255 }
256 
257 /* ----------
258  * pgstat_get_wait_client() -
259  *
260  * Convert WaitEventClient to string.
261  * ----------
262  */
263 static const char *
265 {
266  const char *event_name = "unknown wait event";
267 
268  switch (w)
269  {
271  event_name = "ClientRead";
272  break;
274  event_name = "ClientWrite";
275  break;
277  event_name = "GSSOpenServer";
278  break;
280  event_name = "LibPQWalReceiverConnect";
281  break;
283  event_name = "LibPQWalReceiverReceive";
284  break;
286  event_name = "SSLOpenServer";
287  break;
289  event_name = "WalSenderWaitForWAL";
290  break;
292  event_name = "WalSenderWriteData";
293  break;
294  /* no default case, so that compiler will warn */
295  }
296 
297  return event_name;
298 }
299 
300 /* ----------
301  * pgstat_get_wait_ipc() -
302  *
303  * Convert WaitEventIPC to string.
304  * ----------
305  */
306 static const char *
308 {
309  const char *event_name = "unknown wait event";
310 
311  switch (w)
312  {
314  event_name = "AppendReady";
315  break;
317  event_name = "ArchiveCleanupCommand";
318  break;
320  event_name = "ArchiveCommand";
321  break;
323  event_name = "BackendTermination";
324  break;
326  event_name = "BackupWaitWalArchive";
327  break;
329  event_name = "BgWorkerShutdown";
330  break;
332  event_name = "BgWorkerStartup";
333  break;
335  event_name = "BtreePage";
336  break;
338  event_name = "BufferIO";
339  break;
341  event_name = "CheckpointDone";
342  break;
344  event_name = "CheckpointStart";
345  break;
347  event_name = "ExecuteGather";
348  break;
350  event_name = "HashBatchAllocate";
351  break;
353  event_name = "HashBatchElect";
354  break;
356  event_name = "HashBatchLoad";
357  break;
359  event_name = "HashBuildAllocate";
360  break;
362  event_name = "HashBuildElect";
363  break;
365  event_name = "HashBuildHashInner";
366  break;
368  event_name = "HashBuildHashOuter";
369  break;
371  event_name = "HashGrowBatchesDecide";
372  break;
374  event_name = "HashGrowBatchesElect";
375  break;
377  event_name = "HashGrowBatchesFinish";
378  break;
380  event_name = "HashGrowBatchesReallocate";
381  break;
383  event_name = "HashGrowBatchesRepartition";
384  break;
386  event_name = "HashGrowBucketsElect";
387  break;
389  event_name = "HashGrowBucketsReallocate";
390  break;
392  event_name = "HashGrowBucketsReinsert";
393  break;
395  event_name = "LogicalApplySendData";
396  break;
398  event_name = "LogicalParallelApplyStateChange";
399  break;
401  event_name = "LogicalSyncData";
402  break;
404  event_name = "LogicalSyncStateChange";
405  break;
407  event_name = "MessageQueueInternal";
408  break;
410  event_name = "MessageQueuePutMessage";
411  break;
413  event_name = "MessageQueueReceive";
414  break;
415  case WAIT_EVENT_MQ_SEND:
416  event_name = "MessageQueueSend";
417  break;
419  event_name = "ParallelBitmapScan";
420  break;
422  event_name = "ParallelCreateIndexScan";
423  break;
425  event_name = "ParallelFinish";
426  break;
428  event_name = "ProcArrayGroupUpdate";
429  break;
431  event_name = "ProcSignalBarrier";
432  break;
433  case WAIT_EVENT_PROMOTE:
434  event_name = "Promote";
435  break;
437  event_name = "RecoveryConflictSnapshot";
438  break;
440  event_name = "RecoveryConflictTablespace";
441  break;
443  event_name = "RecoveryEndCommand";
444  break;
446  event_name = "RecoveryPause";
447  break;
449  event_name = "ReplicationOriginDrop";
450  break;
452  event_name = "ReplicationSlotDrop";
453  break;
455  event_name = "RestoreCommand";
456  break;
458  event_name = "SafeSnapshot";
459  break;
460  case WAIT_EVENT_SYNC_REP:
461  event_name = "SyncRep";
462  break;
464  event_name = "WalReceiverExit";
465  break;
467  event_name = "WalReceiverWaitStart";
468  break;
470  event_name = "XactGroupUpdate";
471  break;
472  /* no default case, so that compiler will warn */
473  }
474 
475  return event_name;
476 }
477 
478 /* ----------
479  * pgstat_get_wait_timeout() -
480  *
481  * Convert WaitEventTimeout to string.
482  * ----------
483  */
484 static const char *
486 {
487  const char *event_name = "unknown wait event";
488 
489  switch (w)
490  {
492  event_name = "BaseBackupThrottle";
493  break;
495  event_name = "CheckpointWriteDelay";
496  break;
497  case WAIT_EVENT_PG_SLEEP:
498  event_name = "PgSleep";
499  break;
501  event_name = "RecoveryApplyDelay";
502  break;
504  event_name = "RecoveryRetrieveRetryInterval";
505  break;
507  event_name = "RegisterSyncRequest";
508  break;
510  event_name = "SpinDelay";
511  break;
513  event_name = "VacuumDelay";
514  break;
516  event_name = "VacuumTruncate";
517  break;
518  /* no default case, so that compiler will warn */
519  }
520 
521  return event_name;
522 }
523 
524 /* ----------
525  * pgstat_get_wait_io() -
526  *
527  * Convert WaitEventIO to string.
528  * ----------
529  */
530 static const char *
532 {
533  const char *event_name = "unknown wait event";
534 
535  switch (w)
536  {
538  event_name = "BaseBackupRead";
539  break;
541  event_name = "BaseBackupSync";
542  break;
544  event_name = "BaseBackupWrite";
545  break;
547  event_name = "BufFileRead";
548  break;
550  event_name = "BufFileWrite";
551  break;
553  event_name = "BufFileTruncate";
554  break;
556  event_name = "ControlFileRead";
557  break;
559  event_name = "ControlFileSync";
560  break;
562  event_name = "ControlFileSyncUpdate";
563  break;
565  event_name = "ControlFileWrite";
566  break;
568  event_name = "ControlFileWriteUpdate";
569  break;
571  event_name = "CopyFileRead";
572  break;
574  event_name = "CopyFileWrite";
575  break;
577  event_name = "DataFileExtend";
578  break;
580  event_name = "DataFileFlush";
581  break;
583  event_name = "DataFileImmediateSync";
584  break;
586  event_name = "DataFilePrefetch";
587  break;
589  event_name = "DataFileRead";
590  break;
592  event_name = "DataFileSync";
593  break;
595  event_name = "DataFileTruncate";
596  break;
598  event_name = "DataFileWrite";
599  break;
601  event_name = "DSMAllocate";
602  break;
604  event_name = "DSMFillZeroWrite";
605  break;
607  event_name = "LockFileAddToDataDirRead";
608  break;
610  event_name = "LockFileAddToDataDirSync";
611  break;
613  event_name = "LockFileAddToDataDirWrite";
614  break;
616  event_name = "LockFileCreateRead";
617  break;
619  event_name = "LockFileCreateSync";
620  break;
622  event_name = "LockFileCreateWrite";
623  break;
625  event_name = "LockFileReCheckDataDirRead";
626  break;
628  event_name = "LogicalRewriteCheckpointSync";
629  break;
631  event_name = "LogicalRewriteMappingSync";
632  break;
634  event_name = "LogicalRewriteMappingWrite";
635  break;
637  event_name = "LogicalRewriteSync";
638  break;
640  event_name = "LogicalRewriteTruncate";
641  break;
643  event_name = "LogicalRewriteWrite";
644  break;
646  event_name = "RelationMapRead";
647  break;
649  event_name = "RelationMapReplace";
650  break;
652  event_name = "RelationMapWrite";
653  break;
655  event_name = "ReorderBufferRead";
656  break;
658  event_name = "ReorderBufferWrite";
659  break;
661  event_name = "ReorderLogicalMappingRead";
662  break;
664  event_name = "ReplicationSlotRead";
665  break;
667  event_name = "ReplicationSlotRestoreSync";
668  break;
670  event_name = "ReplicationSlotSync";
671  break;
673  event_name = "ReplicationSlotWrite";
674  break;
676  event_name = "SLRUFlushSync";
677  break;
679  event_name = "SLRURead";
680  break;
682  event_name = "SLRUSync";
683  break;
685  event_name = "SLRUWrite";
686  break;
688  event_name = "SnapbuildRead";
689  break;
691  event_name = "SnapbuildSync";
692  break;
694  event_name = "SnapbuildWrite";
695  break;
697  event_name = "TimelineHistoryFileSync";
698  break;
700  event_name = "TimelineHistoryFileWrite";
701  break;
703  event_name = "TimelineHistoryRead";
704  break;
706  event_name = "TimelineHistorySync";
707  break;
709  event_name = "TimelineHistoryWrite";
710  break;
712  event_name = "TwophaseFileRead";
713  break;
715  event_name = "TwophaseFileSync";
716  break;
718  event_name = "TwophaseFileWrite";
719  break;
721  event_name = "VersionFileWrite";
722  break;
724  event_name = "WALSenderTimelineHistoryRead";
725  break;
727  event_name = "WALBootstrapSync";
728  break;
730  event_name = "WALBootstrapWrite";
731  break;
733  event_name = "WALCopyRead";
734  break;
736  event_name = "WALCopySync";
737  break;
739  event_name = "WALCopyWrite";
740  break;
742  event_name = "WALInitSync";
743  break;
745  event_name = "WALInitWrite";
746  break;
747  case WAIT_EVENT_WAL_READ:
748  event_name = "WALRead";
749  break;
750  case WAIT_EVENT_WAL_SYNC:
751  event_name = "WALSync";
752  break;
754  event_name = "WALSyncMethodAssign";
755  break;
757  event_name = "WALWrite";
758  break;
759 
760  /* no default case, so that compiler will warn */
761  }
762 
763  return event_name;
764 }
unsigned short uint16
Definition: c.h:489
unsigned int uint32
Definition: c.h:490
const char * GetLockNameFromTagType(uint16 locktag_type)
Definition: lmgr.c:1265
const char * GetLWLockIdentifier(uint32 classId, uint16 eventId)
Definition: lwlock.c:794
static const char * pgstat_get_wait_timeout(WaitEventTimeout w)
Definition: wait_event.c:485
const char * pgstat_get_wait_event(uint32 wait_event_info)
Definition: wait_event.c:129
static const char * pgstat_get_wait_activity(WaitEventActivity w)
Definition: wait_event.c:206
static const char * pgstat_get_wait_io(WaitEventIO w)
Definition: wait_event.c:531
void pgstat_set_wait_event_storage(uint32 *wait_event_info)
Definition: wait_event.c:50
static uint32 local_my_wait_event_info
Definition: wait_event.c:37
const char * pgstat_get_wait_event_type(uint32 wait_event_info)
Definition: wait_event.c:74
static const char * pgstat_get_wait_client(WaitEventClient w)
Definition: wait_event.c:264
static const char * pgstat_get_wait_ipc(WaitEventIPC w)
Definition: wait_event.c:307
void pgstat_reset_wait_event_storage(void)
Definition: wait_event.c:62
uint32 * my_wait_event_info
Definition: wait_event.c:38
#define PG_WAIT_TIMEOUT
Definition: wait_event.h:25
WaitEventActivity
Definition: wait_event.h:37
@ WAIT_EVENT_SYSLOGGER_MAIN
Definition: wait_event.h:47
@ WAIT_EVENT_BGWRITER_MAIN
Definition: wait_event.h:41
@ WAIT_EVENT_WAL_WRITER_MAIN
Definition: wait_event.h:50
@ WAIT_EVENT_WAL_SENDER_MAIN
Definition: wait_event.h:49
@ WAIT_EVENT_LOGICAL_PARALLEL_APPLY_MAIN
Definition: wait_event.h:45
@ WAIT_EVENT_LOGICAL_LAUNCHER_MAIN
Definition: wait_event.h:44
@ WAIT_EVENT_CHECKPOINTER_MAIN
Definition: wait_event.h:42
@ WAIT_EVENT_BGWRITER_HIBERNATE
Definition: wait_event.h:40
@ WAIT_EVENT_WAL_RECEIVER_MAIN
Definition: wait_event.h:48
@ WAIT_EVENT_ARCHIVER_MAIN
Definition: wait_event.h:38
@ WAIT_EVENT_LOGICAL_APPLY_MAIN
Definition: wait_event.h:43
@ WAIT_EVENT_RECOVERY_WAL_STREAM
Definition: wait_event.h:46
@ WAIT_EVENT_AUTOVACUUM_MAIN
Definition: wait_event.h:39
WaitEventIO
Definition: wait_event.h:163
@ WAIT_EVENT_LOGICAL_REWRITE_MAPPING_SYNC
Definition: wait_event.h:195
@ WAIT_EVENT_RELATION_MAP_WRITE
Definition: wait_event.h:202
@ WAIT_EVENT_WAL_COPY_SYNC
Definition: wait_event.h:230
@ WAIT_EVENT_LOCK_FILE_ADDTODATADIR_WRITE
Definition: wait_event.h:189
@ WAIT_EVENT_CONTROL_FILE_READ
Definition: wait_event.h:170
@ WAIT_EVENT_DATA_FILE_IMMEDIATE_SYNC
Definition: wait_event.h:179
@ WAIT_EVENT_REORDER_BUFFER_READ
Definition: wait_event.h:203
@ WAIT_EVENT_BUFFILE_WRITE
Definition: wait_event.h:168
@ WAIT_EVENT_RELATION_MAP_READ
Definition: wait_event.h:200
@ WAIT_EVENT_CONTROL_FILE_WRITE_UPDATE
Definition: wait_event.h:174
@ WAIT_EVENT_DATA_FILE_READ
Definition: wait_event.h:181
@ WAIT_EVENT_DATA_FILE_WRITE
Definition: wait_event.h:184
@ WAIT_EVENT_DSM_ALLOCATE
Definition: wait_event.h:185
@ WAIT_EVENT_COPY_FILE_READ
Definition: wait_event.h:175
@ WAIT_EVENT_VERSION_FILE_WRITE
Definition: wait_event.h:225
@ WAIT_EVENT_LOCK_FILE_CREATE_SYNC
Definition: wait_event.h:191
@ WAIT_EVENT_TIMELINE_HISTORY_FILE_WRITE
Definition: wait_event.h:218
@ WAIT_EVENT_LOCK_FILE_CREATE_READ
Definition: wait_event.h:190
@ WAIT_EVENT_BASEBACKUP_SYNC
Definition: wait_event.h:165
@ WAIT_EVENT_LOGICAL_REWRITE_WRITE
Definition: wait_event.h:199
@ WAIT_EVENT_BASEBACKUP_WRITE
Definition: wait_event.h:166
@ WAIT_EVENT_RELATION_MAP_REPLACE
Definition: wait_event.h:201
@ WAIT_EVENT_BASEBACKUP_READ
Definition: wait_event.h:164
@ WAIT_EVENT_WAL_COPY_WRITE
Definition: wait_event.h:231
@ WAIT_EVENT_DSM_FILL_ZERO_WRITE
Definition: wait_event.h:186
@ WAIT_EVENT_TIMELINE_HISTORY_WRITE
Definition: wait_event.h:221
@ WAIT_EVENT_WAL_COPY_READ
Definition: wait_event.h:229
@ WAIT_EVENT_WAL_SYNC_METHOD_ASSIGN
Definition: wait_event.h:236
@ WAIT_EVENT_REPLICATION_SLOT_READ
Definition: wait_event.h:206
@ WAIT_EVENT_SNAPBUILD_SYNC
Definition: wait_event.h:215
@ WAIT_EVENT_DATA_FILE_FLUSH
Definition: wait_event.h:178
@ WAIT_EVENT_LOCK_FILE_CREATE_WRITE
Definition: wait_event.h:192
@ WAIT_EVENT_LOCK_FILE_RECHECKDATADIR_READ
Definition: wait_event.h:193
@ WAIT_EVENT_DATA_FILE_EXTEND
Definition: wait_event.h:177
@ WAIT_EVENT_WAL_SYNC
Definition: wait_event.h:235
@ WAIT_EVENT_CONTROL_FILE_WRITE
Definition: wait_event.h:173
@ WAIT_EVENT_SLRU_SYNC
Definition: wait_event.h:212
@ WAIT_EVENT_TWOPHASE_FILE_READ
Definition: wait_event.h:222
@ WAIT_EVENT_CONTROL_FILE_SYNC
Definition: wait_event.h:171
@ WAIT_EVENT_TWOPHASE_FILE_WRITE
Definition: wait_event.h:224
@ WAIT_EVENT_SLRU_READ
Definition: wait_event.h:211
@ WAIT_EVENT_BUFFILE_TRUNCATE
Definition: wait_event.h:169
@ WAIT_EVENT_WAL_WRITE
Definition: wait_event.h:237
@ WAIT_EVENT_COPY_FILE_WRITE
Definition: wait_event.h:176
@ WAIT_EVENT_REPLICATION_SLOT_WRITE
Definition: wait_event.h:209
@ WAIT_EVENT_WAL_INIT_SYNC
Definition: wait_event.h:232
@ WAIT_EVENT_REORDER_LOGICAL_MAPPING_READ
Definition: wait_event.h:205
@ WAIT_EVENT_REORDER_BUFFER_WRITE
Definition: wait_event.h:204
@ WAIT_EVENT_TIMELINE_HISTORY_FILE_SYNC
Definition: wait_event.h:217
@ WAIT_EVENT_LOGICAL_REWRITE_MAPPING_WRITE
Definition: wait_event.h:196
@ WAIT_EVENT_CONTROL_FILE_SYNC_UPDATE
Definition: wait_event.h:172
@ WAIT_EVENT_WALSENDER_TIMELINE_HISTORY_READ
Definition: wait_event.h:226
@ WAIT_EVENT_SNAPBUILD_WRITE
Definition: wait_event.h:216
@ WAIT_EVENT_TWOPHASE_FILE_SYNC
Definition: wait_event.h:223
@ WAIT_EVENT_DATA_FILE_TRUNCATE
Definition: wait_event.h:183
@ WAIT_EVENT_SLRU_FLUSH_SYNC
Definition: wait_event.h:210
@ WAIT_EVENT_DATA_FILE_PREFETCH
Definition: wait_event.h:180
@ WAIT_EVENT_TIMELINE_HISTORY_READ
Definition: wait_event.h:219
@ WAIT_EVENT_BUFFILE_READ
Definition: wait_event.h:167
@ WAIT_EVENT_LOCK_FILE_ADDTODATADIR_READ
Definition: wait_event.h:187
@ WAIT_EVENT_TIMELINE_HISTORY_SYNC
Definition: wait_event.h:220
@ WAIT_EVENT_LOCK_FILE_ADDTODATADIR_SYNC
Definition: wait_event.h:188
@ WAIT_EVENT_DATA_FILE_SYNC
Definition: wait_event.h:182
@ WAIT_EVENT_REPLICATION_SLOT_RESTORE_SYNC
Definition: wait_event.h:207
@ WAIT_EVENT_LOGICAL_REWRITE_TRUNCATE
Definition: wait_event.h:198
@ WAIT_EVENT_SLRU_WRITE
Definition: wait_event.h:213
@ WAIT_EVENT_REPLICATION_SLOT_SYNC
Definition: wait_event.h:208
@ WAIT_EVENT_LOGICAL_REWRITE_CHECKPOINT_SYNC
Definition: wait_event.h:194
@ WAIT_EVENT_WAL_INIT_WRITE
Definition: wait_event.h:233
@ WAIT_EVENT_WAL_READ
Definition: wait_event.h:234
@ WAIT_EVENT_SNAPBUILD_READ
Definition: wait_event.h:214
@ WAIT_EVENT_WAL_BOOTSTRAP_SYNC
Definition: wait_event.h:227
@ WAIT_EVENT_LOGICAL_REWRITE_SYNC
Definition: wait_event.h:197
@ WAIT_EVENT_WAL_BOOTSTRAP_WRITE
Definition: wait_event.h:228
#define PG_WAIT_LWLOCK
Definition: wait_event.h:18
WaitEventIPC
Definition: wait_event.h:81
@ WAIT_EVENT_REPLICATION_ORIGIN_DROP
Definition: wait_event.h:127
@ WAIT_EVENT_CHECKPOINT_START
Definition: wait_event.h:92
@ WAIT_EVENT_PROMOTE
Definition: wait_event.h:122
@ WAIT_EVENT_SAFE_SNAPSHOT
Definition: wait_event.h:130
@ WAIT_EVENT_BACKUP_WAIT_WAL_ARCHIVE
Definition: wait_event.h:86
@ WAIT_EVENT_RESTORE_COMMAND
Definition: wait_event.h:129
@ WAIT_EVENT_PARALLEL_BITMAP_SCAN
Definition: wait_event.h:117
@ WAIT_EVENT_MQ_INTERNAL
Definition: wait_event.h:113
@ WAIT_EVENT_MQ_PUT_MESSAGE
Definition: wait_event.h:114
@ WAIT_EVENT_ARCHIVE_COMMAND
Definition: wait_event.h:84
@ WAIT_EVENT_BUFFER_IO
Definition: wait_event.h:90
@ WAIT_EVENT_SYNC_REP
Definition: wait_event.h:131
@ WAIT_EVENT_LOGICAL_PARALLEL_APPLY_STATE_CHANGE
Definition: wait_event.h:110
@ WAIT_EVENT_PARALLEL_CREATE_INDEX_SCAN
Definition: wait_event.h:118
@ WAIT_EVENT_HASH_GROW_BUCKETS_REINSERT
Definition: wait_event.h:108
@ WAIT_EVENT_HASH_GROW_BUCKETS_REALLOCATE
Definition: wait_event.h:107
@ WAIT_EVENT_BGWORKER_STARTUP
Definition: wait_event.h:88
@ WAIT_EVENT_HASH_BUILD_ELECT
Definition: wait_event.h:98
@ WAIT_EVENT_XACT_GROUP_UPDATE
Definition: wait_event.h:134
@ WAIT_EVENT_MQ_SEND
Definition: wait_event.h:116
@ WAIT_EVENT_HASH_BUILD_HASH_INNER
Definition: wait_event.h:99
@ WAIT_EVENT_HASH_BATCH_LOAD
Definition: wait_event.h:96
@ WAIT_EVENT_LOGICAL_SYNC_STATE_CHANGE
Definition: wait_event.h:112
@ WAIT_EVENT_APPEND_READY
Definition: wait_event.h:82
@ WAIT_EVENT_BTREE_PAGE
Definition: wait_event.h:89
@ WAIT_EVENT_HASH_GROW_BATCHES_DECIDE
Definition: wait_event.h:101
@ WAIT_EVENT_PROCARRAY_GROUP_UPDATE
Definition: wait_event.h:120
@ WAIT_EVENT_BACKEND_TERMINATION
Definition: wait_event.h:85
@ WAIT_EVENT_CHECKPOINT_DONE
Definition: wait_event.h:91
@ WAIT_EVENT_RECOVERY_CONFLICT_TABLESPACE
Definition: wait_event.h:124
@ WAIT_EVENT_HASH_GROW_BATCHES_FINISH
Definition: wait_event.h:103
@ WAIT_EVENT_HASH_GROW_BUCKETS_ELECT
Definition: wait_event.h:106
@ WAIT_EVENT_BGWORKER_SHUTDOWN
Definition: wait_event.h:87
@ WAIT_EVENT_HASH_GROW_BATCHES_REALLOCATE
Definition: wait_event.h:104
@ WAIT_EVENT_REPLICATION_SLOT_DROP
Definition: wait_event.h:128
@ WAIT_EVENT_PARALLEL_FINISH
Definition: wait_event.h:119
@ WAIT_EVENT_ARCHIVE_CLEANUP_COMMAND
Definition: wait_event.h:83
@ WAIT_EVENT_WAL_RECEIVER_WAIT_START
Definition: wait_event.h:133
@ WAIT_EVENT_LOGICAL_APPLY_SEND_DATA
Definition: wait_event.h:109
@ WAIT_EVENT_RECOVERY_CONFLICT_SNAPSHOT
Definition: wait_event.h:123
@ WAIT_EVENT_HASH_BUILD_HASH_OUTER
Definition: wait_event.h:100
@ WAIT_EVENT_WAL_RECEIVER_EXIT
Definition: wait_event.h:132
@ WAIT_EVENT_HASH_BATCH_ALLOCATE
Definition: wait_event.h:94
@ WAIT_EVENT_HASH_GROW_BATCHES_REPARTITION
Definition: wait_event.h:105
@ WAIT_EVENT_HASH_BATCH_ELECT
Definition: wait_event.h:95
@ WAIT_EVENT_PROC_SIGNAL_BARRIER
Definition: wait_event.h:121
@ WAIT_EVENT_RECOVERY_PAUSE
Definition: wait_event.h:126
@ WAIT_EVENT_RECOVERY_END_COMMAND
Definition: wait_event.h:125
@ WAIT_EVENT_LOGICAL_SYNC_DATA
Definition: wait_event.h:111
@ WAIT_EVENT_HASH_BUILD_ALLOCATE
Definition: wait_event.h:97
@ WAIT_EVENT_EXECUTE_GATHER
Definition: wait_event.h:93
@ WAIT_EVENT_HASH_GROW_BATCHES_ELECT
Definition: wait_event.h:102
@ WAIT_EVENT_MQ_RECEIVE
Definition: wait_event.h:115
#define PG_WAIT_IPC
Definition: wait_event.h:24
#define PG_WAIT_CLIENT
Definition: wait_event.h:22
WaitEventTimeout
Definition: wait_event.h:144
@ WAIT_EVENT_VACUUM_TRUNCATE
Definition: wait_event.h:153
@ WAIT_EVENT_CHECKPOINT_WRITE_DELAY
Definition: wait_event.h:146
@ WAIT_EVENT_BASE_BACKUP_THROTTLE
Definition: wait_event.h:145
@ WAIT_EVENT_SPIN_DELAY
Definition: wait_event.h:151
@ WAIT_EVENT_PG_SLEEP
Definition: wait_event.h:147
@ WAIT_EVENT_RECOVERY_APPLY_DELAY
Definition: wait_event.h:148
@ WAIT_EVENT_VACUUM_DELAY
Definition: wait_event.h:152
@ WAIT_EVENT_REGISTER_SYNC_REQUEST
Definition: wait_event.h:150
@ WAIT_EVENT_RECOVERY_RETRIEVE_RETRY_INTERVAL
Definition: wait_event.h:149
#define PG_WAIT_EXTENSION
Definition: wait_event.h:23
WaitEventClient
Definition: wait_event.h:62
@ WAIT_EVENT_CLIENT_READ
Definition: wait_event.h:63
@ WAIT_EVENT_GSS_OPEN_SERVER
Definition: wait_event.h:65
@ WAIT_EVENT_SSL_OPEN_SERVER
Definition: wait_event.h:68
@ WAIT_EVENT_LIBPQWALRECEIVER_RECEIVE
Definition: wait_event.h:67
@ WAIT_EVENT_LIBPQWALRECEIVER_CONNECT
Definition: wait_event.h:66
@ WAIT_EVENT_WAL_SENDER_WRITE_DATA
Definition: wait_event.h:70
@ WAIT_EVENT_CLIENT_WRITE
Definition: wait_event.h:64
@ WAIT_EVENT_WAL_SENDER_WAIT_WAL
Definition: wait_event.h:69
#define PG_WAIT_ACTIVITY
Definition: wait_event.h:21
#define PG_WAIT_BUFFER_PIN
Definition: wait_event.h:20
#define PG_WAIT_LOCK
Definition: wait_event.h:19
#define PG_WAIT_IO
Definition: wait_event.h:26