n8n - 💡(How to fix) Fix Execution data is still in the database even when it is disabled and the execution is finished [1 comments, 2 participants]

Official PRs (…)
ON THIS PAGE

Recommended Tools

×6

Utilities matched from this issue’s tags and category — try them while you read without losing context.

GitHub issue graph ai analysis

Paste a GitHub issue URL. We fetch that issue, discover linked issues from bodies/comments/timeline, collect linked pull requests, and produce a structured English report.

The report is written in English Markdown for sharing and archival.

Helpful · Quick feedback

Loading…
GitHub stats
n8n-io/n8n#29555Fetched 2026-05-01 05:52:34
View on GitHub
Comments
1
Participants
2
Timeline
6
Reactions
0
Author
Timeline (top)
labeled ×3commented ×1mentioned ×1subscribed ×1

Error Message

  • error: none
RAW_BUFFERClick to expand / collapse

Bug Description

When N8N is run in queue-mode the execution data (public.execution_data."data") isn't deleted from the database after the finished execution regardless of the settings (server-environment or in the workflow itself).

To Reproduce

  1. Start docker-compose with N8N in queue mode
  2. Change settings of workflow to not safe any execution data
  3. Execut workflow and confirm finished execution
  4. Check Database for execution data, example: docker exec -it postgres psql -U n8n -d n8n SELECT “executionId”, pg_column_size(“data”) FROM public.execution_data;

Here is a minimal docker-compose example which can reproduce the problem:

demo workflow.json docker-compose-n8n.yml n8n-task-runners.json .env.demo.txt

Expected behavior

public.execution_data."data" should have only "[]" in the executions where the execution data was disabled.

Debug Info

Debug info

core

  • n8nVersion: 2.18.5
  • platform: docker (self-hosted)
  • nodeJsVersion: 24.14.1
  • nodeEnv: production
  • database: postgres
  • executionMode: scaling (single-main)
  • concurrency: 10
  • license: community
  • consumerId: unknown

storage

  • success: none
  • error: none
  • progress: false
  • manual: false
  • binaryMode: database

pruning

  • enabled: true
  • maxAge: 336 hours
  • maxCount: 10000 executions

client

  • userAgent: mozilla/5.0 (windows nt 10.0; win64; x64) applewebkit/537.36 (khtml, like gecko) chrome/147.0.0.0 safari/537.36
  • isTouchDevice: false

Generated at: 2026-04-30T07:07:04.732Z

Operating System

Rocky Linux 9.7 (Blue Onyx)

n8n Version

2.18.5

Node.js Version

v22.22.2

Database

PostgreSQL

Execution mode

queue

Hosting

self hosted

extent analysis

TL;DR

The issue can be mitigated by adjusting the pruning settings to ensure execution data is properly deleted after a finished execution.

Guidance

  • Review the pruning settings in the n8n configuration to ensure that pruning.enabled is set to true and adjust pruning.maxAge and pruning.maxCount as needed to control how long execution data is retained.
  • Verify that the workflow settings are correctly configured to not save any execution data.
  • Check the PostgreSQL database to confirm whether the execution data is being deleted as expected after adjusting the pruning settings.
  • Consider updating the docker-compose-n8n.yml file to reflect any changes made to the pruning settings.

Example

No code snippet is provided as the issue is related to configuration settings rather than code.

Notes

The provided information suggests that the issue is related to the pruning settings in n8n, but without further details on the specific configuration, it's difficult to provide a more targeted solution.

Recommendation

Apply workaround: Adjust the pruning settings to ensure proper deletion of execution data, as the root cause appears to be related to the configuration rather than a version-specific issue.

Vote matrix · Quick signals

Works
Did the solution work? Tap to confirm.
Easy Fix
Was it a quick fix?
Time Saver
Did it save you time?
Blocking
Was it severely blocking?
Common Issue
Are others likely hitting this too?
Flaky / Intermittent
Is it intermittent?
Verified / Reproducible
Can you reproduce it reliably?
Loading…

FAQ

Expected behavior

public.execution_data."data" should have only "[]" in the executions where the execution data was disabled.

Still need to ship something?

×6

Another batch ranked right after the header list — different links, same matching logic.

Back to top recommendations

TRENDING