wait_event.h File Reference

This graph shows which files directly or indirectly include this file:

Go to the source code of this file.

Macros
#define	PG_WAIT_LWLOCK   0x01000000U
#define	PG_WAIT_LOCK   0x03000000U
#define	PG_WAIT_BUFFER_PIN   0x04000000U
#define	PG_WAIT_ACTIVITY   0x05000000U
#define	PG_WAIT_CLIENT   0x06000000U
#define	PG_WAIT_EXTENSION   0x07000000U
#define	PG_WAIT_IPC   0x08000000U
#define	PG_WAIT_TIMEOUT   0x09000000U
#define	PG_WAIT_IO   0x0A000000U

Enumerations
enum	WaitEventActivity {   WAIT_EVENT_ARCHIVER_MAIN = PG_WAIT_ACTIVITY , WAIT_EVENT_AUTOVACUUM_MAIN , WAIT_EVENT_BGWRITER_HIBERNATE , WAIT_EVENT_BGWRITER_MAIN ,   WAIT_EVENT_CHECKPOINTER_MAIN , WAIT_EVENT_LOGICAL_APPLY_MAIN , WAIT_EVENT_LOGICAL_LAUNCHER_MAIN , WAIT_EVENT_LOGICAL_PARALLEL_APPLY_MAIN ,   WAIT_EVENT_RECOVERY_WAL_STREAM , WAIT_EVENT_SYSLOGGER_MAIN , WAIT_EVENT_WAL_RECEIVER_MAIN , WAIT_EVENT_WAL_SENDER_MAIN ,   WAIT_EVENT_WAL_WRITER_MAIN }
enum	WaitEventClient {   WAIT_EVENT_CLIENT_READ = PG_WAIT_CLIENT , WAIT_EVENT_CLIENT_WRITE , WAIT_EVENT_GSS_OPEN_SERVER , WAIT_EVENT_LIBPQWALRECEIVER_CONNECT ,   WAIT_EVENT_LIBPQWALRECEIVER_RECEIVE , WAIT_EVENT_SSL_OPEN_SERVER , WAIT_EVENT_WAL_SENDER_WAIT_WAL , WAIT_EVENT_WAL_SENDER_WRITE_DATA }
enum	WaitEventIPC {   WAIT_EVENT_APPEND_READY = PG_WAIT_IPC , WAIT_EVENT_ARCHIVE_CLEANUP_COMMAND , WAIT_EVENT_ARCHIVE_COMMAND , WAIT_EVENT_BACKEND_TERMINATION ,   WAIT_EVENT_BACKUP_WAIT_WAL_ARCHIVE , WAIT_EVENT_BGWORKER_SHUTDOWN , WAIT_EVENT_BGWORKER_STARTUP , WAIT_EVENT_BTREE_PAGE ,   WAIT_EVENT_BUFFER_IO , WAIT_EVENT_CHECKPOINT_DONE , WAIT_EVENT_CHECKPOINT_START , WAIT_EVENT_EXECUTE_GATHER ,   WAIT_EVENT_HASH_BATCH_ALLOCATE , WAIT_EVENT_HASH_BATCH_ELECT , WAIT_EVENT_HASH_BATCH_LOAD , WAIT_EVENT_HASH_BUILD_ALLOCATE ,   WAIT_EVENT_HASH_BUILD_ELECT , WAIT_EVENT_HASH_BUILD_HASH_INNER , WAIT_EVENT_HASH_BUILD_HASH_OUTER , WAIT_EVENT_HASH_GROW_BATCHES_DECIDE ,   WAIT_EVENT_HASH_GROW_BATCHES_ELECT , WAIT_EVENT_HASH_GROW_BATCHES_FINISH , WAIT_EVENT_HASH_GROW_BATCHES_REALLOCATE , WAIT_EVENT_HASH_GROW_BATCHES_REPARTITION ,   WAIT_EVENT_HASH_GROW_BUCKETS_ELECT , WAIT_EVENT_HASH_GROW_BUCKETS_REALLOCATE , WAIT_EVENT_HASH_GROW_BUCKETS_REINSERT , WAIT_EVENT_LOGICAL_APPLY_SEND_DATA ,   WAIT_EVENT_LOGICAL_PARALLEL_APPLY_STATE_CHANGE , WAIT_EVENT_LOGICAL_SYNC_DATA , WAIT_EVENT_LOGICAL_SYNC_STATE_CHANGE , WAIT_EVENT_MQ_INTERNAL ,   WAIT_EVENT_MQ_PUT_MESSAGE , WAIT_EVENT_MQ_RECEIVE , WAIT_EVENT_MQ_SEND , WAIT_EVENT_PARALLEL_BITMAP_SCAN ,   WAIT_EVENT_PARALLEL_CREATE_INDEX_SCAN , WAIT_EVENT_PARALLEL_FINISH , WAIT_EVENT_PROCARRAY_GROUP_UPDATE , WAIT_EVENT_PROC_SIGNAL_BARRIER ,   WAIT_EVENT_PROMOTE , WAIT_EVENT_RECOVERY_CONFLICT_SNAPSHOT , WAIT_EVENT_RECOVERY_CONFLICT_TABLESPACE , WAIT_EVENT_RECOVERY_END_COMMAND ,   WAIT_EVENT_RECOVERY_PAUSE , WAIT_EVENT_REPLICATION_ORIGIN_DROP , WAIT_EVENT_REPLICATION_SLOT_DROP , WAIT_EVENT_RESTORE_COMMAND ,   WAIT_EVENT_SAFE_SNAPSHOT , WAIT_EVENT_SYNC_REP , WAIT_EVENT_WAL_RECEIVER_EXIT , WAIT_EVENT_WAL_RECEIVER_WAIT_START ,   WAIT_EVENT_XACT_GROUP_UPDATE }
enum	WaitEventTimeout {   WAIT_EVENT_BASE_BACKUP_THROTTLE = PG_WAIT_TIMEOUT , WAIT_EVENT_CHECKPOINT_WRITE_DELAY , WAIT_EVENT_PG_SLEEP , WAIT_EVENT_RECOVERY_APPLY_DELAY ,   WAIT_EVENT_RECOVERY_RETRIEVE_RETRY_INTERVAL , WAIT_EVENT_REGISTER_SYNC_REQUEST , WAIT_EVENT_SPIN_DELAY , WAIT_EVENT_VACUUM_DELAY ,   WAIT_EVENT_VACUUM_TRUNCATE }
enum	WaitEventIO {   WAIT_EVENT_BASEBACKUP_READ = PG_WAIT_IO , WAIT_EVENT_BASEBACKUP_SYNC , WAIT_EVENT_BASEBACKUP_WRITE , WAIT_EVENT_BUFFILE_READ ,   WAIT_EVENT_BUFFILE_WRITE , WAIT_EVENT_BUFFILE_TRUNCATE , WAIT_EVENT_CONTROL_FILE_READ , WAIT_EVENT_CONTROL_FILE_SYNC ,   WAIT_EVENT_CONTROL_FILE_SYNC_UPDATE , WAIT_EVENT_CONTROL_FILE_WRITE , WAIT_EVENT_CONTROL_FILE_WRITE_UPDATE , WAIT_EVENT_COPY_FILE_READ ,   WAIT_EVENT_COPY_FILE_WRITE , WAIT_EVENT_DATA_FILE_EXTEND , WAIT_EVENT_DATA_FILE_FLUSH , WAIT_EVENT_DATA_FILE_IMMEDIATE_SYNC ,   WAIT_EVENT_DATA_FILE_PREFETCH , WAIT_EVENT_DATA_FILE_READ , WAIT_EVENT_DATA_FILE_SYNC , WAIT_EVENT_DATA_FILE_TRUNCATE ,   WAIT_EVENT_DATA_FILE_WRITE , WAIT_EVENT_DSM_ALLOCATE , WAIT_EVENT_DSM_FILL_ZERO_WRITE , WAIT_EVENT_LOCK_FILE_ADDTODATADIR_READ ,   WAIT_EVENT_LOCK_FILE_ADDTODATADIR_SYNC , WAIT_EVENT_LOCK_FILE_ADDTODATADIR_WRITE , WAIT_EVENT_LOCK_FILE_CREATE_READ , WAIT_EVENT_LOCK_FILE_CREATE_SYNC ,   WAIT_EVENT_LOCK_FILE_CREATE_WRITE , WAIT_EVENT_LOCK_FILE_RECHECKDATADIR_READ , WAIT_EVENT_LOGICAL_REWRITE_CHECKPOINT_SYNC , WAIT_EVENT_LOGICAL_REWRITE_MAPPING_SYNC ,   WAIT_EVENT_LOGICAL_REWRITE_MAPPING_WRITE , WAIT_EVENT_LOGICAL_REWRITE_SYNC , WAIT_EVENT_LOGICAL_REWRITE_TRUNCATE , WAIT_EVENT_LOGICAL_REWRITE_WRITE ,   WAIT_EVENT_RELATION_MAP_READ , WAIT_EVENT_RELATION_MAP_REPLACE , WAIT_EVENT_RELATION_MAP_WRITE , WAIT_EVENT_REORDER_BUFFER_READ ,   WAIT_EVENT_REORDER_BUFFER_WRITE , WAIT_EVENT_REORDER_LOGICAL_MAPPING_READ , WAIT_EVENT_REPLICATION_SLOT_READ , WAIT_EVENT_REPLICATION_SLOT_RESTORE_SYNC ,   WAIT_EVENT_REPLICATION_SLOT_SYNC , WAIT_EVENT_REPLICATION_SLOT_WRITE , WAIT_EVENT_SLRU_FLUSH_SYNC , WAIT_EVENT_SLRU_READ ,   WAIT_EVENT_SLRU_SYNC , WAIT_EVENT_SLRU_WRITE , WAIT_EVENT_SNAPBUILD_READ , WAIT_EVENT_SNAPBUILD_SYNC ,   WAIT_EVENT_SNAPBUILD_WRITE , WAIT_EVENT_TIMELINE_HISTORY_FILE_SYNC , WAIT_EVENT_TIMELINE_HISTORY_FILE_WRITE , WAIT_EVENT_TIMELINE_HISTORY_READ ,   WAIT_EVENT_TIMELINE_HISTORY_SYNC , WAIT_EVENT_TIMELINE_HISTORY_WRITE , WAIT_EVENT_TWOPHASE_FILE_READ , WAIT_EVENT_TWOPHASE_FILE_SYNC ,   WAIT_EVENT_TWOPHASE_FILE_WRITE , WAIT_EVENT_VERSION_FILE_WRITE , WAIT_EVENT_WALSENDER_TIMELINE_HISTORY_READ , WAIT_EVENT_WAL_BOOTSTRAP_SYNC ,   WAIT_EVENT_WAL_BOOTSTRAP_WRITE , WAIT_EVENT_WAL_COPY_READ , WAIT_EVENT_WAL_COPY_SYNC , WAIT_EVENT_WAL_COPY_WRITE ,   WAIT_EVENT_WAL_INIT_SYNC , WAIT_EVENT_WAL_INIT_WRITE , WAIT_EVENT_WAL_READ , WAIT_EVENT_WAL_SYNC ,   WAIT_EVENT_WAL_SYNC_METHOD_ASSIGN , WAIT_EVENT_WAL_WRITE }

