On Mon, Oct 29, 2012 at 1:07 AM, Seref Arikan <serefarikan@xxxxxxxxxxxxxxxxxxxxx> wrote: > Greetings, > I keep seeing statements like "Postgresql optimizer rewrites this query > as...." What I'm curious about is, is there a way to obtain SQL form of the > re-written queries somewhere in the chain of query evaluation? It does not > make a lot sense to generate sql again, but it would help a lot to see the > queries in their rewritten form. The re-writing does not occur at the level of SQL, but rather at the level of an internal representation "parse tree". You can see these representations using these configuration settings; debug_print_parse = on debug_print_rewritten = on I'm not aware of anything that turns those back into SQL. Cheers, Jeff -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
