Re: Incorrect Total runtime Reported by Explain Analyze!?

On Thu, 2006-01-26 at 11:57, Michael Fuhr wrote:
> On Thu, Jan 26, 2006 at 04:49:59PM +0000, Richard Huxton wrote:
> > Jozsef Szalay wrote:
> > >I have seen it on occasion that the total runtime reported by explain
> > >analyze was much higher than the actual time the query needed to
> > >complete. The differences in my case ranged between 20-120 seconds. I'm
> > >just curious if anyone else has experienced this and whether there is
> > >something that I can do to convince explain analyze to report the
> > >execution time of the query itself rather than the time of its own
> > >execution. Engine version is 8.1.1.
> >
> > I think it's down to all the gettime() calls that have to be made to
> > measure how long each stage of the query takes. In some cases these can
> > take a substantial part of the overall query time.
>
> Another possibility is that the total query time was indeed that
> long because the query was blocked waiting for a lock. For example:

Could be, but I've had this happen where the query returned in like 1
second but reported 30 seconds run time.