Identifying Expensive Queries
On this page
In Studio, navigate to the Activity Resource Usage page.
If you don’t have monitoring data from SingleStore’s monitoring solution, press Begin Profiling to capture current activity for a period of time.
Be sure to record during the workload or query of interest, if you have identified one from collecting a report in the previous step, or from another source.
If one has been identified, switch the database selector to the problematic database.
See the following example image, where you can find the database selector to the top left.
Run Countby clicking on the field name.
Hover over the
Time Spentbar and look at what queries are spending the most time on.
Sort on CPU, Memory, and Network, respectively to identify other resource-intensive queries.
Distinguish query shapes that may be resource-intensive due to having a high
run countcompared to others.
Is a query using resources because of how many times it has been executed, or is it using a large number of resources across a low number of executions?
activity_of queries that have high elapsed time, run count, and/or that are using a lot of a given resource.
Click on the Nodes tab to identify which node these queries are running on.
The Nodes tab can also help to confirm why a given node is running slowly.
Last modified: June 28, 2023