explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 69ht0

Settings
# exclusive inclusive rows x rows loops node
1. 0.019 1.185 ↓ 2.0 2 1

Sort (cost=65.25..65.26 rows=1 width=240) (actual time=1.184..1.185 rows=2 loops=1)

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

Nested Loop (cost=15.02..65.24 rows=1 width=240) (actual time=0.691..1.166 rows=2 loops=1)

3. 0.018 1.117 ↓ 2.0 2 1

Nested Loop (cost=8.04..52.64 rows=1 width=196) (actual time=0.666..1.117 rows=2 loops=1)

4. 0.009 1.061 ↓ 2.0 2 1

Nested Loop (cost=1.06..40.70 rows=1 width=181) (actual time=0.638..1.061 rows=2 loops=1)

  • Join Filter: (pv.cod_prod_var = pz.cod_producto)
5. 0.007 0.050 ↓ 2.0 2 1

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

6. 0.019 0.019 ↑ 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.017..0.019 rows=2 loops=1)

  • Index Cond: (cod_prod_gen = 10013506)
7. 0.024 0.024 ↑ 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.011..0.012 rows=1 loops=2)

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

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

  • Filter: (v.cod_producto = cod_producto)
9. 0.008 0.038 ↑ 2.0 1 2

Bitmap Heap Scan on attributes_i18n ati (cost=6.97..11.92 rows=2 width=19) (actual time=0.019..0.019 rows=1 loops=2)

  • Recheck Cond: (((cod_attb = pv.cod_attb1) AND ((cod_idioma)::text = 'es'::text)) OR ((cod_attb = pv.cod_attb2) AND ((cod_idioma)::text = 'es'::text)))
  • Heap Blocks: exact=2
10. 0.006 0.030 ↓ 0.0 0 2

BitmapOr (cost=6.97..6.97 rows=2 width=0) (actual time=0.015..0.015 rows=0 loops=2)

11. 0.022 0.022 ↑ 1.0 1 2

Bitmap Index Scan on ati18n_cat_ci_pk (cost=0.00..3.49 rows=1 width=0) (actual time=0.011..0.011 rows=1 loops=2)

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

Bitmap Index Scan on ati18n_cat_ci_pk (cost=0.00..3.49 rows=1 width=0) (actual time=0.001..0.001 rows=0 loops=2)

  • Index Cond: ((cod_attb = pv.cod_attb2) AND ((cod_idioma)::text = 'es'::text))
13. 0.008 0.030 ↑ 2.0 1 2

Bitmap Heap Scan on atvalues_i18n atv (cost=6.99..12.57 rows=2 width=15) (actual time=0.015..0.015 rows=1 loops=2)

  • Recheck Cond: (((cod_value = pv.cod_val1) AND ((cod_idioma)::text = 'es'::text)) OR ((cod_value = pv.cod_val2) AND ((cod_idioma)::text = 'es'::text)))
  • Heap Blocks: exact=2
14. 0.004 0.022 ↓ 0.0 0 2

BitmapOr (cost=6.99..6.99 rows=2 width=0) (actual time=0.011..0.011 rows=0 loops=2)

15. 0.018 0.018 ↑ 1.0 1 2

Bitmap Index Scan on avi18n_cv_ci_pk (cost=0.00..3.49 rows=1 width=0) (actual time=0.009..0.009 rows=1 loops=2)

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

Bitmap Index Scan on avi18n_cv_ci_pk (cost=0.00..3.49 rows=1 width=0) (actual time=0.000..0.000 rows=0 loops=2)

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