This system table lists all the consumer groups known to the system. All users have access to the table.
| Column Name | Description |
|---|---|
CONSUMER_GROUP_NAME
|
Name of the consumer group |
CONSUMER_GROUP_ID
|
ID of the consumer group |
CPU_WEIGHT
|
CPU Weight of the consumer group |
PRECEDENCE
|
Precedence attribute of a consumer group used for tie-breaking |
GROUP_TEMP_DB_RAM_LIMIT
|
Limit for Temp DB RAM usage by all sessions in the consumer group in MB |
USER_TEMP_DB_RAM_LIMIT
|
Limit for Temp DB RAM usage by all sessions of a user in the consumer group in MB |
SESSION_TEMP_DB_RAM_LIMIT
|
Limit for Temp DB RAM usage by each session in MB |
CREATED
|
Timestamp when the consumer group was created |
CONSUMER_GROUP_COMMENT
|
Comment on the consumer group |
QUERY_TIMEOUT
|
Duration (in seconds) a statement may run before it is terminated |
IDLE_TIMEOUT
|
Duration (in seconds) a session is terminated due to inactivity |
