PGXC_WORKLOAD_SQL_ELAPSE_TIME
PGXC_WORKLOAD_SQL_ELAPSE_TIME displays statistics on the response time of SQL statements in workload Cgroups on all CNs in a cluster, including the maximum, minimum, average, and total response time of SELECT, UPDATE, INSERT, and DELETE statements. The unit is microsecond. It is accessible only to users with system administrator rights.
| Name | Type | Description |
|---|---|---|
| node_name | name | Node name |
| workload | name | Workload Cgroup name |
| total_select_elapse | bigint | Total response time of SELECT statements |
| max_select_elapse | bigint | Maximum response time of SELECT statements |
| min_select_elapse | bigint | Minimum response time of SELECT statements |
| avg_select_elapse | bigint | Average response time of SELECT statements |
| total_update_elapse | bigint | Total response time of UPDATE statements |
| max_update_elapse | bigint | Maximum response time of UPDATE statements |
| min_update_elapse | bigint | Minimum response time of UPDATE statements |
| avg_update_elapse | bigint | Average response time of UPDATE statements |
| total_insert_elapse | bigint | Total response time of INSERT statements |
| max_insert_elapse | bigint | Maximum response time of INSERT statements |
| min_insert_elapse | bigint | Minimum response time of INSERT statements |
| avg_insert_elapse | bigint | Average response time of INSERT statements |
| total_delete_elapse | bigint | Total response time of DELETE statements |
| max_delete_elapse | bigint | Maximum response time of DELETE statements |
| min_delete_elapse | bigint | Minimum response time of DELETE statements |
| avg_delete_elapse | bigint | Average response time of DELETE statements |
Last Article: PGXC_WORKLOAD_SQL_COUNT
Next Article: GS_WORKLOAD_TRANSACTION
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.