ADM_IND_PARTITIONS

ADM_IND_PARTITIONS displays the partition information about local indexes of level-1 partitioned table in the database (excluding global indexes on partitioned tables). Each local index partition of level-1 index 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 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 an 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. 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 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.
composite	character varying(3)	Specifies whether the index is a local index on the level-2 partitioned table. This table does not store level-2 partition information. Therefore, the value is NO.
subpartition_count	numeric	Number of level-2 partitions in a partition. This table does not store level-2 partition information. Therefore, the value is 0.
partition_position	numeric	Position of an index partition in the index.
status	character varying(8)	Specifies whether an index partition is available.
tablespace_name	name	Name of the tablespace that contains the partition.
pct_free	numeric	Percentage of minimum available space in a block.
ini_trans	numeric	Initial number of transactions. The default value is 4. The value is NULL for non-Ustore partitioned tables.
max_trans	numeric	Maximum number of transactions. The default value is 128. The value is NULL for non-Ustore partitioned tables.
initial_extent	numeric	Not supported. Its value is NULL.
next_extent	numeric	Not supported. Its value is NULL.
min_extent	numeric	Not supported. Its value is NULL.
max_extent	numeric	Not supported. Its value is NULL.
max_size	numeric	Not supported. Its value is NULL.
pct_increase	numeric	Not supported. Its value is NULL.
freelists	numeric	Not supported. Its value is NULL.
freelist_groups	numeric	Not supported. Its value is NULL.
logging	character varying(7)	Specifies whether changes to an index are logged.
compression	character varying(13)	Specifies whether an index compression is enabled for a partitioned index.
blevel	numeric	Not supported. Its value is NULL.
leaf_blocks	numeric	Not supported. Its value is NULL.
distinct_keys	numeric	Not supported. Its value is NULL.
avg_leaf_blocks_per_key	numeric	Not supported. Its value is NULL.
avg_data_blocks_per_key	numeric	Not supported. Its value is NULL.
clustering_factor	numeric	Sequence of a row in the table based on the value of the index. You need to run the analyze command to collect statistics.
num_rows	numeric	Number of rows in a partition. You need to run the vacuum command to collect statistics.
sample_size	numeric	Not supported. Its value is NULL.
last_analyzed	timestamp with time zone	Last date when the partition was analyzed.
buffer_pool	character varying(7)	Actual buffer pool of a partition.
flash_cache	character varying(7)	Not supported. Its value is NULL.
cell_flash_cache	character varying(7)	Not supported. Its value is NULL.
user_stats	character varying(3)	Not supported. Its value is NULL.
pct_direct_access	numeric	Not supported. Its value is NULL.
global_stats	character varying(3)	Not supported. Its value is NULL.
domidx_opstatus	character varying(6)	Not supported. Its value is NULL.
parameters	character varying(1000)	Not supported. Its value is NULL.
interval	character varying(3)	Specifies whether the partition is a partition in an interval partitioned table.
segment_created	character varying(3)	Specifies whether an index partition segment has been created.
orphaned_entries	character varying(3)	Not supported. Its value is NULL.