Postgres Pro
Downloads
Home   >   mailing lists

How to find the final transformed query in postgresql - Mailing list pgsql-performance

From Goti
Subject How to find the final transformed query in postgresql
Date
Msg-id CAOzfMuqvzJxty9CXyvkkkc4N6Z6Y+iSyuV59XFYe+vJjdsRnTQ@mail.gmail.com
Whole thread Raw
Responses Re: How to find the final transformed query in postgresql  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tree view
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

pgsql-performance by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Query Planner not taking advantage of HASH PARTITION
Next
From: Tom Lane
Date:
Subject: Re: How to find the final transformed query in postgresql