explain.depesz.com

PostgreSQL's explain analyze made readable

Result: i6ji

Settings
# exclusive inclusive rows x rows loops node
1. 0.029 1.143 ↑ 1.0 5 1

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

  • Join Filter: (m.cod_mkp = p.cod_mkp)
  • Rows Removed by Join Filter: 25
2. 0.368 1.060 ↑ 1.0 6 1

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

  • Hash Cond: (t.cod_tienda = m.cod_tienda)
3. 0.675 0.675 ↑ 1.0 434 1

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

  • Filter: (1 = ANY (cod_alm_a))
4. 0.006 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
5. 0.011 0.011 ↑ 1.0 6 1

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

6. 0.035 0.054 ↑ 1.0 5 6

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

7. 0.019 0.019 ↑ 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.019 rows=5 loops=1)

  • Index Cond: (cod_producto = 10005725)
  • Heap Fetches: 4
Planning time : 0.517 ms
Execution time : 1.199 ms