Re: list of extended statistics on psql

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: list of extended statistics on psql
Дата
Msg-id 3959104.1598885891@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: list of extended statistics on psql  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Ответы Re: list of extended statistics on psql  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Список 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 по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: list of extended statistics on psql
Следующее
От: Kasahara Tatsuhito
Дата:
Сообщение: Re: Get memory contexts of an arbitrary backend process