GaussDB-MY_TAB_HISTOGRAMS

26 阅读1分钟

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.

NameTypeDescription
table_namecharacter varying(128)Table name.
column_namecharacter varying(4000)Column name or attribute of an object column.
endpoint_numbernumericBucket ID of the histogram.
endpoint_valuenumericNot supported. Set it to NULL.
endpoint_actual_valuecharacter varying(4000)Actual value of the bucket endpoint.
endpoint_actual_value_rawrawNot supported. Set it to NULL.
endpoint_repeat_countnumericNot supported. Set it to NULL.
scopecharacter varying(7)Not supported. Set it to SHARED.

更多详情请参考GaussDB 文档中心:doc.hcs.huawei.com/db/zh-cn/ga…