Note
This view is available starting with V4.4.1.
Purpose
The CDB_OB_VECTOR_INDEX_TASKS view displays the information of vector index partition rebuild tasks for all tenants in 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 type of the task trigger. Valid values:
|
|
| STATUS | varchar(16) | NO | The status of the task. 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 status of the task when it ends. Valid values:
|
|
| TRACE_ID | varchar(512) | NO | The execution tracking ID of the task. | |
| PROGRESS_INFO | varchar(512) | NO | The execution progress information of the task, 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.
|
Sample query
In the sys tenant, query the information of vector index performance optimization tasks for all tenants.
SELECT * FROM oceanbase.CDB_OB_VECTOR_INDEX_TASKS;
The query result is as follows:
+-----------+----------+---------------------+---------+----------------------------+----------------------------+--------------+---------+-----------+------------------+----------+------------------------------------+
| TENANT_ID | TABLE_ID | TABLET_ID | TASK_ID | START_TIME | MODIFY_TIME | TRIGGER_TYPE | STATUS | TASK_TYPE | TASK_SCN | RET_CODE | TRACE_ID |
+-----------+----------+---------------------+---------+----------------------------+----------------------------+--------------+---------+-----------+------------------+----------+------------------------------------+
| 1004 | 500017 | 1152921504606846987 | 22023 | 1970-08-23 17:08:27.175705 | 1970-08-23 17:08:27.175715 | USER | RUNNING | 1 | 1746611825281271 | -1 | Y61460BA2DAD8-000634872BECF00C-0-1 |
+-----------+----------+---------------------+---------+----------------------------+----------------------------+--------------+---------+-----------+------------------+----------+------------------------------------+
1 row in set