On Tue, Jun 23, 2009 at 10:52 AM, Laurent Laborde<kerdezixe@xxxxxxxxx> wrote: > On Mon, Jun 22, 2009 at 12:06 AM, Scott Marlowe<scott.marlowe@xxxxxxxxx> wrote: >> On Sun, Jun 21, 2009 at 12:28 PM, Peter Alban<peter.alban2@xxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
