Re: Determining table and column access based on query

Поиск
Список
Период
Сортировка
От Thomas Rosenstein
Тема Re: Determining table and column access based on query
Дата
Msg-id 427FB826-23D8-4E57-AFD4-DDE5A8F6A5F6@creamfinance.com
обсуждение исходный текст
Ответ на Re: Determining table and column access based on query  (Thomas Kellerer <spam_eater@gmx.net>)
Список pgsql-general
Actually yes, thanks

Was just blind when checking EXPLAIN :D


On 13 Aug 2019, at 12:55, Thomas Kellerer wrote:

> Thomas Rosenstein schrieb am 13.08.2019 um 12:17:
>> we would like to evaluate what data a SQL query will access, is there
>> a possibility to ask the Planner directly which tables and columns
>> will be affected in the end?
>>
>
> explain (verbose)  will show the output columns for each step.
>
> Is that what you are looking for?



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

Предыдущее
От: stan
Дата:
Сообщение: Re: A GROUP BY question
Следующее
От: Alban Hertroys
Дата:
Сообщение: Re: A GROUP BY question