GaussDB-DB_TAB_HISTOGRAMS

30 阅读1分钟

GaussDB-DB_TAB_HISTOGRAMS

DB_TAB_HISTOGRAMS displays histogram statistics about the tables and views accessible to the current user, that is, the distribution of data in each column of the table. All users can access this view. This view exists in the PG_CATALOG and SYS schemas.

NameTypeDescription
ownercharacter varying(128)Table owner.
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…