Skip to main content

SHOW STORAGE VOLUMES

SHOW STORAGE VOLUMES shows the storage volumes in your StarRocks cluster. This feature is supported from v3.1.

tip

This operation does not require privileges.

Syntax​

SHOW STORAGE VOLUMES [ LIKE '<pattern>' ]

Parameters​

ParameterDescription
patternThe pattern used to match the storage volumes.

Return value​

ReturnDescription
Storage VolumeThe name of the storage volume.

Examples​

Example 1: Show all storage volumes in the StarRocks cluster.

MySQL > SHOW STORAGE VOLUMES;
+----------------+
| Storage Volume |
+----------------+
| my_s3_volume |
+----------------+
1 row in set (0.01 sec)

Relevant SQL statements​