explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qur2

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.683 12.432 ↓ 9.1 1,526 1

Hash Join (cost=695.57..1,417.20 rows=167 width=2,992) (actual time=2.749..12.432 rows=1,526 loops=1)

  • Hash Cond: (buildrecor1_.user_id = user13_.id)
2. 0.685 11.729 ↓ 9.1 1,526 1

Hash Left Join (cost=692.73..1,413.89 rows=167 width=2,945) (actual time=2.723..11.729 rows=1,526 loops=1)

  • Hash Cond: (buildrecor1_.productmilestone_id = productmil12_.id)
3. 0.557 11.000 ↓ 9.1 1,526 1

Hash Left Join (cost=688.05..1,408.76 rows=167 width=2,839) (actual time=2.675..11.000 rows=1,526 loops=1)

  • Hash Cond: (buildrecor1_.buildenvironment_id = buildenvir11_.id)
4. 0.596 10.430 ↓ 9.1 1,526 1

Hash Left Join (cost=686.58..1,406.85 rows=167 width=2,644) (actual time=2.656..10.430 rows=1,526 loops=1)

  • Hash Cond: (buildconfi2_.user_id = user10_.id)
5. 0.595 9.818 ↓ 9.1 1,526 1

Hash Left Join (cost=683.73..1,403.55 rows=167 width=2,597) (actual time=2.635..9.818 rows=1,526 loops=1)

  • Hash Cond: (buildconfi2_.productversion_id = productver9_.id)
6. 0.529 9.176 ↓ 9.1 1,526 1

Hash Left Join (cost=680.12..1,399.49 rows=167 width=2,580) (actual time=2.583..9.176 rows=1,526 loops=1)

  • Hash Cond: (productmil5_.id = productrel8_.productmilestone_id)
7. 0.569 8.646 ↓ 9.1 1,526 1

Hash Left Join (cost=669.22..1,387.40 rows=167 width=898) (actual time=2.569..8.646 rows=1,526 loops=1)

  • Hash Cond: (productver6_.product_id = product7_.id)
8. 0.560 8.059 ↓ 9.1 1,526 1

Hash Left Join (cost=666.22..1,383.94 rows=167 width=800) (actual time=2.547..8.059 rows=1,526 loops=1)

  • Hash Cond: (productmil5_.productversion_id = productver6_.id)
9. 0.549 7.471 ↓ 9.1 1,526 1

Hash Left Join (cost=662.61..1,379.88 rows=167 width=783) (actual time=2.513..7.471 rows=1,526 loops=1)

  • Hash Cond: (productver4_.currentproductmilestone_id = productmil5_.id)
10. 0.479 6.866 ↓ 9.1 1,526 1

Hash Left Join (cost=657.93..1,374.75 rows=167 width=677) (actual time=2.452..6.866 rows=1,526 loops=1)

  • Hash Cond: (buildconfi3_.productversion_id = productver4_.id)
11. 0.513 6.355 ↓ 9.1 1,526 1

Hash Left Join (cost=654.32..1,370.69 rows=167 width=660) (actual time=2.417..6.355 rows=1,526 loops=1)

  • Hash Cond: (buildconfi2_.buildconfigurationset_id = buildconfi3_.id)
12. 0.536 5.753 ↓ 9.1 1,526 1

Hash Left Join (cost=635.96..1,351.89 rows=167 width=623) (actual time=2.324..5.753 rows=1,526 loops=1)

  • Hash Cond: (buildrecor1_.buildconfigsetrecord_id = buildconfi2_.id)
13. 1.674 5.014 ↓ 9.1 1,526 1

Hash Join (cost=614.00..1,329.49 rows=167 width=583) (actual time=2.114..5.014 rows=1,526 loops=1)

  • Hash Cond: (buildrecor1_.id = dependantb0_.build_record_id)
14. 1.243 1.243 ↑ 1.0 7,721 1

Seq Scan on buildrecord buildrecor1_ (cost=0.00..695.21 rows=7,721 width=575) (actual time=0.010..1.243 rows=7,721 loops=1)

15. 0.163 2.097 ↓ 9.1 1,526 1

Hash (cost=611.91..611.91 rows=167 width=8) (actual time=2.097..2.097 rows=1,526 loops=1)

  • Buckets: 2048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 76kB
16. 1.759 1.934 ↓ 9.1 1,526 1

Bitmap Heap Scan on build_record_artifact_dependencies_map dependantb0_ (cost=5.72..611.91 rows=167 width=8) (actual time=0.333..1.934 rows=1,526 loops=1)

  • Recheck Cond: (dependency_artifact_id = 13)
  • Heap Blocks: exact=1520
17. 0.175 0.175 ↓ 9.3 1,554 1

