Logs Spilling

[ { "$sort" : { "a" : 1 } } ]

{ }

[ { "$sort" : { "a" : 1 } } ]

{ }

[ { "$sort" : { "a" : 1 } } ]

{
	"sortSpilledBytes" : "X",
	"sortSpilledDataStorageSize" : "X",
	"sortSpilledRecords" : 8,
	"sortSpills" : 5,
	"usedDisk" : true
}

[
	{
		"$sort" : {
			"a" : 1
		}
	},
	{
		"$limit" : 3
	},
	{
		"$sort" : {
			"b" : 1
		}
	}
]

{
	"sortSpilledBytes" : "X",
	"sortSpilledDataStorageSize" : "X",
	"sortSpilledRecords" : 16,
	"sortSpills" : 10,
	"usedDisk" : true
}

[ { "$sort" : { "time" : 1 } } ]

{
	"sortSpilledBytes" : "X",
	"sortSpilledDataStorageSize" : "X",
	"sortSpilledRecords" : 50,
	"sortSpills" : 50,
	"usedDisk" : true
}

[
	{
		"$group" : {
			"_id" : "$a",
			"b" : {
				"$sum" : "$b"
			}
		}
	},
	{
		"$sort" : {
			"b" : 1
		}
	}
]

{
	"groupSpilledBytes" : "X",
	"groupSpilledDataStorageSize" : "X",
	"groupSpilledRecords" : 4,
	"groupSpills" : 4,
	"sortSpilledBytes" : "X",
	"sortSpilledDataStorageSize" : "X",
	"sortSpilledRecords" : 4,
	"sortSpills" : 3,
	"usedDisk" : true
}

{ "timeWaitingMicros" : "X" }

[
	{
		"$match" : {
			"$text" : {
				"$search" : "black tea"
			}
		}
	},
	{
		"$addFields" : {
			"score" : {
				"$meta" : "textScore"
			}
		}
	}
]

{
	"textOrSpilledBytes" : "X",
	"textOrSpilledDataStorageSize" : "X",
	"textOrSpilledRecords" : 4,
	"textOrSpills" : 4,
	"usedDisk" : true
}

[
	{
		"$match" : {
			"$text" : {
				"$search" : "black tea"
			}
		}
	},
	{
		"$sort" : {
			"_" : {
				"$meta" : "textScore"
			}
		}
	}
]

{
	"sortSpilledBytes" : "X",
	"sortSpilledDataStorageSize" : "X",
	"sortSpilledRecords" : 8,
	"sortSpills" : 5,
	"textOrSpilledBytes" : "X",
	"textOrSpilledDataStorageSize" : "X",
	"textOrSpilledRecords" : 4,
	"textOrSpills" : 4,
	"usedDisk" : true
}

[
	{
		"$bucketAuto" : {
			"groupBy" : "$a",
			"buckets" : 2,
			"output" : {
				"sum" : {
					"$sum" : "$b"
				}
			}
		}
	}
]

{
	"bucketAutoSpilledBytes" : "X",
	"bucketAutoSpilledDataStorageSize" : "X",
	"bucketAutoSpilledRecords" : 13,
	"bucketAutoSpills" : 7,
	"usedDisk" : true
}

[
	{
		"$lookup" : {
			"from" : "logs_spilling_md_students",
			"localField" : "name",
			"foreignField" : "name",
			"as" : "matched"
		}
	}
]

{
	"hashLookupSpilledBytes" : "X",
	"hashLookupSpilledDataStorageSize" : "X",
	"hashLookupSpilledRecords" : 14,
	"hashLookupSpills" : 16,
	"usedDisk" : true
}

{ "timeWaitingMicros" : "X" }

[
	{
		"$limit" : 1
	},
	{
		"$graphLookup" : {
			"from" : "coll",
			"startWith" : 1,
			"connectFromField" : "to",
			"connectToField" : "_id",
			"as" : "path",
			"depthField" : "depth"
		}
	}
]

{
	"graphLookupSpilledBytes" : "X",
	"graphLookupSpilledDataStorageSize" : "X",
	"graphLookupSpilledRecords" : 2,
	"graphLookupSpills" : 2,
	"usedDisk" : true
}

{ "timeWaitingMicros" : "X" }

[
	{
		"$limit" : 1
	},
	{
		"$graphLookup" : {
			"from" : "coll",
			"startWith" : 1,
			"connectFromField" : "to",
			"connectToField" : "_id",
			"as" : "path",
			"depthField" : "depth"
		}
	},
	{
		"$unwind" : "$path"
	},
	{
		"$sort" : {
			"path.depth" : 1
		}
	}
]

{
	"graphLookupSpilledBytes" : "X",
	"graphLookupSpilledDataStorageSize" : "X",
	"graphLookupSpilledRecords" : 2,
	"graphLookupSpills" : 2,
	"usedDisk" : true
}

{ "timeWaitingMicros" : "X" }

[
	{
		"$lookup" : {
			"from" : "logs_spilling_md_locations",
			"localField" : "locationName",
			"foreignField" : "name",
			"as" : "location"
		}
	},
	{
		"$unwind" : "$location"
	},
	{
		"$project" : {
			"locationName" : false,
			"location.extra" : false,
			"location.coordinates" : false,
			"colors" : false
		}
	}
]

{
	"hashLookupSpilledBytes" : "X",
	"hashLookupSpilledDataStorageSize" : "X",
	"hashLookupSpilledRecords" : 6,
	"hashLookupSpills" : 6,
	"usedDisk" : true
}

{ "timeWaitingMicros" : "X" }

[
	{
		"$setWindowFields" : {
			"partitionBy" : "$a",
			"sortBy" : {
				"b" : 1
			},
			"output" : {
				"sum" : {
					"$sum" : "$b"
				}
			}
		}
	}
]

{
	"setWindowFieldsSpilledBytes" : "X",
	"setWindowFieldsSpilledDataStorageSize" : "X",
	"setWindowFieldsSpilledRecords" : 4,
	"setWindowFieldsSpills" : 4,
	"sortSpilledBytes" : "X",
	"sortSpilledDataStorageSize" : "X",
	"sortSpilledRecords" : 13,
	"sortSpills" : 7,
	"usedDisk" : true
}

{ "timeWaitingMicros" : "X" }

[
	{
		"$setWindowFields" : {
			"partitionBy" : "$a",
			"sortBy" : {
				"b" : 1
			},
			"output" : {
				"sum" : {
					"$sum" : "$b"
				}
			}
		}
	},
	{
		"$limit" : 1
	}
]

{
	"setWindowFieldsSpilledBytes" : "X",
	"setWindowFieldsSpilledDataStorageSize" : "X",
	"setWindowFieldsSpilledRecords" : 3,
	"setWindowFieldsSpills" : 3,
	"sortSpilledBytes" : "X",
	"sortSpilledDataStorageSize" : "X",
	"sortSpilledRecords" : 13,
	"sortSpills" : 7,
	"usedDisk" : true
}

{ "timeWaitingMicros" : "X" }