Untitled

ic_pg_otb=# EXPLAIN ANALYZE  select * from packages where departure_date='2007-10-20' and hotel_town='Canico' and nights =7;
                                                                   QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------------
 Bitmap Heap Scan on packages  (cost=3937.73..4873.92 rows=234 width=314) (actual time=7343.024..7343.024 rows=0 loops=1)
   Recheck Cond: (((hotel_town)::text = 'Canico'::text) AND (departure_date = '2007-10-20'::date) AND (nights = 7))
   ->  BitmapAnd  (cost=3937.73..3937.73 rows=234 width=0) (actual time=7343.019..7343.019 rows=0 loops=1)
         ->  Bitmap Index Scan on packages_hotel_town  (cost=0.00..1384.58 rows=107022 width=0) (actual time=600.191..600.191 rows=8686 loops=1)
               Index Cond: ((hotel_town)::text = 'Canico'::text)
         ->  Bitmap Index Scan on packages_ibg2  (cost=0.00..2552.90 rows=114888 width=0) (actual time=6741.842..6741.842 rows=178011 loops=1)
               Index Cond: ((departure_date = '2007-10-20'::date) AND (nights = 7))