Note
This view is available starting with V4.4.1.
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 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 trigger type of the task. 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 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 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 vector index performance optimization task information of 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