Bitmap Index Scan on idx_build_record_artifact_dependencies_map (cost=0.00..5.68 rows=167 width=0) (actual time=0.175..0.175 rows=1,554 loops=1)

  • Index Cond: (dependency_artifact_id = 13)
18. 0.094 0.203 ↓ 1.1 711 1

Hash (cost=13.65..13.65 rows=665 width=40) (actual time=0.203..0.203 rows=711 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 61kB
19. 0.109 0.109 ↓ 1.1 711 1

Seq Scan on buildconfigsetrecord buildconfi2_ (cost=0.00..13.65 rows=665 width=40) (actual time=0.006..0.109 rows=711 loops=1)

20. 0.046 0.089 ↑ 1.2 499 1

Hash (cost=10.94..10.94 rows=594 width=37) (actual time=0.089..0.089 rows=499 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 43kB
21. 0.043 0.043 ↑ 1.2 499 1

Seq Scan on buildconfigurationset buildconfi3_ (cost=0.00..10.94 rows=594 width=37) (actual time=0.004..0.043 rows=499 loops=1)

22. 0.014 0.032 ↓ 1.1 126 1

Hash (cost=2.16..2.16 rows=116 width=17) (actual time=0.032..0.032 rows=126 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
23. 0.018 0.018 ↓ 1.1 126 1

Seq Scan on productversion productver4_ (cost=0.00..2.16 rows=116 width=17) (actual time=0.005..0.018 rows=126 loops=1)

24. 0.029 0.056 ↓ 1.2 139 1

Hash (cost=3.19..3.19 rows=119 width=106) (actual time=0.056..0.056 rows=139 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 24kB
25. 0.027 0.027 ↓ 1.2 139 1

Seq Scan on productmilestone productmil5_ (cost=0.00..3.19 rows=119 width=106) (actual time=0.004..0.027 rows=139 loops=1)

26. 0.013 0.028 ↓ 1.1 126 1

Hash (cost=2.16..2.16 rows=116 width=17) (actual time=0.028..0.028 rows=126 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
27. 0.015 0.015 ↓ 1.1 126 1

Seq Scan on productversion productver6_ (cost=0.00..2.16 rows=116 width=17) (actual time=0.003..0.015 rows=126 loops=1)

28. 0.010 0.018 ↓ 1.1 95 1

Hash (cost=1.89..1.89 rows=89 width=98) (actual time=0.018..0.018 rows=95 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
29. 0.008 0.008 ↓ 1.1 95 1

Seq Scan on product product7_ (cost=0.00..1.89 rows=89 width=98) (actual time=0.003..0.008 rows=95 loops=1)

30. 0.000 0.001 ↓ 0.0 0 1

Hash (cost=10.40..10.40 rows=40 width=1,682) (actual time=0.001..0.001 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
31. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on productrelease productrel8_ (cost=0.00..10.40 rows=40 width=1,682) (actual time=0.001..0.001 rows=0 loops=1)

32. 0.014 0.047 ↓ 1.1 126 1

Hash (cost=2.16..2.16 rows=116 width=17) (actual time=0.047..0.047 rows=126 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
33. 0.033 0.033 ↓ 1.1 126 1

Seq Scan on productversion productver9_ (cost=0.00..2.16 rows=116 width=17) (actual time=0.003..0.033 rows=126 loops=1)

34. 0.008 0.016 ↓ 1.1 87 1

Hash (cost=1.82..1.82 rows=82 width=47) (actual time=0.016..0.016 rows=87 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
35. 0.008 0.008 ↓ 1.1 87 1

Seq Scan on usertable user10_ (cost=0.00..1.82 rows=82 width=47) (actual time=0.002..0.008 rows=87 loops=1)

36. 0.006 0.013 ↓ 1.2 25 1

Hash (cost=1.21..1.21 rows=21 width=195) (actual time=0.013..0.013 rows=25 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
37. 0.007 0.007 ↓ 1.2 25 1

Seq Scan on buildenvironment buildenvir11_ (cost=0.00..1.21 rows=21 width=195) (actual time=0.003..0.007 rows=25 loops=1)

38. 0.022 0.044 ↓ 1.2 139 1

Hash (cost=3.19..3.19 rows=119 width=106) (actual time=0.044..0.044 rows=139 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 24kB
39. 0.022 0.022 ↓ 1.2 139 1

Seq Scan on productmilestone productmil12_ (cost=0.00..3.19 rows=119 width=106) (actual time=0.002..0.022 rows=139 loops=1)

40. 0.009 0.020 ↓ 1.1 87 1

Hash (cost=1.82..1.82 rows=82 width=47) (actual time=0.020..0.020 rows=87 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
41. 0.011 0.011 ↓ 1.1 87 1

Seq Scan on usertable user13_ (cost=0.00..1.82 rows=82 width=47) (actual time=0.005..0.011 rows=87 loops=1)

Planning time : 2.811 ms
Execution time : 12.698 ms