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.