GS_LOGICAL_INDEX
GS_LOGICAL_INDEX stores some index information, and GS_LOGICAL_CLASS stores other information.
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. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.