This topic describes the PARTITION_ID_CALC_DONE diagnostic point.
The PARTITION_ID_CALC_DONE diagnostic point records information of calculating the partition ID based on the query statement. The following table describes the diagnostic information at the PARTITION_ID_CALC_DONE diagnostic point.
| Field | Description | Remarks |
|---|---|---|
| parse_sql | The SQL statement used by OceanBase Database Proxy (ODP) to calculate the partitioning key. | You can check whether the statement meets the expectation. |
| part_name | The partition name specified in the SQL statement. | N/A |
| part_idx | The partition location obtained through calculation. | For more information about partitions, see Create partitions in OMS documentation. |
| sub_part_idx | The subpartition location obtained through calculation. | For more information about partitions, see Create partitions in OMS documentation. |
| partition_id | The partition ID obtained through calculation. | N/A |
| level | The partitioning level, which indicates whether the queried table is a partitioned or subpartitioned table. | Syntax for creating a partitioned table: CREATE TABLE XX PARTITION BY XXX Syntax for creating a subpartitioned table: CREATE TABLE XX PARTITION BY XXX SUBPARTITION BY |