Group Targeting

[ { "$group" : { "_id" : "$shardKey" } } ]

{ "_id" : "sHaRd0_2" }
{ "_id" : "shARD1_3" }
{ "_id" : "shard0_1" }
{ "_id" : "shard0_2" }
{ "_id" : "shard0_3" }
{ "_id" : "shard1_1" }
{ "_id" : "shard1_2" }
{ "_id" : "shard1_3" }

[ "_id_", "shardKey_1" ]

{
	"group_targeting-rs0" : [
		{
			"$cursor" : {
				"rejectedPlans" : [ ],
				"winningPlan" : [
					{
						"stage" : "PROJECTION_COVERED",
						"transformBy" : {
							"_id" : 0,
							"shardKey" : 1
						}
					},
					{
						"direction" : "forward",
						"indexBounds" : {
							"shardKey" : [
								"[MinKey, MaxKey]"
							]
						},
						"indexName" : "shardKey_1",
						"isFetching" : false,
						"isMultiKey" : false,
						"isPartial" : false,
						"isShardFiltering" : true,
						"isSparse" : false,
						"isUnique" : false,
						"keyPattern" : {
							"shardKey" : 1
						},
						"multiKeyPaths" : {
							"shardKey" : [ ]
						},
						"stage" : "DISTINCT_SCAN"
					}
				]
			}
		},
		{
			"$groupByDistinctScan" : {
				"newRoot" : {
					"_id" : "$shardKey"
				}
			}
		}
	],
	"group_targeting-rs1" : [
		{
			"$cursor" : {
				"rejectedPlans" : [ ],
				"winningPlan" : [
					{
						"stage" : "PROJECTION_COVERED",
						"transformBy" : {
							"_id" : 0,
							"shardKey" : 1
						}
					},
					{
						"direction" : "forward",
						"indexBounds" : {
							"shardKey" : [
								"[MinKey, MaxKey]"
							]
						},
						"indexName" : "shardKey_1",
						"isFetching" : false,
						"isMultiKey" : false,
						"isPartial" : false,
						"isShardFiltering" : true,
						"isSparse" : false,
						"isUnique" : false,
						"keyPattern" : {
							"shardKey" : 1
						},
						"multiKeyPaths" : {
							"shardKey" : [ ]
						},
						"stage" : "DISTINCT_SCAN"
					}
				]
			}
		},
		{
			"$groupByDistinctScan" : {
				"newRoot" : {
					"_id" : "$shardKey"
				}
			}
		}
	],
	"mergeType" : "router",
	"mergerPart" : [
		{
			"$mergeCursors" : {
				"allowPartialResults" : false,
				"compareWholeSortKey" : false,
				"nss" : "test.group_targeting",
				"recordRemoteOpWaitTime" : false,
				"requestQueryStatsFromRemotes" : false,
				"tailableMode" : "normal"
			}
		}
	],
	"queryShapeHash" : "09EC87EC1562264EEBD9FFB4AFCA462B420CE9D7D84761393C1EDFF22CC0DC52",
	"shardsPart" : [
		{
			"$group" : {
				"$willBeMerged" : false,
				"_id" : "$shardKey"
			}
		}
	]
}

[
	{
		"$group" : {
			"_id" : "$shardKey",
			"otherField" : {
				"$top" : {
					"output" : "$otherField",
					"sortBy" : {
						"shardKey" : 1
					}
				}
			}
		}
	},
	{
		"$match" : {
			"_id" : {
				"$lte" : "shard1_1"
			}
		}
	},
	{
		"$sort" : {
			"_id" : 1
		}
	}
]

{ "_id" : "sHaRd0_2", "otherField" : "b" }
{ "_id" : "shARD1_3", "otherField" : "c" }
{ "_id" : "shard0_1", "otherField" : "a" }
{ "_id" : "shard0_2", "otherField" : "b" }
{ "_id" : "shard0_3", "otherField" : "c" }
{ "_id" : "shard1_1", "otherField" : "a" }

[ "_id_", "shardKey_1" ]

{
	"group_targeting-rs0" : [
		{
			"$cursor" : {
				"rejectedPlans" : [ ],
				"winningPlan" : [
					{
						"stage" : "SORT_KEY_GENERATOR"
					},
					{
						"direction" : "forward",
						"indexBounds" : {
							"shardKey" : [
								"[\"\", \"shard1_1\"]"
							]
						},
						"indexName" : "shardKey_1",
						"isFetching" : true,
						"isMultiKey" : false,
						"isPartial" : false,
						"isShardFiltering" : true,
						"isSparse" : false,
						"isUnique" : false,
						"keyPattern" : {
							"shardKey" : 1
						},
						"multiKeyPaths" : {
							"shardKey" : [ ]
						},
						"stage" : "DISTINCT_SCAN"
					}
				]
			}
		},
		{
			"$group" : {
				"$willBeMerged" : false,
				"_id" : "$shardKey",
				"otherField" : {
					"$top" : {
						"output" : "$otherField",
						"sortBy" : {
							"shardKey" : 1
						}
					}
				}
			}
		},
		{
			"$sort" : {
				"sortKey" : {
					"_id" : 1
				}
			}
		}
	],
	"group_targeting-rs1" : [
		{
			"$cursor" : {
				"rejectedPlans" : [ ],
				"winningPlan" : [
					{
						"stage" : "SORT_KEY_GENERATOR"
					},
					{
						"direction" : "forward",
						"indexBounds" : {
							"shardKey" : [
								"[\"\", \"shard1_1\"]"
							]
						},
						"indexName" : "shardKey_1",
						"isFetching" : true,
						"isMultiKey" : false,
						"isPartial" : false,
						"isShardFiltering" : true,
						"isSparse" : false,
						"isUnique" : false,
						"keyPattern" : {
							"shardKey" : 1
						},
						"multiKeyPaths" : {
							"shardKey" : [ ]
						},
						"stage" : "DISTINCT_SCAN"
					}
				]
			}
		},
		{
			"$group" : {
				"$willBeMerged" : false,
				"_id" : "$shardKey",
				"otherField" : {
					"$top" : {
						"output" : "$otherField",
						"sortBy" : {
							"shardKey" : 1
						}
					}
				}
			}
		},
		{
			"$sort" : {
				"sortKey" : {
					"_id" : 1
				}
			}
		}
	],
	"mergeType" : "router",
	"mergerPart" : [
		{
			"$mergeCursors" : {
				"allowPartialResults" : false,
				"compareWholeSortKey" : false,
				"nss" : "test.group_targeting",
				"recordRemoteOpWaitTime" : false,
				"requestQueryStatsFromRemotes" : false,
				"sort" : {
					"_id" : 1
				},
				"tailableMode" : "normal"
			}
		}
	],
	"queryShapeHash" : "478B6A0368D57A8E91672794B842019CD3599311CF35C5BF57ADC37B3B32D884",
	"shardsPart" : [
		{
			"$match" : {
				"shardKey" : {
					"$lte" : "shard1_1"
				}
			}
		},
		{
			"$group" : {
				"$willBeMerged" : false,
				"_id" : "$shardKey",
				"otherField" : {
					"$top" : {
						"output" : "$otherField",
						"sortBy" : {
							"shardKey" : 1
						}
					}
				}
			}
		},
		{
			"$sort" : {
				"sortKey" : {
					"_id" : 1
				}
			}
		}
	]
}

[
	{
		"$group" : {
			"_id" : "$shardKey",
			"avg" : {
				"$avg" : "$_id"
			}
		}
	}
]

