Updated on 2024-06-03 GMT+08:00

GLOBAL_WAIT_EVENTS

GLOBAL_WAIT_EVENTS displays statistics about wait events on each node, as described in Table 1.

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.