Value are cumulativ problem how to solve

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

@vikozo

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

it is a influxdb 1.8

influx

use databank
the call up with
then the select command

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