explain.depesz.com

PostgreSQL's explain analyze made readable

Result: P5Si

Settings
# exclusive inclusive rows x rows loops node
1. 0.204 14.482 ↑ 7.2 117 1

Sort (cost=1,514.28..1,516.39 rows=844 width=21) (actual time=14.469..14.482 rows=117 loops=1)

  • Sort Key: p.marca
  • Sort Method: quicksort Memory: 33kB
2. 1.492 14.278 ↑ 7.2 117 1

HashAggregate (cost=1,464.82..1,473.26 rows=844 width=21) (actual time=14.254..14.278 rows=117 loops=1)

  • Group Key: p.marca, p.cod_marca
3. 3.182 12.786 ↑ 1.1 4,017 1

Hash Join (cost=797.17..1,430.62 rows=4,559 width=13) (actual time=7.327..12.786 rows=4,017 loops=1)

  • Hash Cond: (prod.cod_producto = p.cod_producto)
4. 2.387 2.387 ↑ 1.0 15,253 1

Seq Scan on productos prod (cost=0.00..530.30 rows=15,350 width=4) (actual time=0.010..2.387 rows=15,253 loops=1)

5. 1.025 7.217 ↑ 1.1 4,017 1

Hash (cost=740.19..740.19 rows=4,559 width=17) (actual time=7.217..7.217 rows=4,017 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 262kB
6. 6.192 6.192 ↑ 1.1 4,017 1

Seq Scan on v_productos_es p (cost=0.00..740.19 rows=4,559 width=17) (actual time=0.009..6.192 rows=4,017 loops=1)

  • Filter: ((cod_prod_role = ANY ('{1,2}'::integer[])) AND ((visible_web)::text = 'S'::text))
  • Rows Removed by Filter: 4422