Overview
gv$merge_info displays statistics related to compactions that have been completed in the OceanBase cluster.
Field description
| Field name | Type | Nullable | Description |
|---|---|---|---|
| svr_ip | varchar(32) | No | The IP address of the OBServer. |
| svr_port | BIGINT(20) | No | The port number of the OBServer. |
| 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: * minor * major |
| action | varchar(64) | No | The specific compaction action. Valid values: * mini * mini minor * buffer minor * minor |
| 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. |