Insights show 0

Describe the problem/error/question

Insights never populated on the Overview/Insights page. I am using a self-hosted version. The numbers always stay 0.

I do have production executions going on all the time via webhook and schedule.

Information on your n8n setup

  • n8n version: 1.110.1
  • Database (default: SQLite): PostgreSQL
  • n8n EXECUTIONS_PROCESS setting (default: own, main): regular
  • Running n8n via (Docker, npm, n8n cloud, desktop app): Docker
  • Operating system: Ubuntu 22.04.4 LTS

Here are all the variables set in .env file.

`environment:

  • N8N_HOST=${SUBDOMAIN}.${DOMAIN_NAME}
  • N8N_PORT=5678
  • N8N_PROTOCOL=https
  • NODE_ENV=production
  • WEBHOOK_URL=https://${SUBDOMAIN}.${DOMAIN_NAME}/
  • GENERIC_TIMEZONE=America/New_York
  • DB_TYPE=postgresdb
  • DB_POSTGRESDB_DATABASE=*********
  • DB_POSTGRESDB_HOST==*********
  • DB_POSTGRESDB_PORT==*********
  • DB_POSTGRESDB_USER==*********
  • DB_POSTGRESDB_SCHEMA=public
  • DB_POSTGRESDB_PASSWORD==*********
  • NODE_FUNCTION_ALLOW_BUILTIN=*
  • EXECUTIONS_DATA_PRUNE=true
  • EXECUTIONS_DATA_PRUNE_MAX_COUNT=0
  • EXECUTIONS_DATA_MAX_AGE=360
  • NODE_FUNCTION_ALLOW_EXTERNAL=*
  • N8N_ENFORCE_SETTINGS_FILE_PERMISSIONS=true`

Did u just update to a version with insights?

It can take a while for it to show.

Nope, I update on regular basis. The insights were launched in version 1.89.0 and I did the update when it was released.

Ok, and they never showed anything else than 0?
Did u get the registered community edition? Maybe it is required to get it, I am not sure.

Ah I just noticed you set this. That doesn’t work to be set to 0 anymore it will remove all executions I think.
Before we could set it to 0 to not have a max count but not anymore.

Correct, it always have been 0.

Still unable to figure out even though removed