ALL_TAB_PARTITIONS v11

The ALL_TAB_PARTITIONS view provides information about all of the partitions that reside in the database.

NameTypeDescription
table_ownerTEXTThe owner of the table in which the partition resides.
schema_nameTEXTThe name of the schema in which the table resides.
table_nameTEXTThe name of the table.
compositeTEXTYES if the table is subpartitioned; NO if the table is not subpartitioned.
partition_nameTEXTThe name of the partition.
subpartition_countBIGINTThe number of subpartitions in the partition.
high_valueTEXTThe high partitioning value specified in the CREATE TABLE statement.
high_value_lengthINTEGERThe length of high partitioning value.
partition_positionINTEGERIncluded for compatibility only; always NULL.
tablespace_nameTEXTThe name of the tablespace in which the partition 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 partition backing table.