Determining table and column access based on query

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Determining table and column access based on query

Thomas Rosenstein
Hi,

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?


Thanks
Thomas


Reply | Threaded
Open this post in threaded view
|

Re: Determining table and column access based on query

Thomas Kellerer
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?




Reply | Threaded
Open this post in threaded view
|

Re: Determining table and column access based on query

Thomas Rosenstein
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?