Re: Regarding EXPLAIN and width calculations

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Regarding EXPLAIN and width calculations
Дата
Msg-id 3236.1290190482@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Regarding EXPLAIN and width calculations  (Jon Nelson <jnelson+pgsql@jamponi.net>)
Ответы Re: Regarding EXPLAIN and width calculations  (Jon Nelson <jnelson+pgsql@jamponi.net>)
Список pgsql-general
Jon Nelson <jnelson+pgsql@jamponi.net> writes:
> What influences the calculation of the 'width' value in query plans?

It's generally the sum of the estimated column widths for all the
columns needed at that particular level of the plan.

> Specifically, I have two queries which both query the same set of
> tables via either UNION or UNION ALL based on the presence (or
> absence) of an aggregate function.

Hard to comment about this with such an incomplete view of the situation
--- in particular, data types would be a critical factor, and I also
wonder if you're admitting to all the columns involved.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Upgrading 8.2 to 8.4: pg_restore: did not find magic string in file header\n
Следующее
От: Jon Nelson
Дата:
Сообщение: Re: Regarding EXPLAIN and width calculations