{ "_id" : "sHaRd0_2", "avg" : 2.5 }
{ "_id" : "shARD1_3", "avg" : 6.5 }
{ "_id" : "shard0_1", "avg" : 1.25 }
{ "_id" : "shard0_2", "avg" : 2 }
{ "_id" : "shard0_3", "avg" : 3.25 }
{ "_id" : "shard1_1", "avg" : 4.25 }
{ "_id" : "shard1_2", "avg" : 5 }
{ "_id" : "shard1_3", "avg" : 6 }

[ "_id_", "shardKey_1" ]

{
	"group_targeting-rs0" : {
		"rejectedPlans" : [ ],
		"winningPlan" : [
			{
				"stage" : "GROUP"
			},
			{
				"stage" : "SHARDING_FILTER"
			},
			{
				"direction" : "forward",
				"filter" : { },
				"nss" : "test.group_targeting",
				"stage" : "COLLSCAN"
			}
		]
	},
	"group_targeting-rs1" : {
		"rejectedPlans" : [ ],
		"winningPlan" : [
			{
				"stage" : "GROUP"
			},
			{
				"stage" : "SHARDING_FILTER"
			},
			{
				"direction" : "forward",
				"filter" : { },
				"nss" : "test.group_targeting",
				"stage" : "COLLSCAN"
			}
		]
	},
	"mergeType" : "router",
	"mergerPart" : [
		{
			"$mergeCursors" : {
				"allowPartialResults" : false,
				"compareWholeSortKey" : false,
				"nss" : "test.group_targeting",
				"recordRemoteOpWaitTime" : false,
				"requestQueryStatsFromRemotes" : false,
				"tailableMode" : "normal"
			}
		}
	],
	"queryShapeHash" : "9A81DF86B99921BDA452D7B2B1C281B4DD92D7793B7A41490B713E2E6240ABA8",
	"shardsPart" : [
		{
			"$group" : {
				"$willBeMerged" : false,
				"_id" : "$shardKey",
				"avg" : {
					"$avg" : "$_id"
				}
			}
		}
	]
}

[
	{
		"$project" : {
			"renamedShardKey" : "$shardKey"
		}
	},
	{
		"$group" : {
			"_id" : "$renamedShardKey"
		}
	}
]

{ "_id" : "sHaRd0_2" }
{ "_id" : "shARD1_3" }
{ "_id" : "shard0_1" }
{ "_id" : "shard0_2" }
{ "_id" : "shard0_3" }
{ "_id" : "shard1_1" }
{ "_id" : "shard1_2" }
{ "_id" : "shard1_3" }

[ "_id_", "shardKey_1" ]

{
	"group_targeting-rs0" : {
		"rejectedPlans" : [ ],
		"winningPlan" : [
			{
				"stage" : "GROUP"
			},
			{
				"stage" : "PROJECTION_DEFAULT",
				"transformBy" : {
					"_id" : true,
					"renamedShardKey" : "$shardKey"
				}
			},
			{
				"stage" : "SHARDING_FILTER"
			},
			{
				"direction" : "forward",
				"filter" : { },
				"nss" : "test.group_targeting",
				"stage" : "COLLSCAN"
			}
		]
	},
	"group_targeting-rs1" : {
		"rejectedPlans" : [ ],
		"winningPlan" : [
			{
				"stage" : "GROUP"
			},
			{
				"stage" : "PROJECTION_DEFAULT",
				"transformBy" : {
					"_id" : true,
					"renamedShardKey" : "$shardKey"
				}
			},
			{
				"stage" : "SHARDING_FILTER"
			},
			{
				"direction" : "forward",
				"filter" : { },
				"nss" : "test.group_targeting",
				"stage" : "COLLSCAN"
			}
		]
	},
	"mergeType" : "router",
	"mergerPart" : [
		{
			"$mergeCursors" : {
				"allowPartialResults" : false,
				"compareWholeSortKey" : false,
				"nss" : "test.group_targeting",
				"recordRemoteOpWaitTime" : false,
				"requestQueryStatsFromRemotes" : false,
				"tailableMode" : "normal"
			}
		}
	],
	"queryShapeHash" : "2383D49B22274AFD9D150CAAF21DEE74D13CECD29F757749126D14AB6A8A1259",
	"shardsPart" : [
		{
			"$project" : {
				"_id" : true,
				"renamedShardKey" : "$shardKey"
			}
		},
		{
			"$group" : {
				"$willBeMerged" : false,
				"_id" : "$renamedShardKey"
			}
		}
	]
}

[ { "$group" : { "_id" : [ "$shardKey", "$_id" ] } } ]

{ "_id" : [ "sHaRd0_2", 2.5 ] }
{ "_id" : [ "shARD1_3", 6.5 ] }
{ "_id" : [ "shard0_1", 1 ] }
{ "_id" : [ "shard0_1", 1.5 ] }
{ "_id" : [ "shard0_2", 2 ] }
{ "_id" : [ "shard0_3", 3 ] }
{ "_id" : [ "shard0_3", 3.5 ] }
{ "_id" : [ "shard1_1", 4 ] }
{ "_id" : [ "shard1_1", 4.5 ] }
{ "_id" : [ "shard1_2", 5 ] }
{ "_id" : [ "shard1_3", 6 ] }

[ "_id_", "shardKey_1" ]

{
	"group_targeting-rs0" : {
		"rejectedPlans" : [ ],
		"winningPlan" : [
			{
				"stage" : "GROUP"
			},
			{
				"stage" : "SHARDING_FILTER"
			},
			{
				"direction" : "forward",
				"filter" : { },
				"nss" : "test.group_targeting",
				"stage" : "COLLSCAN"
			}
		]
	},
	"group_targeting-rs1" : {
		"rejectedPlans" : [ ],
		"winningPlan" : [
			{
				"stage" : "GROUP"
			},
			{
				"stage" : "SHARDING_FILTER"
			},
			{
				"direction" : "forward",
				"filter" : { },
				"nss" : "test.group_targeting",
				"stage" : "COLLSCAN"
			}
		]
	},
	"mergeType" : "router",
	"mergerPart" : [
		{
			"$mergeCursors" : {
				"allowPartialResults" : false,
				"compareWholeSortKey" : false,
				"nss" : "test.group_targeting",
				"recordRemoteOpWaitTime" : false,
				"requestQueryStatsFromRemotes" : false,
				"tailableMode" : "normal"
			}
		}
	],
	"queryShapeHash" : "09640F28D8AD9D13A38E9B0AD3B6639B815174E1C2D6EA8056C9C98F379C4304",
	"shardsPart" : [
		{
			"$group" : {
				"$willBeMerged" : false,
				"_id" : [
					"$shardKey",
					"$_id"
				]
			}
		}
	]
}

[
	{
		"$group" : {
			"_id" : [
				"$shardKey",
				"$_id"
			],
			"otherField" : {
				"$top" : {
					"output" : "$otherField",
					"sortBy" : {
						"shardKey" : 1
					}
				}
			}
		}
	},
	{
		"$match" : {
			"_id" : {
				"$lte" : "shard1_1"
			}
		}
	},
	{
		"$sort" : {
			"_id" : 1
		}
	}
]

{ "_id" : [ "sHaRd0_2", 2.5 ], "otherField" : "b" }
{ "_id" : [ "shARD1_3", 6.5 ], "otherField" : "c" }
{ "_id" : [ "shard0_1", 1 ], "otherField" : "a" }
{ "_id" : [ "shard0_1", 1.5 ], "otherField" : "A" }
{ "_id" : [ "shard0_2", 2 ], "otherField" : "b" }
{ "_id" : [ "shard0_3", 3 ], "otherField" : "c" }
{ "_id" : [ "shard0_3", 3.5 ], "otherField" : "C" }
{ "_id" : [ "shard1_1", 4 ], "otherField" : "a" }
{ "_id" : [ "shard1_1", 4.5 ], "otherField" : "A" }

