explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 45k

Settings
# exclusive inclusive rows x rows loops node
1. 159.556 178.655 ↑ 1.0 69,671 1

Bitmap Heap Scan on victor uniform (cost=2,154.920..32,057.260 rows=71,267 width=74) (actual time=23.355..178.655 rows=69,671 loops=1)

  • Recheck Cond: (hotel_whiskey < ((zulu())::date - 'two'::interval))
  • Filter: hotel_two
  • Heap Blocks: exact=26050
2. 19.099 19.099 ↑ 1.0 69,671 1

Bitmap Index Scan on golf (cost=0.000..2,137.100 rows=71,267 width=0) (actual time=19.099..19.099 rows=69,671 loops=1)

  • Index Cond: ((hotel_two = true) AND (hotel_whiskey < ((zulu())::date - 'two'::interval)))
Planning time : 0.302 ms
Execution time : 180.652 ms