hard parse?

From: Peter Koukoulis <pkoukoulis(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: hard parse?
Date: 2017-09-21 12:48:10
Message-ID: CABpxA9hOgg+btm15NoJ_GTSpt0Uwm9TxA1ZV0bPmtvHSUJSU5Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi

I have a query where a filter would always be negative, how many steps, out
these:

- parsing and syntax check
- semantic analysis
- transformation process (query rewrite based on system or user-defined
rules)
- query optimization
- execution

would be performed or not? Also, where in the documentation can I found out
which of the above phases would be performed?

For example, for a query such as the following:

select x,y from test1 where 1=0;

Thanks
P

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2017-09-21 13:54:56 Re: a JOIN to a VIEW seems slow
Previous Message johncarter 2017-09-21 10:45:48 EDB to PST Converter