> ## Documentation Index
> Fetch the complete documentation index at: https://docs.regatta.dev/llms.txt
> Use this file to discover all available pages before exploring further.

# SHOW INDEX DEVICES

This view returns the list of devices per index in the database.

Note that in this view, specifying the `IN INDEX` index\_name is mandatory.

The output is ordered by the `device_id` column.

The following table lists the output’s columns:

| Column name             | Data type     | Description                                             |
| :---------------------- | :------------ | :------------------------------------------------------ |
| DEVICE\_ID              | `VARCHAR(32)` | The unique device identifier. This is the filter column |
| MODULE\_ID              | `INT`         | The identifier of the module                            |
| DEVICE\_TOTAL\_CAPACITY | `BIGINT`      | Total size in bytes                                     |

For example:

```sql theme={null}
SHOW INDEX DEVICES IN INDEX 'my_table_idx';
```