[ "_id_", "shardKey_1" ]

{
	"group_targeting-rs0" : [
		{
			"$cursor" : {
				"rejectedPlans" : [ ],
				"winningPlan" : [
					{
						"stage" : "GROUP"
					},
					{
						"stage" : "SHARDING_FILTER"
					},
					{
						"direction" : "forward",
						"filter" : { },
						"nss" : "test.group_targeting",
						"stage" : "COLLSCAN"
					}
				]
			}
		},
		{
			"$match" : {
				"_id" : {
					"$lte" : "shard1_1"
				}
			}
		},
		{
			"$sort" : {
				"sortKey" : {
					"_id" : 1
				}
			}
		}
	],
	"group_targeting-rs1" : [
		{
			"$cursor" : {
				"rejectedPlans" : [ ],
				"winningPlan" : [
					{
						"stage" : "GROUP"
					},
					{
						"stage" : "SHARDING_FILTER"
					},
					{
						"direction" : "forward",
						"filter" : { },
						"nss" : "test.group_targeting",
						"stage" : "COLLSCAN"
					}
				]
			}
		},
		{
			"$match" : {
				"_id" : {
					"$lte" : "shard1_1"
				}
			}
		},
		{
			"$sort" : {
				"sortKey" : {
					"_id" : 1
				}
			}
		}
	],
	"mergeType" : "router",
	"mergerPart" : [
		{
			"$mergeCursors" : {
				"allowPartialResults" : false,
				"compareWholeSortKey" : false,
				"nss" : "test.group_targeting",
				"recordRemoteOpWaitTime" : false,
				"requestQueryStatsFromRemotes" : false,
				"sort" : {
					"_id" : 1
				},
				"tailableMode" : "normal"
			}
		}
	],
	"queryShapeHash" : "744ECBEB61B075559F88DC0388215DE156259BB0F0064E78DDA8F8941EE745BA",
	"shardsPart" : [
		{
			"$group" : {
				"$willBeMerged" : false,
				"_id" : [
					"$shardKey",
					"$_id"
				],
				"otherField" : {
					"$top" : {
						"output" : "$otherField",
						"sortBy" : {
							"shardKey" : 1
						}
					}
				}
			}
		},
		{
			"$match" : {
				"_id" : {
					"$lte" : "shard1_1"
				}
			}
		},
		{
			"$sort" : {
				"sortKey" : {
					"_id" : 1
				}
			}
		}
	]
}

[
	{
		"$project" : {
			"renamedShardKey" : "$shardKey"
		}
	},
	{
		"$group" : {
			"_id" : {
				"secretlyShardKey" : "$renamedShardKey",
				"actualId" : "$_id"
			}
		}
	}
]

{ "_id" : { "actualId" : 1, "secretlyShardKey" : "shard0_1" } }
{ "_id" : { "actualId" : 1.5, "secretlyShardKey" : "shard0_1" } }
{ "_id" : { "actualId" : 2, "secretlyShardKey" : "shard0_2" } }
{ "_id" : { "actualId" : 2.5, "secretlyShardKey" : "sHaRd0_2" } }
{ "_id" : { "actualId" : 3, "secretlyShardKey" : "shard0_3" } }
{ "_id" : { "actualId" : 3.5, "secretlyShardKey" : "shard0_3" } }
{ "_id" : { "actualId" : 4, "secretlyShardKey" : "shard1_1" } }
{ "_id" : { "actualId" : 4.5, "secretlyShardKey" : "shard1_1" } }
{ "_id" : { "actualId" : 5, "secretlyShardKey" : "shard1_2" } }
{ "_id" : { "actualId" : 6, "secretlyShardKey" : "shard1_3" } }
{ "_id" : { "actualId" : 6.5, "secretlyShardKey" : "shARD1_3" } }

[ "_id_", "shardKey_1" ]

{
	"group_targeting-rs0" : {
		"rejectedPlans" : [ ],
		"winningPlan" : [
			{
				"stage" : "GROUP"
			},
			{
				"stage" : "PROJECTION_DEFAULT",
				"transformBy" : {
					"_id" : true,
					"renamedShardKey" : "$shardKey"
				}
			},
			{
				"stage" : "SHARDING_FILTER"
			},
			{
				"direction" : "forward",
				"filter" : { },
				"nss" : "test.group_targeting",
				"stage" : "COLLSCAN"
			}
		]
	},
	"group_targeting-rs1" : {
		"rejectedPlans" : [ ],
		"winningPlan" : [
			{
				"stage" : "GROUP"
			},
			{
				"stage" : "PROJECTION_DEFAULT",
				"transformBy" : {
					"_id" : true,
					"renamedShardKey" : "$shardKey"
				}
			},
			{
				"stage" : "SHARDING_FILTER"
			},
			{
				"direction" : "forward",
				"filter" : { },
				"nss" : "test.group_targeting",
				"stage" : "COLLSCAN"
			}
		]
	},
	"mergeType" : "router",
	"mergerPart" : [
		{
			"$mergeCursors" : {
				"allowPartialResults" : false,
				"compareWholeSortKey" : false,
				"nss" : "test.group_targeting",
				"recordRemoteOpWaitTime" : false,
				"requestQueryStatsFromRemotes" : false,
				"tailableMode" : "normal"
			}
		}
	],
	"queryShapeHash" : "78D76645B1D16F553E5F8EE2980FAB231DCC0EF7F8EF99C7A4F9CEE10F0E5460",
	"shardsPart" : [
		{
			"$project" : {
				"_id" : true,
				"renamedShardKey" : "$shardKey"
			}
		},
		{
			"$group" : {
				"$willBeMerged" : false,
				"_id" : {
					"actualId" : "$_id",
					"secretlyShardKey" : "$renamedShardKey"
				}
			}
		}
	]
}

[
	{
		"$group" : {
			"_id" : {
				"$min" : [
					"$shardKey",
					1
				]
			}
		}
	}
]

{ "_id" : 1 }

[ "_id_", "shardKey_1" ]

{
	"group_targeting-rs0" : [
		{
			"$cursor" : {
				"rejectedPlans" : [ ],
				"winningPlan" : [
					{
						"stage" : "PROJECTION_SIMPLE",
						"transformBy" : {
							"_id" : 0,
							"shardKey" : 1
						}
					},
					{
						"stage" : "SHARDING_FILTER"
					},
					{
						"direction" : "forward",
						"nss" : "test.group_targeting",
						"stage" : "COLLSCAN"
					}
				]
			}
		},
		{
			"$group" : {
				"_id" : {
					"$min" : [
						"$shardKey",
						{
							"$const" : 1
						}
					]
				}
			}
		}
	],
	"group_targeting-rs1" : [
		{
			"$cursor" : {
				"rejectedPlans" : [ ],
				"winningPlan" : [
					{
						"stage" : "PROJECTION_SIMPLE",
						"transformBy" : {
							"_id" : 0,
							"shardKey" : 1
						}
					},
					{
						"stage" : "SHARDING_FILTER"
					},
					{
						"direction" : "forward",
						"nss" : "test.group_targeting",
						"stage" : "COLLSCAN"
					}
				]
			}
		},
		{
			"$group" : {
				"_id" : {
					"$min" : [
						"$shardKey",
						{
							"$const" : 1
						}
					]
				}
			}
		}
	],
	"mergeType" : "router",
	"mergerPart" : [
		{
			"$mergeCursors" : {
				"allowPartialResults" : false,
				"compareWholeSortKey" : false,
				"nss" : "test.group_targeting",
				"recordRemoteOpWaitTime" : false,
				"requestQueryStatsFromRemotes" : false,
				"tailableMode" : "normal"
			}
		},
		{
			"$group" : {
				"$doingMerge" : true,
				"_id" : "$$ROOT._id"
			}
		}
	],
	"queryShapeHash" : "C605458B8E6E7334D2C90BC2104F144FD6F0C35D1D81B1AD224B21D9569B3346",
	"shardsPart" : [
		{
			"$group" : {
				"_id" : {
					"$min" : [
						"$shardKey",
						{
							"$const" : 1
						}
					]
				}
			}
		}
	]
}

