InfluxDB1.8 Grafana9.1
Hello
from opnSense i got
bytes send and recv
packets send and resv
are both cumulative.
So what magic have to be done to get a value to see the used bandwith
have a nice day
vinc
Please provide sample influxdb data for example
_field,_value,_time
send,4.5,2022-08-22 13:00:00
recv,14.5,2022-08-22 13:00:00
We don’t have remote access to your influxdb so proving us sample data helps us help you.
We can have your data in our our influxdb
Otherwise it will just be guess work and back and forth
hope so is OK, Interface igb0 would be my WAN Port to calculate
> select * from net limit 20
name: net
time bytes_recv bytes_sent drop_in drop_out err_in err_out interface packets_recv packets_sent
---- ---------- ---------- ------- -------- ------ ------- --------- ------------ ------------
1660984200000000000 31240214 2787387 0 0 0 0 igb0 27109 26840
1660984200000000000 0 0 0 0 0 0 ovpns1 0 0
1660984200000000000 1063839 1569696 0 0 0 0 igb1 4113 4712
1660984200000000000 0 0 0 0 0 0 igb2_vlan1002 0 0
1660984200000000000 0 0 0 0 0 0 igb2_vlan1027 0 0
1660984200000000000 134611 214562 0 0 0 1 igb2_vlan1042 1165 945
1660984200000000000 131 42 0 0 0 1 igb2_vlan1014 1 1
1660984200000000000 776607 5043977 0 0 0 0 igb2 6792 4254
1660984200000000000 16738 45152 0 0 0 1 igb2_vlan1015 143 561
1660984200000000000 0 0 0 0 0 0 igb2_vlan1024 0 0
1660984210000000000 17104 45518 0 0 0 1 igb2_vlan1015 148 568
1660984210000000000 0 0 0 0 0 0 igb2_vlan1024 0 0
1660984210000000000 0 0 0 0 0 0 igb2_vlan1027 0 0
1660984210000000000 1105783 1644298 0 0 0 0 igb1 4410 4962
1660984210000000000 31268731 2825689 0 0 0 0 igb0 27307 27072
1660984210000000000 0 0 0 0 0 0 ovpns1 0 0
1660984210000000000 0 0 0 0 0 0 igb2_vlan1002 0 0
1660984210000000000 880604 5113232 0 0 0 0 igb2 7450 4556
1660984210000000000 139913 221002 0 0 0 1 igb2_vlan1042 1213 988
1660984210000000000 21332 8207 0 0 0 1 igb2_vlan1014 32 32
1 Like
So your question is tagged under influx db but I see a select statement that looks like mysql. Are you using flux ql?
Also please post back proper csv either comma delimited or tab delimited.
What you posted is not delimited.
sorry don’t know how to do this ;-(
with comma added. Please answer the other questions
time,bytes_recv,bytes_sent,drop_in,drop_out,err_in,err_out,interface,packets_recv,packets_sent
1660984200000000000,31240214 ,2787387 , 0 , 0 , 0 , 0 , igb0 , 27109 , 26840
The data is in influxdb
But are you using flux query language or influxql to query the data.
2 different query languages.
in Grafana is the DataSource
and
queryLanguage
InfluxQL
1 Like
so for the following igb0 interface data
time,bytes_recv,bytes_sent,packets_recv,packets_sent
1660984210000000000,3126873,2825689,27307, 27072
1660984200000000000,31240214,2787387,27109, 26840
what should the final result look like?
the problem the number is cumulative, so i don’t get the bandwith used
I am confused, sorry
Hello sorry not so easy in english
time, bytes_recv, bytes_sent, drop_in, drop_out, err_in, err_out, interface, packets_recv, packets_sent,
1660984200000000000, 31240214, 2787387, 0, 0, 0, 0, igb0, 27109, 26840,
1660984210000000000, 31268731, 2825689, 0, 0, 0, 0, igb0, 27307, 27072,
so from the Interface igb0 take as example bytes_recv the fist is newer, so the second number - first number would be the difference = the bytes_recv in the time difference diveded by this difference i would have the bytes_recv/s
the same then for bytes_sent packets_recv packets_sent
and then also for other Interface but this would basicly allway be the same
still confusing.
please show using expected result as inline csv
interface, expected
igb0,89789.00
data is not limited to English or French or whatever
zeigen Sie uns anhand von Beispieldaten
montrez-nous en utilisant des exemples de données
mostraci usando dati di esempio
This helped to solve the problem
1 Like