explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Zm4k

Settings
# exclusive inclusive rows x rows loops node
1. 0.028 144.717 ↑ 1.0 100 1

Limit (cost=9.82..1,557.45 rows=100 width=69) (actual time=9.995..144.717 rows=100 loops=1)

  • Planning time: 1.177 ms
  • Execution time: 144.943 ms
2.          

Initplan (forLimit)

3. 0.013 0.013 ↑ 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.013..0.013 rows=1 loops=1)

  • Index Cond: (release_id = '3e6d43b5-0a7e-4181-9bc5-c56f36b7a9be'::uuid)
4. 0.199 144.676 ↑ 45.4 100 1

Nested Loop (cost=1.52..70,217.77 rows=4,537 width=69) (actual time=9.992..144.676 rows=100 loops=1)

5. 0.411 142.577 ↑ 45.4 100 1

Nested Loop (cost=1.10..35,538.03 rows=4,537 width=56) (actual time=9.948..142.577 rows=100 loops=1)

6. 138.666 138.666 ↑ 29.6 100 1

Index Scan using version_bom_index_only on version_bom_file vbf (cost=0.68..11,587.69 rows=2,959 width=21) (actual time=9.864..138.666 rows=100 loops=1)

  • Index Cond: (version_bom_id = $0)
7. 3.500 3.500 ↑ 1.0 1 100

Index Scan using idx_version_bom_entry_version_bom_file_id on version_bom_entry vbe (cost=0.43..8.08 rows=1 width=51) (actual time=0.034..0.035 rows=1 loops=100)

  • Index Cond: (version_bom_file_id = vbf.id)
8. 1.900 1.900 ↑ 1.0 1 100

Index Scan using version_bom_component_pkey on version_bom_component vbc (cost=0.42..7.63 rows=1 width=29) (actual time=0.019..0.019 rows=1 loops=100)

  • Index Cond: (id = vbe.version_bom_component_id)