Active Queries

The SingleStore Helios Cloud Portal has an option that lets you monitor currently running queries. This can help in identifying and troubleshooting long-running queries.

To access the Active Queries page, select Active Queries under Monitoring in the left navigation. Once on the Active Queries page, you can select a workspace by using the workspace selector list at the top of this page.

Kill a Running Query

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

Explain a Query

To explain a query, select the checkbox next to the query and then select 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, select the checkbox next to the query and then select the Export as CSV button. This will download the query as a CSV file.

Additional Information

Refer to Testing Your Queries and Performance and Query Tuning for more information about queries and query troubleshooting.