explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0lr9

Settings
# exclusive inclusive rows x rows loops node
1. 0.045 0.569 ↑ 1.0 1 1

GroupAggregate (cost=36.31..36.36 rows=1 width=40) (actual time=0.568..0.569 rows=1 loops=1)

  • Group Key: pp.stock_proveedor, ppe.plazo_con_stock
2. 0.073 0.524 ↑ 1.0 1 1

Sort (cost=36.31..36.32 rows=1 width=16) (actual time=0.523..0.524 rows=1 loops=1)

  • Sort Key: pp.stock_proveedor, ppe.plazo_con_stock
  • Sort Method: quicksort Memory: 17kB
3. 0.010 0.451 ↑ 1.0 1 1

Nested Loop (cost=9.31..36.30 rows=1 width=16) (actual time=0.414..0.451 rows=1 loops=1)

  • Join Filter: (pgt.cod_proveedor = pp.cod_proveedor)
4. 0.003 0.433 ↑ 1.0 1 1

Nested Loop (cost=9.02..31.24 rows=1 width=24) (actual time=0.401..0.433 rows=1 loops=1)

5. 0.005 0.420 ↑ 1.0 1 1

Nested Loop (cost=8.74..22.93 rows=1 width=24) (actual time=0.390..0.420 rows=1 loops=1)

6. 0.009 0.036 ↑ 1.0 1 1

Nested Loop (cost=0.29..9.64 rows=1 width=12) (actual time=0.031..0.036 rows=1 loops=1)

7. 0.016 0.016 ↑ 1.0 1 1

Seq Scan on almacenes a (cost=0.00..1.32 rows=1 width=4) (actual time=0.014..0.016 rows=1 loops=1)

  • Filter: ((no_contabiliza)::text = 'N'::text)
  • Rows Removed by Filter: 25
8. 0.011 0.011 ↑ 1.0 1 1

Index Scan using ca_cp_pk on productos_almacen pa (cost=0.29..8.31 rows=1 width=16) (actual time=0.010..0.011 rows=1 loops=1)

  • Index Cond: ((cod_almacen = a.cod_almacen) AND (cod_almacen = ANY ('{1}'::integer[])) AND (cod_producto = 10001796))
9. 0.172 0.379 ↑ 1.0 1 1

Hash Join (cost=8.45..13.27 rows=1 width=16) (actual time=0.356..0.379 rows=1 loops=1)

  • Hash Cond: (ppe.cod_proveedor = pgt.cod_proveedor)
10. 0.170 0.170 ↑ 1.0 173 1

Seq Scan on prov_paises_entrega ppe (cost=0.00..4.16 rows=173 width=8) (actual time=0.007..0.170 rows=173 loops=1)

  • Filter: ((cod_pais_entrega)::text = 'ES'::text)
11. 0.023 0.037 ↑ 1.0 1 1

Hash (cost=8.44..8.44 rows=1 width=8) (actual time=0.037..0.037 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 5kB
12. 0.014 0.014 ↑ 1.0 1 1

Index Scan using productos_grupo_tarifas_pk on productos_grupo_tarifas pgt (cost=0.42..8.44 rows=1 width=8) (actual time=0.012..0.014 rows=1 loops=1)

  • Index Cond: ((cod_producto = 10001796) AND (cod_grupo_tarifas = ANY ('{1}'::integer[])))
13. 0.010 0.010 ↑ 1.0 1 1

Index Scan using cod_producto on productos p (cost=0.29..8.30 rows=1 width=4) (actual time=0.009..0.010 rows=1 loops=1)

  • Index Cond: (cod_producto = 10001796)
  • Filter: (cod_estado_comercial <> 2)
14. 0.008 0.008 ↑ 1.0 1 1

Index Scan using pp_pk on productos_proveedor pp (cost=0.29..5.05 rows=1 width=12) (actual time=0.007..0.008 rows=1 loops=1)

  • Index Cond: ((cod_producto = 10001796) AND (cod_proveedor = ppe.cod_proveedor))