ADM_PART_COL_STATISTICS

ADM_PART_COL_STATISTICS displays the column statistics and histogram information about all table 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 the PG_CATALOG and SYS schemas.

**Table 1** ADM_PART_COL_STATISTICS columns
Name	Type	Description
owner	character varying(128)	Owner of the partitioned table.
table_name	character varying(128)	Table name.
partition_name	character varying(128)	Table partition name.
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	date	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(63)	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.