explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ivzJ

Settings
# exclusive inclusive rows x rows loops node
1. 124.793 174.893 ↑ 1.0 63,810 1

Bitmap Heap Scan on episodios_cache e (cost=8,864.55..54,421.82 rows=64,185 width=4) (actual time=55.776..174.893 rows=63,810 loops=1)

  • Recheck Cond: ((id_hospital = 290) AND (altad_normalizada > 20180101) AND (id_norma = 1))
  • Heap Blocks: exact=17272
2. 50.100 50.100 ↑ 1.0 63,810 1

Bitmap Index Scan on hospital_norma (cost=0.00..8,848.50 rows=64,185 width=0) (actual time=50.100..50.100 rows=63,810 loops=1)

  • Index Cond: ((id_hospital = 290) AND (altad_normalizada > 20180101) AND (id_norma = 1))
Planning time : 0.128 ms
Execution time : 181.203 ms