Aggregate  (cost=816866.73..816866.74 rows=1 width=0)
   ->  Nested Loop  (cost=705926.62..816816.29 rows=20177 width=0)
         ->  HashAggregate  (cost=705926.62..706128.39 rows=20177 width=280)
               ->  Append  (cost=0.00..704564.67 rows=20177 width=280)
                     ->  Nested Loop Left Join  (cost=0.00..71.68 rows=3 width=280)
                           Filter: ((public.bugtask.product IS NULL) OR public.product.active)
                           ->  Nested Loop  (cost=0.00..52.83 rows=3 width=280)
                                 ->  Index Scan using bugtask__assignee__idx on bugtask  (cost=0.00..32.64 rows=3 width=280)
                                       Index Cond: (assignee = 343381)
                                       Filter: ((status = 10) OR (status = 15) OR (status = 20) OR (status = 21) OR (status = 22) OR (status = 25))
                                 ->  Index Scan using bug_pkey on bug  (cost=0.00..6.72 rows=1 width=4)
                                       Index Cond: (public.bug.id = public.bugtask.bug)
                                       Filter: ((public.bug.duplicateof IS NULL) AND (public.bug.latest_patch_uploaded IS NOT NULL) AND (NOT public.bug.private))
                           ->  Index Scan using product_pkey on product  (cost=0.00..6.27 rows=1 width=5)
                                 Index Cond: (public.bugtask.product = public.product.id)
                                 Filter: public.product.activeh, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, B                     ->  Nested Loop  (cost=0.00..1304.50 rows=4 width=280)sk.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.heat, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.OWNER, BugTask.product, BugTask                           ->  Nested Loop Left Join  (cost=0.00..1008.40 rows=44 width=284)k.targetnamecache
                                 Filter: ((public.bugtask.product IS NULL) OR public.product.active)
                                 ->  Nested Loop  (cost=0.00..993.50 rows=48 width=284)
                                       ->  Index Scan using bugsubscription_person_idx on bugsubscription  (cost=0.00..255.56 rows=115 width=4)
                                             Index Cond: (person = 343381)
                                       ->  Index Scan using bugtask__bug__idx on bugtask  (cost=0.00..6.40 rows=1 width=280)
                                             Index Cond: (public.bugtask.bug = bugsubscription.bug)
                                             Filter: ((public.bugtask.status = 10) OR (public.bugtask.status = 15) OR (public.bugtask.status = 20) OR (public.bugtask.status = 21) OR (public.bugtask.status = 22) OR (public.bugtask.status = 25)) Bug ON BugTask.bug = Bug.id;E)) AS BugTaskr = 343381lestone, BugsepackagenameroductgTask.targetnamecacheon, BugTask.distroseries, BugTask.heat, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.OWNER, BugTask.product, BugTask
                                 ->  Index Scan using product_pkey on product  (cost=0.00..0.30 rows=1 width=5)
                                       Index Cond: (public.bugtask.product = public.product.id)
                                       Filter: public.product.active
                           ->  Index Scan using bug_pkey on bug  (cost=0.00..6.72 rows=1 width=4)
                                 Index Cond: (public.bug.id = public.bugtask.bug)
                                 Filter: ((public.bug.duplicateof IS NULL) AND (public.bug.latest_patch_uploaded IS NOT NULL) AND (NOT public.bug.private))
                     ->  Nested Loop Left Join  (cost=0.00..22.51 rows=1 width=280)
                           Filter: ((public.bugtask.product IS NULL) OR public.product.active)
                           ->  Nested Loop  (cost=0.00..16.22 rows=1 width=280)
                                 ->  Index Scan using bug_owner_idx on bug  (cost=0.00..9.78 rows=1 width=4)
                                       Index Cond: (owner = 343381)
                                       Filter: ((duplicateof IS NULL) AND (latest_patch_uploaded IS NOT NULL) AND (NOT private))
                                 ->  Index Scan using bugtask__bug__idx on bugtask  (cost=0.00..6.43 rows=1 width=280)
                                       Index Cond: (public.bugtask.bug = public.bug.id)
                                       Filter: ((public.bugtask.owner = 343381) AND ((public.bugtask.status = 10) OR (public.bugtask.status = 15) OR (public.bugtask.status = 20) OR (public.bugtask.status = 21) OR (public.bugtask.status = 22) OR (public.bugtask.status = 25)))
                           ->  Index Scan using product_pkey on product  (cost=0.00..6.27 rows=1 width=5)
                                 Index Cond: (public.bugtask.product = public.product.id)
                                 Filter: public.product.active
                     ->  Nested Loop Left Join  (cost=33.94..60.63 rows=1 width=280)
                           Filter: ((public.bugtask.product IS NULL) OR public.product.active)
                           ->  Nested Loop  (cost=33.94..60.32 rows=1 width=280)
                                 ->  Nested Loop  (cost=33.94..46.86 rows=2 width=284)
                                       ->  HashAggregate  (cost=33.94..33.96 rows=2 width=4)
                                             ->  Index Scan using bugmessage__owner__index__idx on bugmessage  (cost=0.00..33.91 rows=10 width=4)
                                                   Index Cond: ((owner = 343381) AND (index > 0))
                                       ->  Index Scan using bugtask__bug__idx on bugtask  (cost=0.00..6.43 rows=1 width=280)
                                             Index Cond: (public.bugtask.bug = bugmessage.bug)
                                             Filter: ((public.bugtask.status = 10) OR (public.bugtask.status = 15) OR (public.bugtask.status = 20) OR (public.bugtask.status = 21) OR (public.bugtask.status = 22) OR (public.bugtask.status = 25))
                                 ->  Index Scan using bug_pkey on bug  (cost=0.00..6.72 rows=1 width=4)
                                       Index Cond: (public.bug.id = public.bugtask.bug)
                                       Filter: ((public.bug.duplicateof IS NULL) AND (public.bug.latest_patch_uploaded IS NOT NULL) AND (NOT public.bug.private))

                           ->  Index Scan using product_pkey on product  (cost=0.00..0.30 rows=1 width=5)
                                 Index Cond: (public.bugtask.product = public.product.id)
                                 Filter: public.product.active
                     ->  Nested Loop  (cost=43392.43..702903.59 rows=20168 width=280)
                           Join Filter: ((public.bugtask.product = structuralsubscription.product) OR (public.bugtask.productseries = structuralsubscription.productseries) OR ((public.product.project = structuralsubscription.project) AND (public.bugtask.product = public.product.id)) OR ((public.bugtask.distribution = structuralsubscription.distribution) AND ((public.bugtask.sourcepackagename = structuralsubscription.sourcepackagename) OR (structuralsubscription.sourcepackagename IS NULL))) OR (public.bugtask.distroseries = structuralsubscription.distroseries) OR (public.bugtask.milestone = structuralsubscription.milestone))
                           ->  Bitmap Heap Scan on structuralsubscription  (cost=4.48..188.09 rows=1 width=28)
                                 Recheck Cond: (subscriber = 343381)
                                 Filter: (((subscriber = 343381) AND (product IS NOT NULL)) OR ((subscriber = 343381) AND (productseries IS NOT NULL)) OR ((subscriber = 343381) AND (project IS NOT NULL)) OR ((subscriber = 343381) AND (distribution IS NOT NULL) AND (sourcepackagename IS NOT NULL)) OR ((subscriber = 343381) AND (distribution IS NOT NULL) AND (sourcepackagename IS NULL)) OR ((subscriber = 343381) AND (distroseries IS NOT NULL)) OR ((subscriber = 343381) AND (milestone IS NOT NULL)))
                                 ->  Bitmap Index Scan on structuralsubscription__subscriber__idx  (cost=0.00..4.48 rows=164 width=0)
                                       Index Cond: (subscriber = 343381)
                           ->  Nested Loop Left Join  (cost=43387.94..702110.46 rows=20168 width=288)
                                 Filter: ((public.bugtask.product IS NULL) OR public.product.active)
                                 ->  Nested Loop  (cost=43387.94..695244.24 rows=22125 width=280)
                                       ->  Bitmap Heap Scan on bug  (cost=43387.94..614073.75 rows=22125 width=4)
                                             Recheck Cond: (duplicateof IS NULL)
                                             Filter: ((latest_patch_uploaded IS NOT NULL) AND (NOT private))
                                             ->  Bitmap Index Scan on bug_duplicateof_idx  (cost=0.00..43382.41 rows=577824 width=0)
                                                   Index Cond: (duplicateof IS NULL)
                                       ->  Index Scan using bugtask__bug__idx on bugtask  (cost=0.00..3.66 rows=1 width=280)
                                             Index Cond: (public.bugtask.bug = public.bug.id)
                                             Filter: ((public.bugtask.status = 10) OR (public.bugtask.status = 15) OR (public.bugtask.status = 20) OR (public.bugtask.status = 21) OR (public.bugtask.status = 22) OR (public.bugtask.status = 25))
                                 ->  Index Scan using product_pkey on product  (cost=0.00..0.30 rows=1 width=9)
                                       Index Cond: (public.bugtask.product = public.product.id)
                                       Filter: public.product.active
         ->  Index Scan using bug_pkey on bug  (cost=0.00..5.46 rows=1 width=4)
               Index Cond: (public.bug.id = public.bugtask.bug)