Updated on 2022-08-16 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. It is accessible only to users with system administrator rights.

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