explain.depesz.com

PostgreSQL's explain analyze made readable

Result: M56Y

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 0.347 ↑ 5.0 1 1

Nested Loop (cost=0.78..67.36 rows=5 width=16) (actual time=0.346..0.347 rows=1 loops=1)

2. 0.026 0.026 ↑ 1.0 1 1

Index Scan using vpes_cp_idx on v_productos_es p (cost=0.28..6.70 rows=1 width=8) (actual time=0.025..0.026 rows=1 loops=1)

  • Index Cond: (cod_producto = 10009998)
  • Filter: ((visible_web)::text = 'S'::text)
3. 0.295 0.295 ↑ 5.0 1 1

Function Scan on f_plazo_prod_cache pz (cost=0.50..13.00 rows=5 width=12) (actual time=0.295..0.295 rows=1 loops=1)

  • Filter: (cod_producto = 10009998)
4.          

SubPlan (forNested Loop)

5. 0.005 0.021 ↑ 1.0 1 1

Aggregate (cost=9.51..9.52 rows=1 width=4) (actual time=0.021..0.021 rows=1 loops=1)

6. 0.016 0.016 ↑ 1.0 1 1

Index Scan using pa_cp_idx on productos_almacen (cost=0.29..9.51 rows=1 width=8) (actual time=0.015..0.016 rows=1 loops=1)

  • Index Cond: (cod_producto = p.cod_producto)
  • Filter: (((stock_disponible - stock_comprometido) >= 1) AND (cod_almacen = ANY ('{1,18,13,15,19}'::integer[])))
  • Rows Removed by Filter: 10