diff options
| author | Erik Johnston <erik@matrix.org> | 2021-10-27 12:33:21 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2021-10-27 11:33:21 +0000 |
| commit | 72626b78ef4aa9ab0bd11e332495f34bd43bbc26 (patch) | |
| tree | 435e2abe746d4e50048ea4052b5f83189defe8dd /synapse | |
| parent | Update CHANGES.md (diff) | |
| download | synapse-72626b78ef4aa9ab0bd11e332495f34bd43bbc26.tar.xz | |
Fix thread BG update to not seq scan event_json (#11192)
For some reason the query optimiser decided to seq scan both tables, rather than index scanning `event_json`.
Diffstat (limited to 'synapse')
| -rw-r--r-- | synapse/storage/databases/main/events_bg_updates.py | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/synapse/storage/databases/main/events_bg_updates.py b/synapse/storage/databases/main/events_bg_updates.py index f92d824876..ae3a8a63e4 100644 --- a/synapse/storage/databases/main/events_bg_updates.py +++ b/synapse/storage/databases/main/events_bg_updates.py @@ -1108,7 +1108,7 @@ class EventsBackgroundUpdatesStore(SQLBaseStore): """ SELECT event_id, json FROM event_json LEFT JOIN event_relations USING (event_id) - WHERE event_id > ? AND relates_to_id IS NULL + WHERE event_id > ? AND event_relations.event_id IS NULL ORDER BY event_id LIMIT ? """, (last_event_id, batch_size), |