Note
This view is available starting with V4.4.1.
Purpose
The DBA_OB_VECTOR_INDEX_TASKS view displays information about all vector index partition rebuild tasks in the current tenant.
Columns
| Column | Data 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 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 execution trace ID of the task. | |
| PROGRESS_INFO | varchar(512) | NO | The progress information of the task 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 information about all vector index performance optimization 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