Recorder commit_interval not working

Configuration
1

Hi,
It seems that the optionnal commit_interval for recorder is not working.
I tried to set it to 10, 30, 50 and my sensor keep publishing every second.
My DB is growing too fast and I don’t know how to slow down it.
Anybody saw this option working ?

Example state changed time recorded:
2020-06-03 20:00:21.234360
2020-06-03 20:00:21.242900
2020-06-03 20:00:21.786608
2020-06-03 20:00:22.675126
2020-06-03 20:00:22.684792
2020-06-03 20:00:23.226622
2020-06-03 20:00:24.023969
2020-06-03 20:00:24.038115
2020-06-03 20:00:24.122900
2020-06-03 20:00:24.132024
2020-06-03 20:00:25.567267

2

The commit interval only changes how often the database is written, it does not change the sensor scan_interval.

So if you set a commit interval of 50 seconds HA will store 50 of your sensor’s 1 second updates in memory then write them all at once to the database.

Change your sensor’s scan_interval.

3

Thanks, I missed this scan_interval on the sensor doc.