Initial request refers unknown (to me) query parser {!simpleFilter, I
can't comment on it.
Parsing queries took in millis: - time: 261, usually prepare for query
takes a moment. I suspect the box is really slow per se or encounter heavy
load.
And then facets took about 6 times more - facet_module: { - time: 1122,
that a reasonable ratio.
I also notice limit: -1 that's really expensive usually. If tweaking can't
help, only profiling might give a clue.
Note: in 8.5 there will be uniqueBlockQuery() operation, which is expected
to be faster than uniqueBlock()
On Wed, Jan 22, 2020 at 5:36 PM kumar gaurav <kg2...@gmail.com> wrote:
> HI Mikhail
>
> Here is full debug log . Please have a look .
>
> debug:
> {
>
> - rawquerystring:
> "{!parent tag=top which=$pq filters=$child.fq score=max v=$cq}",
> - querystring:
> "{!parent tag=top which=$pq filters=$child.fq score=max v=$cq}",
> - parsedquery:
> "AllParentsAware(ToParentBlockJoinQuery (+(+docType:sku
> +(store_873:1)^0.0) #(filter(color_refine:Black)
> filter(color_refine:Blue))))"
> ,
> - parsedquery_toString:
> "ToParentBlockJoinQuery (+(+docType:sku +(store_873:1)^0.0)
> #(filter(color_refine:Black) filter(color_refine:Blue)))"
> ,
> - explain:
> {
> - 5172: "
> 1.0 = Score based on 240 child docs in range from 2572484 to
> 2573162, best match:
> 1.0 = sum of: 1.0 = sum of: 1.0 = docType:sku
> 0.0 = ConstantScore(store_873:1)^0.0
> 0.0 = match on required clause, product of: 0.0 = # clause
> 0.0 = sum of: 0.0 =
> ConstantScore(BitSetDocTopFilter)^0.0 "
> ,
> - 5178: "
> 1.0 = Score based on 304 child docs in range from 2571860 to
> 2572404, best match:
> 1.0 = sum of: 1.0 = sum of: 1.0 = docType:sku
> 0.0 = ConstantScore(store_873:1)^0.0
> 0.0 = match on required clause, product of: 0.0 = # clause
> 0.0 = sum of: 0.0 =
> ConstantScore(BitSetDocTopFilter)^0.0 "
> ,
> - 9301: "
> 1.0 = Score based on 93 child docs in range from 710150 to
> 710796, best match:
> 1.0 = sum of: 1.0 = sum of: 1.0 = docType:sku
> 0.0 = ConstantScore(store_873:1)^0.0
> 0.0 = match on required clause, product of: 0.0 = # clause
> 0.0 = sum of: 0.0 =
> ConstantScore(BitSetDocTopFilter)^0.0 "
> ,
> - 118561: "
> 1.0 = Score based on 177 child docs in range from 5728215 to
> 5728505, best match:
> 1.0 = sum of: 1.0 = sum of: 1.0 = docType:sku
> 0.0 = ConstantScore(store_873:1)^0.0
> 0.0 = match on required clause, product of: 0.0 = # clause
> 0.0 = sum of: 0.0 =
> ConstantScore(BitSetDocTopFilter)^0.0 "
> ,
> - 266659: "
> 1.0 = Score based on 89 child docs in range from 5368923 to
> 5369396, best match:
> 1.0 = sum of: 1.0 = sum of: 1.0 = docType:sku
> 0.0 = ConstantScore(store_873:1)^0.0
> 0.0 = match on required clause, product of: 0.0 = # clause
> 0.0 = sum of: 0.0 =
> ConstantScore(BitSetDocTopFilter)^0.0 "
> ,
> - 323407: "
> 1.0 = Score based on 321 child docs in range from 4807493 to
> 4808441, best match:
> 1.0 = sum of: 1.0 = sum of: 1.0 = docType:sku
> 0.0 = ConstantScore(store_873:1)^0.0
> 0.0 = match on required clause, product of: 0.0 = # clause
> 0.0 = sum of: 0.0 =
> ConstantScore(BitSetDocTopFilter)^0.0 "
> ,
> - 381312: "
> 1.0 = Score based on 232 child docs in range from 2660717 to
> 2661101, best match:
> 1.0 = sum of: 1.0 = sum of: 1.0 = docType:sku
> 0.0 = ConstantScore(store_873:1)^0.0
> 0.0 = match on required clause, product of: 0.0 = # clause
> 0.0 = sum of: 0.0 =
> ConstantScore(BitSetDocTopFilter)^0.0 "
> ,
> - 851246: "
> 1.0 = Score based on 61 child docs in range from 730259 to
> 730562, best match:
> 1.0 = sum of: 1.0 = sum of: 1.0 = docType:sku
> 0.0 = ConstantScore(store_873:1)^0.0
> 0.0 = match on required clause, product of: 0.0 = # clause
> 0.0 = sum of: 0.0 =
> ConstantScore(BitSetDocTopFilter)^0.0 "
> ,
> - 1564330: "
> 1.0 = Score based on 12 child docs in range from 6831792 to
> 6832154, best match:
> 1.0 = sum of: 1.0 = sum of: 1.0 = docType:sku
> 0.0 = ConstantScore(store_873:1)^0.0
> 0.0 = match on required clause, product of: 0.0 = # clause
> 0.0 = sum of: 0.0 =
> ConstantScore(BitSetDocTopFilter)^0.0 "
> ,
> - 1695762: "
> 1.0 = Score based on 157 child docs in range from 5155397 to
> 5156414, best match:
> 1.0 = sum of: 1.0 = sum of: 1.0 = docType:sku
> 0.0 = ConstantScore(store_873:1)^0.0
> 0.0 = match on required clause, product of: 0.0 = # clause
> 0.0 = sum of: 0.0 =
> ConstantScore(BitSetDocTopFilter)^0.0 "
> ,
> - 1728758: "
> 1.0 = Score based on 4 child docs in range from 5108617 to
> 5108632, best match:
> 1.0 = sum of: 1.0 = sum of: 1.0 = docType:sku
> 0.0 = ConstantScore(store_873:1)^0.0
> 0.0 = match on required clause, product of: 0.0 = # clause
> 0.0 = sum of: 0.0 =
> ConstantScore(BitSetDocTopFilter)^0.0 "
> ,
> - 1730721: "
> 1.0 = Score based on 34 child docs in range from 5097552 to
> 5097808, best match:
> 1.0 = sum of: 1.0 = sum of: 1.0 = docType:sku
> 0.0 = ConstantScore(store_873:1)^0.0
> 0.0 = match on required clause, product of: 0.0 = # clause
> 0.0 = sum of: 0.0 =
> ConstantScore(BitSetDocTopFilter)^0.0 "
> ,
> - 1731442: "
> 1.0 = Score based on 60 child docs in range from 5094932 to
> 5095562, best match:
> 1.0 = sum of: 1.0 = sum of: 1.0 = docType:sku
> 0.0 = ConstantScore(store_873:1)^0.0
> 0.0 = match on required clause, product of: 0.0 = # clause
> 0.0 = sum of: 0.0 =
> ConstantScore(BitSetDocTopFilter)^0.0 "
> ,
> - 1731513: "
> 1.0 = Score based on 45 child docs in range from 5093701 to
> 5094098, best match:
> 1.0 = sum of: 1.0 = sum of: 1.0 = docType:sku
> 0.0 = ConstantScore(store_873:1)^0.0
> 0.0 = match on required clause, product of: 0.0 = # clause
> 0.0 = sum of: 0.0 =
> ConstantScore(BitSetDocTopFilter)^0.0 "
> ,
> - 1732190: "
> 1.0 = Score based on 25 child docs in range from 5087456 to
> 5087663, best match:
> 1.0 = sum of: 1.0 = sum of: 1.0 = docType:sku
> 0.0 = ConstantScore(store_873:1)^0.0
> 0.0 = match on required clause, product of: 0.0 = # clause
> 0.0 = sum of: 0.0 =
> ConstantScore(BitSetDocTopFilter)^0.0 "
> ,
> - 1944597: "
> 1.0 = Score based on 14 child docs in range from 310637 to
> 310761, best match:
> 1.0 = sum of: 1.0 = sum of: 1.0 = docType:sku
> 0.0 = ConstantScore(store_873:1)^0.0
> 0.0 = match on required clause, product of: 0.0 = # clause
> 0.0 = sum of: 0.0 =
> ConstantScore(BitSetDocTopFilter)^0.0 "
> ,
> - 1989834: "
> 1.0 = Score based on 761 child docs in range from 276442 to
> 277686, best match:
> 1.0 = sum of: 1.0 = sum of: 1.0 = docType:sku
> 0.0 = ConstantScore(store_873:1)^0.0
> 0.0 = match on required clause, product of: 0.0 = # clause
> 0.0 = sum of: 0.0 =
> ConstantScore(BitSetDocTopFilter)^0.0 "
> ,
> - 2375536: "
> 1.0 = Score based on 79 child docs in range from 6142157 to
> 6142944, best match:
> 1.0 = sum of: 1.0 = sum of: 1.0 = docType:sku
> 0.0 = ConstantScore(store_873:1)^0.0
> 0.0 = match on required clause, product of: 0.0 = # clause
> 0.0 = sum of: 0.0 =
> ConstantScore(BitSetDocTopFilter)^0.0 "
> ,
> - 2616122: "
> 1.0 = Score based on 19 child docs in range from 5489872 to
> 5490024, best match:
> 1.0 = sum of: 1.0 = sum of: 1.0 = docType:sku
> 0.0 = ConstantScore(store_873:1)^0.0
> 0.0 = match on required clause, product of: 0.0 = # clause
> 0.0 = sum of: 0.0 =
> ConstantScore(BitSetDocTopFilter)^0.0 "
> ,
> - 2689457: "
> 1.0 = Score based on 13 child docs in range from 5309377 to
> 5309538, best match:
> 1.0 = sum of: 1.0 = sum of: 1.0 = docType:sku
> 0.0 = ConstantScore(store_873:1)^0.0
> 0.0 = match on required clause, product of: 0.0 = # clause
> 0.0 = sum of: 0.0 =
> ConstantScore(BitSetDocTopFilter)^0.0 "
> ,
> - 2784916: "
> 1.0 = Score based on 24 child docs in range from 4040314 to
> 4040401, best match:
> 1.0 = sum of: 1.0 = sum of: 1.0 = docType:sku
> 0.0 = ConstantScore(store_873:1)^0.0
> 0.0 = match on required clause, product of: 0.0 = # clause
> 0.0 = sum of: 0.0 =
> ConstantScore(BitSetDocTopFilter)^0.0 "
> ,
> - 2817779: "
> 1.0 = Score based on 28 child docs in range from 3958922 to
> 3960019, best match:
> 1.0 = sum of: 1.0 = sum of: 1.0 = docType:sku
> 0.0 = ConstantScore(store_873:1)^0.0
> 0.0 = match on required clause, product of: 0.0 = # clause
> 0.0 = sum of: 0.0 =
> ConstantScore(BitSetDocTopFilter)^0.0 "
> ,
> - 2861368: "
> 1.0 = Score based on 22 child docs in range from 2381681 to
> 2381809, best match:
> 1.0 = sum of: 1.0 = sum of: 1.0 = docType:sku
> 0.0 = ConstantScore(store_873:1)^0.0
> 0.0 = match on required clause, product of: 0.0 = # clause
> 0.0 = sum of: 0.0 =
> ConstantScore(BitSetDocTopFilter)^0.0 "
> ,
> - 2873186: "
> 1.0 = Score based on 3 child docs in range from 2349642 to
> 2349702, best match:
> 1.0 = sum of: 1.0 = sum of: 1.0 = docType:sku
> 0.0 = ConstantScore(store_873:1)^0.0
> 0.0 = match on required clause, product of: 0.0 = # clause
> 0.0 = sum of: 0.0 =
> ConstantScore(BitSetDocTopFilter)^0.0 "
> ,
> - 2946661: "
> 1.0 = Score based on 32 child docs in range from 2127883 to
> 2128109, best match:
> 1.0 = sum of: 1.0 = sum of: 1.0 = docType:sku
> 0.0 = ConstantScore(store_873:1)^0.0
> 0.0 = match on required clause, product of: 0.0 = # clause
> 0.0 = sum of: 0.0 =
> ConstantScore(BitSetDocTopFilter)^0.0 "
> ,
> - 3022498: "
> 1.0 = Score based on 70 child docs in range from 4301041 to
> 4301652, best match:
> 1.0 = sum of: 1.0 = sum of: 1.0 = docType:sku
> 0.0 = ConstantScore(store_873:1)^0.0
> 0.0 = match on required clause, product of: 0.0 = # clause
> 0.0 = sum of: 0.0 =
> ConstantScore(BitSetDocTopFilter)^0.0 "
> ,
> - 3040746: "
> 1.0 = Score based on 140 child docs in range from 4237473 to
> 4238188, best match:
> 1.0 = sum of: 1.0 = sum of: 1.0 = docType:sku
> 0.0 = ConstantScore(store_873:1)^0.0
> 0.0 = match on required clause, product of: 0.0 = # clause
> 0.0 = sum of: 0.0 =
> ConstantScore(BitSetDocTopFilter)^0.0 "
> ,
> - 3084682: "
> 1.0 = Score based on 4 child docs in range from 1669672 to
> 1669707, best match:
> 1.0 = sum of: 1.0 = sum of: 1.0 = docType:sku
> 0.0 = ConstantScore(store_873:1)^0.0
> 0.0 = match on required clause, product of: 0.0 = # clause
> 0.0 = sum of: 0.0 =
> ConstantScore(BitSetDocTopFilter)^0.0 "
> ,
> - 3085032: "
> 1.0 = Score based on 3 child docs in range from 1667821 to
> 1667844, best match:
> 1.0 = sum of: 1.0 = sum of: 1.0 = docType:sku
> 0.0 = ConstantScore(store_873:1)^0.0
> 0.0 = match on required clause, product of: 0.0 = # clause
> 0.0 = sum of: 0.0 =
> ConstantScore(BitSetDocTopFilter)^0.0 "
> ,
> - 3091571: "
> 1.0 = Score based on 24 child docs in range from 1646924 to
> 1647331, best match:
> 1.0 = sum of: 1.0 = sum of: 1.0 = docType:sku
> 0.0 = ConstantScore(store_873:1)^0.0
> 0.0 = match on required clause, product of: 0.0 = # clause
> 0.0 = sum of: 0.0 =
> ConstantScore(BitSetDocTopFilter)^0.0 "
> ,
> - 3404073: "
> 1.0 = Score based on 9 child docs in range from 2852367 to
> 2852436, best match:
> 1.0 = sum of: 1.0 = sum of: 1.0 = docType:sku
> 0.0 = ConstantScore(store_873:1)^0.0
> 0.0 = match on required clause, product of: 0.0 = # clause
> 0.0 = sum of: 0.0 =
> ConstantScore(BitSetDocTopFilter)^0.0 "
> ,
> - 3417777: "
> 1.0 = Score based on 6 child docs in range from 2805995 to
> 2806022, best match:
> 1.0 = sum of: 1.0 = sum of: 1.0 = docType:sku
> 0.0 = ConstantScore(store_873:1)^0.0
> 0.0 = match on required clause, product of: 0.0 = # clause
> 0.0 = sum of: 0.0 =
> ConstantScore(BitSetDocTopFilter)^0.0 "
> ,
> - 3438255: "
> 1.0 = Score based on 2 child docs in range from 2051209 to
> 2051210, best match:
> 1.0 = sum of: 1.0 = sum of: 1.0 = docType:sku
> 0.0 = ConstantScore(store_873:1)^0.0
> 0.0 = match on required clause, product of: 0.0 = # clause
> 0.0 = sum of: 0.0 =
> ConstantScore(BitSetDocTopFilter)^0.0 "
> ,
> - 3478728: "
> 1.0 = Score based on 4 child docs in range from 1981328 to
> 1981344, best match:
> 1.0 = sum of: 1.0 = sum of: 1.0 = docType:sku
> 0.0 = ConstantScore(store_873:1)^0.0
> 0.0 = match on required clause, product of: 0.0 = # clause
> 0.0 = sum of: 0.0 =
> ConstantScore(BitSetDocTopFilter)^0.0 "
> ,
> - 3583992: "
> 1.0 = Score based on 5 child docs in range from 3374843 to
> 3375002, best match:
> 1.0 = sum of: 1.0 = sum of: 1.0 = docType:sku
> 0.0 = ConstantScore(store_873:1)^0.0
> 0.0 = match on required clause, product of: 0.0 = # clause
> 0.0 = sum of: 0.0 =
> ConstantScore(BitSetDocTopFilter)^0.0 "
> ,
> - 3589850: "
> 1.0 = Score based on 47 child docs in range from 3361030 to
> 3361178, best match:
> 1.0 = sum of: 1.0 = sum of: 1.0 = docType:sku
> 0.0 = ConstantScore(store_873:1)^0.0
> 0.0 = match on required clause, product of: 0.0 = # clause
> 0.0 = sum of: 0.0 =
> ConstantScore(BitSetDocTopFilter)^0.0 "
> ,
> - 3665911: "
> 1.0 = Score based on 1 child docs in range from 3796838 to
> 3796840, best match:
> 1.0 = sum of: 1.0 = sum of: 1.0 = docType:sku
> 0.0 = ConstantScore(store_873:1)^0.0
> 0.0 = match on required clause, product of: 0.0 = # clause
> 0.0 = sum of: 0.0 =
> ConstantScore(BitSetDocTopFilter)^0.0 "
> ,
> - 3665931: "
> 1.0 = Score based on 2 child docs in range from 3796740 to
> 3796744, best match:
> 1.0 = sum of: 1.0 = sum of: 1.0 = docType:sku
> 0.0 = ConstantScore(store_873:1)^0.0
> 0.0 = match on required clause, product of: 0.0 = # clause
> 0.0 = sum of: 0.0 =
> ConstantScore(BitSetDocTopFilter)^0.0 "
> ,
> - 3674970: "
> 1.0 = Score based on 22 child docs in range from 3765599 to
> 3765916, best match:
> 1.0 = sum of: 1.0 = sum of: 1.0 = docType:sku
> 0.0 = ConstantScore(store_873:1)^0.0
> 0.0 = match on required clause, product of: 0.0 = # clause
> 0.0 = sum of: 0.0 =
> ConstantScore(BitSetDocTopFilter)^0.0 "
> ,
> - 3681635: "
> 1.0 = Score based on 14 child docs in range from 3741477 to
> 3741644, best match:
> 1.0 = sum of: 1.0 = sum of: 1.0 = docType:sku
> 0.0 = ConstantScore(store_873:1)^0.0
> 0.0 = match on required clause, product of: 0.0 = # clause
> 0.0 = sum of: 0.0 =
> ConstantScore(BitSetDocTopFilter)^0.0 "
> ,
> - 3719278: "
> 1.0 = Score based on 74 child docs in range from 3635161 to
> 3635475, best match:
> 1.0 = sum of: 1.0 = sum of: 1.0 = docType:sku
> 0.0 = ConstantScore(store_873:1)^0.0
> 0.0 = match on required clause, product of: 0.0 = # clause
> 0.0 = sum of: 0.0 =
> ConstantScore(BitSetDocTopFilter)^0.0 "
> ,
> - 3721932: "
> 1.0 = Score based on 6 child docs in range from 3623696 to
> 3623846, best match:
> 1.0 = sum of: 1.0 = sum of: 1.0 = docType:sku
> 0.0 = ConstantScore(store_873:1)^0.0
> 0.0 = match on required clause, product of: 0.0 = # clause
> 0.0 = sum of: 0.0 =
> ConstantScore(BitSetDocTopFilter)^0.0 "
> ,
> - 3746624: "
> 1.0 = Score based on 11 child docs in range from 3558822 to
> 3558917, best match:
> 1.0 = sum of: 1.0 = sum of: 1.0 = docType:sku
> 0.0 = ConstantScore(store_873:1)^0.0
> 0.0 = match on required clause, product of: 0.0 = # clause
> 0.0 = sum of: 0.0 =
> ConstantScore(BitSetDocTopFilter)^0.0 "
> ,
> - 3770890: "
> 1.0 = Score based on 11 child docs in range from 3477177 to
> 3477278, best match:
> 1.0 = sum of: 1.0 = sum of: 1.0 = docType:sku
> 0.0 = ConstantScore(store_873:1)^0.0
> 0.0 = match on required clause, product of: 0.0 = # clause
> 0.0 = sum of: 0.0 =
> ConstantScore(BitSetDocTopFilter)^0.0 "
> ,
> - 3776680: "
> 1.0 = Score based on 14 child docs in range from 2765582 to
> 2765659, best match:
> 1.0 = sum of: 1.0 = sum of: 1.0 = docType:sku
> 0.0 = ConstantScore(store_873:1)^0.0
> 0.0 = match on required clause, product of: 0.0 = # clause
> 0.0 = sum of: 0.0 =
> ConstantScore(BitSetDocTopFilter)^0.0 "
> ,
> - 3781963: "
> 1.0 = Score based on 4 child docs in range from 2743197 to
> 2743227, best match:
> 1.0 = sum of: 1.0 = sum of: 1.0 = docType:sku
> 0.0 = ConstantScore(store_873:1)^0.0
> 0.0 = match on required clause, product of: 0.0 = # clause
> 0.0 = sum of: 0.0 =
> ConstantScore(BitSetDocTopFilter)^0.0 "
> ,
> - 3785704: "
> 1.0 = Score based on 20 child docs in range from 2736712 to
> 2736789, best match:
> 1.0 = sum of: 1.0 = sum of: 1.0 = docType:sku
> 0.0 = ConstantScore(store_873:1)^0.0
> 0.0 = match on required clause, product of: 0.0 = # clause
> 0.0 = sum of: 0.0 =
> ConstantScore(BitSetDocTopFilter)^0.0 "
> ,
> - 3800445: "
> 1.0 = Score based on 133 child docs in range from 2693268 to
> 2693522, best match:
> 1.0 = sum of: 1.0 = sum of: 1.0 = docType:sku
> 0.0 = ConstantScore(store_873:1)^0.0
> 0.0 = match on required clause, product of: 0.0 = # clause
> 0.0 = sum of: 0.0 =
> ConstantScore(BitSetDocTopFilter)^0.0 "
> ,
> - 3804448: "
> 1.0 = Score based on 3 child docs in range from 2679999 to
> 2680028, best match:
> 1.0 = sum of: 1.0 = sum of: 1.0 = docType:sku
> 0.0 = ConstantScore(store_873:1)^0.0
> 0.0 = match on required clause, product of: 0.0 = # clause
> 0.0 = sum of: 0.0 =
> ConstantScore(BitSetDocTopFilter)^0.0 "
> ,
> - 3829927: "
> 1.0 = Score based on 1 child docs in range from 2509568 to
> 2509568, best match:
> 1.0 = sum of: 1.0 = sum of: 1.0 = docType:sku
> 0.0 = ConstantScore(store_873:1)^0.0
> 0.0 = match on required clause, product of: 0.0 = # clause
> 0.0 = sum of: 0.0 =
> ConstantScore(BitSetDocTopFilter)^0.0 "
> ,
> - 3831655: "
> 1.0 = Score based on 3 child docs in range from 2505494 to
> 2505499, best match:
> 1.0 = sum of: 1.0 = sum of: 1.0 = docType:sku
> 0.0 = ConstantScore(store_873:1)^0.0
> 0.0 = match on required clause, product of: 0.0 = # clause
> 0.0 = sum of: 0.0 =
> ConstantScore(BitSetDocTopFilter)^0.0 "
> ,
> - 3845656: "
> 1.0 = Score based on 2 child docs in range from 2476141 to
> 2476152, best match:
> 1.0 = sum of: 1.0 = sum of: 1.0 = docType:sku
> 0.0 = ConstantScore(store_873:1)^0.0
> 0.0 = match on required clause, product of: 0.0 = # clause
> 0.0 = sum of: 0.0 =
> ConstantScore(BitSetDocTopFilter)^0.0 "
> ,
> - 3854170: "
> 1.0 = Score based on 8 child docs in range from 2448313 to
> 2448442, best match:
> 1.0 = sum of: 1.0 = sum of: 1.0 = docType:sku
> 0.0 = ConstantScore(store_873:1)^0.0
> 0.0 = match on required clause, product of: 0.0 = # clause
> 0.0 = sum of: 0.0 =
> ConstantScore(BitSetDocTopFilter)^0.0 "
> ,
> - 3870437: "
> 1.0 = Score based on 1 child docs in range from 1354370 to
> 1354373, best match:
> 1.0 = sum of: 1.0 = sum of: 1.0 = docType:sku
> 0.0 = ConstantScore(store_873:1)^0.0
> 0.0 = match on required clause, product of: 0.0 = # clause
> 0.0 = sum of: 0.0 =
> ConstantScore(BitSetDocTopFilter)^0.0 "
> ,
> - 3876209: "
> 1.0 = Score based on 1 child docs in range from 1336247 to
> 1336247, best match:
> 1.0 = sum of: 1.0 = sum of: 1.0 = docType:sku
> 0.0 = ConstantScore(store_873:1)^0.0
> 0.0 = match on required clause, product of: 0.0 = # clause
> 0.0 = sum of: 0.0 =
> ConstantScore(BitSetDocTopFilter)^0.0 "
> ,
> - 3876366: "
> 1.0 = Score based on 1 child docs in range from 1335318 to
> 1335318, best match:
> 1.0 = sum of: 1.0 = sum of: 1.0 = docType:sku
> 0.0 = ConstantScore(store_873:1)^0.0
> 0.0 = match on required clause, product of: 0.0 = # clause
> 0.0 = sum of: 0.0 =
> ConstantScore(BitSetDocTopFilter)^0.0 "
> ,
> - 3893661: "
> 1.0 = Score based on 19 child docs in range from 1287720 to
> 1287779, best match:
> 1.0 = sum of: 1.0 = sum of: 1.0 = docType:sku
> 0.0 = ConstantScore(store_873:1)^0.0
> 0.0 = match on required clause, product of: 0.0 = # clause
> 0.0 = sum of: 0.0 =
> ConstantScore(BitSetDocTopFilter)^0.0 "
> ,
> - 3894925: "
> 1.0 = Score based on 1 child docs in range from 1284318 to
> 1284318, best match:
> 1.0 = sum of: 1.0 = sum of: 1.0 = docType:sku
> 0.0 = ConstantScore(store_873:1)^0.0
> 0.0 = match on required clause, product of: 0.0 = # clause
> 0.0 = sum of: 0.0 =
> ConstantScore(BitSetDocTopFilter)^0.0 "
> ,
> - 3911561: "
> 1.0 = Score based on 2 child docs in range from 1227763 to
> 1227768, best match:
> 1.0 = sum of: 1.0 = sum of: 1.0 = docType:sku
> 0.0 = ConstantScore(store_873:1)^0.0
> 0.0 = match on required clause, product of: 0.0 = # clause
> 0.0 = sum of: 0.0 =
> ConstantScore(BitSetDocTopFilter)^0.0 "
> ,
> - 3941974: "
> 1.0 = Score based on 1 child docs in range from 1145356 to
> 1145356, best match:
> 1.0 = sum of: 1.0 = sum of: 1.0 = docType:sku
> 0.0 = ConstantScore(store_873:1)^0.0
> 0.0 = match on required clause, product of: 0.0 = # clause
> 0.0 = sum of: 0.0 =
> ConstantScore(BitSetDocTopFilter)^0.0 "
> ,
> },
> - facet-trace:
> {
> - processor: "FacetQueryProcessor",
> - elapse: 1122,
> - query: null,
> - domainSize: 98155,
> - sub-facet:
> [
> -
> {
> - processor: "FacetFieldProcessorByArrayDV",
> - elapse: 134,
> - field: "gender_refine",
> - limit: -1,
> - domainSize: 98155,
> - numBuckets: 11,
> },
> -
> {
> - processor: "FacetFieldProcessorByArrayDV",
> - elapse: 159,
> - field: "color_refine",
> - limit: -1,
> - domainSize: 98155,
> - numBuckets: 14,
> },
> -
> {
> - processor: "FacetFieldProcessorByArrayDV",
> - elapse: 128,
> - field: "sizeRange_refine",
> - limit: -1,
> - domainSize: 98155,
> - numBuckets: 18,
> },
> -
> {
> - processor: "FacetFieldProcessorByArrayDV",
> - elapse: 131,
> - field: "material_refine",
> - limit: -1,
> - domainSize: 98155,
> - numBuckets: 223,
> },
> -
> {
> - processor: "FacetFieldProcessorByArrayDV",
> - elapse: 132,
> - field: "ageAppropriate_refine",
> - limit: -1,
> - domainSize: 98155,
> - numBuckets: 6,
> },
> -
> {
> - processor: "FacetFieldProcessorByArrayDV",
> - elapse: 138,
> - field: "price_refine",
> - limit: -1,
> - domainSize: 98155,
> - numBuckets: 9,
> },
> -
> {
> - processor: "FacetFieldProcessorByArrayDV",
> - elapse: 147,
> - field: "size_refine",
> - limit: -1,
> - domainSize: 98155,
> - numBuckets: 2158,
> },
> -
> {
> - processor: "FacetFieldProcessorByArrayDV",
> - elapse: 149,
> - field: "inStoreOnline_refine",
> - limit: -1,
> - domainSize: 98155,
> - numBuckets: 3,
> },
> ],
> },
> - facet-debug:
> {
> - elapse: 29,
> - sub-facet:
> [
> -
> {
> - processor: "SimpleFacets",
> - elapse: 29,
> - action: "field facet",
> - maxThreads: 0,
> - sub-facet:
> [
> -
> {
> - elapse: 8,
> - requestedMethod: "not specified",
> - appliedMethod: "FC",
> - inputDocSetSize: 98155,
> - field: "brand",
> - numBuckets: 6304,
> },
> -
> {
> - elapse: 5,
> - requestedMethod: "not specified",
> - appliedMethod: "FC",
> - inputDocSetSize: 98155,
> - field: "product",
> - numBuckets: 1129,
> },
> -
> {
> - elapse: 5,
> - requestedMethod: "not specified",
> - appliedMethod: "FC",
> - inputDocSetSize: 98155,
> - field: "category",
> - numBuckets: 194,
> },
> -
> {
> - elapse: 5,
> - requestedMethod: "not specified",
> - appliedMethod: "FC",
> - inputDocSetSize: 98155,
> - field: "department",
> - numBuckets: 30,
> },
> -
> {
> - elapse: 4,
> - requestedMethod: "not specified",
> - appliedMethod: "FC",
> - inputDocSetSize: 98155,
> - field: "topRated",
> - numBuckets: 6,
> },
> ],
> }
> ],
> },
> - json:
> {
> - facet:
> {
> - gender_refine:
> {
> - domain:
> {
> - excludeTags: "rassortment,top,top2,top3,top4,",
> - filter:
> [
> -
> "{!filters param=$child.fq excludeTags=rgender_refine
> v=$sq}"
> ,
> -
> "{!child of=$pq filters=$fq}docType:(product
> collection)",
> ],
> },
> - type: "terms",
> - field: "gender_refine",
> - limit: -1,
> - facet:
> {
> - productsCount: "uniqueBlock(_root_)"
> },
> },
> - color_refine:
> {
> - domain:
> {
> - excludeTags: "rassortment,top,top2,top3,top4,",
> - filter:
> [
> -
> "{!filters param=$child.fq excludeTags=rcolor_refine
> v=$sq}"
> ,
> -
> "{!child of=$pq filters=$fq}docType:(product
> collection)",
> ],
> },
> - type: "terms",
> - field: "color_refine",
> - limit: -1,
> - facet:
> {
> - productsCount: "uniqueBlock(_root_)"
> },
> },
> - sizeRange_refine:
> {
> - domain:
> {
> - excludeTags: "rassortment,top,top2,top3,top4,",
> - filter:
> [
> -
> "{!filters param=$child.fq
> excludeTags=rsizeRange_refine v=$sq}"
> ,
> -
> "{!child of=$pq filters=$fq}docType:(product
> collection)",
> ],
> },
> - type: "terms",
> - field: "sizeRange_refine",
> - limit: -1,
> - facet:
> {
> - productsCount: "uniqueBlock(_root_)"
> },
> },
> - material_refine:
> {
> - domain:
> {
> - excludeTags: "rassortment,top,top2,top3,top4,",
> - filter:
> [
> -
> "{!filters param=$child.fq
> excludeTags=rmaterial_refine v=$sq}"
> ,
> -
> "{!child of=$pq filters=$fq}docType:(product
> collection)",
> ],
> },
> - type: "terms",
> - field: "material_refine",
> - limit: -1,
> - facet:
> {
> - productsCount: "uniqueBlock(_root_)"
> },
> },
> - ageAppropriate_refine:
> {
> - domain:
> {
> - excludeTags: "rassortment,top,top2,top3,top4,",
> - filter:
> [
> -
> "{!filters param=$child.fq
> excludeTags=rageAppropriate_refine v=$sq}"
> ,
> -
> "{!child of=$pq filters=$fq}docType:(product
> collection)",
> ],
> },
> - type: "terms",
> - field: "ageAppropriate_refine",
> - limit: -1,
> - facet:
> {
> - productsCount: "uniqueBlock(_root_)"
> },
> },
> - price_refine:
> {
> - domain:
> {
> - excludeTags: "rassortment,top,top2,top3,top4,",
> - filter:
> [
> -
> "{!filters param=$child.fq excludeTags=rprice_refine
> v=$sq}"
> ,
> -
> "{!child of=$pq filters=$fq}docType:(product
> collection)",
> ],
> },
> - type: "terms",
> - field: "price_refine",
> - limit: -1,
> - facet:
> {
> - productsCount: "uniqueBlock(_root_)"
> },
> },
> - size_refine:
> {
> - domain:
> {
> - excludeTags: "rassortment,top,top2,top3,top4,",
> - filter:
> [
> -
> "{!filters param=$child.fq excludeTags=rsize_refine
> v=$sq}"
> ,
> -
> "{!child of=$pq filters=$fq}docType:(product
> collection)",
> ],
> },
> - type: "terms",
> - field: "size_refine",
> - limit: -1,
> - facet:
> {
> - productsCount: "uniqueBlock(_root_)"
> },
> },
> - inStoreOnline_refine:
> {
> - domain:
> {
> - excludeTags: "rassortment,top,top2,top3,top4,",
> - filter:
> [
> -
> "{!filters param=$child.fq
> excludeTags=rinStoreOnline_refine v=$sq}"
> ,
> -
> "{!child of=$pq filters=$fq}docType:(product
> collection)",
> ],
> },
> - type: "terms",
> - field: "inStoreOnline_refine",
> - limit: -1,
> - facet:
> {
> - productsCount: "uniqueBlock(_root_)"
> },
> },
> }
> },
> - QParser: "BlockJoinParentQParser",
> - filter_queries:
> [
> - "{!tag=top2}(*:* -pvgc:true)",
> - "{!tag=top3}{!query v=$eligibleCollections}",
> - "{!tag=top3}{!query v=$eligibleCollections}",
> ],
> - parsed_filter_queries:
> [
> - "MatchAllDocsQuery(*:*) -pvgc:true",
> - "docType:product (+docType:collection +(eligibleToShow:[1 TO 1]))",
> - "docType:product (+docType:collection +(eligibleToShow:[1 TO 1]))",
> ],
> - timing:
> {
> - time: 1667,
> - prepare:
> {
> - time: 261,
> - query:
> {
> - time: 261
> },
> - facet:
> {
> - time: 0
> },
> - facet_module:
> {
> - time: 0
> },
> - mlt:
> {
> - time: 0
> },
> - highlight:
> {
> - time: 0
> },
> - stats:
> {
> - time: 0
> },
> - expand:
> {
> - time: 0
> },
> - terms:
> {
> - time: 0
> },
> - debug:
> {
> - time: 0
> },
> },
> - process:
> {
> - time: 1405,
> - query:
> {
> - time: 79
> },
> - facet:
> {
> - time: 29
> },
> - facet_module:
> {
> - time: 1122
> },
> - mlt:
> {
> - time: 0
> },
> - highlight:
> {
> - time: 0
> },
> - stats:
> {
> - time: 0
> },
> - expand:
> {
> - time: 0
> },
> - terms:
> {
> - time: 0
> },
> - debug:
> {
> - time: 174
> },
> },
> },
>
>
>
>
>
> On Wed, Jan 22, 2020 at 5:55 PM Mikhail Khludnev <m...@apache.org> wrote:
>
> > Screenshot didn't come though the list. That excerpt doesn't have any
> > informative numbers.
> >
> > On Tue, Jan 21, 2020 at 5:18 PM kumar gaurav <kg2...@gmail.com> wrote:
> >
> > > Hi Mikhail
> > >
> > > Thanks for your reply . Please help me in this .
> > >
> > > Followings are the screenshot:-
> > >
> > > [image: image.png]
> > >
> > >
> > > [image: image.png]
> > >
> > >
> > > json facet debug Output:-
> > >
> > > json:
> > > {
> > >
> > > - facet:
> > > {
> > > - color_refine:
> > > {
> > > - domain:
> > > {
> > > - excludeTags: "rassortment,top,top2,top3,top4,",
> > > - filter:
> > > [
> > > -
> > > "{!filters param=$child.fq excludeTags=rcolor_refine
> > v=$sq}"
> > > ,
> > > - "{!child of=$pq filters=$fq}docType:(product
> > collection)"
> > > ,
> > > ],
> > > },
> > > - type: "terms",
> > > - field: "color_refine",
> > > - limit: -1,
> > > - facet:
> > > {
> > > - productsCount: "uniqueBlock(_root_)"
> > > },
> > > },
> > > - size_refine:
> > > {
> > > - domain:
> > > {
> > > - excludeTags: "rassortment,top,top2,top3,top4,",
> > > - filter:
> > > [
> > > -
> > > "{!filters param=$child.fq excludeTags=rsize_refine
> > v=$sq}"
> > > ,
> > > - "{!child of=$pq filters=$fq}docType:(product
> > collection)"
> > > ,
> > > ],
> > > },
> > > - type: "terms",
> > > - field: "size_refine",
> > > - limit: -1,
> > > - facet:
> > > {
> > > - productsCount: "uniqueBlock(_root_)"
> > > },
> > > },
> > > }
> > >
> > > }
> > >
> > >
> > >
> > > regards
> > > Kumar Gaurav
> > >
> > >
> > > On Tue, Jan 21, 2020 at 5:25 PM Mikhail Khludnev <m...@apache.org>
> > wrote:
> > >
> > >> Hi.
> > >> Can you share debugQuery=true output?
> > >>
> > >> On Tue, Jan 21, 2020 at 1:37 PM kumar gaurav <kg2...@gmail.com>
> wrote:
> > >>
> > >> > HI
> > >> >
> > >> > i have a parent child query in which i have used json facet for
> child
> > >> > faceting like following.
> > >> >
> > >> > qt=/dismax
> > >> > matchAllQueryRef1=+(+({!query v=$cq}))
> > >> > sq=+{!lucene v=$matchAllQueryRef1}
> > >> > q={!parent tag=top which=$pq filters=$child.fq score=max v=$cq}
> > >> > child.fq={!tag=rcolor_refine}filter({!term f=color_refine
> > >> > v=$qcolor_refine1}) filter({!term f=color_refine v=$qcolor_refine2})
> > >> > qcolor_refine1=Blue
> > >> > qcolor_refine2=Other clrs
> > >> > cq=+{!simpleFilter v=docType:sku}
> > >> > pq=docType:(product)
> > >> > facet=true
> > >> > facet.mincount=1
> > >> > facet.limit=-1
> > >> > facet.missing=false
> > >> > json.facet= {color_refine:{
> > >> > domain:{
> > >> > filter:["{!filters param=$child.fq excludeTags=rcolor_refine
> > >> > v=$sq}","{!child of=$pq filters=$fq}docType:(product)"]
> > >> > },
> > >> > type:terms,
> > >> > field:color_refine,
> > >> > limit:-1,
> > >> > facet:{productsCount:"uniqueBlock(_root_)"}}}
> > >> >
> > >> > schema :-
> > >> > <field name="color_refine" type="string" indexed="true"
> stored="true"
> > >> > multiValued="true" docValues="true"/>
> > >> >
> > >> > i have observed that json facets are slow . It is taking much time
> > than
> > >> > expected .
> > >> > Can anyone please check this query specially child.fq and json.facet
> > >> part .
> > >> >
> > >> > Please help me in this .
> > >> >
> > >> > Thanks & regards
> > >> > Kumar Gaurav
> > >> >
> > >>
> > >>
> > >> --
> > >> Sincerely yours
> > >> Mikhail Khludnev
> > >>
> > >
> >
> > --
> > Sincerely yours
> > Mikhail Khludnev
> >
>
--
Sincerely yours
Mikhail Khludnev