[
	{
		"$group" : {
			"_id" : {
				"$min" : [
					"$shardKey",
					1
				]
			},
			"otherField" : {
				"$top" : {
					"output" : "$otherField",
					"sortBy" : {
						"shardKey" : 1
					}
				}
			}
		}
	},
	{
		"$match" : {
			"_id" : {
				"$lte" : "shard1_1"
			}
		}
	},
	{
		"$sort" : {
			"_id" : 1
		}
	}
]

[ "_id_", "shardKey_1" ]

{
	"group_targeting-rs0" : [
		{
			"$cursor" : {
				"rejectedPlans" : [ ],
				"winningPlan" : [
					{
						"stage" : "PROJECTION_SIMPLE",
						"transformBy" : {
							"_id" : 0,
							"otherField" : 1,
							"shardKey" : 1
						}
					},
					{
						"stage" : "SHARDING_FILTER"
					},
					{
						"direction" : "forward",
						"nss" : "test.group_targeting",
						"stage" : "COLLSCAN"
					}
				]
			}
		},
		{
			"$group" : {
				"_id" : {
					"$min" : [
						"$shardKey",
						{
							"$const" : 1
						}
					]
				},
				"otherField" : {
					"$top" : {
						"output" : "$otherField",
						"sortBy" : {
							"shardKey" : 1
						}
					}
				}
			}
		}
	],
	"group_targeting-rs1" : [
		{
			"$cursor" : {
				"rejectedPlans" : [ ],
				"winningPlan" : [
					{
						"stage" : "PROJECTION_SIMPLE",
						"transformBy" : {
							"_id" : 0,
							"otherField" : 1,
							"shardKey" : 1
						}
					},
					{
						"stage" : "SHARDING_FILTER"
					},
					{
						"direction" : "forward",
						"nss" : "test.group_targeting",
						"stage" : "COLLSCAN"
					}
				]
			}
		},
		{
			"$group" : {
				"_id" : {
					"$min" : [
						"$shardKey",
						{
							"$const" : 1
						}
					]
				},
				"otherField" : {
					"$top" : {
						"output" : "$otherField",
						"sortBy" : {
							"shardKey" : 1
						}
					}
				}
			}
		}
	],
	"mergeType" : "router",
	"mergerPart" : [
		{
			"$mergeCursors" : {
				"allowPartialResults" : false,
				"compareWholeSortKey" : false,
				"nss" : "test.group_targeting",
				"recordRemoteOpWaitTime" : false,
				"requestQueryStatsFromRemotes" : false,
				"tailableMode" : "normal"
			}
		},
		{
			"$group" : {
				"$doingMerge" : true,
				"_id" : "$$ROOT._id",
				"otherField" : {
					"$top" : {
						"output" : "$$ROOT.otherField",
						"sortBy" : {
							"shardKey" : 1
						}
					}
				}
			}
		},
		{
			"$match" : {
				"_id" : {
					"$lte" : "shard1_1"
				}
			}
		},
		{
			"$sort" : {
				"sortKey" : {
					"_id" : 1
				}
			}
		}
	],
	"queryShapeHash" : "01FA23646F5D8B9B4431EE11F599E449A1C20E7F13511FF8A8A3D584334FDBB9",
	"shardsPart" : [
		{
			"$group" : {
				"_id" : {
					"$min" : [
						"$shardKey",
						{
							"$const" : 1
						}
					]
				},
				"otherField" : {
					"$top" : {
						"output" : "$otherField",
						"sortBy" : {
							"shardKey" : 1
						}
					}
				}
			}
		}
	]
}

[
	{
		"$group" : {
			"_id" : {
				"$min" : [
					"$shardKey",
					"$_id"
				]
			}
		}
	}
]

{ "_id" : 1 }
{ "_id" : 1.5 }
{ "_id" : 2 }
{ "_id" : 2.5 }
{ "_id" : 3 }
{ "_id" : 3.5 }
{ "_id" : 4 }
{ "_id" : 4.5 }
{ "_id" : 5 }
{ "_id" : 6 }
{ "_id" : 6.5 }

[ "_id_", "shardKey_1" ]

{
	"group_targeting-rs0" : [
		{
			"$cursor" : {
				"rejectedPlans" : [ ],
				"winningPlan" : [
					{
						"stage" : "PROJECTION_SIMPLE",
						"transformBy" : {
							"_id" : 1,
							"shardKey" : 1
						}
					},
					{
						"stage" : "SHARDING_FILTER"
					},
					{
						"direction" : "forward",
						"nss" : "test.group_targeting",
						"stage" : "COLLSCAN"
					}
				]
			}
		},
		{
			"$group" : {
				"_id" : {
					"$min" : [
						"$shardKey",
						"$_id"
					]
				}
			}
		}
	],
	"group_targeting-rs1" : [
		{
			"$cursor" : {
				"rejectedPlans" : [ ],
				"winningPlan" : [
					{
						"stage" : "PROJECTION_SIMPLE",
						"transformBy" : {
							"_id" : 1,
							"shardKey" : 1
						}
					},
					{
						"stage" : "SHARDING_FILTER"
					},
					{
						"direction" : "forward",
						"nss" : "test.group_targeting",
						"stage" : "COLLSCAN"
					}
				]
			}
		},
		{
			"$group" : {
				"_id" : {
					"$min" : [
						"$shardKey",
						"$_id"
					]
				}
			}
		}
	],
	"mergeType" : "router",
	"mergerPart" : [
		{
			"$mergeCursors" : {
				"allowPartialResults" : false,
				"compareWholeSortKey" : false,
				"nss" : "test.group_targeting",
				"recordRemoteOpWaitTime" : false,
				"requestQueryStatsFromRemotes" : false,
				"tailableMode" : "normal"
			}
		},
		{
			"$group" : {
				"$doingMerge" : true,
				"_id" : "$$ROOT._id"
			}
		}
	],
	"queryShapeHash" : "7D37D6CBCE761BFCFC3A2C9573ACFCF7D1A4AA1FAECBB63DBA95DCC5848764CC",
	"shardsPart" : [
		{
			"$group" : {
				"_id" : {
					"$min" : [
						"$shardKey",
						"$_id"
					]
				}
			}
		}
	]
}

[
	{
		"$group" : {
			"_id" : {
				"key" : "$shardKey",
				"other" : "$otherField"
			}
		}
	},
	{
		"$group" : {
			"_id" : "$_id.other"
		}
	}
]

{ "_id" : "A" }
{ "_id" : "C" }
{ "_id" : "a" }
{ "_id" : "b" }
{ "_id" : "c" }

[ "_id_", "shardKey_1" ]

