Re: multiple joins + Order by + LIMIT query performance issue

From: "Guillaume Smet" <guillaume(dot)smet(at)gmail(dot)com>
To: "Antoine Baudoux" <ab(at)taktik(dot)be>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: multiple joins + Order by + LIMIT query performance issue
Date: 2008-05-06 15:38:23
Message-ID: 1d4e0c10805060838i5927b15bm26f9d9e2dac23520@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Antoine,

On Tue, May 6, 2008 at 5:03 PM, Antoine Baudoux <ab(at)taktik(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Justin 2008-05-06 15:45:42 What constitutes a complex query
Previous Message Frank van Vugt 2008-05-06 15:27:40 Re: plan difference between set-returning function with ROWS within IN() and a plain join