Skip to main content
The SHOW RESOURCE GROUPS statement lists the user-defined resource groups in the cluster. The SHOW RESOURCE GROUP statement shows a single resource group.
This feature is in preview and subject to change. To share feedback and/or issues, contact Support.
To use SHOW RESOURCE GROUPS, you must first enable resource groups.

Required privileges

Only members of the admin role can view resource groups.

Synopsis

To list all resource groups: show_resource_groups syntax diagram To show a single resource group: show_resource_group syntax diagram

Parameters

Response

The following fields are returned for each resource group: SHOW RESOURCE GROUPS does not list the built-in resource groups.

Examples

The examples on this page use the following resource groups:

Show all resource groups

The following statement lists all user-defined resource groups:

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:
If the resource group does not exist, the statement returns an error:

See also