The pg_statistic_ext_data catalog provides information about extended statistics data.
| Column name | Data type | Description |
|---|---|---|
stxoid |
oid (references pg_statistic_ext.oid) |
The extended statistics object containing the definition for this data. |
stxdinherit |
bool |
Specifies whether the statistics include values from child tables in addition to the specified relation (TRUE) or not (FALSE). |
stxdndistinct |
pg_ndistinct |
N-distinct counts, serialized using the pg_ndistinct type. |
stxddependencies |
pg_dependencies |
Functional dependency statistics, serialized using the pg_dependencies type. |
stxdmcv |
pg_mcv_list |
Most-common-values (MCV) list statistics, serialized as the pg_mcv_list type. |
stxdexpr |
pg_statistic[] |
Per-expression statistics, serialized as the array of pg_statistic. |