1 files changed, 6 insertions, 0 deletions
diff --git a/latest/usage/administration/useful_sql_for_admins.html b/latest/usage/administration/useful_sql_for_admins.html
index ce31570096..b501d28f23 100644
--- a/latest/usage/administration/useful_sql_for_admins.html
+++ b/latest/usage/administration/useful_sql_for_admins.html
@@ -329,6 +329,12 @@ WHERE room_stats_state.room_id = event_json.room_id&quot; | psql -d synapse -h l
   FROM devices
   WHERE last_seen &lt; DATE_PART('epoch', NOW() - INTERVAL '3 month') * 1000;
 </code></pre>
+<h2 id="clear-the-cache-of-a-remote-users-device-list"><a class="header" href="#clear-the-cache-of-a-remote-users-device-list">Clear the cache of a remote user's device list</a></h2>
+<p>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.</p>
+<pre><code class="language-sql">INSERT INTO device_lists_remote_resync
+VALUES ('USER_ID', (EXTRACT(epoch FROM NOW()) * 1000)::BIGINT);
+</code></pre>
 
                     </main>