Re: [GENERAL] using explain to get query expected time

2009-05-25 Thread Joshua Tolley
On Mon, May 25, 2009 at 12:10:21AM -0700, Scara Maccai wrote: > 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,

[GENERAL] using explain to get query expected time

2009-05-25 Thread Scara Maccai
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) -- Sent via p