RAM Usage, CPU Usage and Mean Execution Time by Query

Help
#1

Hello,

I need to know if there’s a way to query information about RAM Usage, CPU Usage and Mean Execution Time for every SQL query executed on SingleStore.

Thanks.

#2

You can get that information from mv_activities_extended.

1 Like
#3

I executed a simple select * from a table I have and then tried to execute this query:

SELECT queries.query_text FROM information_schema.mv_activities_extended AS activities
JOIN information_schema.mv_queries AS queries
WHERE activities.activity_name = queries.activity_name;

But for some reason it didn’t show the select all query, any idea why this happened ?

#4

Can someone help me with my issue ?