Note
This view is available starting with OceanBase Database V4.3.5 BP3.
Purpose
The CDB_OB_VECTOR_INDEX_TASKS view displays information about 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 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, this information 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 following fields:
|
Sample query
In the sys tenant, query the vector index partition rebuild 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