Re: timestamp query doesn't use an index ...

From: Michael Glaesemann <grzm(at)seespotcode(dot)net>
To: Marc G(dot) Fournier <scrappy(at)postgresql(dot)org>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: timestamp query doesn't use an index ...
Date: 2006-05-21 01:47:39
Message-ID: CDFEA380-8C33-4B73-8FFA-FBE4A659ADBF@seespotcode.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


On May 21, 2006, at 10:42 , Marc G. Fournier wrote:

> -> Seq Scan on page_schedule ps2 (cost=0.00..2364.95
> rows=33110 width=16) (actual time=0.021..623.363 rows=94798 loops=1)

I don't know about rewriting the query, but it appears your
statistics are a little out of date (e.g., rows expected/actual
33110/94798). Does running ANALYZE help?

Michael Glaesemann
grzm seespotcode net

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Marc G. Fournier 2006-05-21 02:26:37 Re: timestamp query doesn't use an index ...
Previous Message Marc G. Fournier 2006-05-21 01:42:00 timestamp query doesn't use an index ...