explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JIys

Settings
# exclusive inclusive rows x rows loops node
1. 0.967 3.615 ↓ 45.0 45 1

Nested Loop (cost=8.46..21.41 rows=1 width=59) (actual time=0.238..3.615 rows=45 loops=1)

  • Planning time: 0.689 ms
  • Execution time: 4.778 ms
2. 0.659 2.018 ↓ 45.0 45 1

Nested Loop (cost=8.32..21.01 rows=1 width=54) (actual time=0.214..2.018 rows=45 loops=1)

3. 0.559 0.831 ↓ 22.0 22 1

Hash Join (cost=8.18..20.25 rows=1 width=40) (actual time=0.139..0.831 rows=22 loops=1)

  • Hash Cond: (vbc.version_bom_id = vb.id)
4. 0.235 0.235 ↑ 4.3 35 1

Seq Scan on version_bom_component vbc (cost=0.00..11.50 rows=150 width=48) (actual time=0.078..0.235 rows=35 loops=1)

5. 0.016 0.037 ↑ 1.0 1 1

Hash (cost=8.17..8.17 rows=1 width=8) (actual time=0.033..0.037 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
6. 0.021 0.021 ↑ 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.012..0.021 rows=1 loops=1)

  • Index Cond: (release_id = 'd1f5dd75-f190-4f6e-bdba-7d8b67bd8040'::uuid)
7. 0.528 0.528 ↑ 1.5 2 22

Index Scan using idx_version_bom_entry_version_bom_component_id on version_bom_entry vbe (cost=0.14..0.73 rows=3 width=30) (actual time=0.014..0.024 rows=2 loops=22)

  • Index Cond: (version_bom_component_id = vbc.id)
8. 0.630 0.630 ↑ 1.0 1 45

Index Scan using version_bom_file_pkey on version_bom_file vbf (cost=0.14..0.39 rows=1 width=21) (actual time=0.007..0.014 rows=1 loops=45)

  • Index Cond: (id = vbe.version_bom_file_id)