Re: Where does the time go? - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: Where does the time go?
Date
Msg-id 1143283930.24487.972.camel@localhost.localdomain
Whole thread Raw
In response to Re: Where does the time go?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Where does the time go?
List pgsql-hackers
On Wed, 2006-03-22 at 21:59 -0500, Tom Lane wrote:

> I'm betting that a
> big part of your issue is that the EXPLAIN ANALYZE instrumentation
> overhead is (1) significant

I would like to implement an additional mode for EXPLAIN ANALYZE that
does no timing instrumentation at all. Most of the time just looking for
differences between estimated and actual row counts is all you need.

For long queries, the additional time can make the execution infeasible,
yet frequently they are the ones you want to see the output for.

EXPLAIN ANALYZE NOTIMING sounds a little dry, any ideas?

Best Regards, Simon Riggs



pgsql-hackers by date:

Previous
From: Joel Miller
Date:
Subject: Re: [SUGGESTION] CVSync
Next
From: Simon Riggs
Date:
Subject: Re: [PATCHES] Automatically setting work_mem