[PERFORM] Incorrect Total runtime Reported by Explain Analyze!?

2006-01-26 Thread Jozsef Szalay
Hi All, 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. Im just curious if anyone else has experienced this and whether there is

Re: [PERFORM] Incorrect Total runtime Reported by Explain Analyze!?

2006-01-26 Thread Scott Marlowe
On Thu, 2006-01-26 at 09:50, Jozsef Szalay wrote: Hi All, 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

Re: [PERFORM] Incorrect Total runtime Reported by Explain Analyze!?

2006-01-26 Thread Richard Huxton
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

Re: [PERFORM] Incorrect Total runtime Reported by Explain Analyze!?

2006-01-26 Thread Jozsef Szalay
Total runtime Reported by Explain Analyze!? 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

Re: [PERFORM] Incorrect Total runtime Reported by Explain Analyze!?

2006-01-26 Thread Michael Fuhr
On Thu, Jan 26, 2006 at 04:49:59PM +, 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

Re: [PERFORM] Incorrect Total runtime Reported by Explain Analyze!?

2006-01-26 Thread Scott Marlowe
On Thu, 2006-01-26 at 11:57, Michael Fuhr wrote: On Thu, Jan 26, 2006 at 04:49:59PM +, 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

Re: [PERFORM] Incorrect Total runtime Reported by Explain Analyze!?

2006-01-26 Thread Jozsef Szalay
, 2006 11:57 AM To: Richard Huxton Cc: Jozsef Szalay; pgsql-performance@postgresql.org Subject: Re: [PERFORM] Incorrect Total runtime Reported by Explain Analyze!? On Thu, Jan 26, 2006 at 04:49:59PM +, Richard Huxton wrote: Jozsef Szalay wrote: I have seen it on occasion that the total runtime