Navigation

    Netgate Discussion Forum
    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Search

    Telegraf bytes_recv seems to be cumulative?

    Traffic Monitoring
    2
    4
    489
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • R
      RedBeardCowboy last edited by

      So I'm running TICK stack and using Chronograf to chart stats, and I'm a little confused by the data. This could perhaps be me not being a SQL guru, but seems that the values the telegraf package are sending are cumulative for bytes_recv / sent under the net stats?

      alt text

      1 Reply Last reply Reply Quote 0
      • R
        RedBeardCowboy last edited by

        OK... upon a few hours and googles.... I came across this:

        https://www.homelabrat.com/pfsense-dashboard/

        Where in DERIVATIVE() is mentioned

        Which lead me to this query which seems to be right:

        SELECT DERIVATIVE("bytes_recv",1s) FROM "firewall"."autogen"."net" WHERE time > :dashboardTime: AND "interface"='igb0'
        

        Like mentioned in my op ... I'm not a SQL guru. Now I've just got to figure how to structure both "bytes_recv" and "bytes_sent" into one graph.

        For further reference:
        InfluxQL Functions

        1 Reply Last reply Reply Quote 0
        • R
          RedBeardCowboy last edited by RedBeardCowboy

          OK, after further investigation the numbers it shows are incorrect... add a *8:

          SELECT DERIVATIVE("bytes_recv",1s)*8 FROM "firewall"."autogen"."net" WHERE time > :dashboardTime: AND "interface"='igb0'
          

          For Mbps that is... unless you're one of those weirdos that does MBps

          D 1 Reply Last reply Reply Quote 1
          • D
            DePingus @RedBeardCowboy last edited by

            @RedBeardCowboy Thanks for taking the time to answer your own question. This is exactly what I was looking for today!

            1 Reply Last reply Reply Quote 0
            • First post
              Last post