Purge db entries | Home Assistant | Page 1

dull zinc Oct 14, 2024, 9:20 PM

#

I try to reduce my databsse size.
All metrics are shipped to prometheus so there is no need to have it here in a long-term storage.
Created this automation but my backup size isn't decreased.
Am I doing something wrong?

alias: Purge it baby
description: ""
triggers:
  - trigger: time
    at: "04:15:00"
conditions: []
actions:
  - action: recorder.purge
    data:
      repack: true
      keep_days: 365
  - action: recorder.purge_entities
    metadata: {}
    data:
      keep_days: 365
mode: single

distant fiber Oct 14, 2024, 9:32 PM

#

You’re keeping 365 days of data. Depending on your current DB size, it can take hours (or days) to purge. If you have Prometheus, why do you need 365 days of data?

dull zinc Oct 14, 2024, 10:06 PM

#

I started with a value to see if it works.

#

The automation is correct configured?

distant fiber Oct 14, 2024, 10:22 PM

#

The automation looks fine, but with 365+ days of data, it’s going to take hours or more to run the purge. It’s not an instant process.

dull zinc Oct 14, 2024, 11:15 PM

#

okay thank you for the details

#Purge db entries