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

Key fetch metrics

Offset fetch metrics

Token fetch metrics

Column query metrics per index

Terms 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.

ChunkCacheHitRate — All-time chunk cache hit rate for keys during queries against the given table.

TotalChunkCacheLookups — All-time chunk cache lookups for keys during queries against the given table.

TotalChunkCacheMisses — All-time chunk cache misses for keys during queries against the given table.

ChunkCache(One|Five|Fifteen)HitRate — <N>-minute chunk cache hit rate for keys during queries against the given table.

ChunkCacheHitRate — All-time chunk cache hit rate for partition key SSTable offset fetches during queries against the given table.

TotalChunkCacheLookups — All-time chunk cache lookups for partition key SSTable offset fetches during queries against the given table.

TotalChunkCacheMisses — All-time chunk cache misses for partition key SSTable offset fetches during queries against the given table.

ChunkCache(One|Five|Fifteen)HitRate — <N>-minute chunk cache hit rate for partition key SSTable offset fetches during queries against the given table.

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.

ChunkCacheHitRate — All-time chunk cache hit rate for partition key token fetches during queries against the given table.

TotalChunkCacheLookups — All-time chunk cache lookups for partition key token fetches during queries against the given table.

TotalChunkCacheMisses — All-time chunk cache misses for partition key token fetches during queries against the given table.

ChunkCache(One|Five|Fifteen)HitRate — <N>-minute chunk cache hit rate for partition key token fetches during queries against the given table.

CacheHits — Number of cache hits from token skipping in a multi-index AND query.

Lookups — Number of lookups from token skipping a multi-index AND query.

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.

ChunkCacheHitRate — All-time chunk cache hit rate for terms during string index queries that used the given index.

TotalChunkCacheLookups — All-time chunk cache lookups for terms during string index queries that used the given index.

TotalChunkCacheMisses — All-time chunk cache misses for terms during string index queries that used the given index.

ChunkCache(One|Five|Fifteen)HitRate — <N>-minute chunk cache hit rate for terms during string index queries that used the given index.