InfluxDB is BIG... how to manage it?

It should be all in my guide above. To look what entities are stored you can use the webinterface of influxdb (i think it was in the explore option, i don’t use influxdb anymore). There you can check every measurement with for example this select statement:

select * from homeassistant.autogen."%" where time > '2022-04-22' and time < '2022-04-24'

But deleting from there did not work for me. To access the influxdb container you need the addon with elevated access, it’ called advanced ssh & web terminal:

Don’t forget to disable protection mode in the settings. In this you can log into your influxdb container:

docker exec -it addon_a0d7b954_influxdb influx -precision rfc3339

then auth yourself if necessary:

> auth
username: homeassistant
password:
> use homeassistant
Using database homeassistant

and finally you can use the delete command

delete from "%" where entity_id = 'your_sensor'
2 Likes