Help Center> GaussDB> Distributed_2.x> Schemas> DBE_PERF Schema> Wait Event> GLOBAL_WAIT_EVENTS

Updated on 2023-10-23 GMT+08:00

View PDF

GLOBAL_WAIT_EVENTS

GLOBAL_WAIT_EVENTS displays statistics about wait events on each node. To query a view, you must have the sysadmin or monitor admin permission.

**Table 1** GLOBAL_WAIT_EVENTS columns
Name	Type	Description
nodename	text	Node name
type	text	Event type
event	text	Event name
wait	bigint	Number of waiting times
failed_wait	bigint	Number of waiting failures
total_wait_time	bigint	Total waiting time (unit: μs)
avg_wait_time	bigint	Average waiting time (unit: μs)
max_wait_time	bigint	Maximum waiting time (unit: μs)
min_wait_time	bigint	Minimum waiting time (unit: μs)
last_updated	timestamp with time zone	Last time when the event was updated