I try to understand why my postgresql database is growing and finally I’ve found that hass does not purge anything.
My oldest event actually is date on 21/8 in the events table but when I run a purge here’s what I see in the debug log:
hass=# select event_id,event_type,created from events order by created limit 1;
event_id | event_type | created
----------±--------------±------------------------------
2115 | state_changed | 2018-08-21 07:06:54.409343+02
(1 row)
Thanks, I’ve run something similar and found that my cpu and mermory monitoring no the host was the most expensive consumer here.
And I don’t need local history because I already have influxdb.