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)