Spaces:
Running
Suggestion: Add Execution data pruning (Automatic)
Hey, I was facing some issue, like number of execution became more than 5000 and making supabase limit more than 0.5GB which is not supported in free version.
Then added a workflow to delete execution everyday which is making the interface crashed.
I have done some digging and find out there some ENV that does it safely and works like a charm. i.e.
EXECUTIONS_DATA_PRUNE
EXECUTIONS_DATA_MAX_AGE
EXECUTIONS_DATA_PRUNE_MAX_COUNT
Please see the docs. and lets do it if it is doable! It can help many users. Let me know if we can do it.
I got this from internet:
These variables work together to control the pruning process. For instance, if you set EXECUTIONS_DATA_PRUNE to true, EXECUTIONS_DATA_MAX_AGE to 24, and EXECUTIONS_DATA_PRUNE_MAX_COUNT to 100, n8n will automatically delete any execution data older than 24 hours and will keep only the last 100 executions, deleting older ones if the count exceeds 100.
Please verify it and lets see if we can add this
Thanks