WAIT_EVENT_INFO

WAIT_EVENT_INFO displays the details about wait events.

**Table 1** WAIT_EVENT_INFO columns
Name	Type	Description
module	text	Name of the module an event belongs to.
type	text	Event type.
event	text	Event name.

**Table 2** List of wait events
Module Category	Event Category	Event	Description
Lock	Wait event	acquire lock	Waits for locking until the locking succeeds or times out.
SharedMemory	LWLock event	ShmemIndexLock	Protects the primary index table, a hash table, in shared memory.
Shared buffer	LWLock event	BufMappingLock	Protects operations on a shared-buffer mapping table.
Lmgr	LWLock event	LockMgrLock	Protects the information about a common lock structure.
LWLock	Wait event	acquire lwlock	Waits for a lightweight lock.
I/O	Wait event	wait io	Waits for I/O completion.
COMM	Wait event	wait cmd	Waits for reading network communication packets to complete.
COMM	Wait event	wait pooler get conn	Waits for pooler to obtain connections.
COMM	Wait event	wait pooler abort conn	Waits for pooler to terminate connections.
COMM	Wait event	wait pooler clean conn	Waits for pooler to clear connections.
COMM	Wait event	get conn	Obtains connections to other nodes.
COMM	Wait event	set cmd	Waits for running the SET, RESET, or TRANSACTION BLOCK LEVEL command on the connection.
COMM	Wait event	cancel query	Cancels the SQL statement that is being executed through a connection.
COMM	Wait event	stop query	Stops the query that is being executed through a connection.
COMM	Wait event	wait node	Waits for receiving data through the connection to a node.
COMM	Wait event	flush data	Waits for sending data to other nodes in the network.
COMM	Wait event	stream get conn	Waits for establishing connections to consumer nodes when the stream flow is initialized.
COMM	Wait event	wait producer ready	Waits for every producer to get ready when the stream flow is initialized.
Stream	Wait event	synchronize quit	Waits for the threads in the stream thread group to exit when the stream plan ends.
Stream	Wait event	wait stream group destroy	Waits for destroying the stream node group when the stream plan ends.
Transaction	Wait event	wait transaction sync	Waits for transaction synchronization.
Transaction	Wait event	wait data sync	Waits for the completion of data page synchronization to the standby node.
Transaction	Wait event	wait data sync queue	Waits for putting the data pages that are in the row-store into the synchronization queue.
Transaction	LWLock event	OidGenLock	Prevents different threads from generating the same OID.
Transaction	LWLock event	XidGenLock	Prevents two transactions from obtaining the same XID.
Transaction	LWLock event	ProcArrayLock	Prevents concurrent access to or concurrent modification on the ProcArray shared arrays.
Transaction	LWLock event	SubtransControlLock	Prevents concurrent access to or concurrent modification on the sub-transaction control data structure.
Transaction	LWLock event	MultiXactGenLock	Allocates a unique MultiXact ID in serial mode.
Transaction	LWLock event	TwoPhaseStateLock	Prevents concurrent access to or concurrent modification on two-phase information sharing arrays.
Transaction	LWLock event	SerializableXactHashLock	Prevents concurrent read/write or concurrent write/write on a sharing structure for serializable transactions.
Transaction	LWLock event	SerializableFinishedListLock	Prevents concurrent read/write or concurrent write/write on a shared linked list for completed serial transactions.
Transaction	LWLock event	SerializablePredicateLockListLock	Protects a linked list of serializable transactions that have locks.
Transaction	LWLock event	PredicateLockMgrLock	Protects the information about a lock structure that has serializable transactions.
Transaction	LWLock event	OldSerXid SLRU lwlock	Protects SLRU buffers of old transaction IDs.
Transaction	LWLock event	OldSerXidLock	Protects a structure that records serializable transactions that have conflicts.
Transaction	Lock event	transactionid	Adds a lock to a transaction ID.
Transaction	Lock event	virtualxid	Adds a lock to a virtual transaction ID.
Checkpoint	LWLock event	CheckpointLock	Prevents multi-checkpoint concurrent execution.
Checkpoint	LWLock event	CheckpointerCommLock	Sends file flush requests to a checkpointer. The request structure needs to be inserted to a request queue in serial mode.
Analyze	LWLock event	AutoanalyzeLock	Obtains and releases resources related to a task that allows for autoanalyze execution.
Vacuum	LWLock event	BtreeVacuumLock	Prevents VACUUM from clearing pages that are being used by B-tree indexes.
Vacuum	LWLock event	AutovacuumLock	Accesses the autovacuum worker array in serial mode.
Vacuum	LWLock event	AutovacuumScheduleLock	Distributes tables requiring VACUUM in serial mode.
Auto vacuum	LWLock event	AutovacuumLock	Protects the autovacuum shared memory structure.
Auto vacuum	LWLock event	AutovacuumScheduleLock	Protects the information about autovacuum workers.
Auto analyze	LWLock event	AutoanalyzeLock	Protects the autoAnalyzeFreeProcess variable and ensures that no more than 10 autoanalyze threads are running at the same time.
WAL	Wait event	wait wal sync	Waits for the completion of WAL synchronization from the specified LSN to the standby node.
WAL	I/O event	WALBootstrapSync	Flushes an initialized WAL file to a disk during database initialization.
WAL	I/O event	WALBootstrapWrite	Writes an initialized WAL file during database initialization.
WAL	I/O event	WALCopyRead	Reads operation generated when an existing WAL file is read for replication after archiving and restoration.
WAL	I/O event	WALCopySync	Flushes a replicated WAL file to a disk after archiving and restoration.
WAL	I/O event	WALCopyWrite	Writes operation generated when an existing WAL file is read for replication after archiving and restoration.
WAL	I/O event	WALInitSync	Flushes a newly initialized WAL file to a disk during log reclaiming or writing.
WAL	I/O event	WALInitWrite	Initializes a newly created WAL file to 0 during log reclaiming or writing.
WAL	I/O event	WALRead	Reads data from Xlogs during redo operations on two-phase files.
WAL	I/O event	WALSyncMethodAssign	Flushes all open WAL files to a disk.
WAL	I/O event	WALWrite	Writes a WAL file.
WAL	I/O event	LOGCTRL_SLEEP	Collects statistics on the number of stream control times and the sleep time of log stream control.
WAL	LWLock event	RcvWriteLock	Prevents concurrent call of WalDataRcvWrite.
WAL	LWLock event	WALBufMappingLock	An exclusive (X) lock needs to be added when the next page of an Xlog buffer is initialized.
WAL	LWLock event	WALInsertLock	Prevents multiple programs from writing data to the same Xlog buffer at the same time.
WAL	LWLock event	WALWriteLock	Prevents concurrent WAL write.
Relation	LWLock event	SInvalReadLock	Prevents concurrent execution with invalid message deletion.
Relation	LWLock event	SinvalWriteLock	Prevents concurrent execution with invalid message write and deletion.
Relation	LWLock event	RelCacheInitLock	Adds a lock before any operations are performed on the init file when messages are invalid.
Relation	LWLock event	TablespaceCreateLock	Checks whether a tablespace already exists.
Relation	LWLock event	RelfilenodeReuseLock	Prevents the link to a reused column attribute file from being canceled by mistake.
Relation	Lock event	relation	Adds a lock to a table.
Relation	Lock event	extend	Adds a lock to a table being scaled out.
Relation	Lock event	partition	Adds a lock to a partitioned table.
Relation	Lock event	partition_seq	Adds a lock to a partition of a partitioned table.
WLM	Wait event	wait active statement	Waits for active statements.
WLM	Wait event	wait memory	Waits for free memory.
DDL/DCL	Wait event	create index	Waits for the completion of index creation.
DDL/DCL	Wait event	analyze	Waits for analysis completion.
DDL/DCL	Wait event	vacuum	Waits for the completion of the VACUUM operation.
DDL/DCL	LWLock event	DelayDDLLock	Prevents concurrent DDL operations.
DDL/DCL	Wait event	vacuum full	Waits for the completion of the VACUUM FULL operation.
Executor	Wait event	Sort	Waits for the completion of tuple sorting.
Executor	Wait event	Sort - write file	Writes sorted data to a file temporarily since the memory is limited during merge sort.
Executor	Wait event	Material	Waits for tuple materialization.
Executor	Wait event	Material - write file	Waits for writing a materialized tuple to a file.
Executor	Wait event	HashJoin - build hash	Waits until a hash table is created when a hash join is executed.
Executor	Wait event	HashJoin - write file	Waits for writing the hash result of a tuple to a disk when a hash join is executed.
Executor	Wait event	HashAgg - build hash	Waits until a hash table is created when a hash aggregate is executed.
Executor	Wait event	HashAgg - write file	Waits for writing the hash result of a tuple to a disk when a hash aggregate is executed.
Executor	Wait event	HashSetop - build hash	Waits until a hash table is created when an OP operation is performed using the hash algorithm.
Executor	Wait event	HashSetop - write file	Waits for writing the hash result of a tuple to a disk when an OP operation is performed using the hash algorithm.
Executor	Wait event	wait sync consumer next step	Waits for the stream consumer to perform the next step.
Executor	Wait event	wait sync producer next step	Waits for the stream producer to perform the next step.
GTM	Wait event	gtm connect	Waits for connecting to GTM.
GTM	Wait event	gtm reset xmin	Waits for GTM to reset the minimum transaction ID.
GTM	Wait event	gtm get xmin	Waits for obtaining the minimum transaction ID from GTM.
GTM	Wait event	gtm get gxid	Waits for obtaining the global transaction ID from GTM during transaction startup.
GTM	Wait event	gtm get csn	Waits for obtaining the CSN from GTM during transaction startup.
GTM	Wait event	gtm get snapshot	Waits for obtaining snapshots from GTM during transaction startup.
GTM	Wait event	gtm begin trans	Waits for GTM to start a transaction.
GTM	Wait event	gtm commit trans	Waits for GTM to commit a transaction.
GTM	Wait event	gtm rollback trans	Waits for GTM to roll back transactions.
GTM	Wait event	gtm start preprare trans	Waits for GTM to complete the first phase during two-phase commit.
GTM	Wait event	gtm prepare trans	Waits for GTM to complete the second phase during two-phase commit.
GTM	Wait event	gtm open sequence	Waits for GTM to create a sequence.
GTM	Wait event	gtm close sequence	Waits for GTM to complete the ALTER SEQUENCE operation.
GTM	Wait event	gtm set sequence val	Waits for GTM to set a sequence value.
GTM	Wait event	gtm drop sequence	Waits for GTM to delete a sequence.
GTM	Wait event	gtm rename sequence	Waits for GTM to rename a sequence.
GTM	LWLock event	GTMHostInfoLock	Protects GTM information.
Temp File	I/O event	BufFileRead	Reads data from a temporary file to a specified buffer.
Temp File	I/O event	BufFileWrite	Writes the content of a specified buffer to a temporary file.
Pg_control	I/O event	ControlFileRead	Reads the pg_control file, mainly during database startup, checkpoint execution, and primary/standby verification.
Pg_control	I/O event	ControlFileSync	Flushes the pg_control file to a disk, mainly during database initialization.
Pg_control	I/O event	ControlFileSyncUpdate	Flushes the pg_control file to a disk, mainly during database startup, checkpoint execution, and primary/standby verification.
Pg_control	I/O event	ControlFileWrite	Writes the pg_control file, mainly during database initialization.
Pg_control	I/O event	ControlFileWriteUpdate	Updates the pg_control file, mainly during database startup, checkpoint execution, and primary/standby verification.
Pg_control	LWLock event	ControlFileLock	Prevents concurrent read/write or concurrent write/write on the pg_control file.
File operation	I/O event	CopyFileRead	Reads a file during file copying.
File operation	I/O event	CopyFileWrite	Writes a file during file copying.
File operation	I/O event	DataFileExtend	Writes a file during file name extension.
Table data file	I/O event	DataFileImmediateSync	Flushes a table data file to a disk immediately.
Table data file	I/O event	DataFilePrefetch	Reads a table data file asynchronously.
Table data file	I/O event	DataFileRead	Reads a table data file synchronously.
Table data file	I/O event	DataFileSync	Synchronizes a table data file to a disk.
Table data file	I/O event	DataFileTruncate	Truncates a table data file.
Table data file	I/O event	DataFileWrite	Writes a table data file.
Table data file	LWLock event	SyncScanLock	Determines the start position of a relfilenode during heap scanning.
Table data file	LWLock event	RelationMappingLock	Waits for the mapping file between system catalogs and storage locations to be updated.
metadata	LWLock event	MetaCacheSweepLock	Adds a lock when metadata is cyclically washed out.
postmaster.pid	I/O event	LockFileAddToDataDirRead	Reads the postmaster.pid file.
postmaster.pid	I/O event	LockFileAddToDataDirSync	Flushes the postmaster.pid file to a disk.
postmaster.pid	I/O event	LockFileAddToDataDirWrite	Writes PID information into the postmaster.pid file.
Pid File	I/O event	LockFileCreateRead	Reads the LockFile file %s.lock.
Pid File	I/O event	LockFileCreateSync	Flushes the LockFile file %s.lock to a disk.
Pid File	I/O event	LockFileCreateWRITE	Writes PID information into the LockFile file %s.lock.
System catalog mapping file	I/O event	RelationMapRead	Reads the mapping file between system catalogs and storage locations.
System catalog mapping file	I/O event	RelationMapSync	Flushes the mapping file between system catalogs and storage locations to a disk.
System catalog mapping file	I/O event	RelationMapWrite	Writes the mapping file between system catalogs and storage locations.
Streaming replication	I/O event	ReplicationSlotRead	Reads a streaming replication slot file during a restart.
Streaming replication	I/O event	ReplicationSlotRestoreSync	Flushes a streaming replication slot file to a disk.
Streaming replication	I/O event	ReplicationSlotSync	Flushes a temporary streaming replication slot file to a disk during checkpoint execution.
Streaming replication	I/O event	ReplicationSlotWrite	Writes a temporary streaming replication slot file during checkpoint execution.
Streaming replication	LWLock event	ReplicationSlotAllocationLock	Allocates a replication slot.
Streaming replication	LWLock event	ReplicationSlotControlLock	Detects replication slot name conflicts and identifies replication slots that can be allocated.
Clog	I/O event	SLRUFlushSync	Flushes the pg_clog file to a disk, mainly during checkpoint execution and database shutdown.
Clog	I/O event	SLRURead	Reads the pg_clog file.
Clog	I/O event	SLRUSync	Writes dirty pages into the pg_clog file, and flushes the file to a disk, mainly during checkpoint execution and database shutdown.
Clog	I/O event	SLRUWrite	Writes the pg_clog file.
Clog	LWLock event	CLogControlLock	Prevents concurrent access to or concurrent modification on the Clog control data structure.
Clog	LWLock event	MultiXactOffsetControlLock	Prevents concurrent read/write or concurrent write/write on pg_multixact/offset.
Clog	LWLock event	MultiXactMemberControlLock	Prevents concurrent read/write or concurrent write/write on pg_multixact/members.
timelinehistory	I/O event	TimelineHistoryRead	Reads the timelinehistory file during database startup.
timelinehistory	I/O event	TimelineHistorySync	Flushes the timelinehistory file to a disk during database startup.
timelinehistory	I/O event	TimelineHistoryWrite	Writes the timelinehistory file.
pg_twophase	I/O event	TwophaseFileRead	Reads the pg_twophase file, mainly during two-phase transaction commit and restoration.
pg_twophase	I/O event	TwophaseFileSync	Flushes the pg_twophase file to a disk, mainly during two-phase transaction commit and restoration.
pg_twophase	I/O event	TwophaseFileWrite	Writes the pg_twophase file, mainly during two-phase transaction commit and restoration.
Cluster	LWLock event	NodeTableLock	Protects a shared structure that stores CNs and DNs information.
Concurrency	LWLock event	PoolerLock	Prevents two threads from simultaneously obtaining the same connection from a connection pool.
Concurrency	LWLock event	AsyncCtlLock	Prevents concurrent access to or concurrent modification on the sharing notification status.
Concurrency	LWLock event	AsyncQueueLock	Prevents concurrent access to or concurrent modification on the sharing notification queue.
Double write	I/O event	DoubleWriteFileWrite	Writes pages to a doublewrite file during the doublewrite process.
Double write	I/O event	DoubleWriteFileRead	Reads a doublewrite file during restoration for a halfwrite.
Statistics file	LWLock event	FileStatLock	Protects a data structure that stores statistics file information.
Master-slave replication	LWLock event	SyncRepLock	Protects Xlog synchronization information during primary/standby replication.
Master-slave replication	LWLock event	ReplicationSlotAllocationLock	Adds a lock when a primary node allocates streaming replication slots during primary/standby replication.
Master-slave replication	LWLock event	ReplicationSlotControlLock	Prevents concurrent update of streaming replication slot status during primary/standby replication.
Master-slave replication	LWLock event	LsnXlogChkFileLock	Serially updates the Xlog flush points for primary and standby nodes recorded in a specific structure.
Master-slave replication	LWLock event	DataSyncRepLock	Protects data page synchronization information during primary/standby replication.
Speed up the cluster	LWLock event	SearchServerLibLock	Adds a lock on the file read operation when a specific dynamic library is initially loaded in GPU-accelerated scenarios.
Resource manage	LWLock event	ResourcePoolHashLock	Prevents concurrent access to or concurrent modification on a resource pool table, a hash table.
Resource manage	LWLock event	WorkloadStatHashLock	Prevents concurrent access to or concurrent modification on a hash table that contains SQL requests from the CN side.
Resource manage	LWLock event	WorkloadIoStatHashLock	Prevents concurrent access to or concurrent modification on a hash table that contains I/O information of the current DN.
Resource manage	LWLock event	WorkloadCGroupHashLock	Prevents concurrent access to or concurrent modification on a hash table that contains Cgroup information.
Resource manage	LWLock event	WorkloadRecordLock	Prevents concurrent access to or concurrent modification on a hash table that contains requests received by CNs during adaptive memory management.
Resource manage	LWLock event	WorkloadIOUtilLock	Protects a structure that records iostat and CPU load information.
Resource manage	LWLock event	WorkloadNodeGroupLock	Prevents concurrent access to or concurrent modification on a hash table that contains node group information in memory.
OBS	LWLock event	OBSGetPathLock	Prevents concurrent read/write or concurrent write/write on an OBS path.
OBS	LWLock event	OBSRuntimeLock	Obtains environment variables, for example, GAUSSHOME.
MPP is compatible with ORACLE scheduled task function	LWLock event	JobShmemLock	Used to protect global variables in the shared memory that is periodically read during a scheduled job where MPP is compatible with Oracle Database.
Operator history information statistics	LWLock event	OperatorRealTLock	Prevents concurrent access to or concurrent modification on a global structure that contains real-time data at the operator level.
Operator history information statistics	LWLock event	OperatorHistLock	Prevents concurrent access to or concurrent modification on a global structure that contains historical data at the operator level.
query history information statistics	LWLock event	SessionRealTLock	Prevents concurrent access to or concurrent modification on a global structure that contains real-time data at the query level.
query history information statistics	LWLock event	SessionHistLock	Prevents concurrent access to or concurrent modification on a global structure that contains historical data at the query level.
query history information statistics	LWLock event	WaitCountHashLock	Protects a shared structure in user statement counting scenarios.
barrier	LWLock event	BarrierLock	Ensures that only one thread is creating a barrier at a time.
CSN	LWLock event	CSNBufMappingLock	Protects CSN pages.
instrumentation	LWLock event	UniqueSQLMappingLock	Protects a unique SQL hash table.
instrumentation	LWLock event	InstrUserLock	Protects InstrUserHTAB.
instrumentation	LWLock event	PercentileLock	Protects global percentile buffers.
instrumentation	LWLock event	InstrWorkloadLock	Protects a workload transaction hash table.
Pgproc	LWLock event	Pgproc lwlock	Protects the PGPROC structure.
Async buffer	LWLock event	AsyncCtlLock	Protects asynchronization buffers.
MultiXact	LWLock event	MultiXactOffset lwlock	Protects SLRU buffers of a MultiXact offset.
MultiXact	LWLock event	MultiXactMemberlwlock	Protects SLRU buffer of a MultiXact member.
CBM	LWLock event	CBMParseXlogLock	Protects the lock used when CBM parses Xlogs.
BadBlock	LWLock event	BadBlockStatHashLock	Protects the hash table global_bad_block_stat.
Page	Lock event	page	Adds a lock to a table page.
Tuple	Lock event	tuple	Adds a lock to a tuple on a page.
object	Lock event	object	Adds a lock to an object.
user	Lock event	userlock	Adds a lock to a user.
advisor	Lock event	advisory	Adds an advisory lock.
ODBC	LWLock event	ExtensionConnectorLibLock	Adds a lock when a specific dynamic library is loaded or uninstalled in ODBC connection initialization scenarios.
Undo	Wait event	wait fetch undo record	Waits for reading the target undo record.
Heap	Wait event	wait heap hot search buffer	Waits for reading the Astore tuple that meets the snapshot requirements through the hot link.
LWLock	Wait event	wait exclusive lwlock	The starvation prevention mechanism is triggered. A new lightweight lock request waits for the previously blocked lightweight lock to be obtained.