Menu Performance - Slow SQLs

The module allows you to display grouped statistics of queries in a given period of time. The screen provides an option to filter queries for which the total time in a given period was greater than the value of the Min. elapsed execution time parameter.
An example showing the statistics of queries in a month period whose Elapsed Time is above 2000 seconds.


Once the query is selected, the content and query plan will be displayed. Unchecking the Group by plan option allows you to display summary statistics of the query for all its plan versions.

From the screen, you can easily add a query of interest for detailed analysis in SQL Details by clicking on the [Plus] button next to the query ID and selecting the option: