diff options
| author | Eric Eastwood <erice@element.io> | 2023-06-07 11:45:16 -0500 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2023-06-07 11:45:16 -0500 |
| commit | 195b6a298d509518bf16d5a421d706ecb2ccdce6 (patch) | |
| tree | dadb649c6af2f54f8d320081bef783adc6dc952b /docs/usage | |
| parent | Check required power levels earlier in createRoom handler. (#15695) (diff) | |
| download | synapse-195b6a298d509518bf16d5a421d706ecb2ccdce6.tar.xz | |
Remove redundant `room_memberships` join to find participating servers in a room (#15732)
Spawning from https://github.com/matrix-org/synapse/pull/15731
Diffstat (limited to 'docs/usage')
| -rw-r--r-- | docs/usage/administration/admin_faq.md | 5 |
1 files changed, 2 insertions, 3 deletions
diff --git a/docs/usage/administration/admin_faq.md b/docs/usage/administration/admin_faq.md index 28c3dd53a5..5c9ee7d0aa 100644 --- a/docs/usage/administration/admin_faq.md +++ b/docs/usage/administration/admin_faq.md @@ -27,9 +27,8 @@ What servers are currently participating in this room? Run this sql query on your db: ```sql SELECT DISTINCT split_part(state_key, ':', 2) - FROM current_state_events AS c - INNER JOIN room_memberships AS m USING (room_id, event_id) - WHERE room_id = '!cURbafjkfsMDVwdRDQ:matrix.org' AND membership = 'join'; +FROM current_state_events +WHERE room_id = '!cURbafjkfsMDVwdRDQ:matrix.org' AND membership = 'join'; ``` What users are registered on my server? |