Contents

pg_statistic_ext_data

A system catalogue table data containing data for extended planner statistics defined in pg_statistic_ext

pg_statistic_ext_data is a system catalogue table data containing data for extended planner statistics defined in pg_statistic_ext.

pg_statistic_ext_data was introduced in PostgreSQL 12 (commit 6cbfb784).

Definition by PostgreSQL version

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

Categories

System catalogue

See also

pg_statistic_ext, pg_stats_ext, CREATE STATISTICS