gistfile1.txt

  Log Load (9515.7ms)  SELECT "logs".* FROM "logs" WHERE "logs"."id" IN (SELECT MAX(id) FROM "logs" GROUP BY sensor_id)
  EXPLAIN (2.5ms)  EXPLAIN SELECT "logs".* FROM "logs" WHERE "logs"."id" IN (SELECT MAX(id) FROM "logs" GROUP BY sensor_id)
EXPLAIN for: SELECT "logs".* FROM "logs"  WHERE "logs"."id" IN (SELECT MAX(id) FROM "logs"  GROUP BY sensor_id)
                                       QUERY PLAN
-----------------------------------------------------------------------------------------
 Nested Loop  (cost=705950.15..707475.66 rows=180 width=53)
   ->  HashAggregate  (cost=705949.71..705951.51 rows=180 width=4)
         Group Key: max(logs_1.id)
         ->  HashAggregate  (cost=705945.66..705947.46 rows=180 width=8)
               Group Key: logs_1.sensor_id
               ->  Seq Scan on logs logs_1  (cost=0.00..568768.44 rows=27435444 width=8)
   ->  Index Scan using logs_pkey on logs  (cost=0.44..8.46 rows=1 width=53)
         Index Cond: (id = (max(logs_1.id)))
(8 rows)