gp_resgroup_config
The gp_toolkit.gp_resgroup_config view allows administrators to see the current CPU, memory, and concurrency limits for a resource group.
Note The
gp_resgroup_configview is valid only when resource group-based resource management is active.
| 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 (CONCURRENCY) value specified for the resource group. |
cpu_rate_limit | text | pg_resgroupcapability.value for pg_resgroupcapability.reslimittype = 2 | The CPU limit (CPU_RATE_LIMIT) value specified for the resource group, or -1. |
memory_limit | text | pg_resgroupcapability.value for pg_resgroupcapability.reslimittype = 3 | The memory limit (MEMORY_LIMIT) value specified for the resource group. |
memory_shared_quota | text | pg_resgroupcapability.value for pg_resgroupcapability.reslimittype = 4 | The shared memory quota (MEMORY_SHARED_QUOTA) value specified for the resource group. |
memory_spill_ratio | text | pg_resgroupcapability.value for pg_resgroupcapability.reslimittype = 5 | The memory spill ratio (MEMORY_SPILL_RATIO) value specified for the resource group. |
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 -1. |