explain.depesz.com

PostgreSQL's explain analyze made readable

Result: stLZ

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Aggregate (cost=206,140,934.25..206,140,934.26 rows=1 width=0) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.84..206,140,549.50 rows=153,900 width=0) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.42..206,066,190.01 rows=153,900 width=8) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..205,990,927.24 rows=153,900 width=4) (actual rows= loops=)

  • Join Filter: ((a.mpn_bis = b.mpn_bis) OR (b.mpn_bis = (a.normalized_value)::text))
5. 0.000 0.000 ↓ 0.0

Seq Scan on normalized_manufacturing_part_numbers a (cost=0.00..23,842.78 rows=896,178 width=32) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..768.00 rows=13,133 width=32) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on offer_rutronik b (cost=0.00..702.33 rows=13,133 width=32) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Index Only Scan using material_requirement_plannings_article_id on material_requirement_plannings mrp (cost=0.42..0.48 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (article_id = a.article_id)
9. 0.000 0.000 ↓ 0.0

Index Only Scan using articles_pkey on articles (cost=0.42..0.47 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = a.article_id)