SHOW RESOURCE GROUPS

The SHOW RESOURCE GROUPS lists the user-defined in the cluster. The SHOW RESOURCE GROUP statement shows a single resource group.

This feature is in and subject to change. To share feedback and/or issues, contact Support.

To use SHOW RESOURCE GROUPS, you must first .

Required privileges

Only members of the can view resource groups.

Synopsis

To list all resource groups:

To show a single resource group:

Parameters

Parameter	Description
`name`	The name of the resource group to show. If no resource group with this name exists, `SHOW RESOURCE GROUP` returns an error.

Response

The following fields are returned for each resource group:

Column	Type	Description
`id`	`INT`	The ID of the resource group.
`name`	`STRING`	The name of the resource group.
`cpu_weight`	`INT`	The CPU weight of the resource group.
`max_cpu`	`BOOL`	Whether the resource group stays in the burst tier when it uses more than its share of CPU. For details, refer to .
`cpu_share_percent`	`FLOAT`	The resource group’s `cpu_weight` as a percentage of the sum of the `cpu_weight` values of all user-defined resource groups. This value does not include the built-in resource groups. For details, refer to .

SHOW RESOURCE GROUPS does not list the .

Examples

The examples on this page use the following resource groups:

CREATE RESOURCE GROUP oltp WITH (cpu_weight = 300, max_cpu = true);

CREATE RESOURCE GROUP reporting WITH (cpu_weight = 100);

Show all resource groups

The following statement lists all user-defined resource groups:

SHOW RESOURCE GROUPS;

  id |   name    | cpu_weight | max_cpu | cpu_share_percent
-----+-----------+------------+---------+--------------------
  17 | oltp      |        300 |    t    |                75
  18 | reporting |        100 |    f    |                25
(2 rows)

Show a single resource group

The following statement shows the reporting resource group. The cpu_share_percent value is calculated from the weights of all user-defined resource groups:

SHOW RESOURCE GROUP reporting;

  id |   name    | cpu_weight | max_cpu | cpu_share_percent
-----+-----------+------------+---------+--------------------
  18 | reporting |        100 |    f    |                25
(1 row)

If the resource group does not exist, the statement returns an error:

SHOW RESOURCE GROUP nosuch;

ERROR: resource group "nosuch" does not exist
SQLSTATE: 42704

Statements

Syntax

Data Types

Spatial Data

Constraints

Required privileges

Synopsis

Parameters

Response

Examples

Show all resource groups

Show a single resource group

See also

​Required privileges

​Synopsis

​Parameters

​Response

​Examples

​Show all resource groups

​Show a single resource group

​See also

Required privileges

Synopsis

Parameters

Response

Examples

Show all resource groups

Show a single resource group

See also