ADM_IND_PARTITIONS
ADM_IND_PARTITIONS displays information about all index partitions in the database. Each index partition of a partitioned table in the database, if present, has a row of records in ADM_IND_PARTITIONS. By default, only the SYSADMIN can access this view. Common users can access the view only after being authorized. This view exists in both PG_CATALOG and SYS schemas.
Name |
Type |
Description |
---|---|---|
index_owner |
character varying(64) |
Name of the owner of the partitioned table index to which an index partition belongs. |
index_name |
character varying(64) |
Name of the partitioned table index to which the index partition belongs. |
partition_name |
character varying(64) |
Name of the index partition. |
def_tablespace_name |
name |
Tablespace name of the index partition. |
high_value |
text |
Upper limit of the partition corresponding to the index partition. |
index_partition_usable |
Boolean |
Specifies whether the index partition is available.
|
schema |
character varying(64) |
Schema of the partitioned table index to which the index partition belongs. |
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