The USER_TAB_PARTITIONS view provides the information about all of the partitions that are owned by the current user.

Parameter Type Description
schema_name TEXT The name of the schema to which the table belongs.
table_name TEXT The name of the table.
composite TEXT
  • YES: The table is subpartitioned.
  • NO: The table is not subpartitioned.
partition_name TEXT The name of the partition.
subpartition_count BIGINT The number of subpartitions in the partition.
high_value TEXT The high partitioning value specified in the CREATE TABLE statement.
high_value_length INTEGER The length of the high partitioning value.
partition_position INTEGER The ordinal position of this partition. For example, a value of 1 indicates the first partition and a value of 2 indicates the second partition. All positions follow the same rules.
tablespace_name TEXT The name of the tablespace to which the subpartition belongs.
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 partition backup table.