MY_PART_COL_STATISTICS
MY_PART_COL_STATISTICS displays column statistics and histogram information about table partitions owned by the current user. It is accessible to all users. This view exists in the PG_CATALOG and SYS schemas.
Name | Type | Description |
|---|---|---|
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. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
