gp_resgroup_status_per_segment

gp_resgroup_status_per_segment

The gp_toolkit.gp_resgroup_status_per_segment view allows administrators to see current memory and CPU usage and allocation for each resource group on a per-host and per-segment basis.

Memory amounts are specified in MBs.

Note

The gp_resgroup_status_per_segment view is valid only when resource group-based resource management is active.

column	type	references	description
`rsgname`	name	pg_resgroup.rsgname	The name of the resource group.
`groupid`	oid	pg_resgroup.oid	The ID of the resource group.
`hostname`	text	gp_segment_configuration.hostname	The hostname of the segment host.
`segment_id`	smallint	gp_segment_configuration.content	The content ID for a segment instance on the segment host.
`cpu`	numeric		The real-time, per-segment instance CPU core usage by the resource group on the host. The value is the sum of the percentages (as a decimal value) of the CPU cores that are used by the resource group for the segment instance.
`memory_used`	integer		The real-time memory usage of the resource group for the segment instance on the host. This total includes resource group fixed and shared memory. It also includes global shared memory used by the resource group.
`memory_available`	integer		The unused fixed and shared memory for the resource group for the segment instance on the host.
`memory_quota_used`	integer		The real-time fixed memory usage for the resource group for the segment instance on the host.
`memory_quota_available`	integer		The fixed memory available to the resource group for the segment instance on the host.
`memory_shared_used`	integer		The group shared memory used by the resource group for the segment instance on the host.
`memory_shared_available`	integer		The amount of group shared memory available for the segment instance on the host. Resource group global shared memory is not included in this total.

Parent topic: System Catalogs Definitions