explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0fyj

Settings
# exclusive inclusive rows x rows loops node
1. 0.017 1.196 ↑ 5.0 1 1

GroupAggregate (cost=1.41..33.53 rows=5 width=36) (actual time=1.196..1.196 rows=1 loops=1)

  • Group Key: p.cod_producto
2. 0.041 1.179 ↑ 1.0 5 1

Nested Loop (cost=1.41..33.42 rows=5 width=8) (actual time=0.765..1.179 rows=5 loops=1)

  • Join Filter: (m.cod_mkp = p.cod_mkp)
  • Rows Removed by Join Filter: 25
3. 0.334 1.096 ↑ 1.0 6 1

Hash Join (cost=1.14..28.59 rows=6 width=4) (actual time=0.058..1.096 rows=6 loops=1)

  • Hash Cond: (t.cod_tienda = m.cod_tienda)
4. 0.745 0.745 ↑ 1.0 434 1

Seq Scan on tiendas t (cost=0.00..25.77 rows=434 width=4) (actual time=0.012..0.745 rows=434 loops=1)

  • Filter: (1 = ANY (cod_alm_a))
5. 0.009 0.017 ↑ 1.0 6 1

Hash (cost=1.06..1.06 rows=6 width=8) (actual time=0.017..0.017 rows=6 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 5kB
6. 0.008 0.008 ↑ 1.0 6 1

Seq Scan on marketplaces m (cost=0.00..1.06 rows=6 width=8) (actual time=0.003..0.008 rows=6 loops=1)

7. 0.024 0.042 ↑ 1.0 5 6

Materialize (cost=0.28..4.39 rows=5 width=8) (actual time=0.003..0.007 rows=5 loops=6)

8. 0.018 0.018 ↑ 1.0 5 1

Index Only Scan using pmkp_cpcmpkcsidx on prod_mkp p (cost=0.28..4.36 rows=5 width=8) (actual time=0.010..0.018 rows=5 loops=1)

  • Index Cond: (cod_producto = 10005725)
  • Heap Fetches: 4