Functions
const char *	pgstat_get_wait_event (uint32 wait_event_info)
const char *	pgstat_get_wait_event_type (uint32 wait_event_info)
static void	pgstat_report_wait_start (uint32 wait_event_info)
static void	pgstat_report_wait_end (void)
void	pgstat_set_wait_event_storage (uint32 *wait_event_info)
void	pgstat_reset_wait_event_storage (void)

Variables
PGDLLIMPORT uint32 *	my_wait_event_info

Macro Definition Documentation

PG_WAIT_ACTIVITY

#define PG_WAIT_ACTIVITY   0x05000000U

Definition at line 21 of file wait_event.h.

PG_WAIT_BUFFER_PIN

#define PG_WAIT_BUFFER_PIN   0x04000000U

Definition at line 20 of file wait_event.h.

PG_WAIT_CLIENT

#define PG_WAIT_CLIENT   0x06000000U

Definition at line 22 of file wait_event.h.

PG_WAIT_EXTENSION

#define PG_WAIT_EXTENSION   0x07000000U

Definition at line 23 of file wait_event.h.

PG_WAIT_IO

#define PG_WAIT_IO   0x0A000000U

Definition at line 26 of file wait_event.h.

PG_WAIT_IPC

#define PG_WAIT_IPC   0x08000000U

