SHOW PARTITIONS command¶
The SHOW PARTITIONS command returns information about all partitions in the Storage services of the current service group.
The following table describes the returned information:
| Column | Description |
|---|---|
partition_id |
The ID of the partition. The row with partition_id equal to 0 represents the system partition (used to store catalog, permissions, and configuration information), and the rest are data partitions. Unless otherwise specified, "partition" in this topic refers to data partitions. |
leader |
The host address of the Storage service where the leader replica is located. |
leader_zone |
The name of the zone where leader replicas are located. If the current service group does not have zones added, it defaults to default. |
peer |
The host addresses of the Storage services where leader replicas and follower replicas are located. For more information about leader replicas and follower replicas, see SHOW PEERS. |
Partition configuration in Developer Edition¶
Developer Edition has one data partition and one system partition, each with one replica. You cannot change the partition or replica count. See Capabilities and limits.
Syntax¶
- show_partitions_command
show_partitions_command ::=
'SHOW' 'PARTITIONS'
Examples¶
SHOW PARTITIONS
The row with partition_id equal to 0 represents the system partition; the other row represents the data partition. Addresses in leader and peer identify the Storage service of the current instance.