This documentation is related to an older version of Firebolt. For the most current documentation, see Firebolt documentation.

Information schema for indexes

You can use the information_schema.indexes view to return information about each index in a database. The view is available for each database and contains one row for each index in the database. You can use a SELECT query to return information about each index.

The following query returns all aggregating indexes defined within the current database

SELECT
  *
FROM
  information_schema.indexes
WHERE
  index_type='aggregating`;

Columns in information_schema.indexes

Each row has the following columns with information about the database.

Name	Data Type	Description
table_catalog	TEXT	Name of the catalog. Firebolt provides a single ‘default’ catalog.
table_schema	TEXT	Name of the database.
table_name	TEXT	The name of the table for which the index is defined.
index_name	TEXT	The name defined for the index.
index_type	TEXT	One of `primary` or `aggregating`.
index_definition	TEXT	The portion of the index statement that defines the columns and aggregations (if applicable) for the index.
index_compressed_size	BIGINT	The compressed size of the index.
index_uncompressed_size	BIGINT	The uncompressed size of the index.