Definition at line 24 of file wait_event.h.

PG_WAIT_LOCK

#define PG_WAIT_LOCK   0x03000000U

Definition at line 19 of file wait_event.h.

PG_WAIT_LWLOCK

#define PG_WAIT_LWLOCK   0x01000000U

Definition at line 18 of file wait_event.h.

PG_WAIT_TIMEOUT

#define PG_WAIT_TIMEOUT   0x09000000U

Definition at line 25 of file wait_event.h.

Enumeration Type Documentation

WaitEventActivity

enum WaitEventActivity

Enumerator
WAIT_EVENT_ARCHIVER_MAIN
WAIT_EVENT_AUTOVACUUM_MAIN
WAIT_EVENT_BGWRITER_HIBERNATE
WAIT_EVENT_BGWRITER_MAIN
WAIT_EVENT_CHECKPOINTER_MAIN
WAIT_EVENT_LOGICAL_APPLY_MAIN
WAIT_EVENT_LOGICAL_LAUNCHER_MAIN
WAIT_EVENT_LOGICAL_PARALLEL_APPLY_MAIN
WAIT_EVENT_RECOVERY_WAL_STREAM
WAIT_EVENT_SYSLOGGER_MAIN
WAIT_EVENT_WAL_RECEIVER_MAIN
WAIT_EVENT_WAL_SENDER_MAIN
WAIT_EVENT_WAL_WRITER_MAIN

Definition at line 36 of file wait_event.h.

{
    WAIT_EVENT_ARCHIVER_MAIN = PG_WAIT_ACTIVITY,
    WAIT_EVENT_AUTOVACUUM_MAIN,
    WAIT_EVENT_BGWRITER_HIBERNATE,
    WAIT_EVENT_BGWRITER_MAIN,
    WAIT_EVENT_CHECKPOINTER_MAIN,
    WAIT_EVENT_LOGICAL_APPLY_MAIN,
    WAIT_EVENT_LOGICAL_LAUNCHER_MAIN,
    WAIT_EVENT_LOGICAL_PARALLEL_APPLY_MAIN,
    WAIT_EVENT_RECOVERY_WAL_STREAM,
    WAIT_EVENT_SYSLOGGER_MAIN,
    WAIT_EVENT_WAL_RECEIVER_MAIN,
    WAIT_EVENT_WAL_SENDER_MAIN,
    WAIT_EVENT_WAL_WRITER_MAIN
} WaitEventActivity;

WaitEventClient

enum WaitEventClient

Enumerator
WAIT_EVENT_CLIENT_READ
WAIT_EVENT_CLIENT_WRITE
WAIT_EVENT_GSS_OPEN_SERVER
WAIT_EVENT_LIBPQWALRECEIVER_CONNECT
WAIT_EVENT_LIBPQWALRECEIVER_RECEIVE
WAIT_EVENT_SSL_OPEN_SERVER
WAIT_EVENT_WAL_SENDER_WAIT_WAL
WAIT_EVENT_WAL_SENDER_WRITE_DATA

Definition at line 61 of file wait_event.h.

{
    WAIT_EVENT_CLIENT_READ = PG_WAIT_CLIENT,
    WAIT_EVENT_CLIENT_WRITE,
    WAIT_EVENT_GSS_OPEN_SERVER,
    WAIT_EVENT_LIBPQWALRECEIVER_CONNECT,
    WAIT_EVENT_LIBPQWALRECEIVER_RECEIVE,
    WAIT_EVENT_SSL_OPEN_SERVER,
    WAIT_EVENT_WAL_SENDER_WAIT_WAL,
    WAIT_EVENT_WAL_SENDER_WRITE_DATA,
} WaitEventClient;

WaitEventIO

enum WaitEventIO

