explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lyRu : Optimization for: testmk_dom_lb01; plan #jUYM

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 201.908 1,237.389 ↑ 1.0 1 1

GroupAggregate (cost=41.87..8,582.54 rows=1 width=37) (actual time=1,237.389..1,237.389 rows=1 loops=1)

  • Group Key: sub_dim_mercado_productos.mktadm_mercado_grupo
  • Buffers: shared hit=354949
2. 123.820 1,035.481 ↓ 4,604.7 764,387 1

Nested Loop (cost=41.87..8,581.70 rows=166 width=37) (actual time=0.194..1,035.481 rows=764,387 loops=1)

  • Buffers: shared hit=354949
3. 0.921 0.921 ↓ 706.0 706 1

Index Scan using idx_mfp_merc_arm on sub_dim_mercado_productos (cost=0.55..8.56 rows=1 width=30) (actual time=0.054..0.921 rows=706 loops=1)

  • Index Cond: ((mktadm_mercado_grupo)::text = 'Mercado Marketing DOM'::text)
  • Buffers: shared hit=72
4. 828.138 910.740 ↑ 2.0 1,083 706

Bitmap Heap Scan on f_mfp (cost=41.33..8,551.51 rows=2,163 width=15) (actual time=0.187..1.290 rows=1,083 loops=706)

  • Recheck Cond: (pk_producto_competencia = sub_dim_mercado_productos.pk_producto_competencia)
  • Heap Blocks: exact=349957
  • Buffers: shared hit=354877
5. 82.602 82.602 ↑ 2.0 1,083 706

Bitmap Index Scan on idx_pk_pc_procomp (cost=0.00..40.79 rows=2,163 width=0) (actual time=0.117..0.117 rows=1,083 loops=706)

  • Index Cond: (pk_producto_competencia = sub_dim_mercado_productos.pk_producto_competencia)
  • Buffers: shared hit=4920