{
	"group_targeting-rs0" : {
		"rejectedPlans" : [ ],
		"winningPlan" : [
			{
				"stage" : "GROUP"
			},
			{
				"stage" : "GROUP"
			},
			{
				"stage" : "SHARDING_FILTER"
			},
			{
				"direction" : "forward",
				"filter" : { },
				"nss" : "test.group_targeting",
				"stage" : "COLLSCAN"
			}
		]
	},
	"group_targeting-rs1" : {
		"rejectedPlans" : [ ],
		"winningPlan" : [
			{
				"stage" : "GROUP"
			},
			{
				"stage" : "GROUP"
			},
			{
				"stage" : "SHARDING_FILTER"
			},
			{
				"direction" : "forward",
				"filter" : { },
				"nss" : "test.group_targeting",
				"stage" : "COLLSCAN"
			}
		]
	},
	"mergeType" : "router",
	"mergerPart" : [
		{
			"$mergeCursors" : {
				"allowPartialResults" : false,
				"compareWholeSortKey" : false,
				"nss" : "test.group_targeting",
				"recordRemoteOpWaitTime" : false,
				"requestQueryStatsFromRemotes" : false,
				"tailableMode" : "normal"
			}
		},
		{
			"$group" : {
				"$doingMerge" : true,
				"_id" : "$$ROOT._id"
			}
		}
	],
	"queryShapeHash" : "801173738BA7069D3C0E0D81881FD43C5B89488ABF1BFFE408F46A06BBD3C6F6",
	"shardsPart" : [
		{
			"$group" : {
				"$willBeMerged" : false,
				"_id" : {
					"key" : "$shardKey",
					"other" : "$otherField"
				}
			}
		},
		{
			"$group" : {
				"_id" : "$_id.other"
			}
		}
	]
}

[
	{
		"$group" : {
			"_id" : {
				"key" : "$shardKey",
				"other" : "$otherField"
			}
		}
	},
	{
		"$group" : {
			"_id" : "$_id"
		}
	}
]

{ "_id" : { "key" : "sHaRd0_2", "other" : "b" } }
{ "_id" : { "key" : "shARD1_3", "other" : "c" } }
{ "_id" : { "key" : "shard0_1", "other" : "A" } }
{ "_id" : { "key" : "shard0_1", "other" : "a" } }
{ "_id" : { "key" : "shard0_2", "other" : "b" } }
{ "_id" : { "key" : "shard0_3", "other" : "C" } }
{ "_id" : { "key" : "shard0_3", "other" : "c" } }
{ "_id" : { "key" : "shard1_1", "other" : "A" } }
{ "_id" : { "key" : "shard1_1", "other" : "a" } }
{ "_id" : { "key" : "shard1_2", "other" : "b" } }
{ "_id" : { "key" : "shard1_3", "other" : "c" } }

[ "_id_", "shardKey_1" ]

{
	"group_targeting-rs0" : {
		"rejectedPlans" : [ ],
		"winningPlan" : [
			{
				"stage" : "GROUP"
			},
			{
				"stage" : "GROUP"
			},
			{
				"stage" : "SHARDING_FILTER"
			},
			{
				"direction" : "forward",
				"filter" : { },
				"nss" : "test.group_targeting",
				"stage" : "COLLSCAN"
			}
		]
	},
	"group_targeting-rs1" : {
		"rejectedPlans" : [ ],
		"winningPlan" : [
			{
				"stage" : "GROUP"
			},
			{
				"stage" : "GROUP"
			},
			{
				"stage" : "SHARDING_FILTER"
			},
			{
				"direction" : "forward",
				"filter" : { },
				"nss" : "test.group_targeting",
				"stage" : "COLLSCAN"
			}
		]
	},
	"mergeType" : "router",
	"mergerPart" : [
		{
			"$mergeCursors" : {
				"allowPartialResults" : false,
				"compareWholeSortKey" : false,
				"nss" : "test.group_targeting",
				"recordRemoteOpWaitTime" : false,
				"requestQueryStatsFromRemotes" : false,
				"tailableMode" : "normal"
			}
		},
		{
			"$group" : {
				"$doingMerge" : true,
				"_id" : "$$ROOT._id"
			}
		}
	],
	"queryShapeHash" : "F3459C97A782CC2BD58165A9EE9BB0E1F2CCC8D51597AABBF3C54BD884203868",
	"shardsPart" : [
		{
			"$group" : {
				"$willBeMerged" : false,
				"_id" : {
					"key" : "$shardKey",
					"other" : "$otherField"
				}
			}
		},
		{
			"$group" : {
				"_id" : "$_id"
			}
		}
	]
}

[
	{
		"$group" : {
			"_id" : "$shardKey",
			"avg" : {
				"$avg" : "$_id"
			}
		}
	},
	{
		"$group" : {
			"_id" : "$avg",
			"num" : {
				"$count" : { }
			}
		}
	}
]

{ "_id" : 1.25, "num" : 1 }
{ "_id" : 2, "num" : 1 }
{ "_id" : 2.5, "num" : 1 }
{ "_id" : 3.25, "num" : 1 }
{ "_id" : 4.25, "num" : 1 }
{ "_id" : 5, "num" : 1 }
{ "_id" : 6, "num" : 1 }
{ "_id" : 6.5, "num" : 1 }

[ "_id_", "shardKey_1" ]

{
	"group_targeting-rs0" : {
		"rejectedPlans" : [ ],
		"winningPlan" : [
			{
				"stage" : "GROUP"
			},
			{
				"stage" : "GROUP"
			},
			{
				"stage" : "SHARDING_FILTER"
			},
			{
				"direction" : "forward",
				"filter" : { },
				"nss" : "test.group_targeting",
				"stage" : "COLLSCAN"
			}
		]
	},
	"group_targeting-rs1" : {
		"rejectedPlans" : [ ],
		"winningPlan" : [
			{
				"stage" : "GROUP"
			},
			{
				"stage" : "GROUP"
			},
			{
				"stage" : "SHARDING_FILTER"
			},
			{
				"direction" : "forward",
				"filter" : { },
				"nss" : "test.group_targeting",
				"stage" : "COLLSCAN"
			}
		]
	},
	"mergeType" : "router",
	"mergerPart" : [
		{
			"$mergeCursors" : {
				"allowPartialResults" : false,
				"compareWholeSortKey" : false,
				"nss" : "test.group_targeting",
				"recordRemoteOpWaitTime" : false,
				"requestQueryStatsFromRemotes" : false,
				"tailableMode" : "normal"
			}
		},
		{
			"$group" : {
				"$doingMerge" : true,
				"_id" : "$$ROOT._id",
				"num" : {
					"$sum" : "$$ROOT.num"
				}
			}
		}
	],
	"queryShapeHash" : "8815C6186EC271EF6EAD8060BE52DEA1E3BD053F10839B00FDA354341E8F59B4",
	"shardsPart" : [
		{
			"$group" : {
				"$willBeMerged" : false,
				"_id" : "$shardKey",
				"avg" : {
					"$avg" : "$_id"
				}
			}
		},
		{
			"$group" : {
				"_id" : "$avg",
				"num" : {
					"$sum" : {
						"$const" : 1
					}
				}
			}
		}
	]
}

[ { "$group" : { "_id" : "$otherField" } } ]

{ "_id" : "A" }
{ "_id" : "C" }
{ "_id" : "a" }
{ "_id" : "b" }
{ "_id" : "c" }

[ "_id_", "shardKey_1" ]

