explain.depesz.com

PostgreSQL's explain analyze made readable

Result: grXe

Settings
# exclusive inclusive rows x rows loops node
1. 10.839 531.186 ↓ 1.6 10,361 1

Hash Right Join (cost=14,903.31..188,799.21 rows=6,495 width=544) (actual time=196.926..531.186 rows=10,361 loops=1)

  • Hash Cond: (jcv.job_id = j.job_id)
  • Functions: 402
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 58.772 ms, Inlining 0.000 ms, Optimization 28.416 ms, Emission 407.510 ms, Total 494.698 ms
2. 0.000 19.137 ↓ 1.3 8,715 1

Gather (cost=1,000.00..91,323.15 rows=6,483 width=35) (actual time=6.245..19.137 rows=8,715 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
3. 120.830 120.830 ↓ 1.1 1,743 5 / 5

Parallel Seq Scan on jobcolourvalues jcv (cost=0.00..89,674.85 rows=1,621 width=35) (actual time=9.657..120.830 rows=1,743 loops=5)

  • Filter: ((type = 14) AND (dot = '100'::double precision))
  • Rows Removed by Filter: 255,873
4. 2.743 190.380 ↑ 1.0 4,686 1

Hash (cost=13,844.63..13,844.63 rows=4,694 width=453) (actual time=190.380..190.380 rows=4,686 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 2,236kB
5. 28.470 187.637 ↑ 1.0 4,686 1

Gather (cost=1,575.95..13,844.63 rows=4,694 width=453) (actual time=144.106..187.637 rows=4,686 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
6. 0.296 159.167 ↑ 1.3 1,172 4 / 4

Hash Left Join (cost=575.95..12,375.23 rows=1,514 width=453) (actual time=113.324..159.167 rows=1,172 loops=4)

  • Hash Cond: (j.subcategory_id = scg.subcategory_id)
7. 0.277 158.837 ↑ 1.3 1,172 4 / 4

Hash Left Join (cost=574.90..12,364.77 rows=1,514 width=443) (actual time=113.283..158.837 rows=1,172 loops=4)

  • Hash Cond: (j.category_id = cg.category_id)
8. 0.466 158.501 ↑ 1.3 1,172 4 / 4

Hash Join (cost=573.86..12,354.31 rows=1,514 width=431) (actual time=113.196..158.501 rows=1,172 loops=4)

  • Hash Cond: (sj.site_id = st.site_id)
9. 0.311 59.097 ↑ 1.3 1,172 4 / 4

Hash Join (cost=571.62..12,347.79 rows=1,514 width=402) (actual time=14.099..59.097 rows=1,172 loops=4)

  • Hash Cond: (j.operator_id = op.operator_id)
10. 0.303 58.712 ↑ 1.3 1,172 4 / 4

Hash Join (cost=569.06..12,340.58 rows=1,514 width=394) (actual time=14.017..58.712 rows=1,172 loops=4)

  • Hash Cond: (j.customer_id = c.customer_id)
11. 0.332 58.330 ↑ 1.3 1,172 4 / 4

Hash Join (cost=563.74..12,331.12 rows=1,514 width=378) (actual time=13.929..58.330 rows=1,172 loops=4)

  • Hash Cond: (j.press_id = p.press_id)
12. 0.326 57.934 ↑ 1.3 1,172 4 / 4

Hash Join (cost=558.29..12,321.54 rows=1,514 width=367) (actual time=13.855..57.934 rows=1,172 loops=4)

  • Hash Cond: (j.ink_paper_id = ip.ink_paper_id)
13. 0.378 57.571 ↑ 1.3 1,172 4 / 4

Hash Join (cost=556.25..12,315.16 rows=1,514 width=352) (actual time=13.806..57.571 rows=1,172 loops=4)

  • Hash Cond: (j.press_target_id = pt.press_target_id)
14. 23.099 57.120 ↑ 1.3 1,172 4 / 4

Hash Join (cost=551.36..12,306.09 rows=1,514 width=309) (actual time=13.721..57.120 rows=1,172 loops=4)

  • Hash Cond: (s.score_id = j.score_id)
15. 22.890 22.890 ↑ 1.3 120,260 4 / 4

Parallel Seq Scan on score s (cost=0.00..11,157.43 rows=155,243 width=80) (actual time=0.010..22.890 rows=120,260 loops=4)

16. 2.396 11.131 ↑ 1.0 4,686 4 / 4

Hash (cost=492.69..492.69 rows=4,694 width=237) (actual time=11.131..11.131 rows=4,686 loops=4)

  • Buckets: 8,192 Batches: 1 Memory Usage: 1,330kB
17. 1.877 8.735 ↑ 1.0 4,686 4 / 4

Hash Join (cost=401.38..492.69 rows=4,694 width=237) (actual time=6.452..8.735 rows=4,686 loops=4)

  • Hash Cond: (sj.job_id = j.job_id)
18. 0.482 0.482 ↓ 1.0 4,743 4 / 4

Seq Scan on site_job sj (cost=0.00..78.97 rows=4,697 width=8) (actual time=0.025..0.482 rows=4,743 loops=4)

19. 2.400 6.376 ↓ 1.0 4,686 4 / 4

Hash (cost=342.85..342.85 rows=4,682 width=233) (actual time=6.376..6.376 rows=4,686 loops=4)

  • Buckets: 8,192 Batches: 1 Memory Usage: 1,303kB
20. 3.976 3.976 ↓ 1.0 4,686 4 / 4

Seq Scan on job j (cost=0.00..342.85 rows=4,682 width=233) (actual time=0.035..3.976 rows=4,686 loops=4)

  • Filter: active
  • Rows Removed by Filter: 3
21. 0.014 0.073 ↑ 1.0 84 4 / 4

Hash (cost=3.84..3.84 rows=84 width=51) (actual time=0.073..0.073 rows=84 loops=4)

  • Buckets: 1,024 Batches: 1 Memory Usage: 16kB
22. 0.059 0.059 ↑ 1.0 84 4 / 4

Seq Scan on presstarget pt (cost=0.00..3.84 rows=84 width=51) (actual time=0.026..0.059 rows=84 loops=4)

23. 0.008 0.037 ↑ 1.0 46 4 / 4

Hash (cost=1.46..1.46 rows=46 width=23) (actual time=0.037..0.037 rows=46 loops=4)

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
24. 0.029 0.029 ↑ 1.0 46 4 / 4

Seq Scan on inkpaper ip (cost=0.00..1.46 rows=46 width=23) (actual time=0.025..0.029 rows=46 loops=4)

25. 0.016 0.064 ↑ 1.0 109 4 / 4

Hash (cost=4.09..4.09 rows=109 width=19) (actual time=0.064..0.064 rows=109 loops=4)

  • Buckets: 1,024 Batches: 1 Memory Usage: 14kB
26. 0.048 0.048 ↑ 1.0 109 4 / 4

Seq Scan on press p (cost=0.00..4.09 rows=109 width=19) (actual time=0.026..0.048 rows=109 loops=4)

27. 0.013 0.079 ↑ 1.0 103 4 / 4

Hash (cost=4.03..4.03 rows=103 width=24) (actual time=0.079..0.079 rows=103 loops=4)

  • Buckets: 1,024 Batches: 1 Memory Usage: 15kB
28. 0.066 0.066 ↑ 1.0 103 4 / 4

Seq Scan on customer c (cost=0.00..4.03 rows=103 width=24) (actual time=0.030..0.066 rows=103 loops=4)

29. 0.006 0.074 ↑ 1.0 25 4 / 4

Hash (cost=2.25..2.25 rows=25 width=16) (actual time=0.074..0.074 rows=25 loops=4)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
30. 0.068 0.068 ↑ 1.0 25 4 / 4

Seq Scan on operator op (cost=0.00..2.25 rows=25 width=16) (actual time=0.051..0.068 rows=25 loops=4)

31. 0.019 98.938 ↑ 1.0 55 4 / 4

Hash (cost=1.55..1.55 rows=55 width=29) (actual time=98.938..98.938 rows=55 loops=4)

  • Buckets: 1,024 Batches: 1 Memory Usage: 12kB
32. 98.919 98.919 ↑ 1.0 55 4 / 4

Seq Scan on site st (cost=0.00..1.55 rows=55 width=29) (actual time=98.907..98.919 rows=55 loops=4)

33. 0.006 0.059 ↑ 1.0 2 4 / 4

Hash (cost=1.02..1.02 rows=2 width=20) (actual time=0.059..0.059 rows=2 loops=4)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
34. 0.053 0.053 ↑ 1.0 2 4 / 4

Seq Scan on category cg (cost=0.00..1.02 rows=2 width=20) (actual time=0.053..0.053 rows=2 loops=4)

35. 0.004 0.034 ↑ 1.0 2 4 / 4

Hash (cost=1.02..1.02 rows=2 width=18) (actual time=0.034..0.034 rows=2 loops=4)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
36. 0.030 0.030 ↑ 1.0 2 4 / 4

Seq Scan on subcategory scg (cost=0.00..1.02 rows=2 width=18) (actual time=0.029..0.030 rows=2 loops=4)

37.          

SubPlan (for Hash Right Join)

38. 20.722 155.415 ↑ 1.0 1 10,361

Aggregate (cost=6.41..6.42 rows=1 width=32) (actual time=0.015..0.015 rows=1 loops=10,361)

39. 10.346 134.693 ↑ 2.5 2 10,361

Hash Join (cost=1.11..6.40 rows=5 width=8) (actual time=0.003..0.013 rows=2 loops=10,361)

  • Hash Cond: (ssg.sitegroup_id = sg.sitegroup_id)
40. 124.332 124.332 ↑ 2.5 2 10,361

Seq Scan on sites_sitegroups ssg (cost=0.00..5.26 rows=5 width=8) (actual time=0.002..0.012 rows=2 loops=10,361)

  • Filter: (site_id = sj.site_id)
  • Rows Removed by Filter: 259
41. 0.007 0.015 ↑ 1.0 5 1

Hash (cost=1.05..1.05 rows=5 width=8) (actual time=0.015..0.015 rows=5 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
42. 0.008 0.008 ↑ 1.0 5 1

Seq Scan on sitegroups sg (cost=0.00..1.05 rows=5 width=8) (actual time=0.007..0.008 rows=5 loops=1)

43. 20.722 155.415 ↑ 1.0 1 10,361

Aggregate (cost=6.41..6.43 rows=1 width=32) (actual time=0.015..0.015 rows=1 loops=10,361)

44. 10.354 134.693 ↑ 2.5 2 10,361

Hash Join (cost=1.11..6.40 rows=5 width=17) (actual time=0.003..0.013 rows=2 loops=10,361)

  • Hash Cond: (ssg_1.sitegroup_id = sg_1.sitegroup_id)
45. 124.332 124.332 ↑ 2.5 2 10,361

Seq Scan on sites_sitegroups ssg_1 (cost=0.00..5.26 rows=5 width=8) (actual time=0.002..0.012 rows=2 loops=10,361)

  • Filter: (site_id = sj.site_id)
  • Rows Removed by Filter: 259
46. 0.003 0.007 ↑ 1.0 5 1

Hash (cost=1.05..1.05 rows=5 width=17) (actual time=0.007..0.007 rows=5 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
47. 0.004 0.004 ↑ 1.0 5 1

Seq Scan on sitegroups sg_1 (cost=0.00..1.05 rows=5 width=17) (actual time=0.004..0.004 rows=5 loops=1)

Execution time : 553.964 ms