Updated on 2024-05-13 GMT+08:00

PGXC_RESPOOL_RESOURCE_HISTORY

PGXC_RESPOOL_RESOURCE_HISTORY is used to query historical monitoring information about resource pools on all instances.

Table 1 PGXC_RESPOOL_RESOURCE_HISTORY columns

Name

Type

Description

nodename

name

Instance name, including CNs and DNs.

timestamp

timestamp

Persistence duration of resource pool monitoring information

nodegroup

name

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

rpname

name

Resource pool name

cgroup

name

Name of the Cgroup associated with the resource pool

ref_count

int

Number of jobs referenced by the resource pool. The number is counted regardless of whether the job is controlled by the resource pool. This parameter is valid only on CNs.

fast_run

int

Number of running jobs in the fast lane of the resource pool. This parameter is valid only on CNs.

fast_wait

int

Number of jobs queued in the fast lane of the resource pool. This parameter is valid only on CNs.

fast_limit

int

Limit on the number of concurrent fast lane jobs in the resource pool. This parameter is valid only on CNs.

slow_run

int

Number of running jobs in the slow lane of the resource pool. This parameter is valid only on CNs.

slow_wait

int

Number of jobs queued in the slow lane of the resource pool. This parameter is valid only on CNs.

slow_limit

int

Limit on the number of concurrent slow lane jobs in the resource pool. This parameter is valid only on CNs.

used_cpu

double

Average number of used CPUs of the resource pool in a 5s monitoring period. The value is accurate to two decimal places.

  • On a DN, it indicates the number of CPUs used by the resource pool on the current DN.
  • On a CN, it indicates the total CPU usage of resource pools on all DNs.

cpu_limit

int

It indicates the upper limit of available CPUs for resource pools. If the CPU time limit is specified, this parameter indicates the available CPUs for GaussDB(DWS). If the CPU usage limit is specified, this parameter indicates the available CPUs for associated Cgroups.

  • On a DN, it indicates the upper limit of available CPUs for the resource pool on the current DN.
  • On a CN, it indicates the total upper limit of available CPUs for resource pools on all DNs.

used_mem

int

Memory used by the resource pool (unit: MB).

  • On a DN, it indicates the memory usage of the resource pool on the current DN.
  • On a CN, it indicates the total memory usage of resource pools on all DNs.

estimate_mem

int

Estimated memory used by the jobs running in the resource pools on the current CN. This parameter is valid only on CNs.

mem_limit

int

Upper limit of available memory for the resource pool (unit: MB)

  • On a DN, it indicates the upper limit of available memory for the resource pool on the current DN.
  • On a CN, it indicates the total upper limit of available memory for resource pools on all DNs.

read_kbytes

bigint

Number of logical read bytes in the resource pool within a 5s monitoring period (unit: KB)

  • On a DN, it indicates the number of logical read bytes in the resource pool on the current DN.
  • On a CN, it indicates the total logical read bytes of resource pools on all DNs.

write_kbytes

bigint

Number of logical write bytes in the resource pool within a 5s monitoring period (unit: KB)

  • On a DN, it indicates the number of logical write bytes in the resource pool on the current DN.
  • On a CN, it indicates the total logical write bytes of resource pools on all DNs.

read_counts

bigint

Number of logical reads in the resource pool within a 5s monitoring period

  • On a DN, it indicates the number of logical reads in the resource pool on the current DN.
  • On a CN, it indicates the total number of logical reads in resource pools on all DNs.

write_counts

bigint

Number of logical writes in the resource pool within a 5s monitoring period

  • On a DN, it indicates the number of logical writes in the resource pool on the current DN.
  • On a CN, it indicates the total number of logical writes in resource pools on all DNs.

read_speed

double

Average rate of logical reads of the resource pool in a 5s monitoring period.

  • On a DN, it indicates the logical read rate of the resource pool on the current DN.
  • On a CN, it indicates the overall logical read rate of resource pools on all DNs.

write_speed

double

Average rate of logical writes of the resource pool in a 5s monitoring period

  • On a DN, it indicates the logical write rate of the resource pool on the current DN.
  • On a CN, it indicates the overall logical write rate of resource pools on all DNs.