explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0rMx

Settings
# exclusive inclusive rows x rows loops node
1. 0.012 23,024.018 ↑ 1.0 100 1

Limit (cost=59,572.41..59,572.66 rows=100 width=375) (actual time=23,023.988..23,024.018 rows=100 loops=1)

2. 62.655 23,024.006 ↑ 61.6 100 1

Sort (cost=59,572.41..59,587.81 rows=6,160 width=375) (actual time=23,023.986..23,024.006 rows=100 loops=1)

  • Sort Key: vbf.file_name
  • Sort Method: top-N heapsort Memory: 76kB
3. 88.057 22,961.351 ↓ 11.7 72,226 1

Hash Join (cost=13,071.36..59,336.98 rows=6,160 width=375) (actual time=732.149..22,961.351 rows=72,226 loops=1)

  • Hash Cond: (vbe.version_bom_component_id = vbc.id)
4. 70.948 22,706.316 ↓ 11.7 72,226 1

Nested Loop (cost=384.67..46,565.59 rows=6,160 width=362) (actual time=563.727..22,706.316 rows=72,226 loops=1)

5. 40.242 21,913.108 ↓ 18.0 72,226 1

Nested Loop (cost=384.25..15,731.20 rows=4,017 width=327) (actual time=563.672..21,913.108 rows=72,226 loops=1)

6. 3.431 3.431 ↓ 3.5 7 1

Seq Scan on cl_main_code_location (cost=0.00..554.59 rows=2 width=16) (actual time=0.315..3.431 rows=7 loops=1)

  • Filter: (release_id = '3e6d43b5-0a7e-4181-9bc5-c56f36b7a9be'::uuid)
  • Rows Removed by Filter: 9720
7. 20,723.227 21,869.435 ↓ 5.1 10,318 7

Bitmap Heap Scan on version_bom_file vbf (cost=384.25..7,568.21 rows=2,009 width=343) (actual time=165.399..3,124.205 rows=10,318 loops=7)

  • Recheck Cond: (code_location_id = cl_main_code_location.id)
  • Heap Blocks: exact=32652
8. 1,146.208 1,146.208 ↓ 5.2 10,374 7

Bitmap Index Scan on uidx_version_bom_file_code_location_composite_path (cost=0.00..383.75 rows=2,009 width=0) (actual time=163.744..163.744 rows=10,374 loops=7)

  • Index Cond: (code_location_id = cl_main_code_location.id)
9. 722.260 722.260 ↑ 1.0 1 72,226

Index Scan using idx_version_bom_entry_version_bom_file_id on version_bom_entry vbe (cost=0.43..7.67 rows=1 width=51) (actual time=0.009..0.010 rows=1 loops=72,226)

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

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

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

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