Note
This view is available starting with V4.6.0.
Purpose
This view displays the SINDI and SINDI_SQ vector index information and real-time status on all OBServer nodes.
Columns
Column |
Data type |
Nullable |
Description |
Information type |
|---|---|---|---|---|
| SVR_IP | varchar(46) | NO | The IP address of the node where the replica resides. | Basic information |
| SVR_PORT | bigint(20) | NO | The RPC_PORT of the node where the replica resides. | Basic information |
| TENANT_ID | bigint(20) | NO | The tenant ID
|
Basic information |
| DATA_TABLE_ID | bigint(20) | NO | The ID of the data table. | Basic information |
| DATA_TABLET_ID | bigint(20) | NO | The ID of the partition. | Basic information |
| TABLE_NAME | varchar(256) | NO | The name of the table. | Basic information |
| INDEX_NAME | varchar(256) | NO | The name of the index. | Index information |
| ROLE | varchar(8) | NO | The role*:
|
Basic information |
| INDEX_PARAM | varchar(512) | NO | The index parameters. | Index information |
| MEMORY_USED | bigint(20) | NO | The memory used. | Index information |
| MEMORY_HOLD | bigint(20) | NO | The occupied memory. | Index information |
| INCR_MEM_HOLD | bigint(20) | NO | The incremental memory usage. | Index information |
| SNAP_MEM_HOLD | bigint(20) | NO | The snapshot memory usage. | Index information |
| INCR_VECTOR_CNT | bigint(20) | NO | The number of incremental vectors. | Index information |
| SNAP_VECTOR_CNT | bigint(20) | NO | The number of snapshot vectors. | Index information |
| INCR_DATA_SCN | bigint(20) unsigned | NO | The incremental data version. | Index information |
| SNAP_DATA_SCN | bigint(20) unsigned | NO | The snapshot data version. | Index information |
| LAST_SUCC_SYNC_TIME | datetime | NO | The last successful synchronization time. | Synchronization information |
| LAST_FAILED_SYNC_TIME | datetime | NO | The last failed synchronization time. | Synchronization information |
| LAST_FAILED_CODE | bigint(20) | NO | The error code of the last failed synchronization. | Synchronization information |
Sample query
Query the real-time status of SINDI and SINDI_SQ vector indexes for all tenants on all OBServer nodes.
SELECT * FROM oceanbase.GV$OB_SINDI_INDEX_INFO\G;
The query result is as follows:
*************************** 1. row ***************************
SVR_IP: 127.0.0.1
SVR_PORT: 10403
TENANT_ID: 1004
DATA_TABLE_ID: 500086
DATA_TABLET_ID: 200011
TABLE_NAME: t2
INDEX_NAME: idx2
ROLE: LEADER
INDEX_PARAM: type=SINDI,dist_algorithm=ip,prune=false,refine=false,refine_k=4.000000,drop_ratio_build=0.000000,drop_ratio_search=0.000000
MEMORY_USED: 11824
MEMORY_HOLD: 32768
INCR_MEM_HOLD: 0
SNAP_MEM_HOLD: 32768
INCR_VECTOR_CNT: 0
SNAP_VECTOR_CNT: 10
INCR_DATA_SCN: 0
SNAP_DATA_SCN: 1768210417252461000
LAST_SUCC_SYNC_TIME: 2026-01-12 18:01:41.091294
LAST_FAILED_SYNC_TIME: NULL
LAST_FAILED_CODE: 0
1 row in set