{"kind": "psql", "major": "18", "item": {"slug": "cmd-64-58", "name": "\\dX", "name_zh": "", "category": "\u63cf\u8ff0\u6570\u636e\u5e93\u5bf9\u8c61", "summary": "\u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 x \uff0c\u7ed3\u679c\u4f1a\u4ee5\u6269\u5c55\u6a21\u5f0f\u663e\u793a\u3002", "aliases": ["\\dX", "\\dX+", "\\dXx", "\\dXx+"], "content_hash": "121038b7cd1244f597abeb37a1598fe4474ae3b91517d356527f061a714e19eb", "versions": {"14": {"lang": "zh", "facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 14.25"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\dX"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-64-58/?v=14", "text": "\\dX"}, "modifiers": "\u6b64\u8bed\u6cd5\u7b7e\u540d\u672a\u5217\u51fa"}], "title": "\u672c\u7248\u624b\u518c\u4e2d\u7684\u5199\u6cd5", "columns": [{"key": "command", "label": "\u547d\u4ee4"}, {"key": "modifiers", "label": "\u624b\u518c\u4e2d\u7684\u540e\u7f00\u4fee\u9970\u7b26"}]}], "command": "\\dX", "related": [{"url": "/wiki/tool/psql/?v=14", "label": "psql \u547d\u4ee4\u884c\u9009\u9879\u53ca\u5b8c\u6574\u624b\u518c"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v14.25/postgresql-14.25.tar.bz2", "label": "14.25", "major": "14", "channel": "stable", "manifest": {"major": "14", "release": "14.25", "source_url": "https://ftp.postgresql.org/pub/source/v14.25/postgresql-14.25.tar.bz2", "source_sha256": "09af980eb3a5d0a8ad7a34b95031b1988bbcd430c87700a62d6234c0ed97ae4c"}, "revision": "3458c6c18c8d4de5bbf0e6a5e72e5d2a815a2604b1cef6d1ec84491c75e57d2f", "evidence_kind": "English manual and source declarations", "source_sha256": "09af980eb3a5d0a8ad7a34b95031b1988bbcd430c87700a62d6234c0ed97ae4c"}, "sources": [{"url": "/docs/14/app-psql.html#APP-PSQL-META-COMMANDS", "file": "app-psql.html", "label": "14.25 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMANDS", "sha256": "ea99b69e21da51aab6382e82434cfb27bfb24f452abe7bbb4b1fb29319f081b0"}], "zh_from": "same-version-manual", "facts_zh": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 14.25"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\dX"}], "sections": [], "center_zh": {"locale": "zh-Hans", "payload": {"description_zh": "\u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002", "description_zh_html": "<dd><p>\n        \u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 <em class=\"replaceable\"><code>pattern</code></em>\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002        </p><p>\n        \u6bcf\u79cd\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u7684\u72b6\u6001\u663e\u793a\u5728\u4ee5\u5176\u7edf\u8ba1\u7c7b\u578b\u547d\u540d\u7684\u5217\u4e2d\uff08\u4f8b\u5982 Ndistinct\uff09\u3002<code class=\"literal\">defined</code> \u8868\u793a\u5728\u521b\u5efa\u7edf\u8ba1\u4fe1\u606f\u65f6\u8bf7\u6c42\u4e86\u8be5\u4fe1\u606f\uff0cNULL \u8868\u793a\u672a\u8bf7\u6c42\u3002\u5982\u679c\u60f3\u77e5\u9053\u662f\u5426\u5df2\u7ecf\u8fd0\u884c\u4e86 <a class=\"link\" href=\"/docs/14/sql-analyze.html\" title=\"ANALYZE\"><code class=\"command\">ANALYZE</code></a>\uff0c\u4ee5\u53ca\u8fd9\u4e9b\u7edf\u8ba1\u4fe1\u606f\u662f\u5426\u5df2\u7ecf\u5bf9\u89c4\u5212\u5668\u53ef\u7528\uff0c\u53ef\u4ee5\u67e5\u770b <code class=\"structname\">pg_stats_ext</code>\u3002\n        </p></dd>"}, "summary": "\u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002", "body_html": "<dd><p>\n        \u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 <em class=\"replaceable\"><code>pattern</code></em>\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002        </p><p>\n        \u6bcf\u79cd\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u7684\u72b6\u6001\u663e\u793a\u5728\u4ee5\u5176\u7edf\u8ba1\u7c7b\u578b\u547d\u540d\u7684\u5217\u4e2d\uff08\u4f8b\u5982 Ndistinct\uff09\u3002<code class=\"literal\">defined</code> \u8868\u793a\u5728\u521b\u5efa\u7edf\u8ba1\u4fe1\u606f\u65f6\u8bf7\u6c42\u4e86\u8be5\u4fe1\u606f\uff0cNULL \u8868\u793a\u672a\u8bf7\u6c42\u3002\u5982\u679c\u60f3\u77e5\u9053\u662f\u5426\u5df2\u7ecf\u8fd0\u884c\u4e86 <a class=\"link\" href=\"/docs/14/sql-analyze.html\" title=\"ANALYZE\"><code class=\"command\">ANALYZE</code></a>\uff0c\u4ee5\u53ca\u8fd9\u4e9b\u7edf\u8ba1\u4fe1\u606f\u662f\u5426\u5df2\u7ecf\u5bf9\u89c4\u5212\u5668\u53ef\u7528\uff0c\u53ef\u4ee5\u67e5\u770b <code class=\"structname\">pg_stats_ext</code>\u3002\n        </p></dd>", "body_sha256": "644a49d859b03e059091f00ce7f23d07e9a21779d0ac0aadee87c0f438e00dd9", "content_hash": "79da33aabda49b7aa4b18a682c70aa4ffed1b70be9cc47ed99c9d4b460f026dd", "source_revision": "pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552", "definition_version": "14", "documentation_release": "14.25"}, "modifiers": [], "signature": "\\dX [ pattern ]", "spellings": ["\\dX"], "tables_zh": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-64-58/?v=14", "text": "\\dX"}, "modifiers": "\u6b64\u8bed\u6cd5\u7b7e\u540d\u672a\u5217\u51fa"}], "title": "\u672c\u7248\u624b\u518c\u4e2d\u7684\u5199\u6cd5", "columns": [{"key": "command", "label": "\u547d\u4ee4"}, {"key": "modifiers", "label": "\u624b\u518c\u4e2d\u7684\u540e\u7f00\u4fee\u9970\u7b26"}]}], "related_zh": [{"url": "/wiki/tool/psql/?v=14", "label": "psql \u547d\u4ee4\u884c\u9009\u9879\u53ca\u5b8c\u6574\u624b\u518c"}], "description": ["\u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002"], "manual_html": "<dd><p>\n        \u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 <em class=\"replaceable\"><code>pattern</code></em>\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002        </p><p>\n        \u6bcf\u79cd\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u7684\u72b6\u6001\u663e\u793a\u5728\u4ee5\u5176\u7edf\u8ba1\u7c7b\u578b\u547d\u540d\u7684\u5217\u4e2d\uff08\u4f8b\u5982 Ndistinct\uff09\u3002<code class=\"literal\">defined</code> \u8868\u793a\u5728\u521b\u5efa\u7edf\u8ba1\u4fe1\u606f\u65f6\u8bf7\u6c42\u4e86\u8be5\u4fe1\u606f\uff0cNULL \u8868\u793a\u672a\u8bf7\u6c42\u3002\u5982\u679c\u60f3\u77e5\u9053\u662f\u5426\u5df2\u7ecf\u8fd0\u884c\u4e86 <a class=\"link\" href=\"/docs/14/sql-analyze.html\" title=\"ANALYZE\"><code class=\"command\">ANALYZE</code></a>\uff0c\u4ee5\u53ca\u8fd9\u4e9b\u7edf\u8ba1\u4fe1\u606f\u662f\u5426\u5df2\u7ecf\u5bf9\u89c4\u5212\u5668\u53ef\u7528\uff0c\u53ef\u4ee5\u67e5\u770b <code class=\"structname\">pg_stats_ext</code>\u3002\n        </p></dd>", "manual_path": "app-psql.html#APP-PSQL-META-COMMANDS", "sections_zh": [], "localization": {"status": "same-version-reviewed-manual", "language": "zh", "source_language": "en", "source_revision": "pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552", "documentation_release": "14.25"}, "description_zh": "\u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002", "comparison_data": {"modifiers": [], "signature": "\\dX [ pattern ]", "spellings": ["\\dX"], "definition": "Lists extended statistics. If pattern is specified, only those extended statistics whose names match the pattern are listed. The status of each kind of extended statistics is shown in a column named after its statistic kind (e.g. Ndistinct). defined means that it was requested when creating the statistics, and NULL means it wasn't requested. You can use pg_stats_ext if you'd like to know whether ANALYZE was run and statistics are available to the planner."}, "comparison_hash": "e8e40be3868ba8bbe9663cc29befa206dff42274e00e6a4e658818ef2b2380d4", "manual_language": "zh", "description_zh_html": "<dd><p>\n        \u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 <em class=\"replaceable\"><code>pattern</code></em>\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002        </p><p>\n        \u6bcf\u79cd\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u7684\u72b6\u6001\u663e\u793a\u5728\u4ee5\u5176\u7edf\u8ba1\u7c7b\u578b\u547d\u540d\u7684\u5217\u4e2d\uff08\u4f8b\u5982 Ndistinct\uff09\u3002<code class=\"literal\">defined</code> \u8868\u793a\u5728\u521b\u5efa\u7edf\u8ba1\u4fe1\u606f\u65f6\u8bf7\u6c42\u4e86\u8be5\u4fe1\u606f\uff0cNULL \u8868\u793a\u672a\u8bf7\u6c42\u3002\u5982\u679c\u60f3\u77e5\u9053\u662f\u5426\u5df2\u7ecf\u8fd0\u884c\u4e86 <a class=\"link\" href=\"/docs/14/sql-analyze.html\" title=\"ANALYZE\"><code class=\"command\">ANALYZE</code></a>\uff0c\u4ee5\u53ca\u8fd9\u4e9b\u7edf\u8ba1\u4fe1\u606f\u662f\u5426\u5df2\u7ecf\u5bf9\u89c4\u5212\u5668\u53ef\u7528\uff0c\u53ef\u4ee5\u67e5\u770b <code class=\"structname\">pg_stats_ext</code>\u3002\n        </p></dd>", "documentation_revision": {"inputs": [{"file": "app-psql.html", "kind": "same-version-reviewed-manual", "locale": "en", "sha256": "ea99b69e21da51aab6382e82434cfb27bfb24f452abe7bbb4b1fb29319f081b0", "version": "14.25"}, {"file": "app-psql.html", "kind": "same-version-reviewed-manual", "locale": "zh-Hans", "sha256": "f2eed17e1379e0b59f4bf5a92289a41d8ec44b349f2b069962f186547dc717ef", "version": "14.25"}], "release": "14.25", "source_revision": "pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552", "runtime_remeasured": false}}, "15": {"lang": "zh", "facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 15.20"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\dX"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-64-58/?v=15", "text": "\\dX"}, "modifiers": "\u6b64\u8bed\u6cd5\u7b7e\u540d\u672a\u5217\u51fa"}], "title": "\u672c\u7248\u624b\u518c\u4e2d\u7684\u5199\u6cd5", "columns": [{"key": "command", "label": "\u547d\u4ee4"}, {"key": "modifiers", "label": "\u624b\u518c\u4e2d\u7684\u540e\u7f00\u4fee\u9970\u7b26"}]}], "command": "\\dX", "related": [{"url": "/wiki/tool/psql/?v=15", "label": "psql \u547d\u4ee4\u884c\u9009\u9879\u53ca\u5b8c\u6574\u624b\u518c"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v15.20/postgresql-15.20.tar.bz2", "label": "15.20", "major": "15", "channel": "stable", "manifest": {"major": "15", "release": "15.20", "source_url": "https://ftp.postgresql.org/pub/source/v15.20/postgresql-15.20.tar.bz2", "source_sha256": "30e65cbbb771a39b553ed2df7e65622e65647aed55dbc19bd0fe853ff0a08442"}, "revision": "6d870676353ceb5b021cc09084428ae294e90804236e38ffe556364784ee5fe5", "evidence_kind": "English manual and source declarations", "source_sha256": "30e65cbbb771a39b553ed2df7e65622e65647aed55dbc19bd0fe853ff0a08442"}, "sources": [{"url": "/docs/15/app-psql.html#APP-PSQL-META-COMMANDS", "file": "app-psql.html", "label": "15.20 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMANDS", "sha256": "b2a45145fd66cf7a28d7197594e8437e3b0310e88cdedf9d789c0fceefeebc27"}], "zh_from": "same-version-manual", "facts_zh": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 15.20"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\dX"}], "sections": [], "center_zh": {"locale": "zh-Hans", "payload": {"description_zh": "\u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002", "description_zh_html": "<dd><p>\n        \u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 <em class=\"replaceable\"><code>pattern</code></em>\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002        </p><p>\n        \u6bcf\u79cd\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u7684\u72b6\u6001\u663e\u793a\u5728\u4ee5\u5176\u7edf\u8ba1\u7c7b\u578b\u547d\u540d\u7684\u5217\u4e2d\uff08\u4f8b\u5982 Ndistinct\uff09\u3002<code class=\"literal\">defined</code> \u8868\u793a\u5728\u521b\u5efa\u7edf\u8ba1\u4fe1\u606f\u65f6\u8bf7\u6c42\u4e86\u8be5\u4fe1\u606f\uff0cNULL \u8868\u793a\u672a\u8bf7\u6c42\u3002\u5982\u679c\u60f3\u77e5\u9053\u662f\u5426\u5df2\u7ecf\u8fd0\u884c\u4e86 <a class=\"link\" href=\"/docs/15/sql-analyze.html\" title=\"ANALYZE\"><code class=\"command\">ANALYZE</code></a>\uff0c\u4ee5\u53ca\u8fd9\u4e9b\u7edf\u8ba1\u4fe1\u606f\u662f\u5426\u5df2\u7ecf\u5bf9\u89c4\u5212\u5668\u53ef\u7528\uff0c\u53ef\u4ee5\u67e5\u770b <code class=\"structname\">pg_stats_ext</code>\u3002\n        </p></dd>"}, "summary": "\u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002", "body_html": "<dd><p>\n        \u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 <em class=\"replaceable\"><code>pattern</code></em>\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002        </p><p>\n        \u6bcf\u79cd\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u7684\u72b6\u6001\u663e\u793a\u5728\u4ee5\u5176\u7edf\u8ba1\u7c7b\u578b\u547d\u540d\u7684\u5217\u4e2d\uff08\u4f8b\u5982 Ndistinct\uff09\u3002<code class=\"literal\">defined</code> \u8868\u793a\u5728\u521b\u5efa\u7edf\u8ba1\u4fe1\u606f\u65f6\u8bf7\u6c42\u4e86\u8be5\u4fe1\u606f\uff0cNULL \u8868\u793a\u672a\u8bf7\u6c42\u3002\u5982\u679c\u60f3\u77e5\u9053\u662f\u5426\u5df2\u7ecf\u8fd0\u884c\u4e86 <a class=\"link\" href=\"/docs/15/sql-analyze.html\" title=\"ANALYZE\"><code class=\"command\">ANALYZE</code></a>\uff0c\u4ee5\u53ca\u8fd9\u4e9b\u7edf\u8ba1\u4fe1\u606f\u662f\u5426\u5df2\u7ecf\u5bf9\u89c4\u5212\u5668\u53ef\u7528\uff0c\u53ef\u4ee5\u67e5\u770b <code class=\"structname\">pg_stats_ext</code>\u3002\n        </p></dd>", "body_sha256": "c47eba1fae95cc3a572d5a5f8ec69672d3e38c50cf6e47bf96bafb7d6ab329ee", "content_hash": "8051e78b3a0d0f500e4d691f2a3e215d08a8beac6e5b11084af3717074465e24", "source_revision": "pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552", "definition_version": "15", "documentation_release": "15.20"}, "modifiers": [], "signature": "\\dX [ pattern ]", "spellings": ["\\dX"], "tables_zh": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-64-58/?v=15", "text": "\\dX"}, "modifiers": "\u6b64\u8bed\u6cd5\u7b7e\u540d\u672a\u5217\u51fa"}], "title": "\u672c\u7248\u624b\u518c\u4e2d\u7684\u5199\u6cd5", "columns": [{"key": "command", "label": "\u547d\u4ee4"}, {"key": "modifiers", "label": "\u624b\u518c\u4e2d\u7684\u540e\u7f00\u4fee\u9970\u7b26"}]}], "related_zh": [{"url": "/wiki/tool/psql/?v=15", "label": "psql \u547d\u4ee4\u884c\u9009\u9879\u53ca\u5b8c\u6574\u624b\u518c"}], "description": ["\u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002"], "manual_html": "<dd><p>\n        \u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 <em class=\"replaceable\"><code>pattern</code></em>\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002        </p><p>\n        \u6bcf\u79cd\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u7684\u72b6\u6001\u663e\u793a\u5728\u4ee5\u5176\u7edf\u8ba1\u7c7b\u578b\u547d\u540d\u7684\u5217\u4e2d\uff08\u4f8b\u5982 Ndistinct\uff09\u3002<code class=\"literal\">defined</code> \u8868\u793a\u5728\u521b\u5efa\u7edf\u8ba1\u4fe1\u606f\u65f6\u8bf7\u6c42\u4e86\u8be5\u4fe1\u606f\uff0cNULL \u8868\u793a\u672a\u8bf7\u6c42\u3002\u5982\u679c\u60f3\u77e5\u9053\u662f\u5426\u5df2\u7ecf\u8fd0\u884c\u4e86 <a class=\"link\" href=\"/docs/15/sql-analyze.html\" title=\"ANALYZE\"><code class=\"command\">ANALYZE</code></a>\uff0c\u4ee5\u53ca\u8fd9\u4e9b\u7edf\u8ba1\u4fe1\u606f\u662f\u5426\u5df2\u7ecf\u5bf9\u89c4\u5212\u5668\u53ef\u7528\uff0c\u53ef\u4ee5\u67e5\u770b <code class=\"structname\">pg_stats_ext</code>\u3002\n        </p></dd>", "manual_path": "app-psql.html#APP-PSQL-META-COMMANDS", "sections_zh": [], "localization": {"status": "same-version-reviewed-manual", "language": "zh", "source_language": "en", "source_revision": "pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552", "documentation_release": "15.20"}, "description_zh": "\u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002", "comparison_data": {"modifiers": [], "signature": "\\dX [ pattern ]", "spellings": ["\\dX"], "definition": "Lists extended statistics. If pattern is specified, only those extended statistics whose names match the pattern are listed. The status of each kind of extended statistics is shown in a column named after its statistic kind (e.g. Ndistinct). defined means that it was requested when creating the statistics, and NULL means it wasn't requested. You can use pg_stats_ext if you'd like to know whether ANALYZE was run and statistics are available to the planner."}, "comparison_hash": "e8e40be3868ba8bbe9663cc29befa206dff42274e00e6a4e658818ef2b2380d4", "manual_language": "zh", "description_zh_html": "<dd><p>\n        \u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 <em class=\"replaceable\"><code>pattern</code></em>\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002        </p><p>\n        \u6bcf\u79cd\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u7684\u72b6\u6001\u663e\u793a\u5728\u4ee5\u5176\u7edf\u8ba1\u7c7b\u578b\u547d\u540d\u7684\u5217\u4e2d\uff08\u4f8b\u5982 Ndistinct\uff09\u3002<code class=\"literal\">defined</code> \u8868\u793a\u5728\u521b\u5efa\u7edf\u8ba1\u4fe1\u606f\u65f6\u8bf7\u6c42\u4e86\u8be5\u4fe1\u606f\uff0cNULL \u8868\u793a\u672a\u8bf7\u6c42\u3002\u5982\u679c\u60f3\u77e5\u9053\u662f\u5426\u5df2\u7ecf\u8fd0\u884c\u4e86 <a class=\"link\" href=\"/docs/15/sql-analyze.html\" title=\"ANALYZE\"><code class=\"command\">ANALYZE</code></a>\uff0c\u4ee5\u53ca\u8fd9\u4e9b\u7edf\u8ba1\u4fe1\u606f\u662f\u5426\u5df2\u7ecf\u5bf9\u89c4\u5212\u5668\u53ef\u7528\uff0c\u53ef\u4ee5\u67e5\u770b <code class=\"structname\">pg_stats_ext</code>\u3002\n        </p></dd>", "documentation_revision": {"inputs": [{"file": "app-psql.html", "kind": "same-version-reviewed-manual", "locale": "en", "sha256": "b2a45145fd66cf7a28d7197594e8437e3b0310e88cdedf9d789c0fceefeebc27", "version": "15.20"}, {"file": "app-psql.html", "kind": "same-version-reviewed-manual", "locale": "zh-Hans", "sha256": "666ec9d596198e5b09316660b8bc7ce5cdbfbdb13053df6050aeea8838b8a855", "version": "15.20"}], "release": "15.20", "source_revision": "pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552", "runtime_remeasured": false}}, "16": {"lang": "zh", "facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 16.16"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\dX"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-64-58/?v=16", "text": "\\dX"}, "modifiers": "\u6b64\u8bed\u6cd5\u7b7e\u540d\u672a\u5217\u51fa"}], "title": "\u672c\u7248\u624b\u518c\u4e2d\u7684\u5199\u6cd5", "columns": [{"key": "command", "label": "\u547d\u4ee4"}, {"key": "modifiers", "label": "\u624b\u518c\u4e2d\u7684\u540e\u7f00\u4fee\u9970\u7b26"}]}], "command": "\\dX", "related": [{"url": "/wiki/tool/psql/?v=16", "label": "psql \u547d\u4ee4\u884c\u9009\u9879\u53ca\u5b8c\u6574\u624b\u518c"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v16.16/postgresql-16.16.tar.bz2", "label": "16.16", "major": "16", "channel": "stable", "manifest": {"major": "16", "release": "16.16", "source_url": "https://ftp.postgresql.org/pub/source/v16.16/postgresql-16.16.tar.bz2", "source_sha256": "9d5cd8633043b75740d5d59749c6b7365e6aeb53c47098b1a5e80bb18f87881a"}, "revision": "871ba8026d5a12aa5884ac4e6e77369dacd4b2bdbd835b2305f7dbae4ee7b50d", "evidence_kind": "English manual and source declarations", "source_sha256": "9d5cd8633043b75740d5d59749c6b7365e6aeb53c47098b1a5e80bb18f87881a"}, "sources": [{"url": "/docs/16/app-psql.html#APP-PSQL-META-COMMAND-DX-UC", "file": "app-psql.html", "label": "16.16 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-DX-UC", "sha256": "6161d51dc66d54c8fd300944fed2bbae80efe4a532023b2e7771df5d94732330"}], "zh_from": "same-version-manual", "facts_zh": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 16.16"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\dX"}], "sections": [], "center_zh": {"locale": "zh-Hans", "payload": {"description_zh": "\u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002", "description_zh_html": "<dd><p>\n        \u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 <em class=\"replaceable\"><code>pattern</code></em>\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002        </p><p>\n        \u6bcf\u79cd\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u7684\u72b6\u6001\u663e\u793a\u5728\u4ee5\u5176\u7edf\u8ba1\u7c7b\u578b\u547d\u540d\u7684\u5217\u4e2d\uff08\u4f8b\u5982 Ndistinct\uff09\u3002<code class=\"literal\">defined</code> \u8868\u793a\u5728\u521b\u5efa\u7edf\u8ba1\u4fe1\u606f\u65f6\u8bf7\u6c42\u4e86\u8be5\u4fe1\u606f\uff0cNULL \u8868\u793a\u672a\u8bf7\u6c42\u3002\u5982\u679c\u60f3\u77e5\u9053\u662f\u5426\u5df2\u7ecf\u8fd0\u884c\u4e86 <a class=\"link\" href=\"/docs/16/sql-analyze.html\" title=\"ANALYZE\"><code class=\"command\">ANALYZE</code></a>\uff0c\u4ee5\u53ca\u8fd9\u4e9b\u7edf\u8ba1\u4fe1\u606f\u662f\u5426\u5df2\u7ecf\u5bf9\u89c4\u5212\u5668\u53ef\u7528\uff0c\u53ef\u4ee5\u67e5\u770b <code class=\"structname\">pg_stats_ext</code>\u3002\n        </p></dd>"}, "summary": "\u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002", "body_html": "<dd><p>\n        \u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 <em class=\"replaceable\"><code>pattern</code></em>\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002        </p><p>\n        \u6bcf\u79cd\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u7684\u72b6\u6001\u663e\u793a\u5728\u4ee5\u5176\u7edf\u8ba1\u7c7b\u578b\u547d\u540d\u7684\u5217\u4e2d\uff08\u4f8b\u5982 Ndistinct\uff09\u3002<code class=\"literal\">defined</code> \u8868\u793a\u5728\u521b\u5efa\u7edf\u8ba1\u4fe1\u606f\u65f6\u8bf7\u6c42\u4e86\u8be5\u4fe1\u606f\uff0cNULL \u8868\u793a\u672a\u8bf7\u6c42\u3002\u5982\u679c\u60f3\u77e5\u9053\u662f\u5426\u5df2\u7ecf\u8fd0\u884c\u4e86 <a class=\"link\" href=\"/docs/16/sql-analyze.html\" title=\"ANALYZE\"><code class=\"command\">ANALYZE</code></a>\uff0c\u4ee5\u53ca\u8fd9\u4e9b\u7edf\u8ba1\u4fe1\u606f\u662f\u5426\u5df2\u7ecf\u5bf9\u89c4\u5212\u5668\u53ef\u7528\uff0c\u53ef\u4ee5\u67e5\u770b <code class=\"structname\">pg_stats_ext</code>\u3002\n        </p></dd>", "body_sha256": "3266900fdca2639e2314bfd46c831087fe041a6bd9afc0da56669fbe14574b78", "content_hash": "3ac416c6add97891d0eee8caf0c723827a9bff468a38eb15baf405e07fbc5574", "source_revision": "pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552", "definition_version": "16", "documentation_release": "16.16"}, "modifiers": [], "signature": "\\dX [ pattern ]", "spellings": ["\\dX"], "tables_zh": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-64-58/?v=16", "text": "\\dX"}, "modifiers": "\u6b64\u8bed\u6cd5\u7b7e\u540d\u672a\u5217\u51fa"}], "title": "\u672c\u7248\u624b\u518c\u4e2d\u7684\u5199\u6cd5", "columns": [{"key": "command", "label": "\u547d\u4ee4"}, {"key": "modifiers", "label": "\u624b\u518c\u4e2d\u7684\u540e\u7f00\u4fee\u9970\u7b26"}]}], "related_zh": [{"url": "/wiki/tool/psql/?v=16", "label": "psql \u547d\u4ee4\u884c\u9009\u9879\u53ca\u5b8c\u6574\u624b\u518c"}], "description": ["\u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002"], "manual_html": "<dd><p>\n        \u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 <em class=\"replaceable\"><code>pattern</code></em>\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002        </p><p>\n        \u6bcf\u79cd\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u7684\u72b6\u6001\u663e\u793a\u5728\u4ee5\u5176\u7edf\u8ba1\u7c7b\u578b\u547d\u540d\u7684\u5217\u4e2d\uff08\u4f8b\u5982 Ndistinct\uff09\u3002<code class=\"literal\">defined</code> \u8868\u793a\u5728\u521b\u5efa\u7edf\u8ba1\u4fe1\u606f\u65f6\u8bf7\u6c42\u4e86\u8be5\u4fe1\u606f\uff0cNULL \u8868\u793a\u672a\u8bf7\u6c42\u3002\u5982\u679c\u60f3\u77e5\u9053\u662f\u5426\u5df2\u7ecf\u8fd0\u884c\u4e86 <a class=\"link\" href=\"/docs/16/sql-analyze.html\" title=\"ANALYZE\"><code class=\"command\">ANALYZE</code></a>\uff0c\u4ee5\u53ca\u8fd9\u4e9b\u7edf\u8ba1\u4fe1\u606f\u662f\u5426\u5df2\u7ecf\u5bf9\u89c4\u5212\u5668\u53ef\u7528\uff0c\u53ef\u4ee5\u67e5\u770b <code class=\"structname\">pg_stats_ext</code>\u3002\n        </p></dd>", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-DX-UC", "sections_zh": [], "localization": {"status": "same-version-reviewed-manual", "language": "zh", "source_language": "en", "source_revision": "pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552", "documentation_release": "16.16"}, "description_zh": "\u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002", "comparison_data": {"modifiers": [], "signature": "\\dX [ pattern ]", "spellings": ["\\dX"], "definition": "Lists extended statistics. If pattern is specified, only those extended statistics whose names match the pattern are listed. The status of each kind of extended statistics is shown in a column named after its statistic kind (e.g. Ndistinct). defined means that it was requested when creating the statistics, and NULL means it wasn't requested. You can use pg_stats_ext if you'd like to know whether ANALYZE was run and statistics are available to the planner."}, "comparison_hash": "e8e40be3868ba8bbe9663cc29befa206dff42274e00e6a4e658818ef2b2380d4", "manual_language": "zh", "description_zh_html": "<dd><p>\n        \u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 <em class=\"replaceable\"><code>pattern</code></em>\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002        </p><p>\n        \u6bcf\u79cd\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u7684\u72b6\u6001\u663e\u793a\u5728\u4ee5\u5176\u7edf\u8ba1\u7c7b\u578b\u547d\u540d\u7684\u5217\u4e2d\uff08\u4f8b\u5982 Ndistinct\uff09\u3002<code class=\"literal\">defined</code> \u8868\u793a\u5728\u521b\u5efa\u7edf\u8ba1\u4fe1\u606f\u65f6\u8bf7\u6c42\u4e86\u8be5\u4fe1\u606f\uff0cNULL \u8868\u793a\u672a\u8bf7\u6c42\u3002\u5982\u679c\u60f3\u77e5\u9053\u662f\u5426\u5df2\u7ecf\u8fd0\u884c\u4e86 <a class=\"link\" href=\"/docs/16/sql-analyze.html\" title=\"ANALYZE\"><code class=\"command\">ANALYZE</code></a>\uff0c\u4ee5\u53ca\u8fd9\u4e9b\u7edf\u8ba1\u4fe1\u606f\u662f\u5426\u5df2\u7ecf\u5bf9\u89c4\u5212\u5668\u53ef\u7528\uff0c\u53ef\u4ee5\u67e5\u770b <code class=\"structname\">pg_stats_ext</code>\u3002\n        </p></dd>", "documentation_revision": {"inputs": [{"file": "app-psql.html", "kind": "same-version-reviewed-manual", "locale": "en", "sha256": "6161d51dc66d54c8fd300944fed2bbae80efe4a532023b2e7771df5d94732330", "version": "16.16"}, {"file": "app-psql.html", "kind": "same-version-reviewed-manual", "locale": "zh-Hans", "sha256": "c0d23bdcbad8a5daf5f0b3f68e3cda09f59d69ebf5476444ecd369309fbd52c6", "version": "16.16"}], "release": "16.16", "source_revision": "pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552", "runtime_remeasured": false}}, "17": {"lang": "zh", "facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 17.12"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\dX"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-64-58/?v=17", "text": "\\dX"}, "modifiers": "\u6b64\u8bed\u6cd5\u7b7e\u540d\u672a\u5217\u51fa"}], "title": "\u672c\u7248\u624b\u518c\u4e2d\u7684\u5199\u6cd5", "columns": [{"key": "command", "label": "\u547d\u4ee4"}, {"key": "modifiers", "label": "\u624b\u518c\u4e2d\u7684\u540e\u7f00\u4fee\u9970\u7b26"}]}], "command": "\\dX", "related": [{"url": "/wiki/tool/psql/?v=17", "label": "psql \u547d\u4ee4\u884c\u9009\u9879\u53ca\u5b8c\u6574\u624b\u518c"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v17.12/postgresql-17.12.tar.bz2", "label": "17.12", "major": "17", "channel": "stable", "manifest": {"major": "17", "release": "17.12", "source_url": "https://ftp.postgresql.org/pub/source/v17.12/postgresql-17.12.tar.bz2", "source_sha256": "9cf136a703d8ee2f83465c43be4e9e8e7930c82b0bfba13be7e2537be769ac55"}, "revision": "cdf1f58367ae5412a459972f45d3edc959901a849a12eaac1f08b050ba94663e", "evidence_kind": "English manual and source declarations", "source_sha256": "9cf136a703d8ee2f83465c43be4e9e8e7930c82b0bfba13be7e2537be769ac55"}, "sources": [{"url": "/docs/17/app-psql.html#APP-PSQL-META-COMMAND-DX-UC", "file": "app-psql.html", "label": "17.12 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-DX-UC", "sha256": "0a15b496eec7377c3e3cdbba9c3202ea984799cde158cf8c6826d339ff454a76"}], "zh_from": "same-version-manual", "facts_zh": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 17.12"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\dX"}], "sections": [], "center_zh": {"locale": "zh-Hans", "payload": {"description_zh": "\u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002", "description_zh_html": "<dd><p>\n        \u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 <em class=\"replaceable\"><code>pattern</code></em>\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002        </p><p>\n        \u6bcf\u79cd\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u7684\u72b6\u6001\u663e\u793a\u5728\u4ee5\u5176\u7edf\u8ba1\u7c7b\u578b\u547d\u540d\u7684\u5217\u4e2d\uff08\u4f8b\u5982 Ndistinct\uff09\u3002<code class=\"literal\">defined</code> \u8868\u793a\u5728\u521b\u5efa\u7edf\u8ba1\u4fe1\u606f\u65f6\u8bf7\u6c42\u4e86\u8be5\u4fe1\u606f\uff0cNULL \u8868\u793a\u672a\u8bf7\u6c42\u3002\u5982\u679c\u60f3\u77e5\u9053\u662f\u5426\u5df2\u7ecf\u8fd0\u884c\u4e86 <a class=\"link\" href=\"/docs/17/sql-analyze.html\" title=\"ANALYZE\"><code class=\"command\">ANALYZE</code></a>\uff0c\u4ee5\u53ca\u8fd9\u4e9b\u7edf\u8ba1\u4fe1\u606f\u662f\u5426\u5df2\u7ecf\u5bf9\u89c4\u5212\u5668\u53ef\u7528\uff0c\u53ef\u4ee5\u67e5\u770b <code class=\"structname\">pg_stats_ext</code>\u3002\n        </p></dd>"}, "summary": "\u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002", "body_html": "<dd><p>\n        \u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 <em class=\"replaceable\"><code>pattern</code></em>\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002        </p><p>\n        \u6bcf\u79cd\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u7684\u72b6\u6001\u663e\u793a\u5728\u4ee5\u5176\u7edf\u8ba1\u7c7b\u578b\u547d\u540d\u7684\u5217\u4e2d\uff08\u4f8b\u5982 Ndistinct\uff09\u3002<code class=\"literal\">defined</code> \u8868\u793a\u5728\u521b\u5efa\u7edf\u8ba1\u4fe1\u606f\u65f6\u8bf7\u6c42\u4e86\u8be5\u4fe1\u606f\uff0cNULL \u8868\u793a\u672a\u8bf7\u6c42\u3002\u5982\u679c\u60f3\u77e5\u9053\u662f\u5426\u5df2\u7ecf\u8fd0\u884c\u4e86 <a class=\"link\" href=\"/docs/17/sql-analyze.html\" title=\"ANALYZE\"><code class=\"command\">ANALYZE</code></a>\uff0c\u4ee5\u53ca\u8fd9\u4e9b\u7edf\u8ba1\u4fe1\u606f\u662f\u5426\u5df2\u7ecf\u5bf9\u89c4\u5212\u5668\u53ef\u7528\uff0c\u53ef\u4ee5\u67e5\u770b <code class=\"structname\">pg_stats_ext</code>\u3002\n        </p></dd>", "body_sha256": "2b714f11f0370daa5f0b4e88f4ec967969750dc28043c2327ac7a044927cfe58", "content_hash": "37c39792879b959edc729d73a1f66829833bd9991726c0ef4b93dee695f3fbd8", "source_revision": "pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552", "definition_version": "17", "documentation_release": "17.12"}, "modifiers": [], "signature": "\\dX [ pattern ]", "spellings": ["\\dX"], "tables_zh": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-64-58/?v=17", "text": "\\dX"}, "modifiers": "\u6b64\u8bed\u6cd5\u7b7e\u540d\u672a\u5217\u51fa"}], "title": "\u672c\u7248\u624b\u518c\u4e2d\u7684\u5199\u6cd5", "columns": [{"key": "command", "label": "\u547d\u4ee4"}, {"key": "modifiers", "label": "\u624b\u518c\u4e2d\u7684\u540e\u7f00\u4fee\u9970\u7b26"}]}], "related_zh": [{"url": "/wiki/tool/psql/?v=17", "label": "psql \u547d\u4ee4\u884c\u9009\u9879\u53ca\u5b8c\u6574\u624b\u518c"}], "description": ["\u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002"], "manual_html": "<dd><p>\n        \u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 <em class=\"replaceable\"><code>pattern</code></em>\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002        </p><p>\n        \u6bcf\u79cd\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u7684\u72b6\u6001\u663e\u793a\u5728\u4ee5\u5176\u7edf\u8ba1\u7c7b\u578b\u547d\u540d\u7684\u5217\u4e2d\uff08\u4f8b\u5982 Ndistinct\uff09\u3002<code class=\"literal\">defined</code> \u8868\u793a\u5728\u521b\u5efa\u7edf\u8ba1\u4fe1\u606f\u65f6\u8bf7\u6c42\u4e86\u8be5\u4fe1\u606f\uff0cNULL \u8868\u793a\u672a\u8bf7\u6c42\u3002\u5982\u679c\u60f3\u77e5\u9053\u662f\u5426\u5df2\u7ecf\u8fd0\u884c\u4e86 <a class=\"link\" href=\"/docs/17/sql-analyze.html\" title=\"ANALYZE\"><code class=\"command\">ANALYZE</code></a>\uff0c\u4ee5\u53ca\u8fd9\u4e9b\u7edf\u8ba1\u4fe1\u606f\u662f\u5426\u5df2\u7ecf\u5bf9\u89c4\u5212\u5668\u53ef\u7528\uff0c\u53ef\u4ee5\u67e5\u770b <code class=\"structname\">pg_stats_ext</code>\u3002\n        </p></dd>", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-DX-UC", "sections_zh": [], "localization": {"status": "same-version-reviewed-manual", "language": "zh", "source_language": "en", "source_revision": "pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552", "documentation_release": "17.12"}, "description_zh": "\u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002", "comparison_data": {"modifiers": [], "signature": "\\dX [ pattern ]", "spellings": ["\\dX"], "definition": "Lists extended statistics. If pattern is specified, only those extended statistics whose names match the pattern are listed. The status of each kind of extended statistics is shown in a column named after its statistic kind (e.g. Ndistinct). defined means that it was requested when creating the statistics, and NULL means it wasn't requested. You can use pg_stats_ext if you'd like to know whether ANALYZE was run and statistics are available to the planner."}, "comparison_hash": "e8e40be3868ba8bbe9663cc29befa206dff42274e00e6a4e658818ef2b2380d4", "manual_language": "zh", "description_zh_html": "<dd><p>\n        \u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 <em class=\"replaceable\"><code>pattern</code></em>\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002        </p><p>\n        \u6bcf\u79cd\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u7684\u72b6\u6001\u663e\u793a\u5728\u4ee5\u5176\u7edf\u8ba1\u7c7b\u578b\u547d\u540d\u7684\u5217\u4e2d\uff08\u4f8b\u5982 Ndistinct\uff09\u3002<code class=\"literal\">defined</code> \u8868\u793a\u5728\u521b\u5efa\u7edf\u8ba1\u4fe1\u606f\u65f6\u8bf7\u6c42\u4e86\u8be5\u4fe1\u606f\uff0cNULL \u8868\u793a\u672a\u8bf7\u6c42\u3002\u5982\u679c\u60f3\u77e5\u9053\u662f\u5426\u5df2\u7ecf\u8fd0\u884c\u4e86 <a class=\"link\" href=\"/docs/17/sql-analyze.html\" title=\"ANALYZE\"><code class=\"command\">ANALYZE</code></a>\uff0c\u4ee5\u53ca\u8fd9\u4e9b\u7edf\u8ba1\u4fe1\u606f\u662f\u5426\u5df2\u7ecf\u5bf9\u89c4\u5212\u5668\u53ef\u7528\uff0c\u53ef\u4ee5\u67e5\u770b <code class=\"structname\">pg_stats_ext</code>\u3002\n        </p></dd>", "documentation_revision": {"inputs": [{"file": "app-psql.html", "kind": "same-version-reviewed-manual", "locale": "en", "sha256": "0a15b496eec7377c3e3cdbba9c3202ea984799cde158cf8c6826d339ff454a76", "version": "17.12"}, {"file": "app-psql.html", "kind": "same-version-reviewed-manual", "locale": "zh-Hans", "sha256": "72c5d1a2c80c31246970e54811e0b6ea23a7c11cefe49b9e64efbb6b84781fa2", "version": "17.12"}], "release": "17.12", "source_revision": "pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552", "runtime_remeasured": false}}, "18": {"lang": "zh", "facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 18.7"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\dX"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-64-58/?v=18", "text": "\\dX"}, "modifiers": "x"}], "title": "\u672c\u7248\u624b\u518c\u4e2d\u7684\u5199\u6cd5", "columns": [{"key": "command", "label": "\u547d\u4ee4"}, {"key": "modifiers", "label": "\u624b\u518c\u4e2d\u7684\u540e\u7f00\u4fee\u9970\u7b26"}]}], "command": "\\dX", "related": [{"url": "/wiki/tool/psql/?v=18", "label": "psql \u547d\u4ee4\u884c\u9009\u9879\u53ca\u5b8c\u6574\u624b\u518c"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v18.7/postgresql-18.7.tar.bz2", "label": "18.7", "major": "18", "channel": "stable", "manifest": {"major": "18", "release": "18.7", "source_url": "https://ftp.postgresql.org/pub/source/v18.7/postgresql-18.7.tar.bz2", "source_sha256": "441dfae4280cae3e0425e5f876f80559fb0731c140f1aae22b3e5a54d0411bfd"}, "revision": "1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915", "evidence_kind": "English manual and source declarations", "source_sha256": "441dfae4280cae3e0425e5f876f80559fb0731c140f1aae22b3e5a54d0411bfd"}, "sources": [{"url": "/docs/18/app-psql.html#APP-PSQL-META-COMMAND-DX-UC", "file": "app-psql.html", "label": "18.7 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-DX-UC", "sha256": "af50448485df02bdef2b72b8347192ba029c7082b8d0392ecb17db44ad533aaf"}], "zh_from": "same-version-manual", "facts_zh": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 18.7"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\dX"}], "sections": [], "center_zh": {"locale": "zh-Hans", "payload": {"description_zh": "\u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 x \uff0c\u7ed3\u679c\u4f1a\u4ee5\u6269\u5c55\u6a21\u5f0f\u663e\u793a\u3002", "description_zh_html": "<dd><p>\n        \u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 <em class=\"replaceable\"><code>pattern</code></em>\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 <code class=\"literal\">x</code>\uff0c\u7ed3\u679c\u4f1a\u4ee5\u6269\u5c55\u6a21\u5f0f\u663e\u793a\u3002\n        </p><p>\n        \u6bcf\u79cd\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u7684\u72b6\u6001\u663e\u793a\u5728\u4ee5\u5176\u7edf\u8ba1\u7c7b\u578b\u547d\u540d\u7684\u5217\u4e2d\uff08\u4f8b\u5982 Ndistinct\uff09\u3002<code class=\"literal\">defined</code> \u8868\u793a\u5728\u521b\u5efa\u7edf\u8ba1\u4fe1\u606f\u65f6\u8bf7\u6c42\u4e86\u8be5\u4fe1\u606f\uff0cNULL \u8868\u793a\u672a\u8bf7\u6c42\u3002\u5982\u679c\u60f3\u77e5\u9053\u662f\u5426\u5df2\u7ecf\u8fd0\u884c\u4e86 <a class=\"link\" href=\"/docs/18/sql-analyze.html\" title=\"ANALYZE\"><code class=\"command\">ANALYZE</code></a>\uff0c\u4ee5\u53ca\u8fd9\u4e9b\u7edf\u8ba1\u4fe1\u606f\u662f\u5426\u5df2\u7ecf\u5bf9\u89c4\u5212\u5668\u53ef\u7528\uff0c\u53ef\u4ee5\u67e5\u770b <code class=\"structname\">pg_stats_ext</code>\u3002\n        </p></dd>"}, "summary": "\u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 x \uff0c\u7ed3\u679c\u4f1a\u4ee5\u6269\u5c55\u6a21\u5f0f\u663e\u793a\u3002", "body_html": "<dd><p>\n        \u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 <em class=\"replaceable\"><code>pattern</code></em>\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 <code class=\"literal\">x</code>\uff0c\u7ed3\u679c\u4f1a\u4ee5\u6269\u5c55\u6a21\u5f0f\u663e\u793a\u3002\n        </p><p>\n        \u6bcf\u79cd\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u7684\u72b6\u6001\u663e\u793a\u5728\u4ee5\u5176\u7edf\u8ba1\u7c7b\u578b\u547d\u540d\u7684\u5217\u4e2d\uff08\u4f8b\u5982 Ndistinct\uff09\u3002<code class=\"literal\">defined</code> \u8868\u793a\u5728\u521b\u5efa\u7edf\u8ba1\u4fe1\u606f\u65f6\u8bf7\u6c42\u4e86\u8be5\u4fe1\u606f\uff0cNULL \u8868\u793a\u672a\u8bf7\u6c42\u3002\u5982\u679c\u60f3\u77e5\u9053\u662f\u5426\u5df2\u7ecf\u8fd0\u884c\u4e86 <a class=\"link\" href=\"/docs/18/sql-analyze.html\" title=\"ANALYZE\"><code class=\"command\">ANALYZE</code></a>\uff0c\u4ee5\u53ca\u8fd9\u4e9b\u7edf\u8ba1\u4fe1\u606f\u662f\u5426\u5df2\u7ecf\u5bf9\u89c4\u5212\u5668\u53ef\u7528\uff0c\u53ef\u4ee5\u67e5\u770b <code class=\"structname\">pg_stats_ext</code>\u3002\n        </p></dd>", "body_sha256": "5c02a3c2bd93c5a4af5579da7c6b1a5e7327ae2d9258f1154ccfb3ab885de7fc", "content_hash": "fd963885ef38ae9af45cdb7fdcf8d804887e63542aae368eafb98ab99b446b34", "source_revision": "pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552", "definition_version": "18", "documentation_release": "18.7"}, "modifiers": [{"command": "\\dX", "modifiers": "x"}], "signature": "\\dX[x] [ pattern ]", "spellings": ["\\dX"], "tables_zh": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-64-58/?v=18", "text": "\\dX"}, "modifiers": "x"}], "title": "\u672c\u7248\u624b\u518c\u4e2d\u7684\u5199\u6cd5", "columns": [{"key": "command", "label": "\u547d\u4ee4"}, {"key": "modifiers", "label": "\u624b\u518c\u4e2d\u7684\u540e\u7f00\u4fee\u9970\u7b26"}]}], "related_zh": [{"url": "/wiki/tool/psql/?v=18", "label": "psql \u547d\u4ee4\u884c\u9009\u9879\u53ca\u5b8c\u6574\u624b\u518c"}], "description": ["\u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 x \uff0c\u7ed3\u679c\u4f1a\u4ee5\u6269\u5c55\u6a21\u5f0f\u663e\u793a\u3002"], "manual_html": "<dd><p>\n        \u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 <em class=\"replaceable\"><code>pattern</code></em>\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 <code class=\"literal\">x</code>\uff0c\u7ed3\u679c\u4f1a\u4ee5\u6269\u5c55\u6a21\u5f0f\u663e\u793a\u3002\n        </p><p>\n        \u6bcf\u79cd\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u7684\u72b6\u6001\u663e\u793a\u5728\u4ee5\u5176\u7edf\u8ba1\u7c7b\u578b\u547d\u540d\u7684\u5217\u4e2d\uff08\u4f8b\u5982 Ndistinct\uff09\u3002<code class=\"literal\">defined</code> \u8868\u793a\u5728\u521b\u5efa\u7edf\u8ba1\u4fe1\u606f\u65f6\u8bf7\u6c42\u4e86\u8be5\u4fe1\u606f\uff0cNULL \u8868\u793a\u672a\u8bf7\u6c42\u3002\u5982\u679c\u60f3\u77e5\u9053\u662f\u5426\u5df2\u7ecf\u8fd0\u884c\u4e86 <a class=\"link\" href=\"/docs/18/sql-analyze.html\" title=\"ANALYZE\"><code class=\"command\">ANALYZE</code></a>\uff0c\u4ee5\u53ca\u8fd9\u4e9b\u7edf\u8ba1\u4fe1\u606f\u662f\u5426\u5df2\u7ecf\u5bf9\u89c4\u5212\u5668\u53ef\u7528\uff0c\u53ef\u4ee5\u67e5\u770b <code class=\"structname\">pg_stats_ext</code>\u3002\n        </p></dd>", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-DX-UC", "sections_zh": [], "localization": {"status": "same-version-reviewed-manual", "language": "zh", "source_language": "en", "source_revision": "pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552", "documentation_release": "18.7"}, "description_zh": "\u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 x \uff0c\u7ed3\u679c\u4f1a\u4ee5\u6269\u5c55\u6a21\u5f0f\u663e\u793a\u3002", "comparison_data": {"modifiers": [{"command": "\\dX", "modifiers": "x"}], "signature": "\\dX[x] [ pattern ]", "spellings": ["\\dX"], "definition": "Lists extended statistics. If pattern is specified, only those extended statistics whose names match the pattern are listed. If x is appended to the command name, the results are displayed in expanded mode. The status of each kind of extended statistics is shown in a column named after its statistic kind (e.g. Ndistinct). defined means that it was requested when creating the statistics, and NULL means it wasn't requested. You can use pg_stats_ext if you'd like to know whether ANALYZE was run and statistics are available to the planner."}, "comparison_hash": "7d57c7a90cc5537c52b133cd7775b49b853bbfdfb4f13def0a7a596b42b3ae29", "manual_language": "zh", "description_zh_html": "<dd><p>\n        \u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 <em class=\"replaceable\"><code>pattern</code></em>\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 <code class=\"literal\">x</code>\uff0c\u7ed3\u679c\u4f1a\u4ee5\u6269\u5c55\u6a21\u5f0f\u663e\u793a\u3002\n        </p><p>\n        \u6bcf\u79cd\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u7684\u72b6\u6001\u663e\u793a\u5728\u4ee5\u5176\u7edf\u8ba1\u7c7b\u578b\u547d\u540d\u7684\u5217\u4e2d\uff08\u4f8b\u5982 Ndistinct\uff09\u3002<code class=\"literal\">defined</code> \u8868\u793a\u5728\u521b\u5efa\u7edf\u8ba1\u4fe1\u606f\u65f6\u8bf7\u6c42\u4e86\u8be5\u4fe1\u606f\uff0cNULL \u8868\u793a\u672a\u8bf7\u6c42\u3002\u5982\u679c\u60f3\u77e5\u9053\u662f\u5426\u5df2\u7ecf\u8fd0\u884c\u4e86 <a class=\"link\" href=\"/docs/18/sql-analyze.html\" title=\"ANALYZE\"><code class=\"command\">ANALYZE</code></a>\uff0c\u4ee5\u53ca\u8fd9\u4e9b\u7edf\u8ba1\u4fe1\u606f\u662f\u5426\u5df2\u7ecf\u5bf9\u89c4\u5212\u5668\u53ef\u7528\uff0c\u53ef\u4ee5\u67e5\u770b <code class=\"structname\">pg_stats_ext</code>\u3002\n        </p></dd>", "documentation_revision": {"inputs": [{"file": "app-psql.html", "kind": "same-version-reviewed-manual", "locale": "en", "sha256": "af50448485df02bdef2b72b8347192ba029c7082b8d0392ecb17db44ad533aaf", "version": "18.7"}, {"file": "app-psql.html", "kind": "same-version-reviewed-manual", "locale": "zh-Hans", "sha256": "cb475c53a16d9e06358f5e6c9c5649645db92568cfd319f230c62c9f57ae090b", "version": "18.7"}], "release": "18.7", "source_revision": "pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552", "runtime_remeasured": false}, "center_zh_rendered": "<dl><dd><p>\n        \u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 <em class=\"replaceable\"><code>pattern</code></em>\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 <code class=\"literal\">x</code>\uff0c\u7ed3\u679c\u4f1a\u4ee5\u6269\u5c55\u6a21\u5f0f\u663e\u793a\u3002\n        </p><p>\n        \u6bcf\u79cd\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u7684\u72b6\u6001\u663e\u793a\u5728\u4ee5\u5176\u7edf\u8ba1\u7c7b\u578b\u547d\u540d\u7684\u5217\u4e2d\uff08\u4f8b\u5982 Ndistinct\uff09\u3002<code class=\"literal\">defined</code> \u8868\u793a\u5728\u521b\u5efa\u7edf\u8ba1\u4fe1\u606f\u65f6\u8bf7\u6c42\u4e86\u8be5\u4fe1\u606f\uff0cNULL \u8868\u793a\u672a\u8bf7\u6c42\u3002\u5982\u679c\u60f3\u77e5\u9053\u662f\u5426\u5df2\u7ecf\u8fd0\u884c\u4e86 <a class=\"link\" href=\"/docs/18/sql-analyze.html\" title=\"ANALYZE\"><code class=\"command\">ANALYZE</code></a>\uff0c\u4ee5\u53ca\u8fd9\u4e9b\u7edf\u8ba1\u4fe1\u606f\u662f\u5426\u5df2\u7ecf\u5bf9\u89c4\u5212\u5668\u53ef\u7528\uff0c\u53ef\u4ee5\u67e5\u770b <code class=\"structname\">pg_stats_ext</code>\u3002\n        </p></dd></dl>"}, "19": {"lang": "zh", "facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 19rc2"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\dX"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-64-58/?v=19", "text": "\\dX"}, "modifiers": "x+"}], "title": "\u672c\u7248\u624b\u518c\u4e2d\u7684\u5199\u6cd5", "columns": [{"key": "command", "label": "\u547d\u4ee4"}, {"key": "modifiers", "label": "\u624b\u518c\u4e2d\u7684\u540e\u7f00\u4fee\u9970\u7b26"}]}], "command": "\\dX", "related": [{"url": "/wiki/tool/psql/?v=19", "label": "psql \u547d\u4ee4\u884c\u9009\u9879\u53ca\u5b8c\u6574\u624b\u518c"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v19rc2/postgresql-19rc2.tar.bz2", "label": "19rc2", "major": "19", "channel": "preview", "manifest": {"major": "19", "release": "19rc2", "source_url": "https://ftp.postgresql.org/pub/source/v19rc2/postgresql-19rc2.tar.bz2", "source_sha256": "23a7bb862e4bac395c047305ed0084117b01e71255ce858b907cdcd78ce40351"}, "revision": "cd49a2a98fed04eec7571858125796f86e63613d1985225049f2aa8b0955f256", "evidence_kind": "English manual and source declarations", "source_sha256": "23a7bb862e4bac395c047305ed0084117b01e71255ce858b907cdcd78ce40351"}, "sources": [{"url": "/docs/19/app-psql.html#APP-PSQL-META-COMMAND-DX-UC", "file": "app-psql.html", "label": "19rc2 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-DX-UC", "sha256": "88aeb3d77ad0a535a6a363215f0ac18936c368ac157e694ad30fea3c1ee30218"}], "zh_from": "same-version-manual", "facts_zh": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 19rc2"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\dX"}], "sections": [], "center_zh": {"locale": "zh-Hans", "payload": {"description_zh": "\u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 x \uff0c\u7ed3\u679c\u4f1a\u4ee5\u6269\u5c55\u6a21\u5f0f\u663e\u793a\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 + \uff0c\u5219\u6bcf\u4e2a\u5bf9\u8c61\u90fd\u4f1a\u8fde\u540c\u5176\u5173\u8054\u63cf\u8ff0\u4e00\u8d77\u5217\u51fa\u3002", "description_zh_html": "<dd><p>\n        \u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 <em class=\"replaceable\"><code>pattern</code></em>\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 <code class=\"literal\">x</code>\uff0c\u7ed3\u679c\u4f1a\u4ee5\u6269\u5c55\u6a21\u5f0f\u663e\u793a\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 <code class=\"literal\">+</code>\uff0c\u5219\u6bcf\u4e2a\u5bf9\u8c61\u90fd\u4f1a\u8fde\u540c\u5176\u5173\u8054\u63cf\u8ff0\u4e00\u8d77\u5217\u51fa\u3002\n        </p><p>\n        \u6bcf\u79cd\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u7684\u72b6\u6001\u663e\u793a\u5728\u4ee5\u5176\u7edf\u8ba1\u7c7b\u578b\u547d\u540d\u7684\u5217\u4e2d\uff08\u4f8b\u5982 Ndistinct\uff09\u3002<code class=\"literal\">defined</code> \u8868\u793a\u5728\u521b\u5efa\u7edf\u8ba1\u4fe1\u606f\u65f6\u8bf7\u6c42\u4e86\u8be5\u4fe1\u606f\uff0cNULL \u8868\u793a\u672a\u8bf7\u6c42\u3002\u5982\u679c\u60f3\u77e5\u9053\u662f\u5426\u5df2\u7ecf\u8fd0\u884c\u4e86 <a class=\"link\" href=\"/docs/19/sql-analyze.html\" title=\"ANALYZE\"><code class=\"command\">ANALYZE</code></a>\uff0c\u4ee5\u53ca\u8fd9\u4e9b\u7edf\u8ba1\u4fe1\u606f\u662f\u5426\u5df2\u7ecf\u5bf9\u89c4\u5212\u5668\u53ef\u7528\uff0c\u53ef\u4ee5\u67e5\u770b <code class=\"structname\">pg_stats_ext</code>\u3002\n        </p></dd>"}, "summary": "\u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 x \uff0c\u7ed3\u679c\u4f1a\u4ee5\u6269\u5c55\u6a21\u5f0f\u663e\u793a\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 + \uff0c\u5219\u6bcf\u4e2a\u5bf9\u8c61\u90fd\u4f1a\u8fde\u540c\u5176\u5173\u8054\u63cf\u8ff0\u4e00\u8d77\u5217\u51fa\u3002", "body_html": "<dd><p>\n        \u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 <em class=\"replaceable\"><code>pattern</code></em>\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 <code class=\"literal\">x</code>\uff0c\u7ed3\u679c\u4f1a\u4ee5\u6269\u5c55\u6a21\u5f0f\u663e\u793a\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 <code class=\"literal\">+</code>\uff0c\u5219\u6bcf\u4e2a\u5bf9\u8c61\u90fd\u4f1a\u8fde\u540c\u5176\u5173\u8054\u63cf\u8ff0\u4e00\u8d77\u5217\u51fa\u3002\n        </p><p>\n        \u6bcf\u79cd\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u7684\u72b6\u6001\u663e\u793a\u5728\u4ee5\u5176\u7edf\u8ba1\u7c7b\u578b\u547d\u540d\u7684\u5217\u4e2d\uff08\u4f8b\u5982 Ndistinct\uff09\u3002<code class=\"literal\">defined</code> \u8868\u793a\u5728\u521b\u5efa\u7edf\u8ba1\u4fe1\u606f\u65f6\u8bf7\u6c42\u4e86\u8be5\u4fe1\u606f\uff0cNULL \u8868\u793a\u672a\u8bf7\u6c42\u3002\u5982\u679c\u60f3\u77e5\u9053\u662f\u5426\u5df2\u7ecf\u8fd0\u884c\u4e86 <a class=\"link\" href=\"/docs/19/sql-analyze.html\" title=\"ANALYZE\"><code class=\"command\">ANALYZE</code></a>\uff0c\u4ee5\u53ca\u8fd9\u4e9b\u7edf\u8ba1\u4fe1\u606f\u662f\u5426\u5df2\u7ecf\u5bf9\u89c4\u5212\u5668\u53ef\u7528\uff0c\u53ef\u4ee5\u67e5\u770b <code class=\"structname\">pg_stats_ext</code>\u3002\n        </p></dd>", "body_sha256": "8e2bd995ed2535314266c8ed29f701010a3104eecd8e29776406b8590a4621af", "content_hash": "4ff1cad830f5c8ecec20348b5d4cf2a2f95658321504a2cd0fea5f4aca9c88e6", "source_revision": "pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552", "definition_version": "19", "documentation_release": "19rc2"}, "modifiers": [{"command": "\\dX", "modifiers": "x+"}], "signature": "\\dX[x+] [ pattern ]", "spellings": ["\\dX"], "tables_zh": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-64-58/?v=19", "text": "\\dX"}, "modifiers": "x+"}], "title": "\u672c\u7248\u624b\u518c\u4e2d\u7684\u5199\u6cd5", "columns": [{"key": "command", "label": "\u547d\u4ee4"}, {"key": "modifiers", "label": "\u624b\u518c\u4e2d\u7684\u540e\u7f00\u4fee\u9970\u7b26"}]}], "related_zh": [{"url": "/wiki/tool/psql/?v=19", "label": "psql \u547d\u4ee4\u884c\u9009\u9879\u53ca\u5b8c\u6574\u624b\u518c"}], "description": ["\u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 x \uff0c\u7ed3\u679c\u4f1a\u4ee5\u6269\u5c55\u6a21\u5f0f\u663e\u793a\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 + \uff0c\u5219\u6bcf\u4e2a\u5bf9\u8c61\u90fd\u4f1a\u8fde\u540c\u5176\u5173\u8054\u63cf\u8ff0\u4e00\u8d77\u5217\u51fa\u3002"], "manual_html": "<dd><p>\n        \u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 <em class=\"replaceable\"><code>pattern</code></em>\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 <code class=\"literal\">x</code>\uff0c\u7ed3\u679c\u4f1a\u4ee5\u6269\u5c55\u6a21\u5f0f\u663e\u793a\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 <code class=\"literal\">+</code>\uff0c\u5219\u6bcf\u4e2a\u5bf9\u8c61\u90fd\u4f1a\u8fde\u540c\u5176\u5173\u8054\u63cf\u8ff0\u4e00\u8d77\u5217\u51fa\u3002\n        </p><p>\n        \u6bcf\u79cd\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u7684\u72b6\u6001\u663e\u793a\u5728\u4ee5\u5176\u7edf\u8ba1\u7c7b\u578b\u547d\u540d\u7684\u5217\u4e2d\uff08\u4f8b\u5982 Ndistinct\uff09\u3002<code class=\"literal\">defined</code> \u8868\u793a\u5728\u521b\u5efa\u7edf\u8ba1\u4fe1\u606f\u65f6\u8bf7\u6c42\u4e86\u8be5\u4fe1\u606f\uff0cNULL \u8868\u793a\u672a\u8bf7\u6c42\u3002\u5982\u679c\u60f3\u77e5\u9053\u662f\u5426\u5df2\u7ecf\u8fd0\u884c\u4e86 <a class=\"link\" href=\"/docs/19/sql-analyze.html\" title=\"ANALYZE\"><code class=\"command\">ANALYZE</code></a>\uff0c\u4ee5\u53ca\u8fd9\u4e9b\u7edf\u8ba1\u4fe1\u606f\u662f\u5426\u5df2\u7ecf\u5bf9\u89c4\u5212\u5668\u53ef\u7528\uff0c\u53ef\u4ee5\u67e5\u770b <code class=\"structname\">pg_stats_ext</code>\u3002\n        </p></dd>", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-DX-UC", "sections_zh": [], "localization": {"status": "same-version-reviewed-manual", "language": "zh", "source_language": "en", "source_revision": "pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552", "documentation_release": "19rc2"}, "description_zh": "\u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 x \uff0c\u7ed3\u679c\u4f1a\u4ee5\u6269\u5c55\u6a21\u5f0f\u663e\u793a\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 + \uff0c\u5219\u6bcf\u4e2a\u5bf9\u8c61\u90fd\u4f1a\u8fde\u540c\u5176\u5173\u8054\u63cf\u8ff0\u4e00\u8d77\u5217\u51fa\u3002", "comparison_data": {"modifiers": [{"command": "\\dX", "modifiers": "x+"}], "signature": "\\dX[x+] [ pattern ]", "spellings": ["\\dX"], "definition": "Lists extended statistics. If pattern is specified, only those extended statistics whose names match the pattern are listed. If x is appended to the command name, the results are displayed in expanded mode. If + is appended to the command name, each object is listed with its associated description. The status of each kind of extended statistics is shown in a column named after its statistic kind (e.g. Ndistinct). defined means that it was requested when creating the statistics, and NULL means it wasn't requested. You can use pg_stats_ext if you'd like to know whether ANALYZE was run and statistics are available to the planner."}, "comparison_hash": "00afe6616ae35df1d909e640e68a18c8a970fc23ef49baea45b10fd45fa6cabf", "manual_language": "zh", "description_zh_html": "<dd><p>\n        \u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 <em class=\"replaceable\"><code>pattern</code></em>\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 <code class=\"literal\">x</code>\uff0c\u7ed3\u679c\u4f1a\u4ee5\u6269\u5c55\u6a21\u5f0f\u663e\u793a\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 <code class=\"literal\">+</code>\uff0c\u5219\u6bcf\u4e2a\u5bf9\u8c61\u90fd\u4f1a\u8fde\u540c\u5176\u5173\u8054\u63cf\u8ff0\u4e00\u8d77\u5217\u51fa\u3002\n        </p><p>\n        \u6bcf\u79cd\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u7684\u72b6\u6001\u663e\u793a\u5728\u4ee5\u5176\u7edf\u8ba1\u7c7b\u578b\u547d\u540d\u7684\u5217\u4e2d\uff08\u4f8b\u5982 Ndistinct\uff09\u3002<code class=\"literal\">defined</code> \u8868\u793a\u5728\u521b\u5efa\u7edf\u8ba1\u4fe1\u606f\u65f6\u8bf7\u6c42\u4e86\u8be5\u4fe1\u606f\uff0cNULL \u8868\u793a\u672a\u8bf7\u6c42\u3002\u5982\u679c\u60f3\u77e5\u9053\u662f\u5426\u5df2\u7ecf\u8fd0\u884c\u4e86 <a class=\"link\" href=\"/docs/19/sql-analyze.html\" title=\"ANALYZE\"><code class=\"command\">ANALYZE</code></a>\uff0c\u4ee5\u53ca\u8fd9\u4e9b\u7edf\u8ba1\u4fe1\u606f\u662f\u5426\u5df2\u7ecf\u5bf9\u89c4\u5212\u5668\u53ef\u7528\uff0c\u53ef\u4ee5\u67e5\u770b <code class=\"structname\">pg_stats_ext</code>\u3002\n        </p></dd>", "source_revalidation": {"kind": "static-same-version-source-and-manual-replay", "audit": "wiki-audit-20261023", "runtime_rerun": false, "compared_fields": "entity membership and source-derived facts; presentation markup normalized", "source_revision": "5e06fe0541cd1f62a9fc1a66c342c19a2944ff3c98281bfbdb1d4a6d6d53fe2f", "previous_source_revision": "1bbbbf4133d426f0e4304010688d2984c30fb67df0cc3a61b3e37eb3f6f37833"}, "documentation_revision": {"inputs": [{"file": "app-psql.html", "kind": "same-version-reviewed-manual", "locale": "en", "sha256": "88aeb3d77ad0a535a6a363215f0ac18936c368ac157e694ad30fea3c1ee30218", "version": "19rc2"}, {"file": "app-psql.html", "kind": "same-version-reviewed-manual", "locale": "zh-Hans", "sha256": "7c244fc95f382349e2864e47925de5baa9fd870b49efe597bdf30e0ffc365f68", "version": "19rc2"}], "release": "19rc2", "source_revision": "pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552", "runtime_remeasured": false}}, "20": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 20devel"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\dX"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-64-58/?v=20", "text": "\\dX"}, "modifiers": "x+"}], "title": "\u672c\u7248\u624b\u518c\u4e2d\u7684\u5199\u6cd5", "columns": [{"key": "command", "label": "\u547d\u4ee4"}, {"key": "modifiers", "label": "\u624b\u518c\u4e2d\u7684\u540e\u7f00\u4fee\u9970\u7b26"}]}], "command": "\\dX", "related": [{"url": "/wiki/tool/psql/?v=20", "label": "psql \u547d\u4ee4\u884c\u9009\u9879\u53ca\u5b8c\u6574\u624b\u518c"}], "release": {"ref": "https://ftp.postgresql.org/pub/snapshot/dev/postgresql-snapshot.tar.bz2", "label": "20devel", "major": "20", "channel": "devel", "manifest": {"major": "20", "release": "20devel", "source_url": "https://ftp.postgresql.org/pub/snapshot/dev/postgresql-snapshot.tar.bz2", "source_sha256": "49c73aa4c9cacef8ca979276a28ac416c08e9e54c9baee4ae5fd116a35fa13ac"}, "revision": "3cd0885bb4eccdbaac1a21177cc639e9031e54bd8ea6536c45224b5563354ce2", "evidence_kind": "English manual and source declarations", "source_sha256": "49c73aa4c9cacef8ca979276a28ac416c08e9e54c9baee4ae5fd116a35fa13ac"}, "sources": [{"url": "/docs/devel/app-psql.html#APP-PSQL-META-COMMAND-DX-UC", "file": "app-psql.html", "label": "20devel English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-DX-UC", "sha256": "4040ccb7cbcb1a83a43c150f5b92ddd10ff8837fdc27835b1863d4a316645676"}], "zh_from": {"kind": "same-version-chinese-manual-with-source-derived-identity", "manual": {"url": "/zh/docs/devel/app-psql.html#APP-PSQL-META-COMMAND-DX-UC", "anchor": "APP-PSQL-META-COMMAND-DX-UC", "locale": "zh-Hans", "version": "20", "build_id": 111, "page_key": "app-psql.html", "extraction": "exact-definition", "source_hash": "98935f3e8a333e7201e42b7315bb9e09d62e0711037964568c16bd22ae183680", "fragment_sha256": "8b08b61685bc6de781cd627955c0a569d5bf34503fd2a952eaa071e02aaab467", "source_revision": "sha256:49c73aa4c9cacef8ca979276a28ac416c08e9e54c9baee4ae5fd116a35fa13ac", "translation_revision": "git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:98c980963b401d40bd50df72b909e7523e3148b8fdb48edd897de2efb67e5235", "translated_from_revision": "sha256:49c73aa4c9cacef8ca979276a28ac416c08e9e54c9baee4ae5fd116a35fa13ac"}, "body_sha256": "991a0e637241e7943fe71cae3e4d5de042b6e193c10a8956b979f3b4affe5d3d", "runtime_rerun": false, "authored_translation": "source-derived-identity", "source_facts_revision": "3cd0885bb4eccdbaac1a21177cc639e9031e54bd8ea6536c45224b5563354ce2"}, "facts_zh": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 20devel"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\dX"}], "sections": [], "center_zh": {"title": "\\dX", "locale": "zh-Hans", "source": {"key": "cmd-64-58", "locale": "zh-Hans", "version": "20", "text_hash": "7bdf50e90f4cf347284f14fe472cc5129b3a480d7977da7a7837fefa5a43e3b3", "collection": "psql", "dataset_hash": "7c31b524dfe136022d39a6ae8dcfac6b3bbd5f8fdaf422536599981252aff0c9", "source_database": "center", "source_revision": "3cd0885bb4eccdbaac1a21177cc639e9031e54bd8ea6536c45224b5563354ce2"}, "payload": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 20devel"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\dX"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-64-58/?v=20", "text": "\\dX"}, "modifiers": "x+"}], "title": "\u672c\u7248\u624b\u518c\u4e2d\u7684\u5199\u6cd5", "columns": [{"key": "command", "label": "\u547d\u4ee4"}, {"key": "modifiers", "label": "\u624b\u518c\u4e2d\u7684\u540e\u7f00\u4fee\u9970\u7b26"}]}], "zh_from": {"kind": "same-version-chinese-manual-with-source-derived-identity", "manual": {"url": "/zh/docs/devel/app-psql.html#APP-PSQL-META-COMMAND-DX-UC", "anchor": "APP-PSQL-META-COMMAND-DX-UC", "locale": "zh-Hans", "version": "20", "build_id": 111, "page_key": "app-psql.html", "extraction": "exact-definition", "source_hash": "98935f3e8a333e7201e42b7315bb9e09d62e0711037964568c16bd22ae183680", "fragment_sha256": "8b08b61685bc6de781cd627955c0a569d5bf34503fd2a952eaa071e02aaab467", "source_revision": "sha256:49c73aa4c9cacef8ca979276a28ac416c08e9e54c9baee4ae5fd116a35fa13ac", "translation_revision": "git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:98c980963b401d40bd50df72b909e7523e3148b8fdb48edd897de2efb67e5235", "translated_from_revision": "sha256:49c73aa4c9cacef8ca979276a28ac416c08e9e54c9baee4ae5fd116a35fa13ac"}, "body_sha256": "991a0e637241e7943fe71cae3e4d5de042b6e193c10a8956b979f3b4affe5d3d", "runtime_rerun": false, "authored_translation": "source-derived-identity", "source_facts_revision": "3cd0885bb4eccdbaac1a21177cc639e9031e54bd8ea6536c45224b5563354ce2"}, "sections": [], "description_zh": "\u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 x \uff0c\u7ed3\u679c\u4f1a\u4ee5\u6269\u5c55\u6a21\u5f0f\u663e\u793a\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 + \uff0c\u5219\u6bcf\u4e2a\u5bf9\u8c61\u90fd\u4f1a\u8fde\u540c\u5176\u5173\u8054\u63cf\u8ff0\u4e00\u8d77\u5217\u51fa\u3002 \u6bcf\u79cd\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u7684\u72b6\u6001\u663e\u793a\u5728\u4ee5\u5176\u7edf\u8ba1\u7c7b\u578b\u547d\u540d\u7684\u5217\u4e2d\uff08\u4f8b\u5982 Ndistinct\uff09\u3002 defined \u8868\u793a\u5728\u521b\u5efa\u7edf\u8ba1\u4fe1\u606f\u65f6\u8bf7\u6c42\u4e86\u8be5\u4fe1\u606f\uff0cNULL \u8868\u793a\u672a\u8bf7\u6c42\u3002\u5982\u679c\u60f3\u77e5\u9053\u662f\u5426\u5df2\u7ecf\u8fd0\u884c\u4e86 ANALYZE \uff0c\u4ee5\u53ca\u8fd9\u4e9b\u7edf\u8ba1\u4fe1\u606f\u662f\u5426\u5df2\u7ecf\u5bf9\u89c4\u5212\u5668\u53ef\u7528\uff0c\u53ef\u4ee5\u67e5\u770b pg_stats_ext \u3002", "description_zh_html": "<p>psql \u547d\u4ee4 \\dX[x+] [ pattern ]\u3002</p><h3>\u540c\u7248\u672c\u4e2d\u6587\u624b\u518c\u5b9a\u4e49</h3><dd><p>\n        \u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 <em class=\"replaceable\"><code>pattern</code></em>\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 <code class=\"literal\">x</code>\uff0c\u7ed3\u679c\u4f1a\u4ee5\u6269\u5c55\u6a21\u5f0f\u663e\u793a\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 <code class=\"literal\">+</code>\uff0c\u5219\u6bcf\u4e2a\u5bf9\u8c61\u90fd\u4f1a\u8fde\u540c\u5176\u5173\u8054\u63cf\u8ff0\u4e00\u8d77\u5217\u51fa\u3002\n        </p><p>\n        \u6bcf\u79cd\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u7684\u72b6\u6001\u663e\u793a\u5728\u4ee5\u5176\u7edf\u8ba1\u7c7b\u578b\u547d\u540d\u7684\u5217\u4e2d\uff08\u4f8b\u5982 Ndistinct\uff09\u3002<code class=\"literal\">defined</code> \u8868\u793a\u5728\u521b\u5efa\u7edf\u8ba1\u4fe1\u606f\u65f6\u8bf7\u6c42\u4e86\u8be5\u4fe1\u606f\uff0cNULL \u8868\u793a\u672a\u8bf7\u6c42\u3002\u5982\u679c\u60f3\u77e5\u9053\u662f\u5426\u5df2\u7ecf\u8fd0\u884c\u4e86 <a class=\"link\" href=\"/zh/docs/devel/sql-analyze.html\"><code class=\"command\">ANALYZE</code></a>\uff0c\u4ee5\u53ca\u8fd9\u4e9b\u7edf\u8ba1\u4fe1\u606f\u662f\u5426\u5df2\u7ecf\u5bf9\u89c4\u5212\u5668\u53ef\u7528\uff0c\u53ef\u4ee5\u67e5\u770b <code class=\"structname\">pg_stats_ext</code>\u3002\n        </p></dd><p><a href=\"/zh/docs/devel/app-psql.html#APP-PSQL-META-COMMAND-DX-UC\">\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587</a>\u3002</p>"}, "summary": "\u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 x \uff0c\u7ed3\u679c\u4f1a\u4ee5\u6269\u5c55\u6a21\u5f0f\u663e\u793a\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 + \uff0c\u5219\u6bcf\u4e2a\u5bf9\u8c61\u90fd\u4f1a\u8fde\u540c\u5176\u5173\u8054\u63cf\u8ff0\u4e00\u8d77\u5217\u51fa\u3002 \u6bcf\u79cd\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u7684\u72b6\u6001\u663e\u793a\u5728\u4ee5\u5176\u7edf\u8ba1\u7c7b\u578b\u547d\u540d\u7684\u5217\u4e2d\uff08\u4f8b\u5982 Ndistinct\uff09\u3002 defined \u8868\u793a\u5728\u521b\u5efa\u7edf\u8ba1\u4fe1\u606f\u65f6\u8bf7\u6c42\u4e86\u8be5\u4fe1\u606f\uff0cNULL \u8868\u793a\u672a\u8bf7\u6c42\u3002\u5982\u679c\u60f3\u77e5\u9053\u662f\u5426\u5df2\u7ecf\u8fd0\u884c\u4e86 ANALYZE \uff0c\u4ee5\u53ca\u8fd9\u4e9b\u7edf\u8ba1\u4fe1\u606f\u662f\u5426\u5df2\u7ecf\u5bf9\u89c4\u5212\u5668\u53ef\u7528\uff0c\u53ef\u4ee5\u67e5\u770b pg_stats_ext \u3002", "version": "20", "link_map": {"/zh/docs/devel/sql-analyze.html": "/docs/devel/sql-analyze.html", "/zh/docs/devel/app-psql.html#APP-PSQL-META-COMMAND-DX-UC": "/docs/devel/app-psql.html#APP-PSQL-META-COMMAND-DX-UC"}, "body_html": "<p>psql \u547d\u4ee4 \\dX[x+] [ pattern ]\u3002</p><h3>\u540c\u7248\u672c\u4e2d\u6587\u624b\u518c\u5b9a\u4e49</h3><dd><p>\n        \u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 <em><code>pattern</code></em>\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 <code>x</code>\uff0c\u7ed3\u679c\u4f1a\u4ee5\u6269\u5c55\u6a21\u5f0f\u663e\u793a\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 <code>+</code>\uff0c\u5219\u6bcf\u4e2a\u5bf9\u8c61\u90fd\u4f1a\u8fde\u540c\u5176\u5173\u8054\u63cf\u8ff0\u4e00\u8d77\u5217\u51fa\u3002\n        </p><p>\n        \u6bcf\u79cd\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u7684\u72b6\u6001\u663e\u793a\u5728\u4ee5\u5176\u7edf\u8ba1\u7c7b\u578b\u547d\u540d\u7684\u5217\u4e2d\uff08\u4f8b\u5982 Ndistinct\uff09\u3002<code>defined</code> \u8868\u793a\u5728\u521b\u5efa\u7edf\u8ba1\u4fe1\u606f\u65f6\u8bf7\u6c42\u4e86\u8be5\u4fe1\u606f\uff0cNULL \u8868\u793a\u672a\u8bf7\u6c42\u3002\u5982\u679c\u60f3\u77e5\u9053\u662f\u5426\u5df2\u7ecf\u8fd0\u884c\u4e86 <a href=\"/zh/docs/devel/sql-analyze.html\" rel=\"nofollow\"><code>ANALYZE</code></a>\uff0c\u4ee5\u53ca\u8fd9\u4e9b\u7edf\u8ba1\u4fe1\u606f\u662f\u5426\u5df2\u7ecf\u5bf9\u89c4\u5212\u5668\u53ef\u7528\uff0c\u53ef\u4ee5\u67e5\u770b <code>pg_stats_ext</code>\u3002\n        </p></dd><p><a href=\"/zh/docs/devel/app-psql.html#APP-PSQL-META-COMMAND-DX-UC\" rel=\"nofollow\">\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587</a>\u3002</p>", "body_sha256": "6bde54bde1e9da6a4cd344328d9037cbb1fb6eb1b32c055c4f6ca38485b81115", "content_hash": "7bdf50e90f4cf347284f14fe472cc5129b3a480d7977da7a7837fefa5a43e3b3", "source_database": "center", "source_revision": "3cd0885bb4eccdbaac1a21177cc639e9031e54bd8ea6536c45224b5563354ce2"}, "modifiers": [{"command": "\\dX", "modifiers": "x+"}], "signature": "\\dX[x+] [ pattern ]", "spellings": ["\\dX"], "tables_zh": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-64-58/?v=20", "text": "\\dX"}, "modifiers": "x+"}], "title": "\u672c\u7248\u624b\u518c\u4e2d\u7684\u5199\u6cd5", "columns": [{"key": "command", "label": "\u547d\u4ee4"}, {"key": "modifiers", "label": "\u624b\u518c\u4e2d\u7684\u540e\u7f00\u4fee\u9970\u7b26"}]}], "description": ["\u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 x \uff0c\u7ed3\u679c\u4f1a\u4ee5\u6269\u5c55\u6a21\u5f0f\u663e\u793a\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 + \uff0c\u5219\u6bcf\u4e2a\u5bf9\u8c61\u90fd\u4f1a\u8fde\u540c\u5176\u5173\u8054\u63cf\u8ff0\u4e00\u8d77\u5217\u51fa\u3002 \u6bcf\u79cd\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u7684\u72b6\u6001\u663e\u793a\u5728\u4ee5\u5176\u7edf\u8ba1\u7c7b\u578b\u547d\u540d\u7684\u5217\u4e2d\uff08\u4f8b\u5982 Ndistinct\uff09\u3002 defined \u8868\u793a\u5728\u521b\u5efa\u7edf\u8ba1\u4fe1\u606f\u65f6\u8bf7\u6c42\u4e86\u8be5\u4fe1\u606f\uff0cNULL \u8868\u793a\u672a\u8bf7\u6c42\u3002\u5982\u679c\u60f3\u77e5\u9053\u662f\u5426\u5df2\u7ecf\u8fd0\u884c\u4e86 ANALYZE \uff0c\u4ee5\u53ca\u8fd9\u4e9b\u7edf\u8ba1\u4fe1\u606f\u662f\u5426\u5df2\u7ecf\u5bf9\u89c4\u5212\u5668\u53ef\u7528\uff0c\u53ef\u4ee5\u67e5\u770b pg_stats_ext \u3002"], "manual_html": "", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-DX-UC", "sections_zh": [], "localization": {"status": "complete", "sources": [{"url": "/docs/devel/app-psql.html", "method": "same-major semantic node", "sha256": "1590b6e290ad21fe3ac1c1549628841ae426d1cd07a8f808789207878dbee5ab", "language": "zh", "matched_nodes": ["#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[101]/p[0]"]}], "language": "zh", "original_text": {"/summary": "Lists extended statistics. If pattern is specified, only those extended statistics whose names match the pattern are listed. If x is appended to the command name, the results are displayed in expanded mode. If + is appended to the command name, each object is listed with its associated description.", "/category": "Describe database objects", "/versions/20/description/0": "Lists extended statistics. If pattern is specified, only those extended statistics whose names match the pattern are listed. If x is appended to the command name, the results are displayed in expanded mode. If + is appended to the command name, each object is listed with its associated description.", "/versions/20/facts/0/label": "Client", "/versions/20/facts/1/label": "Case-sensitive spelling", "/versions/20/tables/0/title": "Spellings in this manual definition", "/versions/20/related/0/label": "psql command-line options and complete manual", "/versions/20/tables/0/columns/0/label": "Command", "/versions/20/tables/0/columns/1/label": "Documented suffix modifiers"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "f50e6f6bc89ac8d8af093ca5369ac1b104cadc2e4187626c4f2346ce4170e98d", "canonical_center_text_hash": "7bdf50e90f4cf347284f14fe472cc5129b3a480d7977da7a7837fefa5a43e3b3"}, "description_zh": "\u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 x \uff0c\u7ed3\u679c\u4f1a\u4ee5\u6269\u5c55\u6a21\u5f0f\u663e\u793a\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 + \uff0c\u5219\u6bcf\u4e2a\u5bf9\u8c61\u90fd\u4f1a\u8fde\u540c\u5176\u5173\u8054\u63cf\u8ff0\u4e00\u8d77\u5217\u51fa\u3002 \u6bcf\u79cd\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u7684\u72b6\u6001\u663e\u793a\u5728\u4ee5\u5176\u7edf\u8ba1\u7c7b\u578b\u547d\u540d\u7684\u5217\u4e2d\uff08\u4f8b\u5982 Ndistinct\uff09\u3002 defined \u8868\u793a\u5728\u521b\u5efa\u7edf\u8ba1\u4fe1\u606f\u65f6\u8bf7\u6c42\u4e86\u8be5\u4fe1\u606f\uff0cNULL \u8868\u793a\u672a\u8bf7\u6c42\u3002\u5982\u679c\u60f3\u77e5\u9053\u662f\u5426\u5df2\u7ecf\u8fd0\u884c\u4e86 ANALYZE \uff0c\u4ee5\u53ca\u8fd9\u4e9b\u7edf\u8ba1\u4fe1\u606f\u662f\u5426\u5df2\u7ecf\u5bf9\u89c4\u5212\u5668\u53ef\u7528\uff0c\u53ef\u4ee5\u67e5\u770b pg_stats_ext \u3002", "comparison_data": {"modifiers": [{"command": "\\dX", "modifiers": "x+"}], "signature": "\\dX[x+] [ pattern ]", "spellings": ["\\dX"], "definition": "Lists extended statistics. If pattern is specified, only those extended statistics whose names match the pattern are listed. If x is appended to the command name, the results are displayed in expanded mode. If + is appended to the command name, each object is listed with its associated description. The status of each kind of extended statistics is shown in a column named after its statistic kind (e.g. Ndistinct). defined means that it was requested when creating the statistics, and NULL means it wasn't requested. You can use pg_stats_ext if you'd like to know whether ANALYZE was run and statistics are available to the planner."}, "comparison_hash": "00afe6616ae35df1d909e640e68a18c8a970fc23ef49baea45b10fd45fa6cabf", "manual_language": "zh", "description_zh_html": "<p>psql \u547d\u4ee4 \\dX[x+] [ pattern ]\u3002</p><h3>\u540c\u7248\u672c\u4e2d\u6587\u624b\u518c\u5b9a\u4e49</h3><dd><p>\n        \u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 <em><code>pattern</code></em>\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 <code>x</code>\uff0c\u7ed3\u679c\u4f1a\u4ee5\u6269\u5c55\u6a21\u5f0f\u663e\u793a\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 <code>+</code>\uff0c\u5219\u6bcf\u4e2a\u5bf9\u8c61\u90fd\u4f1a\u8fde\u540c\u5176\u5173\u8054\u63cf\u8ff0\u4e00\u8d77\u5217\u51fa\u3002\n        </p><p>\n        \u6bcf\u79cd\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u7684\u72b6\u6001\u663e\u793a\u5728\u4ee5\u5176\u7edf\u8ba1\u7c7b\u578b\u547d\u540d\u7684\u5217\u4e2d\uff08\u4f8b\u5982 Ndistinct\uff09\u3002<code>defined</code> \u8868\u793a\u5728\u521b\u5efa\u7edf\u8ba1\u4fe1\u606f\u65f6\u8bf7\u6c42\u4e86\u8be5\u4fe1\u606f\uff0cNULL \u8868\u793a\u672a\u8bf7\u6c42\u3002\u5982\u679c\u60f3\u77e5\u9053\u662f\u5426\u5df2\u7ecf\u8fd0\u884c\u4e86 <a href=\"/zh/docs/devel/sql-analyze.html\" rel=\"nofollow\"><code>ANALYZE</code></a>\uff0c\u4ee5\u53ca\u8fd9\u4e9b\u7edf\u8ba1\u4fe1\u606f\u662f\u5426\u5df2\u7ecf\u5bf9\u89c4\u5212\u5668\u53ef\u7528\uff0c\u53ef\u4ee5\u67e5\u770b <code>pg_stats_ext</code>\u3002\n        </p></dd><p><a href=\"/zh/docs/devel/app-psql.html#APP-PSQL-META-COMMAND-DX-UC\" rel=\"nofollow\">\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587</a>\u3002</p>", "source_revalidation": {"kind": "static-same-version-source-and-manual-replay", "audit": "wiki-audit-20261023", "runtime_rerun": false, "compared_fields": "entity membership and source-derived facts; presentation markup normalized", "source_revision": "3cd0885bb4eccdbaac1a21177cc639e9031e54bd8ea6536c45224b5563354ce2", "previous_source_revision": "2eba5e0fd4c3bffb2803247b6cd537878e9d6ee5a6dfbe3c50ece8b421b80918"}}}}, "snapshot": {"lang": "zh", "facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 18.7"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\dX"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-64-58/?v=18", "text": "\\dX"}, "modifiers": "x"}], "title": "\u672c\u7248\u624b\u518c\u4e2d\u7684\u5199\u6cd5", "columns": [{"key": "command", "label": "\u547d\u4ee4"}, {"key": "modifiers", "label": "\u624b\u518c\u4e2d\u7684\u540e\u7f00\u4fee\u9970\u7b26"}]}], "command": "\\dX", "related": [{"url": "/wiki/tool/psql/?v=18", "label": "psql \u547d\u4ee4\u884c\u9009\u9879\u53ca\u5b8c\u6574\u624b\u518c"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v18.7/postgresql-18.7.tar.bz2", "label": "18.7", "major": "18", "channel": "stable", "manifest": {"major": "18", "release": "18.7", "source_url": "https://ftp.postgresql.org/pub/source/v18.7/postgresql-18.7.tar.bz2", "source_sha256": "441dfae4280cae3e0425e5f876f80559fb0731c140f1aae22b3e5a54d0411bfd"}, "revision": "1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915", "evidence_kind": "English manual and source declarations", "source_sha256": "441dfae4280cae3e0425e5f876f80559fb0731c140f1aae22b3e5a54d0411bfd"}, "sources": [{"url": "/docs/18/app-psql.html#APP-PSQL-META-COMMAND-DX-UC", "file": "app-psql.html", "label": "18.7 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-DX-UC", "sha256": "af50448485df02bdef2b72b8347192ba029c7082b8d0392ecb17db44ad533aaf"}], "zh_from": "same-version-manual", "facts_zh": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 18.7"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\dX"}], "sections": [], "center_zh": {"locale": "zh-Hans", "payload": {"description_zh": "\u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 x \uff0c\u7ed3\u679c\u4f1a\u4ee5\u6269\u5c55\u6a21\u5f0f\u663e\u793a\u3002", "description_zh_html": "<dd><p>\n        \u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 <em class=\"replaceable\"><code>pattern</code></em>\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 <code class=\"literal\">x</code>\uff0c\u7ed3\u679c\u4f1a\u4ee5\u6269\u5c55\u6a21\u5f0f\u663e\u793a\u3002\n        </p><p>\n        \u6bcf\u79cd\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u7684\u72b6\u6001\u663e\u793a\u5728\u4ee5\u5176\u7edf\u8ba1\u7c7b\u578b\u547d\u540d\u7684\u5217\u4e2d\uff08\u4f8b\u5982 Ndistinct\uff09\u3002<code class=\"literal\">defined</code> \u8868\u793a\u5728\u521b\u5efa\u7edf\u8ba1\u4fe1\u606f\u65f6\u8bf7\u6c42\u4e86\u8be5\u4fe1\u606f\uff0cNULL \u8868\u793a\u672a\u8bf7\u6c42\u3002\u5982\u679c\u60f3\u77e5\u9053\u662f\u5426\u5df2\u7ecf\u8fd0\u884c\u4e86 <a class=\"link\" href=\"/docs/18/sql-analyze.html\" title=\"ANALYZE\"><code class=\"command\">ANALYZE</code></a>\uff0c\u4ee5\u53ca\u8fd9\u4e9b\u7edf\u8ba1\u4fe1\u606f\u662f\u5426\u5df2\u7ecf\u5bf9\u89c4\u5212\u5668\u53ef\u7528\uff0c\u53ef\u4ee5\u67e5\u770b <code class=\"structname\">pg_stats_ext</code>\u3002\n        </p></dd>"}, "summary": "\u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 x \uff0c\u7ed3\u679c\u4f1a\u4ee5\u6269\u5c55\u6a21\u5f0f\u663e\u793a\u3002", "body_html": "<dd><p>\n        \u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 <em class=\"replaceable\"><code>pattern</code></em>\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 <code class=\"literal\">x</code>\uff0c\u7ed3\u679c\u4f1a\u4ee5\u6269\u5c55\u6a21\u5f0f\u663e\u793a\u3002\n        </p><p>\n        \u6bcf\u79cd\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u7684\u72b6\u6001\u663e\u793a\u5728\u4ee5\u5176\u7edf\u8ba1\u7c7b\u578b\u547d\u540d\u7684\u5217\u4e2d\uff08\u4f8b\u5982 Ndistinct\uff09\u3002<code class=\"literal\">defined</code> \u8868\u793a\u5728\u521b\u5efa\u7edf\u8ba1\u4fe1\u606f\u65f6\u8bf7\u6c42\u4e86\u8be5\u4fe1\u606f\uff0cNULL \u8868\u793a\u672a\u8bf7\u6c42\u3002\u5982\u679c\u60f3\u77e5\u9053\u662f\u5426\u5df2\u7ecf\u8fd0\u884c\u4e86 <a class=\"link\" href=\"/docs/18/sql-analyze.html\" title=\"ANALYZE\"><code class=\"command\">ANALYZE</code></a>\uff0c\u4ee5\u53ca\u8fd9\u4e9b\u7edf\u8ba1\u4fe1\u606f\u662f\u5426\u5df2\u7ecf\u5bf9\u89c4\u5212\u5668\u53ef\u7528\uff0c\u53ef\u4ee5\u67e5\u770b <code class=\"structname\">pg_stats_ext</code>\u3002\n        </p></dd>", "body_sha256": "5c02a3c2bd93c5a4af5579da7c6b1a5e7327ae2d9258f1154ccfb3ab885de7fc", "content_hash": "fd963885ef38ae9af45cdb7fdcf8d804887e63542aae368eafb98ab99b446b34", "source_revision": "pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552", "definition_version": "18", "documentation_release": "18.7"}, "modifiers": [{"command": "\\dX", "modifiers": "x"}], "signature": "\\dX[x] [ pattern ]", "spellings": ["\\dX"], "tables_zh": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-64-58/?v=18", "text": "\\dX"}, "modifiers": "x"}], "title": "\u672c\u7248\u624b\u518c\u4e2d\u7684\u5199\u6cd5", "columns": [{"key": "command", "label": "\u547d\u4ee4"}, {"key": "modifiers", "label": "\u624b\u518c\u4e2d\u7684\u540e\u7f00\u4fee\u9970\u7b26"}]}], "related_zh": [{"url": "/wiki/tool/psql/?v=18", "label": "psql \u547d\u4ee4\u884c\u9009\u9879\u53ca\u5b8c\u6574\u624b\u518c"}], "description": ["\u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 x \uff0c\u7ed3\u679c\u4f1a\u4ee5\u6269\u5c55\u6a21\u5f0f\u663e\u793a\u3002"], "manual_html": "<dd><p>\n        \u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 <em class=\"replaceable\"><code>pattern</code></em>\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 <code class=\"literal\">x</code>\uff0c\u7ed3\u679c\u4f1a\u4ee5\u6269\u5c55\u6a21\u5f0f\u663e\u793a\u3002\n        </p><p>\n        \u6bcf\u79cd\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u7684\u72b6\u6001\u663e\u793a\u5728\u4ee5\u5176\u7edf\u8ba1\u7c7b\u578b\u547d\u540d\u7684\u5217\u4e2d\uff08\u4f8b\u5982 Ndistinct\uff09\u3002<code class=\"literal\">defined</code> \u8868\u793a\u5728\u521b\u5efa\u7edf\u8ba1\u4fe1\u606f\u65f6\u8bf7\u6c42\u4e86\u8be5\u4fe1\u606f\uff0cNULL \u8868\u793a\u672a\u8bf7\u6c42\u3002\u5982\u679c\u60f3\u77e5\u9053\u662f\u5426\u5df2\u7ecf\u8fd0\u884c\u4e86 <a class=\"link\" href=\"/docs/18/sql-analyze.html\" title=\"ANALYZE\"><code class=\"command\">ANALYZE</code></a>\uff0c\u4ee5\u53ca\u8fd9\u4e9b\u7edf\u8ba1\u4fe1\u606f\u662f\u5426\u5df2\u7ecf\u5bf9\u89c4\u5212\u5668\u53ef\u7528\uff0c\u53ef\u4ee5\u67e5\u770b <code class=\"structname\">pg_stats_ext</code>\u3002\n        </p></dd>", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-DX-UC", "sections_zh": [], "localization": {"status": "same-version-reviewed-manual", "language": "zh", "source_language": "en", "source_revision": "pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552", "documentation_release": "18.7"}, "description_zh": "\u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 x \uff0c\u7ed3\u679c\u4f1a\u4ee5\u6269\u5c55\u6a21\u5f0f\u663e\u793a\u3002", "comparison_data": {"modifiers": [{"command": "\\dX", "modifiers": "x"}], "signature": "\\dX[x] [ pattern ]", "spellings": ["\\dX"], "definition": "Lists extended statistics. If pattern is specified, only those extended statistics whose names match the pattern are listed. If x is appended to the command name, the results are displayed in expanded mode. The status of each kind of extended statistics is shown in a column named after its statistic kind (e.g. Ndistinct). defined means that it was requested when creating the statistics, and NULL means it wasn't requested. You can use pg_stats_ext if you'd like to know whether ANALYZE was run and statistics are available to the planner."}, "comparison_hash": "7d57c7a90cc5537c52b133cd7775b49b853bbfdfb4f13def0a7a596b42b3ae29", "manual_language": "zh", "description_zh_html": "<dd><p>\n        \u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 <em class=\"replaceable\"><code>pattern</code></em>\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 <code class=\"literal\">x</code>\uff0c\u7ed3\u679c\u4f1a\u4ee5\u6269\u5c55\u6a21\u5f0f\u663e\u793a\u3002\n        </p><p>\n        \u6bcf\u79cd\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u7684\u72b6\u6001\u663e\u793a\u5728\u4ee5\u5176\u7edf\u8ba1\u7c7b\u578b\u547d\u540d\u7684\u5217\u4e2d\uff08\u4f8b\u5982 Ndistinct\uff09\u3002<code class=\"literal\">defined</code> \u8868\u793a\u5728\u521b\u5efa\u7edf\u8ba1\u4fe1\u606f\u65f6\u8bf7\u6c42\u4e86\u8be5\u4fe1\u606f\uff0cNULL \u8868\u793a\u672a\u8bf7\u6c42\u3002\u5982\u679c\u60f3\u77e5\u9053\u662f\u5426\u5df2\u7ecf\u8fd0\u884c\u4e86 <a class=\"link\" href=\"/docs/18/sql-analyze.html\" title=\"ANALYZE\"><code class=\"command\">ANALYZE</code></a>\uff0c\u4ee5\u53ca\u8fd9\u4e9b\u7edf\u8ba1\u4fe1\u606f\u662f\u5426\u5df2\u7ecf\u5bf9\u89c4\u5212\u5668\u53ef\u7528\uff0c\u53ef\u4ee5\u67e5\u770b <code class=\"structname\">pg_stats_ext</code>\u3002\n        </p></dd>", "documentation_revision": {"inputs": [{"file": "app-psql.html", "kind": "same-version-reviewed-manual", "locale": "en", "sha256": "af50448485df02bdef2b72b8347192ba029c7082b8d0392ecb17db44ad533aaf", "version": "18.7"}, {"file": "app-psql.html", "kind": "same-version-reviewed-manual", "locale": "zh-Hans", "sha256": "cb475c53a16d9e06358f5e6c9c5649645db92568cfd319f230c62c9f57ae090b", "version": "18.7"}], "release": "18.7", "source_revision": "pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552", "runtime_remeasured": false}, "center_zh_rendered": "<dl><dd><p>\n        \u5217\u51fa\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u6307\u5b9a\u4e86 <em class=\"replaceable\"><code>pattern</code></em>\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 <code class=\"literal\">x</code>\uff0c\u7ed3\u679c\u4f1a\u4ee5\u6269\u5c55\u6a21\u5f0f\u663e\u793a\u3002\n        </p><p>\n        \u6bcf\u79cd\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u7684\u72b6\u6001\u663e\u793a\u5728\u4ee5\u5176\u7edf\u8ba1\u7c7b\u578b\u547d\u540d\u7684\u5217\u4e2d\uff08\u4f8b\u5982 Ndistinct\uff09\u3002<code class=\"literal\">defined</code> \u8868\u793a\u5728\u521b\u5efa\u7edf\u8ba1\u4fe1\u606f\u65f6\u8bf7\u6c42\u4e86\u8be5\u4fe1\u606f\uff0cNULL \u8868\u793a\u672a\u8bf7\u6c42\u3002\u5982\u679c\u60f3\u77e5\u9053\u662f\u5426\u5df2\u7ecf\u8fd0\u884c\u4e86 <a class=\"link\" href=\"/docs/18/sql-analyze.html\" title=\"ANALYZE\"><code class=\"command\">ANALYZE</code></a>\uff0c\u4ee5\u53ca\u8fd9\u4e9b\u7edf\u8ba1\u4fe1\u606f\u662f\u5426\u5df2\u7ecf\u5bf9\u89c4\u5212\u5668\u53ef\u7528\uff0c\u53ef\u4ee5\u67e5\u770b <code class=\"structname\">pg_stats_ext</code>\u3002\n        </p></dd></dl>"}, "comparison": {"left": "13", "right": "14", "status": "added", "diff": "--- PostgreSQL 13\n+++ PostgreSQL 14\n@@ -1 +1,8 @@\n-\u8be5\u7248\u672a\u6536\u5f55\n+{\n+  \"definition\": \"Lists extended statistics. If pattern is specified, only those extended statistics whose names match the pattern are listed. The status of each kind of extended statistics is shown in a column named after its statistic kind (e.g. Ndistinct). defined means that it was requested when creating the statistics, and NULL means it wasn't requested. You can use pg_stats_ext if you'd like to know whether ANALYZE was run and statistics are available to the planner.\",\n+  \"modifiers\": [],\n+  \"signature\": \"\\\\dX [ pattern ]\",\n+  \"spellings\": [\n+    \"\\\\dX\"\n+  ]\n+}"}}