Execution data#
Depending on your executions settings and volume, your n8n database can grow in size and run out of storage.
To avoid this, n8n recommends that you don't save unnecessary data, and enable pruning of old executions data.
To do this, configure the corresponding environment variables.
Reduce saved data#
Configuration at workflow level
You can also configure these settings on an individual workflow basis using the workflow settings.
You can select which executions data n8n saves. For example, you can save only executions that result in an Error
.
1 2 3 4 5 6 7 8 9 10 11 12 |
|
1 2 3 4 5 6 7 8 9 |
|
1 2 3 4 5 6 7 |
|
Enable executions pruning#
Executions pruning deletes finished executions along with their execution data and binary data on a regular schedule. n8n enables pruning by default. For performance reasons, pruning first marks targets for deletion, and then later permanently removes them.
n8n prunes executions when either of the following condition occur:
- Age: The execution finished more than
EXECUTIONS_DATA_MAX_AGE
hours ago (default: 336 hours -> 14 days). - Count: The total number of executions exceeds
EXECUTIONS_DATA_PRUNE_MAX_COUNT
(default: 10,000). When this occurs, n8n deletes executions from oldest to newest.
Keep in mind:
- Executions with the
new
,running
, orwaiting
status aren't eligible for pruning. - Annotated executions are permanently exempt from pruning.
- Pruning honors a safety buffer period of
EXECUTIONS_DATA_HARD_DELETE_BUFFER
hours (default: 1h), to ensure recent data remains available while the user is building or debugging a workflow.
1 2 3 4 5 6 7 8 |
|
1 2 3 4 5 6 7 |
|
1 2 3 4 5 6 |
|
SQLite
If you run n8n using the default SQLite database, the disk space of any pruned data isn't automatically freed up but rather reused for future executions data. To free up this space configure the DB_SQLITE_VACUUM_ON_STARTUP
environment variable or manually run the VACUUM operation.
Binary data pruning
Binary data pruning operates on the active binary data mode. For example, if your instance stored data in S3, and you later switched to filesystem mode, n8n only prunes binary data in the filesystem. This may change in future.