The DBA_TAB_SUBPARTITIONS view provides the information about all subpartitions that locate in the database.

Parameter Type Description
table_owner TEXT The owner of the table where a subpartition is located.
schema_name TEXT The name of the schema where the table is located.
table_name TEXT The name of the table.
partition_name TEXT The name of the partition.
subpartition_name TEXT The name of the subpartition.
high_value TEXT The high subpartitioning value specified in the CREATE TABLE statement.
high_value_length INTEGER The length of the high subpartitioning value.
subpartition_position INTEGER The ordinal position of this subpartition. For example, a value of 1 indicates the first subpartition and a value of 2 indicates the second subpartition. All positions of subpartitions follow the same rule.
tablespace_name TEXT The name of the tablespace where the subpartition is located.
pct_free NUMERIC This parameter is supported for compatibility only. The value is 0.
pct_used NUMERIC This parameter is supported for compatibility only. The value is 0.
ini_trans NUMERIC This parameter is supported for compatibility only. The value is 0.
max_trans NUMERIC This parameter is supported for compatibility only. The value is 0.
initial_extent NUMERIC This parameter is supported for compatibility only. The value is NULL.
next_extent NUMERIC This parameter is supported for compatibility only. The value is NULL.
min_extent NUMERIC This parameter is supported for compatibility only. The value is 0.
max_extent NUMERIC This parameter is supported for compatibility only. The value is 0.
pct_increase NUMERIC This parameter is supported for compatibility only. The value is 0.
freelists NUMERIC This parameter is supported for compatibility only. The value is NULL.
freelist_groups NUMERIC This parameter is supported for compatibility only. The value is NULL.
logging CHARACTER VARYING(7) This parameter is supported for compatibility only. The value is YES.
compression CHARACTER VARYING(8) This parameter is supported for compatibility only. The value is NONE.
num_rows NUMERIC The same as pg_class.reltuples.
blocks INTEGER The same as pg_class.relpages.
empty_blocks NUMERIC This parameter is supported for compatibility only. The value is NULL.
avg_space NUMERIC This parameter is supported for compatibility only. The value is NULL.
chain_cnt NUMERIC This parameter is supported for compatibility only. The value is NULL.
avg_row_len NUMERIC This parameter is supported for compatibility only. The value is NULL.
sample_size NUMERIC This parameter is supported for compatibility only. The value is NULL.
last_analyzed TIMESTAMP WITHOUT TIME ZONE This parameter is supported for compatibility only. The value is NULL.
buffer_pool CHARACTER VARYING(7) This parameter is supported for compatibility only. The value is NULL.
global_stats CHARACTER VARYING(3) This parameter is supported for compatibility only. The value is YES.
user_stats CHARACTER VARYING(3) This parameter is supported for compatibility only. The value is NO.
backing_table REGCLASS The name of the subpartition backup table.