Re: list of extended statistics on psql - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: list of extended statistics on psql
Date
Msg-id 20200831161809.GA31337@alvherre.pgsql
Whole thread Raw
In response to Re: list of extended statistics on psql  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Responses Re: list of extended statistics on psql  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Matthieu Garrigues
Date:
Subject: Re: PATCH: Batch/pipelining support for libpq
Next
From: Tomas Vondra
Date:
Subject: Re: list of extended statistics on psql