explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oXsu

Settings
# exclusive inclusive rows x rows loops node
1. 48.649 7,028.401 ↓ 85.1 72,226 1

Nested Loop (cost=12.14..8,319.68 rows=849 width=25) (actual time=12.020..7,028.401 rows=72,226 loops=1)

2. 20.269 332.839 ↓ 86.0 73,043 1

Nested Loop (cost=11.71..3,870.23 rows=849 width=25) (actual time=0.543..332.839 rows=73,043 loops=1)

3. 4.724 4.724 ↓ 3.5 7 1

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

  • Filter: (release_id = '3e6d43b5-0a7e-4181-9bc5-c56f36b7a9be'::uuid)
  • Rows Removed by Filter: 9720
4. 297.304 307.846 ↓ 24.6 10,435 7

Bitmap Heap Scan on version_bom_entry vbe (cost=11.71..1,653.58 rows=424 width=41) (actual time=1.915..43.978 rows=10,435 loops=7)

  • Recheck Cond: (code_location_id = cl_main_code_location.id)
  • Heap Blocks: exact=19118
5. 10.542 10.542 ↓ 24.6 10,439 7

Bitmap Index Scan on version_bom_entry_code_location_id_idx (cost=0.00..11.61 rows=424 width=0) (actual time=1.506..1.506 rows=10,439 loops=7)

  • Index Cond: (code_location_id = cl_main_code_location.id)
6. 6,646.913 6,646.913 ↑ 1.0 1 73,043

Index Only Scan using version_bom_file_pkey on version_bom_file vbf (cost=0.43..5.23 rows=1 width=8) (actual time=0.091..0.091 rows=1 loops=73,043)

  • Index Cond: (id = vbe.version_bom_file_id)
  • Heap Fetches: 26066
Planning time : 6.439 ms
Execution time : 7,035.783 ms