There is two Actions (Service Calls) to perform here.
Recorder: Purge entities
- Entities you want to completely remove from the database or history you want to delete.
- I always set keep days to 0 for these.
- I am not interested in their data or have completely removed the entity.
- Database size will not reduce until you have completed a
Recorder: Purgewith repack. - Select Perform Action and wait a good few minutes, there is no sign that the Action is complete.
Recorder: Purge
- I always set days to keep 365 (As I have rain data I want to keep for graphs)
- Select Repack True and toggled ON - must for database to shrink
- Select Apply filter and toggled ON - I have a long list of excluded entities in my recorder config.
- Select Perform Action and wait a good few minutes.
Having a graph that monitors the database size is a good way to see if the size has shrunk.
I recently added this link Tracking down sudden increase in database size 2025 to the original post in this thread. It shows visually how to work through the steps outlined at the top of this thread.
Great job btw @denilsonsa you helped me immensely shrinking my 3GB database down to what it is now.