[PR #23801] [CLOSED] perf: add index on memory.user_id #66234

New Issue

GiteaMirror · 2026-05-06T12:29:14-05:00

GiteaMirror commented

2026-05-06 12:29:14 -05:00

📋 Pull Request Information

Original PR: https://github.com/open-webui/open-webui/pull/23801
Author: @Classic298
Created: 4/16/2026
Status: ❌ Closed

Base: dev ← Head: claude/add-memory-user-index-9GTzH

📝 Commits (2)

2dd02cf perf: add index on memory.user_id
eadbd27 fix: align index name between model and migration, drop unused import

📊 Changes

2 files changed (+30 additions, -1 deletions)

View changed files

➕ backend/open_webui/migrations/versions/a749ab2aa953_add_memory_user_id_index.py (+25 -0)
📝 backend/open_webui/models/memories.py (+5 -1)

📄 Description

Memory queries filter by user_id (get_memories_by_user_id, delete_memories_by_user_id) but the column had no index, forcing a full table scan per request. Adds a btree index via Alembic migration plus index=True on the model so fresh installs include it.

Contributor License Agreement

By submitting this pull request, I confirm that I have read and fully agree to the Contributor License Agreement (CLA), and I am providing my contributions under its terms.

Note

Deleting the CLA section will lead to immediate closure of your PR and it will not be merged in.

_{🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.}

## 📋 Pull Request Information **Original PR:** https://github.com/open-webui/open-webui/pull/23801 **Author:** [@Classic298](https://github.com/Classic298) **Created:** 4/16/2026 **Status:** ❌ Closed **Base:** `dev` ← **Head:** `claude/add-memory-user-index-9GTzH` --- ### 📝 Commits (2) - [`2dd02cf`](https://github.com/open-webui/open-webui/commit/2dd02cfc92b04ed5be3510152bc17642df3560a2) perf: add index on memory.user_id - [`eadbd27`](https://github.com/open-webui/open-webui/commit/eadbd272a9dfdacf042f5b278511f044826515ad) fix: align index name between model and migration, drop unused import ### 📊 Changes **2 files changed** (+30 additions, -1 deletions) <details> <summary>View changed files</summary> ➕ `backend/open_webui/migrations/versions/a749ab2aa953_add_memory_user_id_index.py` (+25 -0) 📝 `backend/open_webui/models/memories.py` (+5 -1) </details> ### 📄 Description Memory queries filter by user_id (get_memories_by_user_id, delete_memories_by_user_id) but the column had no index, forcing a full table scan per request. Adds a btree index via Alembic migration plus index=True on the model so fresh installs include it. ### Contributor License Agreement  - [X] By submitting this pull request, I confirm that I have read and fully agree to the [Contributor License Agreement (CLA)](https://github.com/open-webui/open-webui/blob/main/CONTRIBUTOR_LICENSE_AGREEMENT), and I am providing my contributions under its terms. > [!NOTE] > Deleting the CLA section will lead to immediate closure of your PR and it will not be merged in. --- <sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>

GiteaMirror added the pull-request label 2026-05-06 12:29:15 -05:00

GiteaMirror closed this issue

2026-05-06 12:29:17 -05:00

Sign in to join this conversation.

Branches Tags

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: github-starred/open-webui#66234