ALL_TAB_SUBPARTITIONS v10

The ALL_TAB_SUBPARTITIONS view provides information about all of the subpartitions that reside in the database.

NameTypeDescription
table_ownerTEXTThe owner of the table in which the subpartition resides.
schema_nameTEXTThe name of the schema in which the table resides.
table_nameTEXTThe name of the table.
partition_nameTEXTThe name of the partition.
subpartition_nameTEXTThe name of the subpartition.
high_valueTEXTThe high subpartitioning value specified in the CREATE TABLE statement.
high_value_lengthINTEGERThe length of the subpartitioning value.
subpartition_positionINTEGER1 for the first subpartition; 2 for the second subpartition, etc.
tablespace_nameTEXTThe name of the tablespace in which the subpartition resides.
pct_freeNUMERICIncluded for compatibility only; always 0.
pct_usedNUMERICIncluded for compatibility only; always 0.
ini_transNUMERICIncluded for compatibility only; always 0.
max_transNUMERICIncluded for compatibility only; always 0.
initial_extentNUMERICIncluded for compatibility only; always NULL.
next_extentNUMERICIncluded for compatibility only; always NULL.
min_extentNUMERICIncluded for compatibility only; always 0.
max_extentNUMERICIncluded for compatibility only; always 0.
pct_increaseNUMERICIncluded for compatibility only; always 0.
freelistsNUMERICIncluded for compatibility only; always NULL.
freelist_groupsNUMERICIncluded for compatibility only; always NULL.
loggingCHARACTER VARYING(7)Included for compatibility only; always YES.
compressionCHARACTER VARYING(8)Included for compatibility only; always NONE.
num_rowsNUMERICSame as pg_class.reltuples.
blocksINTEGERSame as pg_class.relpages.
empty_blocksNUMERICIncluded for compatibility only; always NULL.
avg_spaceNUMERICIncluded for compatibility only; always NULL.
chain_cntNUMERICIncluded for compatibility only; always NULL.
avg_row_lenNUMERICIncluded for compatibility only; always NULL.
sample_sizeNUMERICIncluded for compatibility only; always NULL.
last_analyzedTIMESTAMP WITHOUT TIME ZONEIncluded for compatibility only; always NULL.
buffer_poolCHARACTER VARYING(7)Included for compatibility only; always NULL.
global_statsCHARACTER VARYING(3)Included for compatibility only; always YES.
user_statsCHARACTER VARYING(3)Included for compatibility only; always NO.
backing_tableREGCLASSName of the subpartition backing table.