explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AuVL : Optimization for: plan #KUyV

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 1.077 3.504 ↑ 1.0 809 1

Seq Scan on m_productionline (cost=0.00..7,009.60 rows=840 width=259) (actual time=0.112..3.504 rows=809 loops=1)

2.          

SubPlan (for Seq Scan)

3. 2.427 2.427 ↑ 1.0 1 809

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

  • Index Cond: (m_product_id = m_productionline.m_product_id)
Planning time : 0.167 ms
Execution time : 3.836 ms