Re: [influxdb] Displaying summed rates of counters

2016-08-11 Thread Sean Beckett
This approach should work, and by using the GROUP BY * in the continuous query, all series will be downsampled and can be combined at will later. On Wed, Aug 10, 2016 at 8:10 PM, Aaron Knister wrote: > On 7/27/16 7:47 PM, m...@michalrus.com wrote: > >> Hello! >> >> I’ve got a few counters for di

Re: [influxdb] Displaying summed rates of counters

2016-08-10 Thread Aaron Knister
On 7/27/16 7:47 PM, m...@michalrus.com wrote: Hello! I’ve got a few counters for different iptables rules (collected with collectd). Using Grafana, I can plot rates (bytes/s) for these byte counters like that: SELECT non_negative_derivative(sum("value"), 1s) FROM "iptables_value" WHERE "

[influxdb] Displaying summed rates of counters

2016-07-27 Thread m
Hello! I’ve got a few counters for different iptables rules (collected with collectd). Using Grafana, I can plot rates (bytes/s) for these byte counters like that: SELECT non_negative_derivative(sum("value"), 1s) FROM "iptables_value" WHERE "type" = 'ipt_bytes' AND "type_instance" = "$