Postgres Pro
Downloads
Home   >   mailing lists

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

From Thomas Kellerer
Subject Re: Determining table and column access based on query
Date
Msg-id bcb47eb2-1e4d-0d26-ae57-10322ca01446@gmx.net
Whole thread Raw
In response to Determining table and column access based on query  ("Thomas Rosenstein" <thomas.rosenstein@creamfinance.com>)
Responses Re: Determining table and column access based on query
List pgsql-general
Tree view 
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: "Thomas Rosenstein"
Date:
Subject: Determining table and column access based on query
Next
From: Shital A
Date:
Subject: Re: Fwd: Postgres HA - pacemaker RA do not support auto failback