# 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 |
+-------+-----------------+---------------+-----------------+----------------+-------+----------+-------------+------------+-----------------------------------+----------------------------------+

```