explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CrZt

Settings
# exclusive inclusive rows x rows loops node
1. 0.046 40.274 ↑ 1.0 1 1

Index Scan using m_productionline_pkey on m_productionline (cost=0.42..7.18 rows=1 width=819) (actual time=40.274..40.274 rows=1 loops=1)

  • Index Cond: (m_productionline_id = '5000003'::numeric)
2.          

SubPlan (forIndex Scan)

3. 40.219 40.219 ↑ 1.0 1 1

Seq Scan on m_locator l (cost=0.00..2.04 rows=1 width=32) (actual time=40.216..40.219 rows=1 loops=1)

  • Filter: (m_locator_id = m_productionline.m_locator_id)
  • Rows Removed by Filter: 22
4. 0.009 0.009 ↑ 1.0 1 1

Index Scan using m_product_pkey on m_product (cost=0.28..2.50 rows=1 width=2) (actual time=0.009..0.009 rows=1 loops=1)

  • Index Cond: (m_product_id = m_productionline.m_product_id)