explain results in pg logs

From: Marcin Mazurek <M(dot)Mazurek(at)poznan(dot)multinet(dot)pl>
To: pgsql-general(at)postgresql(dot)org
Subject: explain results in pg logs
Date: 2001-01-07 11:22:57
Message-ID: 20010107122257.A1495@poznan.mtl.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

HI,
I couldn't find an answer in doc, so here's the question. Is it possible
to to have result similar to explain command in postgres log. I've turned
on plan in pg_options but results are not to readable for me (anyone has a
doc about it?). I need it to find queries which I can optimize by using
correct indices?
Any hint?

tia
mazek

Browse pgsql-general by date

  From Date Subject
Next Message Marko Kreen 2001-01-07 11:29:38 Re: using crypt authentication
Previous Message Boon Yeo 2001-01-07 11:02:19 c++ wrappers