[SQL] Query Performance

Hello List, I have a query which use to run very fast now has turn into show stopper . PostgreSQL:8.2 explain analyze select user_name,A.user_id, dnd_window_start, dnd_window_stop, B.subs as subs, B.city_id as city_id, B.source_type as source_type from

Re: [SQL] Query Performance

time=6909.632..6909.632 rows=3758304 loops=1) -> Seq Scan on user_subscriptions u (cost=0.00..77415.54 rows=3746154 width=49) (actual time=3.624..4265.114 rows=3758304 loops=1) Total runtime: 192585.437 ms ____ From: "t...@fuzzy.cz" To: Pos