Thanks sunjot.Rebuilding the clientlibs did not help and no errors in the console. Adding the log here for the explain query:
{
"statement": "SELECT * FROM [cq:Page] AS p WHERE ISDESCENDANTNODE([/conf]) AND p.[jcr:path] LIKE '/conf/%/settings/wcm/templates' ORDER BY [jcr:path]",
"language": "JCR-SQL2",
"explain": {
"logs": [
"Parsing JCR-SQL2 statement: explain SELECT * FROM [cq:Page] AS p WHERE ISDESCENDANTNODE([/conf]) AND p.[jcr:path] LIKE '/conf/%/settings/wcm/templates' ORDER BY [jcr:path]\n",
"Execute JCR-SQL2 / explain SELECT * FROM [cq:Page] AS p WHERE ISDESCENDANTNODE([/conf]) AND p.[jcr:path] LIKE '/conf/%/settings/wcm/templates' ORDER BY [jcr:path]\n",
"Literal used\n",
"Attempting optimisation\n",
"cost using filter Filter(query=explain SELECT * FROM [cq:Page] AS p WHERE ISDESCENDANTNODE([/conf]) AND p.[jcr:path] LIKE '/conf/%/settings/wcm/templates' ORDER BY [jcr:path], path=/conf//*)\n",
"cost for reference is Infinity\n",
"cost for property is Infinity\n",
"cost for nodeType is Infinity\n",
"Ignoring index [/oak:index/slingeventJob] which is not working correctly since 16.66 d ,0 indexing cycles, accessed 32900 times\n",
"Evaluating plan with index definition Lucene Index : /oak:index/versionStoreIndex\n",
"Applicable IndexingRule found IndexRule: nt:base\n",
"Evaluating plan with index definition Lucene Index : /oak:index/cqTagLucene\n",
"No applicable IndexingRule found for any of the superTypes [nt:hierarchyNode, cq:Page, nt:base, mix:created]\n",
"Evaluating plan with index definition Lucene Index : /oak:index/workflowDataLucene\n",
"No applicable IndexingRule found for any of the superTypes [nt:hierarchyNode, cq:Page, nt:base, mix:created]\n",
"Evaluating plan with index definition Lucene Index : /oak:index/socialLucene\n",
"No applicable IndexingRule found for any of the superTypes [nt:hierarchyNode, cq:Page, nt:base, mix:created]\n",
"Evaluating plan with index definition Lucene Index : /oak:index/authorizables\n",
"No applicable IndexingRule found for any of the superTypes [nt:hierarchyNode, cq:Page, nt:base, mix:created]\n",
"Evaluating plan with index definition Lucene Index : /oak:index/ntBaseLucene\n",
"Applicable IndexingRule found IndexRule: nt:base\n",
"Evaluating plan with index definition Lucene Index : /oak:index/nodetypeLucene\n",
"No applicable IndexingRule found for any of the superTypes [nt:hierarchyNode, cq:Page, nt:base, mix:created]\n",
"Evaluating plan with index definition Lucene Index : /oak:index/lucene\n",
"Applicable IndexingRule found IndexRule: nt:base\n",
"Evaluating plan with index definition Lucene Index : /oak:index/commerceLucene\n",
"Applicable IndexingRule found IndexRule: nt:base\n",
"Opting out due mismatch between path restriction /conf and query paths [/var/commerce]\n",
"Evaluating plan with index definition Lucene Index : /oak:index/enablementResourceName\n",
"Applicable IndexingRule found IndexRule: nt:base\n",
"Opting out due mismatch between path restriction /conf and query paths [/content]\n",
"Evaluating plan with index definition Lucene Index : /oak:index/cqReportsLucene\n",
"No applicable IndexingRule found for any of the superTypes [nt:hierarchyNode, cq:Page, nt:base, mix:created]\n",
"Evaluating plan with index definition Lucene Index : /oak:index/repTokenIndex\n",
"No applicable IndexingRule found for any of the superTypes [nt:hierarchyNode, cq:Page, nt:base, mix:created]\n",
"Evaluating plan with index definition Lucene Index : /oak:index/cqProjectLucene\n",
"No applicable IndexingRule found for any of the superTypes [nt:hierarchyNode, cq:Page, nt:base, mix:created]\n",
"Evaluating plan with index definition Lucene Index : /oak:index/cmLucene\n",
"No applicable IndexingRule found for any of the superTypes [nt:hierarchyNode, cq:Page, nt:base, mix:created]\n",
"Ignoring index [/oak:index/damAssetLucene] which is not working correctly since 16.66 d ,0 indexing cycles, accessed 27445 times\n",
"Evaluating plan with index definition Lucene Index : /oak:index/cqPageLucene\n",
"Applicable IndexingRule found IndexRule: cq:Page\n",
"cost for [/oak:index/cqPageLucene] of type (lucene-property) with plan [lucene:cqPageLucene(/oak:index/cqPageLucene) :ancestors:/conf] is 1601.00\n",
"cost for lucene-property[/oak:index/cqPageLucene] is 1601.0\n",
"cost for aggregate lucene is Infinity\n",
"looking for plans for paths : []\n",
"cost for aggregate solr is Infinity\n",
"cost for traverse is 2000.0\n",
"No alternatives found. Query: select [p].[jcr:primaryType] as [p.jcr:primaryType], [p].[jcr:createdBy] as [p.jcr:createdBy], [p].[jcr:created] as [p.jcr:created] from [cq:Page] as [p] where (isdescendantnode([p], [/conf])) and ([p].[jcr:path] like '/conf/%/settings/wcm/templates') order by [p].[jcr:path] ASCENDING\n",
"query:\texplain SELECT * FROM [cq:Page] AS p WHERE ISDESCENDANTNODE([/conf]) AND p.[jcr:path] LIKE '/conf/%/settings/wcm/templates' ORDER BY [jcr:path]\n",
"count:\t1\tquery:\texplain SELECT * FROM [cq:Page] AS p WHERE ISDESCENDANTNODE('x') AND p.[jcr:path] LIKE 'x' ORDER BY [jcr:path]\n"
],
"plan": "[cq:Page] as [p] /* lucene:cqPageLucene(/oak:index/cqPageLucene) :ancestors:/conf where (isdescendantnode([p], [/conf])) and ([p].[jcr:path] like '/conf/%/settings/wcm/templates') */",
"propertyIndexes": [
"cqPageLucene(/oak:index/cqPageLucene)"
]
},
"heuristics": {
"count": 0,
"countTime": 2,
"executionTime": 4,
"getNodesTime": 1,
"totalTime": 7
}
}
