3.9. pg_index

pg_index contains part of the information about indexes. The rest is mostly in pg_class.

Table 3-9. pg_index Columns

NameTypeReferencesDescription
indexrelidoidpg_class.oidThe oid of the pg_class entry for this index
indrelidoidpg_class.oidThe oid of the pg_class entry for the table this index is for
indprocoidpg_proc.oidThe registered procedure if this is a functional index
indkeyint2vectorpg_attribute.attnum This is an vector (array) of up to INDEX_MAX_KEYS values that indicate which table columns this index pertains to. For example a value of 1 3 would mean that the first and the third column make up the index key.
indclassoidvectorpg_opclass.oid For each column in the index key this contains a reference to the "operator class" to use. See pg_opclass for details.
indisclusteredbool unused
indislossybool ???
indisuniquebool If true, this is a unique index.
indisprimarybool If true, this index is a unique index that represents the primary key of the table.
indreferenceoid unused
indpredtext Query plan for partial index predicate (not functional)