Date: Mon, 31 Aug 2020 12:18:09 -0400
From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Tomas Vondra <tomas.vondra@2ndquadrant.com>
Cc: Tatsuro Yamada <tatsuro.yamada.tf@nttcom.co.jp>,
	Julien Rouhaud <rjuju123@gmail.com>,
	Pavel Stehule <pavel.stehule@gmail.com>,
	PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Subject: Re: list of extended statistics on psql
Message-ID: <20200831161809.GA31337@alvherre.pgsql>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <20200831153053.a343pjgumahiejhw@development>
User-Agent: Mutt/1.10.1 (2018-07-13)
Precedence: bulk

On 2020-Aug-31, Tomas Vondra wrote:

> I wonder if trying to list info about all stats from the statistics
> object in a single line is necessary. Maybe we should split the info
> into one line per statistics, so for example
> 
>     CREATE STATISTICS s (mcv, ndistinct, dependencies) ON ...
> 
> would result in three lines in the \dX output. The statistics name would
> identify which lines belong together, but other than that the pieces are
> mostly independent.

Yeah, that's what I'm suggesting.  I don't think we need to repeat the
name/definition for each line though.

It might be useful to know how does pspg show a single entry that's
split in three lines, though.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services