The USER_TAB_SUBPARTITIONS view provides information about all of the subpartitions 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. |
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 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. |