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. Only the system administrator or the preset role gs_role_read_all_stats can access this view.
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 |