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.

**Table 1** ADM_IND_PARTITIONS columns
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. t (true): yes. f (false): no.
schema	character varying(64)	Schema of the partitioned table index to which the index partition belongs.