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 nameData typeDescription
DEVICE_IDVARCHAR(32)The unique device identifier. This is the filter column
MODULE_IDINTThe identifier of the module
DEVICE_TOTAL_CAPACITYBIGINTTotal size in bytes

For example:

SHOW INDEX DEVICES IN INDEX 'my_table_idx';