Note
- This view is available starting with V4.3.5 BP3.
Purpose
This view displays the detailed statistics of vector index data memory usage for the current tenant across all OBServer nodes.
Columns
Column |
Type |
Nullable? |
Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The tenant ID.
|
| SVR_IP | varchar(46) | NO | The IP address of the node. |
| SVR_PORT | bigint(20) | NO | The port number of the node. |
| VECTOR_MEM_HOLD | bigint(20) | NO | The size of memory occupied by vector index data, in bytes. |
| VECTOR_MEM_LIMIT | bigint(20) | NO | The maximum size of memory that can be configured for vector index data, in bytes. |
| VECTOR_MEM_USED | bigint(20) | NO | The size of memory actually used by vector index data, in bytes. |
Sample query
Query the detailed statistics of vector index data memory usage for the current tenant across all OBServer nodes.
obclient [oceanbase]> SELECT * FROM oceanbase.GV$OB_VECTOR_MEMORY \G
The query result is as follows:
*************************** 1. row ***************************
svr_ip: 11.xxx.xx.xx
svr_port: 46002
tenant_id: 1004
vector_mem_hold: 82231296
vector_mem_used: 77876328
vector_mem_limit: 429496720
1 row in set