{"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":"437fa48d023f2f73a82b563ca358f4c610770f2110367e039b69569a30133beb","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":"english-manuals:b9fdfa8534cfb1f93e648d112f770018330fa27757b2ba0b89799dcb4b2ce6a1","summary":"The catalog pg_statistic_ext_data holds data for extended planner statistics defined in pg_statistic_ext.","summary_zh":""}},"Definition":{"Collection":"catalog","Key":"pg_statistic_ext_data","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_statistic_ext_data","SourceRevision":"english-manuals:b9fdfa8534cfb1f93e648d112f770018330fa27757b2ba0b89799dcb4b2ce6a1","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},{"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},{"array_dimensions":0,"attnum":3,"description":"N-distinct counts, serialized as pg_ndistinct type","description_zh":"","documented":true,"documented_name":"stxdndistinct","hidden":false,"name":"stxdndistinct","not_null":false,"references":"","type":"pg_ndistinct","type_modifier":-1,"type_oid":3361},{"array_dimensions":0,"attnum":4,"description":"Functional dependency statistics, serialized as pg_dependencies type","description_zh":"","documented":true,"documented_name":"stxddependencies","hidden":false,"name":"stxddependencies","not_null":false,"references":"","type":"pg_dependencies","type_modifier":-1,"type_oid":3402},{"array_dimensions":0,"attnum":5,"description":"MCV (most-common values) list statistics, serialized as pg_mcv_list type","description_zh":"","documented":true,"documented_name":"stxdmcv","hidden":false,"name":"stxdmcv","not_null":false,"references":"","type":"pg_mcv_list","type_modifier":-1,"type_oid":5017},{"array_dimensions":1,"attnum":6,"description":"Per-expression statistics, serialized as an array of pg_statistic type","description_zh":"","documented":true,"documented_name":"stxdexpr","hidden":false,"name":"stxdexpr","not_null":false,"references":"","type":"pg_statistic[]","type_modifier":-1,"type_oid":10028}],"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":"","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"},"ManualEvidence":{"doc":{"anchor":"id-1.10.4.55.6","file":"catalog-pg-statistic-ext-data.html","lang":"en","sha256":"9f2e7308b808af6cbc3a07229eaac7dc3eccad73d92e7c632470de9831be741d","slug":"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":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_statistic_ext_data","Summary":"目录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连接后），仅暴露当前用户拥有的表的信息。","BodyHTML":"\u003cp\u003e目录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连接后），仅暴露当前用户拥有的表的信息。\u003c/p\u003e","SourceRevision":"2026-09-27@419045e","ContentHash":"a30c12b3d20e62315f01f07064a8679614a4067b079b65419c23cc0a08a73adf","Payload":{"columns":[{"description_zh":"包含此数据定义的扩展统计信息对象","name":"stxoid","type":"oid","zh_from":"doc"},{"description_zh":"如果为真，则统计信息包括子表中的值，而不仅仅是指定关系中的值","name":"stxdinherit","type":"boolean","zh_from":"doc"},{"description_zh":"非重复值计数，序列化为pg_ndistinct类型","name":"stxdndistinct","type":"pg_ndistinct","zh_from":"doc"},{"description_zh":"函数依赖统计信息，序列化为pg_dependencies类型","name":"stxddependencies","type":"pg_dependencies","zh_from":"doc"},{"description_zh":"MCV（高频值）列表统计信息，序列化为pg_mcv_list类型","name":"stxdmcv","type":"pg_mcv_list","zh_from":"doc"},{"description_zh":"每个表达式的统计信息，序列化为pg_statistic类型的数组。","name":"stxdexpr","type":"pg_statistic[]","zh_from":"doc"}],"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连接后），仅暴露当前用户拥有的表的信息。","zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["12","13","14","15","16","17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}