{"Entry":{"collection":"catalog","key":"pg_statistic_ext","name":"pg_statistic_ext","aliases":[],"metadata":{"changed_in":["12","13","14","17"],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"9.6","order":false,"removed":[],"status":"added","to":"10","types":[]},{"added":[],"attributes":[{"attribute":"hidden","from":true,"name":"oid","to":false}],"description_changed":true,"descriptions":[{"from":"An array containing codes for the enabled statistics kinds; valid values are: d for n-distinct statistics, f for functional dependency statistics","name":"stxkind","to":"An array containing codes for the enabled statistics kinds; valid values are: d for n-distinct statistics, f for functional dependency statistics, and m for most common values (MCV) list statistics"}],"from":"11","listing":[],"order":false,"removed":["stxndistinct","stxdependencies"],"status":"changed","to":"12","types":[],"unlisted":[]},{"added":["stxstattarget"],"attributes":[],"description_changed":false,"descriptions":[],"from":"12","listing":["oid"],"order":false,"removed":[],"status":"changed","to":"13","types":[],"unlisted":[]},{"added":["stxexprs"],"attributes":[],"description_changed":false,"descriptions":[{"from":"An array containing codes for the enabled statistics kinds; valid values are: d for n-distinct statistics, f for functional dependency statistics, and m for most common values (MCV) list statistics","name":"stxkind","to":"An array containing codes for the enabled statistics kinds; valid values are: d for n-distinct statistics, f for functional dependency statistics, m for most common values (MCV) list statistics, and e for expression statistics"}],"from":"13","listing":[],"order":false,"removed":[],"status":"changed","to":"14","types":[],"unlisted":[]},{"added":[],"attributes":[{"attribute":"not_null","from":true,"name":"stxstattarget","to":false}],"description_changed":false,"descriptions":[{"from":"stxstattarget controls the level of detail of statistics accumulated for this statistics object by ANALYZE. A zero value indicates that no statistics should be collected. A negative value says to use the maximum of the statistics targets of the referenced columns, if set, or the system default statistics target. Positive values of stxstattarget determine the target number of “most common values” to collect.","name":"stxstattarget","to":"stxstattarget controls the level of detail of statistics accumulated for this statistics object by ANALYZE. A zero value indicates that no statistics should be collected. A null value says to use the maximum of the statistics targets of the referenced columns, if set, or the system default statistics target. Positive values of stxstattarget determine the target number of “most common values” to collect."}],"from":"16","listing":[],"order":true,"removed":[],"status":"changed","to":"17","types":[{"from":"int4","name":"stxstattarget","to":"int2"}],"unlisted":[]}],"column_count":9,"content_hash":"d1479334c458fb5ecf89151ac61cc34ac23d0f453d0428af63ad080b3d7ebc1d","first_version":"10","imported_at":"2026-09-30T00:40:56.174139+08:00","kind":"catalog","last_version":"20","name":"pg_statistic_ext","position":131,"present_in":["10","11","12","13","14","15","16","17","18","19","20"],"relation_oid":null,"relkind":"r","shared":false,"source_rev":"english-manuals:9e8e03149e385ecc56cdcbc1055e9e7283c1ad8432a3fffe125138725600212e","summary":"The catalog pg_statistic_ext holds definitions of extended planner statistics.","summary_zh":""}},"Definition":{"Collection":"catalog","Key":"pg_statistic_ext","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_statistic_ext","SourceRevision":"english-manuals:9e8e03149e385ecc56cdcbc1055e9e7283c1ad8432a3fffe125138725600212e","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Row identifier","description_zh":"","documented":true,"documented_name":"oid","hidden":false,"name":"oid","not_null":true,"references":"","type":"oid","type_modifier":-1,"type_oid":26},{"array_dimensions":0,"attnum":2,"description":"Table containing the columns described by this object","description_zh":"","documented":true,"documented_name":"stxrelid","hidden":false,"name":"stxrelid","not_null":true,"references":"pg_class.oid","type":"oid","type_modifier":-1,"type_oid":26},{"array_dimensions":0,"attnum":3,"description":"Name of the statistics object","description_zh":"","documented":true,"documented_name":"stxname","hidden":false,"name":"stxname","not_null":true,"references":"","type":"name","type_modifier":-1,"type_oid":19},{"array_dimensions":0,"attnum":4,"description":"The OID of the namespace that contains this statistics object","description_zh":"","documented":true,"documented_name":"stxnamespace","hidden":false,"name":"stxnamespace","not_null":true,"references":"pg_namespace.oid","type":"oid","type_modifier":-1,"type_oid":26},{"array_dimensions":0,"attnum":5,"description":"Owner of the statistics object","description_zh":"","documented":true,"documented_name":"stxowner","hidden":false,"name":"stxowner","not_null":true,"references":"pg_authid.oid","type":"oid","type_modifier":-1,"type_oid":26},{"array_dimensions":1,"attnum":6,"description":"An array of attribute numbers, indicating which table columns are covered by this statistics object; for example a value of 1 3 would mean that the first and the third table columns are covered","description_zh":"","documented":true,"documented_name":"stxkeys","hidden":false,"name":"stxkeys","not_null":true,"references":"pg_attribute.attnum","type":"int2vector","type_modifier":-1,"type_oid":22},{"array_dimensions":0,"attnum":7,"description":"stxstattarget controls the level of detail of statistics accumulated for this statistics object by ANALYZE. A zero value indicates that no statistics should be collected. A null value says to use the maximum of the statistics targets of the referenced columns, if set, or the system default statistics target. Positive values of stxstattarget determine the target number of “most common values” to collect.","description_zh":"","documented":true,"documented_name":"stxstattarget","hidden":false,"name":"stxstattarget","not_null":false,"references":"","type":"int2","type_modifier":-1,"type_oid":21},{"array_dimensions":1,"attnum":8,"description":"An array containing codes for the enabled statistics kinds; valid values are: d for n-distinct statistics, f for functional dependency statistics, m for most common values (MCV) list statistics, and e for expression statistics","description_zh":"","documented":true,"documented_name":"stxkind","hidden":false,"name":"stxkind","not_null":true,"references":"","type":"char[]","type_modifier":-1,"type_oid":1002},{"array_dimensions":0,"attnum":9,"description":"Expression trees (in nodeToString() representation) for statistics object attributes that are not simple column references. This is a list with one element per expression. Null if all statistics object attributes are simple references.","description_zh":"","documented":true,"documented_name":"stxexprs","hidden":false,"name":"stxexprs","not_null":false,"references":"","type":"pg_node_tree","type_modifier":-1,"type_oid":194}],"description":"The catalog pg_statistic_ext holds definitions of extended planner statistics. Each row in this catalog corresponds to a statistics object created with CREATE STATISTICS.","description_zh":"","doc":{"anchor":"id-1.10.4.54.4","file":"catalog-pg-statistic-ext.html","lang":"en","sha256":"797aaaee2ce146247b12ad130ac075964bbc104d77eeec7837d879bc1aed9331","slug":"18"},"kind":"catalog","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["oid","stxrelid","stxname","stxnamespace","stxowner","stxkeys","stxstattarget","stxkind","stxexprs"],"runtime_verified":false,"source":"english-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.10.4.54.4","file":"catalog-pg-statistic-ext.html","lang":"en","sha256":"797aaaee2ce146247b12ad130ac075964bbc104d77eeec7837d879bc1aed9331","slug":"18"}},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["oid","stxrelid","stxname","stxnamespace","stxowner","stxkeys","stxstattarget","stxkind","stxexprs"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_statistic_ext","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_statistic_ext","Summary":"目录pg_statistic_ext包含了扩展的规划器统计信息的定义。这个目录中的每一行对应于一个用CREATE STATISTICS创建的统计信息对象。","BodyHTML":"\u003cp\u003e目录pg_statistic_ext包含了扩展的规划器统计信息的定义。这个目录中的每一行对应于一个用CREATE STATISTICS创建的统计信息对象。\u003c/p\u003e","SourceRevision":"2026-09-27@419045e","ContentHash":"cff510629396b6deda3b7694cfbab8d563806be8d3488fe7ffaf34eb4ff55303","Payload":{"columns":[{"description_zh":"行标识符","name":"oid","type":"oid","zh_from":"doc"},{"description_zh":"包含这个对象所描述的列的表","name":"stxrelid","type":"oid","zh_from":"doc"},{"description_zh":"统计信息对象的名称","name":"stxname","type":"name","zh_from":"doc"},{"description_zh":"包含这个统计信息对象的名字空间的OID","name":"stxnamespace","type":"oid","zh_from":"doc"},{"description_zh":"统计信息对象的拥有者","name":"stxowner","type":"oid","zh_from":"doc"},{"description_zh":"一个属性编号的数组，表示哪些表列被这个统计信息对象覆盖。例如值1 3表示第一个和第三个表列被覆盖","name":"stxkeys","type":"int2vector","zh_from":"doc"},{"description_zh":"stxstattarget 控制 ANALYZE 为该统计信息对象收集统计信息时的细节级别。零值表示不应收集统计信息。空值表示使用被引用列的统计目标中的最大值（如果有设置），否则使用系统默认统计目标。正值 stxstattarget 决定要收集的“高频值”目标个数。","name":"stxstattarget","type":"smallint","zh_from":"doc"},{"description_zh":"包含启用的统计类型代码的数组，可用值有：d 表示非重复值统计信息，f 表示函数依赖统计信息，m 表示高频值（MCV）列表统计信息，e 表示表达式统计信息","name":"stxkind","type":"\"char\"[]","zh_from":"doc"},{"description_zh":"统计信息对象属性中那些不是简单列引用的表达式树，以 nodeToString() 表示。这是一个列表，每个表达式占一个元素。如果所有统计信息对象属性都是简单引用，则为空值。","name":"stxexprs","type":"pg_node_tree","zh_from":"doc"}],"description_zh":"目录pg_statistic_ext包含了扩展的规划器统计信息的定义。这个目录中的每一行对应于一个用CREATE STATISTICS创建的统计信息对象。","zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}