Purpose
gv$merge_info displays the statistics related to compactions that have been completed in the OceanBase cluster.
Fields
| Field | Type | Nullable? | Description |
|---|---|---|---|
| svr_ip | varchar(32) | NO | The IP address of the server. |
| svr_port | bigint(20) | NO | The port number of the server. |
| tenant_id | bigint(20) | NO | The ID of the tenant. |
| table_id | bigint(20) | NO | The ID of the table. |
| partition_id | bigint(20) | NO | The ID of the partition. |
| type | varchar(5) | NO | The type of the compaction. Valid values: |
| action | varchar(64) | NO | The specific compaction action. Valid values: |
| version | varchar(64) | NO | The version of the compaction. |
| start_time | timestamp(6) | NO | The time when the compaction started. |
| end_time | timestamp | NO | The time when the compaction ended. |
| macro_block_count | bigint(20) | NO | The total number of macro blocks in the compaction. |
| reuse_pct | DECIMAL(26,2) | NO | The reuse rate of macro blocks in the compaction. |
| parallel_degree | bigint(20) | NO | The degree of parallelism of the compaction. |