ADM_SUBPART_COL_STATISTICS

ADM_SUBPART_COL_STATISTICS displays the column statistics and histogram information about all level-2 partitions in the database. By default, only the system administrator can access this view. Common users can access the view only after being authorized. This view exists in both PG_CATALOG and SYS schema.

**Table 1** ADM_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. Its value is NULL.
low_value	raw	Not supported. Its value is NULL.
high_value	raw	Not supported. Its value is NULL.
density	numeric	Not supported. Its value is NULL.
num_nulls	numeric	Not supported. Its value is NULL.
num_buckets	numeric	Not supported. Its value is NULL.
sample_size	numeric	Not supported. Its value is NULL.
last_analyzed	timestamp(0) without time zone	Not supported. Its value is NULL.
global_stats	character varying(3)	Not supported. Its value is NULL.
user_stats	character varying(3)	Not supported. Its value is NULL.
notes	character varying(41)	Not supported. Its value is NULL.
avg_col_len	numeric	Not supported. Its value is NULL.
histogram	character varying(15)	Not supported. Its value is NULL.
schema	character varying(64)	Name of the namespace to which the column belongs.