Re: same query in high number of times

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Peter Alban <peter(dot)alban2(at)gmail(dot)com>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: same query in high number of times
Date: 2009-06-21 22:06:41
Message-ID: dcc563d10906211506w41440cefw45d5b40d0f132048@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Justin Graf 2009-06-21 22:09:10 Re: same query in high number of times
Previous Message Peter Alban 2009-06-21 20:59:49 Re: same query in high number of times