pg_indexes
The view pg_indexes provides access to useful information about each index in the database.
Table pg_indexes Columns
| Column Type Description | 
|---|
 Name of schema containing table and index  | 
 Name of table the index is for  | 
 Name of index  | 
 Name of tablespace containing index (null if default for database)  | 
 Index definition (a reconstructed   |