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

From Tom Lane
Subject Re: list of extended statistics on psql
Date
Msg-id 3959104.1598885891@sss.pgh.pa.us
Whole thread Raw
In response to Re: list of extended statistics on psql  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Responses Re: list of extended statistics on psql  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
List pgsql-hackers
Alvaro Herrera <alvherre@2ndquadrant.com> writes:
> If we do put each type in its own row -- at least "logical" row, say
> string_agg(unnest(array_of_types), '\n') -- then we can put the size of each type
> in a separate column with string_agg(unnest(array_of_sizes), '\n')

>  statname |   definition    |         type             |  size
> ----------+-----------------+--------------------------+-----------
>  someobj  | (a, b) FROM tab | n-distinct: built        | 2000 bytes
>                             | func-dependencies: built | 4000 bytes
>  another  | (a, c) FROM tab | n-distint: enabled       | <null>

I guess I'm wondering why the size is of such interest that we
need it at all here.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: list of extended statistics on psql
Next
From: Kasahara Tatsuhito
Date:
Subject: Re: Get memory contexts of an arbitrary backend process