---
title: "pg_indexes"
id: view-pg-indexes
pg_version: "20devel"
---

<a id="view-pg-indexes"></a>

## 53.13. pg_indexes

The view pg_indexes provides access to useful information about each index in the database. 

**pg_indexes Columns**

| Column Type | Description | 
| --- | --- |
| `schemaname` `name` (references [pg_namespace](catalog-pg-namespace.md).`nspname`) | Name of schema containing table and index |
| `tablename` `name` (references [pg_class](catalog-pg-class.md).`relname`) | Name of table the index is for |
| `indexname` `name` (references [pg_class](catalog-pg-class.md).`relname`) | Name of index |
| `tablespace` `name` (references [pg_tablespace](catalog-pg-tablespace.md).`spcname`) | Name of tablespace containing index (null if default for database) |
| `indexdef` `text` | Index definition (a reconstructed [CREATE INDEX](sql-createindex.md) command) |