Re: Get sum of sums

I have the following table that has netflow data. I can get the top ten receivers by the query below - but I would also like to get
at the same time a grand total of the RX Bytes. I am not exactly sure how to do it. This is with version 8.4.

select ip_dst as "Receiver" ,sum(bytes) as "RX Bytes" from acct_v9 where stamp_inserted >= '2016-04-26' and stamp_inserted <= '2016-04-30' and tag=246 group by ip_dst  order by "RX Bytes" desc limit 10;
    Receiver    |  RX Bytes  
----------------+-------------
 172.24.110.93  | 40363536915
 172.24.110.81  |  6496041533
 172.24.110.123 |  4891514009
 172.24.16.10   |  4540333516
 172.24.110.151 |  4101253631
 192.168.198.71 |  3303066724
 172.24.110.121 |  2529532947
 172.24.110.101 |  2506527294
 172.21.64.99   |  2472842640
 172.24.110.83  |  2232550271

a single query can only return a set of rows with the same fields.     your grand total of RX Bytes is a scalar value.   I mean, I *suppose* you could generate it as an additional query with a union, something like this...

select ip_dst as "Receiver" ,sum(bytes) as "RX Bytes" from acct_v9     where stamp_inserted >= '2016-04-26' and stamp_inserted <=     '2016-04-30' and tag=246 group by ip_dst  order by "RX Bytes" desc     limit 10

union

select 'Total' as "Reciever", sum(bytes) as "RX Bytes" from acct_v9 where stamp_inserted >= '2016-04-26' and stamp_inserted <=     '2016-04-30' and tag=246;

-- 
john r pierce, recycling bits in santa cruz