Starting from version 2.2, Studio Enterprise Edition includes a functionality called Profiling. To understand how Profiling works, please refer to the Profiler page.
In the above section you can choose the server in order to investigate queries executed on it and manage the local cache.
This panel shows all the queries executed on a specific server grouped by the command content. For each query the following information are reported:
Type, as the query type
Command, as the content of the query
Users, as the users who executed the query
Entries, as the number of times the query it was executed
Average, as the average required time by the queries
Total, as the total required time by all the queries
Max, as the maximum required time
Min, as the minimum required time
Last, as the time required by the last query
Last execution, as the timestamp of the last query execution
Through this panel you can manage the cache of the specific server and consult the cached results of queries by using the
VIEW RESULTS button.
You can even filter the queries by the "Query" field and purge the whole cache by using the
PURGE CACHE button.