pg_statistic_ext_data
A system table containing data for extended planner statistics
pg_statistic_ext_data
is a system catalogue table containing data for extended planner statistics defined in pg_statistic_ext
.
pg_statistic_ext_data
was added in PostgreSQL 12.
Definition by PostgreSQL version
pg_statistic_ext_data (PostgreSQL 15)
Table "pg_catalog.pg_statistic_ext_data" Column | Type | Collation | Nullable | Default ------------------+-----------------+-----------+----------+--------- stxoid | oid | | not null | stxdinherit | boolean | | not null | stxdndistinct | pg_ndistinct | C | | stxddependencies | pg_dependencies | C | | stxdmcv | pg_mcv_list | C | | stxdexpr | pg_statistic[] | | | Indexes: "pg_statistic_ext_data_stxoid_inh_index" PRIMARY KEY, btree (stxoid, stxdinherit)
Documentation: pg_statistic_ext_data
pg_statistic_ext_data (PostgreSQL 14)
Table "pg_catalog.pg_statistic_ext_data" Column | Type | Collation | Nullable | Default ------------------+-----------------+-----------+----------+--------- stxoid | oid | | not null | stxdndistinct | pg_ndistinct | C | | stxddependencies | pg_dependencies | C | | stxdmcv | pg_mcv_list | C | | stxdexpr | pg_statistic[] | | | Indexes: "pg_statistic_ext_data_stxoid_index" PRIMARY KEY, btree (stxoid)
Documentation: pg_statistic_ext_data
pg_statistic_ext_data (PostgreSQL 13)
Table "pg_catalog.pg_statistic_ext_data" Column | Type | Collation | Nullable | Default ------------------+-----------------+-----------+----------+--------- stxoid | oid | | not null | stxdndistinct | pg_ndistinct | C | | stxddependencies | pg_dependencies | C | | stxdmcv | pg_mcv_list | C | | Indexes: "pg_statistic_ext_data_stxoid_index" UNIQUE, btree (stxoid)
Documentation: pg_statistic_ext_data
pg_statistic_ext_data (PostgreSQL 12)
Table "pg_catalog.pg_statistic_ext_data" Column | Type | Collation | Nullable | Default ------------------+-----------------+-----------+----------+--------- stxoid | oid | | not null | stxdndistinct | pg_ndistinct | C | | stxddependencies | pg_dependencies | C | | stxdmcv | pg_mcv_list | C | | Indexes: "pg_statistic_ext_data_stxoid_index" UNIQUE, btree (stxoid)
Documentation: pg_statistic_ext_data
Change history
- PostgreSQL 15
- column
stxdinherit
added (commit 269b532a)
- column
- PostgreSQL 14
- column
stxdexpr
added (commit a4d75c86)
- column
- PostgreSQL 12
- added (commit 6cbfb784)
References
- PostgreSQL documentation: pg_statistic_ext_data