System Catalogs Definitions - gp_resgroup_config - 《Greenplum Database v6.23 Documentation》

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_config view 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