rendered paste bodyic_pg_otb=# EXPLAIN ANALYZE select * from packages where departure_date='2007-10-20' and hotel_town='Puerto Rico' and nights =7;
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------------------
Bitmap Heap Scan on packages (cost=3937.73..4873.92 rows=234 width=314) (actual time=12394.385..16864.328 rows=2659 loops=1)
Recheck Cond: (((hotel_town)::text = 'Puerto Rico'::text) AND (departure_date = '2007-10-20'::date) AND (nights = 7))
-> BitmapAnd (cost=3937.73..3937.73 rows=234 width=0) (actual time=12376.753..12376.753 rows=0 loops=1)
-> Bitmap Index Scan on packages_hotel_town (cost=0.00..1384.58 rows=107022 width=0) (actual time=12294.798..12294.798 rows=280762 loops=1)
Index Cond: ((hotel_town)::text = 'Puerto Rico'::text)
-> Bitmap Index Scan on packages_ibg2 (cost=0.00..2552.90 rows=114888 width=0) (actual time=61.289..61.289 rows=178011 loops=1)
Index Cond: ((departure_date = '2007-10-20'::date) AND (nights = 7))
Total runtime: 16868.909 ms