PGXC_RESPOOL_RESOURCE_HISTORY
PGXC_RESPOOL_RESOURCE_HISTORY is used to query historical monitoring information about resource pools on all instances.
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.
|
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.
|
used_mem |
int |
Memory used by the resource pool (unit: MB).
|
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)
|
read_kbytes |
bigint |
Number of logical read bytes in the resource pool within a 5s monitoring period (unit: KB)
|
write_kbytes |
bigint |
Number of logical write bytes in the resource pool within a 5s monitoring period (unit: KB)
|
read_counts |
bigint |
Number of logical reads in the resource pool within a 5s monitoring period
|
write_counts |
bigint |
Number of logical writes in the resource pool within a 5s monitoring period
|
read_speed |
double |
Average rate of logical reads of the resource pool in a 5s monitoring period.
|
write_speed |
double |
Average rate of logical writes of the resource pool in a 5s monitoring period
|
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot