{"kind": "psql", "major": "18", "item": {"slug": "cmd-64-58", "name": "\\dX", "name_zh": "", "category": "Describe database objects", "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.", "aliases": ["\\dX", "\\dX+", "\\dXx", "\\dXx+"], "content_hash": "77e98b623d93139bc9cee9d50c5692eb3cd94897a7a31fce3b0a7182e3d1f855", "versions": {"14": {"facts": [{"label": "Client", "value": "psql 14.24"}, {"label": "Case-sensitive spelling", "value": "\\dX"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-64-58/?v=14", "text": "\\dX"}, "modifiers": "None listed in this signature"}], "title": "Spellings in this manual definition", "columns": [{"key": "command", "label": "Command"}, {"key": "modifiers", "label": "Documented suffix modifiers"}]}], "command": "\\dX", "related": [{"url": "/wiki/tool/psql/?v=14", "label": "psql command-line options and complete manual"}], "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": "/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"}], "sections": [], "modifiers": [], "signature": "\\dX [ pattern ]", "spellings": ["\\dX"], "description": ["Lists extended statistics. If pattern is specified, only those extended statistics whose names match the pattern are listed."], "manual_html": "<div><dl class=\"variablelist\"><dt><span class=\"term\"><code class=\"literal\">\\dX [ <a class=\"link\" href=\"/docs/14/app-psql.html#APP-PSQL-PATTERNS\" title=\"Patterns\"><em class=\"replaceable\"><code>pattern</code></em></a> ]</code></span></dt><dd>\n<p>Lists extended statistics. If <em class=\"replaceable\"><code>pattern</code></em> is specified, only those extended statistics whose names match the pattern are listed.</p>\n<p>The status of each kind of extended statistics is shown in a column named after its statistic kind (e.g. Ndistinct). <code class=\"literal\">defined</code> means that it was requested when creating the statistics, and NULL means it wasn't requested. You can use <code class=\"structname\">pg_stats_ext</code> if you'd like to know whether <a class=\"link\" href=\"/docs/14/sql-analyze.html\" title=\"ANALYZE\"><code class=\"command\">ANALYZE</code></a> was run and statistics are available to the planner.</p>\n</dd></dl></div>", "manual_path": "app-psql.html#APP-PSQL-META-COMMANDS", "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"}, "15": {"facts": [{"label": "Client", "value": "psql 15.19"}, {"label": "Case-sensitive spelling", "value": "\\dX"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-64-58/?v=15", "text": "\\dX"}, "modifiers": "None listed in this signature"}], "title": "Spellings in this manual definition", "columns": [{"key": "command", "label": "Command"}, {"key": "modifiers", "label": "Documented suffix modifiers"}]}], "command": "\\dX", "related": [{"url": "/wiki/tool/psql/?v=15", "label": "psql command-line options and complete manual"}], "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": "/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"}], "sections": [], "modifiers": [], "signature": "\\dX [ pattern ]", "spellings": ["\\dX"], "description": ["Lists extended statistics. If pattern is specified, only those extended statistics whose names match the pattern are listed."], "manual_html": "<div><dl class=\"variablelist\"><dt><span class=\"term\"><code class=\"literal\">\\dX [ <a class=\"link\" href=\"/docs/15/app-psql.html#APP-PSQL-PATTERNS\" title=\"Patterns\"><em class=\"replaceable\"><code>pattern</code></em></a> ]</code></span></dt><dd>\n<p>Lists extended statistics. If <em class=\"replaceable\"><code>pattern</code></em> is specified, only those extended statistics whose names match the pattern are listed.</p>\n<p>The status of each kind of extended statistics is shown in a column named after its statistic kind (e.g. Ndistinct). <code class=\"literal\">defined</code> means that it was requested when creating the statistics, and NULL means it wasn't requested. You can use <code class=\"structname\">pg_stats_ext</code> if you'd like to know whether <a class=\"link\" href=\"/docs/15/sql-analyze.html\" title=\"ANALYZE\"><code class=\"command\">ANALYZE</code></a> was run and statistics are available to the planner.</p>\n</dd></dl></div>", "manual_path": "app-psql.html#APP-PSQL-META-COMMANDS", "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"}, "16": {"facts": [{"label": "Client", "value": "psql 16.15"}, {"label": "Case-sensitive spelling", "value": "\\dX"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-64-58/?v=16", "text": "\\dX"}, "modifiers": "None listed in this signature"}], "title": "Spellings in this manual definition", "columns": [{"key": "command", "label": "Command"}, {"key": "modifiers", "label": "Documented suffix modifiers"}]}], "command": "\\dX", "related": [{"url": "/wiki/tool/psql/?v=16", "label": "psql command-line options and complete manual"}], "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": "/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"}], "sections": [], "modifiers": [], "signature": "\\dX [ pattern ]", "spellings": ["\\dX"], "description": ["Lists extended statistics. If pattern is specified, only those extended statistics whose names match the pattern are listed."], "manual_html": "<div><dl class=\"variablelist\"><dt id=\"APP-PSQL-META-COMMAND-DX-UC\"><span class=\"term\"><code class=\"literal\">\\dX [ <a class=\"link\" href=\"/docs/16/app-psql.html#APP-PSQL-PATTERNS\" title=\"Patterns\"><em class=\"replaceable\"><code>pattern</code></em></a> ]</code></span> </dt><dd>\n<p>Lists extended statistics. If <em class=\"replaceable\"><code>pattern</code></em> is specified, only those extended statistics whose names match the pattern are listed.</p>\n<p>The status of each kind of extended statistics is shown in a column named after its statistic kind (e.g. Ndistinct). <code class=\"literal\">defined</code> means that it was requested when creating the statistics, and NULL means it wasn't requested. You can use <code class=\"structname\">pg_stats_ext</code> if you'd like to know whether <a class=\"link\" href=\"/docs/16/sql-analyze.html\" title=\"ANALYZE\"><code class=\"command\">ANALYZE</code></a> was run and statistics are available to the planner.</p>\n</dd></dl></div>", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-DX-UC", "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"}, "17": {"facts": [{"label": "Client", "value": "psql 17.11"}, {"label": "Case-sensitive spelling", "value": "\\dX"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-64-58/?v=17", "text": "\\dX"}, "modifiers": "None listed in this signature"}], "title": "Spellings in this manual definition", "columns": [{"key": "command", "label": "Command"}, {"key": "modifiers", "label": "Documented suffix modifiers"}]}], "command": "\\dX", "related": [{"url": "/wiki/tool/psql/?v=17", "label": "psql command-line options and complete manual"}], "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": "/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"}], "sections": [], "modifiers": [], "signature": "\\dX [ pattern ]", "spellings": ["\\dX"], "description": ["Lists extended statistics. If pattern is specified, only those extended statistics whose names match the pattern are listed."], "manual_html": "<div><dl class=\"variablelist\"><dt id=\"APP-PSQL-META-COMMAND-DX-UC\"><span class=\"term\"><code class=\"literal\">\\dX [ <a class=\"link\" href=\"/docs/17/app-psql.html#APP-PSQL-PATTERNS\" title=\"Patterns\"><em class=\"replaceable\"><code>pattern</code></em></a> ]</code></span> </dt><dd>\n<p>Lists extended statistics. If <em class=\"replaceable\"><code>pattern</code></em> is specified, only those extended statistics whose names match the pattern are listed.</p>\n<p>The status of each kind of extended statistics is shown in a column named after its statistic kind (e.g. Ndistinct). <code class=\"literal\">defined</code> means that it was requested when creating the statistics, and NULL means it wasn't requested. You can use <code class=\"structname\">pg_stats_ext</code> if you'd like to know whether <a class=\"link\" href=\"/docs/17/sql-analyze.html\" title=\"ANALYZE\"><code class=\"command\">ANALYZE</code></a> was run and statistics are available to the planner.</p>\n</dd></dl></div>", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-DX-UC", "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"}, "18": {"facts": [{"label": "Client", "value": "psql 18.6"}, {"label": "Case-sensitive spelling", "value": "\\dX"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-64-58/?v=18", "text": "\\dX"}, "modifiers": "x"}], "title": "Spellings in this manual definition", "columns": [{"key": "command", "label": "Command"}, {"key": "modifiers", "label": "Documented suffix modifiers"}]}], "command": "\\dX", "related": [{"url": "/wiki/tool/psql/?v=18", "label": "psql command-line options and complete manual"}], "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": "/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"}], "sections": [], "modifiers": [{"command": "\\dX", "modifiers": "x"}], "signature": "\\dX[x] [ pattern ]", "spellings": ["\\dX"], "description": ["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."], "manual_html": "<div><dl class=\"variablelist\"><dt id=\"APP-PSQL-META-COMMAND-DX-UC\"><span class=\"term\"><code class=\"literal\">\\dX[x] [ <a class=\"link\" href=\"/docs/18/app-psql.html#APP-PSQL-PATTERNS\" title=\"Patterns\"><em class=\"replaceable\"><code>pattern</code></em></a> ]</code></span> </dt><dd>\n<p>Lists extended statistics. If <em class=\"replaceable\"><code>pattern</code></em> is specified, only those extended statistics whose names match the pattern are listed. If <code class=\"literal\">x</code> is appended to the command name, the results are displayed in expanded mode.</p>\n<p>The status of each kind of extended statistics is shown in a column named after its statistic kind (e.g. Ndistinct). <code class=\"literal\">defined</code> means that it was requested when creating the statistics, and NULL means it wasn't requested. You can use <code class=\"structname\">pg_stats_ext</code> if you'd like to know whether <a class=\"link\" href=\"/docs/18/sql-analyze.html\" title=\"ANALYZE\"><code class=\"command\">ANALYZE</code></a> was run and statistics are available to the planner.</p>\n</dd></dl></div>", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-DX-UC", "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"}, "19": {"facts": [{"label": "Client", "value": "psql 19beta4"}, {"label": "Case-sensitive spelling", "value": "\\dX"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-64-58/?v=19", "text": "\\dX"}, "modifiers": "x+"}], "title": "Spellings in this manual definition", "columns": [{"key": "command", "label": "Command"}, {"key": "modifiers", "label": "Documented suffix modifiers"}]}], "command": "\\dX", "related": [{"url": "/wiki/tool/psql/?v=19", "label": "psql command-line options and complete manual"}], "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": "/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"}], "sections": [], "modifiers": [{"command": "\\dX", "modifiers": "x+"}], "signature": "\\dX[x+] [ pattern ]", "spellings": ["\\dX"], "description": ["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."], "manual_html": "<div><dl class=\"variablelist\"><dt id=\"APP-PSQL-META-COMMAND-DX-UC\"><span class=\"term\"><code class=\"literal\">\\dX[x+] [ <a class=\"link\" href=\"/docs/19/app-psql.html#APP-PSQL-PATTERNS\" title=\"Patterns\"><em class=\"replaceable\"><code>pattern</code></em></a> ]</code></span> </dt><dd>\n<p>Lists extended statistics. If <em class=\"replaceable\"><code>pattern</code></em> is specified, only those extended statistics whose names match the pattern are listed. If <code class=\"literal\">x</code> is appended to the command name, the results are displayed in expanded mode. If <code class=\"literal\">+</code> is appended to the command name, each object is listed with its associated description.</p>\n<p>The status of each kind of extended statistics is shown in a column named after its statistic kind (e.g. Ndistinct). <code class=\"literal\">defined</code> means that it was requested when creating the statistics, and NULL means it wasn't requested. You can use <code class=\"structname\">pg_stats_ext</code> if you'd like to know whether <a class=\"link\" href=\"/docs/19/sql-analyze.html\" title=\"ANALYZE\"><code class=\"command\">ANALYZE</code></a> was run and statistics are available to the planner.</p>\n</dd></dl></div>", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-DX-UC", "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"}, "20": {"facts": [{"label": "Client", "value": "psql 20devel"}, {"label": "Case-sensitive spelling", "value": "\\dX"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-64-58/?v=20", "text": "\\dX"}, "modifiers": "x+"}], "title": "Spellings in this manual definition", "columns": [{"key": "command", "label": "Command"}, {"key": "modifiers", "label": "Documented suffix modifiers"}]}], "command": "\\dX", "related": [{"url": "/wiki/tool/psql/?v=20", "label": "psql command-line options and complete manual"}], "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": "/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"}], "sections": [], "modifiers": [{"command": "\\dX", "modifiers": "x+"}], "signature": "\\dX[x+] [ pattern ]", "spellings": ["\\dX"], "description": ["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."], "manual_html": "<div><dl class=\"variablelist\"><dt id=\"APP-PSQL-META-COMMAND-DX-UC\"><span class=\"term\"><code class=\"literal\">\\dX[x+] [ <a class=\"link\" href=\"/docs/devel/app-psql.html#APP-PSQL-PATTERNS\" title=\"Patterns\"><em class=\"replaceable\"><code>pattern</code></em></a> ]</code></span> </dt><dd>\n<p>Lists extended statistics. If <em class=\"replaceable\"><code>pattern</code></em> is specified, only those extended statistics whose names match the pattern are listed. If <code class=\"literal\">x</code> is appended to the command name, the results are displayed in expanded mode. If <code class=\"literal\">+</code> is appended to the command name, each object is listed with its associated description.</p>\n<p>The status of each kind of extended statistics is shown in a column named after its statistic kind (e.g. Ndistinct). <code class=\"literal\">defined</code> means that it was requested when creating the statistics, and NULL means it wasn't requested. You can use <code class=\"structname\">pg_stats_ext</code> if you'd like to know whether <a class=\"link\" href=\"/docs/devel/sql-analyze.html\" title=\"ANALYZE\"><code class=\"command\">ANALYZE</code></a> was run and statistics are available to the planner.</p>\n</dd></dl></div>", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-DX-UC", "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"}}}, "snapshot": {"facts": [{"label": "Client", "value": "psql 18.6"}, {"label": "Case-sensitive spelling", "value": "\\dX"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-64-58/?v=18", "text": "\\dX"}, "modifiers": "x"}], "title": "Spellings in this manual definition", "columns": [{"key": "command", "label": "Command"}, {"key": "modifiers", "label": "Documented suffix modifiers"}]}], "command": "\\dX", "related": [{"url": "/wiki/tool/psql/?v=18", "label": "psql command-line options and complete manual"}], "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": "/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"}], "sections": [], "modifiers": [{"command": "\\dX", "modifiers": "x"}], "signature": "\\dX[x] [ pattern ]", "spellings": ["\\dX"], "description": ["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."], "manual_html": "<div><dl class=\"variablelist\"><dt id=\"APP-PSQL-META-COMMAND-DX-UC\"><span class=\"term\"><code class=\"literal\">\\dX[x] [ <a class=\"link\" href=\"/docs/18/app-psql.html#APP-PSQL-PATTERNS\" title=\"Patterns\"><em class=\"replaceable\"><code>pattern</code></em></a> ]</code></span> </dt><dd>\n<p>Lists extended statistics. If <em class=\"replaceable\"><code>pattern</code></em> is specified, only those extended statistics whose names match the pattern are listed. If <code class=\"literal\">x</code> is appended to the command name, the results are displayed in expanded mode.</p>\n<p>The status of each kind of extended statistics is shown in a column named after its statistic kind (e.g. Ndistinct). <code class=\"literal\">defined</code> means that it was requested when creating the statistics, and NULL means it wasn't requested. You can use <code class=\"structname\">pg_stats_ext</code> if you'd like to know whether <a class=\"link\" href=\"/docs/18/sql-analyze.html\" title=\"ANALYZE\"><code class=\"command\">ANALYZE</code></a> was run and statistics are available to the planner.</p>\n</dd></dl></div>", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-DX-UC", "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"}, "comparison": {"left": "17", "right": "18", "status": "changed", "diff": "--- PostgreSQL 17\n+++ PostgreSQL 18\n@@ -1,7 +1,12 @@\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+  \"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.\",\n+  \"modifiers\": [\n+    {\n+      \"command\": \"\\\\dX\",\n+      \"modifiers\": \"x\"\n+    }\n+  ],\n+  \"signature\": \"\\\\dX[x] [ pattern ]\",\n   \"spellings\": [\n     \"\\\\dX\"\n   ]"}}