Hi, the tool BaGLAMa2 is executing on tools labs very long running queries, up to ~65000 seconds, please optimize them ASAP because they're affecting the database performances.
All the long queries are of type:
SELECT DISTINCT views.id AS id,title,namespace_id,grok_code,server FROM views,group2view,sites WHERE group_status_id=<const> AND view_id=views.id AND sites.id=site AND done=0 AND namespace_id=0 ORDER BY rand() LIMIT 2000;