explain.depesz.com

PostgreSQL's explain analyze made readable

Result: i5Fk

Settings
# exclusive inclusive rows x rows loops node
1. 0.947 2.565 ↑ 1.0 809 1

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

2.          

SubPlan (for Seq Scan)

3. 1.618 1.618 ↑ 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.002..0.002 rows=1 loops=809)

  • Index Cond: (m_product_id = m_productionline.m_product_id)
Planning time : 0.140 ms
Execution time : 2.641 ms