explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JCDi

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.222 ↑ 2.3 3 1

Limit (cost=87.07..87.09 rows=7 width=215) (actual time=0.221..0.222 rows=3 loops=1)

2. 0.010 0.221 ↑ 2.0 4 1

Sort (cost=87.07..87.09 rows=8 width=215) (actual time=0.221..0.221 rows=4 loops=1)

  • Sort Key: at.orden, patav.cod_attb
  • Sort Method: quicksort Memory: 25kB
3. 0.014 0.211 ↑ 2.0 4 1

WindowAgg (cost=6.99..86.95 rows=8 width=215) (actual time=0.207..0.211 rows=4 loops=1)

4. 0.003 0.197 ↑ 2.0 4 1

Nested Loop Left Join (cost=6.99..86.85 rows=8 width=207) (actual time=0.135..0.197 rows=4 loops=1)

5. 0.005 0.174 ↑ 2.0 4 1

Nested Loop (cost=6.71..36.35 rows=8 width=200) (actual time=0.128..0.174 rows=4 loops=1)

  • Join Filter: (patav.cod_attb = ati18.cod_attb)
6. 0.004 0.137 ↑ 2.0 4 1

Nested Loop (cost=6.43..29.73 rows=8 width=19) (actual time=0.108..0.137 rows=4 loops=1)

7. 0.014 0.121 ↑ 2.0 4 1

Hash Join (cost=6.29..27.89 rows=8 width=23) (actual time=0.101..0.121 rows=4 loops=1)

  • Hash Cond: (patav.cod_attb = at.cod_attb)
8. 0.024 0.024 ↑ 2.0 4 1

Index Scan using cod_pr_at_vl_prod_idx on products_attributes_atvalues patav (cost=0.29..21.78 rows=8 width=11) (actual time=0.010..0.024 rows=4 loops=1)

  • Index Cond: (cod_producto = 10002808)
9. 0.044 0.083 ↑ 1.0 160 1

Hash (cost=4.00..4.00 rows=160 width=12) (actual time=0.083..0.083 rows=160 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
10. 0.039 0.039 ↑ 1.0 160 1

Seq Scan on attributes at (cost=0.00..4.00 rows=160 width=12) (actual time=0.008..0.039 rows=160 loops=1)

11. 0.012 0.012 ↑ 1.0 1 4

Index Scan using at_gp_pk on atgroups ag (cost=0.14..0.22 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=4)

  • Index Cond: (cod_group = at.cod_group)
  • Filter: ((visibilidad)::text = 'S'::text)
12. 0.032 0.032 ↑ 1.0 1 4

Index Scan using ati18n_cat_ci_pk on attributes_i18n ati18 (cost=0.28..0.82 rows=1 width=189) (actual time=0.008..0.008 rows=1 loops=4)

  • Index Cond: ((cod_attb = at.cod_attb) AND ((cod_idioma)::text = 'es'::text))
13. 0.020 0.020 ↑ 1.0 1 4

Index Scan using avi18n_cv_ci_pk on atvalues_i18n avi18 (cost=0.28..6.30 rows=1 width=15) (actual time=0.004..0.005 rows=1 loops=4)

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