query-plan-1241

Change label
Query Plan as raw text
Summary
Time Node
Node (ms) Percent
191879.422 100.00% 
 Sort (cost=1203757.22..1203757.59 rows=149 width=16) (actual time=191879.154..191879.422 rows=353 loops=1)
   Sort Key: (date_trunc('week'::text, measurement.measurement_date))
   Sort Method:  quicksort  Memory: 41kB
191878.444 100.00% 
   -> HashAggregate (cost=1203749.6..1203751.84 rows=149 width=16) (actual time=191877.400..191878.444 rows=353 loops=1)
188605.572 98.29% 
         -> Nested Loop (cost=151740.51..1199855.17 rows=778887 width=16) (actual time=43501.275..188605.572 rows=630830 loops=1)
0.033 0.00% 
               -> Seq Scan on sensor_station (cost=0.0..1.31 rows=1 width=4) (actual time=0.020..0.033 rows=1 loops=1)
                     Filter: (sensor_station_key = 1)
186011.491 96.94% 
               -> Nested Loop (cost=151740.51..1190117.77 rows=778887 width=20) (actual time=43501.218..186011.491 rows=630830 loops=1)
0.026 0.00% 
                     -> Index Scan using meas_type_dtl_pkey on meas_type_dtl (cost=0.0..8.27 rows=1 width=4) (actual time=0.020..0.026 rows=1 loops=1)
                           Index Cond: (meas_type_dtl_key = 1003)
184450.377 96.13% 
                     -> Bitmap Heap Scan on measurement (cost=151740.51..1182320.63 rows=778887 width=24) (actual time=43501.190..184450.377 rows=630830 loops=1)
                           Recheck Cond: (measurement.meas_type_dtl_key = 1003)
                           Filter: (measurement.sensor_station_key = 1)
43438.177 22.64% 
                           -> Bitmap Index Scan on meas_meas_type_dtl_idx (cost=0.0..151545.79 rows=9309408 width=0) (actual time=43438.177..43438.177 rows=8797136 loops=1)
                                 Index Cond: (measurement.meas_type_dtl_key = 1003)