Hi,
I’ve set up my electricity energy metrics by reading the values from the smart meter (infrared diode, sending SML) with some ESP8266 + Tasmota. The data I collect for both meters like this:
name: Energy Total House
state: "{{ states('sensor.tasmota_sml_house_value_1_8_0') | float }}"
unit_of_measurement: kWh
device_class: energy
state_class: total_increasing
name: Energy Total Heatpump
state: "{{ states('sensor.tasmota_sml_heatpump_value_1_8_0') | float }}"
unit_of_measurement: kWh
device_class: energy
state_class: total_increasing
For the house metric it shows 1992.30 EUR
, which I have no explanation for why.
The values in the database look like this:
sqlite> select * from statistics_meta where id in (240, 241, 242, 243);
id = 240
statistic_id = sensor.energy_total_heatpump
source = recorder
unit_of_measurement = kWh
has_mean = 0
has_sum = 1
name =
id = 241
statistic_id = sensor.energy_total_house
source = recorder
unit_of_measurement = kWh
has_mean = 0
has_sum = 1
name =
id = 242
statistic_id = sensor.energy_total_heatpump_cost
source = recorder
unit_of_measurement = EUR
has_mean = 0
has_sum = 1
name =
id = 243
statistic_id = sensor.energy_total_house_cost
source = recorder
unit_of_measurement = EUR
has_mean = 0
has_sum = 1
name =
select * from statistics where metadata_id in (240, 241, 242, 243);
id = 65633
created = 2022-08-17 10:00:10.093916
start = 2022-08-17 09:00:00.000000
mean =
min =
max =
last_reset =
state = 34748.72
sum = 4.86000000000058
metadata_id = 240
id = 65819
created = 2022-08-17 11:00:10.097035
start = 2022-08-17 10:00:00.000000
mean =
min =
max =
last_reset =
state = 34748.85
sum = 4.98999999999796
metadata_id = 240
id = 66005
created = 2022-08-17 12:00:10.094918
start = 2022-08-17 11:00:00.000000
mean =
min =
max =
last_reset =
state = 34748.97
sum = 5.11000000000058
metadata_id = 240
id = 66191
created = 2022-08-17 13:00:10.094315
start = 2022-08-17 12:00:00.000000
mean =
min =
max =
last_reset =
state = 34749.1
sum = 5.23999999999796
metadata_id = 240
id = 66377
created = 2022-08-17 14:00:10.065641
start = 2022-08-17 13:00:00.000000
mean =
min =
max =
last_reset =
state = 34749.4
sum = 5.54000000000087
metadata_id = 240
id = 66563
created = 2022-08-17 15:00:10.093586
start = 2022-08-17 14:00:00.000000
mean =
min =
max =
last_reset =
state = 34750.5
sum = 6.63999999999942
metadata_id = 240
id = 66749
created = 2022-08-17 16:00:10.089928
start = 2022-08-17 15:00:00.000000
mean =
min =
max =
last_reset =
state = 34750.81
sum = 6.94999999999709
metadata_id = 240
id = 66935
created = 2022-08-17 17:00:10.096342
start = 2022-08-17 16:00:00.000000
mean =
min =
max =
last_reset =
state = 34751.2
sum = 7.33999999999651
metadata_id = 240
id = 67121
created = 2022-08-17 18:00:10.100463
start = 2022-08-17 17:00:00.000000
mean =
min =
max =
last_reset =
state = 34752.2
sum = 8.33999999999651
metadata_id = 240
id = 65634
created = 2022-08-17 10:00:10.094007
start = 2022-08-17 09:00:00.000000
mean =
min =
max =
last_reset =
state = 39816.56
sum = 10.2599999999948
metadata_id = 241
id = 65820
created = 2022-08-17 11:00:10.097083
start = 2022-08-17 10:00:00.000000
mean =
min =
max =
last_reset =
state = 39816.78
sum = 10.4799999999959
metadata_id = 241
id = 66006
created = 2022-08-17 12:00:10.095021
start = 2022-08-17 11:00:00.000000
mean =
min =
max =
last_reset =
state = 39816.97
sum = 10.6699999999983
metadata_id = 241
id = 66192
created = 2022-08-17 13:00:10.094381
start = 2022-08-17 12:00:00.000000
mean =
min =
max =
last_reset =
state = 39817.16
sum = 10.8600000000006
metadata_id = 241
id = 66378
created = 2022-08-17 14:00:10.065690
start = 2022-08-17 13:00:00.000000
mean =
min =
max =
last_reset =
state = 39817.34
sum = 11.0399999999936
metadata_id = 241
id = 66564
created = 2022-08-17 15:00:10.093633
start = 2022-08-17 14:00:00.000000
mean =
min =
max =
last_reset =
state = 39817.88
sum = 11.5799999999945
metadata_id = 241
id = 66750
created = 2022-08-17 16:00:10.089976
start = 2022-08-17 15:00:00.000000
mean =
min =
max =
last_reset =
state = 39818.31
sum = 12.0099999999948
metadata_id = 241
id = 66936
created = 2022-08-17 17:00:10.096389
start = 2022-08-17 16:00:00.000000
mean =
min =
max =
last_reset =
state = 39818.73
sum = 12.4300000000003
metadata_id = 241
id = 67122
created = 2022-08-17 18:00:10.100514
start = 2022-08-17 17:00:00.000000
mean =
min =
max =
last_reset =
state = 39818.99
sum = 12.6899999999951
metadata_id = 241
id = 65635
created = 2022-08-17 10:00:10.094073
start = 2022-08-17 09:00:00.000000
mean =
min =
max =
last_reset = 2022-08-17 09:47:48.461512
state = 0.0140579999994545
sum = 0.69352799999809
metadata_id = 242
id = 65821
created = 2022-08-17 11:00:10.097164
start = 2022-08-17 10:00:00.000000
mean =
min =
max =
last_reset = 2022-08-17 09:47:48.461512
state = 0.0445169999988408
sum = 0.723986999997476
metadata_id = 242
id = 66007
created = 2022-08-17 12:00:10.095086
start = 2022-08-17 11:00:00.000000
mean =
min =
max =
last_reset = 2022-08-17 09:47:48.461512
state = 0.0726329999994545
sum = 0.75210299999809
metadata_id = 242
id = 66193
created = 2022-08-17 13:00:10.094443
start = 2022-08-17 12:00:00.000000
mean =
min =
max =
last_reset = 2022-08-17 09:47:48.461512
state = 0.103091999998841
sum = 0.782561999997476
metadata_id = 242
id = 66379
created = 2022-08-17 14:00:10.065738
start = 2022-08-17 13:00:00.000000
mean =
min =
max =
last_reset = 2022-08-17 09:47:48.461512
state = 0.173381999999523
sum = 0.852851999998158
metadata_id = 242
id = 66565
created = 2022-08-17 15:00:10.093682
start = 2022-08-17 14:00:00.000000
mean =
min =
max =
last_reset = 2022-08-17 09:47:48.461512
state = 0.431111999999181
sum = 1.11058199999782
metadata_id = 242
id = 66751
created = 2022-08-17 16:00:10.090023
start = 2022-08-17 15:00:00.000000
mean =
min =
max =
last_reset = 2022-08-17 09:47:48.461512
state = 0.503744999998636
sum = 1.18321499999727
metadata_id = 242
id = 66937
created = 2022-08-17 17:00:10.096436
start = 2022-08-17 16:00:00.000000
mean =
min =
max =
last_reset = 2022-08-17 09:47:48.461512
state = 0.5951219999985
sum = 1.27459199999714
metadata_id = 242
id = 67123
created = 2022-08-17 18:00:10.100562
start = 2022-08-17 17:00:00.000000
mean =
min =
max =
last_reset = 2022-08-17 09:47:48.461512
state = 0.8294219999985
sum = 1.50889199999714
metadata_id = 242
id = 65636
created = 2022-08-17 10:00:10.094125
start = 2022-08-17 09:00:00.000000
mean =
min =
max =
last_reset = 2022-08-17 09:47:48.461710
state = 0.0164999999993597
sum = 1992.48345011586
metadata_id = 243
id = 65822
created = 2022-08-17 11:00:10.097215
start = 2022-08-17 10:00:00.000000
mean =
min =
max =
last_reset = 2022-08-17 09:47:48.461710
state = 0.0769999999996799
sum = 1992.54395011586
metadata_id = 243
id = 66008
created = 2022-08-17 12:00:10.095136
start = 2022-08-17 11:00:00.000000
mean =
min =
max =
last_reset = 2022-08-17 09:47:48.461710
state = 0.12925000000032
sum = 1992.59620011586
metadata_id = 243
id = 66194
created = 2022-08-17 13:00:10.094493
start = 2022-08-17 12:00:00.000000
mean =
min =
max =
last_reset = 2022-08-17 09:47:48.461710
state = 0.18150000000096
sum = 1992.64845011586
metadata_id = 243
id = 66380
created = 2022-08-17 14:00:10.065806
start = 2022-08-17 13:00:00.000000
mean =
min =
max =
last_reset = 2022-08-17 09:47:48.461710
state = 0.23099999999904
sum = 1992.69795011585
metadata_id = 243
id = 66566
created = 2022-08-17 15:00:10.093732
start = 2022-08-17 14:00:00.000000
mean =
min =
max =
last_reset = 2022-08-17 09:47:48.461710
state = 0.379499999999279
sum = 1992.84645011585
metadata_id = 243
id = 66752
created = 2022-08-17 16:00:10.090073
start = 2022-08-17 15:00:00.000000
mean =
min =
max =
last_reset = 2022-08-17 09:47:48.461710
state = 0.497749999999359
sum = 1992.96470011585
metadata_id = 243
id = 66938
created = 2022-08-17 17:00:10.096485
start = 2022-08-17 16:00:00.000000
mean =
min =
max =
last_reset = 2022-08-17 09:47:48.461710
state = 0.613250000000881
sum = 1993.08020011586
metadata_id = 243
id = 67124
created = 2022-08-17 18:00:10.100611
start = 2022-08-17 17:00:00.000000
mean =
min =
max =
last_reset = 2022-08-17 09:47:48.461710
state = 0.68474999999944
sum = 1993.15170011585
metadata_id = 243
Where might this initial high sum coming from? Is there anything else than the statistics db that I could/should clean up before setting up the energy metrics again?
Here’s the .storage/energy
config btw:
{
"version": 1,
"minor_version": 1,
"key": "energy",
"data": {
"energy_sources": [
{
"type": "grid",
"flow_from": [
{
"stat_energy_from": "sensor.energy_total_house",
"stat_cost": null,
"entity_energy_from": "sensor.energy_total_house",
"entity_energy_price": null,
"number_energy_price": 0.275
},
{
"stat_energy_from": "sensor.energy_total_heatpump",
"stat_cost": null,
"entity_energy_from": "sensor.energy_total_heatpump",
"entity_energy_price": null,
"number_energy_price": 0.2343
}
],
"flow_to": [],
"cost_adjustment_day": 0.0
}
],
"device_consumption": [
{
"stat_consumption": "sensor.tasmota_bicycle_energy_total"
},
{
"stat_consumption": "sensor.tasmota_datacenter_energy_total"
},
{
"stat_consumption": "sensor.tasmota_dryer_energy_total"
},
{
"stat_consumption": "sensor.tasmota_fountain_energy_total"
},
{
"stat_consumption": "sensor.tasmota_heating_workroom_2_energy_total"
},
{
"stat_consumption": "sensor.tasmota_office_energy_total"
},
{
"stat_consumption": "sensor.tasmota_printer_energy_total"
},
{
"stat_consumption": "sensor.tasmota_tv_livingroom_energy_total"
},
{
"stat_consumption": "sensor.tasmota_washingmachine_energy_total"
}
]
}
}
Thanks,
Johannes