SHOW INDEXES
SHOW INDEXES provides details about indexes built on a source, view, or materialized view.
Syntax
SHOW INDEXES [ FROM <schema_name> | ON <object_name> ]
[ IN CLUSTER <cluster_name> ]
[ LIKE <pattern> | WHERE <condition(s)> ]
| Option | Description |
|---|---|
| FROM <schema_name> | If specified, only show indexes from the specified schema. Defaults to first resolvable schema in the search path if neither ON <object_name> nor IN CLUSTER <cluster_name> are specified. For available schemas, see SHOW SCHEMAS. |
| ON <object_name> | If specified, only show indexes for the specified object. |
| IN CLUSTER <cluster_name> | If specified, only show indexes from the specified cluster. |
| LIKE <pattern> | If specified, only show indexes that match the pattern. |
| WHERE <condition(s)> | If specified, only show indexes that match the condition(s). |
Details
Output format
SHOW INDEX’s output is a table with the following structure:
name | on | cluster | key
-----+-----+---------+----
... | ... | ... | ...
| Field | Meaning |
|---|---|
| name | The name of the index. |
| on | The name of the table, source, or view the index belongs to. |
| cluster | The name of the cluster containing the index. |
| key | A text array describing the expressions in the index key. |
Examples
SHOW VIEWS;
name
-------------------------
my_nonmaterialized_view
my_materialized_view
SHOW INDEXES ON my_materialized_view;
name | on | cluster | key
------+-----+---------+----
... | ... | ... | ...