explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0fE4

Settings
# exclusive inclusive rows x rows loops node
1. 3.966 48.334 ↓ 4.9 576 1

Bitmap Heap Scan on yankee_oscar (cost=2,049.500..2,520.890 rows=118 width=1,136) (actual time=44.434..48.334 rows=576 loops=1)

  • Recheck Cond: (((hotel)::text = 'echo'::text) AND (five && 'two'::date[]) AND (victor && 'alpha'::character varying[]))
  • Heap Blocks: exact=635
2. 44.368 44.368 ↓ 5.7 674 1

Bitmap Index Scan on yankee_three (cost=0.000..2,049.470 rows=118 width=0) (actual time=44.368..44.368 rows=674 loops=1)

  • Index Cond: (((hotel)::text = 'echo'::text) AND (five && 'two'::date[]) AND (victor && 'alpha'::character varying[]))
Planning time : 0.937 ms
Execution time : 48.521 ms