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

WAIT_EVENTS

WAIT_EVENTS displays statistics about wait events on the current node, as described in Table 1. 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.