PG_STATISTIC_INFO
Records extended statistics objects of tables in the current cluster, including expression statistics objects. This system catalog is supported only by clusters of version 8.2.1.200 or later.
Column |
Type |
Description |
---|---|---|
relid |
oid |
Table used in the extended statistics object. |
statname |
name |
Name of the extended statistics object. |
statnamespace |
oid |
OID of the namespace that contains the extended statistics object. |
statowner |
oid |
OID of the owner of the extended statistics object. |
stattarget |
integer |
Controls the detail level of statistics. |
keys |
int2vector |
Array of column numbers described, indicating the columns included in the statistics object. |
kind |
"char"[] |
Array containing statistics types. The possible values are as follows: d: N-distinct statistics f: function dependency statistics m: most common value (MCV) statistics e: expression statistics |
exprs |
pg_node_tree |
Expression corresponding to the extended statistics information. |
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