Enumerator
WAIT_EVENT_BASEBACKUP_READ
WAIT_EVENT_BASEBACKUP_SYNC
WAIT_EVENT_BASEBACKUP_WRITE
WAIT_EVENT_BUFFILE_READ
WAIT_EVENT_BUFFILE_WRITE
WAIT_EVENT_BUFFILE_TRUNCATE
WAIT_EVENT_CONTROL_FILE_READ
WAIT_EVENT_CONTROL_FILE_SYNC
WAIT_EVENT_CONTROL_FILE_SYNC_UPDATE
WAIT_EVENT_CONTROL_FILE_WRITE
WAIT_EVENT_CONTROL_FILE_WRITE_UPDATE
WAIT_EVENT_COPY_FILE_READ
WAIT_EVENT_COPY_FILE_WRITE
WAIT_EVENT_DATA_FILE_EXTEND
WAIT_EVENT_DATA_FILE_FLUSH
WAIT_EVENT_DATA_FILE_IMMEDIATE_SYNC
WAIT_EVENT_DATA_FILE_PREFETCH
WAIT_EVENT_DATA_FILE_READ
WAIT_EVENT_DATA_FILE_SYNC
WAIT_EVENT_DATA_FILE_TRUNCATE
WAIT_EVENT_DATA_FILE_WRITE
WAIT_EVENT_DSM_ALLOCATE
WAIT_EVENT_DSM_FILL_ZERO_WRITE
WAIT_EVENT_LOCK_FILE_ADDTODATADIR_READ
WAIT_EVENT_LOCK_FILE_ADDTODATADIR_SYNC
WAIT_EVENT_LOCK_FILE_ADDTODATADIR_WRITE
WAIT_EVENT_LOCK_FILE_CREATE_READ
WAIT_EVENT_LOCK_FILE_CREATE_SYNC
WAIT_EVENT_LOCK_FILE_CREATE_WRITE
WAIT_EVENT_LOCK_FILE_RECHECKDATADIR_READ
WAIT_EVENT_LOGICAL_REWRITE_CHECKPOINT_SYNC
WAIT_EVENT_LOGICAL_REWRITE_MAPPING_SYNC
WAIT_EVENT_LOGICAL_REWRITE_MAPPING_WRITE
WAIT_EVENT_LOGICAL_REWRITE_SYNC
WAIT_EVENT_LOGICAL_REWRITE_TRUNCATE
WAIT_EVENT_LOGICAL_REWRITE_WRITE
WAIT_EVENT_RELATION_MAP_READ
WAIT_EVENT_RELATION_MAP_REPLACE
WAIT_EVENT_RELATION_MAP_WRITE
WAIT_EVENT_REORDER_BUFFER_READ
WAIT_EVENT_REORDER_BUFFER_WRITE
WAIT_EVENT_REORDER_LOGICAL_MAPPING_READ
WAIT_EVENT_REPLICATION_SLOT_READ
WAIT_EVENT_REPLICATION_SLOT_RESTORE_SYNC
WAIT_EVENT_REPLICATION_SLOT_SYNC
WAIT_EVENT_REPLICATION_SLOT_WRITE
WAIT_EVENT_SLRU_FLUSH_SYNC
WAIT_EVENT_SLRU_READ
WAIT_EVENT_SLRU_SYNC
WAIT_EVENT_SLRU_WRITE
WAIT_EVENT_SNAPBUILD_READ
WAIT_EVENT_SNAPBUILD_SYNC
WAIT_EVENT_SNAPBUILD_WRITE
WAIT_EVENT_TIMELINE_HISTORY_FILE_SYNC
WAIT_EVENT_TIMELINE_HISTORY_FILE_WRITE
WAIT_EVENT_TIMELINE_HISTORY_READ
WAIT_EVENT_TIMELINE_HISTORY_SYNC
WAIT_EVENT_TIMELINE_HISTORY_WRITE
WAIT_EVENT_TWOPHASE_FILE_READ
WAIT_EVENT_TWOPHASE_FILE_SYNC
WAIT_EVENT_TWOPHASE_FILE_WRITE
WAIT_EVENT_VERSION_FILE_WRITE
WAIT_EVENT_WALSENDER_TIMELINE_HISTORY_READ
WAIT_EVENT_WAL_BOOTSTRAP_SYNC
WAIT_EVENT_WAL_BOOTSTRAP_WRITE
WAIT_EVENT_WAL_COPY_READ
WAIT_EVENT_WAL_COPY_SYNC
WAIT_EVENT_WAL_COPY_WRITE
WAIT_EVENT_WAL_INIT_SYNC
WAIT_EVENT_WAL_INIT_WRITE
WAIT_EVENT_WAL_READ
WAIT_EVENT_WAL_SYNC
WAIT_EVENT_WAL_SYNC_METHOD_ASSIGN
WAIT_EVENT_WAL_WRITE

Definition at line 162 of file wait_event.h.

{
    WAIT_EVENT_BASEBACKUP_READ = PG_WAIT_IO,
    WAIT_EVENT_BASEBACKUP_SYNC,
    WAIT_EVENT_BASEBACKUP_WRITE,
    WAIT_EVENT_BUFFILE_READ,
    WAIT_EVENT_BUFFILE_WRITE,
    WAIT_EVENT_BUFFILE_TRUNCATE,
    WAIT_EVENT_CONTROL_FILE_READ,
    WAIT_EVENT_CONTROL_FILE_SYNC,
    WAIT_EVENT_CONTROL_FILE_SYNC_UPDATE,
    WAIT_EVENT_CONTROL_FILE_WRITE,
    WAIT_EVENT_CONTROL_FILE_WRITE_UPDATE,
    WAIT_EVENT_COPY_FILE_READ,
    WAIT_EVENT_COPY_FILE_WRITE,
    WAIT_EVENT_DATA_FILE_EXTEND,
    WAIT_EVENT_DATA_FILE_FLUSH,
    WAIT_EVENT_DATA_FILE_IMMEDIATE_SYNC,
    WAIT_EVENT_DATA_FILE_PREFETCH,
    WAIT_EVENT_DATA_FILE_READ,
    WAIT_EVENT_DATA_FILE_SYNC,
    WAIT_EVENT_DATA_FILE_TRUNCATE,
    WAIT_EVENT_DATA_FILE_WRITE,
    WAIT_EVENT_DSM_ALLOCATE,
    WAIT_EVENT_DSM_FILL_ZERO_WRITE,
    WAIT_EVENT_LOCK_FILE_ADDTODATADIR_READ,
    WAIT_EVENT_LOCK_FILE_ADDTODATADIR_SYNC,
    WAIT_EVENT_LOCK_FILE_ADDTODATADIR_WRITE,
    WAIT_EVENT_LOCK_FILE_CREATE_READ,
    WAIT_EVENT_LOCK_FILE_CREATE_SYNC,
    WAIT_EVENT_LOCK_FILE_CREATE_WRITE,
    WAIT_EVENT_LOCK_FILE_RECHECKDATADIR_READ,
    WAIT_EVENT_LOGICAL_REWRITE_CHECKPOINT_SYNC,
    WAIT_EVENT_LOGICAL_REWRITE_MAPPING_SYNC,
    WAIT_EVENT_LOGICAL_REWRITE_MAPPING_WRITE,
    WAIT_EVENT_LOGICAL_REWRITE_SYNC,
    WAIT_EVENT_LOGICAL_REWRITE_TRUNCATE,
    WAIT_EVENT_LOGICAL_REWRITE_WRITE,
    WAIT_EVENT_RELATION_MAP_READ,
    WAIT_EVENT_RELATION_MAP_REPLACE,
    WAIT_EVENT_RELATION_MAP_WRITE,
    WAIT_EVENT_REORDER_BUFFER_READ,
    WAIT_EVENT_REORDER_BUFFER_WRITE,
    WAIT_EVENT_REORDER_LOGICAL_MAPPING_READ,
    WAIT_EVENT_REPLICATION_SLOT_READ,
    WAIT_EVENT_REPLICATION_SLOT_RESTORE_SYNC,
    WAIT_EVENT_REPLICATION_SLOT_SYNC,
    WAIT_EVENT_REPLICATION_SLOT_WRITE,
    WAIT_EVENT_SLRU_FLUSH_SYNC,
    WAIT_EVENT_SLRU_READ,
    WAIT_EVENT_SLRU_SYNC,
    WAIT_EVENT_SLRU_WRITE,
    WAIT_EVENT_SNAPBUILD_READ,
    WAIT_EVENT_SNAPBUILD_SYNC,
    WAIT_EVENT_SNAPBUILD_WRITE,
    WAIT_EVENT_TIMELINE_HISTORY_FILE_SYNC,
    WAIT_EVENT_TIMELINE_HISTORY_FILE_WRITE,
    WAIT_EVENT_TIMELINE_HISTORY_READ,
    WAIT_EVENT_TIMELINE_HISTORY_SYNC,
    WAIT_EVENT_TIMELINE_HISTORY_WRITE,
    WAIT_EVENT_TWOPHASE_FILE_READ,
    WAIT_EVENT_TWOPHASE_FILE_SYNC,
    WAIT_EVENT_TWOPHASE_FILE_WRITE,
    WAIT_EVENT_VERSION_FILE_WRITE,
    WAIT_EVENT_WALSENDER_TIMELINE_HISTORY_READ,
    WAIT_EVENT_WAL_BOOTSTRAP_SYNC,
    WAIT_EVENT_WAL_BOOTSTRAP_WRITE,
    WAIT_EVENT_WAL_COPY_READ,
    WAIT_EVENT_WAL_COPY_SYNC,
    WAIT_EVENT_WAL_COPY_WRITE,
    WAIT_EVENT_WAL_INIT_SYNC,
    WAIT_EVENT_WAL_INIT_WRITE,
    WAIT_EVENT_WAL_READ,
    WAIT_EVENT_WAL_SYNC,
    WAIT_EVENT_WAL_SYNC_METHOD_ASSIGN,
    WAIT_EVENT_WAL_WRITE
} WaitEventIO;

WaitEventIPC

enum WaitEventIPC

