GS_WAIT_EVENTS

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

View PDF

GS_WAIT_EVENTS displays statistics about waiting status and events on the current node.

The values of statistical columns in this view are accumulated only when the enable_track_wait_event GUC parameter is set to on. If enable_track_wait_event is set to off during statistics measurement, the statistics will no longer be accumulated, but the existing values are not affected. If enable_track_wait_event is off, 0 row is returned when this view is queried.

**Table 1** GS_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

In the current version, for events whose type is LOCK_EVENT, LWLOCK_EVENT, or IO_EVENT, the display scope of GS_WAIT_EVENTS is the same as that of the corresponding events in the PG_THREAD_WAIT_STATUS view.

For events whose type is STATUS, GS_WAIT_EVENTS displays the following waiting status columns. For details, see the PG_THREAD_WAIT_STATUS view.