Postgres Pro
Downloads
Home   >   mailing lists

Re: timestamp query doesn't use an index ... - Mailing list pgsql-sql

From Michael Glaesemann
Subject Re: timestamp query doesn't use an index ...
Date
Msg-id CDFEA380-8C33-4B73-8FFA-FBE4A659ADBF@seespotcode.net
Whole thread Raw
In response to timestamp query doesn't use an index ...  ("Marc G. Fournier" <scrappy@postgresql.org>)
Responses Re: timestamp query doesn't use an index ...
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: timestamp query doesn't use an index ...
Next
From: "Marc G. Fournier"
Date:
Subject: Re: timestamp query doesn't use an index ...