live=# explain analyze SELECT id FROM calllogs WHERE from = 'you';
QUERY PLAN
----------------------------------------------------------------------------------------------------------
Seq Scan on calllogs (cost=0.00..136.11 rows=24 width=4) (actual
time=0.30..574.72 rows=143485 loops=1)
Filter: (from = 'you'::character varying)
Total runtime: 676.24 msec
(3 rows)
Have you got an index on calllogs(from)?
Have you vacuumed and analyzed that table recently?
Chris
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
