using explain to get query expected time

From: Scara Maccai <m_lists(at)yahoo(dot)it>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: using explain to get query expected time
Date: 2009-05-25 07:10:21
Message-ID: 914297.26664.qm@web24608.mail.ird.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hi,

is there any chance to get the "Planner Cost Constants" right enough to get a "good" estimate in seconds of how long a query is supposed to run?
The "rowcount" estimates are always good (there is no skew data at all in the db, values are pretty much "plain" distributed)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sebastien FLAESCH 2009-05-25 07:32:00 Re: INTERVAL data type and libpq - what format?
Previous Message Abel Camarillo 2009-05-25 06:04:36 Re: Query