Updated on 2024-12-19 GMT+08:00

PGXC_INSTANCE_TIME

PGXC_INSTANCE_TIME displays the running time of processes on each node in the cluster and the time consumed in each execution phase. Except the node_name column, the other columns are the same as those in the PV_INSTANCE_TIME view. Only the system administrator or the preset role gs_role_read_all_stats can access this view.

Table 1 PGXC_INSTANCE_TIME columns

Name

Type

Description

node_name

text

Node name

stat_id

integer

Type ID

stat_name

text

Name of the runtime type

value

bigint

Running time value