Re: Determining table and column access based on query

From: "Thomas Rosenstein" <thomas(dot)rosenstein(at)creamfinance(dot)com>
To: "Thomas Kellerer" <spam_eater(at)gmx(dot)net>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Determining table and column access based on query
Date: 2019-08-13 11:15:24
Message-ID: 427FB826-23D8-4E57-AFD4-DDE5A8F6A5F6@creamfinance.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alban Hertroys 2019-08-13 12:59:22 Re: A GROUP BY question
Previous Message stan 2019-08-13 11:10:18 Re: A GROUP BY question