<div dir="ltr">If you are using graphite/grafana you should use perSecond()<div>there are a couple of dashboards available for grafana ...</div><div>write if need help</div><div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, May 5, 2020 at 12:17 PM Winfried Angele via dnsdist <<a href="mailto:dnsdist@mailman.powerdns.com">dnsdist@mailman.powerdns.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Hi Simone,<br>
<br>
> Is there a way to get QPS and/or metrics per seconds? Or I have to <br>
> manipulate data (how?)?<br>
<br>
We use the non-negative-derivative "transformation" in InfluxQL:<br>
<br>
<a href="https://docs.influxdata.com/influxdb/v1.8/query_language/functions/#non-negative-derivative" rel="noreferrer" target="_blank">https://docs.influxdata.com/influxdb/v1.8/query_language/functions/#non-negative-derivative</a><br>
<br>
Something like:<br>
SELECT non_negative_derivative(max("queries"), 1s) FROM "dnsdist" WHERE <br>
$timeFilter GROUP BY time($__interval)<br>
<br>
Winfried<br>
_______________________________________________<br>
dnsdist mailing list<br>
<a href="mailto:dnsdist@mailman.powerdns.com" target="_blank">dnsdist@mailman.powerdns.com</a><br>
<a href="https://mailman.powerdns.com/mailman/listinfo/dnsdist" rel="noreferrer" target="_blank">https://mailman.powerdns.com/mailman/listinfo/dnsdist</a><br>
</blockquote></div>