Request Log Analyzer to find the top 10 expensive queries in AEM 6.4

Statement : Analyzes the current request log in order to identify the most expensive requests in a given period.

Solution :

• Go to this path http://localhost:4502/etc/reports/healthcheck.html 
• Enter the below details as per screenshot

                - The last number of hours from now to be analyzed - Enter the hours since when

                 - Limit output to the specified number of lines. 

                 - Analyze up to the specified number of requests (-1 meaning all)

•  You can run the request log analyzer on daily basis to check the expensive requests and have automated mail alert to email box , Make sure SMTP is configured to receive the mail alerts of the request log report
•  Also you can configure the run time of script on daily basis for auto run and get the automated email.
• Below screenshot shows the top expensive queries and further you can investigate on these queries as required

• If you don't configure the SMTP and trying to configure your email id for auto alert. you will see the below error. make sure SMTP is configured.

• Request to Analyze 10 request for first 1 hour as show in the below screenshot.