All pastes #544325 Raw Edit

Mine

public text v1 · immutable
·published 2007-06-06 12:05 UTC
rendered paste body
ic_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