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.

Parent topic: Logical Decoding

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.