Enumerator
WAIT_EVENT_APPEND_READY
WAIT_EVENT_ARCHIVE_CLEANUP_COMMAND
WAIT_EVENT_ARCHIVE_COMMAND
WAIT_EVENT_BACKEND_TERMINATION
WAIT_EVENT_BACKUP_WAIT_WAL_ARCHIVE
WAIT_EVENT_BGWORKER_SHUTDOWN
WAIT_EVENT_BGWORKER_STARTUP
WAIT_EVENT_BTREE_PAGE
WAIT_EVENT_BUFFER_IO
WAIT_EVENT_CHECKPOINT_DONE
WAIT_EVENT_CHECKPOINT_START
WAIT_EVENT_EXECUTE_GATHER
WAIT_EVENT_HASH_BATCH_ALLOCATE
WAIT_EVENT_HASH_BATCH_ELECT
WAIT_EVENT_HASH_BATCH_LOAD
WAIT_EVENT_HASH_BUILD_ALLOCATE
WAIT_EVENT_HASH_BUILD_ELECT
WAIT_EVENT_HASH_BUILD_HASH_INNER
WAIT_EVENT_HASH_BUILD_HASH_OUTER
WAIT_EVENT_HASH_GROW_BATCHES_DECIDE
WAIT_EVENT_HASH_GROW_BATCHES_ELECT
WAIT_EVENT_HASH_GROW_BATCHES_FINISH
WAIT_EVENT_HASH_GROW_BATCHES_REALLOCATE
WAIT_EVENT_HASH_GROW_BATCHES_REPARTITION
WAIT_EVENT_HASH_GROW_BUCKETS_ELECT
WAIT_EVENT_HASH_GROW_BUCKETS_REALLOCATE
WAIT_EVENT_HASH_GROW_BUCKETS_REINSERT
WAIT_EVENT_LOGICAL_APPLY_SEND_DATA
WAIT_EVENT_LOGICAL_PARALLEL_APPLY_STATE_CHANGE
WAIT_EVENT_LOGICAL_SYNC_DATA
WAIT_EVENT_LOGICAL_SYNC_STATE_CHANGE
WAIT_EVENT_MQ_INTERNAL
WAIT_EVENT_MQ_PUT_MESSAGE
WAIT_EVENT_MQ_RECEIVE
WAIT_EVENT_MQ_SEND
WAIT_EVENT_PARALLEL_BITMAP_SCAN
WAIT_EVENT_PARALLEL_CREATE_INDEX_SCAN
WAIT_EVENT_PARALLEL_FINISH
WAIT_EVENT_PROCARRAY_GROUP_UPDATE
WAIT_EVENT_PROC_SIGNAL_BARRIER
WAIT_EVENT_PROMOTE
WAIT_EVENT_RECOVERY_CONFLICT_SNAPSHOT
WAIT_EVENT_RECOVERY_CONFLICT_TABLESPACE
WAIT_EVENT_RECOVERY_END_COMMAND
WAIT_EVENT_RECOVERY_PAUSE
WAIT_EVENT_REPLICATION_ORIGIN_DROP
WAIT_EVENT_REPLICATION_SLOT_DROP
WAIT_EVENT_RESTORE_COMMAND
WAIT_EVENT_SAFE_SNAPSHOT
WAIT_EVENT_SYNC_REP
WAIT_EVENT_WAL_RECEIVER_EXIT
WAIT_EVENT_WAL_RECEIVER_WAIT_START
WAIT_EVENT_XACT_GROUP_UPDATE

Definition at line 80 of file wait_event.h.

{
    WAIT_EVENT_APPEND_READY = PG_WAIT_IPC,
    WAIT_EVENT_ARCHIVE_CLEANUP_COMMAND,
    WAIT_EVENT_ARCHIVE_COMMAND,
    WAIT_EVENT_BACKEND_TERMINATION,
    WAIT_EVENT_BACKUP_WAIT_WAL_ARCHIVE,
    WAIT_EVENT_BGWORKER_SHUTDOWN,
    WAIT_EVENT_BGWORKER_STARTUP,
    WAIT_EVENT_BTREE_PAGE,
    WAIT_EVENT_BUFFER_IO,
    WAIT_EVENT_CHECKPOINT_DONE,
    WAIT_EVENT_CHECKPOINT_START,
    WAIT_EVENT_EXECUTE_GATHER,
    WAIT_EVENT_HASH_BATCH_ALLOCATE,
    WAIT_EVENT_HASH_BATCH_ELECT,
    WAIT_EVENT_HASH_BATCH_LOAD,
    WAIT_EVENT_HASH_BUILD_ALLOCATE,
    WAIT_EVENT_HASH_BUILD_ELECT,
    WAIT_EVENT_HASH_BUILD_HASH_INNER,
    WAIT_EVENT_HASH_BUILD_HASH_OUTER,
    WAIT_EVENT_HASH_GROW_BATCHES_DECIDE,
    WAIT_EVENT_HASH_GROW_BATCHES_ELECT,
    WAIT_EVENT_HASH_GROW_BATCHES_FINISH,
    WAIT_EVENT_HASH_GROW_BATCHES_REALLOCATE,
    WAIT_EVENT_HASH_GROW_BATCHES_REPARTITION,
    WAIT_EVENT_HASH_GROW_BUCKETS_ELECT,
    WAIT_EVENT_HASH_GROW_BUCKETS_REALLOCATE,
    WAIT_EVENT_HASH_GROW_BUCKETS_REINSERT,
    WAIT_EVENT_LOGICAL_APPLY_SEND_DATA,
    WAIT_EVENT_LOGICAL_PARALLEL_APPLY_STATE_CHANGE,
    WAIT_EVENT_LOGICAL_SYNC_DATA,
    WAIT_EVENT_LOGICAL_SYNC_STATE_CHANGE,
    WAIT_EVENT_MQ_INTERNAL,
    WAIT_EVENT_MQ_PUT_MESSAGE,
    WAIT_EVENT_MQ_RECEIVE,
    WAIT_EVENT_MQ_SEND,
    WAIT_EVENT_PARALLEL_BITMAP_SCAN,
    WAIT_EVENT_PARALLEL_CREATE_INDEX_SCAN,
    WAIT_EVENT_PARALLEL_FINISH,
    WAIT_EVENT_PROCARRAY_GROUP_UPDATE,
    WAIT_EVENT_PROC_SIGNAL_BARRIER,
    WAIT_EVENT_PROMOTE,
    WAIT_EVENT_RECOVERY_CONFLICT_SNAPSHOT,
    WAIT_EVENT_RECOVERY_CONFLICT_TABLESPACE,
    WAIT_EVENT_RECOVERY_END_COMMAND,
    WAIT_EVENT_RECOVERY_PAUSE,
    WAIT_EVENT_REPLICATION_ORIGIN_DROP,
    WAIT_EVENT_REPLICATION_SLOT_DROP,
    WAIT_EVENT_RESTORE_COMMAND,
    WAIT_EVENT_SAFE_SNAPSHOT,
    WAIT_EVENT_SYNC_REP,
    WAIT_EVENT_WAL_RECEIVER_EXIT,
    WAIT_EVENT_WAL_RECEIVER_WAIT_START,
    WAIT_EVENT_XACT_GROUP_UPDATE
} WaitEventIPC;

