Cloud

pg_index

The pg_index stores information about indexes on tables. It mimics the pg_index PostgreSQL system catalog.

Columns

The following columns are available for querying in pg_index:

Column Type Description

indexrelid

int

This column represents OID of the index

indrelid

int

This column represents OID (Object ID) of the table on which the index is defined

indnatts

int

This column represents number of columns in the index

indnkeyatts

int

This column represents number of key columns in the index

indisunique

bool

The default value is false

indnullsnotdistinct

bool

unused

indisprimary

bool

unused

indisexclusion

bool

unused

indimmediate

bool

unused

indisclustered

bool

unused

indisvalid

bool

unused

indcheckxmin

bool

unused

indisready

bool

unused

indislive

bool

unused

indisreplident

bool

unused

indkey

int

unused

indcollation

int

unused

indclass

int

unused

indoption

int

unused

indexprs

int

unused

indpred

int

unused