Question

How to get average of CPU stats and load1 Stats Values ( Explained )

hey, I am trying to understand this

For each Droplet, find the stats via Digital Ocean API, such as

calculate the average of the above stats How to can I get the average of these stats values ???


Submit an answer

This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

Sign In or Sign Up to Answer

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Accepted Answer

Hello,

You can calculate the average by summing up the values in the metric field based on the mode that you are after.

The exact syntax would depend on what framework or programming language you are using.

The response that you would get would look something like this:

{
  "status": "success",
  "data": {
    "resultType": "matrix",
    "result": [
      {
        "metric": {
          "host_id": "222651441",
          "mode": "idle"
        },
        "values": [
          [
            1635386880,
            "122901.18"
          ],
          [
            1635387000,
            "123020.92"
          ],
          [
            1635387120,
            "123140.8"
          ]
        ]
      },
...
    ]
  }
}

Under the values array, you have 2 items:

  • The time when the value was recorded in UNIX time
  • The actual value

You can use a JSON parser to parse the information and get all of the values and sum them up based on your exact requirements.

Hope that this helps Best, Bobby