Re: same query in high number of times

On Mon, Jun 22, 2009 at 12:06 AM, Scott Marlowe<scott(dot)marlowe(at)gmail(dot)com> wrote:
> On Sun, Jun 21, 2009 at 12:28 PM, Peter Alban<peter(dot)alban2(at)gmail(dot)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.

--
F4FQM
Kerunix Flan
Laurent Laborde