GaussDB-MY_INDEXES
MY_INDEXES displays index information about the current user. This view exists in the PG_CATALOG and SYS schemas. For details about the columns, see Table 1.
| Name | Type | Description |
|---|---|---|
| owner | character varying(64) | Index owner |
| index_name | character varying(64) | Index name |
| table_name | character varying(64) | Name of the table corresponding to the index |
| uniqueness | text | Specifies whether the index is a unique index.- UNIQUE: unique index. |
- NONUNIQUE: non-unique index. | | partitioned | character(3) | Specifies whether the index has the property of partitioned tables.- Yes: The index has the property of a partitioned table.
- No: The index does not have the property of a partitioned table. | | generated | character varying(1) | Specifies whether the index name is generated by the system.- y: The index name is generated by the system.
- n: The index name is not generated by the system. | | index_type | character varying(27) | Index type- NORMAL: Index attributes are simple references, and the expression tree is empty.
- FUNCTION-BASED NORMAL: Expression trees are used for index attributes that are not simple column references. | | table_owner | character varying(128) | Owner of the index object | | table_type | character(11) | Type of an index object- TABLE: The index object is of the table type. | | tablespace_name | character varying(30) | Name of the tablespace that contains the index | | status | character varying(8) | Status of a non-partitioned index.- VALID: Non-partitioned indexes can be used for query.
- UNUSABLE: The non-partitioned index is unavailable.
- N/A: The index has the property of a partitioned table. | | compression | character varying(13) | Not supported. Its value is NULL. | | prefix_length | numeric | Not supported. Its value is NULL. | | ini_trans | numeric | Not supported. Its value is NULL. | | max_trans | numeric | Not supported. Its value is NULL. | | initial_extent | numeric | Not supported. Its value is NULL. | | next_extent | numeric | Not supported. Its value is NULL. | | min_extents | numeric | Not supported. Its value is NULL. | | max_extents | numeric | Not supported. Its value is NULL. | | pct_increase | numeric | Not supported. Its value is NULL. | | pct_threshold | numeric | Not supported. Its value is NULL. | | include_column | numeric | Not supported. Its value is NULL. | | freelists | numeric | Not supported. Its value is NULL. | | freelist_groups | numeric | Not supported. Its value is NULL. | | pct_free | numeric | Not supported. Its value is NULL. | | logging | character varying(3) | Not supported. Its value is NULL. | | blevel | numeric | Not supported. Its value is NULL. | | leaf_blocks | numeric | Not supported. Its value is NULL. | | distinct_keys | numeric | Not supported. Its value is NULL. | | avg_leaf_blocks_per_key | numeric | Not supported. Its value is NULL. | | avg_data_blocks_per_key | numeric | Not supported. Its value is NULL. | | clustering_factor | numeric | Not supported. Its value is NULL. | | num_rows | numeric | Not supported. Its value is NULL. | | sample_size | numeric | Not supported. Its value is NULL. | | last_analyzed | date | Not supported. Its value is NULL. | | degree | character varying(40) | Not supported. Its value is NULL. | | instances | character varying(40) | Not supported. Its value is NULL. | | temporary | character varying(1) | Not supported. Its value is NULL. | | secondary | character varying(1) | Not supported. Its value is NULL. | | buffer_pool | character varying(7) | Not supported. Its value is NULL. | | flash_cache | character varying(7) | Not supported. Its value is NULL. | | cell_flash_cache | character varying(7) | Not supported. Its value is NULL. | | user_stats | character varying(3) | Not supported. Its value is NULL. | | duration | character varying(15) | Not supported. Its value is NULL. | | pct_direct_access | numeric | Not supported. Its value is NULL. | | ityp_owner | character varying(128) | Not supported. Its value is NULL. | | ityp_name | character varying(128) | Not supported. Its value is NULL. | | parameters | character varying(1000) | Not supported. Its value is NULL. | | global_stats | character varying(3) | Not supported. Its value is NULL. | | domidx_status | character varying(12) | Not supported. Its value is NULL. | | domidx_opstatus | character varying(6) | Not supported. Its value is NULL. | | funcidx_status | character varying(8) | Not supported. Its value is NULL. | | join_index | character varying(3) | Not supported. Its value is NULL. | | iot_redundant_pkey_elim | character varying(3) | Not supported. Its value is NULL. | | dropped | character varying(3) | Not supported. Its value is NULL. | | visibility | character varying(9) | Specifies whether the index is visible to the optimizer.- VISIBLE: The index is visible to the optimizer.
- INVISIBLE: The index is visible to the optimizer. | | domidx_management | character varying(14) | Not supported. Its value is NULL. | | segment_created | character varying(3) | Not supported. Its value is NULL. | | orphaned_entries | character varying(3) | Not supported. Its value is NULL. | | indexing | character varying(7) | Not supported. Its value is NULL. | | auto | character varying(3) | Not supported. Its value is NULL. |
更多详情请参考GaussDB 文档中心：doc.hcs.huawei.com/db/zh-cn/ga…
