Purpose
gv$partition displays the meta information of all partitions in the cluster.
Related tables/views
oceanbase.__all_virtual_partition_table
oceanbase.gv$table
Fields
| Field | Type | Nullable? | Description |
|---|---|---|---|
| tenant_id | bigint(20) | NO | The ID of the tenant. |
| table_id | bigint(20) | NO | The ID of the table. |
| tablegroup_id | bigint(20) | NO | The ID of the table group. |
| partition_id | bigint(20) | NO | The ID of the partition. |
| svr_ip | varchar(32) | NO | The IP address of the OBServer node. |
| svr_port | bigint(20) | NO | The port number of the OBServer node. |
| sql_port | bigint(20) | NO | The SQL port of the OBServer node. |
| unit_id | bigint(20) | NO | The ID of the unit. |
| partition_cnt | bigint(20) | NO | The number of partitions. This field is no longer in use and is meaningless. |
| zone | varchar(128) | NO | The zone where the replica is located. |
| role | bigint(20) | NO | The role of the replica. Valid values: |
| member_list | varchar(3520) | NO | The list of members in the Paxos group. |
| row_count | bigint(20) | NO | The number of rows. |
| data_size | bigint(20) | NO | The amount of data. |
| data_version | bigint(20) | NO | The data version. |
| partition_checksum | bigint(20) | NO | The checksum of the partition. |
| data_checksum | bigint(20) | NO | The checksum of the data. |
| row_checksum | bigint(20) | NO | The row checksum. |
| column_checksum | varchar(8192) | NO | The column checksum. |
| rebuild | bigint(20) | NO | Indicates whether the partition is in the rebuild state. |
| replica_type | bigint(20) | NO | The replica type. Valid values: |
| required_size | bigint(20) | NO | The size required for migrating the partition. |
| status | varchar(64) | NO | The status of the replica. |
| is_restore | bigint(20) | NO | Indicates whether the replica is being logically or physically restored. |
| quorum | bigint(20) | NO | The number of members that the Paxos group needs to contain. This field is valid only for rows whose role is equal to 1. It is used to calculate the majority. |