summary refs log tree commit diff
path: root/synapse/storage/client_ips.py
diff options
context:
space:
mode:
authorNeil Johnson <neil@fragile.org.uk>2018-03-28 12:03:13 +0100
committerNeil Johnson <neil@fragile.org.uk>2018-03-28 12:03:13 +0100
commit788e69098c93f2433ef907015666c624bb39318f (patch)
treef88f872ca2c3a9b6308ce1051cee8b6dcb172a35 /synapse/storage/client_ips.py
parentNo need to cast in count_daily_users (diff)
downloadsynapse-788e69098c93f2433ef907015666c624bb39318f.tar.xz
Add user_ips last seen index
Diffstat (limited to 'synapse/storage/client_ips.py')
-rw-r--r--synapse/storage/client_ips.py7
1 files changed, 7 insertions, 0 deletions
diff --git a/synapse/storage/client_ips.py b/synapse/storage/client_ips.py
index a03d1d6104..7b44dae0fc 100644
--- a/synapse/storage/client_ips.py
+++ b/synapse/storage/client_ips.py
@@ -48,6 +48,13 @@ class ClientIpStore(background_updates.BackgroundUpdateStore):
             columns=["user_id", "device_id", "last_seen"],
         )
 
+        self.register_background_index_update(
+            "user_ips_last_seen_index",
+            index_name="user_ips_last_seen",
+            table="user_ips",
+            columns=["user_id", "last_seen"],
+        )
+
         # (user_id, access_token, ip) -> (user_agent, device_id, last_seen)
         self._batch_row_update = {}