Re: Determining table and column access based on query

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 an

Re: Determining table and column access based on query

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

Determining table and column access based on query

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