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

WAIT_EVENTS

WAIT_EVENTS displays statistics about wait events on the current node. For key events in the kernel, see Table 2. Alternatively, view the list of all events in the system in the wait_event_info view. For details about the impact of each transaction lock on services, see LOCK.

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