Re: Slow query - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Slow query
Date
Msg-id 200303241147.09853.josh@agliodbs.com
Whole thread Raw
In response to Slow query  (Oleg Lebedev <oleg.lebedev@waterford.org>)
List pgsql-performance
Stephan,

Hmmm ... I'm a bit confused by the new EXPLAIN output.   Stefan, does Oleg's
output show the time for *one* subplan execution, executed for 44,000 loops,
or does it show the total time?  The former would make more sense given his
query, but I'm just not sure ....


--
-Josh Berkus
 Aglio Database Solutions
 San Francisco


pgsql-performance by date:

Previous
From: Oleg Lebedev
Date:
Subject: Re: Slow query
Next
From: Oleg Lebedev
Date:
Subject: Re: Slow query