Identify the Slowest Pieces of Code

Highest Execution Time

Identify the slowest procedures, functions or triggers executed.

1. Select the root of the procedures, functions or triggers
2. Click "Highest execution time", from the ribbon or the navigation bar
3. The slowest procedures are listed, based on their average execution time.

This feature comes with 2 parameters to let you customize it (click the small wrench on the right to set them):

• Number of procedures displayed in the result (20 by default)
• Minimum execution time, to show only procedures with a significant response time

Total Execution Time:

Calculate the total execution time for each procedure, function or trigger,
by calculating the Average execution time x Number of times it is executed.

The Highest Execution Time feature lets you identify the slowest functions,
but a slow response time is not necessarily critical if the corresponding functions are rarely used.

Actually, to properly assess the criticality of this problem, you must take into account how frequently each function is actually executed.

This feature comes with 2 parameters to let you customize the result (click the small wrench on the right to set them):

• Number of functions displayed in the result (20 by default)
• Minimum execution time, to view only functions with a significant response time