SHOW RESOURCE GROUPS statement lists the user-defined resource groups in the cluster. The SHOW RESOURCE GROUP statement shows a single resource group.
To use SHOW RESOURCE GROUPS, you must first enable resource groups.
Required privileges
Only members of theadmin role can view resource groups.
Synopsis
To list all resource groups: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 thereporting resource group. The cpu_share_percent value is calculated from the weights of all user-defined resource groups:

