Monitor and analyze with Grafana, influxdb 1.8 and collectd under Ubuntu 22.04 LTS

SCREENSHOT 11) Click on the Explore to make queries to the InfluxDB and to visualize the results.

Explore menu is just for testing purposes of different queries.

main menu
Explore menu

SCREENSHOT 12) The data source collectd is selected and a skeleton of the query is shown.

The white text can be modified by clicking on it Grafana will offer different options and hits. The button “plus” means there could be added more functionalities. To view what can be added, click the button plus “+”.

main menu
Explore page collectd

SCREENSHOT 13) Select the measurement to query.

The dropdown list shows all available ones right now in the database collectd – cpu_value, interface_rx, interface_tx, load_longterm, load_midterm, load_shortterm and memory_value. The collectd daemon started at the (STEP 1) writes data those measurement in the database.

main menu
Explore select measurement

SCREENSHOT 14) Select the measurement cpu_value, which is an increasing number and a graph immediate appears.

main menu
Explore select cpu_value

SCREENSHOT 15) Select the function, which will transform the cpu_value in meaningful value.

The cpu_value is increasing value and the show how many CPU idles it should subtract two consecutive values.

The CPU plugin collects the amount of time spent by the CPU in various states, most notably executing user code, executing system code, waiting for IO-operations and being idle. This since has been an FAQ: The CPU plugin does not collect percentages. It collects “jiffies”, the units of scheduling. On many Linux systems, there are circa 100 jiffies in one second, but this does not mean you will end up with a percentage. More on

More on

main menu
Explore select non_negative_derivative

SCREENSHOT 16) Select the tag, with which to limit the query.

All available tags for this measurement are shown – host, instance, type, and type_instance. In different collectd modules there might be slightly different meanings, but, for example, the host is for the server’s hostname, which gathered the value.

main menu
Explore select tag name

SCREENSHOT 17) Select the hostname of the server to limit the measurement only to this server.

The host tag value is for the hostname. It can accept regular expressions.

main menu
Explore select tag value

SCREENSHOT 18) A proper query for the idle time percentage of the CPU is shown.

Limiting by using WHERE clause with tags host, type and type_instance and tags’ values, cpu, idle in the same order.

main menu
Explore select cpu idle graph

SCREENSHOT 19) All graphs and data usually is organized in dashboards with panels of charts, graphs, tables, counters, and lines of data.

main menu
Dashboards menu

SCREENSHOT 20) Create a new dashboard.

main menu
Dashboards new Dashboard

Leave a Reply

Your email address will not be published. Required fields are marked *