Description

The SHOW COMPUTE GROUPS command is used to display information about all configured compute groups in the system. Compute groups are logical units used to manage and organize computational resources, helping users allocate and utilize system resources more effectively.

This command assists administrators and users in quickly understanding the existing compute group configurations in the system, including the name, attributes, and other relevant information for each compute group. This is particularly useful for resource management, performance optimization, and system monitoring.

Syntax

    SHOW COMPUTE GROUPS

Return Values

This command returns a result set containing the following columns:

• Name: The name of the compute group.
• IsCurrent: Indicates whether it is the current working compute group.
• Users: Displays the list of users who have permission to use this compute group.
• BackendNum: Shows the number of backends (compute nodes) currently allocated to this compute group.

Related Commands

• ALTER SYSTEM ADD BACKEND
• GRANT
• REVOKE
• SET DEFAULT COMPUTE GROUP

Keywords

SHOW, COMPUTE GROUPS