Updated on 2023-04-14 GMT+08:00

PGXC_RESPOOL_RUNTIME_INFO

PGXC_RESPOOL_RUNTIME_INFO displays the running information about all resource pool jobs on all CNs.

Table 1 PGXC_RESPOOL_RUNTIME_INFO columns

Name

Type

Description

nodename

name

CN name

nodegroup

name

Name of the logical cluster of the resource pool. The default value is installation

rpname

name

Resource pool name

ref_count

int

Number of jobs referenced by resource pools. The number is counted regardless of whether a job is controlled by a resource pool.

fast_run

int

Number of running jobs in the fast lane of the resource pool

fast_wait

int

Number of jobs queued in the fast lane of the resource pool

slow_run

int

Number of running jobs in the slow lane of the resource pool

slow_wait

int

Number of jobs queued in the slow lane of the resource pool