explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 17l7

Settings
# exclusive inclusive rows x rows loops node
1. 5.035 3,776.470 ↓ 1.2 100 1

Subquery Scan on t (cost=7,767.36..7,775.71 rows=86 width=61) (actual time=3,712.257..3,776.470 rows=100 loops=1)

  • Filter: (t.dr <= 100)
  • Rows Removed by Filter: 66826
2. 35.786 3,771.435 ↓ 260.4 66,926 1

WindowAgg (cost=7,767.36..7,772.50 rows=257 width=61) (actual time=3,712.248..3,771.435 rows=66,926 loops=1)

3. 103.234 3,735.649 ↓ 260.4 66,926 1

Sort (cost=7,767.36..7,768.00 rows=257 width=53) (actual time=3,712.218..3,735.649 rows=66,926 loops=1)

  • Sort Key: vbf.file_name, vbf.id
  • Sort Method: quicksort Memory: 12238kB
4. 49.473 3,632.415 ↓ 260.4 66,926 1

Nested Loop (cost=12.44..7,757.07 rows=257 width=53) (actual time=15.391..3,632.415 rows=66,926 loops=1)

5. 24.913 504.346 ↓ 260.4 66,926 1

Nested Loop (cost=12.01..5,785.16 rows=257 width=40) (actual time=13.814..504.346 rows=66,926 loops=1)

6. 10.123 278.655 ↓ 260.4 66,926 1

Nested Loop (cost=11.59..3,820.52 rows=257 width=33) (actual time=13.769..278.655 rows=66,926 loops=1)

7. 5.437 5.437 ↓ 3.5 7 1

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

  • Filter: (release_id = '3e6d43b5-0a7e-4181-9bc5-c56f36b7a9be'::uuid)
  • Rows Removed by Filter: 9720
8. 253.400 263.095 ↓ 74.7 9,561 7

Bitmap Heap Scan on version_bom_entry vbe (cost=11.59..1,631.69 rows=128 width=49) (actual time=2.748..37.585 rows=9,561 loops=7)

  • Recheck Cond: (code_location_id = cl_main_code_location.id)
  • Filter: (match_type = 'FILE_EXACT_FILE_MATCH'::text)
  • Rows Removed by Filter: 874
  • Heap Blocks: exact=19106
9. 9.695 9.695 ↓ 25.0 10,435 7

Bitmap Index Scan on version_bom_entry_code_location_id_idx (cost=0.00..11.56 rows=418 width=0) (actual time=1.385..1.385 rows=10,435 loops=7)

  • Index Cond: (code_location_id = cl_main_code_location.id)
10. 200.778 200.778 ↑ 1.0 1 66,926

Index Scan using version_bom_component_pkey on version_bom_component vbc (cost=0.42..7.63 rows=1 width=23) (actual time=0.003..0.003 rows=1 loops=66,926)

  • Index Cond: (id = vbe.version_bom_component_id)
11. 3,078.596 3,078.596 ↑ 1.0 1 66,926

Index Scan using version_bom_file_pkey on version_bom_file vbf (cost=0.43..7.66 rows=1 width=21) (actual time=0.046..0.046 rows=1 loops=66,926)

  • Index Cond: (id = vbe.version_bom_file_id)
Planning time : 2.141 ms
Execution time : 3,778.064 ms