内容

pg_statistic_ext_data

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

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

pg_statistic_ext_data 在PostgreSQL 12中添加。

按PostgreSQL版本定义

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" 的任何评论、建议或更正 此处.