The gp_toolkit.gp_resgroup_config view allows administrators to see the current CPU, memory, and concurrency limits for a resource group.
NoteThe
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. |
Parent topic: System Catalogs Definitions
