{"Entry":{"collection":"catalog","key":"pg_statistic_ext_data","name":"pg_statistic_ext_data","aliases":[],"metadata":{"changed_in":["14","15"],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"11","order":false,"removed":[],"status":"added","to":"12","types":[]},{"added":["stxdexpr"],"attributes":[],"description_changed":true,"descriptions":[{"from":"Extended statistic object containing the definition for this data","name":"stxoid","to":"Extended statistics object containing the definition for this data"}],"from":"13","listing":[],"order":false,"removed":[],"status":"changed","to":"14","types":[],"unlisted":[]},{"added":["stxdinherit"],"attributes":[],"description_changed":true,"descriptions":[],"from":"14","listing":[],"order":false,"removed":[],"status":"changed","to":"15","types":[],"unlisted":[]}],"column_count":6,"content_hash":"023b2398d64f3b75244c9b9529ea59e61ca711fa745aed2998d0eda329251f95","derived_content_hash":"6e36a735060cc40173a22eb7c8cadd59ba06597e3345644683b710906c259f7f","first_version":"12","imported_at":"2026-09-30T00:40:56.182616+08:00","kind":"catalog","last_version":"20","name":"pg_statistic_ext_data","position":132,"present_in":["12","13","14","15","16","17","18","19","20"],"relation_oid":null,"relkind":"r","shared":false,"source_rev":"catalog-bilingual-repair:0a42ccfb0ad40f202f6b561a427c0d1911d0d8b2629ddedda9c34e898f4b83c2","summary":"The catalog pg_statistic_ext_data holds data for extended planner statistics defined in pg_statistic_ext.","summary_zh":"目录 pg_statistic_ext_data 保存在 pg_statistic_ext 中定义的扩展规划器统计信息的数据。该目录的每一行对应用 CREATE STATISTICS 创建的一个统计信息对象。"}},"Definition":{"Collection":"catalog","Key":"pg_statistic_ext_data","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_statistic_ext_data","SourceRevision":"catalog-bilingual-repair:0a42ccfb0ad40f202f6b561a427c0d1911d0d8b2629ddedda9c34e898f4b83c2","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Extended statistics object containing the definition for this data","description_zh":"包含此数据定义的扩展统计信息对象","documented":true,"documented_name":"stxoid","hidden":false,"name":"stxoid","not_null":true,"references":"pg_statistic_ext.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"description":"If true, the stats include values from child tables, not just the values in the specified relation","description_zh":"如果为真，则统计信息包括子表中的值，而不仅仅是指定关系中的值","documented":true,"documented_name":"stxdinherit","hidden":false,"name":"stxdinherit","not_null":true,"references":"","type":"bool","type_modifier":-1,"type_oid":16,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"N-distinct counts, serialized as pg_ndistinct type","description_zh":"非重复值计数，序列化为 pg_ndistinct 类型","documented":true,"documented_name":"stxdndistinct","hidden":false,"name":"stxdndistinct","not_null":false,"references":"","type":"pg_ndistinct","type_modifier":-1,"type_oid":3361,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"Functional dependency statistics, serialized as pg_dependencies type","description_zh":"函数依赖统计信息，序列化为 pg_dependencies 类型","documented":true,"documented_name":"stxddependencies","hidden":false,"name":"stxddependencies","not_null":false,"references":"","type":"pg_dependencies","type_modifier":-1,"type_oid":3402,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":5,"description":"MCV (most-common values) list statistics, serialized as pg_mcv_list type","description_zh":"MCV（高频值）列表统计信息，序列化为 pg_mcv_list 类型","documented":true,"documented_name":"stxdmcv","hidden":false,"name":"stxdmcv","not_null":false,"references":"","type":"pg_mcv_list","type_modifier":-1,"type_oid":5017,"zh_from":"same-version-manual"},{"array_dimensions":1,"attnum":6,"description":"Per-expression statistics, serialized as an array of pg_statistic type","description_zh":"每个表达式的统计信息，序列化为 pg_statistic 类型的数组。","documented":true,"documented_name":"stxdexpr","hidden":false,"name":"stxdexpr","not_null":false,"references":"","type":"pg_statistic[]","type_modifier":-1,"type_oid":10028,"zh_from":"same-version-manual"}],"description":"The catalog pg_statistic_ext_data holds data for extended planner statistics defined in pg_statistic_ext. Each row in this catalog corresponds to a statistics object created with CREATE STATISTICS.\n\nNormally there is one entry, with stxdinherit = false, for each statistics object that has been analyzed. If the table has inheritance children or partitions, a second entry with stxdinherit = true is also created. This row represents the statistics object over the inheritance tree, i.e., statistics for the data you'd see with SELECT * FROM table*, whereas the stxdinherit = false row represents the results of SELECT * FROM ONLY table.\n\nLike pg_statistic, pg_statistic_ext_data should not be readable by the public, since the contents might be considered sensitive. (Example: most common combinations of values in columns might be quite interesting.) pg_stats_ext is a publicly readable view on pg_statistic_ext_data (after joining with pg_statistic_ext) that only exposes information about tables the current user owns.","description_zh":"目录 pg_statistic_ext_data 保存在 pg_statistic_ext 中定义的扩展规划器统计信息的数据。该目录的每一行对应用 CREATE STATISTICS 创建的一个统计信息对象。\n\n通常，每个已分析的统计信息对象都有一个 stxdinherit = false 的条目。如果表有继承子表或分区，还会创建第二个 stxdinherit = true 的条目。后者表示该统计信息对象在整个继承树上的统计信息，即通过 SELECT * FROM table* 看到的数据的统计信息；而 stxdinherit = false 的行表示 SELECT * FROM ONLY table 的结果。\n\n像 pg_statistic 一样，pg_statistic_ext_data 不应公开可读，因为其内容可能被视为敏感。（例如，列中最常见的值组合可能非常引人关注。）pg_stats_ext 是建立在 pg_statistic_ext_data 之上的公开可读视图，（在与 pg_statistic_ext 连接后），仅暴露当前用户拥有的表的信息。","description_zh_html":"\u003cp\u003e目录 pg_statistic_ext_data 保存在 pg_statistic_ext 中定义的扩展规划器统计信息的数据。该目录的每一行对应用 CREATE STATISTICS 创建的一个统计信息对象。\u003c/p\u003e\n\u003cp\u003e通常，每个已分析的统计信息对象都有一个 stxdinherit = false 的条目。如果表有继承子表或分区，还会创建第二个 stxdinherit = true 的条目。后者表示该统计信息对象在整个继承树上的统计信息，即通过 SELECT * FROM table* 看到的数据的统计信息；而 stxdinherit = false 的行表示 SELECT * FROM ONLY table 的结果。\u003c/p\u003e\n\u003cp\u003e像 pg_statistic 一样，pg_statistic_ext_data 不应公开可读，因为其内容可能被视为敏感。（例如，列中最常见的值组合可能非常引人关注。）pg_stats_ext 是建立在 pg_statistic_ext_data 之上的公开可读视图，（在与 pg_statistic_ext 连接后），仅暴露当前用户拥有的表的信息。\u003c/p\u003e","doc":{"anchor":"id-1.10.4.55.6","file":"catalog-pg-statistic-ext-data.html","lang":"en","sha256":"9f2e7308b808af6cbc3a07229eaac7dc3eccad73d92e7c632470de9831be741d","slug":"18"},"kind":"catalog","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["stxoid","stxdinherit","stxdndistinct","stxddependencies","stxdmcv","stxdexpr"],"runtime_verified":false,"source":"english-manual","sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"catalog-pg-statistic-ext-data.html","sha256":"4295ca69f4be6426e330a26f3f5d6884e4fea710ca4aac0c5d6b6ee24a087704","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:b9fdfa8534cfb1f93e648d112f770018330fa27757b2ba0b89799dcb4b2ce6a1","version":"18"}],"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.10.4.55.6","file":"catalog-pg-statistic-ext-data.html","lang":"en","sha256":"9f2e7308b808af6cbc3a07229eaac7dc3eccad73d92e7c632470de9831be741d","slug":"18"},"sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"catalog-pg-statistic-ext-data.html","sha256":"4295ca69f4be6426e330a26f3f5d6884e4fea710ca4aac0c5d6b6ee24a087704","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:b9fdfa8534cfb1f93e648d112f770018330fa27757b2ba0b89799dcb4b2ce6a1","version":"18"}]},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["stxoid","stxdinherit","stxdndistinct","stxddependencies","stxdmcv","stxdexpr"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_statistic_ext_data","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_statistic_ext_data","Summary":"The catalog pg_statistic_ext_data holds data for extended planner statistics defined in pg_statistic_ext. Each row in this catalog corresponds to a statistics object created with CREATE STATISTICS.\n\nNormally there is one entry, with stxdinherit = false, for each statistics object that has been analyzed. If the table has inheritance children or partitions, a second entry with stxdinherit = true is also created. This row represents the statistics object over the inheritance tree, i.e., statistics for the data you'd see with SELECT * FROM table*, whereas the stxdinherit = false row represents the results of SELECT * FROM ONLY table.\n\nLike pg_statistic, pg_statistic_ext_data should not be readable by the public, since the contents might be considered sensitive. (Example: most common combinations of values in columns might be quite interesting.) pg_stats_ext is a publicly readable view on pg_statistic_ext_data (after joining with pg_statistic_ext) that only exposes information about tables the current user owns.","BodyHTML":"\u003cp\u003eThe catalog pg_statistic_ext_data holds data for extended planner statistics defined in pg_statistic_ext. Each row in this catalog corresponds to a statistics object created with CREATE STATISTICS.\n\nNormally there is one entry, with stxdinherit = false, for each statistics object that has been analyzed. If the table has inheritance children or partitions, a second entry with stxdinherit = true is also created. This row represents the statistics object over the inheritance tree, i.e., statistics for the data you\u0026#39;d see with SELECT * FROM table*, whereas the stxdinherit = false row represents the results of SELECT * FROM ONLY table.\n\nLike pg_statistic, pg_statistic_ext_data should not be readable by the public, since the contents might be considered sensitive. (Example: most common combinations of values in columns might be quite interesting.) pg_stats_ext is a publicly readable view on pg_statistic_ext_data (after joining with pg_statistic_ext) that only exposes information about tables the current user owns.\u003c/p\u003e","SourceRevision":"catalog-bilingual-repair:0a42ccfb0ad40f202f6b561a427c0d1911d0d8b2629ddedda9c34e898f4b83c2","ContentHash":"d42f1c5822e1a578446f774e81e2c48aef386b85f1e8c2bcf414b1e0d45f220d","Payload":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Extended statistics object containing the definition for this data","description_zh":"包含此数据定义的扩展统计信息对象","documented":true,"documented_name":"stxoid","hidden":false,"name":"stxoid","not_null":true,"references":"pg_statistic_ext.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"description":"If true, the stats include values from child tables, not just the values in the specified relation","description_zh":"如果为真，则统计信息包括子表中的值，而不仅仅是指定关系中的值","documented":true,"documented_name":"stxdinherit","hidden":false,"name":"stxdinherit","not_null":true,"references":"","type":"bool","type_modifier":-1,"type_oid":16,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"N-distinct counts, serialized as pg_ndistinct type","description_zh":"非重复值计数，序列化为 pg_ndistinct 类型","documented":true,"documented_name":"stxdndistinct","hidden":false,"name":"stxdndistinct","not_null":false,"references":"","type":"pg_ndistinct","type_modifier":-1,"type_oid":3361,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"Functional dependency statistics, serialized as pg_dependencies type","description_zh":"函数依赖统计信息，序列化为 pg_dependencies 类型","documented":true,"documented_name":"stxddependencies","hidden":false,"name":"stxddependencies","not_null":false,"references":"","type":"pg_dependencies","type_modifier":-1,"type_oid":3402,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":5,"description":"MCV (most-common values) list statistics, serialized as pg_mcv_list type","description_zh":"MCV（高频值）列表统计信息，序列化为 pg_mcv_list 类型","documented":true,"documented_name":"stxdmcv","hidden":false,"name":"stxdmcv","not_null":false,"references":"","type":"pg_mcv_list","type_modifier":-1,"type_oid":5017,"zh_from":"same-version-manual"},{"array_dimensions":1,"attnum":6,"description":"Per-expression statistics, serialized as an array of pg_statistic type","description_zh":"每个表达式的统计信息，序列化为 pg_statistic 类型的数组。","documented":true,"documented_name":"stxdexpr","hidden":false,"name":"stxdexpr","not_null":false,"references":"","type":"pg_statistic[]","type_modifier":-1,"type_oid":10028,"zh_from":"same-version-manual"}],"description":"The catalog pg_statistic_ext_data holds data for extended planner statistics defined in pg_statistic_ext. Each row in this catalog corresponds to a statistics object created with CREATE STATISTICS.\n\nNormally there is one entry, with stxdinherit = false, for each statistics object that has been analyzed. If the table has inheritance children or partitions, a second entry with stxdinherit = true is also created. This row represents the statistics object over the inheritance tree, i.e., statistics for the data you'd see with SELECT * FROM table*, whereas the stxdinherit = false row represents the results of SELECT * FROM ONLY table.\n\nLike pg_statistic, pg_statistic_ext_data should not be readable by the public, since the contents might be considered sensitive. (Example: most common combinations of values in columns might be quite interesting.) pg_stats_ext is a publicly readable view on pg_statistic_ext_data (after joining with pg_statistic_ext) that only exposes information about tables the current user owns."}},"RequestedLocale":"en","Fallback":false,"Versions":["12","13","14","15","16","17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}