Contents

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 16)

              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 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

Categories

System catalogue

See also

pg_statistic_ext, pg_stats_ext, CREATE STATISTICS