The metabase user started running long-term queries himself

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

@flamber

Many thanks!
I am reading and try to change somethink.