Skip to main content
Version: Latest-3.5

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​