Cloud SQL information schema

MySQL | PostgreSQL | SQL Server

This page lists the Cloud SQL information schema table additions.

information_schema.innodb_vector_indexes

Gives all the vector indexes that are opened in the memory after restart.

Column name Description

INDEX_NAME Name of the index

TABLE_NAME Qualified table name in db_name.table_name format

INDEX_TYPE TREE_SQ is supported

DIMENSION Dimensionality of the vector column

DIST_MEASURE Distance Measure on which index is built

STATUS A string describing the current state of the index

STATE Internal state of the index

NUM_LEAVES Number of leaves as configured by the user or computed internally based on the size of the base table

NUM_LEAVES_TO_SEARCH Number of leaves to search in ANN. Can be overridden at query time

QUERIES Number of ANN queries on this index since server start

MUTATIONS Number of DML operations on base table that resulted in updating the vector index

TREE_MEMORY Memory occupied by the non-leaf part of the vector index

Contains all the vector indexes that exists on the instance (even if they are not opened in the memory yet).

Column name Description

id same as innodb_indexes.index_id

table_id An identifier representing the table associated with the index

sub_table_id An identifier representing the sub table associated with the vector index

state Internal state of the index. Same as information_schema.innodb_vector_indexes

corrupted Indicates whether the index is corrupted or not. 1 means corrupted, 0 means not corrupted.

config A json value showing index configuration.

In configuration:

"D" implies it is a static default value of this parameter.
"G" implies that the value is generated or computed internally.
"C" means that the value is explicitly specified by the user.
The order of precedence is C> G> D.

Provides information about overall memory usage of vector indexes in the instance.

Column name Description

STATE Memory management for vector indexes is enabled.

TOTAL_MEMORY cloudsql_vector_max_mem_size

INDEX_MEMORY Amount of memory that is used to load index_tree into the memory.

TRAINING_MEMORY Amount of memory that is allocated for training during index build.

LOADED_INDEX Number of indexes that are loaded in the memory.