explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VneM : Optimization for: Optimization for: Optimization for: plan #cjH6; plan #RIdw; plan #VE6w

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.001 320.089 ↓ 0.0 0 1

Nested Loop (cost=2,027.22..50,412.72 rows=1 width=194) (actual time=320.089..320.089 rows=0 loops=1)

2. 296.492 320.088 ↓ 0.0 0 1

Bitmap Heap Scan on dispensaciones_cache d (cost=2,026.80..50,395.65 rows=1 width=4) (actual time=320.088..320.088 rows=0 loops=1)

  • Recheck Cond: (id_medicamento = 24117)
  • Filter: ((administracionm_normalizada >= 20180101) AND (administracionm_normalizada <= 20181231))
  • Rows Removed by Filter: 111992
  • Heap Blocks: exact=42662
3. 23.596 23.596 ↓ 1.0 111,992 1

Bitmap Index Scan on dispensacion_medicamento (cost=0.00..2,026.79 rows=109,649 width=0) (actual time=23.596..23.596 rows=111,992 loops=1)

  • Index Cond: (id_medicamento = 24117)
4. 0.000 0.000 ↓ 0.0 0

Index Scan using id_nf on episodios_cache_nf e (cost=0.42..17.05 rows=1 width=194) (never executed)

  • Index Cond: (id = d.id_episodio)
  • Filter: ((id_hospital = 290) AND (id_norma = 1))
Planning time : 1.402 ms
Execution time : 320.164 ms