finally i found the way to get it from publisher:
Result on working server:
{ "statement": "/jcr:root/content//element(*, cq:PageContent)[(@sling:resourceType = 'my-site/components/articlepage/articlePage' and @cq:tags='NAMESPACE:Tag')] order by @publishDate descending", "language": "xpath", "explain": { "logs": [ "cost using filter Filter(query=explain select [jcr:path], [jcr:score], * from [cq:PageContent] as a where [sling:resourceType] = 'my-site/components/articlepage/articlePage' and [cq:tags] = 'NAMESPACE:Tag' and isdescendantnode(a, '/content') order by [publishDate] desc /* xpath: /jcr:root/content//element(*, cq:PageContent)[(@sling:resourceType = 'my-site/components/articlepage/articlePage' and @cq:tags='NAMESPACE:Tag')] order by @publishDate descending */, path=/content//*, property=[cq:tags=[NAMESPACE:Tag], sling:resourceType=[my-site/components/articlepage/articlePage]])", "cost for aggregate lucene is Infinity", "Evaluating plan with index definition Lucene Index : /oak:index/content-search-index", "Applicable IndexingRule found IndexRule: cq:PageContent", "Evaluating plan with index definition Lucene Index : cqTag(/oak:index/cqTagLucene)", "No applicable IndexingRule found for any of the superTypes [sling:VanityPath, sling:Resource, cq:ReplicationStatus, cq:OwnerTaggable, nt:unstructured, cq:Taggable, nt:base, cq:PageContent, mix:created, mix:title]", "Evaluating plan with index definition Lucene Index : workflow(/oak:index/workflowDataLucene)", "No applicable IndexingRule found for any of the superTypes [sling:VanityPath, sling:Resource, cq:ReplicationStatus, cq:OwnerTaggable, nt:unstructured, cq:Taggable, nt:base, cq:PageContent, mix:created, mix:title]", "Evaluating plan with index definition Lucene Index : authorizables(/oak:index/authorizables)", "No applicable IndexingRule found for any of the superTypes [sling:VanityPath, sling:Resource, cq:ReplicationStatus, cq:OwnerTaggable, nt:unstructured, cq:Taggable, nt:base, cq:PageContent, mix:created, mix:title]", "Evaluating plan with index definition Lucene Index : /oak:index/damAssetLucene", "No applicable IndexingRule found for any of the superTypes [sling:VanityPath, sling:Resource, cq:ReplicationStatus, cq:OwnerTaggable, nt:unstructured, cq:Taggable, nt:base, cq:PageContent, mix:created, mix:title]", "Evaluating plan with index definition Lucene Index : tags(/oak:index/ntBaseLucene)", "Applicable IndexingRule found IndexRule: nt:base", "Evaluating plan with index definition Lucene Index : /oak:index/lucene", "Index is old format. Not supported", "Evaluating plan with index definition Lucene Index : cq:Page(/oak:index/cqPageLucene)", "No applicable IndexingRule found for any of the superTypes [sling:VanityPath, sling:Resource, cq:ReplicationStatus, cq:OwnerTaggable, nt:unstructured, cq:Taggable, nt:base, cq:PageContent, mix:created, mix:title]", "cost for lucene-property[/oak:index/content-search-index] is 334.3333333333333", "cost for reference is Infinity", "getPlans(Filter, List<OrderEntry>, NodeState)", "getPlans() - filter: Filter(query=explain select [jcr:path], [jcr:score], * from [cq:PageContent] as a where [sling:resourceType] = 'my-site/components/articlepage/articlePage' and [cq:tags] = 'NAMESPACE:Tag' and isdescendantnode(a, '/content') order by [publishDate] desc /* xpath: /jcr:root/content//element(*, cq:PageContent)[(@sling:resourceType = 'my-site/components/articlepage/articlePage' and @cq:tags='NAMESPACE:Tag')] order by @publishDate descending */, path=/content//*, property=[cq:tags=[NAMESPACE:Tag], sling:resourceType=[my-site/components/articlepage/articlePage]]) - ", "getPlans() - sortOrder: [{ propertyName : publishDate, propertyType : UNDEFINED, order : DESCENDING }] - ", "getPlans() - rootState: { jcr:primaryType = rep:root, jcr:mixinTypes = [rep:RepoAccessControllable, rep:AccessControllable], sling:target = /index.html, sling:resourceType = sling:redirect, crx = { ... }, :async : { async-temp = [5b7c9b0c-af60-4db5-a899-8438ee62bccf, b5ab6fae-ac89-4cb9-92aa-488211131b3b], async = 5b7c9b0c-af60-4db5-a899-8438ee62bccf, async-LastIndexedTo = 2016-06-02T17:54:59.810Z }, tmp = { ... }, home = { ... }, :clusterConfig : { :clusterId = 5778ac61-a3c0-4232-a044-40eb7ab3c1dd }, oak:index = { ... }, conf = { ... }, jcr:system = { ... }, etc = { ... }, system = { ... }, content = { ... }, bin : { jcr:primaryType = nt:folder, jcr:mixinTypes = [mix:versionable], jcr:createdBy = admin, jcr:versionHistory = 46d5eb8b-8d69-4c9b-9591-4e0153d8f195, jcr:predecessors = [], jcr:created = 2015-12-29T19:17:19.078Z, jcr:baseVersion = f38fd84b-139e-4655-82cd-8782ad07643e, jcr:isCheckedOut = false, jcr:uuid = 40ed38c9-cb13-41dc-8602-0249e2c1b4c2 }, rep:policy = { ... }, libs = { ... }, rep:repoPolicy = { ... }, var = { ... }, apps = { ... } } - ", "cost for ordered is Infinity", "cost for nodeType is 3229.0", "property cost for slingResourceType is 1414.0", "cost for property is 1414.0", "cost for traverse is 1605100.0" ], "plan": "[cq:PageContent] as [a] /* lucene:content-search-index(/oak:index/content-search-index) +:ancestors:/content +cq:tags:NAMESPACE:Tag +sling:resourceType:my-site/components/articlepage/articlePage ordering:[{ propertyName : publishDate, propertyType : UNDEFINED, order : DESCENDING }] where ([a].[sling:resourceType] = 'my-site/components/articlepage/articlePage') and ([a].[cq:tags] = 'NAMESPACE:Tag') and (isdescendantnode([a], [/content])) */" }, "heuristics": { "executeTime": 2, "getNodesTime": 6, "count": 4843, "countTime": 341, "totalTime": 349 } }
