DB_IND_PARTITIONS

DB_IND_PARTITIONS displays information about partitioned table indexes (excluding global indexes of partitioned tables) accessible to the current user. This view exists in both PG_CATALOG and SYS schemas.

**Table 1** DB_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 partition where an index is located.
def_tablespace_name	name	Tablespace name of the index partition.
high_value	text	Limit of the partition corresponding to the 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	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.
high_value_length	integer	Character length of the limit of the partition corresponding to an index partition.