gistfile1.txt

                                                          QUERY PLAN                                                           
-------------------------------------------------------------------------------------------------------------------------------
 Hash Join  (cost=21617.99..45328.86 rows=1 width=29)
   Hash Cond: ((m.event_id = c.event_id) AND (m.user_id = c.state_key))
   ->  Bitmap Heap Scan on room_memberships m  (cost=236.36..23882.12 rows=3255 width=94)
         Recheck Cond: (room_id = '!mWtzDejxeIoLEirXEV:matrix.org'::text)
         Filter: (membership = 'join'::text)
         ->  Bitmap Index Scan on room_memberships_room_id  (cost=0.00..235.54 rows=6264 width=0)
               Index Cond: (room_id = '!mWtzDejxeIoLEirXEV:matrix.org'::text)
   ->  Hash  (cost=21288.29..21288.29 rows=6223 width=85)
         ->  Bitmap Heap Scan on current_state_events c  (cost=452.35..21288.29 rows=6223 width=85)
               Recheck Cond: ((room_id = '!mWtzDejxeIoLEirXEV:matrix.org'::text) AND (type = 'm.room.member'::text))
               ->  Bitmap Index Scan on current_state_events_room_id_type_state_key_key  (cost=0.00..450.79 rows=6223 width=0)
                     Index Cond: ((room_id = '!mWtzDejxeIoLEirXEV:matrix.org'::text) AND (type = 'm.room.member'::text))