System Catalogs / System catalogs
pg_statistic_ext_data
Read the PG 18 manualThe catalog pg_statistic_ext_data holds data for extended planner statistics defined in pg_statistic_ext.
Reading PG 18current·documented in 9 of 24 versions, 12 to 20
- Kind
- System catalogs
- Columns in this snapshot
- 6
- Definition source
- English manual
- Metadata snapshot
- 18.6
Columns 6
As listed in the PostgreSQL 18 manual.
| Column | Type | Description / reference |
|---|---|---|
stxoid | oidNOT NULL | Extended statistics object containing the definition for this data pg_statistic_ext.oid |
stxdinherit | boolNOT NULL | 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
Definition snapshot: english-manuals:b9fdfa8534cfb1f93e648d112f7… · English manual source