Any Query to find the complete SQL query that is in sleep for more than 60?

Hi

I’m seeing many jobs in sleep state, any Query to find on which table it is running and what is the full statement of that sleep query?

Regards,
Gunasekhar

Welcome argunasekhar! :wave:

Are you running the manages service or self-hosted and what version?

Hi @MariaSilverhardt -

I’m using self hosted SingleStore and version is 7.6.

The mv_blocked_queries management view may be useful to you. See

https://docs.singlestore.com/managed-service/en/reference/information-schema-reference/management-tables/mv_blocked_queries.html

1 Like