select count(*) as rows,sum(ext_key::bigint) as sum_ext_key, sum(use_src) as sum_use_src,sum(dup_src) as sum_dup_src, sum(pts_key::bigint) as sum_pts_key from twomass_xsc; rows | sum_ext_key | sum_use_src | sum_dup_src | sum_pts_key ---------+---------------+-------------+-------------+----------------- 1647599 | 2146404951676 | 1587504 | 196537 | 992540387061069