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.
