Under heavy traffic, the coalesce query in \Drupal\workspaces\EntityQuery is very slow.
For normal admin operations this is fine, but for other usages of Workspaces for anonymous traffic it exacerbates the issue and floods the database:
1. Use a module like
https://www.drupal.org/project/wse →
that can activate a workspace for anonymous users on a cookie
2. Throw a lot of Workspace traffic at the site
Optimize the query.
Active
11.1 🔥
workspaces.module