explain.depesz.com

PostgreSQL's explain analyze made readable

Result: t27C

Settings
# exclusive inclusive rows x rows loops node
1. 107.828 162.283 ↓ 1.0 55,035 1

Bitmap Heap Scan on episodios_cache e (cost=8,164.57..53,946.84 rows=54,278 width=4) (actual time=60.005..162.283 rows=55,035 loops=1)

  • Recheck Cond: ((id_hospital = 290) AND (altad_normalizada >= 20180101) AND (altad_normalizada <= 20181231) AND (id_norma = 1))
  • Heap Blocks: exact=15125
2. 54.455 54.455 ↓ 1.0 55,035 1

Bitmap Index Scan on hospital_norma (cost=0.00..8,151.00 rows=54,278 width=0) (actual time=54.455..54.455 rows=55,035 loops=1)

  • Index Cond: ((id_hospital = 290) AND (altad_normalizada >= 20180101) AND (altad_normalizada <= 20181231) AND (id_norma = 1))
Planning time : 0.190 ms
Execution time : 167.875 ms