Is there a way to prune old executions data but keep executions?

Questions
1

Describe the problem/error/question

We have large workflows that run on a schedule basis and handle very large volumes of data, right now we configured pruning to keep only 2 weeks of history, which represents 7Go in our postgres database.

Today we would like to be able to auto generate reports with the list of workflows that ran for the last month, but we didn’t keep them for storage’s sake.

What we’d like to do is separate the pruning of data and the pruning of executions, like keep the data for 2w but the executions for 3m or so. I didn’t find a way in the docs to do that right now, is it possible ? Otherwise I’d open a feature request.

2

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
3

I am not aware of such a feature, but what if you take the n8n API and export the execution data to another database? That way you can selectively choose which data you want to keep.

4

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.