Updated on 2025-05-29 GMT+08:00

GS_LOGICAL_INDEX

GS_LOGICAL_INDEX stores some index information, and GS_LOGICAL_CLASS stores other information.

Table 1 GS_LOGICAL_INDEX columns

Column

Type

Description

indexrelid

Oid

OID of the index.

indrelid

Oid

Referenced RELATION OID.

indnatts

smallint

Total number of columns in an index.

indisunique

boolean

Specifies whether the index is a unique index.

indisprimary

boolean

Specifies whether the index is a primary key.

csnmin

bigint

CSN when a tuple is inserted.

csnmax

bigint

CSN when a tuple is updated or deleted.

createtime

timestamp with time zone

Timestamp when a tuple is inserted.

originid

integer

Source identifier of a tuple.

dbnode

oid

Database OID.

indimmediate

boolean

Specifies whether to execute the uniqueness constraint immediately.

indisvalid

boolean

Specifies whether the index can be used for query.

indisready

boolean

Specifies whether this index is ready to accept inserts.

indisusable

boolean

Specifies whether this index can be used for insertion and selection.

indkey

int2vector

Index column number.

indcollation

oidvector

Sorting identifier.

indpred

pg_node_tree

Expression tree of the predicate if it is a partial index; otherwise, the value is NULL.

indisreplident

boolean

Specifies whether an index is identified as a replication identifier index.