This is a simple statement that i run
core_netfon=# EXPLAIN select spcode,count(*) from callticket group by spcode;
QUERY PLAN
---------------------------------------------------------------------------------------
Aggregate (cost=2057275.91..2130712.22 rows=979151 width=4)
-> Group (cost=2057275.91..2106233.45 rows=9791508 width=4)
-> Sort (cost=2057275.91..2081754.68 rows=9791508 width=4)
Sort Key: spcode
-> Seq Scan on callticket (cost=0.00..424310.08 rows=9791508
width=4)
(5 rows)
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
