How to reduce mqtt data from shelly 3em with the help of "Final Aggregrator Plugin"

Telegraf
1

Hello to all

I use a shelly 3em for showing me the actual 3 phase power in use.
The shelly sends mqtt data almost every second to the [[inputs.mqtt_consumer]] in telegraf.
This gives a unessesary huge amount of influxdb data.

Now i would like to reduce this data with the help of the telegraf.conf file.
Where do i have to place the “Final Aggregrator Plugin” lines in my telegraf.conf file???
I have several topics to read from, but i would like to alter the behaviour only from the shelly 3em topic.

Is there a example telegraf.conf file with this plugin lines?

Many thanks
Toni

my telegraf.conf

[global_tags]

[agent]

interval = “10s”

round_interval = true

metric_batch_size = 1000

metric_buffer_limit = 10000

collection_jitter = “0s”

flush_interval = “10s”

flush_jitter = “0s”

precision = “”

#===================================================================================
#output configuration
#database “PV_data”

#measurement “grid” >>> Bezug / Einspeisung vom Shelly 3 EM

[[outputs.influxdb]]
urls = [“http://raspberrypi:8086”]
database = “PV_data”
name_override = “grid”
[outputs.influxdb.tagpass]
topic=[“shellies/em3/emeter/0/power”,“shellies/em3/emeter/1/power”,“shellies/em3/emeter/2/power”]

#measurement “w_garten” >>> Wintergarten

[[outputs.influxdb]]
urls = [“http://raspberrypi:8086”]
database = “PV_data”
name_override = “w_garten”
[outputs.influxdb.tagpass]
topic=[“tele/solar/SENSOR”]

#measurement “stall” für >>> Stall
[[outputs.influxdb]]
urls = [“http://raspberrypi:8086”]
database = “PV_data”
name_override = “stall”
[outputs.influxdb.tagpass]
topic=[“tele/Sonoff_PV001/SENSOR”]

#measurement “stall2” für >>> Stall2
[[outputs.influxdb]]
urls = [“http://raspberrypi:8086”]
database = “PV_data”
name_override = “stall2”
[outputs.influxdb.tagpass]
topic=[“tele/solar2/SENSOR”]

#Read metrics from MQTT topic(s)

[[inputs.mqtt_consumer]]
servers = [“tcp://raspberrypi:1883”]
topics = [“tele/solar/SENSOR”,“tele/Sonoff_PV001/SENSOR”,“tele/solar2/SENSOR”]
#unnötige Messwerte werden nicht in der Datenbank aufgezeichnet -----------3.2.21 TG
fielddrop = [“ENERGY_ApparentPower”,“_Factor","_Period”,“*_ReactivePower”]
data_format = “json”

#topic vom Shelly 3EM System zeigt, ob Einspeisung oder Netzbezug erfolgt
[[inputs.mqtt_consumer]]
servers = [“tcp://raspberrypi:1883”]
topics = [“shellies/em3/emeter/0/power”,“shellies/em3/emeter/1/power”,“shellies/em3/emeter/2/power”]
data_format = “value”
data_type = “float”

2

You place individual plugins above or below other plugins, the general position does not impact what metrics are sent to the plugin.

What you want to look at is the metric selectors for only sending your 3em topic metrics to the aggregator. Either via the namepass option if those metrics all have the same name or the tagpass option if those have a common tag you can use.

3

Hello jpowers

Thanks for your answer and recommendations.

In the meantime i added my telegraf.conf file for reference.

Now following your recommendation, i could try the following to add the “shellies*” metrics only every 30 seconds ??
Is that correct ??

[[aggregators.final]]
namepass = [“shellies*”]
period = “30s”

Best regards
Toni

4

You will also want to set drop_original = true, so that the original data is not also passed on. And set output_strategy = "periodic" so that you actually send data every 30 seconds.

5

Many thanks for your help!
I added the following lines to the end of my telegraf.conf file :

[[aggregators.final]]
namepass = [“shellies*”]
period = “30s”
drop_original = true
output_strategy = “periodic”

But unfortunately there is no more metrics written to the influx database now …
What i am doing wrong?

Many thanks

6

Please also enable debug mode via --debug via the CLI or debug = true in the agent config as well as also add [[outputs.file]] and provide the logs from that please.

namepass = [“shellies*”]

You are certain that this is the name of your metrics?

7

… not really sure, sorry
… as you can see in my telegraf.conf file this is the “topic” of the shelly 3em …
… not there name too possible???

8

Please grab the logs, but know that usually the metric name is mqtt_consumer unless you set it to be something.

9

Many thanks for your help …

pi@raspberrypi:/etc/telegraf $ telegraf --config telegraf.conf --once
2024-03-07T17:39:23Z I! Starting Telegraf 1.16.2
2024-03-07T17:39:23Z E! [telegraf] Error running agent: Error loading config file telegraf.conf: Error parsing data: line 93: invalid TOML syntax

Above is the debug output with following lines in telegraf.conf (now name changed to grid)

[[aggregators.final]]
namepass = [“grid”]
period = “30s”
drop_original = true
output_strategy = “periodic”

10

This version is many years old and I highly suggest you update to avoid any known issues.

[telegraf] Error running agent: Error loading config file telegraf.conf: Error parsing data: line 93: invalid TOML syntax

Something you added in and around that line is not right.

11

… the problem must be in these lines of code …

But first i do update telegraf.

Best regards and thanks

12

Make sure you are using “real quotes” and note the quotes from this forum. it should be the " charachter.

13

Good morning
that was the cause, i just copied it from here … but still not working => “output_strategy” not working

pi@raspberrypi:/etc/telegraf $ telegraf --config telegraf.conf --once
2024-03-08T08:16:42Z I! Starting Telegraf 1.16.2
2024-03-08T08:16:42Z E! [telegraf] Error running agent: Error loading config file telegraf.conf: Error parsing final, line 95: field corresponding to `output_strategy’ is not defined in final.Final
pi@raspberrypi:/etc/telegraf $

i am struggeling with updating telegraf on my raspberry pi …
what is best to do, and with which commands ??

Best regards
Toni

14

This is because you are on an old version.

15

Hello jpowers

Excactly, this was the problem with v 1.16.2 …
In the meantime i managed with the help of this wonderful community to update my raspi to v 1.29.5

pi@raspberrypi:/etc/telegraf $ telegraf
2024-03-08T14:45:54Z I! Loading config: /etc/telegraf/telegraf.conf
2024-03-08T14:45:54Z W! DeprecationWarning: Option “fielddrop” of plugin “inputs.mqtt_consumer” deprecated since version 1.29.0 and will be removed in 2.0.0: use ‘fieldexclude’ instead
2024-03-08T14:45:54Z I! Starting Telegraf 1.29.5 brought to you by InfluxData the makers of InfluxDB
2024-03-08T14:45:54Z I! Available plugins: 241 inputs, 9 aggregators, 30 processors, 24 parsers, 60 outputs, 6 secret-stores
2024-03-08T14:45:54Z I! Loaded inputs: mqtt_consumer (2x)
2024-03-08T14:45:54Z I! Loaded aggregators: final
2024-03-08T14:45:54Z I! Loaded processors:
2024-03-08T14:45:54Z I! Loaded secretstores:
2024-03-08T14:45:54Z I! Loaded outputs: influxdb (4x)
2024-03-08T14:45:54Z I! Tags enabled: host=raspberrypi
2024-03-08T14:45:54Z I! [agent] Config: Interval:10s, Quiet:false, Hostname:“raspberrypi”, Flush Interval:10s
2024-03-08T14:45:54Z D! [agent] Initializing plugins
2024-03-08T14:45:54Z D! [agent] Connecting outputs
2024-03-08T14:45:54Z D! [agent] Attempting connection to [outputs.influxdb]
2024-03-08T14:45:54Z D! [agent] Successfully connected to outputs.influxdb
2024-03-08T14:45:54Z D! [agent] Attempting connection to [outputs.influxdb]
2024-03-08T14:45:54Z D! [agent] Successfully connected to outputs.influxdb
2024-03-08T14:45:54Z D! [agent] Attempting connection to [outputs.influxdb]
2024-03-08T14:45:54Z D! [agent] Successfully connected to outputs.influxdb
2024-03-08T14:45:54Z D! [agent] Attempting connection to [outputs.influxdb]
2024-03-08T14:45:54Z D! [agent] Successfully connected to outputs.influxdb
2024-03-08T14:45:54Z D! [agent] Starting service inputs
2024-03-08T14:45:54Z I! [inputs.mqtt_consumer] Connected [tcp://raspberrypi:1883]
2024-03-08T14:45:54Z I! [inputs.mqtt_consumer] Connected [tcp://raspberrypi:1883]
2024-03-08T14:45:54Z D! [aggregators.final] Updated aggregation range [2024-03-08 15:45:30 +0100 CET, 2024-03-08 15:46:00 +0100 CET]
2024-03-08T14:46:00Z D! [aggregators.final] Updated aggregation range [2024-03-08 15:46:00 +0100 CET, 2024-03-08 15:46:30 +0100 CET]

… but the data amount written to the influxdb is somehow still not reduced with the help of the “Final Aggregrator Plugin” …

[[aggregators.final]]
namepass = [“grid”]
period = “30s”
drop_original = true
output_strategy = “periodic”

=> data fed to influxdb not in 30s interval …

select * from grid order by time desc Limit 20
name: grid
time host topic value

2024-03-08T15:03:04.545380447Z raspberrypi shellies/em3/emeter/2/power -359.32
2024-03-08T15:03:04.544654151Z raspberrypi shellies/em3/emeter/1/power -233.12
2024-03-08T15:03:04.54431332Z raspberrypi shellies/em3/emeter/0/power 831.92
2024-03-08T15:03:02.548274333Z raspberrypi shellies/em3/emeter/2/power -359.94
2024-03-08T15:03:02.54806121Z raspberrypi shellies/em3/emeter/1/power -205.65
2024-03-08T15:03:02.547858243Z raspberrypi shellies/em3/emeter/0/power 804.63
2024-03-08T15:03:00.600662853Z raspberrypi shellies/em3/emeter/2/power -362.29
2024-03-08T15:03:00.600141503Z raspberrypi shellies/em3/emeter/1/power -208.98
2024-03-08T15:03:00.599774423Z raspberrypi shellies/em3/emeter/0/power 800.54
2024-03-08T15:02:59.546447038Z raspberrypi shellies/em3/emeter/2/power -361.99
2024-03-08T15:02:59.546217405Z raspberrypi shellies/em3/emeter/1/power -234.14
2024-03-08T15:02:59.546099645Z raspberrypi shellies/em3/emeter/0/power 822.93
2024-03-08T15:02:57.549852431Z raspberrypi shellies/em3/emeter/2/power -365.08
2024-03-08T15:02:57.549513059Z raspberrypi shellies/em3/emeter/1/power -235.63
2024-03-08T15:02:57.548883793Z raspberrypi shellies/em3/emeter/0/power 803.32
2024-03-08T15:02:55.549576084Z raspberrypi shellies/em3/emeter/2/power -369.31
2024-03-08T15:02:55.549044265Z raspberrypi shellies/em3/emeter/1/power -193.98
2024-03-08T15:02:55.548617863Z raspberrypi shellies/em3/emeter/0/power 773.48
2024-03-08T15:02:54.719818734Z raspberrypi shellies/em3/emeter/2/power -372.37
2024-03-08T15:02:54.719338946Z raspberrypi shellies/em3/emeter/1/power -203.87

16

Please add the outputs.file output and show me the actual metrics please.

17

Sorry so much, i do not understand what i have to deliver.

@ outputs.file how can i set up to receive one
@ metrics above are the data (metrics??) from the shelly 3em in 2 or 3 sec interval

18

Literally add [[outputs.file]] to your configuration file and restart telegraf. Then look at the output and you will find metrics printed to stdout or to your log file. Please copy those metrics into here so I can see what metrics you are trying to aggregate.

19

To demonstrate how this should all work, given this config:

[agent]
  debug = true
  omit_hostname = true

[[outputs.file]]

[[inputs.mem]]

[[aggregators.final]]
	period = "30s"
	drop_original = true
	output_strategy = "periodic"

It will produce a single metric at the end of every 30 second interval rather than every 10 seconds:

./telegraf --config config.toml
2024-03-08T15:20:59Z I! Loading config: config.toml
2024-03-08T15:20:59Z I! Starting Telegraf 1.30.0-4664b6d0 brought to you by InfluxData the makers of InfluxDB
2024-03-08T15:20:59Z I! Available plugins: 233 inputs, 9 aggregators, 31 processors, 24 parsers, 60 outputs, 6 secret-stores
2024-03-08T15:20:59Z I! Loaded inputs: mem
2024-03-08T15:20:59Z I! Loaded aggregators: final
2024-03-08T15:20:59Z I! Loaded processors: 
2024-03-08T15:20:59Z I! Loaded secretstores: 
2024-03-08T15:20:59Z I! Loaded outputs: file
2024-03-08T15:20:59Z I! Tags enabled: 
2024-03-08T15:20:59Z I! [agent] Config: Interval:10s, Quiet:false, Hostname:"", Flush Interval:10s
2024-03-08T15:20:59Z D! [agent] Initializing plugins
2024-03-08T15:20:59Z D! [agent] Connecting outputs
2024-03-08T15:20:59Z D! [agent] Attempting connection to [outputs.file]
2024-03-08T15:20:59Z D! [agent] Successfully connected to outputs.file
2024-03-08T15:20:59Z D! [agent] Starting service inputs
2024-03-08T15:20:59Z D! [aggregators.final] Updated aggregation range [2024-03-08 08:20:30 -0700 MST, 2024-03-08 08:21:00 -0700 MST]
2024-03-08T15:21:00Z D! [aggregators.final] Updated aggregation range [2024-03-08 08:21:00 -0700 MST, 2024-03-08 08:21:30 -0700 MST]
2024-03-08T15:21:09Z D! [outputs.file] Buffer fullness: 0 / 10000 metrics
2024-03-08T15:21:19Z D! [outputs.file] Buffer fullness: 0 / 10000 metrics
2024-03-08T15:21:29Z D! [outputs.file] Buffer fullness: 0 / 10000 metrics
2024-03-08T15:21:30Z D! [aggregators.final] Updated aggregation range [2024-03-08 08:21:30 -0700 MST, 2024-03-08 08:22:00 -0700 MST]
mem free_final=49458913280i,sreclaimable_final=508706816i,swap_cached_final=0i,page_tables_final=73289728i,vmalloc_chunk_final=0i,low_free_final=0i,high_total_final=0i,huge_page_size_final=2097152i,sunreclaim_final=321601536i,huge_pages_total_final=0i,used_final=6670442496i,available_percent_final=88.15701396849296,slab_final=830308352i,cached_final=11200860160i,write_back_tmp_final=0i,vmalloc_total_final=35184372087808i,inactive_final=7501287424i,buffered_final=3911680i,shared_final=561147904i,write_back_final=0i,committed_as_final=21085368320i,total_final=67334127616i,available_final=59359756288i,low_total_final=0i,vmalloc_used_final=203513856i,commit_limit_final=37962027008i,used_percent_final=9.906480906741507,huge_pages_free_final=0i,swap_total_final=4294963200i,active_final=8913530880i,mapped_final=1918980096i,swap_free_final=4294963200i,dirty_final=31043584i,high_free_final=0i 1709911280000000000
2024-03-08T15:21:39Z D! [outputs.file] Wrote batch of 1 metrics in 61.151µs
2024-03-08T15:21:39Z D! [outputs.file] Buffer fullness: 0 / 10000 metrics
2024-03-08T15:21:49Z D! [outputs.file] Buffer fullness: 0 / 10000 metrics
2024-03-08T15:21:59Z D! [outputs.file] Buffer fullness: 0 / 10000 metrics
2024-03-08T15:22:00Z D! [aggregators.final] Updated aggregation range [2024-03-08 08:22:00 -0700 MST, 2024-03-08 08:22:30 -0700 MST]
mem shared_final=563539968i,huge_pages_free_final=0i,committed_as_final=21077307392i,used_percent_final=9.811432523008095,active_final=8877740032i,inactive_final=7513112576i,mapped_final=1918951424i,swap_cached_final=0i,high_free_final=0i,high_total_final=0i,slab_final=830435328i,free_final=49508646912i,huge_page_size_final=2097152i,used_final=6606442496i,huge_pages_total_final=0i,cached_final=11215126528i,commit_limit_final=37962027008i,write_back_tmp_final=0i,write_back_final=421888i,vmalloc_chunk_final=0i,low_total_final=0i,dirty_final=29069312i,low_free_final=0i,available_final=59421356032i,sunreclaim_final=321687552i,sreclaimable_final=508747776i,vmalloc_used_final=203595776i,swap_free_final=4294963200i,total_final=67334127616i,buffered_final=3911680i,page_tables_final=73310208i,swap_total_final=4294963200i,vmalloc_total_final=35184372087808i,available_percent_final=88.24849765764284 1709911310000000000
2024-03-08T15:22:09Z D! [outputs.file] Wrote batch of 1 metrics in 37.99µs
2024-03-08T15:22:09Z D! [outputs.file] Buffer fullness: 0 / 10000 metrics
2024-03-08T15:22:19Z D! [outputs.file] Buffer fullness: 0 / 10000 metrics
20

Many thanks indeed

Does this help

pi@raspberrypi:~ $ telegraf
2024-03-08T15:21:42Z I! Loading config: /etc/telegraf/telegraf.conf
2024-03-08T15:21:42Z W! DeprecationWarning: Option “fielddrop” of plugin “inputs.mqtt_consumer” deprecated since version 1.29.0 and will be removed in 2.0.0: use ‘fieldexclude’ instead
2024-03-08T15:21:42Z I! Starting Telegraf 1.29.5 brought to you by InfluxData the makers of InfluxDB
2024-03-08T15:21:42Z I! Available plugins: 241 inputs, 9 aggregators, 30 processors, 24 parsers, 60 outputs, 6 secret-stores
2024-03-08T15:21:42Z I! Loaded inputs: mqtt_consumer (2x)
2024-03-08T15:21:42Z I! Loaded aggregators: final
2024-03-08T15:21:42Z I! Loaded processors:
2024-03-08T15:21:42Z I! Loaded secretstores:
2024-03-08T15:21:42Z I! Loaded outputs: file influxdb (4x)
2024-03-08T15:21:42Z I! Tags enabled: host=raspberrypi
2024-03-08T15:21:42Z I! [agent] Config: Interval:10s, Quiet:false, Hostname:“raspberrypi”, Flush Interval:10s
2024-03-08T15:21:42Z D! [agent] Initializing plugins
2024-03-08T15:21:42Z D! [agent] Connecting outputs
2024-03-08T15:21:42Z D! [agent] Attempting connection to [outputs.file]
2024-03-08T15:21:42Z D! [agent] Successfully connected to outputs.file
2024-03-08T15:21:42Z D! [agent] Attempting connection to [outputs.influxdb]
2024-03-08T15:21:42Z D! [agent] Successfully connected to outputs.influxdb
2024-03-08T15:21:42Z D! [agent] Attempting connection to [outputs.influxdb]
2024-03-08T15:21:42Z D! [agent] Successfully connected to outputs.influxdb
2024-03-08T15:21:42Z D! [agent] Attempting connection to [outputs.influxdb]
2024-03-08T15:21:42Z D! [agent] Successfully connected to outputs.influxdb
2024-03-08T15:21:42Z D! [agent] Attempting connection to [outputs.influxdb]
2024-03-08T15:21:42Z D! [agent] Successfully connected to outputs.influxdb
2024-03-08T15:21:42Z D! [agent] Starting service inputs
2024-03-08T15:21:42Z I! [inputs.mqtt_consumer] Connected [tcp://raspberrypi:1883]
2024-03-08T15:21:42Z I! [inputs.mqtt_consumer] Connected [tcp://raspberrypi:1883]
2024-03-08T15:21:42Z D! [aggregators.final] Updated aggregation range [2024-03-08 16:21:30 +0100 CET, 2024-03-08 16:22:00 +0100 CET]
2024-03-08T15:21:52Z D! [outputs.influxdb] Buffer fullness: 0 / 10000 metrics
2024-03-08T15:21:52Z D! [outputs.influxdb] Buffer fullness: 0 / 10000 metrics
2024-03-08T15:21:52Z D! [outputs.influxdb] Buffer fullness: 0 / 10000 metrics
mqtt_consumer,host=raspberrypi,topic=shellies/em3/emeter/0/power value=-29.75 1709911303244199797
mqtt_consumer,host=raspberrypi,topic=shellies/em3/emeter/1/power value=-117.48 1709911303244552714
mqtt_consumer,host=raspberrypi,topic=shellies/em3/emeter/2/power value=-137.6 1709911303245359433
mqtt_consumer,host=raspberrypi,topic=shellies/em3/emeter/0/power value=-25.39 1709911304245891151
mqtt_consumer,host=raspberrypi,topic=shellies/em3/emeter/1/power value=-116.21 1709911304246129120
mqtt_consumer,host=raspberrypi,topic=shellies/em3/emeter/2/power value=-136.1 1709911304247249276
mqtt_consumer,host=raspberrypi,topic=shellies/em3/emeter/0/power value=-27.57 1709911305251144015
mqtt_consumer,host=raspberrypi,topic=shellies/em3/emeter/1/power value=-110.38 1709911305251241932
mqtt_consumer,host=raspberrypi,topic=shellies/em3/emeter/2/power value=-138.61 1709911305251341776
mqtt_consumer,host=raspberrypi,topic=shellies/em3/emeter/0/power value=-27.31 1709911306246520630
mqtt_consumer,host=raspberrypi,topic=shellies/em3/emeter/1/power value=-122.88 1709911306246773338
mqtt_consumer,host=raspberrypi,topic=shellies/em3/emeter/2/power value=-140.56 1709911306247151828
mqtt_consumer,host=raspberrypi,topic=shellies/em3/emeter/0/power value=-27.31 1709911306788898807
mqtt_consumer,host=raspberrypi,topic=shellies/em3/emeter/1/power value=-122.88 1709911306788992400
mqtt_consumer,host=raspberrypi,topic=shellies/em3/emeter/2/power value=-140.56 1709911306789182973
mqtt_consumer,host=raspberrypi,topic=shellies/em3/emeter/0/power value=-30.15 1709911307246474431
mqtt_consumer,host=raspberrypi,topic=shellies/em3/emeter/1/power value=-124.42 1709911307246833650
mqtt_consumer,host=raspberrypi,topic=shellies/em3/emeter/2/power value=-140.96 1709911307247632192
mqtt_consumer,host=raspberrypi,topic=shellies/em3/emeter/0/power value=-34.06 1709911308247263181
mqtt_consumer,host=raspberrypi,topic=shellies/em3/emeter/1/power value=-129.09 1709911308247645837
mqtt_consumer,host=raspberrypi,topic=shellies/em3/emeter/2/power value=-145.22 1709911308247775681
mqtt_consumer,host=raspberrypi,topic=shellies/em3/emeter/0/power value=-36.19 1709911309249791931
mqtt_consumer,host=raspberrypi,topic=shellies/em3/emeter/1/power value=-102.23 1709911309250006462
mqtt_consumer,host=raspberrypi,topic=shellies/em3/emeter/2/power value=-145.2 1709911309250769639
mqtt_consumer,host=raspberrypi,topic=shellies/em3/emeter/0/power value=-31.51 1709911310252208857
mqtt_consumer,host=raspberrypi,topic=shellies/em3/emeter/1/power value=-131.51 1709911310253359222
mqtt_consumer,host=raspberrypi,topic=shellies/em3/emeter/2/power value=-145.9 1709911310254265003
mqtt_consumer,host=raspberrypi,topic=shellies/em3/emeter/0/power value=-34.18 1709911311313831565
mqtt_consumer,host=raspberrypi,topic=shellies/em3/emeter/1/power value=-128.51 1709911311315995784
mqtt_consumer,host=raspberrypi,topic=shellies/em3/emeter/2/power value=-145.7 1709911311316113284
2024-03-08T15:21:52Z D! [outputs.file] Wrote batch of 30 metrics in 2.611823ms
2024-03-08T15:21:52Z D! [outputs.file] Buffer fullness: 0 / 10000 metrics
2024-03-08T15:21:52Z D! [outputs.influxdb] Wrote batch of 30 metrics in 22.329636ms
2024-03-08T15:21:52Z D! [outputs.influxdb] Buffer fullness: 0 / 10000 metrics
2024-03-08T15:22:00Z D! [aggregators.final] Updated aggregation range [2024-03-08 16:22:00 +0100 CET, 2024-03-08 16:22:30 +0100 CET]
2024-03-08T15:22:02Z D! [outputs.influxdb] Buffer fullness: 0 / 10000 metrics
2024-03-08T15:22:02Z D! [outputs.influxdb] Buffer fullness: 0 / 10000 metrics
mqtt_consumer,host=raspberrypi,topic=shellies/em3/emeter/0/power value=-38.4 1709911313250414481
mqtt_consumer,host=raspberrypi,topic=shellies/em3/emeter/1/power value=-130.17 1709911313250590992
mqtt_consumer,host=raspberrypi,topic=shellies/em3/emeter/2/power value=-150.58 1709911313251255679
mqtt_consumer,host=raspberrypi,topic=shellies/em3/emeter/0/power value=-41.83 1709911314252745575
mqtt_consumer,host=raspberrypi,topic=shellies/em3/emeter/1/power value=-139.27 1709911314252826356
mqtt_consumer,host=raspberrypi,topic=shellies/em3/emeter/2/power value=-147.07 1709911314253226095
mqtt_consumer,host=raspberrypi,topic=shellies/em3/emeter/0/power value=-41.88 1709911315252490626
mqtt_consumer,host=raspberrypi,topic=shellies/em3/emeter/1/power value=-113.91 1709911315253438387
mqtt_consumer,host=raspberrypi,topic=shellies/em3/emeter/2/power value=-154.78 1709911315253759064
mqtt_consumer,host=raspberrypi,topic=shellies/em3/emeter/0/power value=-39.99 1709911316253331459
mqtt_consumer,host=raspberrypi,topic=shellies/em3/emeter/1/power value=-141.04 1709911316254020261
mqtt_consumer,host=raspberrypi,topic=shellies/em3/emeter/2/power value=-154.28 1709911316254655418
mqtt_consumer,host=raspberrypi,topic=shellies/em3/emeter/0/power value=-39.02 1709911317255276250
mqtt_consumer,host=raspberrypi,topic=shellies/em3/emeter/1/power value=-137.8 1709911317255329532
mqtt_consumer,host=raspberrypi,topic=shellies/em3/emeter/2/power value=-154.58 1709911317255405678
mqtt_consumer,host=raspberrypi,topic=shellies/em3/emeter/0/power value=-38.75 1709911318255589948
mqtt_consumer,host=raspberrypi,topic=shellies/em3/emeter/1/power value=-131.94 1709911318256247344
mqtt_consumer,host=raspberrypi,topic=shellies/em3/emeter/2/power value=-156.78 1709911318256891458
mqtt_consumer,host=raspberrypi,topic=shellies/em3/emeter/0/power value=-46.76 1709911319255338958
mqtt_consumer,host=raspberrypi,topic=shellies/em3/emeter/1/power value=-140.13 1709911319256009843
mqtt_consumer,host=raspberrypi,topic=shellies/em3/emeter/2/power value=-155.58 1709911319256682864
mqtt_consumer,host=raspberrypi,topic=tele/solar2/SENSOR ENERGY_Total=1603.983,ENERGY_Voltage=234,ENERGY_Current=1.799,ENERGY_Yesterday=3.594,ENERGY_Today=4.823,ENERGY_Power=422 1709911319956860520
2024-03-08T15:22:02Z D! [outputs.file] Wrote batch of 22 metrics in 567.552µs
2024-03-08T15:22:02Z D! [outputs.file] Buffer fullness: 0 / 10000 metrics
2024-03-08T15:22:02Z D! [outputs.influxdb] Wrote batch of 1 metrics in 16.892031ms
2024-03-08T15:22:02Z D! [outputs.influxdb] Buffer fullness: 0 / 10000 metrics
2024-03-08T15:22:02Z D! [outputs.influxdb] Wrote batch of 21 metrics in 20.581667ms
2024-03-08T15:22:02Z D! [outputs.influxdb] Buffer fullness: 0 / 10000 metrics
2024-03-08T15:22:12Z D! [outputs.influxdb] Buffer fullness: 0 / 10000 metrics
2024-03-08T15:22:12Z D! [outputs.influxdb] Buffer fullness: 0 / 10000 metrics
2024-03-08T15:22:12Z D! [outputs.influxdb] Buffer fullness: 0 / 10000 metrics
mqtt_consumer,host=raspberrypi,topic=shellies/em3/emeter/0/power value=-44.2 1709911323261380727
mqtt_consumer,host=raspberrypi,topic=shellies/em3/emeter/1/power value=-143.08 1709911323262197915
mqtt_consumer,host=raspberrypi,topic=shellies/em3/emeter/2/power value=-162.99 1709911323262743592
mqtt_consumer,host=raspberrypi,topic=shellies/em3/emeter/0/power value=-51.63 1709911325262175987
mqtt_consumer,host=raspberrypi,topic=shellies/em3/emeter/1/power value=-137.31 1709911325262826977