jstests/query_golden/expected_output/sbeDisabled/logs_spilling.md
[ { "$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
}
[
{
"$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"
}
}
]
{ }
[
{
"$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
}
}
]
{ }
[
{
"$setWindowFields" : {
"partitionBy" : "$a",
"sortBy" : {
"b" : 1
},
"output" : {
"sum" : {
"$sum" : "$b"
}
}
}
}
]
{
"setWindowFieldsSpilledBytes" : "X",
"setWindowFieldsSpilledDataStorageSize" : "X",
"setWindowFieldsSpilledRecords" : 4,
"setWindowFieldsSpills" : 2,
"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" : 2,
"setWindowFieldsSpills" : 1,
"sortSpilledBytes" : "X",
"sortSpilledDataStorageSize" : "X",
"sortSpilledRecords" : 13,
"sortSpills" : 7,
"usedDisk" : true
}
{ "timeWaitingMicros" : "X" }