# SHOW RESOURCE POOLS

> **📝 Note**: This command is not available in all editions of SingleStore. For more information, see [SingleStore Helios Editions](https://docs.singlestore.com/cloud/getting-started-with-singlestore-helios/about-singlestore-helios/singlestore-helios-editions.md).

Lists all resource pools and their field values.

## Syntax

```sql
SHOW RESOURCE POOLS

```

## Example

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

***

Modified at: January 10, 2023

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

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