MY_PART_INDEXES
MY_PART_INDEXES displays information about partitioned table indexes accessible to the current user. This view exists in both the PG_CATALOG and SYS schemas.
| Name | Type | Description |
|---|---|---|
| def_tablespace_name | name | Tablespace name of the partitioned table index |
| index_owner | character varying(64) | Name of the owner of a partitioned table index |
| index_name | character varying(64) | Name of the partitioned table index |
| partition_count | bigint | Number of index partitions of the partitioned table index |
| partitioning_key_count | integer | Number of partition keys of the partitioned table |
| partitioning_type | text | Partition policy of the partitioned table NOTE: Only range partitioning is supported. |
| schema | character varying(64) | Schema of the partitioned table index |
| table_name | character varying(64) | Name of the partitioned table to which the partitioned table index belongs |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
