Only fetch required fields from database

1 files changed, 2 insertions, 1 deletions

diff --git a/synapse/storage/stream.py b/synapse/storage/stream.py

index b57a8a7ef6..d3adb0bf37 100644
--- a/synapse/storage/stream.py
+++ b/synapse/storage/stream.py
@@ -796,7 +796,8 @@ class StreamWorkerStore(EventsWorkerStore, SQLBaseStore):
             limit_str = ""
 
         sql = (
-            "SELECT * FROM events"
+            "SELECT event_id, topological_ordering, stream_ordering"
+            " FROM events"
             " WHERE outlier = ? AND room_id = ? AND %(bounds)s"
             " ORDER BY topological_ordering %(order)s,"
             " stream_ordering %(order)s %(limit)s"