Re: list of extended statistics on psql

Поиск
Список
Период
Сортировка
От Tomas Vondra
Тема Re: list of extended statistics on psql
Дата
Msg-id 20200831152057.t5kijt5uoww5zs5o@development
обсуждение исходный текст
Ответ на Re: list of extended statistics on psql  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Mon, Aug 31, 2020 at 10:58:11AM -0400, Tom Lane wrote:
>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.
>

I agree it may not be important enough. I did use it during development
etc. but maybe it's not something we need to include in this list (even
if it's just in the \dX+ variant).

regards

-- 
Tomas Vondra                  http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Asim Praveen
Дата:
Сообщение: Re: Continuing instability in insert-conflict-specconflict test
Следующее
От: Tomas Vondra
Дата:
Сообщение: Re: list of extended statistics on psql