explain.depesz.com

PostgreSQL's explain analyze made readable

Result: q09B

Settings
# exclusive inclusive rows x rows loops node
1. 136.192 136.192 ↓ 1.1 74,025 1

Index Scan using index_bookings_on_hotel_id_manual_1 on bookings (cost=0.58..157,508.26 rows=65,041 width=566) (actual time=0.014..136.192 rows=74,025 loops=1)

  • Index Cond: (hotel_id = ANY ('{123,234,456,789,28439,439,702,323,564,29,3984,8320,7253,402}'::integer[]))
  • Planning time: 0.274 ms
  • Execution time: 151.276 ms