Updated on 2024-05-07 GMT+08:00

WAIT_EVENTS

WAIT_EVENTS displays statistics about wait events on the current node. For details about the events, see Table 2, Table 3, Table 4, and Table 5. For details about the impact of each transaction lock on services, see LOCK.

Table 1 WAIT_EVENTS columns

Name

Type

Description

nodename

text

Database process 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.