{"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": "8fac407c29be415633be600d30eaa33e1f4262e1eafa982d4a03823d050a5656", "versions": {"14": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 14.24"}, {"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.24/postgresql-14.24.tar.bz2", "label": "14.24", "major": "14", "channel": "stable", "manifest": {"pdf": {"A4": {"url": "/files/documentation/pdf/14/postgresql-14-A4.pdf", "bytes": 14354704, "pages": 2944, "sha256": "8bc6b9dd7b246888bb77f0a5e8c39a2eae52e9926569832669c7d1600becb27c", "built_at": "2026-09-26"}, "US": {"url": "/files/documentation/pdf/14/postgresql-14-US.pdf", "bytes": 14242178, "pages": 3102, "sha256": "b7ecb5a5f62d8b9f73a69e25a7d26ba285373bc53168a553bff7b77955506db4", "built_at": "2026-09-26"}}, "tree": "14", "index": "index.html", "major": "14", "pages": 1158, "release": "14.24", "source_url": "https://ftp.postgresql.org/pub/source/v14.24/postgresql-14.24.tar.bz2", "svg_assets": 3, "source_mode": "en HTML verified against the pinned official archive", "source_sha256": "a7fa7ed3d558172355f51406097a7bd4f6b473be80f311ef7cda96bf383d8897"}, "revision": "588700d46356d8837c77c7c0a4e71e645fe6535983b8f1830aa8f2e4e41c40ae", "evidence_kind": "English manual and source declarations", "source_sha256": "a7fa7ed3d558172355f51406097a7bd4f6b473be80f311ef7cda96bf383d8897"}, "sources": [{"url": "https://pg.center/docs/14/app-psql.html#APP-PSQL-META-COMMANDS", "file": "app-psql.html", "label": "14.24 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMANDS", "sha256": "8da20abaee171c53c05658cfb2580dea645070f40bad6b46a845d710ad74c3ae", "language": "en", "original_url": "/docs/14/app-psql.html#APP-PSQL-META-COMMANDS"}], "sections": [], "modifiers": [], "signature": "\\dX [ pattern ]", "spellings": ["\\dX"], "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": "
\\dX [ pattern ]
\n

\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

\n

\u6bcf\u79cd\u6269\u5c55\u7edf\u8ba1\u7684\u72b6\u6001\u663e\u793a\u5728\u4ee5\u7edf\u8ba1\u79cd\u7c7b\u547d\u540d\u7684\u5217\u4e2d\uff0c\u4f8b\u5982 Ndistinct\u3002defined \u8868\u793a\u521b\u5efa\u7edf\u8ba1\u65f6\u8bf7\u6c42\u4e86\u8be5\u7edf\u8ba1\uff0cNULL \u8868\u793a\u672a\u8bf7\u6c42\u3002\u82e5\u8981\u5224\u65ad ANALYZE \u662f\u5426\u8fd0\u884c\u8fc7\u3001\u7edf\u8ba1\u662f\u5426\u53ef\u4f9b\u89c4\u5212\u5668\u4f7f\u7528\uff0c\u53ef\u67e5\u8be2 pg_stats_ext\u3002

\n
", "manual_path": "app-psql.html#APP-PSQL-META-COMMANDS", "localization": {"status": "complete", "sources": [{"url": "/docs/14/app-psql.html", "method": "same-major semantic node", "sha256": "11c74f85ef9d2c9b3921e0c622d69dd3f1b3ed0c916197a94ddab5540153e310", "language": "zh", "matched_nodes": ["#APP-PSQL/div[7]/div[3]/div[10]/dl[0]/dd[91]/p[0]"]}], "language": "zh", "original_text": {"/versions/14/description/0": "Lists extended statistics. If pattern is specified, only those extended statistics whose names match the pattern are listed.", "/versions/14/facts/0/label": "Client", "/versions/14/facts/1/label": "Case-sensitive spelling", "/versions/14/tables/0/title": "Spellings in this manual definition", "/versions/14/related/0/label": "psql command-line options and complete manual", "/versions/14/tables/0/columns/0/label": "Command", "/versions/14/tables/0/columns/1/label": "Documented suffix modifiers", "/versions/14/tables/0/rows/0/modifiers": "None listed in this signature"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "f6033dffeb18d4a74b42f73c1cda36455fd0763821539893bd04cdb288a23125"}, "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"}, "15": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 15.19"}, {"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.19/postgresql-15.19.tar.bz2", "label": "15.19", "major": "15", "channel": "stable", "manifest": {"pdf": {"A4": {"url": "/files/documentation/pdf/15/postgresql-15-A4.pdf", "bytes": 14609140, "pages": 2987, "sha256": "66228564a4d16efb47d6a914085716ecfe22ca1566db56bc7c3d82f790646d72", "built_at": "2026-09-26"}, "US": {"url": "/files/documentation/pdf/15/postgresql-15-US.pdf", "bytes": 14495690, "pages": 3153, "sha256": "645a498c2390d47a6223ec74770631185807a19c484edb0fc5a295d9f460bc02", "built_at": "2026-09-26"}}, "tree": "15", "index": "index.html", "major": "15", "pages": 1168, "release": "15.19", "source_url": "https://ftp.postgresql.org/pub/source/v15.19/postgresql-15.19.tar.bz2", "svg_assets": 3, "source_mode": "en HTML verified against the pinned official archive", "source_sha256": "e1a64a87a46b825b88c082e4518161a47aab53c45694964f8ba1df28f7859f89"}, "revision": "6af958c6520151fc7697d56e0616b03fb00522c4568158674d452ae0644ba545", "evidence_kind": "English manual and source declarations", "source_sha256": "e1a64a87a46b825b88c082e4518161a47aab53c45694964f8ba1df28f7859f89"}, "sources": [{"url": "https://pg.center/docs/15/app-psql.html#APP-PSQL-META-COMMANDS", "file": "app-psql.html", "label": "15.19 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMANDS", "sha256": "cb07228edb4914a53530afca316fd700a250cc062af2d5a74d24add93afbd0c8", "language": "en", "original_url": "/docs/15/app-psql.html#APP-PSQL-META-COMMANDS"}], "sections": [], "modifiers": [], "signature": "\\dX [ pattern ]", "spellings": ["\\dX"], "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": "
\\dX [ pattern ]
\n

\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

\n

\u6bcf\u79cd\u6269\u5c55\u7edf\u8ba1\u7684\u72b6\u6001\u663e\u793a\u5728\u4ee5\u7edf\u8ba1\u79cd\u7c7b\u547d\u540d\u7684\u5217\u4e2d\uff0c\u4f8b\u5982 Ndistinct\u3002defined \u8868\u793a\u521b\u5efa\u7edf\u8ba1\u65f6\u8bf7\u6c42\u4e86\u8be5\u7edf\u8ba1\uff0cNULL \u8868\u793a\u672a\u8bf7\u6c42\u3002\u82e5\u8981\u5224\u65ad ANALYZE \u662f\u5426\u8fd0\u884c\u8fc7\u3001\u7edf\u8ba1\u662f\u5426\u53ef\u4f9b\u89c4\u5212\u5668\u4f7f\u7528\uff0c\u53ef\u67e5\u8be2 pg_stats_ext\u3002

\n
", "manual_path": "app-psql.html#APP-PSQL-META-COMMANDS", "localization": {"status": "complete", "sources": [{"url": "/docs/15/app-psql.html", "method": "same-major semantic node", "sha256": "8d6ed2e3400192f466dca73fd9423e91b9ede916fe0981b7e0cd42bc091394d2", "language": "zh", "matched_nodes": ["#APP-PSQL/div[7]/div[3]/div[10]/dl[0]/dd[93]/p[0]"]}], "language": "zh", "original_text": {"/versions/15/description/0": "Lists extended statistics. If pattern is specified, only those extended statistics whose names match the pattern are listed.", "/versions/15/facts/0/label": "Client", "/versions/15/facts/1/label": "Case-sensitive spelling", "/versions/15/tables/0/title": "Spellings in this manual definition", "/versions/15/related/0/label": "psql command-line options and complete manual", "/versions/15/tables/0/columns/0/label": "Command", "/versions/15/tables/0/columns/1/label": "Documented suffix modifiers", "/versions/15/tables/0/rows/0/modifiers": "None listed in this signature"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "3cb724a96fc2bf96c640bb8ca5546de1ad24b637873f4dcda05333f1d5bd72eb"}, "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"}, "16": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 16.15"}, {"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.15/postgresql-16.15.tar.bz2", "label": "16.15", "major": "16", "channel": "stable", "manifest": {"pdf": {"A4": {"url": "/files/documentation/pdf/16/postgresql-16-A4.pdf", "bytes": 15282337, "pages": 3055, "sha256": "4bb6c1f63deedac98736d8c4c7bc0fad0ac24e85b07e21ee10411872f06afd06", "built_at": "2026-09-26"}, "US": {"url": "/files/documentation/pdf/16/postgresql-16-US.pdf", "bytes": 15164148, "pages": 3220, "sha256": "5b6b6166c89991199e144bb0ae34c17a5f29826251dbf19db1abc0df3a3e771b", "built_at": "2026-09-26"}}, "tree": "16", "index": "index.html", "major": "16", "pages": 1169, "release": "16.15", "source_url": "https://ftp.postgresql.org/pub/source/v16.15/postgresql-16.15.tar.bz2", "svg_assets": 3, "source_mode": "en HTML verified against the pinned official archive", "source_sha256": "c1575341fa7bd40f5274ea465b34390f4dc64cdd0770af327005caaeb9f6b7ed"}, "revision": "3c21e58b35318021716440e67bb8bafd392b6a2b965a244d90e9e33c99e0bdef", "evidence_kind": "English manual and source declarations", "source_sha256": "c1575341fa7bd40f5274ea465b34390f4dc64cdd0770af327005caaeb9f6b7ed"}, "sources": [{"url": "https://pg.center/docs/16/app-psql.html#APP-PSQL-META-COMMAND-DX-UC", "file": "app-psql.html", "label": "16.15 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-DX-UC", "sha256": "add25957a1dfc97db721f2958782be186ab90dc0f0a47c4b720b2b6c26172493", "language": "en", "original_url": "/docs/16/app-psql.html#APP-PSQL-META-COMMAND-DX-UC"}], "sections": [], "modifiers": [], "signature": "\\dX [ pattern ]", "spellings": ["\\dX"], "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": "
\\dX [ pattern ]
\n

\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

\n

\u6bcf\u79cd\u6269\u5c55\u7edf\u8ba1\u7684\u72b6\u6001\u663e\u793a\u5728\u4ee5\u7edf\u8ba1\u79cd\u7c7b\u547d\u540d\u7684\u5217\u4e2d\uff0c\u4f8b\u5982 Ndistinct\u3002defined \u8868\u793a\u521b\u5efa\u7edf\u8ba1\u65f6\u8bf7\u6c42\u4e86\u8be5\u7edf\u8ba1\uff0cNULL \u8868\u793a\u672a\u8bf7\u6c42\u3002\u82e5\u8981\u5224\u65ad ANALYZE \u662f\u5426\u8fd0\u884c\u8fc7\u3001\u7edf\u8ba1\u662f\u5426\u53ef\u4f9b\u89c4\u5212\u5668\u4f7f\u7528\uff0c\u53ef\u67e5\u8be2 pg_stats_ext\u3002

\n
", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-DX-UC", "localization": {"status": "complete", "sources": [{"url": "/docs/16/app-psql.html", "method": "same-major semantic node", "sha256": "72833cd861534255277e73a650a16ab07f11c38db9df980213b8335751a3273d", "language": "zh", "matched_nodes": ["#APP-PSQL/div[7]/div[3]/div[10]/dl[0]/dd[97]/p[0]"]}], "language": "zh", "original_text": {"/versions/16/description/0": "Lists extended statistics. If pattern is specified, only those extended statistics whose names match the pattern are listed.", "/versions/16/facts/0/label": "Client", "/versions/16/facts/1/label": "Case-sensitive spelling", "/versions/16/tables/0/title": "Spellings in this manual definition", "/versions/16/related/0/label": "psql command-line options and complete manual", "/versions/16/tables/0/columns/0/label": "Command", "/versions/16/tables/0/columns/1/label": "Documented suffix modifiers", "/versions/16/tables/0/rows/0/modifiers": "None listed in this signature"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "9e36c48c9ee7dbe91c1b1c8e951f490a629d9e997833c838d98434c583da5e77"}, "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"}, "17": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 17.11"}, {"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.11/postgresql-17.11.tar.bz2", "label": "17.11", "major": "17", "channel": "stable", "manifest": {"pdf": {"A4": {"url": "/files/documentation/pdf/17/postgresql-17-A4.pdf", "bytes": 15521293, "pages": 3099, "sha256": "1991354df0dc89e70ec39328c28988ef8b19c6a93671dab3893650b63e9f4e36", "built_at": "2026-09-26"}, "US": {"url": "/files/documentation/pdf/17/postgresql-17-US.pdf", "bytes": 15398150, "pages": 3270, "sha256": "07696c8f38abf31babf22d2db337093936e7c472d2af36d050b000c49bbcf52c", "built_at": "2026-09-26"}}, "tree": "17", "index": "index.html", "major": "17", "pages": 1143, "release": "17.11", "source_url": "https://ftp.postgresql.org/pub/source/v17.11/postgresql-17.11.tar.bz2", "svg_assets": 3, "source_mode": "en SGML built with pinned official archive", "source_sha256": "dd27f2b3c59e73ed14aa3324901242bf69a032a6347805f274e6260322d42979"}, "revision": "58419c9b0dd42cb34c8d53695bb025a7e582edf55ccd4c5bcb1c2c7c71a37487", "evidence_kind": "English manual and source declarations", "source_sha256": "dd27f2b3c59e73ed14aa3324901242bf69a032a6347805f274e6260322d42979"}, "sources": [{"url": "https://pg.center/docs/17/app-psql.html#APP-PSQL-META-COMMAND-DX-UC", "file": "app-psql.html", "label": "17.11 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-DX-UC", "sha256": "04c77661f1c96a64e91a27313542c34aff0c7d2a94e350ed98c6f9f35700629b", "language": "en", "original_url": "/docs/17/app-psql.html#APP-PSQL-META-COMMAND-DX-UC"}], "sections": [], "modifiers": [], "signature": "\\dX [ pattern ]", "spellings": ["\\dX"], "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": "
\\dX [ pattern ]
\n

\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

\n

\u6bcf\u79cd\u6269\u5c55\u7edf\u8ba1\u7684\u72b6\u6001\u663e\u793a\u5728\u4ee5\u7edf\u8ba1\u79cd\u7c7b\u547d\u540d\u7684\u5217\u4e2d\uff0c\u4f8b\u5982 Ndistinct\u3002defined \u8868\u793a\u521b\u5efa\u7edf\u8ba1\u65f6\u8bf7\u6c42\u4e86\u8be5\u7edf\u8ba1\uff0cNULL \u8868\u793a\u672a\u8bf7\u6c42\u3002\u82e5\u8981\u5224\u65ad ANALYZE \u662f\u5426\u8fd0\u884c\u8fc7\u3001\u7edf\u8ba1\u662f\u5426\u53ef\u4f9b\u89c4\u5212\u5668\u4f7f\u7528\uff0c\u53ef\u67e5\u8be2 pg_stats_ext\u3002

\n
", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-DX-UC", "localization": {"status": "complete", "sources": [{"url": "/docs/17/app-psql.html", "method": "same-major semantic node", "sha256": "820a5ee48a79666cef06bfe375ea9337e7a347b6d32c921738edd824fe5aa9f8", "language": "zh", "matched_nodes": ["#APP-PSQL/div[7]/div[3]/div[10]/dl[0]/dd[97]/p[0]"]}], "language": "zh", "original_text": {"/versions/17/description/0": "Lists extended statistics. If pattern is specified, only those extended statistics whose names match the pattern are listed.", "/versions/17/facts/0/label": "Client", "/versions/17/facts/1/label": "Case-sensitive spelling", "/versions/17/tables/0/title": "Spellings in this manual definition", "/versions/17/related/0/label": "psql command-line options and complete manual", "/versions/17/tables/0/columns/0/label": "Command", "/versions/17/tables/0/columns/1/label": "Documented suffix modifiers", "/versions/17/tables/0/rows/0/modifiers": "None listed in this signature"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "724ab30997e55ee2cdbaa69edd677a94521ace84bf1cec3a6f6308cdc7b51516"}, "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"}, "18": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 18.6"}, {"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.6/postgresql-18.6.tar.bz2", "label": "18.6", "major": "18", "channel": "stable", "manifest": {"pdf": {"A4": {"url": "/files/documentation/pdf/18/postgresql-18-A4.pdf", "bytes": 15865106, "pages": 3154, "sha256": "19512c405da53f9f7fcf0abba359223aa65f021be025bf3411381918f92e3190", "built_at": "2026-09-26"}, "US": {"url": "/files/documentation/pdf/18/postgresql-18-US.pdf", "bytes": 15748059, "pages": 3328, "sha256": "facbe6c229e598b872d3d98bef53308f46e06746006fa4590de9a7de9dd46319", "built_at": "2026-09-26"}}, "tree": "18", "index": "index.html", "major": "18", "pages": 1148, "release": "18.6", "source_url": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "svg_assets": 3, "source_mode": "en SGML built with pinned official archive", "source_sha256": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "revision": "ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8", "evidence_kind": "English manual and source declarations", "source_sha256": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "sources": [{"url": "https://pg.center/docs/18/app-psql.html#APP-PSQL-META-COMMAND-DX-UC", "file": "app-psql.html", "label": "18.6 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-DX-UC", "sha256": "fa2a1d39294b8854318e82e93f71272c645ed88150ecc2786c28902c3f32782c", "language": "en", "original_url": "/docs/18/app-psql.html#APP-PSQL-META-COMMAND-DX-UC"}], "sections": [], "modifiers": [{"command": "\\dX", "modifiers": "x"}], "signature": "\\dX[x] [ pattern ]", "spellings": ["\\dX"], "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": "
\\dX[x] [ pattern ]
\n

\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

\n

\u6bcf\u79cd\u6269\u5c55\u7edf\u8ba1\u7684\u72b6\u6001\u663e\u793a\u5728\u4ee5\u7edf\u8ba1\u79cd\u7c7b\u547d\u540d\u7684\u5217\u4e2d\uff0c\u4f8b\u5982 Ndistinct\u3002defined \u8868\u793a\u521b\u5efa\u7edf\u8ba1\u65f6\u8bf7\u6c42\u4e86\u8be5\u7edf\u8ba1\uff0cNULL \u8868\u793a\u672a\u8bf7\u6c42\u3002\u82e5\u8981\u5224\u65ad ANALYZE \u662f\u5426\u8fd0\u884c\u8fc7\u3001\u7edf\u8ba1\u662f\u5426\u53ef\u4f9b\u89c4\u5212\u5668\u4f7f\u7528\uff0c\u53ef\u67e5\u8be2 pg_stats_ext\u3002

\n
", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-DX-UC", "localization": {"status": "complete", "sources": [{"url": "/docs/18/app-psql.html", "method": "same-major semantic node", "sha256": "4ff5633229e0afa7feecc2750a7187d2d45a7eef0ca8febc73e4e5c15ac7fa6d", "language": "zh", "matched_nodes": ["#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[101]/p[0]"]}], "language": "zh", "original_text": {"/versions/18/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.", "/versions/18/facts/0/label": "Client", "/versions/18/facts/1/label": "Case-sensitive spelling", "/versions/18/tables/0/title": "Spellings in this manual definition", "/versions/18/related/0/label": "psql command-line options and complete manual", "/versions/18/tables/0/columns/0/label": "Command", "/versions/18/tables/0/columns/1/label": "Documented suffix modifiers"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "d99ed25d5f9178379c7fb080a4eff424394886f2218be37b96ff54603a64317c"}, "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"}, "19": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 19beta4"}, {"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/v19beta4/postgresql-19beta4.tar.bz2", "label": "19beta4", "major": "19", "channel": "preview", "manifest": {"pdf": {"A4": {"url": "/files/documentation/pdf/19/postgresql-19-A4.pdf", "bytes": 16064841, "pages": 3052, "sha256": "4dd099e4125c591128fc5f3ebd02178dc24781f9e5ae629f96d67c4c8547427b", "built_at": "2026-09-26"}, "US": {"url": "/files/documentation/pdf/19/postgresql-19-US.pdf", "bytes": 15974616, "pages": 3225, "sha256": "61971fa857f0956d47341a0388fa6af9ae10acf691d4b2fc009007d384b0342b", "built_at": "2026-09-26"}}, "tree": "19", "index": "index.html", "major": "19", "pages": 1155, "release": "19beta4", "source_url": "https://ftp.postgresql.org/pub/source/v19beta4/postgresql-19beta4.tar.bz2", "svg_assets": 5, "source_mode": "en SGML built with pinned official archive", "source_sha256": "83157ee9c599d03b2f7a3d73ef3a56ec24e0e79cc2b3501a64d1364f56398c86"}, "revision": "1bbbbf4133d426f0e4304010688d2984c30fb67df0cc3a61b3e37eb3f6f37833", "evidence_kind": "English manual and source declarations", "source_sha256": "83157ee9c599d03b2f7a3d73ef3a56ec24e0e79cc2b3501a64d1364f56398c86"}, "sources": [{"url": "https://pg.center/docs/19/app-psql.html#APP-PSQL-META-COMMAND-DX-UC", "file": "app-psql.html", "label": "19beta4 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-DX-UC", "sha256": "312975c12d6e4d62aeebcb5e98e7ca795c6d07ecb743b4bc64403dc42bc2a6e9", "language": "en", "original_url": "/docs/19/app-psql.html#APP-PSQL-META-COMMAND-DX-UC"}], "sections": [], "modifiers": [{"command": "\\dX", "modifiers": "x+"}], "signature": "\\dX[x+] [ pattern ]", "spellings": ["\\dX"], "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": "
\\dX[x+] [ pattern ]
\n

\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

\n

\u6bcf\u79cd\u6269\u5c55\u7edf\u8ba1\u7684\u72b6\u6001\u663e\u793a\u5728\u4ee5\u7edf\u8ba1\u79cd\u7c7b\u547d\u540d\u7684\u5217\u4e2d\uff0c\u4f8b\u5982 Ndistinct\u3002defined \u8868\u793a\u521b\u5efa\u7edf\u8ba1\u65f6\u8bf7\u6c42\u4e86\u8be5\u7edf\u8ba1\uff0cNULL \u8868\u793a\u672a\u8bf7\u6c42\u3002\u82e5\u8981\u5224\u65ad ANALYZE \u662f\u5426\u8fd0\u884c\u8fc7\u3001\u7edf\u8ba1\u662f\u5426\u53ef\u4f9b\u89c4\u5212\u5668\u4f7f\u7528\uff0c\u53ef\u67e5\u8be2 pg_stats_ext\u3002

\n
", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-DX-UC", "localization": {"status": "complete", "sources": [{"url": "/docs/19/app-psql.html", "method": "same-major semantic node", "sha256": "1351be06967585f99a84454a26dff346091ea378daf6c7ed9fa18edee9d1131c", "language": "zh", "matched_nodes": ["#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[101]/p[0]"]}], "language": "zh", "original_text": {"/versions/19/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/19/facts/0/label": "Client", "/versions/19/facts/1/label": "Case-sensitive spelling", "/versions/19/tables/0/title": "Spellings in this manual definition", "/versions/19/related/0/label": "psql command-line options and complete manual", "/versions/19/tables/0/columns/0/label": "Command", "/versions/19/tables/0/columns/1/label": "Documented suffix modifiers"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "756cd94b38588196e7aa8e96fca8ea1889c699261d6b07950c48f6ffb98ca553"}, "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"}, "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": {"pdf": {"A4": {"url": "/files/documentation/pdf/20/postgresql-20-A4.pdf", "bytes": 16030631, "pages": 3052, "sha256": "bd5d82c0ce38fc18f92a0447818a91a193a261776bca1c37564bf9a683e177d0", "built_at": "2026-09-28"}, "US": {"url": "/files/documentation/pdf/20/postgresql-20-US.pdf", "bytes": 15936613, "pages": 3223, "sha256": "d97d9e0db479a02f4234b175f50fcad70c3661619afc8d6df9b9437882e3c299", "built_at": "2026-09-28"}}, "tree": "0", "index": "index.html", "major": "20", "pages": 1156, "release": "20devel", "source_url": "https://ftp.postgresql.org/pub/snapshot/dev/postgresql-snapshot.tar.bz2", "svg_assets": 6, "source_mode": "en SGML built with pinned official archive", "source_sha256": "4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41", "source_snapshot_utc": "26-Sep-2026 20:22"}, "revision": "2eba5e0fd4c3bffb2803247b6cd537878e9d6ee5a6dfbe3c50ece8b421b80918", "evidence_kind": "English manual and source declarations", "source_sha256": "4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41"}, "sources": [{"url": "https://pg.center/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": "6df5f6fbaff7800ae0e4a08a3116090d890a0cdcc02fddc31c1f220725905f87", "language": "en", "original_url": "/docs/devel/app-psql.html#APP-PSQL-META-COMMAND-DX-UC"}], "sections": [], "modifiers": [{"command": "\\dX", "modifiers": "x+"}], "signature": "\\dX[x+] [ pattern ]", "spellings": ["\\dX"], "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": "
\\dX[x+] [ pattern ]
\n

\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

\n

\u6bcf\u79cd\u6269\u5c55\u7edf\u8ba1\u7684\u72b6\u6001\u663e\u793a\u5728\u4ee5\u7edf\u8ba1\u79cd\u7c7b\u547d\u540d\u7684\u5217\u4e2d\uff0c\u4f8b\u5982 Ndistinct\u3002defined \u8868\u793a\u521b\u5efa\u7edf\u8ba1\u65f6\u8bf7\u6c42\u4e86\u8be5\u7edf\u8ba1\uff0cNULL \u8868\u793a\u672a\u8bf7\u6c42\u3002\u82e5\u8981\u5224\u65ad ANALYZE \u662f\u5426\u8fd0\u884c\u8fc7\u3001\u7edf\u8ba1\u662f\u5426\u53ef\u4f9b\u89c4\u5212\u5668\u4f7f\u7528\uff0c\u53ef\u67e5\u8be2 pg_stats_ext\u3002

\n
", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-DX-UC", "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"}, "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"}}}, "snapshot": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 18.6"}, {"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.6/postgresql-18.6.tar.bz2", "label": "18.6", "major": "18", "channel": "stable", "manifest": {"pdf": {"A4": {"url": "/files/documentation/pdf/18/postgresql-18-A4.pdf", "bytes": 15865106, "pages": 3154, "sha256": "19512c405da53f9f7fcf0abba359223aa65f021be025bf3411381918f92e3190", "built_at": "2026-09-26"}, "US": {"url": "/files/documentation/pdf/18/postgresql-18-US.pdf", "bytes": 15748059, "pages": 3328, "sha256": "facbe6c229e598b872d3d98bef53308f46e06746006fa4590de9a7de9dd46319", "built_at": "2026-09-26"}}, "tree": "18", "index": "index.html", "major": "18", "pages": 1148, "release": "18.6", "source_url": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "svg_assets": 3, "source_mode": "en SGML built with pinned official archive", "source_sha256": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "revision": "ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8", "evidence_kind": "English manual and source declarations", "source_sha256": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "sources": [{"url": "https://pg.center/docs/18/app-psql.html#APP-PSQL-META-COMMAND-DX-UC", "file": "app-psql.html", "label": "18.6 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-DX-UC", "sha256": "fa2a1d39294b8854318e82e93f71272c645ed88150ecc2786c28902c3f32782c", "language": "en", "original_url": "/docs/18/app-psql.html#APP-PSQL-META-COMMAND-DX-UC"}], "sections": [], "modifiers": [{"command": "\\dX", "modifiers": "x"}], "signature": "\\dX[x] [ pattern ]", "spellings": ["\\dX"], "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": "
\\dX[x] [ pattern ]
\n

