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.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot