Thread: multiple joins + Order by + LIMIT query performance issue
View Single Post

   
  #2 (permalink)  
Old 05-07-2008, 11:19 AM
Guillaume Smet
 
Posts: n/a
Default Re: multiple joins + Order by + LIMIT query performance issue
Antoine,

On Tue, May 6, 2008 at 5:03 PM, Antoine Baudoux <ab@taktik.be> wrote:
> "Limit (cost=23981.18..23981.18 rows=1 width=977)"
> " -> Sort (cost=23981.18..23981.18 rows=1 width=977)"
> " Sort Key: this_.c_date"

Can you please provide the EXPLAIN ANALYZE output instead of EXPLAIN?

Thanks.

--
Guillaume

--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

Reply With Quote