Lots of thanks Mikhail.
Also can you please answer - Should i use docValues="true" for _root_
field to improve this json.facet performance ?
On Wed, Jan 22, 2020 at 11:42 PM Mikhail Khludnev <m...@apache.org> wrote:
> 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
>
