Re: Show statistics target in \d+ - Mailing list pgsql-hackers

From Magnus Hagander
Subject Re: Show statistics target in \d+
Date
Msg-id CABUevEx_XDySp6+OtJzGRsfhC1Vr7zk6tsgntJ6FkFh6t5e90w@mail.gmail.com
Whole thread Raw
In response to Re: Show statistics target in \d+  (Cédric Villemain <cedric.villemain.debian@gmail.com>)
Responses Re: Show statistics target in \d+
Re: Show statistics target in \d+
List pgsql-hackers
On Fri, Nov 4, 2011 at 14:53, Cédric Villemain
<cedric.villemain.debian@gmail.com> wrote:
> 2011/11/4 Magnus Hagander <magnus@hagander.net>:
>> The attached patch adds a column for statistics target when viewing
>> tables in psql using \d+.
>>
>> Comments/reivews?
>
> Interesting, can the ouput be clear on the value being a default or an
> explicit stat target ? (not mandatory but I believe I would like to
> have it only when the stat target is jnot the default)

It shows -1 when it's the default.

We could map that to the string "default" if we want, or just NULL, I
guess. Not sure which is best?

--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/


pgsql-hackers by date:

Previous
From: Cédric Villemain
Date:
Subject: Re: Show statistics target in \d+
Next
From: Robert Haas
Date:
Subject: Re: Show statistics target in \d+