Wiki / psql Commands / Describe database objects
\dX
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.
Reading PostgreSQL 18.6.
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.
- Client
- psql 18.6
- Case-sensitive spelling
- \dX
Usage
\dX[x] [ pattern ]Spellings in this manual definition
| Command | Documented suffix modifiers |
|---|---|
| \dX | x |
Manual definition
\dX[x] [pattern]-
Lists extended statistics. If
patternis specified, only those extended statistics whose names match the pattern are listed. Ifxis 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).
definedmeans that it was requested when creating the statistics, and NULL means it wasn't requested. You can usepg_stats_extif you'd like to know whetherANALYZEwas run and statistics are available to the planner.
Related entries
Documentation and source
Source build
- Version
- 18.6
- Build
- https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2
- Source fingerprint
ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8
Compare versions
PostgreSQL 13 → 14: added.
--- PostgreSQL 13
+++ PostgreSQL 14
@@ -1 +1,8 @@
-Not recorded in this version
+{
+ "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.",
+ "modifiers": [],
+ "signature": "\\dX [ pattern ]",
+ "spellings": [
+ "\\dX"
+ ]
+}Compares recorded interfaces and attributes. Source fingerprints and build metadata are excluded; an absent sample is not proof of the introduction or removal release.
Related entries
Export JSON · Back to psql Commands · Recorded in PostgreSQL 14 through 20; the first sample is not necessarily its introduction.