explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JXMC

Settings
# exclusive inclusive rows x rows loops node
1. 1,134.894 24,462.562 ↑ 4,145.5 24 1

GroupAggregate (cost=97,534.97..102,509.57 rows=99,492 width=285) (actual time=22,097.551..24,462.562 rows=24 loops=1)

  • Group Key: d.die_id, mss.die_name, w.wafer_id, l.lot_id, dc.designed_component_id, pc.physical_component_id, pct.physical_component_type, mm.measurement_method, ms.measurement_session_id, ds.software_package, ds.hostname, ds.git_hash, ds."time", ds.comment
2. 2,685.849 23,327.668 ↓ 1.8 180,164 1

Sort (cost=97,534.97..97,783.70 rows=99,492 width=284) (actual time=21,994.933..23,327.668 rows=180,164 loops=1)

  • Sort Key: d.die_id, mss.die_name, w.wafer_id, l.lot_id, dc.designed_component_id, pc.physical_component_id, pct.physical_component_type, mm.measurement_method, ds.software_package, ds.hostname, ds.git_hash, ds."time", ds.comment
  • Sort Method: external merge Disk: 31880kB
3. 1,985.258 20,641.819 ↓ 1.8 180,164 1

Hash Join (cost=29,855.40..76,011.00 rows=99,492 width=284) (actual time=7,578.361..20,641.819 rows=180,164 loops=1)

  • Hash Cond: (w.lot_id = l.lot_id)
4. 2,000.448 18,654.399 ↓ 1.8 180,164 1

Hash Join (cost=29,850.64..75,738.44 rows=99,492 width=277) (actual time=7,576.183..18,654.399 rows=180,164 loops=1)

  • Hash Cond: (ms.wafer_id = w.wafer_id)
5. 1,984.599 16,649.082 ↓ 1.8 180,164 1

Hash Join (cost=29,838.35..75,462.30 rows=99,492 width=269) (actual time=7,571.295..16,649.082 rows=180,164 loops=1)

  • Hash Cond: (d.maskset_seat_id = mss.maskset_seat_id)
6. 2,017.963 14,519.181 ↓ 1.8 180,164 1

Hash Join (cost=29,458.76..74,821.46 rows=99,492 width=267) (actual time=7,425.971..14,519.181 rows=180,164 loops=1)

  • Hash Cond: (pc.die_id = d.die_id)
7. 1,989.109 11,909.940 ↓ 1.8 180,164 1

Nested Loop (cost=27,997.13..73,098.64 rows=99,492 width=263) (actual time=6,834.652..11,909.940 rows=180,164 loops=1)

8. 0.027 0.112 ↑ 1.0 1 1

Nested Loop (cost=0.57..24.69 rows=1 width=208) (actual time=0.076..0.112 rows=1 loops=1)

9. 0.025 0.070 ↑ 1.0 1 1

Nested Loop (cost=0.42..16.49 rows=1 width=76) (actual time=0.046..0.070 rows=1 loops=1)

10. 0.029 0.029 ↑ 1.0 1 1

Index Scan using measurement_session_pkey on measurement_session ms (cost=0.28..8.29 rows=1 width=48) (actual time=0.015..0.029 rows=1 loops=1)

  • Index Cond: (measurement_session_id = 804)
11. 0.016 0.016 ↑ 1.0 1 1

Index Scan using measurement_method_pkey on measurement_method mm (cost=0.15..8.17 rows=1 width=36) (actual time=0.011..0.016 rows=1 loops=1)

  • Index Cond: (measurement_method_id = ms.measurement_method_id)
12. 0.015 0.015 ↑ 1.0 1 1

Index Scan using data_source_pkey on data_source ds (cost=0.15..8.17 rows=1 width=140) (actual time=0.010..0.015 rows=1 loops=1)

  • Index Cond: (data_source_id = ms.data_source_id)
13. 0.000 9,920.719 ↓ 1.8 180,164 1

