Hash Join  (cost=28646.01..274260.15 rows=555706 width=24) (actual time=102323.087..102323.196 rows=5 loops=1)
   Hash Cond: ("outer".template_id = "inner".id)
   ->  Merge Join  (cost=28644.09..265922.62 rows=555706 width=24) (actual time=102322.632..102322.709 rows=5 loops=1)
         Merge Cond: ("outer".data_id = "inner".id)
         ->  Index Scan using idx_dv_data_id on data_values  (cost=0.00..205034.19 rows=9580032 width=16) (actual time=17.503..86263.130 
rows=9596747 loops=1)
         ->  Sort  (cost=28644.09..28870.83 rows=90697 width=16) (actual time=0.829..0.835 rows=1 loops=1)
               Sort Key: data.id
               ->  Index Scan using idx_d_entered on data  (cost=0.00..20202.81 rows=90697 width=16) (actual time=0.146..0.185 rows=1 loops=1)
                     Index Cond: (((('now'::text)::timestamp(6) with time zone)::timestamp without time zone - '00:01:00'::interval) < entered)
                     Filter: ((machine_id = 2) OR (machine_id = 3))
   ->  Hash  (cost=1.74..1.74 rows=74 width=8) (actual time=0.382..0.382 rows=0 loops=1)
         ->  Seq Scan on datatemplate_intervals  (cost=0.00..1.74 rows=74 width=8) (actual time=0.024..0.250 rows=74 loops=1)
 Total runtime: 102323.491 ms
(13 rows)