# pg_index

> For the complete documentation index, see [llms.txt](https://docs.redpanda.com/llms.txt). Component-specific: [cloud-data-platform-full.txt](https://docs.redpanda.com/cloud-data-platform-full.txt)

---
title: pg_index
latest-operator-version: v26.1.4
latest-console-tag: v3.7.3
latest-connect-version: 4.93.0
latest-redpanda-tag: v26.1.9
docname: sql/system-catalogs/catalogs/pg_index
page-component-name: cloud-data-platform
page-version: master
page-component-version: master
page-component-title: Cloud
page-relative-src-path: sql/system-catalogs/catalogs/pg_index.adoc
page-edit-url: https://github.com/redpanda-data/cloud-docs/edit/main/modules/reference/pages/sql/system-catalogs/catalogs/pg_index.adoc
description: The pg_index stores information about indexes on tables.
page-topic-type: reference
page-git-created-date: "2026-05-26"
page-git-modified-date: "2026-05-26"
---

<!-- Source: https://docs.redpanda.com/cloud-data-platform/reference/sql/system-catalogs/catalogs/pg_index.md -->

The `pg_index` stores information about indexes on tables. It mimics the [pg\_index](https://www.postgresql.org/docs/current/catalog-pg-index.html) PostgreSQL system catalog.

## [](#columns)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 |