explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YLXd

Settings
# exclusive inclusive rows x rows loops node
1. 1,133.584 24,499.711 ↑ 4,145.5 24 1

GroupAggregate (cost=97,534.97..102,509.57 rows=99,492 width=285) (actual time=22,144.435..24,499.711 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,675.077 23,366.127 ↓ 1.8 180,164 1

Sort (cost=97,534.97..97,783.70 rows=99,492 width=284) (actual time=22,041.581..23,366.127 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.538 20,691.050 ↓ 1.8 180,164 1

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

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

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

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

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

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

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

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

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

8. 0.023 0.106 ↑ 1.0 1 1

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

9. 0.025 0.068 ↑ 1.0 1 1

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

10. 0.028 0.028 ↑ 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.028 rows=1 loops=1)

  • Index Cond: (measurement_session_id = 804)
11. 0.015 0.015 ↑ 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.009..0.015 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,957.719 ↓ 1.8 180,164 1

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

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

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

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

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

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

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

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

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

  • Hash Cond: (cs.measurement_type_id = mt.measurement_type_id)
18. 382.369 382.369 ↓ 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=39.223..382.369 rows=60,055 loops=3)

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

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

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

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

21. 3,348.083 6,671.602 ↑ 1.0 600,509 3 / 3

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

  • Buckets: 131072 Batches: 16 Memory Usage: 2788kB
22. 3,323.519 3,323.519 ↑ 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.020..3,323.519 rows=600,509 loops=3)

23. 0.069 0.147 ↑ 81.0 10 3 / 3

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

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

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

25. 54.599 109.214 ↑ 1.0 9,587 3 / 3

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

  • Buckets: 16384 Batches: 1 Memory Usage: 503kB
26. 54.615 54.615 ↑ 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..54.615 rows=9,587 loops=3)

27. 296.375 588.642 ↑ 1.0 50,606 1

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

  • Buckets: 65536 Batches: 1 Memory Usage: 2489kB
28. 292.267 292.267 ↑ 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.267 rows=50,606 loops=1)

29. 72.905 144.687 ↑ 1.0 12,426 1

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

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

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

31. 2.545 4.972 ↑ 1.0 413 1

Hash (cost=7.13..7.13 rows=413 width=12) (actual time=4.967..4.972 rows=413 loops=1)

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

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

33. 0.986 1.954 ↑ 1.0 167 1

Hash (cost=2.67..2.67 rows=167 width=11) (actual time=1.949..1.954 rows=167 loops=1)

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

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

Planning time : 1.351 ms
Execution time : 24,505.782 ms