Home > mailing lists

using explain to get query expected time - Mailing list pgsql-general

From	Scara Maccai
Subject	using explain to get query expected time
Date	May 25, 2009 07:10:26
Msg-id	914297.26664.qm@web24608.mail.ird.yahoo.com Whole thread Raw
Responses	Re: using explain to get query expected time (Joshua Tolley <eggyknap@gmail.com>)
List	pgsql-general

Tree view

Hi,

is there any chance to get the "Planner Cost Constants" right enough to get a "good" estimate in seconds of how long a
queryis 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)

pgsql-general by date:

From: Abel Camarillo
Date: 25 May 2009, 06:30:57
Subject: Re: Query

From: Sebastien FLAESCH
Date: 25 May 2009, 07:31:49
Subject: Re: INTERVAL data type and libpq - what format?

using explain to get query expected time - Mailing list pgsql-general

Previous

Next