Marc G. Fournier [EMAIL PROTECTED] writes:
- Bitmap Heap Scan on page_schedule ps2 (cost=573.65..2822.86
rows=91614 width=16) (actual time=149.788..505.438 rows=94798 loops=1)
Recheck Cond: (timezone('MST7MDT'::text, start_time) = '2006-05-17
08:09:18'::timestamp without time
On Sun, 21 May 2006, Michael Glaesemann wrote:
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