explain.depesz.com

A tool for finding a real cause for slow queries.

Result: 6nrD

options
# exclusive inclusive rows x rows loops node
1. 0.000 505.386 ↓ 76.0 76 1
→

Limit (cost=62562.09..62562.09 rows=1 width=12) (actual time=505.249..505.386 rows=76 loops=1)

2.          

Initplan (forLimit)
3. 0.126 0.362 ↑ 1.0 1 1
→

Aggregate (cost=13.64..13.65 rows=1 width=4) (actual time=0.362..0.362 rows=1 loops=1)

4. 0.236 0.236 ↓ 35.7 107 1
→

Index Scan using teamparticipation_person_idx on teamparticipation (cost=0.00..13.63 rows=3 width=4) (actual time=0.023..0.236 rows=107 loops=1)

  • Index Cond: (person = 21997)
5. 8.824 505.294 ↓ 76.0 76 1
→

Sort (cost=62548.44..62548.44 rows=1 width=12) (actual time=505.246..505.294 rows=76 loops=1)

  • Sort Key: bugtaskflat.date_last_updated
  • Sort Method: top-N heapsort Memory: 19kB
6. 24.283 496.470 ↓ 4947.0 4947 1
→

Nested Loop Left Join (cost=474.24..62548.43 rows=1 width=12) (actual time=26.141..496.470 rows=4947 loops=1)

  • Join Filter: ((product.id = bugtaskflat.product) OR (product.id = productseries.product))
  • Filter: (distribution.enable_bug_expiration OR product.enable_bug_expiration)
7. 16.608 437.558 ↓ 4947.0 4947 1
→

Nested Loop Anti Join (cost=465.72..62532.01 rows=1 width=21) (actual time=26.116..437.558 rows=4947 loops=1)

8. 16.316 356.050 ↓ 5900.0 5900 1
→

Nested Loop Left Join (cost=465.72..62525.96 rows=1 width=25) (actual time=26.083..356.050 rows=5900 loops=1)

9. 18.735 333.834 ↓ 5900.0 5900 1
→

Nested Loop (cost=465.72..62517.67 rows=1 width=25) (actual time=26.075..333.834 rows=5900 loops=1)

10. 21.426 232.499 ↓ 5900.0 5900 1
→

Nested Loop Left Join (cost=465.72..62511.93 rows=1 width=25) (actual time=26.022..232.499 rows=5900 loops=1)

  • Filter: (bugwatch.id IS NULL)
11. 18.784 162.213 ↓ 15.5 6980 1
→

Nested Loop (cost=465.72..60639.06 rows=450 width=25) (actual time=25.993..162.213 rows=6980 loops=1)

  • Join Filter: ((distribution.id = bugtaskflat.distribution) OR (distribution.id = distroseries.distribution))
12. 0.048 0.048 ↑ 1.0 1 1
→

Seq Scan on distribution (cost=0.00..6.45 rows=1 width=5) (actual time=0.045..0.048 rows=1 loops=1)

  • Filter: (id = 1)
13. 25.709 143.381 ↓ 1.0 11983 1
→

Hash Left Join (cost=465.72..60454.93 rows=11845 width=32) (actual time=25.885..143.381 rows=11983 loops=1)

  • Hash Cond: (bugtaskflat.distroseries = distroseries.id)
14. 105.454 117.565 ↓ 1.0 11983 1
→

Bitmap Heap Scan on bugtaskflat (cost=461.69..60402.89 rows=11845 width=32) (actual time=25.745..117.565 rows=11983 loops=1)

  • Recheck Cond: (status = ANY ('{15,13,14}'::integer[]))
  • Filter: ((assignee IS NULL) AND (milestone IS NULL) AND (duplicateof IS NULL) AND ((information_type = ANY ('{1,2}'::integer[])) OR (access_grants && $0)))
15. 12.111 12.111 ↓ 1.0 24721 1
→

Bitmap Index Scan on bugtaskflat__status__bugtask__idx (cost=0.00..458.72 rows=24245 width=0) (actual time=12.111..12.111 rows=24721 loops=1)

  • Index Cond: (status = ANY ('{15,13,14}'::integer[]))
16. 0.048 0.107 ↑ 1.0 46 1
→

Hash (cost=3.46..3.46 rows=46 width=8) (actual time=0.107..0.107 rows=46 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 2kB
17. 0.059 0.059 ↑ 1.0 46 1
→

Seq Scan on distroseries (cost=0.00..3.46 rows=46 width=8) (actual time=0.012..0.059 rows=46 loops=1)

18. 48.860 48.860 ↓ 0.0 0 6980
→

Index Scan using bugwatch_bug_idx on bugwatch (cost=0.00..4.14 rows=2 width=8) (actual time=0.006..0.007 rows=0 loops=6980)

  • Index Cond: (bug = bugtaskflat.bug)
19. 82.600 82.600 ↑ 1.0 1 5900
→

Index Scan using bug_pkey on bug (cost=0.00..5.73 rows=1 width=4) (actual time=0.012..0.014 rows=1 loops=5900)

  • Index Cond: (id = bugtaskflat.bug)
  • Filter: (date_last_updated < (timezone('UTC'::text, now()) - '00:00:00'::interval))
20. 5.900 5.900 ↓ 0.0 0 5900
→

Index Scan using productseries_pkey on productseries (cost=0.00..8.27 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=5900)

  • Index Cond: (id = bugtaskflat.productseries)
21. 64.900 64.900 ↓ 0.0 0 5900
→

Index Scan using bugtaskflat__bug__idx on bugtaskflat relatedbugtaskflat (cost=0.00..6.04 rows=1 width=4) (actual time=0.011..0.011 rows=0 loops=5900)

  • Index Cond: (bug = bugtaskflat.bug)
  • Filter: (status = ANY ('{10,16,19,20,21,22,25,30,999}'::integer[]))
22. 9.894 34.629 ↓ 0.0 0 4947
→

Bitmap Heap Scan on product (cost=8.52..16.39 rows=2 width=5) (actual time=0.007..0.007 rows=0 loops=4947)

  • Recheck Cond: ((id = bugtaskflat.product) OR (id = productseries.product))
23. 14.841 24.735 ↓ 0.0 0 4947
→

BitmapOr (cost=8.52..8.52 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=4947)

24. 4.947 4.947 ↓ 0.0 0 4947
→

Bitmap Index Scan on product_pkey (cost=0.00..4.26 rows=1 width=0) (actual time=0.001..0.001 rows=0 loops=4947)

  • Index Cond: (id = bugtaskflat.product)
25. 4.947 4.947 ↓ 0.0 0 4947
→

Bitmap Index Scan on product_pkey (cost=0.00..4.26 rows=1 width=0) (actual time=0.001..0.001 rows=0 loops=4947)

  • Index Cond: (id = productseries.product)