explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IcY : Long query with time range

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 44.446 ↓ 0.0 0 1

Bitmap Heap Scan on time_limits (cost=4,730.38..22,465.32 rows=62,682 width=36) (actual time=44.446..44.446 rows=0 loops=1)

  • Recheck Cond: ((id_phi = 0) AND (start_date_time <= '2011-08-08 00:00:00'::timestamp without time zone) AND (end_date_time >= '2011-08-08 00:05:00'::timestamp without time zone))
2. 44.437 44.437 ↓ 0.0 0 1

Bitmap Index Scan on idx_time_limits_phi_start_end (cost=0.00..4,714.71 rows=62,682 width=0) (actual time=44.437..44.437 rows=0 loops=1)

  • Index Cond: ((id_phi = 0) AND (start_date_time <= '2011-08-08 00:00:00'::timestamp without time zone) AND (end_date_time >= '2011-08-08 00:05:00'::timestamp without time zone))
Total runtime : 44.507 ms