Re: Determining table and column access based on query

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Determining table and column access based on query
Date: 2019-08-13 10:55:07
Message-ID: bcb47eb2-1e4d-0d26-ae57-10322ca01446@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shital A 2019-08-13 11:08:44 Re: Fwd: Postgres HA - pacemaker RA do not support auto failback
Previous Message Thomas Rosenstein 2019-08-13 10:17:52 Determining table and column access based on query