Comment 2 for bug 716774

cold

 Aggregate (cost=341410.33..341410.34 rows=1 width=0) (actual time=135843.359..135843.359 rows=1 loops=1)
   -> Nested Loop Left Join (cost=199512.68..341408.66 rows=667 width=0) (actual time=7456.201..135841.320 rows=1154 loops=1)
         Filter: ((bugtask.product IS NULL) OR product.active)
         -> Hash Join (cost=199512.68..341191.97 rows=732 width=4) (actual time=7456.140..135825.973 rows=1155 loops=1)
               Hash Cond: (bugtask.bug = bug.id)
               Join Filter: ((((bug.fti)::tsvector @@ '''race'''::tsquery) OR ((bugtask.fti)::tsvector @@ '''race'''::tsquery)) AND ((bugtask.status = 10) OR ((bugtask.status = 15) AND (bug.date_last_message IS NOT NULL) AND (bugtask.date_incomplete <= bug.date_last_message)) OR ((bugtask.status = 15) AND ((bug.date_last_message IS NULL) OR (bugtask.date_incomplete > bug.date_last_message))) OR (bugtask.status = 17) OR (bugtask.status = 18) OR (bugtask.status = 19) OR (bugtask.status = 20) OR (bugtask.status = 21) OR (bugtask.status = 22) OR (bugtask.status = 25) OR (bugtask.status = 30)))
               -> Seq Scan on bugtask (cost=0.00..63037.94 rows=563609 width=135) (actual time=0.046..4976.433 rows=826587 loops=1)
                     Filter: ((status = 10) OR ((date_incomplete IS NOT NULL) AND (status = 15)) OR (status = 15) OR (status = 17) OR (status = 18) OR (status = 19) OR (status = 20) OR (status = 21) OR (status = 22) OR (status = 25) OR (status = 30))
               -> Hash (cost=165774.39..165774.39 rows=533143 width=386) (actual time=3860.390..3860.390 rows=530602 loops=1)
                     -> Seq Scan on bug (cost=0.00..165774.39 rows=533143 width=386) (actual time=0.018..2407.350 rows=530602 loops=1)
                           Filter: ((duplicateof IS NULL) AND (NOT private))
         -> Index Scan using product_pkey on product (cost=0.00..0.28 rows=1 width=5) (actual time=0.007..0.007 rows=0 loops=1155)
               Index Cond: (bugtask.product = product.id)
               Filter: product.active
 Total runtime: 135843.565 ms

 Aggregate (cost=341410.33..341410.34 rows=1 width=0) (actual time=12224.685..12224.685 rows=1 loops=1)
   -> Nested Loop Left Join (cost=199512.68..341408.66 rows=667 width=0) (actual time=2724.508..12223.684 rows=1154 loops=1)
         Filter: ((bugtask.product IS NULL) OR product.active)
         -> Hash Join (cost=199512.68..341191.97 rows=732 width=4) (actual time=2724.479..12215.253 rows=1155 loops=1)
               Hash Cond: (bugtask.bug = bug.id)
               Join Filter: ((((bug.fti)::tsvector @@ '''race'''::tsquery) OR ((bugtask.fti)::tsvector @@ '''race'''::tsquery)) AND ((bugtask.status = 10) OR ((bugtask.status = 15) AND (bug.date_last_message IS NOT NULL) AND (bugtask.date_incomplete <= bug.date_last_message)) OR ((bugtask.status = 15) AND ((bug.date_last_message IS NULL) OR (bugtask.date_incomplete > bug.date_last_message))) OR (bugtask.status = 17) OR (bugtask.status = 18) OR (bugtask.status = 19) OR (bugtask.status = 20) OR (bugtask.status = 21) OR (bugtask.status = 22) OR (bugtask.status = 25) OR (bugtask.status = 30)))
               -> Seq Scan on bugtask (cost=0.00..63037.94 rows=563609 width=135) (actual time=0.039..3245.829 rows=826587 loops=1)
                     Filter: ((status = 10) OR ((date_incomplete IS NOT NULL) AND (status = 15)) OR (status = 15) OR (status = 17) OR (status = 18) OR (status = 19) OR (status = 20) OR (status = 21) OR (status = 22) OR (status = 25) OR (status = 30))
               -> Hash (cost=165774.39..165774.39 rows=533143 width=386) (actual time=2475.989..2475.989 rows=530602 loops=1)
                     -> Seq Scan on bug (cost=0.00..165774.39 rows=533143 width=386) (actual time=0.019..1340.676 rows=530602 loops=1)
                           Filter: ((duplicateof IS NULL) AND (NOT private))
         -> Index Scan using product_pkey on product (cost=0.00..0.28 rows=1 width=5) (actual time=0.004..0.004 rows=0 loops=1155)
               Index Cond: (bugtask.product = product.id)
               Filter: product.active
 Total runtime: 12226.102 ms