PG_STATISTIC_DATA
Records extended statistics of tables in the current cluster, including expression statistics. This system catalog is supported only by clusters of version 8.2.1.200 or later.
Column |
Type |
Description |
---|---|---|
statoid |
oid |
OID of the object for which extended statistics are collected. |
inherit |
boolean |
Whether to collect statistics for objects that have inheritance relationship.
|
ndistinct |
pg_ndistinct |
N-distinct count, which is serialized as the pg_ndistinct type. |
dependencies |
pg_dependencies |
Function dependency statistics, which are serialized as the pg_dependencies type. |
mcv |
pg_mcv_list |
Most common value (MCV) statistics, which are serialized as the pg_mcv_list type. |
expr |
pg_statistic[] |
Statistics of each expression, which is serialized as an array of the pg_statistic type. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot