explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GGTg

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 0.329 ↑ 5.0 1 1

GroupAggregate (cost=31.20..31.37 rows=5 width=36) (actual time=0.328..0.329 rows=1 loops=1)

  • Group Key: pz.plazo_calc
2. 0.009 0.319 ↑ 5.0 1 1

Sort (cost=31.20..31.22 rows=5 width=12) (actual time=0.318..0.319 rows=1 loops=1)

  • Sort Key: pz.plazo_calc
  • Sort Method: quicksort Memory: 17kB
3. 0.005 0.310 ↑ 5.0 1 1

Nested Loop (cost=1.21..31.14 rows=5 width=12) (actual time=0.298..0.310 rows=1 loops=1)

4. 0.008 0.053 ↑ 1.0 1 1

Nested Loop (cost=0.71..18.09 rows=1 width=16) (actual time=0.043..0.053 rows=1 loops=1)

5. 0.007 0.035 ↑ 1.0 1 1

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

6. 0.017 0.017 ↑ 1.0 1 1

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

  • Filter: ((no_contabiliza)::text = 'N'::text)
  • Rows Removed by Filter: 25
7. 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))
8. 0.010 0.010 ↑ 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.009..0.010 rows=1 loops=1)

  • Index Cond: ((cod_producto = 10001796) AND (cod_grupo_tarifas = ANY ('{1}'::integer[])))
9. 0.252 0.252 ↑ 5.0 1 1

Function Scan on f_plazo_prod_cache pz (cost=0.50..13.00 rows=5 width=8) (actual time=0.251..0.252 rows=1 loops=1)

  • Filter: (cod_producto = 10001796)