explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gvOT

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 585.486 ↓ 2.0 2 1

Nested Loop Left Join (cost=12,809.27..146,285.88 rows=1 width=5,985) (actual time=456.389..585.486 rows=2 loops=1)

2. 3.109 585.477 ↓ 2.0 2 1

Hash Join (cost=12,808.99..146,278.48 rows=1 width=5,571) (actual time=456.381..585.477 rows=2 loops=1)

  • Hash Cond: ((vbf.composite_id = vbssm.composite_id) AND (vbf.scan_id = vbssm.scan_id))
3. 3.466 489.151 ↓ 2.7 5,423 1

Nested Loop (cost=9.16..133,265.04 rows=1,987 width=5,137) (actual time=76.370..489.151 rows=5,423 loops=1)

4. 3.631 415.186 ↓ 2.7 5,423 1

Nested Loop (cost=8.74..117,582.29 rows=1,987 width=4,358) (actual time=75.631..415.186 rows=5,423 loops=1)

5. 24.387 126.023 ↑ 2.9 76 1

Hash Join (cost=8.31..14,656.58 rows=217 width=1,539) (actual time=74.926..126.023 rows=76 loops=1)

  • Hash Cond: (vbc.version_bom_id = vb.id)
6. 101.617 101.617 ↓ 1.0 287,935 1

Seq Scan on version_bom_component vbc (cost=0.00..13,566.89 rows=287,789 width=1,474) (actual time=0.021..101.617 rows=287,935 loops=1)

7. 0.010 0.019 ↑ 1.0 1 1

Hash (cost=8.29..8.29 rows=1 width=65) (actual time=0.019..0.019 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
8. 0.009 0.009 ↑ 1.0 1 1

Index Scan using version_bom_release_id_idx on version_bom vb (cost=0.28..8.29 rows=1 width=65) (actual time=0.009..0.009 rows=1 loops=1)

  • Index Cond: (release_id = '3dfe4f85-2f19-4f5c-bda4-6468b8660a48'::uuid)
9. 285.532 285.532 ↑ 1.9 71 76

Index Scan using idx_version_bom_entry_version_bom_component_id on version_bom_entry vbe (cost=0.43..472.97 rows=134 width=2,819) (actual time=0.026..3.757 rows=71 loops=76)

  • Index Cond: (version_bom_component_id = vbc.id)
10. 70.499 70.499 ↑ 1.0 1 5,423

Index Scan using version_bom_file_pkey on version_bom_file vbf (cost=0.43..7.88 rows=1 width=779) (actual time=0.012..0.013 rows=1 loops=5,423)

  • Index Cond: (id = vbe.version_bom_file_id)
11. 11.486 93.217 ↑ 1.0 17,941 1

Hash (cost=12,523.67..12,523.67 rows=18,410 width=434) (actual time=93.217..93.217 rows=17,941 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 9080kB
12. 81.731 81.731 ↑ 1.0 17,941 1

Seq Scan on version_bom_string_search_match vbssm (cost=0.00..12,523.67 rows=18,410 width=434) (actual time=0.020..81.731 rows=17,941 loops=1)

  • Filter: (license_id = '39692bc6-4d1c-4466-a02c-fa6f21170587'::uuid)
  • Rows Removed by Filter: 157953
13. 0.004 0.004 ↓ 0.0 0 2

Index Scan using version_bom_snippet_pkey on version_bom_snippet vbs (cost=0.28..7.39 rows=1 width=414) (actual time=0.002..0.002 rows=0 loops=2)

  • Index Cond: (id = vbe.id)