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.
Column |
Type |
Description |
|---|---|---|
node_name |
Text |
Node name |
stat_id |
Integer |
Type ID |
stat_name |
Text |
Name of the runtime type |
value |
Bigint |
Runtime value |