PGXC_WAIT_EVENTS¶
PGXC_WAIT_EVENTS displays statistics on the waiting status and events of each node in the cluster. The content is the same as that displayed in GS_WAIT_EVENTS. This view is accessible only to users with system administrators rights.
Column | 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 |