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. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
