Skip to main content
Version: Stable-3.1

SHOW STORAGE VOLUMES

Description

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