Thanks a lot Tom. Thanks,
Goti On Mon, Apr 18, 2022 at 7:43 PM Tom Lane <t...@sss.pgh.pa.us> wrote: > Goti <aryan.g...@gmail.com> writes: > > I would like to know if postgres performs any transformations when it > does > > the parsing? > > This might be helpful reading: > > https://www.postgresql.org/docs/current/overview.html > > > If yes, is there a way we can get the final transformed query? > > See debug_print_parse and friends [1]. Depending on what you mean by > "final transformed query", you might instead want debug_print_rewritten, > or maybe you want the plan, in which case EXPLAIN is a much friendlier > way to look at it than debug_print_plan. > > regards, tom lane > > [1] > https://www.postgresql.org/docs/current/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT >
