Horton

Re: v13: show extended stats target in \d

gkokolatos@pm.me

View thread View on postgr.es
From: gkokolatos@pm.me
To: Justin Pryzby <pryzby@telsasoft.com>
Cc: "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>, Tomas Vondra <tomas.vondra@2ndquadrant.com>, Tatsuro Yamada <tatsuro.yamada.tf@nttcom.co.jp>
Date: 2020-08-31T07:47:35Z
Lists: pgsql-hackers 




‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
On Monday, 31 August 2020 08:00, Justin Pryzby <pryzby@telsasoft.com> wrote:

> The stats target can be set since commit d06215d03, but wasn't shown by psql.
> ALTER STATISISTICS .. SET STATISTICS n.
>
> Normal (1-D) stats targets are shown in \d+ table.
> Stats objects are shown in \d (no plus).
> Arguably, this should be shown only in "verbose" mode (\d+).

This seems rather useful. May I suggest you add it to the commitfest?

//Georgios

Commits

  1. psql: Display stats target of extended statistics

  2. Allow setting statistics target for extended statistics