Slow Queries Development Tools in AEM

Query Development Tools

Adobe Supported

• Query Builder Debugger 
  • A WebUI for executing Query Builder queries and generate the supporting XPath (for use in Explain Query or Oak Index Definition Generator).
  • Located on AEM at /libs/cq/search/content/querydebug.html
• CRXDE Lite - Query Tool
  • A WebUI for executing XPath and JCR-SQL2 queries.
  • Located on AEM at /crx/de/index.jsp > Tools > Query...
• Explain Query
  • An AEM Operations dashboard that provides a detailed explanation (Query plan, query time, and # of results) for any given XPATH or JCR-SQL2 query.
• Slow/Popular Queries
  • An AEM Operations dashboard listing the recent slow and popular queries executed on AEM.
• Index Manager
  • An AEM Operations WebUI displaying the indexes on the AEM instance; facilitates understanding what indexes already exist, can be targeted or augmented.
• Logging
  • Query Builder logging
    • DEBUG @ com.day.cq.search.impl.builder.QueryImpl
  • Oak query execution logging
    • DEBUG @ org.apache.jackrabbit.oak.query
• Apache Jackrabbit Query Engine Settings OSGi Config
  • OSGi configuration that configures failure behavior for traversing queries.
  • Located on AEM at /system/console/configMgr#org.apache.jackrabbit.oak.query.QueryEngineSettingsService
• NodeCounter JMX Mbean
  • JMX MBean used to estimate the number of nodes in content trees in AEM.
  • Located on AEM at /system/console/jmx/org.apache.jackrabbit.oak%3Aname%3DnodeCounter%2Ctype%3DNodeCounter

Community Supported

• Oak Index Definition Generator
  • Generate optimal Lucence Property Index from XPath or JCR-SQL2 query statements.
• AEM Chrome Plug-in
  • Google Chrome web browser extension that exposes per-request log data, including executed queries and their query plans, in the browser's dev tools console.
  • Requires Sling Log Tracer 1.0.2+ to be installed and enabled on AEM.