Describe the problem/error/question
My execution_data table has grown to 3.2GB. I found the culprit workflow and turned off saving executions. But it seems like the execution data is still there. Short of just waiting for the age threshold (currently 334 hrs) or running a sql delete command (rarely a good idea) is there a way to trigger pruning to remove that data sooner? I’ve already tried restarting.
What is the error message (if any)?
Please share your workflow
select ee."workflowId", count(ee.id) as ct, sum(length(ed.data)) as data_length
from public.execution_data as ed join public.execution_entity as ee on ed."executionId"=ee.id
group by ee."workflowId"
order by sum(length(ed.data)) desc;
Information on your n8n setup
- n8n version: 1.70.3
- Database (default: SQLite): Postgres
- n8n EXECUTIONS_PROCESS setting (default: own, main): ?
- Running n8n via (Docker, npm, n8n cloud, desktop app): npm
- Operating system: Ubuntu Linux