Hi All, I tried to get the debug information about the query for my INNER JOIN and ACROSS JOIN and trying to understand it.
See the query below - 1487 msec { "responseHeader":{ "status":0, "QTime":1487, "params":{ "q":"*:*", "fq.op":"AND", "indent":"on", "fl":"TC_0Y0_Item_ID", "fq":["TC_0Y0_Occurrence_Name:\"6935 style rear MY11+\"", "TC_0Y0_ProductScope:xtWNf_fTAaLUgD", "{!join to=TC_0Y0_Item_ID from=TC_0Y0_ItemRevision_0Y0_awp0Item_item_id fromIndex=collection1}TC_0Y0_ItemRevision_0Y0_awp0Item_item_id:92138773"], "wt":"json", "debugQuery":"on", "group.field":"TC_0Y0_Item_ID", ...... "debug":{ "join":{ "{!join from=TC_0Y0_ItemRevision_0Y0_awp0Item_item_id to=TC_0Y0_Item_ID fromIndex=collection1}TC_0Y0_ItemRevision_0Y0_awp0Item_item_id:92138773":{ "time":955, "fromSetSize":3, "toSetSize":14560, "fromTermCount":6632106, "fromTermTotalDf":6632106, "fromTermDirectCount":6632106, "fromTermHits":1, "fromTermHitsTotalDf":1, "toTermHits":1, "toTermHitsTotalDf":14560, "toTermDirectCount":0, "smallSetsDeferred":1, "toSetDocsAdded":14560}}, "rawquerystring":"*:*", "querystring":"*:*", "parsedquery":"MatchAllDocsQuery(*:*)", "parsedquery_toString":"*:*", "explain":{ "AZD1uV0qgj6GxC":"\n1.0 = *:*, product of:\n 1.0 = boost\n 1.0 = queryNorm\n"}, "QParser":"LuceneQParser", "filter_queries":["TC_0Y0_Occurrence_Name:\"6935 style rear MY11+\"", "TC_0Y0_ProductScope:xtWNf_fTAaLUgD", "{!join to=TC_0Y0_Item_ID from=TC_0Y0_ItemRevision_0Y0_awp0Item_item_id fromIndex=collection1}TC_0Y0_ItemRevision_0Y0_awp0Item_item_id:92138773"], "parsed_filter_queries":["TC_0Y0_Occurrence_Name:6935 style rear MY11+", "TC_0Y0_ProductScope:xtWNf_fTAaLUgD", "JoinQuery({!join from=TC_0Y0_ItemRevision_0Y0_awp0Item_item_id to=TC_0Y0_Item_ID fromIndex=collection1}TC_0Y0_ItemRevision_0Y0_awp0Item_item_id:92138773)"], "timing":{ "time":1487.0, ...... I am trying to see why fromTermCount is so high when fromSetSize and toSetSize is less? Where can I find the details about all the contents of debugQuery and how to read each component? Any help is appreciated. Regards, Paresh