{
	"group_targeting-rs0" : {
		"rejectedPlans" : [ ],
		"winningPlan" : [
			{
				"stage" : "GROUP"
			},
			{
				"stage" : "SHARDING_FILTER"
			},
			{
				"direction" : "forward",
				"filter" : { },
				"nss" : "test.group_targeting",
				"stage" : "COLLSCAN"
			}
		]
	},
	"group_targeting-rs1" : {
		"rejectedPlans" : [ ],
		"winningPlan" : [
			{
				"stage" : "GROUP"
			},
			{
				"stage" : "SHARDING_FILTER"
			},
			{
				"direction" : "forward",
				"filter" : { },
				"nss" : "test.group_targeting",
				"stage" : "COLLSCAN"
			}
		]
	},
	"mergeType" : "router",
	"mergerPart" : [
		{
			"$mergeCursors" : {
				"allowPartialResults" : false,
				"compareWholeSortKey" : false,
				"nss" : "test.group_targeting",
				"recordRemoteOpWaitTime" : false,
				"requestQueryStatsFromRemotes" : false,
				"tailableMode" : "normal"
			}
		},
		{
			"$group" : {
				"$doingMerge" : true,
				"_id" : "$$ROOT._id"
			}
		}
	],
	"queryShapeHash" : "6270E1992E2C5A949A3BF78D8A05435A314BD09755ABC29677C048A700397834",
	"shardsPart" : [
		{
			"$group" : {
				"_id" : "$otherField"
			}
		}
	]
}

[
	{
		"$project" : {
			"shardKey" : "$otherField"
		}
	},
	{
		"$group" : {
			"_id" : "$shardKey"
		}
	}
]

{ "_id" : "A" }
{ "_id" : "C" }
{ "_id" : "a" }
{ "_id" : "b" }
{ "_id" : "c" }

[ "_id_", "shardKey_1" ]

{
	"group_targeting-rs0" : {
		"rejectedPlans" : [ ],
		"winningPlan" : [
			{
				"stage" : "GROUP"
			},
			{
				"stage" : "PROJECTION_DEFAULT",
				"transformBy" : {
					"_id" : true,
					"shardKey" : "$otherField"
				}
			},
			{
				"stage" : "SHARDING_FILTER"
			},
			{
				"direction" : "forward",
				"filter" : { },
				"nss" : "test.group_targeting",
				"stage" : "COLLSCAN"
			}
		]
	},
	"group_targeting-rs1" : {
		"rejectedPlans" : [ ],
		"winningPlan" : [
			{
				"stage" : "GROUP"
			},
			{
				"stage" : "PROJECTION_DEFAULT",
				"transformBy" : {
					"_id" : true,
					"shardKey" : "$otherField"
				}
			},
			{
				"stage" : "SHARDING_FILTER"
			},
			{
				"direction" : "forward",
				"filter" : { },
				"nss" : "test.group_targeting",
				"stage" : "COLLSCAN"
			}
		]
	},
	"mergeType" : "router",
	"mergerPart" : [
		{
			"$mergeCursors" : {
				"allowPartialResults" : false,
				"compareWholeSortKey" : false,
				"nss" : "test.group_targeting",
				"recordRemoteOpWaitTime" : false,
				"requestQueryStatsFromRemotes" : false,
				"tailableMode" : "normal"
			}
		},
		{
			"$group" : {
				"$doingMerge" : true,
				"_id" : "$$ROOT._id"
			}
		}
	],
	"queryShapeHash" : "F8083EDFC37C8CC3733CEDD935E4B3C831389D112C8EE226B709FAF053BD938B",
	"shardsPart" : [
		{
			"$project" : {
				"_id" : true,
				"shardKey" : "$otherField"
			}
		},
		{
			"$group" : {
				"_id" : "$shardKey"
			}
		}
	]
}

[
	{
		"$project" : {
			"otherField" : 1
		}
	},
	{
		"$group" : {
			"_id" : "$shardKey"
		}
	}
]

{ "_id" : null }

[ "_id_", "shardKey_1" ]

{
	"group_targeting-rs0" : {
		"rejectedPlans" : [ ],
		"winningPlan" : [
			{
				"stage" : "GROUP"
			},
			{
				"stage" : "PROJECTION_SIMPLE",
				"transformBy" : {
					"_id" : true,
					"otherField" : true
				}
			},
			{
				"stage" : "SHARDING_FILTER"
			},
			{
				"direction" : "forward",
				"filter" : { },
				"nss" : "test.group_targeting",
				"stage" : "COLLSCAN"
			}
		]
	},
	"group_targeting-rs1" : {
		"rejectedPlans" : [ ],
		"winningPlan" : [
			{
				"stage" : "GROUP"
			},
			{
				"stage" : "PROJECTION_SIMPLE",
				"transformBy" : {
					"_id" : true,
					"otherField" : true
				}
			},
			{
				"stage" : "SHARDING_FILTER"
			},
			{
				"direction" : "forward",
				"filter" : { },
				"nss" : "test.group_targeting",
				"stage" : "COLLSCAN"
			}
		]
	},
	"mergeType" : "router",
	"mergerPart" : [
		{
			"$mergeCursors" : {
				"allowPartialResults" : false,
				"compareWholeSortKey" : false,
				"nss" : "test.group_targeting",
				"recordRemoteOpWaitTime" : false,
				"requestQueryStatsFromRemotes" : false,
				"tailableMode" : "normal"
			}
		},
		{
			"$group" : {
				"$doingMerge" : true,
				"_id" : "$$ROOT._id"
			}
		}
	],
	"queryShapeHash" : "B1196288FCD6D08D7BCD65966BBBDE65B135237A5052F14820D01F6407A0F3A6",
	"shardsPart" : [
		{
			"$project" : {
				"_id" : true,
				"otherField" : true
			}
		},
		{
			"$group" : {
				"_id" : "$shardKey"
			}
		}
	]
}

[
	{
		"$addFields" : {
			"shardKey" : "$otherField"
		}
	},
	{
		"$group" : {
			"_id" : "$shardKey"
		}
	}
]

{ "_id" : "A" }
{ "_id" : "C" }
{ "_id" : "a" }
{ "_id" : "b" }
{ "_id" : "c" }

[ "_id_", "shardKey_1" ]

{
	"group_targeting-rs0" : [
		{
			"$cursor" : {
				"rejectedPlans" : [ ],
				"winningPlan" : [
					{
						"stage" : "PROJECTION_SIMPLE",
						"transformBy" : {
							"_id" : 0,
							"otherField" : 1
						}
					},
					{
						"stage" : "SHARDING_FILTER"
					},
					{
						"direction" : "forward",
						"nss" : "test.group_targeting",
						"stage" : "COLLSCAN"
					}
				]
			}
		},
		{
			"$addFields" : {
				"shardKey" : "$otherField"
			}
		},
		{
			"$group" : {
				"_id" : "$shardKey"
			}
		}
	],
	"group_targeting-rs1" : [
		{
			"$cursor" : {
				"rejectedPlans" : [ ],
				"winningPlan" : [
					{
						"stage" : "PROJECTION_SIMPLE",
						"transformBy" : {
							"_id" : 0,
							"otherField" : 1
						}
					},
					{
						"stage" : "SHARDING_FILTER"
					},
					{
						"direction" : "forward",
						"nss" : "test.group_targeting",
						"stage" : "COLLSCAN"
					}
				]
			}
		},
		{
			"$addFields" : {
				"shardKey" : "$otherField"
			}
		},
		{
			"$group" : {
				"_id" : "$shardKey"
			}
		}
	],
	"mergeType" : "router",
	"mergerPart" : [
		{
			"$mergeCursors" : {
				"allowPartialResults" : false,
				"compareWholeSortKey" : false,
				"nss" : "test.group_targeting",
				"recordRemoteOpWaitTime" : false,
				"requestQueryStatsFromRemotes" : false,
				"tailableMode" : "normal"
			}
		},
		{
			"$group" : {
				"$doingMerge" : true,
				"_id" : "$$ROOT._id"
			}
		}
	],
	"queryShapeHash" : "1D7219367D726673E808E9ADABBA76A609AC8A44D104676C049DBCF4D99004B2",
	"shardsPart" : [
		{
			"$addFields" : {
				"shardKey" : "$otherField"
			}
		},
		{
			"$group" : {
				"_id" : "$shardKey"
			}
		}
	]
}

