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 |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
