Note
- This view is introduced in OceanBase Database V4.3.5 BP3.
Purpose
This view shows the detailed statistics about the memory usage of vector index data on all OBServer nodes of the current tenant.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | 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 memory usage of vector index data, in bytes. |
| VECTOR_MEM_LIMIT | bigint(20) | NO | The maximum memory allowed for vector index data, in bytes. |
| VECTOR_MEM_USED | bigint(20) | NO | The actual memory used by vector index data, in bytes. |
Examples
Query the detailed statistics about the memory usage of vector index data on all OBServer nodes of the current tenant.
OceanBase(root@test)>SELECT * FROM oceanbase.GV$VECTOR_MEMORY \G
The query result is as follows:
*************************** 1. row ***************************
svr_ip: 11.158.31.35
svr_port: 46002
tenant_id: 1004
vector_mem_hold: 82231296
vector_mem_used: 77876328
vector_mem_limit: 429496720
1 row in set