ADM_PART_INDEXES

ADM_PART_INDEXES displays information about all partitioned table indexes (excluding global indexes of partitioned tables) in the database. By default, only users with the SYSADMIN permission can access this system view. Common users can access it only after being authorized. This view exists in both the PG_CATALOG and SYS schemas.

**Table 1** ADM_PART_INDEXES columns
Name	Type	Description
def_tablespace_name	name	Tablespace name of a partitioned table index.
index_owner	character varying(64)	Owner name of a partitioned table index.
index_name	character varying(64)	Name of a partitioned table index.
partition_count	bigint	Number of index partitions of a partitioned table index.
partitioning_key_count	integer	Number of partition keys of the partitioned table.
partitioning_type	text	Partitioning policy of the partitioned table. NOTE: For details about the supported partitioning policies of the current partitioned table, see CREATE TABLE PARTITION.
schema	character varying(64)	Name of the schema to which the partitioned table index belongs.
table_name	character varying(64)	Name of the partitioned table to which a partitioned table index belongs.
subpartitioning_type	text	Partitioning policy of a level-2 partitioned table. If the partitioned table is a level-1 partitioned table, NONE is displayed. NOTE: For details about the supported partitioning policies of the current level-2 partitioned table, see CREATE TABLE SUBPARTITION.
def_subpartition_count	integer	Default number of level-2 partitions to be created. The value is 1 for a level-2 partitioned table and 0 for a level-1 partitioned table.
subpartitioning_key_count	integer	Number of level-2 partition keys of the partitioned table.