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?
- CChristian Scheuer @chrscheuer
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.
KajMagnus @KajMagnus2026-01-17 23:23:54.917ZYes, this should work: (
\xjust 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
\lto 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:
users3will be changed topats_t(for "participants_table") some time in the future)
In reply tochrscheuer⬆:KajMagnus @KajMagnus2026-01-17 23:25:53.701ZWow, 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)
In reply tochrscheuer⬆:KajMagnus @KajMagnus2026-01-24 16:23:06.081Zpaging 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
- Progresswith handling this problem
