MY_IND_PARTITIONS

t (true): yes.
f (false): no.

MY_IND_PARTITIONS displays information about index partitions accessible to the current user. This view exists in both PG_CATALOG and SYS schema.

**Table 1** MY_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)	Index 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	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