From: | John R Pierce <pierce(at)hogranch(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Get sum of sums |
Date: | 2016-05-03 20:12:33 |
Message-ID: | aac69407-66c5-a57a-37ed-8a00f8f4e7e3@hogranch.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 5/3/2016 12:48 PM, Steve Clark wrote:
> 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
From | Date | Subject | |
---|---|---|---|
Next Message | drum.lucas@gmail.com | 2016-05-03 21:27:21 | Re: Function PostgreSQL 9.2 |
Previous Message | David G. Johnston | 2016-05-03 20:08:42 | Re: Get sum of sums |