explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yBhG

Settings
# exclusive inclusive rows x rows loops node
1. 186.708 114,276.772 ↓ 36,113.0 72,226 1

Nested Loop Left Join (cost=13,213.51..35,235.68 rows=2 width=426) (actual time=164.523..114,276.772 rows=72,226 loops=1)

2. 128.988 26,046.570 ↓ 36,113.0 72,226 1

Nested Loop Left Join (cost=13,212.94..35,218.50 rows=2 width=426) (actual time=163.370..26,046.570 rows=72,226 loops=1)

3. 76.241 17,828.270 ↓ 36,113.0 72,226 1

Nested Loop Left Join (cost=13,212.38..35,201.33 rows=2 width=418) (actual time=163.325..17,828.270 rows=72,226 loops=1)

4. 210.963 17,607.577 ↓ 36,113.0 72,226 1

Hash Join (cost=13,212.23..35,193.79 rows=2 width=394) (actual time=163.311..17,607.577 rows=72,226 loops=1)

  • Hash Cond: ((vbf.version_bom_id = vbc.version_bom_id) AND (vbe.version_bom_component_id = vbc.id))
5. 190.420 17,234.843 ↓ 35.3 72,226 1

Nested Loop (cost=1.13..21,967.28 rows=2,048 width=397) (actual time=0.144..17,234.843 rows=72,226 loops=1)

6. 76.683 15,816.581 ↓ 54.1 72,226 1

Nested Loop (cost=0.70..10,686.15 rows=1,336 width=354) (actual time=0.097..15,816.581 rows=72,226 loops=1)

7. 0.056 0.056 ↑ 1.0 1 1

Index Scan using version_bom_release_id_idx on version_bom vb (cost=0.28..8.29 rows=1 width=8) (actual time=0.055..0.056 rows=1 loops=1)

  • Index Cond: (release_id = '3e6d43b5-0a7e-4181-9bc5-c56f36b7a9be'::uuid)
8. 15,739.842 15,739.842 ↓ 24.4 72,226 1

Index Scan using idx_version_bom_file_version_bom_id on version_bom_file vbf (cost=0.43..10,648.27 rows=2,959 width=346) (actual time=0.039..15,739.842 rows=72,226 loops=1)

  • Index Cond: (version_bom_id = vb.id)
9. 1,227.842 1,227.842 ↑ 1.0 1 72,226

Index Scan using idx_version_bom_entry_version_bom_file_id on version_bom_entry vbe (cost=0.43..8.43 rows=1 width=59) (actual time=0.017..0.017 rows=1 loops=72,226)

  • Index Cond: (version_bom_file_id = vbf.id)
10. 71.793 161.771 ↓ 1.0 210,149 1

Hash (cost=10,064.64..10,064.64 rows=209,764 width=37) (actual time=161.771..161.771 rows=210,149 loops=1)

  • Buckets: 262144 Batches: 1 Memory Usage: 17268kB
11. 89.978 89.978 ↓ 1.0 210,149 1

Seq Scan on version_bom_component vbc (cost=0.00..10,064.64 rows=209,764 width=37) (actual time=0.020..89.978 rows=210,149 loops=1)

12. 144.452 144.452 ↓ 0.0 0 72,226

Index Scan using version_bom_snippet_pkey on version_bom_snippet vbs (cost=0.14..3.76 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=72,226)

  • Index Cond: (id = vbe.id)
13. 8,089.312 8,089.312 ↓ 0.0 0 72,226

Index Scan using scan_composite_element_pkey on scan_composite_element sce (cost=0.56..8.57 rows=1 width=32) (actual time=0.112..0.112 rows=0 loops=72,226)

  • Index Cond: ((vbf.composite_id = id) AND (vbf.scan_id = scan_id))
14. 88,043.494 88,043.494 ↑ 1.0 1 72,226

Index Scan using scan_composite_leaf_pkey on scan_composite_leaf scl (cost=0.57..8.58 rows=1 width=50) (actual time=1.207..1.219 rows=1 loops=72,226)

  • Index Cond: ((vbf.composite_id = id) AND (vbf.scan_id = scan_id))