Hi there,
I have a number of Tasmota flashed LB smart plugs I use for energy monitoring. As I have a number of other ESPHome devices I am reflashing the plugs with ESPHome so I can retire Tasmota and simplify my HA setup (a bit).
As part of doing this I will need to move the sensor long term statistics from the existing Tasmota sensors so the new ESPhome sensors so that I can see old and new data seamlessly in the Energy dashboard. I’m OK with the SQL to do this but in getting ready to move the first plug’s data across I have identified a problem.
Specifically the sensors are reporting a spurious amount of decimal places of power data back to HA. HA is then faithfully storing this data in the long term statistics tables which all fills up the database unnecessarily.
It is happening on Tasmota as well, but its particularly bad on ESPHome.
e.g.
daily_energy (from ESPHome):
id created created_ts metadata_id start start_ts mean min max last_reset last_reset_ts state sum mean_weight
60648469 NULL 1756848910.4715693 720 NULL 1756848600.0 NULL NULL NULL NULL NULL 0.48187193274498 0.5298719327449801 NULL
60648770 NULL 1756849210.4559257 720 NULL 1756848900.0 NULL NULL NULL NULL NULL 0.481945276260376 0.529945276260376 NULL
60649071 NULL 1756849510.4542525 720 NULL 1756849200.0 NULL NULL NULL NULL NULL 0.482019782066345 0.530019782066345 NULL
The state and sum are both captured with 10 decimal places of data, e.g. 0.48187193274498 !
daily_energy from Tasmota:
id created created_ts metadata_id start start_ts mean min max last_reset last_reset_ts state sum mean_weight
5019596 NULL 1753322410.417633 213 NULL 1753318800.0 NULL NULL NULL NULL NULL 0.0 95.60300000000208 NULL
5019903 NULL 1753326010.4176698 213 NULL 1753322400.0 NULL NULL NULL NULL NULL 0.001 95.60400000000209 NULL
5020210 NULL 1753329610.4309297 213 NULL 1753326000.0 NULL NULL NULL NULL NULL 0.001 95.60400000000209 NULL
State is returned with 3 decimal places. Sum has gained a lot of decimal places but this is due to floating point rounding errors in HA so is unavoidable.
Power (from ESPHome):
id created created_ts metadata_id start start_ts mean min max last_reset last_reset_ts state sum mean_weight
5316881 NULL 1756843210.51355 722 NULL 1756839600.0 0.8432221859959365 0.641993522644043 0.917133629322052 NULL NULL NULL NULL NULL
5317206 NULL 1756846810.5085099 722 NULL 1756843200.0 73.88444220760194 0.825420260429382 2942.57690429688 NULL NULL NULL NULL NULL
5317507 NULL 1756850410.523198 722 NULL 1756846800.0 0.8898624693616567 0.825420260429382 0.96299022436142 NULL NULL NULL NULL NULL
Mean min and max all have stupid number of decimal places
Power (from Tasmota):
id created created_ts metadata_id start start_ts mean min max last_reset last_reset_ts state sum mean_weight
5026665 NULL 1753405211.015667 214 NULL 1753401600.0 0.0 0.0 0.0 NULL NULL NULL NULL NULL
5026972 NULL 1753408810.4102542 214 NULL 1753405200.0 0.21413377749999998 0.0 1.0 NULL NULL NULL NULL NULL
5027279 NULL 1753412410.3892372 214 NULL 1753408800.0 0.0 0.0 0.0 NULL NULL NULL NULL NULL
5028506 NULL 1753426810.4009042 214 NULL 1753423200.0 0.0 0.0 0.0 NULL NULL NULL NULL NULL
5028812 NULL 1753430410.5007527 214 NULL 1753426800.0 833.9618132332233 3.0 2254.0 NULL NULL NULL NULL NULL
5029109 NULL 1753434010.4462683 214 NULL 1753430400.0 165.48498334833334 8.0 2254.0 NULL NULL NULL NULL NULL
Some big numbers of decimal places but only affecting mean. Zero power is being returned as zero.
To be clear, this is nothing to do with the entity display precision you can change in HA, all that does is change what level of precision you see in the HA UI. This is about how the sensors return data to HA and that they haven’t been configured with a reduced number of decimal places of precision. As a result we get stupidly long values returned and stored in HA.
The config in ESPHome should be something like this which is for a Temperature and Humidity sensor but all the sensors are similarly configured, its the accuracy_decimals that is missing in the LB plug
# BMP280 Temperature & Pressure Sensor
- platform: bmp280_i2c
temperature:
name: "Loft Temperature"
oversampling: 16x
accuracy_decimals: 1
filters:
- offset: 0.0
pressure:
name: "Loft Pressure"
accuracy_decimals: 0
address: 0x76
update_interval: 5min
