Access to postgresql query optimizer output - Mailing list pgsql-general

From Seref Arikan
Subject Access to postgresql query optimizer output
Date
Msg-id CA+4ThdqLSaGUjBjD6qoeW+u4yd4+KqfhmyE3YKbU0UfsdMX46w@mail.gmail.com
Whole thread Raw
Responses Re: Access to postgresql query optimizer output  (Craig Ringer <ringerc@ringerc.id.au>)
Re: Access to postgresql query optimizer output  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-general
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.

Kind regards
Seref

pgsql-general by date:

Previous
From: 高健
Date:
Subject: Why BgWriterDelay is fixed?
Next
From: Craig Ringer
Date:
Subject: Re: Why PGDLLIMPORT is needed