gp_resgroup_config

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. The view also displays proposed limit settings. A proposed limit will differ from a current limit when the limit has been altered, but the new value could not be immediately applied.

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.
`proposed_concurrency`	text	pg_resgroupcapability.proposed for pg_resgroupcapability.reslimittype = 1	The pending concurrency value 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.
`proposed_memory_limit`	text	pg_resgroupcapability.proposed for pg_resgroupcapability.reslimittype = 3	The pending memory limit value 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.
`proposed_memory_shared_quota`	text	pg_resgroupcapability.proposed for pg_resgroupcapability.reslimittype = 4	The pending shared memory quota value 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.
`proposed_memory_spill_ratio`	text	pg_resgroupcapability.proposed for pg_resgroupcapability.reslimittype> = 5	The pending memory spill ratio value for the resource group.

Parent topic: System Catalogs Definitions