gistfile1.txt

EXPLAIN ANALYZE
  SELECT appid, max(time) AS maxtime FROM game_players
    WHERE
      appid != 0 AND time < date_trunc('hour', CURRENT_TIMESTAMP)
    GROUP BY appid;


                                                            QUERY PLAN                                                             
-----------------------------------------------------------------------------------------------------------------------------------
 HashAggregate  (cost=488892.89..488930.88 rows=3799 width=12) (actual time=11097.638..11098.185 rows=3855 loops=1)
   ->  Seq Scan on game_players  (cost=0.00..410984.68 rows=15581643 width=12) (actual time=0.209..7370.670 rows=15581143 loops=1)
         Filter: ((appid <> 0) AND ("time" < date_trunc('hour'::text, now())))
         Rows Removed by Filter: 4461
 Total runtime: 11098.476 ms
(5 rows)