WaitEventTimeout

enum WaitEventTimeout

Enumerator
WAIT_EVENT_BASE_BACKUP_THROTTLE
WAIT_EVENT_CHECKPOINT_WRITE_DELAY
WAIT_EVENT_PG_SLEEP
WAIT_EVENT_RECOVERY_APPLY_DELAY
WAIT_EVENT_RECOVERY_RETRIEVE_RETRY_INTERVAL
WAIT_EVENT_REGISTER_SYNC_REQUEST
WAIT_EVENT_SPIN_DELAY
WAIT_EVENT_VACUUM_DELAY
WAIT_EVENT_VACUUM_TRUNCATE

Definition at line 143 of file wait_event.h.

{
    WAIT_EVENT_BASE_BACKUP_THROTTLE = PG_WAIT_TIMEOUT,
    WAIT_EVENT_CHECKPOINT_WRITE_DELAY,
    WAIT_EVENT_PG_SLEEP,
    WAIT_EVENT_RECOVERY_APPLY_DELAY,
    WAIT_EVENT_RECOVERY_RETRIEVE_RETRY_INTERVAL,
    WAIT_EVENT_REGISTER_SYNC_REQUEST,
    WAIT_EVENT_SPIN_DELAY,
    WAIT_EVENT_VACUUM_DELAY,
    WAIT_EVENT_VACUUM_TRUNCATE
} WaitEventTimeout;

Function Documentation

pgstat_get_wait_event()

const char* pgstat_get_wait_event

(

uint32

wait_event_info

)

Definition at line 129 of file wait_event.c.

{
    uint32      classId;
    uint16      eventId;
    const char *event_name;
 
    /* report process as not waiting. */
    if (wait_event_info == 0)
        return NULL;
 
    classId = wait_event_info & 0xFF000000;
    eventId = wait_event_info & 0x0000FFFF;
 
    switch (classId)
    {
        case PG_WAIT_LWLOCK:
            event_name = GetLWLockIdentifier(classId, eventId);
            break;
        case PG_WAIT_LOCK:
            event_name = GetLockNameFromTagType(eventId);
            break;
        case PG_WAIT_BUFFER_PIN:
            event_name = "BufferPin";
            break;
        case PG_WAIT_ACTIVITY:
            {
                WaitEventActivity w = (WaitEventActivity) wait_event_info;
 
                event_name = pgstat_get_wait_activity(w);
                break;
            }
        case PG_WAIT_CLIENT:
            {
                WaitEventClient w = (WaitEventClient) wait_event_info;
 
                event_name = pgstat_get_wait_client(w);
                break;
            }
        case PG_WAIT_EXTENSION:
            event_name = "Extension";
            break;
        case PG_WAIT_IPC:
            {
                WaitEventIPC w = (WaitEventIPC) wait_event_info;
 
                event_name = pgstat_get_wait_ipc(w);
                break;
            }
        case PG_WAIT_TIMEOUT:
            {
                WaitEventTimeout w = (WaitEventTimeout) wait_event_info;
 
                event_name = pgstat_get_wait_timeout(w);
                break;
            }
        case PG_WAIT_IO:
            {
                WaitEventIO w = (WaitEventIO) wait_event_info;
 
                event_name = pgstat_get_wait_io(w);
                break;
            }
        default:
            event_name = "unknown wait event";
            break;
    }
 
    return event_name;
}

References GetLockNameFromTagType(), GetLWLockIdentifier(), PG_WAIT_ACTIVITY, PG_WAIT_BUFFER_PIN, PG_WAIT_CLIENT, PG_WAIT_EXTENSION, PG_WAIT_IO, PG_WAIT_IPC, PG_WAIT_LOCK, PG_WAIT_LWLOCK, PG_WAIT_TIMEOUT, pgstat_get_wait_activity(), pgstat_get_wait_client(), pgstat_get_wait_io(), pgstat_get_wait_ipc(), and pgstat_get_wait_timeout().

Referenced by pg_stat_get_activity(), and pg_stat_get_backend_wait_event().

pgstat_get_wait_event_type()

const char* pgstat_get_wait_event_type

(

uint32

wait_event_info

)

Definition at line 74 of file wait_event.c.

{
    uint32      classId;
    const char *event_type;
 
    /* report process as not waiting. */
    if (wait_event_info == 0)
        return NULL;
 
    classId = wait_event_info & 0xFF000000;
 
    switch (classId)
    {
        case PG_WAIT_LWLOCK:
            event_type = "LWLock";
            break;
        case PG_WAIT_LOCK:
            event_type = "Lock";
            break;
        case PG_WAIT_BUFFER_PIN:
            event_type = "BufferPin";
            break;
        case PG_WAIT_ACTIVITY:
            event_type = "Activity";
            break;
        case PG_WAIT_CLIENT:
            event_type = "Client";
            break;
        case PG_WAIT_EXTENSION:
            event_type = "Extension";
            break;
        case PG_WAIT_IPC:
            event_type = "IPC";
            break;
        case PG_WAIT_TIMEOUT:
            event_type = "Timeout";
            break;
        case PG_WAIT_IO:
            event_type = "IO";
            break;
        default:
            event_type = "???";
            break;
    }
 
    return event_type;
}

