Re: Weird query plan

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Dennis Gearon <gearond(at)fireserve(dot)net>
Cc: Dmitry Tkach <dmitry(at)openratings(dot)com>, pg_general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Weird query plan
Date: 2003-09-17 21:37:57
Message-ID: 6125.1063834677@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dennis Gearon <gearond(at)fireserve(dot)net> writes:
> There isn't a formatter for these plans is there?

Sure. In 7.2 I think you have to set debug_pretty_print and then look
in the postmaster log (debug_pretty_print didn't affect client output
for some reason). Later versions have progressively saner ways to get
the formatted results.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dmitry Tkach 2003-09-17 21:54:05 Re: Weird query plan
Previous Message Joshua D. Drake 2003-09-17 21:33:44 Re: State of Beta (2)