Environment - AEM 6.3 GA
Solution:
Go to the Felix console URL: http://localhost:4502/system/console/jmx/org.apache.jackrabbit.oak%3Aname%3DOak+Query+Statistics%2Ctype%3DQueryStat
You can observe the top 15 popular queries as shown in below screenshot.
Top 15 Slow Queries tweak slow queries/rewrite slow queries for better performance or create indexes for those slow queries.
Go to the Felix console URL: http://localhost:4502/system/console/jmx/org.apache.jackrabbit.oak%3Aname%3DOak+Query+Statistics%2Ctype%3DQueryStat
You can observe the top 15 popular queries as shown in below screenshot.
Top 15 Slow Queries tweak slow queries/rewrite slow queries for better performance or create indexes for those slow queries.
Below is the screenshot to clear popular and slow queries, Click on each of the below Operation and click on invoke.
No comments:
Post a Comment
If you have any doubts or questions, please let us know.