gp_resgroup_config
The gp_toolkit.gp_resgroup_config view displays the current CPU, memory, and concurrency limits for a resource group.
| Column | Type | References | Description |
|---|---|---|---|
groupid |
oid |
pg_resgroup.oid |
The ID of the resource group |
groupname |
name |
pg_resgroup.rsgname |
The name of the resource group |
concurrency |
text |
pg_resgroupcapability.value for pg_resgroupcapability.reslimittype = 1 |
The concurrency ( |
cpu_rate_limit |
text |
pg_resgroupcapability.value for pg_resgroupcapability.reslimittype = 2 |
The CPU limit ( |
memory_limit |
text |
pg_resgroupcapability.value for pg_resgroupcapability.reslimittype = 3 |
The memory limit ( |
memory_shared_quota |
text |
pg_resgroupcapability.value for pg_resgroupcapability.reslimittype = 4 |
The shared memory quota ( |
memory_spill_ratio |
text |
pg_resgroupcapability.value for pg_resgroupcapability.reslimittype = 5 |
The memory spill ratio ( |
memory_auditor |
text |
pg_resgroupcapability.value for pg_resgroupcapability.reslimittype = 6 |
The memory auditor in use for the resource group |
cpuset |
text |
pg_resgroupcapability.value for pg_resgroupcapability.reslimittype = 7 |
The CPU cores reserved for the resource group, or |