SYSTEM VIEW · System view
pg_indexes
The view pg_indexes provides access to useful information about each index in the database.
Checked column by column against a PostgreSQL 18.6 instance · Raw measurement record ↗
Columns PostgreSQL 18
pg_indexes| COLUMN | TYPE | DESCRIPTION |
|---|---|---|
schemaname |
name |
Name of schema containing table and indexReferences:pg_namespace.nspname |
tablename |
name |
Name of table the index is forReferences:pg_class.relname |
indexname |
name |
Name of indexReferences:pg_class.relname |
tablespace |
name |
Name of tablespace containing index (null if default for database)References:pg_tablespace.spcname |
indexdef |
text |
Index definition (a reconstructed CREATE INDEX command) |
Columns marked "implicit" are not included in SELECT *; some early statistics views are completed from same-version source, and the extra provenance is shown in the column description.
Common system columns 0
System attributes PostgreSQL provides, normally not expanded by SELECT *. Kept separately so they are not mixed in with ordinary columns.
| Columns | Type | attnum |
|---|
Column evolution matrix
Hover a cell for the column type9.0 is the coverage baseline; a column already present in the baseline is not marked as added. The matrix aligns columns by name, so a rename appears as the old column removed and a new column added.
Evolution timeline
Changes between adjacent majorsNo column-structure or description change between the covered versions.
Compare any two versions
Pick two versions to see added, removed, and retyped columns. The interactive comparison needs JavaScript; the evolution timeline reads fine without it.