explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JoC3

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 20.007 ↓ 11.0 11 1

Limit (cost=537.25..537.25 rows=1 width=45) (actual time=20.003..20.007 rows=11 loops=1)

  • Planning time: 1.228 ms
  • Execution time: 20.188 ms
2. 0.063 20.003 ↓ 11.0 11 1

Sort (cost=537.25..537.25 rows=1 width=45) (actual time=20.001..20.003 rows=11 loops=1)

  • Sort Key: vbf.file_name
  • Sort Method: quicksort Memory: 26kB
3. 0.081 19.940 ↓ 11.0 11 1

Nested Loop (cost=1.27..537.24 rows=1 width=45) (actual time=2.370..19.940 rows=11 loops=1)

4. 0.018 2.609 ↓ 1.7 15 1

Nested Loop (cost=0.85..468.20 rows=9 width=40) (actual time=2.317..2.609 rows=15 loops=1)

5. 2.330 2.330 ↓ 3.0 3 1

Index Scan using version_bom_component_release_id_idx on version_bom_component vbc (cost=0.42..84.81 rows=1 width=23) (actual time=2.280..2.330 rows=3 loops=1)

  • Index Cond: (release_id = 'dc075f5c-892b-475d-ba16-f64f67eba2b2'::uuid)
  • Filter: (version_bom_id = 1125)
  • Rows Removed by Filter: 9
6. 0.261 0.261 ↑ 19.8 5 3

Index Scan using idx_version_bom_entry_version_bom_component_id on version_bom_entry vbe (cost=0.43..382.40 rows=99 width=33) (actual time=0.028..0.087 rows=5 loops=3)

  • Index Cond: (version_bom_component_id = vbc.id)
7. 17.250 17.250 ↑ 1.0 1 15

Index Scan using version_bom_file_pkey on version_bom_file vbf (cost=0.43..7.66 rows=1 width=21) (actual time=1.149..1.150 rows=1 loops=15)

  • Index Cond: (id = vbe.version_bom_file_id)
  • Filter: (version_bom_id = 1125)