explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eYlL

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

Seq Scan on m_productionline (cost=0.00..7,009.60 rows=840 width=259) (actual rows= loops=)

2.          

SubPlan (for Seq Scan)

3. 0.000 0.000 ↓ 0.0

Index Scan using m_product_pkey on m_product (cost=0.29..8.30 rows=1 width=2) (actual rows= loops=)

  • Index Cond: (m_product_id = m_productionline.m_product_id)