SYSTEM CATALOGS / SYSTEM CATALOGS
pg_statistic_ext
Read PG 18 manual ↗The catalog pg_statistic_ext holds definitions of extended planner statistics.
- Kind
- System catalogs
- Columns in this snapshot
- 9
- Definition source
- English manual
Columns 9
| Column | Type | Description / reference |
|---|---|---|
oid | oid | Row identifier |
stxrelid | oid | Table containing the columns described by this object pg_class.oid |
stxname | name | Name of the statistics object |
stxnamespace | oid | The OID of the namespace that contains this statistics object pg_namespace.oid |
stxowner | oid | Owner of the statistics object pg_authid.oid |
stxkeys | int2vector | An array of attribute numbers, indicating which table columns are covered by this statistics object; for example a value of 1 3 would mean that the first and the third table columns are covered pg_attribute.attnum |
stxstattarget | int2 | stxstattarget controls the level of detail of statistics accumulated for this statistics object by ANALYZE. A zero value indicates that no statistics should be collected. A null value says to use the maximum of the statistics targets of the referenced columns, if set, or the system default statistics target. Positive values of stxstattarget determine the target number of “most common values” to collect. |
stxkind | char[] | An array containing codes for the enabled statistics kinds; valid values are: d for n-distinct statistics, f for functional dependency statistics, m for most common values (MCV) list statistics, and e for expression statistics |
stxexprs | pg_node_tree | Expression trees (in nodeToString() representation) for statistics object attributes that are not simple column references. This is a list with one element per expression. Null if all statistics object attributes are simple references. |
Column history across versions
| Column | 9.0 | 9.1 | 9.2 | 9.3 | 9.4 | 9.5 | 9.6 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
stxrelid | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
stxname | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
stxnamespace | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
stxowner | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
stxkeys | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
stxkind | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
stxndistinct | · | · | · | · | · | · | · | ● | ● | · | · | · | · | · | · | · | · | · |
stxdependencies | · | · | · | · | · | · | · | ● | ● | · | · | · | · | · | · | · | · | · |
oid | · | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● |
stxstattarget | · | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● |
stxexprs | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● |
Version history 5
- PG 16 → 17changed
- PG 13 → 14changed
- PG 12 → 13changed
- PG 11 → 12changed
- PG 9.6 → 10added
Definition snapshot: english-manuals:cad887bb1ffa22cd4c7ae5f068f… · English manual source