Monitor SAI indexes

system_views.indexes — provides information at the column index level, including the index name, number of indexed SSTables, disk usage, and index state. From the index state, the data reveals if the index is currently building, and whether the index can be queried.

SELECT is_queryable,is_building FROM system_views.indexes WHERE keyspace_name='keyspace'
       AND table_name='table' AND index_name='index';

system_views.sstable_indexes — describes individual SSTable indexes, and includes information around disk size, min/max row ID, the min/max ring token, and the write-time version of the index.

system_views.sstable_index_segments — describes the segments of the SSTable indexes. It exposes the segment row ID offset and most of the information in the SSTable-level virtual table, specifically at a segment granularity. For more details, refer to Virtual tables for SAI indexes and SSTables.

Global indexing metrics

Table query metrics

Per query metrics

Column query metrics per index

Range slice metrics

ColumnIndexBuildsInProgress — The number of individual on-disk column indexes currently being built.

SegmentBufferSpaceLimitBytes — The limit on heap used to buffer SSTable index segments during compaction and index builds.

SegmentBufferSpaceUsedBytes — The heap currently being used to buffer SSTable index segments during compaction and index builds.

DiskUsedBytes — Size in bytes on disk for the given table’s SAI indices.

IndexFileCacheBytes — Size in bytes of memory used by the on-disk data structure of the per-column indices.

OpenIndexFiles — Number of open index files for the given table’s SAI indices.

RowsFiltered — A histogram of the number of rows post-filtered per query since the node started.

QueryLatency — Overall query latency percentiles (in microseconds) and one/five/fifteen minute query throughput.

PartitionReads — Histogram over the number of partitions read per query.

SSTableIndexesHit — Histogram over the number of SSTable indexes read per query.

KDTreeChunkCacheLookups — Histogram over the number of chunk cache lookups while reading kd-tree index files per query.

KDTreeChunkCacheMisses — Histogram over the number of chunk cache misses while reading kd-tree index files per query.

TotalPartitionReads — Total partition reads by all queries since the node started.

TotalQueriesCompleted — Total number of successfully completed queries since the node started.

TotalQueryTimeouts — Total number of timeouts from queries since the node started.

TotalRowsFiltered — Total number of rows post-filtered by all queries since the node started.

DiskPercentageOfBaseTable — SAI size on Disk as a percentage of table size per table.

DiskUsedBytes — Size on-disk in bytes of SAI indices per table.

TotalIndexBuildsInProgress — Status of SAI indices per table currently in the is_building state.

TotalIndexCount — Total number of SAI indices per table.

TotalQueryableIndexCount — Status of SAI indices per table currently in the is_querable state.

KDTreeNiceTryLatency — For numeric indexes, such as age_sai_idx in the quickstart examples, this metric may be used to present a histogram of the times spent waiting for chunk cache misses during kd-tree intersection (in microseconds) and one/five/fifteen minute chunk miss throughputs.

TermsLookupLatency — For string indexes, such as country_sai_idx in the quickstart examples, this metric shows terms lookup latency percentiles (in microseconds) per one/five/fifteen minute query throughput.