SYSTEM CATALOGS / SYSTEM CATALOGS
pg_statistic_ext_data
Read PG 18 manual ↗The catalog pg_statistic_ext_data holds data for extended planner statistics defined in pg_statistic_ext.
- Kind
- System catalogs
- Columns in this snapshot
- 6
- Definition source
- English manual
Columns 6
| Column | Type | Description / reference |
|---|---|---|
stxoid | oid | Extended statistics object containing the definition for this data pg_statistic_ext.oid |
stxdinherit | bool | If true, the stats include values from child tables, not just the values in the specified relation |
stxdndistinct | pg_ndistinct | N-distinct counts, serialized as pg_ndistinct type |
stxddependencies | pg_dependencies | Functional dependency statistics, serialized as pg_dependencies type |
stxdmcv | pg_mcv_list | MCV (most-common values) list statistics, serialized as pg_mcv_list type |
stxdexpr | pg_statistic[] | Per-expression statistics, serialized as an array of pg_statistic type |
Column history across versions
Version history 3
- PG 14 → 15changed
- PG 13 → 14changed
- PG 11 → 12added
Definition snapshot: english-manuals:c9fef2023ccbe7767eb5aca2a0a… · English manual source