Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group