> For the complete documentation index, see [llms.txt](https://docs.deltastream.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.deltastream.io/reference/sql-syntax/command/list-compute_pools.md).

# LIST COMPUTE\_POOLS

## Syntax

```sql
[LIST | SHOW] COMPUTE_POOLS;
```

## Description

This provides a list of[ ](https://docs.deltastream.io/overview/core-concepts/store)compute\_pools to which you have access.

{% hint style="warning" %}
**Important** You're only able to list compute\_pools if your current role has USAGE privileges.
{% endhint %}

## Example

```sh
mydb.public/mystore# show COMPUTE_POOLS;
+-------+-----------------+---------------+-----------------+----------------+-------+----------+-------------+------------+-----------------------------------+----------------------------------+
|  Name |  Intended State |  Actual State |  Error Messages |  Access Region |  Size |  Timeout |  Is Default |    Owner   |             Created At            |            Updated At            |
+-------+-----------------+---------------+-----------------+----------------+-------+----------+-------------+------------+-----------------------------------+----------------------------------+
| "abc" | stopped         | stopped       |                 | K3D us-east-1  | small |      120 | true        | "sysadmin" | 2025-02-25 15:13:03.935 +0000 UTC | 2025-03-04 03:04:04.34 +0000 UTC |
+-------+-----------------+---------------+-----------------+----------------+-------+----------+-------------+------------+-----------------------------------+----------------------------------+

```