# SHOW RESOURCE POOLS

> **📝 Note**: This command is not available in all editions of SingleStore. For more information, see [SingleStore Editions](https://docs.singlestore.com/db/v9.1/introduction/singlestore-editions.md).

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](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands.md)).
* Refer to the [Permissions Matrix](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/permissions-matrix.md) for the required permissions.

## Example

The [CREATE RESOURCE POOL](https://docs.singlestore.com/db/v9.1/reference/sql-reference/resource-pool-commands/create-resource-pool.md) topic provides an example of using `SHOW RESOURCE POOLS`.

## Related Topics

* For more information about using resource pools to specify resource limits, see [Set Resource Limits](https://docs.singlestore.com/db/v9.1/user-and-cluster-administration/use-the-workload-manager-and-set-resource-limits/set-resource-limits.md).

***

Modified at: January 10, 2023

Source: [/db/v9.1/reference/sql-reference/resource-pool-commands/show-resource-pools/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/resource-pool-commands/show-resource-pools/)

(An index of the documentation is available at /llms.txt)