Note
This view is available starting with OceanBase Database V4.3.5 BP3.
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 ID of the table. | |
| TABLET_ID | bigint(20) | YES | The ID of the partition. | |
| TASK_ID | bigint(20) | YES | The ID of the task. | |
| 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.
|
|
| STATUS | varchar(16) | NO | The status of the task.
|
|
| TASK_TYPE | bigint(20) | NO | The type of the task.
|
|
| TASK_SCN | bigint(20) | NO | The version number of the task. | |
| RET_CODE | bigint(20) | NO | The status of the task when it ends.
|
|
| TRACE_ID | varchar(512) | NO | The trace ID of the task. | |
| PROGRESS_INFO | varchar(512) | NO | The progress information of the task, in JSON format. The information typically includes the current operation, estimated number of rows, completed number of rows, progress percentage, and estimated remaining time. The 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 about vector index partition rebuild tasks in all tenants.
SELECT * FROM oceanbase.DBA_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