explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 922

Settings
# exclusive inclusive rows x rows loops node
1. 1.083 6.795 ↓ 45.0 45 1

Nested Loop (cost=8.47..15.15 rows=1 width=59) (actual time=1.130..6.795 rows=45 loops=1)

  • Join Filter: (vbf.version_bom_id = vbc.version_bom_id)
  • Planning time: 2.155 ms
  • Execution time: 7.068 ms
2. 0.995 4.317 ↓ 45.0 45 1

Nested Loop (cost=8.32..14.51 rows=1 width=51) (actual time=0.620..4.317 rows=45 loops=1)

3. 0.664 2.144 ↓ 38.0 38 1

Hash Join (cost=8.18..13.50 rows=1 width=37) (actual time=0.058..2.144 rows=38 loops=1)

  • Hash Cond: (vbf.version_bom_id = vb.id)
4. 1.451 1.451 ↑ 1.0 95 1

Seq Scan on version_bom_file vbf (cost=0.00..4.95 rows=95 width=29) (actual time=0.010..1.451 rows=95 loops=1)

5. 0.014 0.029 ↑ 1.0 1 1

Hash (cost=8.17..8.17 rows=1 width=8) (actual time=0.026..0.029 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
6. 0.015 0.015 ↑ 1.0 1 1

Index Scan using version_bom_release_id_idx on version_bom vb (cost=0.15..8.17 rows=1 width=8) (actual time=0.009..0.015 rows=1 loops=1)

  • Index Cond: (release_id = 'd1f5dd75-f190-4f6e-bdba-7d8b67bd8040'::uuid)
7. 1.178 1.178 ↑ 1.0 1 38

Index Scan using idx_version_bom_entry_version_bom_file_id on version_bom_entry vbe (cost=0.14..1.00 rows=1 width=30) (actual time=0.024..0.031 rows=1 loops=38)

  • Index Cond: (version_bom_file_id = vbf.id)
8. 1.395 1.395 ↑ 1.0 1 45

Index Scan using version_bom_component_pkey on version_bom_component vbc (cost=0.14..0.63 rows=1 width=48) (actual time=0.018..0.031 rows=1 loops=45)

  • Index Cond: (id = vbe.version_bom_component_id)