Note
This view is available starting with V4.6.0.
Purpose
This view displays the basic information and real-time status of each data segment (Segment) in the single partition of HNSW series index tables for all tenants on all OBServer nodes. For the mapping between the SEGMENT_TYPE and SEGMENT_STATE fields and baseline segments, incremental segments (active/frozen/persisted), and the dump and major compaction processes, see Principles of vector indexes.
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 |
| VBITMAP_TABLET_ID | bigint(20) | NO | The ID of the partition corresponding to the auxiliary table (index_id). | Basic information |
| INC_INDEX_TABLET_ID | bigint(20) | NO | The ID of the partition of the delta_buffer table that stores incremental data. | Basic information |
| SNAPSHOT_INDEX_TABLET_ID | bigint(20) | NO | The ID of the partition of the index_snapshot_data table that stores data snapshots. | Basic information |
| BLOCK_COUNT | bigint(20) | NO | The number of data blocks in the snapshot Segment in the index_snapshot_data table. | Basic information |
| SEGMENT_TYPE | varchar(20) | NO | The type of the Segment.
|
Basic information |
| INDEX_TYPE | varchar(20) | NO | The type of the vector index.
|
Basic information |
| MEM_USED | bigint(20) | NO | The size of memory occupied by the current Segment in bytes. | Basic information |
| MIN_VID | bigint(20) | NO | The minimum vector ID (vid) in the Segment. | Basic information |
| MAX_VID | bigint(20) | NO | The maximum vector ID (vid) in the Segment. | Basic information |
| VECTOR_CNT | bigint(20) | NO | The number of vectors (data) in the Segment. | Basic information |
| REF_CNT | bigint(20) | NO | The reference count of the Segment. This value usually indicates the number of times the Segment is referenced by an index or query. | Basic information |
| SEGMENT_STATE | varchar(20) | NO | The state of the current Segment.
|
Basic information |
| PERSISTENCE_TIMESTAMP | timestamp | NO | The timestamp when the Segment is persisted (converted from the SCN of the Segment). | Basic information |
Sample query
Query the real-time status of HNSW vector indexes for all tenants on all OBServer nodes in the SYS tenant.
SELECT * FROM oceanbase.GV$OB_HNSW_INDEX_SEGMENT_INFO ORDER BY PERSISTENCE_TIME DESC\G;
The query result is as follows:
*************************** 1. row ***************************
SVR_IP: 127.0.0.1
SVR_PORT: 11303
TENANT_ID: 1004
DATA_TABLE_ID: 500149
DATA_TABLET_ID: 200019
VBITMAP_TABLET_ID: 1152921504606847128
INC_INDEX_TABLET_ID: 1152921504606847126
SNAPSHOT_INDEX_TABLET_ID: 1152921504606847129
BLOCK_COUNT: 1
SEGMENT_TYPE: PERSISTED_BASE
INDEX_TYPE: HNSW
MEM_USED: 553332
MIN_VID: 11
MAX_VID: 10005
VECTOR_CNT: 2005
REF_CNT: 2
SEGMENT_STATE: PERSISTED
PERSISTENCE_TIME: 2026-03-25 23:20:31.481903