Miscellany

serverplayerstats=# explain analyze select * from day248stats where playerid=776
serverplayerstats-# ;
                                                                 QUERY PLAN                                                                 
--------------------------------------------------------------------------------------------------------------------------------------------
 Bitmap Heap Scan on day248stats  (cost=18.30..9123.75 rows=2657 width=130) (actual time=60.460..8677.122 rows=3139 loops=1)
   Recheck Cond: (playerid = 776)
   ->  Bitmap Index Scan on day248stats_playerid_index  (cost=0.00..18.30 rows=2657 width=0) (actual time=49.474..49.474 rows=3139 loops=1)
         Index Cond: (playerid = 776)
 Total runtime: 8682.796 ms
(5 rows)

serverplayerstats=# explain analyze select * from tmpday248stats where playerid=776;
                                                                     QUERY PLAN                                                                     
----------------------------------------------------------------------------------------------------------------------------------------------------
 Index Scan using day248stats2_playerid_index on tmpday248stats  (cost=0.00..6.67 rows=124 width=130) (actual time=5.971..12.614 rows=3139 loops=1)
   Index Cond: (playerid = 776)
 Total runtime: 16.965 ms
(3 rows)