\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

\n

\u6bcf\u79cd\u6269\u5c55\u7edf\u8ba1\u7684\u72b6\u6001\u663e\u793a\u5728\u4ee5\u7edf\u8ba1\u79cd\u7c7b\u547d\u540d\u7684\u5217\u4e2d\uff0c\u4f8b\u5982 Ndistinct\u3002defined \u8868\u793a\u521b\u5efa\u7edf\u8ba1\u65f6\u8bf7\u6c42\u4e86\u8be5\u7edf\u8ba1\uff0cNULL \u8868\u793a\u672a\u8bf7\u6c42\u3002\u82e5\u8981\u5224\u65ad ANALYZE \u662f\u5426\u8fd0\u884c\u8fc7\u3001\u7edf\u8ba1\u662f\u5426\u53ef\u4f9b\u89c4\u5212\u5668\u4f7f\u7528\uff0c\u53ef\u67e5\u8be2 pg_stats_ext\u3002

\n
", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-DX-UC", "localization": {"status": "complete", "sources": [{"url": "/docs/18/app-psql.html", "method": "same-major semantic node", "sha256": "4ff5633229e0afa7feecc2750a7187d2d45a7eef0ca8febc73e4e5c15ac7fa6d", "language": "zh", "matched_nodes": ["#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[101]/p[0]"]}], "language": "zh", "original_text": {"/versions/18/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.", "/versions/18/facts/0/label": "Client", "/versions/18/facts/1/label": "Case-sensitive spelling", "/versions/18/tables/0/title": "Spellings in this manual definition", "/versions/18/related/0/label": "psql command-line options and complete manual", "/versions/18/tables/0/columns/0/label": "Command", "/versions/18/tables/0/columns/1/label": "Documented suffix modifiers"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "d99ed25d5f9178379c7fb080a4eff424394886f2218be37b96ff54603a64317c"}, "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"}, "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+}"}}