Postgres Pro
Downloads
Home   >   mailing lists

Re: multiple joins + Order by + LIMIT query performance issue - Mailing list pgsql-performance

From Guillaume Smet
Subject Re: multiple joins + Order by + LIMIT query performance issue
Date
Msg-id 1d4e0c10805060838i5927b15bm26f9d9e2dac23520@mail.gmail.com
Whole thread Raw
In response to multiple joins + Order by + LIMIT query performance issue  (Antoine Baudoux <ab@taktik.be>)
Responses Re: multiple joins + Order by + LIMIT query performance issue
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Antoine Baudoux
Date:
Subject: multiple joins + Order by + LIMIT query performance issue
Next
From: Justin
Date:
Subject: What constitutes a complex query