From 051cad208ca17ef13350d0d8810b989c466e9345 Mon Sep 17 00:00:00 2001 From: anoadragon453 Date: Thu, 14 Mar 2024 13:55:07 +0000 Subject: deploy: 1c1b0bfa778e32bf740469b0a86be55102bc01b4 --- develop/usage/administration/useful_sql_for_admins.html | 6 ++++++ 1 file changed, 6 insertions(+) (limited to 'develop/usage/administration/useful_sql_for_admins.html') diff --git a/develop/usage/administration/useful_sql_for_admins.html b/develop/usage/administration/useful_sql_for_admins.html index ce31570096..b501d28f23 100644 --- a/develop/usage/administration/useful_sql_for_admins.html +++ b/develop/usage/administration/useful_sql_for_admins.html @@ -328,6 +328,12 @@ WHERE room_stats_state.room_id = event_json.room_id" | psql -d synapse -h l 
SELECT user_id, device_id, user_agent, TO_TIMESTAMP(last_seen / 1000) AS "last_seen"
   FROM devices
   WHERE last_seen < DATE_PART('epoch', NOW() - INTERVAL '3 month') * 1000;
+
+

Clear the cache of a remote user's device list

+

Forces the resync of a remote user's device list - if you have somehow cached a bad state, and the remote server is +will not send out a device list update.

+
INSERT INTO device_lists_remote_resync
+VALUES ('USER_ID', (EXTRACT(epoch FROM NOW()) * 1000)::BIGINT);
-- cgit 1.5.1