GaussDB-MY_TAB_HISTOGRAMS
MY_TAB_HISTOGRAMS displays histogram information about the tables and views owned by the current user. All users can access this view. This view exists in the PG_CATALOG and SYS schemas.
| Name | Type | Description |
|---|---|---|
| table_name | character varying(128) | Table name. |
| column_name | character varying(4000) | Column name or attribute of an object column. |
| endpoint_number | numeric | Bucket ID of the histogram. |
| endpoint_value | numeric | Not supported. Set it to NULL. |
| endpoint_actual_value | character varying(4000) | Actual value of the bucket endpoint. |
| endpoint_actual_value_raw | raw | Not supported. Set it to NULL. |
| endpoint_repeat_count | numeric | Not supported. Set it to NULL. |
| scope | character varying(7) | Not supported. Set it to SHARED. |
更多详情请参考GaussDB 文档中心:doc.hcs.huawei.com/db/zh-cn/ga…