diff options
| author | Tomas Vondra <tomas.vondra@postgresql.org> | 2021-01-20 22:56:06 +0100 |
|---|---|---|
| committer | Tomas Vondra <tomas.vondra@postgresql.org> | 2021-01-20 22:57:21 +0100 |
| commit | ad600bba0422dde4b73fbd61049ff2a3847b068a (patch) | |
| tree | bef13ef5e1663a23dd116bbe5823b3d2f9146678 /doc/src | |
| parent | 9d23c15a034ba163ae1045b945954e8e1bcfc72a (diff) | |
| download | postgresql-ad600bba0422dde4b73fbd61049ff2a3847b068a.tar.gz postgresql-ad600bba0422dde4b73fbd61049ff2a3847b068a.zip | |
psql \dX: list extended statistics objects
The new command lists extended statistics objects. All past releases
with extended statistics are supported.
This is a simplified version of commit 891a1d0bca, which had to be
reverted due to not considering pg_statistic_ext_data is not accessible
by regular users. Fields requiring access to this catalog were removed.
It's possible to add them, but it'll require changes to core.
Author: Tatsuro Yamada
Reviewed-by: Julien Rouhaud, Alvaro Herrera, Tomas Vondra, Noriyoshi Shinoda
Discussion: https://postgr.es/m/c027a541-5856-75a5-0868-341301e1624b%40nttcom.co.jp_1
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/psql-ref.sgml | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/doc/src/sgml/ref/psql-ref.sgml b/doc/src/sgml/ref/psql-ref.sgml index 221a967bfe6..13c1edfa4dd 100644 --- a/doc/src/sgml/ref/psql-ref.sgml +++ b/doc/src/sgml/ref/psql-ref.sgml @@ -1920,6 +1920,27 @@ testdb=> </varlistentry> <varlistentry> + <term><literal>\dX [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <listitem> + <para> + Lists extended statistics. + If <replaceable class="parameter">pattern</replaceable> + is specified, only those extended statistics whose names match the + pattern are listed. + </para> + + <para> + The column of the kind of extended stats (e.g. Ndistinct) shows its status. + NULL means that it doesn't exists. "defined" means that it was requested + when creating the statistics. + You can use pg_stats_ext if you'd like to know whether <link linkend="sql-analyze"> + <command>ANALYZE</command></link> was run and statistics are available to the + planner. + </para> + </listitem> + </varlistentry> + + <varlistentry> <term><literal>\dy[+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> |