SHOW RESOURCE POOLS

On this page

Note

This command is not available in all editions of SingleStore. For more information, see SingleStore Editions.

Lists all resource pools and their field values.

Syntax

SQL

SHOW RESOURCE POOLS

Remarks

This command can be run on any node (see Cluster Management Commands).
Refer to the Permission Matrix for the required permission.

Example

The CREATE RESOURCE POOL topic provides an example of using SHOW RESOURCE POOLS.

For more information about using resource pools to specify resource limits, see Set Resource Limits.

Last modified: January 10, 2023

Was this article helpful?