serverplayerstats=# explain analyze select * from rank248stats where playerid=22453;
QUERY PLAN
---------------------------------------------------------------------------------------------------------------------------------------------
Index Scan using rank248stats_pkeyonly on rank248stats (cost=0.00..218.71 rows=54 width=36) (actual time=94.026..1436.544 rows=87 loops=1)
Index Cond: (playerid = 22453)
Total runtime: 1436.799 ms
(3 rows)
serverplayerstats=# explain analyze select * from tmprankstatstest where playerid=22453;
QUERY PLAN
---------------------------------------------------------------------------------------------------------------------------------------------------
Index Scan using tmprankstatstest_pkeyonly on tmprankstatstest (cost=0.00..25.79 rows=947 width=36) (actual time=54.214..62.680 rows=87 loops=1)
Index Cond: (playerid = 22453)
Total runtime: 62.825 ms
(3 rows)