explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yseY

Settings
# exclusive inclusive rows x rows loops node
1. 319.132 185,373.780 ↓ 36,113.0 72,226 1

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

  • Planning time: 79.930 ms
  • Execution time: 185415.989 ms
2. 184.302 61,114.832 ↓ 36,113.0 72,226 1

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

3. 199.474 21,134.004 ↓ 36,113.0 72,226 1

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

4. 320.956 20,790.078 ↓ 36,113.0 72,226 1

Hash Join (cost=13,212.23..35,193.79 rows=2 width=394) (actual time=182.323..20,790.078 rows=72,226 loops=1)

  • Hash Cond: ((vbf.version_bom_id = vbc.version_bom_id) AND (vbe.version_bom_component_id = vbc.id))
5. 227.271 20,288.523 ↓ 35.3 72,226 1

Nested Loop (cost=1.13..21,967.28 rows=2,048 width=397) (actual time=0.139..20,288.523 rows=72,226 loops=1)

6. 114.699 17,966.698 ↓ 54.1 72,226 1

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

7. 0.031 0.031 ↑ 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.029..0.031 rows=1 loops=1)

  • Index Cond: (release_id = '3e6d43b5-0a7e-4181-9bc5-c56f36b7a9be'::uuid)
8. 17,851.968 17,851.968 ↓ 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.064..17,851.968 rows=72,226 loops=1)

  • Index Cond: (version_bom_id = vb.id)
9. 2,094.554 2,094.554 ↑ 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.028..0.029 rows=1 loops=72,226)

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

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

  • Buckets: 262144 Batches: 1 Memory Usage: 17268kB
11. 100.390 100.390 ↓ 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.022..100.390 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. 39,796.526 39,796.526 ↓ 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.550..0.551 rows=0 loops=72,226)

  • Index Cond: ((vbf.composite_id = id) AND (vbf.scan_id = scan_id))
14. 123,939.816 123,939.816 ↑ 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.700..1.716 rows=1 loops=72,226)

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