explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lxf

Settings
# exclusive inclusive rows x rows loops node
1. 0.013 19.741 ↑ 1.0 4 1

Sort (cost=1,552.30..1,552.31 rows=4 width=25) (actual time=19.741..19.741 rows=4 loops=1)

  • Sort Key: pui.cod_prod_use
  • Sort Method: quicksort Memory: 25kB
2. 1.375 19.728 ↑ 1.0 4 1

HashAggregate (cost=1,552.22..1,552.26 rows=4 width=25) (actual time=19.727..19.728 rows=4 loops=1)

  • Group Key: pui.cod_prod_use, pui.name
3. 1.275 18.353 ↑ 1.1 4,015 1

Hash Join (cost=797.53..1,518.03 rows=4,558 width=17) (actual time=9.887..18.353 rows=4,015 loops=1)

  • Hash Cond: (p.cod_prod_use = pui.cod_prod_use)
4. 3.588 17.045 ↑ 1.1 4,015 1

Hash Join (cost=796.33..1,437.07 rows=4,558 width=4) (actual time=9.845..17.045 rows=4,015 loops=1)

  • Hash Cond: (prod.cod_producto = p.cod_producto)
5. 3.795 3.795 ↑ 1.0 15,254 1

Seq Scan on productos prod (cost=0.00..537.35 rows=15,415 width=4) (actual time=0.023..3.795 rows=15,254 loops=1)

6. 1.061 9.662 ↑ 1.1 4,015 1

Hash (cost=739.36..739.36 rows=4,558 width=8) (actual time=9.662..9.662 rows=4,015 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 221kB
7. 8.601 8.601 ↑ 1.1 4,015 1

Seq Scan on v_productos_es p (cost=0.00..739.36 rows=4,558 width=8) (actual time=0.013..8.601 rows=4,015 loops=1)

  • Filter: ((cod_prod_role = ANY ('{1,2}'::integer[])) AND ((visible_web)::text = 'S'::text))
  • Rows Removed by Filter: 4422
8. 0.006 0.033 ↑ 1.0 4 1

Hash (cost=1.15..1.15 rows=4 width=17) (actual time=0.033..0.033 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
9. 0.027 0.027 ↑ 1.0 4 1

Seq Scan on prods_uses_idioma pui (cost=0.00..1.15 rows=4 width=17) (actual time=0.021..0.027 rows=4 loops=1)

  • Filter: ((cod_idioma)::text = 'es'::text)
  • Rows Removed by Filter: 24