[ { "$group" : { "_id" : "$$ROOT" } } ]

{ "_id" : { "_id" : 1, "otherField" : "a", "shardKey" : "shard0_1" } }
{ "_id" : { "_id" : 1.5, "otherField" : "A", "shardKey" : "shard0_1" } }
{ "_id" : { "_id" : 2, "otherField" : "b", "shardKey" : "shard0_2" } }
{ "_id" : { "_id" : 2.5, "otherField" : "b", "shardKey" : "sHaRd0_2" } }
{ "_id" : { "_id" : 3, "otherField" : "c", "shardKey" : "shard0_3" } }
{ "_id" : { "_id" : 3.5, "otherField" : "C", "shardKey" : "shard0_3" } }
{ "_id" : { "_id" : 4, "otherField" : "a", "shardKey" : "shard1_1" } }
{ "_id" : { "_id" : 4.5, "otherField" : "A", "shardKey" : "shard1_1" } }
{ "_id" : { "_id" : 5, "otherField" : "b", "shardKey" : "shard1_2" } }
{ "_id" : { "_id" : 6, "otherField" : "c", "shardKey" : "shard1_3" } }
{ "_id" : { "_id" : 6.5, "otherField" : "c", "shardKey" : "shARD1_3" } }

[ "_id_", "shardKey_1" ]

{
	"group_targeting-rs0" : {
		"rejectedPlans" : [ ],
		"winningPlan" : [
			{
				"stage" : "GROUP"
			},
			{
				"stage" : "SHARDING_FILTER"
			},
			{
				"direction" : "forward",
				"filter" : { },
				"nss" : "test.group_targeting",
				"stage" : "COLLSCAN"
			}
		]
	},
	"group_targeting-rs1" : {
		"rejectedPlans" : [ ],
		"winningPlan" : [
			{
				"stage" : "GROUP"
			},
			{
				"stage" : "SHARDING_FILTER"
			},
			{
				"direction" : "forward",
				"filter" : { },
				"nss" : "test.group_targeting",
				"stage" : "COLLSCAN"
			}
		]
	},
	"mergeType" : "router",
	"mergerPart" : [
		{
			"$mergeCursors" : {
				"allowPartialResults" : false,
				"compareWholeSortKey" : false,
				"nss" : "test.group_targeting",
				"recordRemoteOpWaitTime" : false,
				"requestQueryStatsFromRemotes" : false,
				"tailableMode" : "normal"
			}
		},
		{
			"$group" : {
				"$doingMerge" : true,
				"_id" : "$$ROOT._id"
			}
		}
	],
	"queryShapeHash" : "212EE000EB2F7C3432078C9D533F87A72EB238E2129907C7F4A4D2A699947658",
	"shardsPart" : [
		{
			"$group" : {
				"_id" : "$$ROOT"
			}
		}
	]
}

[ { "$group" : { "_id" : "$$ROOT.shardKey" } } ]

{ "_id" : "sHaRd0_2" }
{ "_id" : "shARD1_3" }
{ "_id" : "shard0_1" }
{ "_id" : "shard0_2" }
{ "_id" : "shard0_3" }
{ "_id" : "shard1_1" }
{ "_id" : "shard1_2" }
{ "_id" : "shard1_3" }

[ "_id_", "shardKey_1" ]

{
	"group_targeting-rs0" : [
		{
			"$cursor" : {
				"rejectedPlans" : [ ],
				"winningPlan" : [
					{
						"stage" : "PROJECTION_COVERED",
						"transformBy" : {
							"_id" : 0,
							"shardKey" : 1
						}
					},
					{
						"direction" : "forward",
						"indexBounds" : {
							"shardKey" : [
								"[MinKey, MaxKey]"
							]
						},
						"indexName" : "shardKey_1",
						"isFetching" : false,
						"isMultiKey" : false,
						"isPartial" : false,
						"isShardFiltering" : true,
						"isSparse" : false,
						"isUnique" : false,
						"keyPattern" : {
							"shardKey" : 1
						},
						"multiKeyPaths" : {
							"shardKey" : [ ]
						},
						"stage" : "DISTINCT_SCAN"
					}
				]
			}
		},
		{
			"$groupByDistinctScan" : {
				"newRoot" : {
					"_id" : "$shardKey"
				}
			}
		}
	],
	"group_targeting-rs1" : [
		{
			"$cursor" : {
				"rejectedPlans" : [ ],
				"winningPlan" : [
					{
						"stage" : "PROJECTION_COVERED",
						"transformBy" : {
							"_id" : 0,
							"shardKey" : 1
						}
					},
					{
						"direction" : "forward",
						"indexBounds" : {
							"shardKey" : [
								"[MinKey, MaxKey]"
							]
						},
						"indexName" : "shardKey_1",
						"isFetching" : false,
						"isMultiKey" : false,
						"isPartial" : false,
						"isShardFiltering" : true,
						"isSparse" : false,
						"isUnique" : false,
						"keyPattern" : {
							"shardKey" : 1
						},
						"multiKeyPaths" : {
							"shardKey" : [ ]
						},
						"stage" : "DISTINCT_SCAN"
					}
				]
			}
		},
		{
			"$groupByDistinctScan" : {
				"newRoot" : {
					"_id" : "$shardKey"
				}
			}
		}
	],
	"mergeType" : "router",
	"mergerPart" : [
		{
			"$mergeCursors" : {
				"allowPartialResults" : false,
				"compareWholeSortKey" : false,
				"nss" : "test.group_targeting",
				"recordRemoteOpWaitTime" : false,
				"requestQueryStatsFromRemotes" : false,
				"tailableMode" : "normal"
			}
		}
	],
	"queryShapeHash" : "09DBC64EC8B53958B982EBE3BD1BE19E71C1317D623AC79678873C14E1403B14",
	"shardsPart" : [
		{
			"$group" : {
				"$willBeMerged" : false,
				"_id" : "$$ROOT.shardKey"
			}
		}
	]
}

[
	{
		"$group" : {
			"_id" : "$shardKey"
		}
	},
	{
		"$addFields" : {
			"_id" : {
				"$toLower" : "$_id"
			}
		}
	}
]

{ "collation" : { "locale" : "en_US", "strength" : 2 } }

{ "_id" : "shard0_1" }
{ "_id" : "shard0_2" }
{ "_id" : "shard0_3" }
{ "_id" : "shard1_1" }
{ "_id" : "shard1_2" }
{ "_id" : "shard1_3" }

[ "_id_", "shardKey_1" ]

{
	"group_targeting-rs0" : {
		"rejectedPlans" : [ ],
		"winningPlan" : [
			{
				"stage" : "GROUP"
			},
			{
				"stage" : "SHARDING_FILTER"
			},
			{
				"direction" : "forward",
				"filter" : { },
				"nss" : "test.group_targeting",
				"stage" : "COLLSCAN"
			}
		]
	},
	"group_targeting-rs1" : {
		"rejectedPlans" : [ ],
		"winningPlan" : [
			{
				"stage" : "GROUP"
			},
			{
				"stage" : "SHARDING_FILTER"
			},
			{
				"direction" : "forward",
				"filter" : { },
				"nss" : "test.group_targeting",
				"stage" : "COLLSCAN"
			}
		]
	},
	"mergeType" : "router",
	"mergerPart" : [
		{
			"$mergeCursors" : {
				"allowPartialResults" : false,
				"compareWholeSortKey" : false,
				"nss" : "test.group_targeting",
				"recordRemoteOpWaitTime" : false,
				"requestQueryStatsFromRemotes" : false,
				"tailableMode" : "normal"
			}
		},
		{
			"$group" : {
				"$doingMerge" : true,
				"_id" : "$$ROOT._id"
			}
		},
		{
			"$addFields" : {
				"_id" : {
					"$toLower" : [
						"$_id"
					]
				}
			}
		}
	],
	"queryShapeHash" : "B41F2EC9172F6DC814DF78027338CF30B2DAB99831594593CFEF245E4A09DF0E",
	"shardsPart" : [
		{
			"$group" : {
				"_id" : "$shardKey"
			}
		}
	]
}

