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
<!--
🚨 DO NOT DELETE THE TEXT BELOW 🚨
Keep the "Contributor License Agreement" confirmation text intact.
Deleting it will trigger the CLA-Bot to INVALIDATE your PR.
Your PR will NOT be reviewed or merged until you check the box below confirming that you have read and agree to the terms of the CLA.
-->
- [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>
Blocking a user prevents them from interacting with repositories, such as opening or commenting on pull requests or issues. Learn more about blocking a user.
📋 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)
2dd02cfperf: add index on memory.user_ideadbd27fix: 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
🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.