ADM_IND_PARTITIONS

ADM_IND_PARTITIONS displays information about all index partitions in the database (excluding global indexes on partitioned tables). 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 system administrator can access this view. Common users can access the view only after being authorized. This view exists in both PG_CATALOG and SYS schema.

**Table 1** ADM_IND_PARTITIONS columns
Name	Type	Description
index_owner	character varying(64)	Owner name of the partitioned table index to which an index partition belongs
index_name	character varying(64)	Index name of the partitioned table index to which an index partition belongs
partition_name	character varying(64)	Name of an index partition
def_tablespace_name	name	Tablespace name of an index partition
high_value	text	Limit of the partition corresponding to an index partition NOTE: For range partitioning and interval partitioning, the upper limit of each partition is displayed. For list partitioning, the value list of each partition is displayed. For hash partitioning, the number of each partition is displayed.
index_partition_usable	boolean	Whether an index partition is available t (true): yes f (false): no
schema	character varying(64)	Schema of the partitioned table index to which an index partition belongs
high_value_length	integer	Character length of the limit of the partition corresponding to an index partition.