[
	{
		"$project" : {
			"shardKey" : 0
		}
	},
	{
		"$addFields" : {
			"shardKey" : "$otherField"
		}
	},
	{
		"$group" : {
			"_id" : "$shardKey"
		}
	}
]

{ "_id" : "A" }
{ "_id" : "C" }
{ "_id" : "a" }
{ "_id" : "b" }
{ "_id" : "c" }

[ "_id_", "shardKey_1" ]

{
	"group_targeting-rs0" : [
		{
			"$cursor" : {
				"rejectedPlans" : [ ],
				"winningPlan" : [
					{
						"stage" : "PROJECTION_SIMPLE",
						"transformBy" : {
							"_id" : 0,
							"otherField" : 1
						}
					},
					{
						"stage" : "SHARDING_FILTER"
					},
					{
						"direction" : "forward",
						"nss" : "test.group_targeting",
						"stage" : "COLLSCAN"
					}
				]
			}
		},
		{
			"$project" : {
				"_id" : true,
				"shardKey" : false
			}
		},
		{
			"$addFields" : {
				"shardKey" : "$otherField"
			}
		},
		{
			"$group" : {
				"_id" : "$shardKey"
			}
		}
	],
	"group_targeting-rs1" : [
		{
			"$cursor" : {
				"rejectedPlans" : [ ],
				"winningPlan" : [
					{
						"stage" : "PROJECTION_SIMPLE",
						"transformBy" : {
							"_id" : 0,
							"otherField" : 1
						}
					},
					{
						"stage" : "SHARDING_FILTER"
					},
					{
						"direction" : "forward",
						"nss" : "test.group_targeting",
						"stage" : "COLLSCAN"
					}
				]
			}
		},
		{
			"$project" : {
				"_id" : true,
				"shardKey" : false
			}
		},
		{
			"$addFields" : {
				"shardKey" : "$otherField"
			}
		},
		{
			"$group" : {
				"_id" : "$shardKey"
			}
		}
	],
	"mergeType" : "router",
	"mergerPart" : [
		{
			"$mergeCursors" : {
				"allowPartialResults" : false,
				"compareWholeSortKey" : false,
				"nss" : "test.group_targeting",
				"recordRemoteOpWaitTime" : false,
				"requestQueryStatsFromRemotes" : false,
				"tailableMode" : "normal"
			}
		},
		{
			"$group" : {
				"$doingMerge" : true,
				"_id" : "$$ROOT._id"
			}
		}
	],
	"queryShapeHash" : "B3C864E3B979A9C1B9204E3ED19C34C7FF2F405B7160A775B41011C9C1814BC4",
	"shardsPart" : [
		{
			"$project" : {
				"_id" : true,
				"shardKey" : false
			}
		},
		{
			"$addFields" : {
				"shardKey" : "$otherField"
			}
		},
		{
			"$group" : {
				"_id" : "$shardKey"
			}
		}
	]
}

[
	{
		"$group" : {
			"_id" : {
				"sk0" : "$sk0",
				"sk1" : "$sk1",
				"sk2" : "$sk2"
			}
		}
	}
]

{ "_id" : { "sk0" : "s0", "sk1" : 1, "sk2" : "a" } }
{ "_id" : { "sk0" : "s0", "sk1" : 2, "sk2" : "a" } }
{ "_id" : { "sk0" : "s0/1", "sk1" : 1, "sk2" : "b" } }
{ "_id" : { "sk0" : "s0/1", "sk1" : 1, "sk2" : "z" } }
{ "_id" : { "sk0" : "s0/1", "sk1" : 2, "sk2" : "b" } }
{ "_id" : { "sk0" : "s0/1", "sk1" : 2, "sk2" : "z" } }
{ "_id" : { "sk0" : "s1", "sk1" : 3, "sk2" : "b" } }
{ "_id" : { "sk0" : "s1", "sk1" : 5, "sk2" : "c" } }

[ "_id_", "sk0_1_sk1_1_sk2_1" ]

{
	"group_targeting-rs0" : {
		"rejectedPlans" : [ ],
		"winningPlan" : [
			{
				"stage" : "GROUP"
			},
			{
				"stage" : "SHARDING_FILTER"
			},
			{
				"direction" : "forward",
				"filter" : { },
				"nss" : "test.group_targeting_compound",
				"stage" : "COLLSCAN"
			}
		]
	},
	"group_targeting-rs1" : {
		"rejectedPlans" : [ ],
		"winningPlan" : [
			{
				"stage" : "GROUP"
			},
			{
				"stage" : "SHARDING_FILTER"
			},
			{
				"direction" : "forward",
				"filter" : { },
				"nss" : "test.group_targeting_compound",
				"stage" : "COLLSCAN"
			}
		]
	},
	"mergeType" : "router",
	"mergerPart" : [
		{
			"$mergeCursors" : {
				"allowPartialResults" : false,
				"compareWholeSortKey" : false,
				"nss" : "test.group_targeting_compound",
				"recordRemoteOpWaitTime" : false,
				"requestQueryStatsFromRemotes" : false,
				"tailableMode" : "normal"
			}
		}
	],
	"queryShapeHash" : "24ED0D35376542D41F0864F8C9CA57CEEB2C5349BC4D4B19E604D676D6F03ED2",
	"shardsPart" : [
		{
			"$group" : {
				"$willBeMerged" : false,
				"_id" : {
					"sk0" : "$sk0",
					"sk1" : "$sk1",
					"sk2" : "$sk2"
				}
			}
		}
	]
}

[
	{
		"$group" : {
			"_id" : {
				"sk0" : "$sk0",
				"sk1" : "$sk1",
				"sk2" : "$sk2"
			},
			"sumSk1" : {
				"$sum" : "$sk1"
			},
			"setSk2" : {
				"$addToSet" : "$sk2"
			}
		}
	}
]

{ "_id" : { "sk0" : "s0", "sk1" : 1, "sk2" : "a" }, "setSk2" : [ "a" ], "sumSk1" : 2 }
{ "_id" : { "sk0" : "s0", "sk1" : 2, "sk2" : "a" }, "setSk2" : [ "a" ], "sumSk1" : 2 }
{ "_id" : { "sk0" : "s0/1", "sk1" : 1, "sk2" : "b" }, "setSk2" : [ "b" ], "sumSk1" : 1 }
{ "_id" : { "sk0" : "s0/1", "sk1" : 1, "sk2" : "z" }, "setSk2" : [ "z" ], "sumSk1" : 1 }
{ "_id" : { "sk0" : "s0/1", "sk1" : 2, "sk2" : "b" }, "setSk2" : [ "b" ], "sumSk1" : 4 }
{ "_id" : { "sk0" : "s0/1", "sk1" : 2, "sk2" : "z" }, "setSk2" : [ "z" ], "sumSk1" : 2 }
{ "_id" : { "sk0" : "s1", "sk1" : 3, "sk2" : "b" }, "setSk2" : [ "b" ], "sumSk1" : 6 }
{ "_id" : { "sk0" : "s1", "sk1" : 5, "sk2" : "c" }, "setSk2" : [ "c" ], "sumSk1" : 5 }