Re: slow query - Mailing list pgsql-performance

From David Wilson
Subject Re: slow query
Date
Msg-id e7f9235d0901121555y21b13351j34d1736003781735@mail.gmail.com
Whole thread Raw
In response to slow query  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Responses Re: slow query  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-performance
On Mon, Jan 12, 2009 at 5:59 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
> I can't figure out where my time's going to.

Looks like it's going to:

->  Index Scan using users_orgid_idx on users u  (cost=0.00..129.52
rows=5 width=271) (actual time=843.825..860.638 rows=0 loops=35)

I'd guess the index/pages for users isn't in memory the first time around.

Next time is:

->  Index Scan using users_orgid_idx on users u  (cost=0.00..129.52
rows=5 width=271) (actual time=3.126..3.305 rows=0 loops=35)

--
- David T. Wilson
david.t.wilson@gmail.com

pgsql-performance by date:

Previous
From: Gregory Stark
Date:
Subject: Re: slow query
Next
From: "Scott Marlowe"
Date:
Subject: Re: slow query