How to find the final transformed query in postgresql

From: Goti <aryan(dot)goti(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: How to find the final transformed query in postgresql
Date: 2022-04-18 14:02:49
Message-ID: CAOzfMuqvzJxty9CXyvkkkc4N6Z6Y+iSyuV59XFYe+vJjdsRnTQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi Geeks,

Env: postgres12

I am new to postgres and coming from an Oracle background. Please excuse me
if I am not asking valid questions.

I would like to know if postgres performs any transformations when it does
the parsing? If yes, is there a way we can get the final transformed query?

Thanks,

Goti

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2022-04-18 14:13:03 Re: How to find the final transformed query in postgresql
Previous Message Alvaro Herrera 2022-04-17 18:50:14 Re: Query Planner not taking advantage of HASH PARTITION