show-indexes.md 2.0 KB
title: "SHOW INDEXES" description: "SHOW INDEXES provides details about indexes built on a source, view, or materialized view" menu: main:
parent: commands
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 | 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 | If specified, only show indexes for the specified object. |
| IN CLUSTER | If specified, only show indexes from the specified cluster. |
| LIKE <pattern> | If specified, only show indexes that match the pattern. |
| WHERE | If specified, only show indexes that match the condition(s). |
| 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
------+-----+---------+----
... | ... | ... | ...