Note
This view is available starting with V4.4.1.
Purpose
The CDB_OB_VECTOR_INDEX_TASKS view displays information about vector index partition rebuild tasks in all tenants of the cluster.
Columns
Column |
Type |
Nullable |
Description |
|
|---|---|---|---|---|
| TENANT_ID | bigint(20) | YES | The tenant ID. | |
| 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 task trigger type. Valid values:
|
|
| STATUS | varchar(16) | NO | The task status. Valid values:
|
|
| TASK_TYPE | bigint(20) | NO | The task type. Valid values:
|
|
| TASK_SCN | bigint(20) | NO | The task version number. | |
| RET_CODE | bigint(20) | NO | The task status when the task is completed. 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. Typically, it includes the current operation, estimated number of rows, number of rows completed, 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.
|
Sample query
In the sys tenant, query the vector index performance optimization tasks of all tenants.
SELECT * FROM oceanbase.CDB_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
References
- DBA_OB_VECTOR_INDEX_TASKS
- For the relationship between HNSW vector index dump, merge, and task types, see Vector index principles
- For O&M and manual trigger information, see Monitor and maintain indexes