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 по дате отправления: