PGXC_WAIT_EVENTS

Updated on 2024-12-18 GMT+08:00

View PDF

PGXC_WAIT_EVENTS displays statistics on the waiting status and events of each node in the cluster. The content is the same as that displayed in GS_WAIT_EVENTS. This view is accessible only to users with system administrators rights.

**Table 1** PGXC_WAIT_EVENTS columns
Name	Type	Description
nodename	name	Node name.
type	text	Event type, which can be STATUS, LOCK_EVENT, LWLOCK_EVENT, or IO_EVENT
event	text	Event name. For details, see PG_THREAD_WAIT_STATUS.
wait	bigint	Number of times an event occurs. This column and all the columns below are values accumulated during process running.
failed_wait	bigint	Number of waiting failures. In the current version, this column is used only for counting timeout errors and waiting failures of locks such as LOCK and LWLOCK.
total_wait_time	bigint	Total duration of the event
avg_wait_time	bigint	Average duration of the event
max_wait_time	bigint	Maximum wait time of the event
min_wait_time	bigint	Minimum wait time of the event