Note
This view is available starting with V4.4.1.
Purpose
The DBA_OB_VECTOR_INDEX_TASKS view displays information about vector index partition rebuild tasks in the current tenant.
Columns
| Column | Type | Nullable | Description | |
|---|---|---|---|---|
| TABLE_ID | bigint(20) | YES | The table ID. | |
| TABLET_ID | bigint(20) | YES | The partition ID. | |
| TASK_ID | bigint(20) | YES | The task ID. | |
| START_TIME | timestamp(6) | YES | The start time of the task. | |
| MODIFY_TIME | timestamp(6) | YES | The end time of the task. | |
| TRIGGER_TYPE | varchar(16) | NO | The type of the task trigger. Valid values:
|
|
| STATUS | varchar(16) | NO | The status of the task. Valid values:
|
|
| TASK_TYPE | bigint(20) | NO | The type of the task. Valid values:
|
|
| TASK_SCN | bigint(20) | NO | The task version number. | |
| RET_CODE | bigint(20) | NO | The status of the task. Valid values:
|
|
| TRACE_ID | varchar(512) | NO | The task execution trace ID. | |
| PROGRESS_INFO | varchar(512) | NO | The task execution progress information, in JSON format. It usually includes the current operation, estimated number of rows, number of completed rows, completion percentage, and estimated remaining time. This information is updated every 10 seconds. The JSON string contains the status, estimated_row, finished_row, progress, and time_remaining(s) fields.
|
|
| TASK_INFO | long text | NO | The detailed progress information of the task. It is displayed in JSON format and includes detailed information about each segment in the major compaction task, such as the SCN, key range, index, and memory usage. This information helps you comprehensively understand the execution process of the task. |
Sample query
In the sys tenant, query the information about vector index performance optimization tasks of all tenants.
SELECT * FROM oceanbase.DBA_OB_VECTOR_INDEX_TASKS ORDER BY MODIFY_TIME DESC\G;
The query result is as follows:
*************************** 1. row ***************************
TABLE_ID: 500178
TABLET_ID: 1152921504606847126
TASK_ID: 14556
CREATE_TIME: 2026-03-25 23:42:43.330766
MODIFY_TIME: 2026-03-25 23:42:43.332887
TRIGGER_TYPE: USER
STATUS: RUNNING
TASK_TYPE: 5
TASK_SCN: -1
RET_CODE: -1
TRACE_ID: Y2C277F000001-00064DDA41D11952-0-1
PROGRESS_INFO: NULL
TASK_INFO: NULL
EXEC_ADDR: NULL
PRIORITY: 0
START_TIME: NULL
END_TIME: NULL
ERR_MSG: NULL
1 row in set
The following table describes the JSON string of the TASK_INFO field.
| Field | JSON field type | Description |
|---|---|---|
| merge_segments_cnt | string | The number of segments to be merged. |
| merge_segments | array | The information about the segments to be merged. The number of elements in the array is the same as the value of the merge_segments_cnt field. |
| result_segments | array | The information about the merged segments. |
| scn | string | The internal timestamp. |
| start_key | string | The upper bound of the key range of the segment. |
| end_key | string | The lower bound of the key range of the segment. |
| index_type | string | The index type used to process vectors in the segment. Valid values:
|
| mem_used | string | The memory used by the segment. |
| min_vid | string | The minimum vector ID in the segment. |
| max_vid | string | The maximum vector ID in the segment. |
References
- CDB_OB_VECTOR_INDEX_TASKS
- For information about the relationship between HNSW vector index dump, major compaction, and task types, see Principles of vector indexes.
- For information about O&M and manual triggers, see Monitor and maintain indexes.