Re: slow query

From: "David Wilson" <david(dot)t(dot)wilson(at)gmail(dot)com>
To: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: slow query
Date: 2009-01-12 23:55:13
Message-ID: e7f9235d0901121555y21b13351j34d1736003781735@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Mon, Jan 12, 2009 at 5:59 PM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)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(dot)t(dot)wilson(at)gmail(dot)com

In response to

  • slow query at 2009-01-12 22:59:24 from Scott Marlowe

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2009-01-13 00:54:37 Re: slow query
Previous Message Gregory Stark 2009-01-12 23:51:17 Re: slow query