explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZHcV

Settings
# exclusive inclusive rows x rows loops node
1. 46.435 51.628 ↑ 1.4 2,796 1

Bitmap Heap Scan on bookings (cost=1,313.64..106,118.61 rows=3,900 width=566) (actual time=10.487..51.628 rows=2,796 loops=1)

  • Recheck Cond: (((hotel_id = ANY ('{123,234,456,789,28439,439,702,323,564,29,3984,8320,7253,402}'::integer[])) AND (status = 0)) OR ((hotel_id = ANY ('{123,234,456,789,28439,439,702,323,564,29,3984,8320,7253,402}'::integer[])) AND (status = 2)))
  • Filter: (((coupon_code)::text = 'OYOAPP30'::text) AND (hotel_id = ANY ('{123,234,456,789,28439,439,702,323,564,29,3984,8320,7253,402}'::integer[])))
  • Rows Removed by Filter: 27767
  • Heap Blocks: exact=29866
  • Planning time: 0.327 ms
  • Execution time: 52.308 ms
2. 0.002 5.193 ↓ 0.0 0 1

BitmapOr (cost=1,313.64..1,313.64 rows=28,781 width=0) (actual time=5.193..5.193 rows=0 loops=1)

3. 0.190 0.190 ↑ 3.3 92 1

Bitmap Index Scan on index_bookings_on_multicolumns_hotel_id_status_checkin_source_c (cost=0.00..67.00 rows=301 width=0) (actual time=0.190..0.190 rows=92 loops=1)

  • Index Cond: ((hotel_id = ANY ('{123,234,456,789,28439,439,702,323,564,29,3984,8320,7253,402}'::integer[])) AND (status = 0))
4. 5.001 5.001 ↓ 1.1 30,529 1

Bitmap Index Scan on index_bookings_on_multicolumns_hotel_id_status_checkin_source_c (cost=0.00..1,244.69 rows=28,479 width=0) (actual time=5.001..5.001 rows=30,529 loops=1)

  • Index Cond: ((hotel_id = ANY ('{123,234,456,789,28439,439,702,323,564,29,3984,8320,7253,402}'::integer[])) AND (status = 2))