Gather (cost=27,996.56..72,079.03 rows=99,492 width=59) (actual time=6,834.557..9,920.719 rows=180,164 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
14. 1,005.540 10,230.510 ↓ 1.4 60,055 3 / 3

Hash Join (cost=26,996.56..61,129.83 rows=41,455 width=59) (actual time=6,829.212..10,230.510 rows=60,055 loops=3)

  • Hash Cond: (pc.designed_component_id = dc.designed_component_id)
15. 672.263 9,113.553 ↓ 1.4 60,055 3 / 3

Hash Join (cost=26,633.85..60,658.26 rows=41,455 width=55) (actual time=6,717.696..9,113.553 rows=60,055 loops=3)

  • Hash Cond: (pc.physical_component_type_id = pct.physical_component_type_id)
16. 704.441 8,441.145 ↓ 1.4 60,055 3 / 3

Hash Join (cost=26,605.63..60,520.65 rows=41,455 width=27) (actual time=6,717.531..8,441.145 rows=60,055 loops=3)

  • Hash Cond: (cs.physical_component_id = pc.physical_component_id)
17. 676.360 1,058.122 ↓ 1.4 60,055 3 / 3

Hash Join (cost=24.18..30,491.37 rows=41,455 width=15) (actual time=38.649..1,058.122 rows=60,055 loops=3)

  • Hash Cond: (cs.measurement_type_id = mt.measurement_type_id)
18. 381.652 381.652 ↓ 1.4 60,055 3 / 3

Parallel Seq Scan on component_measurements cs (cost=0.00..30,357.65 rows=41,455 width=19) (actual time=38.515..381.652 rows=60,055 loops=3)

  • Filter: (measurement_session_id = 804)
  • Rows Removed by Filter: 690259
19. 0.046 0.110 ↑ 90.0 7 3 / 3

Hash (cost=16.30..16.30 rows=630 width=4) (actual time=0.105..0.110 rows=7 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
20. 0.064 0.064 ↑ 90.0 7 3 / 3

Seq Scan on measurement_type mt (cost=0.00..16.30 rows=630 width=4) (actual time=0.014..0.064 rows=7 loops=3)

21. 3,352.232 6,678.582 ↑ 1.0 600,509 3 / 3

Hash (cost=16,142.09..16,142.09 rows=600,509 width=16) (actual time=6,678.577..6,678.582 rows=600,509 loops=3)

  • Buckets: 131072 Batches: 16 Memory Usage: 2788kB
22. 3,326.350 3,326.350 ↑ 1.0 600,509 3 / 3

Seq Scan on physical_component pc (cost=0.00..16,142.09 rows=600,509 width=16) (actual time=0.017..3,326.350 rows=600,509 loops=3)

23. 0.068 0.145 ↑ 81.0 10 3 / 3

Hash (cost=18.10..18.10 rows=810 width=36) (actual time=0.140..0.145 rows=10 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
24. 0.077 0.077 ↑ 81.0 10 3 / 3

Seq Scan on physical_component_type pct (cost=0.00..18.10 rows=810 width=36) (actual time=0.015..0.077 rows=10 loops=3)

25. 54.213 111.417 ↑ 1.0 9,587 3 / 3

Hash (cost=242.87..242.87 rows=9,587 width=8) (actual time=111.412..111.417 rows=9,587 loops=3)

  • Buckets: 16384 Batches: 1 Memory Usage: 503kB
26. 57.204 57.204 ↑ 1.0 9,587 3 / 3

Seq Scan on designed_component dc (cost=0.00..242.87 rows=9,587 width=8) (actual time=0.014..57.204 rows=9,587 loops=3)

27. 298.511 591.278 ↑ 1.0 50,606 1

Hash (cost=829.06..829.06 rows=50,606 width=8) (actual time=591.273..591.278 rows=50,606 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 2489kB
28. 292.767 292.767 ↑ 1.0 50,606 1

Seq Scan on die d (cost=0.00..829.06 rows=50,606 width=8) (actual time=0.013..292.767 rows=50,606 loops=1)

29. 73.362 145.302 ↑ 1.0 12,426 1

Hash (cost=224.26..224.26 rows=12,426 width=10) (actual time=145.297..145.302 rows=12,426 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 662kB
30. 71.940 71.940 ↑ 1.0 12,426 1

Seq Scan on maskset_seat mss (cost=0.00..224.26 rows=12,426 width=10) (actual time=0.013..71.940 rows=12,426 loops=1)

31. 2.503 4.869 ↑ 1.0 413 1

Hash (cost=7.13..7.13 rows=413 width=12) (actual time=4.863..4.869 rows=413 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 26kB
32. 2.366 2.366 ↑ 1.0 413 1

Seq Scan on wafer w (cost=0.00..7.13 rows=413 width=12) (actual time=0.015..2.366 rows=413 loops=1)

33. 1.100 2.162 ↑ 1.0 167 1

Hash (cost=2.67..2.67 rows=167 width=11) (actual time=2.157..2.162 rows=167 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
34. 1.062 1.062 ↑ 1.0 167 1

Seq Scan on lot l (cost=0.00..2.67 rows=167 width=11) (actual time=0.012..1.062 rows=167 loops=1)

Planning time : 1.503 ms
Execution time : 24,468.771 ms