Follow the steps in this recipe to calculate the average execution time for multi-tier web requests:
- Log in to your Splunk server.
- Select the Operational Intelligence application.
- Ensure the time range picker is set to Last 24 Hours, and type the following search into the Splunk search bar. Then, click on the search button or hit Enter:
index=main sourcetype=access_combined | join JSESSIONID usetime=true earlier=false [ search index=main sourcetype=log4j | transaction threadId maxspan=5m | eval JSESSIONID=sessionId ] | stats avg(duration) AS Avg_Request_Execution_Time
- After a little while, Splunk will return a single value representing the average execution time in seconds for a complete web request on the website. ...