{"Entry":{"collection":"func","key":"pg-clear-extended-stats","name":"pg_clear_extended_stats","aliases":[],"metadata":{"changed_in":[],"changes":[{"descriptions_changed":false,"doc_overhaul":false,"from":"18","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"added","to":"19"}],"content_hash":"74533c9af7c115ec2d54b8299b773b17110aba3175b810e1ebecbaeabf0e2652","first_version":"19","group":"admin","group_label":"System Administration Functions","groups":["admin"],"imported_at":"2026-09-27T17:57:29.45251+08:00","last_version":"20","name":"pg_clear_extended_stats","name_key":"pg_clear_extended_stats","position":29017,"present_in":["19","20"],"signature":"pg_clear_extended_stats ( schemaname name, relname name, statistics_schemaname name, statistics_name name, inherited boolean ) → void","signature_count":1,"slug":"pg-clear-extended-stats","source_rev":"b7bd9cda","summary":"Clears data of an extended statistics object, as though the object was newly-created.","summary_zh":""}},"Definition":{"Collection":"func","Key":"pg-clear-extended-stats","SourceDatabase":"center","Version":"20","SourceTable":"func","SourceKey":"pg-clear-extended-stats","SourceRevision":"b7bd9cda","Facts":{"description":"Clears data of an extended statistics object, as though the object was newly-created. The required arguments are schemaname and relname to specify the schema and table name of the relation whose statistics are cleared, as well as statistics_schemaname and statistics_name to specify the schema and extended statistics name of the extended statistics object to clear.","description_html":"Clears data of an extended statistics object, as though the object was newly-created. The required arguments are \u003ccode class=\"literal\"\u003eschemaname\u003c/code\u003e and \u003ccode class=\"literal\"\u003erelname\u003c/code\u003e to specify the schema and table name of the relation whose statistics are cleared, as well as \u003ccode class=\"literal\"\u003estatistics_schemaname\u003c/code\u003e and \u003ccode class=\"literal\"\u003estatistics_name\u003c/code\u003e to specify the schema and extended statistics name of the extended statistics object to clear.","description_zh":"","description_zh_html":"","doc":{"anchor":"FUNCTIONS-ADMIN-STATSMOD","file":"functions-admin.html","slug":"devel"},"group":"admin","group_label":"System Administration Functions","lang":"en","layout":"table-new","pages":["functions-admin.html"],"prose_only":false,"signatures":[{"description":"Clears data of an extended statistics object, as though the object was newly-created. The required arguments are schemaname and relname to specify the schema and table name of the relation whose statistics are cleared, as well as statistics_schemaname and statistics_name to specify the schema and extended statistics name of the extended statistics object to clear.","description_html":"Clears data of an extended statistics object, as though the object was newly-created. The required arguments are \u003ccode class=\"literal\"\u003eschemaname\u003c/code\u003e and \u003ccode class=\"literal\"\u003erelname\u003c/code\u003e to specify the schema and table name of the relation whose statistics are cleared, as well as \u003ccode class=\"literal\"\u003estatistics_schemaname\u003c/code\u003e and \u003ccode class=\"literal\"\u003estatistics_name\u003c/code\u003e to specify the schema and extended statistics name of the extended statistics object to clear.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epg_clear_extended_stats\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003eschemaname\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003ename\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003erelname\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003ename\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003estatistics_schemaname\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003ename\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003estatistics_name\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003ename\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003einherited\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eboolean\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003evoid\u003c/code\u003e","returns":"void","text":"pg_clear_extended_stats ( schemaname name, relname name, statistics_schemaname name, statistics_name name, inherited boolean ) → void","zh_from":""}],"zh_from":""},"ManualEvidence":{"doc":{"anchor":"FUNCTIONS-ADMIN-STATSMOD","file":"functions-admin.html","slug":"devel"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"pg-clear-extended-stats","SourceDatabase":"pgweb","Version":"20","Locale":"zh-Hans","Title":"pg_clear_extended_stats","Summary":"清空扩展统计对象的数据，就像该对象是新建的一样。必需的参数包括schemaname和relname，用于指定要清空其统计信息的关系的模式和表名，以及statistics_schemaname和statistics_name，用于指定要清空的扩展统计对象的模式和扩展统计名称。","BodyHTML":"清空扩展统计对象的数据，就像该对象是新建的一样。必需的参数包括\u003ccode\u003eschemaname\u003c/code\u003e和\u003ccode\u003erelname\u003c/code\u003e，用于指定要清空其统计信息的关系的模式和表名，以及\u003ccode\u003estatistics_schemaname\u003c/code\u003e和\u003ccode\u003estatistics_name\u003c/code\u003e，用于指定要清空的扩展统计对象的模式和扩展统计名称。\u003cpre\u003epg_clear_extended_stats ( schemaname name, relname name, statistics_schemaname name, statistics_name name, inherited boolean ) → void\u003c/pre\u003e清空扩展统计对象的数据，就像该对象是新建的一样。必需的参数包括\u003ccode\u003eschemaname\u003c/code\u003e和\u003ccode\u003erelname\u003c/code\u003e，用于指定要清空其统计信息的关系的模式和表名，以及\u003ccode\u003estatistics_schemaname\u003c/code\u003e和\u003ccode\u003estatistics_name\u003c/code\u003e，用于指定要清空的扩展统计对象的模式和扩展统计名称。","SourceRevision":"ca936764","ContentHash":"7800605fd1fa4fd49761678418c39105dec62903d7a29a82d217e91d80103db9","Payload":{"description_zh":"清空扩展统计对象的数据，就像该对象是新建的一样。必需的参数包括schemaname和relname，用于指定要清空其统计信息的关系的模式和表名，以及statistics_schemaname和statistics_name，用于指定要清空的扩展统计对象的模式和扩展统计名称。","description_zh_html":"清空扩展统计对象的数据，就像该对象是新建的一样。必需的参数包括\u003ccode class=\"literal\"\u003eschemaname\u003c/code\u003e和\u003ccode class=\"literal\"\u003erelname\u003c/code\u003e，用于指定要清空其统计信息的关系的模式和表名，以及\u003ccode class=\"literal\"\u003estatistics_schemaname\u003c/code\u003e和\u003ccode class=\"literal\"\u003estatistics_name\u003c/code\u003e，用于指定要清空的扩展统计对象的模式和扩展统计名称。","signatures":[{"description_zh":"清空扩展统计对象的数据，就像该对象是新建的一样。必需的参数包括schemaname和relname，用于指定要清空其统计信息的关系的模式和表名，以及statistics_schemaname和statistics_name，用于指定要清空的扩展统计对象的模式和扩展统计名称。","description_zh_html":"清空扩展统计对象的数据，就像该对象是新建的一样。必需的参数包括\u003ccode class=\"literal\"\u003eschemaname\u003c/code\u003e和\u003ccode class=\"literal\"\u003erelname\u003c/code\u003e，用于指定要清空其统计信息的关系的模式和表名，以及\u003ccode class=\"literal\"\u003estatistics_schemaname\u003c/code\u003e和\u003ccode class=\"literal\"\u003estatistics_name\u003c/code\u003e，用于指定要清空的扩展统计对象的模式和扩展统计名称。","returns":"void","text":"pg_clear_extended_stats ( schemaname name, relname name, statistics_schemaname name, statistics_name name, inherited boolean ) → void","zh_from":"doc"}],"zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["19","20"],"Locales":["en","zh-Hans"],"Signatures":[{"Version":"20","Ordinal":0,"Hash":"565c2de6d6542f7194f757ce77b265a6a13910f074c62ef107c168d086cdfc1c","Text":"pg_clear_extended_stats ( schemaname name, relname name, statistics_schemaname name, statistics_name name, inherited boolean ) → void","Returns":"void","Payload":{"description":"Clears data of an extended statistics object, as though the object was newly-created. The required arguments are schemaname and relname to specify the schema and table name of the relation whose statistics are cleared, as well as statistics_schemaname and statistics_name to specify the schema and extended statistics name of the extended statistics object to clear.","description_html":"Clears data of an extended statistics object, as though the object was newly-created. The required arguments are \u003ccode class=\"literal\"\u003eschemaname\u003c/code\u003e and \u003ccode class=\"literal\"\u003erelname\u003c/code\u003e to specify the schema and table name of the relation whose statistics are cleared, as well as \u003ccode class=\"literal\"\u003estatistics_schemaname\u003c/code\u003e and \u003ccode class=\"literal\"\u003estatistics_name\u003c/code\u003e to specify the schema and extended statistics name of the extended statistics object to clear.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epg_clear_extended_stats\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003eschemaname\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003ename\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003erelname\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003ename\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003estatistics_schemaname\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003ename\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003estatistics_name\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003ename\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003einherited\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eboolean\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003evoid\u003c/code\u003e","returns":"void","text":"pg_clear_extended_stats ( schemaname name, relname name, statistics_schemaname name, statistics_name name, inherited boolean ) → void","zh_from":""}}],"Spellings":null,"SQLState":null,"Evidence":null}