Carlo Stonebanks wrote:
> <<Actually it's quite possible that
> that extra overhead in nested loop is largely gettimeofday() calls for the
> explain analyze. Does the query take less time run without explain analyze
> than it does run with it?
>>>
>
> Do you mean that an EXPLAIN ANALYZE that runs longer than the actual query
> is a symptom of time being lost to a function call?
It means that measuring alters the reality.
--
Alvaro Herrera http://www.flickr.com/photos/alvherre/
"I must say, I am absolutely impressed with what pgsql's implementation of
VALUES allows me to do. It's kind of ridiculous how much "work" goes away in
my code. Too bad I can't do this at work (Oracle 8/9)." (Tom Allison)
http://archives.postgresql.org/pgsql-general/2007-06/msg00016.php
