Updated on 2023-10-31 GMT+08:00

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.

Table 1 PGXC_WORKLOAD_SQL_ELAPSE_TIME columns

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