DB_SUBPART_COL_STATISTICS

DB_SUBPART_COL_STATISTICS displays column statistics and histogram information about level-2 partitions of partitioned objects accessible to the current user. All users can access this view. This view exists in the PG_CATALOG and SYS schemas.

**Table 1** DB_SUBPART_COL_STATISTICS columns
Name	Type	Description
owner	character varying(128)	Table owner.
table_name	character varying(128)	Table name.
subpartition_name	character varying(128)	Name of a level-2 partition.
column_name	character varying(4000)	Column name.
num_distinct	numeric	Not supported. Set it to NULL.
low_value	raw	Not supported. Set it to NULL.
high_value	raw	Not supported. Set it to NULL.
density	numeric	Not supported. Set it to NULL.
num_nulls	numeric	Not supported. Set it to NULL.
num_buckets	numeric	Not supported. Set it to NULL.
sample_size	numeric	Not supported. Set it to NULL.
last_analyzed	timestamp(0) without time zone	Not supported. Set it to NULL.
global_stats	character varying(3)	Not supported. Set it to NULL.
user_stats	character varying(3)	Not supported. Set it to NULL.
notes	character varying(41)	Not supported. Set it to NULL.
avg_col_len	numeric	Not supported. Set it to NULL.
histogram	character varying(15)	Not supported. Set it to NULL.
schema	character varying(64)	Name of the namespace to which the column belongs.