Re: That EXPLAIN ANALYZE patch still needs work - Mailing list pgsql-hackers

From Greg Stark
Subject Re: That EXPLAIN ANALYZE patch still needs work
Date
Msg-id 87y7w6gowm.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: That EXPLAIN ANALYZE patch still needs work  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: That EXPLAIN ANALYZE patch still needs work  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane <tgl@sss.pgh.pa.us> writes:

> I was intending to push forward with the idea of being able to get
> numbers out of a canceled EXPLAIN.  That will allow you to get some
> information even when the underlying query runs longer than you're
> willing to tolerate.  I still say that the number of queries where
> avoiding gettimeofday overhead would transform an intolerable runtime
> into a tolerable one is pretty limited.

Are we still going to subtract out the gettimeofday overhead?

I was always more excited about that than the sampling aspect. I've run into
queries where EXPLAIN ANALYZE results were deceptive due to the gettimeofday
overhead but I've never run into a query where gettimeofday overhead made
running the query under EXPLAIN ANALYZE impractical.


-- 
greg



pgsql-hackers by date:

Previous
From: Greg Stark
Date:
Subject: Re: ADD/DROP constraints
Next
From: Tom Lane
Date:
Subject: Re: ADD/DROP constraints