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

From Tom Lane
Subject Re: Where does the time go?
Date
Msg-id 27386.1143082792@sss.pgh.pa.us
Whole thread Raw
In response to Where does the time go?  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: Where does the time go?  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Re: Where does the time go?  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-hackers
"Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
> I have some odd results from timing two versions of an update query, and
> was hoping to get a better handle on how to interpret this.

You didn't show us the explain analyze results, but I'm betting that a
big part of your issue is that the EXPLAIN ANALYZE instrumentation
overhead is (1) significant and (2) different for the two query plans.
The instrumentation overhead should be about the same for any one plan
node execution, but the two plans could involve very different numbers
of plan node executions ...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: On vacation
Next
From: "Andrew Dunstan"
Date:
Subject: Re: Static build of psql with readline support