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

Help Query Tuning
1

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

2

Welcome argunasekhar! :wave:

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

3

Hi @MariaSilverhardt -

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

4

The mv_blocked_queries management view may be useful to you. See

1 Like