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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: "Antoine Baudoux" <ab@xxxxxxxxx>
Subject: Re: multiple joins + Order by + LIMIT query performance issue
From: "Guillaume Smet" <guillaume.smet@xxxxxxxxx>
Date: Tue, 6 May 2008 17:38:23 +0200
Cc: pgsql-performance@xxxxxxxxxxxxxx
In-reply-to: <938EC908-FB9A-4BFA-950A-053BE3C87085@xxxxxxxxx>
References: <938EC908-FB9A-4BFA-950A-053BE3C87085@xxxxxxxxx>

Antoine,

On Tue, May 6, 2008 at 5:03 PM, Antoine Baudoux <ab@xxxxxxxxx> 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

Follow-Ups:
- Re: multiple joins + Order by + LIMIT query performance issue
  - From: Antoine Baudoux

References:
- multiple joins + Order by + LIMIT query performance issue
  - From: Antoine Baudoux

Prev by Date: multiple joins + Order by + LIMIT query performance issue
Next by Date: What constitutes a complex query
Previous by thread: multiple joins + Order by + LIMIT query performance issue
Next by thread: Re: multiple joins + Order by + LIMIT query performance issue
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux