I am trying a Prometheus/PromQL Grafana Dashboard to
InfluxDB/InfluxQL(OSS/1.8). I am facing two major problems regarding this.
1. Lack of Join for different Measurements
I have the following query which in Prometheus which shows packet loss
with the following query
(ifOutDiscards) * ignoring(ifDescr) group_left(ifDescr) ifDescr
{job="$Job", instance="$Device"}
Then I use “Out {{ifDescr}}” as a legend to get ifDescr of each ifIndex in
tooltip. How to achieve this in InfluxQl. So far I am able to this
SELECT mean(“value”) FROM “ifOutDiscards” WHERE (“job” =~ /^Job/ AND
“instance” =~ /^Instance/) AND timeFilter GROUP BY time(__interval),
“ifIndex” fill(linear)
[image: Screenshot from 2020-05-23 20-12-49]
Screenshot from 2020-05-23 20-12-491920×1080 212 KB
<https://aws1.discourse-cdn.com/standard14/uploads/grafana/original/2X/a/a49cc8038b17113aa73493f0bfa1c003f066fe94.png>
[image: Screenshot from 2020-05-23 15-52-09]
Screenshot from 2020-05-23 15-52-091920×1080 212 KB
<https://aws1.discourse-cdn.com/standard14/uploads/grafana/original/2X/4/4ab2d39b2fe9b8cbd112242e8afb15330a54f4c2.png>
1. Lack of “irate” function
I have a scrape interval of 25 minutes ( I plan to reduce it to 15
seconds) so I have the following query
irate(ifOutOctets{job="$Job",instance="$Device",
ifIndex="$IfIndexAth0"}[30m])*8
I converted it to InfluxQL like this, but results are not the same
SELECT non_negative_derivative(mean(“value”), 30m) *8 FROM “ifOutOctets”
WHERE (“job” =~ /^Job/ AND “instance” =~ /^Instance/ AND “ifIndex” =~ /^
IfIndexAth0/) AND timeFilter GROUP BY time(__interval) fill(linear)
Any help is appreciated.
--
You received this message because you are subscribed to the Google Groups
"Prometheus Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/prometheus-users/6c765d1a-d097-4cd5-81e6-e7809297028c%40googlegroups.com.
