Active Queries

The Managed Service portal has an option that allows you to monitor currently running queries. This can help in identifying and troubleshooting long-running queries. This feature is similar to what is available in SingleStore DB Studio. The only difference is that you can select different clusters from the portal, unlike Studio where you can access only a single cluster.

Active_query.jpeg

To access the Active Queries page, click on your cluster in the left nav and click Active Queries under Monitoring. Once on the Active Queries page, you can select a cluster by using the cluster selector drop-down at the top of this page.

Kill a Running Query

To kill a running query, click the checkbox next to the query and then click the Kill Query button at the top of the page.

Explain a Query

To explain a query, click the checkbox next to the query and then click on the Explain Query button. This will take you to the Visual Explain page where you can see the profile of the query.

Export as CSV

To export the details displayed for a query, click the checkbox next to the query and then click on the Export as CSV button. This will download the query as a CSV file.

Additional Information

Refer to Testing Your Queries and Performance, Query Tuning, and Long Running Queries for more information about queries and query troubleshooting.ISSUE: Long Running Queries Blocking DDL Operations and Workload