Re: same query in high number of times - Mailing list pgsql-performance

From Laurent Laborde
Subject Re: same query in high number of times
Date
Msg-id 8a1bfe660906230155y413b0e56w39d4b28e8bf993a4@mail.gmail.com
Whole thread Raw
In response to Re: same query in high number of times  (Laurent Laborde <kerdezixe@gmail.com>)
List pgsql-performance
On Tue, Jun 23, 2009 at 10:52 AM, Laurent Laborde<kerdezixe@gmail.com> wrote:
> On Mon, Jun 22, 2009 at 12:06 AM, Scott Marlowe<scott.marlowe@gmail.com> wrote:
>> On Sun, Jun 21, 2009 at 12:28 PM, Peter Alban<peter.alban2@gmail.com> wrote:
>>> Hi,
>>>
>>> Here is the query  :
>>> duration: 2533.734 ms  statement:
>>
>> SNIP
>>
>>>  Limit  (cost=4313.54..4313.55 rows=3 width=595) (actual
>>> time=288.525..288.528 rows=3 loops=1)
>>
>> According to this query plan, your query is taking up 288
>> milliseconds.  I'm guessing the rest of the time is actually is spent
>> transferring data.
>
> Huuuuuu ...
> The cost is _certainly_ not the time in ms.
> See the planner cost constants in a config file, or in any good documentation.

Woooops... cost... time... my mistake ... :)
*duck and cover*

--
F4FQM
Kerunix Flan
Laurent Laborde

pgsql-performance by date:

Previous
From: Laurent Laborde
Date:
Subject: Re: same query in high number of times
Next
From: Mathieu Nebra
Date:
Subject: How would you store read/unread topic status?