Re: [PATCH] Improve EXPLAIN ANALYZE overhead by sampling - Mailing list pgsql-patches

From Rocco Altier
Subject Re: [PATCH] Improve EXPLAIN ANALYZE overhead by sampling
Date
Msg-id 6E0907A94904D94B99D7F387E08C4F57010A5E8C@FALCON.INSIGHT
Whole thread Raw
In response to [PATCH] Improve EXPLAIN ANALYZE overhead by sampling  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: [PATCH] Improve EXPLAIN ANALYZE overhead by sampling  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-patches
> - To get this close it needs to get an estimate of the sampling
overhead.
> It does this by a little calibration loop that is run once per
backend.
> If you don't do this, you end up assuming all tuples take the same
time
> as tuples with the overhead, resulting in nodes apparently taking
> longer than their parent nodes. Incidently, I measured the overhead to
> be about 3.6us per tuple per node on my (admittedly slightly old)
> machine.

Could this be deferred until the first explain analyze?  So that we
aren't paying the overhead of the calibration in all backends, even the
ones that won't be explaining?

    -rocco

pgsql-patches by date:

Previous
From: Simon Riggs
Date:
Subject: Re: [PATCH] Improve EXPLAIN ANALYZE overhead by sampling
Next
From: Martijn van Oosterhout
Date:
Subject: Re: [PATCH] Improve EXPLAIN ANALYZE overhead by sampling