summary refs log tree commit diff
path: root/synapse/storage
diff options
context:
space:
mode:
authorShay <hillerys@element.io>2022-07-18 12:35:45 -0700
committerGitHub <noreply@github.com>2022-07-18 12:35:45 -0700
commit15edf23626a55ee38a8ee394bfcc8eaeff733c37 (patch)
treec164a2b90e90edafb483559d104a5d2086778c86 /synapse/storage
parentFix overcounting of pushers when they are replaced (#13296) (diff)
downloadsynapse-15edf23626a55ee38a8ee394bfcc8eaeff733c37.tar.xz
Improve performance of query ` _get_subset_users_in_room_with_profiles` (#13299)
Diffstat (limited to '')
-rw-r--r--synapse/storage/databases/main/roommember.py2
1 files changed, 1 insertions, 1 deletions
diff --git a/synapse/storage/databases/main/roommember.py b/synapse/storage/databases/main/roommember.py
index 105a518677..46ab6232d4 100644
--- a/synapse/storage/databases/main/roommember.py
+++ b/synapse/storage/databases/main/roommember.py
@@ -243,7 +243,7 @@ class RoomMemberWorkerStore(EventsWorkerStore):
             txn: LoggingTransaction,
         ) -> Dict[str, ProfileInfo]:
             clause, ids = make_in_list_sql_clause(
-                self.database_engine, "m.user_id", user_ids
+                self.database_engine, "c.state_key", user_ids
             )
 
             sql = """