Re: Determining table and column access based on query - Mailing list pgsql-general

From Thomas Rosenstein
Subject Re: Determining table and column access based on query
Date
Msg-id 427FB826-23D8-4E57-AFD4-DDE5A8F6A5F6@creamfinance.com
Whole thread Raw
In response to Re: Determining table and column access based on query  (Thomas Kellerer <spam_eater@gmx.net>)
List 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 by date:

Previous
From: stan
Date:
Subject: Re: A GROUP BY question
Next
From: Alban Hertroys
Date:
Subject: Re: A GROUP BY question