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.