explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FbNz

Settings
# exclusive inclusive rows x rows loops node
1. 0.013 0.599 ↓ 2.0 2 1

Sort (cost=67.52..67.52 rows=1 width=309) (actual time=0.598..0.599 rows=2 loops=1)

  • Sort Key: pv.ord
  • Sort Method: quicksort Memory: 25kB
2. 0.014 0.586 ↓ 2.0 2 1

Nested Loop (cost=1.06..67.51 rows=1 width=309) (actual time=0.360..0.586 rows=2 loops=1)

  • Join Filter: (pv.cod_prod_var = pz.cod_producto)
3. 0.003 0.034 ↓ 2.0 2 1

Nested Loop (cost=0.57..27.64 rows=1 width=165) (actual time=0.025..0.034 rows=2 loops=1)

4. 0.015 0.015 ↑ 1.5 2 1

Index Scan using prv_cpg_idx on prod_variants pv (cost=0.28..7.49 rows=3 width=28) (actual time=0.014..0.015 rows=2 loops=1)

  • Index Cond: (cod_prod_gen = 10013506)
5. 0.016 0.016 ↑ 1.0 1 2

Index Scan using vpes_cp_idx on v_productos_es v (cost=0.29..6.71 rows=1 width=145) (actual time=0.007..0.008 rows=1 loops=2)

  • Index Cond: (cod_producto = pv.cod_prod_var)
  • Filter: (cod_prod_gen = 10013506)
6. 0.492 0.492 ↑ 5.0 1 2

Function Scan on f_plazo_prod_cache pz (cost=0.50..13.00 rows=5 width=24) (actual time=0.246..0.246 rows=1 loops=2)

  • Filter: (v.cod_producto = cod_producto)
7.          

SubPlan (forNested Loop)

8. 0.024 0.024 ↑ 1.0 1 2

Index Scan using ati18n_cat_ci_pk on attributes_i18n (cost=0.28..6.70 rows=1 width=32) (actual time=0.011..0.012 rows=1 loops=2)

  • Index Cond: ((cod_attb = pv.cod_attb1) AND ((cod_idioma)::text = 'es'::text))
9. 0.002 0.002 ↓ 0.0 0 2

Index Scan using ati18n_cat_ci_pk on attributes_i18n attributes_i18n_1 (cost=0.28..6.70 rows=1 width=32) (actual time=0.001..0.001 rows=0 loops=2)

  • Index Cond: ((cod_attb = pv.cod_attb2) AND ((cod_idioma)::text = 'es'::text))
10. 0.018 0.018 ↑ 1.0 1 2

Index Scan using avi18n_cv_ci_pk on atvalues_i18n (cost=0.28..6.70 rows=1 width=11) (actual time=0.009..0.009 rows=1 loops=2)

  • Index Cond: ((cod_value = pv.cod_val1) AND ((cod_idioma)::text = 'es'::text))
11. 0.002 0.002 ↓ 0.0 0 2

Index Scan using avi18n_cv_ci_pk on atvalues_i18n atvalues_i18n_1 (cost=0.28..6.70 rows=1 width=11) (actual time=0.001..0.001 rows=0 loops=2)

  • Index Cond: ((cod_value = pv.cod_val2) AND ((cod_idioma)::text = 'es'::text))