Version: Nightly

SSTS_INDEX_META

The SSTS_INDEX_META table provides access to SST (Sorted String Table) index metadata collected from the manifest. This table surfaces information about Puffin index metadata, including inverted indexes, fulltext indexes, and bloom filters.

NOTE

This table is not available on GreptimeCloud.

USE INFORMATION_SCHEMA;
DESC SSTS_INDEX_META;

The output is as follows:

+-----------------+--------+-----+------+---------+---------------+
| Column          | Type   | Key | Null | Default | Semantic Type |
+-----------------+--------+-----+------+---------+---------------+
| table_dir       | String |     | NO   |         | FIELD         |
| index_file_path | String |     | NO   |         | FIELD         |
| region_id       | UInt64 |     | NO   |         | FIELD         |
| table_id        | UInt32 |     | NO   |         | FIELD         |
| region_number   | UInt32 |     | NO   |         | FIELD         |
| region_group    | UInt8  |     | NO   |         | FIELD         |
| region_sequence | UInt32 |     | NO   |         | FIELD         |
| file_id         | String |     | NO   |         | FIELD         |
| index_file_size | UInt64 |     | YES  |         | FIELD         |
| index_type      | String |     | NO   |         | FIELD         |
| target_type     | String |     | NO   |         | FIELD         |
| target_key      | String |     | NO   |         | FIELD         |
| target_json     | String |     | NO   |         | FIELD         |
| blob_size       | UInt64 |     | NO   |         | FIELD         |
| meta_json       | String |     | YES  |         | FIELD         |
| node_id         | UInt64 |     | YES  |         | FIELD         |
+-----------------+--------+-----+------+---------+---------------+

Fields in the SSTS_INDEX_META table are described as follows:

table_dir: The directory path of the table.
index_file_path: The full path to the Puffin index file.
region_id: The ID of the region.
table_id: The ID of the table.
region_number: The region number within the table.
region_group: The group identifier for the region.
region_sequence: The sequence number of the region.
file_id: The unique identifier of the index file (UUID).
index_file_size: The size of the index file in bytes.
index_type: The type of index. Possible values include:
- inverted: Inverted index for fast term lookups
- fulltext_bloom: Combined fulltext and bloom filter index
- bloom_filter: Bloom filter for fast membership tests
target_type: The type of target being indexed. Typically column for column-based indexes.
target_key: The key identifying the target (e.g., column ID).
target_json: JSON representation of the target configuration, such as {"column":0}.
blob_size: The size of the blob data in bytes.
meta_json: JSON metadata containing index-specific information such as:
- For inverted indexes: FST size, bitmap type, segment row count, etc.
- For bloom filters: bloom filter size, row count, segment count
- For fulltext indexes: analyzer type, case sensitivity settings
node_id: The ID of the datanode where the index is located.

Examples

Query all index metadata:

SELECT * FROM INFORMATION_SCHEMA.SSTS_INDEX_META;

Query index metadata for a specific table by joining with the TABLES table:

SELECT s.* 
FROM INFORMATION_SCHEMA.SSTS_INDEX_META s
JOIN INFORMATION_SCHEMA.TABLES t ON s.table_id = t.table_id
WHERE t.table_name = 'my_table';

Query only inverted index metadata:

SELECT table_dir, index_file_path, index_type, target_json, meta_json
FROM INFORMATION_SCHEMA.SSTS_INDEX_META
WHERE index_type = 'inverted';

Query index metadata grouped by index type:

SELECT index_type, COUNT(*) as count, SUM(index_file_size) as total_size
FROM INFORMATION_SCHEMA.SSTS_INDEX_META
GROUP BY index_type;

Output example:

mysql> SELECT * FROM INFORMATION_SCHEMA.SSTS_INDEX_META LIMIT 1\G;
*************************** 1. row ***************************
      table_dir: data/greptime/public/1814/
index_file_path: data/greptime/public/1814/1814_0000000000/data/index/aba4af59-1247-4bfb-a20b-69242cdd9374.puffin
      region_id: 7791070674944
       table_id: 1814
  region_number: 0
   region_group: 0
region_sequence: 0
        file_id: aba4af59-1247-4bfb-a20b-69242cdd9374
index_file_size: 838
     index_type: bloom_filter
    target_type: column
     target_key: 2147483652
    target_json: {"column":2147483652}
      blob_size: 688
      meta_json: {"bloom":{"bloom_filter_size":640,"row_count":2242,"rows_per_segment":1024,"segment_count":3}}
        node_id: 0
1 row in set (0.02 sec)

SSTS_INDEX_META

Examples​

Examples