No internet connection
  1. Home
  2. Issues

Users page won't load if there are many users

Hi Magnus,

We have so many users now that navigating to the Admin page -> Users causes Chrome to crash (beyond that it takes forever to load).

Could we have paging built-in and search / filtering based on user's handle, name and/or email?

  • 4 replies
  1. C
    Christian Scheuer @chrscheuer
      2026-01-16 16:08:45.243Z

      Would you be able to share some custom SQL / terminal code we can run on the server to look up a user based on their SSO id, email, or equal things?

      We need it for a few user support cases.

      1. Yes, this should work: (\x just makes the output simpler to read — toggles one line per column on/off)

        cd /opt/talkyard
        docker-compose exec rdb psql talkyard talkyard
        
        \x
        
        select * from users3 where
          primary_email_addr = 'abcd@example.com' or
          username = 'abcd' or
          full_name like '%part-of-name%' or
          sso_id = '123abcdef45678' ;
        

        (If the name of the database is something else, you can log in as Postgres and type \l to list all databases:

        docker-compose exec rdb psql postgres postgres
        postgres=# \l
        

        )

        Let me know if you can't find what you're looking for in the users table. Then, the info is probably stored in some other table, and I can post SQL for that. (The funny name: users3 will be changed to pats_t (for "participants_table") some time in the future)

      2. In reply tochrscheuer:

        Wow, I'll have a look, shouldn't take long to fix

        user's handle

        You mean username? Or Single Sign-On id? I guess filtering / search for both, makes sense in any case. (+ email etc)

        1. In reply tochrscheuer:

          paging built-in and search / filtering based on user's handle, name and/or email?

          Now that's been implemented (in v0.2025.13, just released) — searching by username, email, name and external ID / SSO ID.

          If the automatic search is slow (don't know how big your database is), you can un-tick "auto-search", and click a manual Search button instead.

          Let me know how it works

          1. Progress
            with handling this problem
          2. @KajMagnus marked this topic as Planned 2026-01-17 23:26:12.245Z.
          3. @KajMagnus marked this topic as Started 2026-01-24 16:25:57.194Z.
          4. @KajMagnus marked this topic as Done 2026-01-29 10:49:21.912Z.