explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XRit

Settings
# exclusive inclusive rows x rows loops node
1. 2.293 10,792.525 ↓ 1,093.0 1,093 1

Sort (cost=17,430.37..17,430.37 rows=1 width=69) (actual time=10,792.298..10,792.525 rows=1,093 loops=1)

  • Sort Key: vbf.file_name DESC
  • Sort Method: quicksort Memory: 200kB
2.          

Initplan (forSort)

3. 0.021 0.021 ↑ 1.0 1 1

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

  • Index Cond: (release_id = '3e6d43b5-0a7e-4181-9bc5-c56f36b7a9be'::uuid)
4. 26.847 10,790.211 ↓ 1,093.0 1,093 1

Nested Loop (cost=0.85..17,422.06 rows=1 width=69) (actual time=52.127..10,790.211 rows=1,093 loops=1)

5. 15.850 1,086.232 ↓ 252.3 35,318 1

Nested Loop (cost=0.43..16,348.13 rows=140 width=64) (actual time=0.061..1,086.232 rows=35,318 loops=1)

6. 130.062 130.062 ↓ 43.5 653 1

Seq Scan on version_bom_component vbc (cost=0.00..10,595.39 rows=15 width=29) (actual time=0.032..130.062 rows=653 loops=1)

  • Filter: (project_name ~~ '%erl%'::text)
  • Rows Removed by Filter: 209618
7. 940.320 940.320 ↑ 1.8 54 653

Index Scan using idx_version_bom_entry_version_bom_component_id on version_bom_entry vbe (cost=0.43..382.53 rows=99 width=51) (actual time=0.571..1.440 rows=54 loops=653)

  • Index Cond: (version_bom_component_id = vbc.id)
8. 9,677.132 9,677.132 ↓ 0.0 0 35,318

Index Scan using version_bom_file_pkey on version_bom_file vbf (cost=0.43..7.66 rows=1 width=21) (actual time=0.274..0.274 rows=0 loops=35,318)

  • Index Cond: (id = vbe.version_bom_file_id)
  • Filter: (version_bom_id = $0)
  • Rows Removed by Filter: 1
Planning time : 21.392 ms
Execution time : 10,792.896 ms