Back to Templates

Purge n8n execution history located in Mysql

Created by

Created by: Miquel Colomer || mcolomer

Miquel Colomer

Last update

Last update a year ago

Share


This workflow is useful if you have lots of tasks running daily.

MySQL node (or the database used to save data shown in n8n - could be Mongo, Postgres, ... -) remove old entries from execution_entity table that contains the history of the executed workflows.

If you have multiple tasks executed every minute, 1024 rows will be created every day (60 minutes x 24 hours) per every task. This will increase the table size fastly.

SQL query deletes entries older than 30 days taking stoppedAt column as a reference for date calculations.

image.png

You only have to setup Mysql connection properly and config cron to execute once per day in a low traffic hour, this way

image.png