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
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
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
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
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
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
, 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