Help Center/ GaussDB(DWS)/ Developer Guide/ Standard data warehouse (9.1.0.x)/ GaussDB(DWS) System Catalogs and Views/ System Views/ PGXC_RESPOOL_RUNTIME_INFO
Updated on 2024-09-02 GMT+08:00
View PDF
Share

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 the resource pool belongs to. The default cluster is installation.

rpname

name

Resource pool name.

ref_count

int

Number of jobs that reference the resource pool. This count includes both controlled and uncontrolled jobs.

fast_run

int

Number of jobs currently running in the resource pool's fast lane.

fast_wait

int

Number of jobs currently queued in the resource pool's fast lane.

slow_run

int

Number of jobs currently running in the resource pool's slow lane.

slow_wait

int

Number of jobs currently queued in the resource pool's slow lane.
Parent topic: System Views