diff options
| author | Tomas Vondra <tomas.vondra@postgresql.org> | 2021-01-17 00:16:25 +0100 |
|---|---|---|
| committer | Tomas Vondra <tomas.vondra@postgresql.org> | 2021-01-17 00:16:45 +0100 |
| commit | 891a1d0bca262ca78564e0fea1eaa5ae544ea5ee (patch) | |
| tree | 3c8977b1f21a6f6fae6547ddaee2c788c2fa27f9 /doc/src | |
| parent | a32d98351e1ff33c5a65db4ed8e2def70a807bfa (diff) | |
| download | postgresql-891a1d0bca262ca78564e0fea1eaa5ae544ea5ee.tar.gz postgresql-891a1d0bca262ca78564e0fea1eaa5ae544ea5ee.zip | |
psql \dX: list extended statistics objects
The new command lists extended statistics objects, possibly with their
sizes. All past releases with extended statistics are supported.
Author: Tatsuro Yamada
Reviewed-by: Julien Rouhaud, Alvaro Herrera, Tomas Vondra
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 | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/doc/src/sgml/ref/psql-ref.sgml b/doc/src/sgml/ref/psql-ref.sgml index 221a967bfe6..aaf55df9215 100644 --- a/doc/src/sgml/ref/psql-ref.sgml +++ b/doc/src/sgml/ref/psql-ref.sgml @@ -1918,6 +1918,28 @@ testdb=> </para> </listitem> </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. + If <literal>+</literal> is appended to the command name, each extended + statistics is listed with its size. + </para> + + <para> + The column of the kind of extended stats (e.g. Ndistinct) shows some statuses. + "requested" means that it needs to collect statistics by <link + linkend="sql-analyze"><command>ANALYZE</command></link>. + "built" means <link linkend="sql-analyze"><command>ANALYZE</command></link> was + finished, and the planner can use it. NULL means that it doesn't exists. + </para> + </listitem> + </varlistentry> <varlistentry> <term><literal>\dy[+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> |