From: Justin Pryzby <pryzby@telsasoft.com>
To: Tomas Vondra <tomas.vondra@enterprisedb.com>
Cc: Shinoda, Noriyoshi (PN Japan FSIP) <noriyoshi.shinoda@hpe.com>
Cc: Julien Rouhaud <rjuju123@gmail.com>
Cc: Tatsuro Yamada <tatsuro.yamada.tf@nttcom.co.jp>
Cc: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: Tomas Vondra <tomas.vondra@2ndquadrant.com>
Cc: Michael Paquier <michael@paquier.xyz>
Cc: Pavel Stehule <pavel.stehule@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Subject: Re: list of extended statistics on psql
Date: Sun, 17 Jan 2021 10:52:10 -0600
Message-ID: <20210117165210.GD8560@telsasoft.com> (raw)
In-Reply-To: <a9c2eb3f-a4e7-b196-9a87-f2acfb5c4859@enterprisedb.com>
References: <876efa7e-2067-a4f9-d7e8-f6025440c870@nttcom.co.jp_1>
<0e84aa72-25f2-1849-753f-f827949132b3@enterprisedb.com>
<85e7e1e7-c2f0-a4a0-61de-6e7ecaee44e3@nttcom.co.jp_1>
<79d3a4c5-1efe-5b9e-c06e-3a907b531013@nttcom.co.jp_1>
<20210115084741.GA91293@nol>
<2eb51458-7475-17d3-cb13-b3c950b2f930@enterprisedb.com>
<5e0fb573-3c38-ee39-885c-bdc01f116335@enterprisedb.com>
<TU4PR8401MB115239DC3FE567BE637F7544EEA50@TU4PR8401MB1152.NAMPRD84.PROD.OUTLOOK.COM>
<d876a1e3-9a6c-712e-7ab8-3dfa8a4cac1e@enterprisedb.com>
<a9c2eb3f-a4e7-b196-9a87-f2acfb5c4859@enterprisedb.com>
On Sun, Jan 17, 2021 at 03:31:57PM +0100, Tomas Vondra wrote:
> I've reverted the commit - once we find the right way to handle this, I'll
> get it committed again.
Please consider these doc changes for the next iteration.
commit 1a69f648ce6c63ebb37b6d8ec7c6539b3cb70787
Author: Justin Pryzby <pryzbyj@telsasoft.com>
Date: Sat Jan 16 17:47:35 2021 -0600
doc review: psql \dX 891a1d0bca262ca78564e0fea1eaa5ae544ea5ee
inline patch 1: doc/src/sgml/ref/psql-ref.sgml (+3/-3 lines) download inline-1.patchdiff --git a/doc/src/sgml/ref/psql-ref.sgml b/doc/src/sgml/ref/psql-ref.sgmlindex aaf55df921..a678a69dfb 100644--- a/doc/src/sgml/ref/psql-ref.sgml+++ b/doc/src/sgml/ref/psql-ref.sgml@@ -1928,15 +1928,15 @@ testdb=>
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.+ statistic is listed with its size.
</para>
<para>
- The column of the kind of extended stats (e.g. Ndistinct) shows some statuses.+ The column of the kind of extended stats (e.g. Ndistinct) shows its status.
"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. + run, and statistics are available to the planner. NULL means that it doesn't exist.
</para>
</listitem>
</varlistentry>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: pryzby@telsasoft.com, tomas.vondra@enterprisedb.com, noriyoshi.shinoda@hpe.com, rjuju123@gmail.com, tatsuro.yamada.tf@nttcom.co.jp, alvherre@2ndquadrant.com, tomas.vondra@2ndquadrant.com, michael@paquier.xyz, pavel.stehule@gmail.com, pgsql-hackers@lists.postgresql.org
Subject: Re: list of extended statistics on psql
In-Reply-To: <20210117165210.GD8560@telsasoft.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox