explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pkK9

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.236 18.707 ↑ 7.2 117 1
→

Sort (cost=1,519.55..1,521.66 rows=844 width=21) (actual time=18.690..18.707 rows=117 loops=1)

  • Sort Key: p.marca
  • Sort Method: quicksort Memory: 33kB
2. 1.520 18.471 ↑ 7.2 117 1
→

HashAggregate (cost=1,470.09..1,478.53 rows=844 width=21) (actual time=18.441..18.471 rows=117 loops=1)

  • Group Key: p.marca, p.cod_marca
3. 3.348 16.951 ↑ 1.1 4,018 1
→

Hash Join (cost=796.39..1,435.89 rows=4,559 width=13) (actual time=10.187..16.951 rows=4,018 loops=1)

  • Hash Cond: (prod.cod_producto = p.cod_producto)
4. 3.602 3.602 ↑ 1.0 15,254 1
→

Seq Scan on productos prod (cost=0.00..536.23 rows=15,383 width=4) (actual time=0.017..3.602 rows=15,254 loops=1)

5. 1.318 10.001 ↑ 1.1 4,018 1
→

Hash (cost=739.40..739.40 rows=4,559 width=17) (actual time=10.001..10.001 rows=4,018 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 262kB
6. 8.683 8.683 ↑ 1.1 4,018 1
→

Seq Scan on v_productos_es p (cost=0.00..739.40 rows=4,559 width=17) (actual time=0.024..8.683 rows=4,018 loops=1)

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