explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pnh2

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 8.121 ↑ 1.0 4 1

Sort (cost=855.40..855.41 rows=4 width=25) (actual time=8.120..8.121 rows=4 loops=1)

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

HashAggregate (cost=855.32..855.36 rows=4 width=25) (actual time=8.111..8.113 rows=4 loops=1)

  • Group Key: pui.cod_prod_use, pui.name
3. 1.229 6.913 ↑ 1.1 4,017 1

Hash Join (cost=1.20..821.14 rows=4,558 width=17) (actual time=0.029..6.913 rows=4,017 loops=1)

  • Hash Cond: (p.cod_prod_use = pui.cod_prod_use)
4. 5.671 5.671 ↑ 1.1 4,017 1

Seq Scan on v_productos_es p (cost=0.00..740.17 rows=4,558 width=4) (actual time=0.011..5.671 rows=4,017 loops=1)

  • Filter: ((cod_prod_role = ANY ('{1,2}'::integer[])) AND ((visible_web)::text = 'S'::text))
  • Rows Removed by Filter: 4421
5. 0.003 0.013 ↑ 1.0 4 1

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

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

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

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