The metabase user started running long-term queries himself.
One of them:
"SELECT audits
.event
AS event
FROM audits
GROUP BY audits
.event
ORDER BY audits
.event
ASC LIMIT 5000"
I can't understand why and how to stop them. Please, help.
Hi @Bob205
That query is part of scanning, which can be disabled, but those should absolutely not be "long-running" unless there might be indexing problems on your database:
https://www.metabase.com/docs/latest/administration-guide/01-managing-databases.html#choose-when-metabase-syncs-and-scans
https://www.metabase.com/docs/latest/troubleshooting-guide/sync-fingerprint-scan.html
Many thanks!
I am reading and try to change somethink.