Access to postgresql query optimizer output

From: Seref Arikan <serefarikan(at)kurumsalteknoloji(dot)com>
To: PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Access to postgresql query optimizer output
Date: 2012-10-29 08:07:28
Message-ID: CA+4ThdqLSaGUjBjD6qoeW+u4yd4+KqfhmyE3YKbU0UfsdMX46w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2012-10-29 08:41:05 Re: Why PGDLLIMPORT is needed
Previous Message 高健 2012-10-29 07:17:10 Why BgWriterDelay is fixed?