目录

pg_statistic_ext_data

包含扩展规划器统计数据的系统表

pg_statistic_ext_data 是一个 系统目录 表，其中包含在 pg_statistic_ext 中定义的扩展规划器统计数据。

pg_statistic_ext_data 在 PostgreSQL 12 中添加。

按 PostgreSQL 版本定义

pg_statistic_ext_data (PostgreSQL 19)

              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)

文档: pg_statistic_ext_data

pg_statistic_ext_data (PostgreSQL 18)

              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)

文档: pg_statistic_ext_data

pg_statistic_ext_data (PostgreSQL 17)

              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)

文档: pg_statistic_ext_data

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)

文档: 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)

文档: 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)

文档: 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)

文档: 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)

文档: pg_statistic_ext_data

变更历史

分类

系统目录

另请参阅

pg_statistic_ext, pg_stats_ext, CREATE STATISTICS

反馈

请将关于 "pg_statistic_ext_data" 的任何评论、建议或更正 在此 提交。