explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1gse

Settings
# exclusive inclusive rows x rows loops node
1. 1,141.439 31,310.433 ↑ 4,145.5 24 1

GroupAggregate (cost=79,590.55..84,565.15 rows=99,492 width=285) (actual time=28,927.474..31,310.433 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,794.439 30,168.994 ↓ 1.8 180,164 1

Sort (cost=79,590.55..79,839.28 rows=99,492 width=284) (actual time=28,825.331..30,168.994 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: 31,880kB
3. 2,063.828 27,374.555 ↓ 1.8 180,164 1

Hash Join (cost=31,162.89..58,066.57 rows=99,492 width=284) (actual time=8,001.519..27,374.555 rows=180,164 loops=1)

  • Hash Cond: (w.lot_id = l.lot_id)
4. 2,040.491 25,308.289 ↓ 1.8 180,164 1

Hash Join (cost=31,158.14..57,794.02 rows=99,492 width=277) (actual time=7,999.065..25,308.289 rows=180,164 loops=1)

  • Hash Cond: (ms.wafer_id = w.wafer_id)
5. 2,042.646 23,262.785 ↓ 1.8 180,164 1

Hash Join (cost=31,145.84..57,517.88 rows=99,492 width=269) (actual time=7,994.029..23,262.785 rows=180,164 loops=1)

  • Hash Cond: (d.maskset_seat_id = mss.maskset_seat_id)
6. 2,040.594 21,073.508 ↓ 1.8 180,164 1

Hash Join (cost=30,766.26..56,877.04 rows=99,492 width=267) (actual time=7,847.371..21,073.508 rows=180,164 loops=1)

  • Hash Cond: (pc.die_id = d.die_id)
7. 2,045.397 18,438.774 ↓ 1.8 180,164 1

Hash Join (cost=29,304.62..55,154.21 rows=99,492 width=263) (actual time=7,253.191..18,438.774 rows=180,164 loops=1)

  • Hash Cond: (pc.designed_component_id = dc.designed_component_id)
8. 2,045.092 16,281.870 ↓ 1.8 180,164 1

Hash Join (cost=28,941.92..54,530.23 rows=99,492 width=259) (actual time=7,141.659..16,281.870 rows=180,164 loops=1)

  • Hash Cond: (pc.physical_component_type_id = pct.physical_component_type_id)
9. 1,973.048 14,236.626 ↓ 1.8 180,164 1

Nested Loop (cost=28,913.69..54,239.47 rows=99,492 width=231) (actual time=7,141.487..14,236.626 rows=180,164 loops=1)

10. 0.025 0.126 ↑ 1.0 1 1

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

11. 0.027 0.082 ↑ 1.0 1 1

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

12. 0.037 0.037 ↑ 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.022..0.037 rows=1 loops=1)

  • Index Cond: (measurement_session_id = 804)
13. 0.018 0.018 ↑ 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.013..0.018 rows=1 loops=1)

  • Index Cond: (measurement_method_id = ms.measurement_method_id)
14. 0.019 0.019 ↑ 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.013..0.019 rows=1 loops=1)

  • Index Cond: (data_source_id = ms.data_source_id)
15. 2,042.456 12,263.452 ↓ 1.8 180,164 1

Hash Join (cost=28,913.12..53,219.86 rows=99,492 width=27) (actual time=7,141.381..12,263.452 rows=180,164 loops=1)

  • Hash Cond: (cs.physical_component_id = pc.physical_component_id)
16. 2,058.523 3,085.429 ↓ 1.8 180,164 1

Hash Join (cost=2,331.67..22,472.24 rows=99,492 width=15) (actual time=5.748..3,085.429 rows=180,164 loops=1)

  • Hash Cond: (cs.measurement_type_id = mt.measurement_type_id)
17. 1,021.305 1,026.798 ↓ 1.8 180,164 1

Bitmap Heap Scan on component_measurements cs (cost=2,307.49..22,185.14 rows=99,492 width=19) (actual time=5.624..1,026.798 rows=180,164 loops=1)

  • Recheck Cond: (measurement_session_id = 804)
  • Heap Blocks: exact=1,540
18. 5.493 5.493 ↓ 1.8 180,164 1

Bitmap Index Scan on component_measurements_measurement_session_pkey (cost=0.00..2,282.62 rows=99,492 width=0) (actual time=5.488..5.493 rows=180,164 loops=1)

  • Index Cond: (measurement_session_id = 804)
19. 0.052 0.108 ↑ 90.0 7 1

Hash (cost=16.30..16.30 rows=630 width=4) (actual time=0.103..0.108 rows=7 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
20. 0.056 0.056 ↑ 90.0 7 1

Seq Scan on measurement_type mt (cost=0.00..16.30 rows=630 width=4) (actual time=0.011..0.056 rows=7 loops=1)

21. 3,606.744 7,135.567 ↑ 1.0 600,509 1

Hash (cost=16,142.09..16,142.09 rows=600,509 width=16) (actual time=7,135.561..7,135.567 rows=600,509 loops=1)

  • Buckets: 131,072 Batches: 16 Memory Usage: 2,788kB
22. 3,528.823 3,528.823 ↑ 1.0 600,509 1

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

23. 0.077 0.152 ↑ 81.0 10 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
24. 0.075 0.075 ↑ 81.0 10 1

Seq Scan on physical_component_type pct (cost=0.00..18.10 rows=810 width=36) (actual time=0.013..0.075 rows=10 loops=1)

25. 55.903 111.507 ↑ 1.0 9,587 1

Hash (cost=242.87..242.87 rows=9,587 width=8) (actual time=111.502..111.507 rows=9,587 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 503kB
26. 55.604 55.604 ↑ 1.0 9,587 1

Seq Scan on designed_component dc (cost=0.00..242.87 rows=9,587 width=8) (actual time=0.010..55.604 rows=9,587 loops=1)

27. 300.782 594.140 ↑ 1.0 50,606 1

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

  • Buckets: 65,536 Batches: 1 Memory Usage: 2,489kB
28. 293.358 293.358 ↑ 1.0 50,606 1

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

29. 74.174 146.631 ↑ 1.0 12,426 1

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

  • Buckets: 16,384 Batches: 1 Memory Usage: 662kB
30. 72.457 72.457 ↑ 1.0 12,426 1

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

31. 2.498 5.013 ↑ 1.0 413 1

Hash (cost=7.13..7.13 rows=413 width=12) (actual time=5.008..5.013 rows=413 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 26kB
32. 2.515 2.515 ↑ 1.0 413 1

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

33. 1.266 2.438 ↑ 1.0 167 1

Hash (cost=2.67..2.67 rows=167 width=11) (actual time=2.433..2.438 rows=167 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 16kB
34. 1.172 1.172 ↑ 1.0 167 1

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

Planning time : 1.683 ms
Execution time : 31,316.854 ms