References PG_WAIT_ACTIVITY, PG_WAIT_BUFFER_PIN, PG_WAIT_CLIENT, PG_WAIT_EXTENSION, PG_WAIT_IO, PG_WAIT_IPC, PG_WAIT_LOCK, PG_WAIT_LWLOCK, and PG_WAIT_TIMEOUT.

Referenced by pg_stat_get_activity(), and pg_stat_get_backend_wait_event_type().

pgstat_report_wait_end()

static void pgstat_report_wait_end ( void  )

inlinestatic

Definition at line 287 of file wait_event.h.

{
    /* see pgstat_report_wait_start() */
    *(volatile uint32 *) my_wait_event_info = 0;
}

References my_wait_event_info.

Referenced by AbortSubTransaction(), AbortTransaction(), AddToDataDirLockFile(), ApplyLogicalMappingFile(), assign_xlog_sync_method(), AutoVacLauncherMain(), BackgroundWriterMain(), basebackup_read_file(), BootStrapXLOG(), CheckpointerMain(), CheckPointLogicalRewriteHeap(), copy_file(), CreateDirAndVersionFile(), CreateLockFile(), dsm_impl_mmap(), dsm_impl_posix_resize(), ExecuteRecoveryCommand(), FilePrefetch(), FileRead(), FileSync(), FileTruncate(), FileWrite(), FileWriteback(), heap_xlog_logical_rewrite(), issue_xlog_fsync(), LWLockReportWaitEnd(), perform_spin_delay(), ProcArrayGroupClearXid(), read_relmap_file(), ReadControlFile(), readTimeLineHistory(), ReadTwoPhaseFile(), RecheckDataDirLockFile(), RecreateTwoPhaseFile(), ReorderBufferSerializeChange(), RestoreArchivedFile(), RestoreSlotFromDisk(), SaveSlotToPath(), SendTimeLineHistory(), shell_archive_file(), ShutdownAuxiliaryProcess(), SlruPhysicalReadPage(), SlruPhysicalWritePage(), SnapBuildRestoreContents(), SnapBuildSerialize(), TransactionGroupUpdateXidStatus(), update_controlfile(), vacuum_delay_point(), WaitEventSetWait(), WaitExceedsMaxStandbyDelay(), WALRead(), WalSndErrorCleanup(), WalWriterMain(), write_relmap_file(), WriteControlFile(), writeTimeLineHistory(), writeTimeLineHistoryFile(), XLogFileCopy(), XLogFileInitInternal(), XLogPageRead(), and XLogWrite().

pgstat_report_wait_start()

static void pgstat_report_wait_start ( uint32  wait_event_info )

inlinestatic

Definition at line 271 of file wait_event.h.

{
    /*
     * Since this is a four-byte field which is always read and written as
     * four-bytes, updates are atomic.
     */
    *(volatile uint32 *) my_wait_event_info = wait_event_info;
}

References my_wait_event_info.

Referenced by AddToDataDirLockFile(), ApplyLogicalMappingFile(), assign_xlog_sync_method(), basebackup_read_file(), BootStrapXLOG(), CheckPointLogicalRewriteHeap(), copy_file(), CreateDirAndVersionFile(), CreateLockFile(), dsm_impl_mmap(), dsm_impl_posix_resize(), ExecuteRecoveryCommand(), FilePrefetch(), FileRead(), FileSync(), FileTruncate(), FileWrite(), FileWriteback(), heap_xlog_logical_rewrite(), issue_xlog_fsync(), LWLockReportWaitStart(), perform_spin_delay(), ProcArrayGroupClearXid(), read_relmap_file(), ReadControlFile(), readTimeLineHistory(), ReadTwoPhaseFile(), RecheckDataDirLockFile(), RecreateTwoPhaseFile(), ReorderBufferSerializeChange(), RestoreArchivedFile(), RestoreSlotFromDisk(), SaveSlotToPath(), SendTimeLineHistory(), shell_archive_file(), SlruPhysicalReadPage(), SlruPhysicalWritePage(), SnapBuildRestoreContents(), SnapBuildSerialize(), TransactionGroupUpdateXidStatus(), update_controlfile(), vacuum_delay_point(), WaitEventSetWait(), WaitExceedsMaxStandbyDelay(), WALRead(), write_relmap_file(), WriteControlFile(), writeTimeLineHistory(), writeTimeLineHistoryFile(), XLogFileCopy(), XLogFileInitInternal(), XLogPageRead(), and XLogWrite().

pgstat_reset_wait_event_storage()

void pgstat_reset_wait_event_storage

(

void

)

Definition at line 62 of file wait_event.c.

{
    my_wait_event_info = &local_my_wait_event_info;
}

References local_my_wait_event_info, and my_wait_event_info.

Referenced by AuxiliaryProcKill(), and ProcKill().

pgstat_set_wait_event_storage()

void pgstat_set_wait_event_storage

(

uint32 *

wait_event_info

)

Definition at line 50 of file wait_event.c.

{
    my_wait_event_info = wait_event_info;
}

References my_wait_event_info.

Referenced by InitAuxiliaryProcess(), and InitProcess().

Variable Documentation

my_wait_event_info

PGDLLIMPORT uint32* my_wait_event_info

extern

Definition at line 38 of file wait_event.c.

Referenced by pgstat_report_wait_end(), pgstat_report_wait_start(), pgstat_reset_wait_event_storage(), and pgstat_set_wait_event_storage().