Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- MongoDB Enterprise > db.t35.explain().aggregate(x)
- {
- "stages" : [
- {
- "$cursor" : {
- "query" : {
- "$and" : [
- {
- "a35" : NumberLong(8)
- },
- {
- "a35" : {
- "$ne" : null
- }
- }
- ]
- },
- "fields" : {
- "__joined_t1.a1" : 1,
- "__joined_t1.x1" : 1,
- "__joined_t10.a10" : 1,
- "__joined_t10.x10" : 1,
- "__joined_t13.a13" : 1,
- "__joined_t13.x13" : 1,
- "__joined_t14.a14" : 1,
- "__joined_t14.x14" : 1,
- "__joined_t15.a15" : 1,
- "__joined_t15.x15" : 1,
- "__joined_t17.a17" : 1,
- "__joined_t17.x17" : 1,
- "__joined_t18.a18" : 1,
- "__joined_t18.x18" : 1,
- "__joined_t19.a19" : 1,
- "__joined_t19.x19" : 1,
- "__joined_t2.a2" : 1,
- "__joined_t2.x2" : 1,
- "__joined_t20.a20" : 1,
- "__joined_t20.x20" : 1,
- "__joined_t22.a22" : 1,
- "__joined_t22.x22" : 1,
- "__joined_t23.a23" : 1,
- "__joined_t23.x23" : 1,
- "__joined_t24.a24" : 1,
- "__joined_t24.x24" : 1,
- "__joined_t25.a25" : 1,
- "__joined_t25.x25" : 1,
- "__joined_t26.a26" : 1,
- "__joined_t26.x26" : 1,
- "__joined_t27.a27" : 1,
- "__joined_t27.x27" : 1,
- "__joined_t28.a28" : 1,
- "__joined_t28.x28" : 1,
- "__joined_t29.a29" : 1,
- "__joined_t29.x29" : 1,
- "__joined_t3.x3" : 1,
- "__joined_t30.a30" : 1,
- "__joined_t30.x30" : 1,
- "__joined_t31.a31" : 1,
- "__joined_t31.x31" : 1,
- "__joined_t32.a32" : 1,
- "__joined_t32.x32" : 1,
- "__joined_t33.a33" : 1,
- "__joined_t33.x33" : 1,
- "__joined_t34.a34" : 1,
- "__joined_t34.x34" : 1,
- "__joined_t36.a36" : 1,
- "__joined_t36.x36" : 1,
- "__joined_t37.a37" : 1,
- "__joined_t37.x37" : 1,
- "__joined_t38.a38" : 1,
- "__joined_t38.x38" : 1,
- "__joined_t39.a39" : 1,
- "__joined_t39.x39" : 1,
- "__joined_t4.a4" : 1,
- "__joined_t4.x4" : 1,
- "__joined_t40.a40" : 1,
- "__joined_t40.x40" : 1,
- "__joined_t41.a41" : 1,
- "__joined_t41.x41" : 1,
- "__joined_t42.a42" : 1,
- "__joined_t42.x42" : 1,
- "__joined_t43.a43" : 1,
- "__joined_t43.x43" : 1,
- "__joined_t45.a45" : 1,
- "__joined_t45.x45" : 1,
- "__joined_t46.a46" : 1,
- "__joined_t46.x46" : 1,
- "__joined_t47.a47" : 1,
- "__joined_t47.x47" : 1,
- "__joined_t48.a48" : 1,
- "__joined_t48.x48" : 1,
- "__joined_t49.a49" : 1,
- "__joined_t49.x49" : 1,
- "__joined_t5.a5" : 1,
- "__joined_t5.x5" : 1,
- "__joined_t50.a50" : 1,
- "__joined_t50.x50" : 1,
- "__joined_t51.a51" : 1,
- "__joined_t51.x51" : 1,
- "__joined_t52.a52" : 1,
- "__joined_t52.x52" : 1,
- "__joined_t53.a53" : 1,
- "__joined_t53.x53" : 1,
- "__joined_t55.a55" : 1,
- "__joined_t55.x55" : 1,
- "__joined_t56.a56" : 1,
- "__joined_t56.x56" : 1,
- "__joined_t57.a57" : 1,
- "__joined_t57.x57" : 1,
- "__joined_t58.a58" : 1,
- "__joined_t58.x58" : 1,
- "__joined_t59.a59" : 1,
- "__joined_t59.x59" : 1,
- "__joined_t6.a6" : 1,
- "__joined_t6.x6" : 1,
- "__joined_t60.a60" : 1,
- "__joined_t60.x60" : 1,
- "__joined_t61.a61" : 1,
- "__joined_t61.x61" : 1,
- "__joined_t62.a62" : 1,
- "__joined_t62.x62" : 1,
- "__joined_t63.a63" : 1,
- "__joined_t63.x63" : 1,
- "__joined_t64.a64" : 1,
- "__joined_t64.x64" : 1,
- "__joined_t7.a7" : 1,
- "__joined_t7.x7" : 1,
- "__joined_t8.a8" : 1,
- "__joined_t8.x8" : 1,
- "__joined_t9.a9" : 1,
- "__joined_t9.x9" : 1,
- "a35" : 1,
- "x35" : 1,
- "_id" : 0
- },
- "queryPlanner" : {
- "plannerVersion" : 1,
- "namespace" : "memtest.t35",
- "indexFilterSet" : false,
- "parsedQuery" : {
- "$and" : [
- {
- "a35" : {
- "$eq" : NumberLong(8)
- }
- },
- {
- "$nor" : [
- {
- "a35" : {
- "$eq" : null
- }
- }
- ]
- }
- ]
- },
- "winningPlan" : {
- "stage" : "COLLSCAN",
- "filter" : {
- "$and" : [
- {
- "a35" : {
- "$eq" : NumberLong(8)
- }
- },
- {
- "$nor" : [
- {
- "a35" : {
- "$eq" : null
- }
- }
- ]
- }
- ]
- },
- "direction" : "forward"
- },
- "rejectedPlans" : [ ]
- }
- }
- },
- {
- "$lookup" : {
- "from" : "t34",
- "as" : "__joined_t34",
- "localField" : "a35",
- "foreignField" : "b34",
- "unwinding" : {
- "preserveNullAndEmptyArrays" : false
- },
- "matching" : {
- "$nor" : [
- {
- "a34" : {
- "$eq" : null
- }
- }
- ]
- }
- }
- },
- {
- "$lookup" : {
- "from" : "t32",
- "as" : "__joined_t32",
- "localField" : "__joined_t34.a34",
- "foreignField" : "b32",
- "unwinding" : {
- "preserveNullAndEmptyArrays" : false
- },
- "matching" : {
- "$nor" : [
- {
- "a32" : {
- "$eq" : null
- }
- }
- ]
- }
- }
- },
- {
- "$lookup" : {
- "from" : "t61",
- "as" : "__joined_t61",
- "localField" : "__joined_t32.a32",
- "foreignField" : "b61",
- "unwinding" : {
- "preserveNullAndEmptyArrays" : false
- },
- "matching" : {
- "$nor" : [
- {
- "a61" : {
- "$eq" : null
- }
- }
- ]
- }
- }
- },
- {
- "$lookup" : {
- "from" : "t60",
- "as" : "__joined_t60",
- "localField" : "__joined_t61.a61",
- "foreignField" : "b60",
- "unwinding" : {
- "preserveNullAndEmptyArrays" : false
- },
- "matching" : {
- "$nor" : [
- {
- "a60" : {
- "$eq" : null
- }
- }
- ]
- }
- }
- },
- {
- "$lookup" : {
- "from" : "t28",
- "as" : "__joined_t28",
- "localField" : "__joined_t60.a60",
- "foreignField" : "b28",
- "unwinding" : {
- "preserveNullAndEmptyArrays" : false
- },
- "matching" : {
- "$nor" : [
- {
- "a28" : {
- "$eq" : null
- }
- }
- ]
- }
- }
- },
- {
- "$lookup" : {
- "from" : "t17",
- "as" : "__joined_t17",
- "localField" : "__joined_t28.a28",
- "foreignField" : "b17",
- "unwinding" : {
- "preserveNullAndEmptyArrays" : false
- },
- "matching" : {
- "$nor" : [
- {
- "a17" : {
- "$eq" : null
- }
- }
- ]
- }
- }
- },
- {
- "$lookup" : {
- "from" : "t59",
- "as" : "__joined_t59",
- "localField" : "__joined_t17.a17",
- "foreignField" : "b59",
- "unwinding" : {
- "preserveNullAndEmptyArrays" : false
- },
- "matching" : {
- "$nor" : [
- {
- "a59" : {
- "$eq" : null
- }
- }
- ]
- }
- }
- },
- {
- "$lookup" : {
- "from" : "t42",
- "as" : "__joined_t42",
- "localField" : "__joined_t59.a59",
- "foreignField" : "b42",
- "unwinding" : {
- "preserveNullAndEmptyArrays" : false
- },
- "matching" : {
- "$nor" : [
- {
- "a42" : {
- "$eq" : null
- }
- }
- ]
- }
- }
- },
- {
- "$lookup" : {
- "from" : "t41",
- "as" : "__joined_t41",
- "localField" : "__joined_t42.a42",
- "foreignField" : "b41",
- "unwinding" : {
- "preserveNullAndEmptyArrays" : false
- },
- "matching" : {
- "$nor" : [
- {
- "a41" : {
- "$eq" : null
- }
- }
- ]
- }
- }
- },
- {
- "$lookup" : {
- "from" : "t4",
- "as" : "__joined_t4",
- "localField" : "__joined_t41.a41",
- "foreignField" : "b4",
- "unwinding" : {
- "preserveNullAndEmptyArrays" : false
- },
- "matching" : {
- "$nor" : [
- {
- "a4" : {
- "$eq" : null
- }
- }
- ]
- }
- }
- },
- {
- "$lookup" : {
- "from" : "t22",
- "as" : "__joined_t22",
- "localField" : "__joined_t4.a4",
- "foreignField" : "b22",
- "unwinding" : {
- "preserveNullAndEmptyArrays" : false
- },
- "matching" : {
- "$nor" : [
- {
- "a22" : {
- "$eq" : null
- }
- }
- ]
- }
- }
- },
- {
- "$lookup" : {
- "from" : "t2",
- "as" : "__joined_t2",
- "localField" : "__joined_t22.a22",
- "foreignField" : "b2",
- "unwinding" : {
- "preserveNullAndEmptyArrays" : false
- },
- "matching" : {
- "$nor" : [
- {
- "a2" : {
- "$eq" : null
- }
- }
- ]
- }
- }
- },
- {
- "$lookup" : {
- "from" : "t53",
- "as" : "__joined_t53",
- "localField" : "__joined_t2.a2",
- "foreignField" : "b53",
- "unwinding" : {
- "preserveNullAndEmptyArrays" : false
- },
- "matching" : {
- "$nor" : [
- {
- "a53" : {
- "$eq" : null
- }
- }
- ]
- }
- }
- },
- {
- "$lookup" : {
- "from" : "t26",
- "as" : "__joined_t26",
- "localField" : "__joined_t53.a53",
- "foreignField" : "b26",
- "unwinding" : {
- "preserveNullAndEmptyArrays" : false
- },
- "matching" : {
- "$nor" : [
- {
- "a26" : {
- "$eq" : null
- }
- }
- ]
- }
- }
- },
- {
- "$lookup" : {
- "from" : "t57",
- "as" : "__joined_t57",
- "localField" : "__joined_t26.a26",
- "foreignField" : "b57",
- "unwinding" : {
- "preserveNullAndEmptyArrays" : false
- },
- "matching" : {
- "$nor" : [
- {
- "a57" : {
- "$eq" : null
- }
- }
- ]
- }
- }
- },
- {
- "$lookup" : {
- "from" : "t24",
- "as" : "__joined_t24",
- "localField" : "__joined_t57.a57",
- "foreignField" : "b24",
- "unwinding" : {
- "preserveNullAndEmptyArrays" : false
- },
- "matching" : {
- "$nor" : [
- {
- "a24" : {
- "$eq" : null
- }
- }
- ]
- }
- }
- },
- {
- "$lookup" : {
- "from" : "t52",
- "as" : "__joined_t52",
- "localField" : "__joined_t24.a24",
- "foreignField" : "b52",
- "unwinding" : {
- "preserveNullAndEmptyArrays" : false
- },
- "matching" : {
- "$nor" : [
- {
- "a52" : {
- "$eq" : null
- }
- }
- ]
- }
- }
- },
- {
- "$lookup" : {
- "from" : "t63",
- "as" : "__joined_t63",
- "localField" : "__joined_t52.a52",
- "foreignField" : "b63",
- "unwinding" : {
- "preserveNullAndEmptyArrays" : false
- },
- "matching" : {
- "$nor" : [
- {
- "a63" : {
- "$eq" : null
- }
- }
- ]
- }
- }
- },
- {
- "$lookup" : {
- "from" : "t15",
- "as" : "__joined_t15",
- "localField" : "__joined_t63.a63",
- "foreignField" : "b15",
- "unwinding" : {
- "preserveNullAndEmptyArrays" : false
- },
- "matching" : {
- "$nor" : [
- {
- "a15" : {
- "$eq" : null
- }
- }
- ]
- }
- }
- },
- {
- "$lookup" : {
- "from" : "t14",
- "as" : "__joined_t14",
- "localField" : "__joined_t15.a15",
- "foreignField" : "b14",
- "unwinding" : {
- "preserveNullAndEmptyArrays" : false
- },
- "matching" : {
- "$nor" : [
- {
- "a14" : {
- "$eq" : null
- }
- }
- ]
- }
- }
- },
- {
- "$lookup" : {
- "from" : "t46",
- "as" : "__joined_t46",
- "localField" : "__joined_t14.a14",
- "foreignField" : "b46",
- "unwinding" : {
- "preserveNullAndEmptyArrays" : false
- },
- "matching" : {
- "$nor" : [
- {
- "a46" : {
- "$eq" : null
- }
- }
- ]
- }
- }
- },
- {
- "$lookup" : {
- "from" : "t29",
- "as" : "__joined_t29",
- "localField" : "__joined_t46.a46",
- "foreignField" : "b29",
- "unwinding" : {
- "preserveNullAndEmptyArrays" : false
- },
- "matching" : {
- "$nor" : [
- {
- "a29" : {
- "$eq" : null
- }
- }
- ]
- }
- }
- },
- {
- "$lookup" : {
- "from" : "t18",
- "as" : "__joined_t18",
- "localField" : "__joined_t29.a29",
- "foreignField" : "b18",
- "unwinding" : {
- "preserveNullAndEmptyArrays" : false
- },
- "matching" : {
- "$nor" : [
- {
- "a18" : {
- "$eq" : null
- }
- }
- ]
- }
- }
- },
- {
- "$lookup" : {
- "from" : "t48",
- "as" : "__joined_t48",
- "localField" : "__joined_t18.a18",
- "foreignField" : "b48",
- "unwinding" : {
- "preserveNullAndEmptyArrays" : false
- },
- "matching" : {
- "$nor" : [
- {
- "a48" : {
- "$eq" : null
- }
- }
- ]
- }
- }
- },
- {
- "$lookup" : {
- "from" : "t49",
- "as" : "__joined_t49",
- "localField" : "__joined_t48.a48",
- "foreignField" : "b49",
- "unwinding" : {
- "preserveNullAndEmptyArrays" : false
- },
- "matching" : {
- "$nor" : [
- {
- "a49" : {
- "$eq" : null
- }
- }
- ]
- }
- }
- },
- {
- "$lookup" : {
- "from" : "t58",
- "as" : "__joined_t58",
- "localField" : "__joined_t49.a49",
- "foreignField" : "b58",
- "unwinding" : {
- "preserveNullAndEmptyArrays" : false
- },
- "matching" : {
- "$nor" : [
- {
- "a58" : {
- "$eq" : null
- }
- }
- ]
- }
- }
- },
- {
- "$lookup" : {
- "from" : "t38",
- "as" : "__joined_t38",
- "localField" : "__joined_t58.a58",
- "foreignField" : "b38",
- "unwinding" : {
- "preserveNullAndEmptyArrays" : false
- },
- "matching" : {
- "$nor" : [
- {
- "a38" : {
- "$eq" : null
- }
- }
- ]
- }
- }
- },
- {
- "$lookup" : {
- "from" : "t1",
- "as" : "__joined_t1",
- "localField" : "__joined_t38.a38",
- "foreignField" : "b1",
- "unwinding" : {
- "preserveNullAndEmptyArrays" : false
- },
- "matching" : {
- "$nor" : [
- {
- "a1" : {
- "$eq" : null
- }
- }
- ]
- }
- }
- },
- {
- "$lookup" : {
- "from" : "t47",
- "as" : "__joined_t47",
- "localField" : "__joined_t1.a1",
- "foreignField" : "b47",
- "unwinding" : {
- "preserveNullAndEmptyArrays" : false
- },
- "matching" : {
- "$nor" : [
- {
- "a47" : {
- "$eq" : null
- }
- }
- ]
- }
- }
- },
- {
- "$lookup" : {
- "from" : "t5",
- "as" : "__joined_t5",
- "localField" : "__joined_t47.a47",
- "foreignField" : "b5",
- "unwinding" : {
- "preserveNullAndEmptyArrays" : false
- },
- "matching" : {
- "$nor" : [
- {
- "a5" : {
- "$eq" : null
- }
- }
- ]
- }
- }
- },
- {
- "$lookup" : {
- "from" : "t7",
- "as" : "__joined_t7",
- "localField" : "__joined_t5.a5",
- "foreignField" : "b7",
- "unwinding" : {
- "preserveNullAndEmptyArrays" : false
- },
- "matching" : {
- "$nor" : [
- {
- "a7" : {
- "$eq" : null
- }
- }
- ]
- }
- }
- },
- {
- "$lookup" : {
- "from" : "t20",
- "as" : "__joined_t20",
- "localField" : "__joined_t7.a7",
- "foreignField" : "b20",
- "unwinding" : {
- "preserveNullAndEmptyArrays" : false
- },
- "matching" : {
- "$nor" : [
- {
- "a20" : {
- "$eq" : null
- }
- }
- ]
- }
- }
- },
- {
- "$lookup" : {
- "from" : "t51",
- "as" : "__joined_t51",
- "localField" : "__joined_t20.a20",
- "foreignField" : "b51",
- "unwinding" : {
- "preserveNullAndEmptyArrays" : false
- },
- "matching" : {
- "$nor" : [
- {
- "a51" : {
- "$eq" : null
- }
- }
- ]
- }
- }
- },
- {
- "$lookup" : {
- "from" : "t10",
- "as" : "__joined_t10",
- "localField" : "__joined_t51.a51",
- "foreignField" : "b10",
- "unwinding" : {
- "preserveNullAndEmptyArrays" : false
- },
- "matching" : {
- "$nor" : [
- {
- "a10" : {
- "$eq" : null
- }
- }
- ]
- }
- }
- },
- {
- "$lookup" : {
- "from" : "t33",
- "as" : "__joined_t33",
- "localField" : "__joined_t10.a10",
- "foreignField" : "b33",
- "unwinding" : {
- "preserveNullAndEmptyArrays" : false
- },
- "matching" : {
- "$nor" : [
- {
- "a33" : {
- "$eq" : null
- }
- }
- ]
- }
- }
- },
- {
- "$lookup" : {
- "from" : "t43",
- "as" : "__joined_t43",
- "localField" : "__joined_t33.a33",
- "foreignField" : "b43",
- "unwinding" : {
- "preserveNullAndEmptyArrays" : false
- },
- "matching" : {
- "$nor" : [
- {
- "a43" : {
- "$eq" : null
- }
- }
- ]
- }
- }
- },
- {
- "$lookup" : {
- "from" : "t45",
- "as" : "__joined_t45",
- "localField" : "__joined_t43.a43",
- "foreignField" : "b45",
- "unwinding" : {
- "preserveNullAndEmptyArrays" : false
- },
- "matching" : {
- "$nor" : [
- {
- "a45" : {
- "$eq" : null
- }
- }
- ]
- }
- }
- },
- {
- "$lookup" : {
- "from" : "t23",
- "as" : "__joined_t23",
- "localField" : "__joined_t45.a45",
- "foreignField" : "b23",
- "unwinding" : {
- "preserveNullAndEmptyArrays" : false
- },
- "matching" : {
- "$nor" : [
- {
- "a23" : {
- "$eq" : null
- }
- }
- ]
- }
- }
- },
- {
- "$lookup" : {
- "from" : "t56",
- "as" : "__joined_t56",
- "localField" : "__joined_t23.a23",
- "foreignField" : "b56",
- "unwinding" : {
- "preserveNullAndEmptyArrays" : false
- },
- "matching" : {
- "$nor" : [
- {
- "a56" : {
- "$eq" : null
- }
- }
- ]
- }
- }
- },
- {
- "$lookup" : {
- "from" : "t25",
- "as" : "__joined_t25",
- "localField" : "__joined_t56.a56",
- "foreignField" : "b25",
- "unwinding" : {
- "preserveNullAndEmptyArrays" : false
- },
- "matching" : {
- "$nor" : [
- {
- "a25" : {
- "$eq" : null
- }
- }
- ]
- }
- }
- },
- {
- "$lookup" : {
- "from" : "t62",
- "as" : "__joined_t62",
- "localField" : "__joined_t25.a25",
- "foreignField" : "b62",
- "unwinding" : {
- "preserveNullAndEmptyArrays" : false
- },
- "matching" : {
- "$nor" : [
- {
- "a62" : {
- "$eq" : null
- }
- }
- ]
- }
- }
- },
- {
- "$lookup" : {
- "from" : "t39",
- "as" : "__joined_t39",
- "localField" : "__joined_t62.a62",
- "foreignField" : "b39",
- "unwinding" : {
- "preserveNullAndEmptyArrays" : false
- },
- "matching" : {
- "$nor" : [
- {
- "a39" : {
- "$eq" : null
- }
- }
- ]
- }
- }
- },
- {
- "$lookup" : {
- "from" : "t6",
- "as" : "__joined_t6",
- "localField" : "__joined_t39.a39",
- "foreignField" : "b6",
- "unwinding" : {
- "preserveNullAndEmptyArrays" : false
- },
- "matching" : {
- "$nor" : [
- {
- "a6" : {
- "$eq" : null
- }
- }
- ]
- }
- }
- },
- {
- "$lookup" : {
- "from" : "t40",
- "as" : "__joined_t40",
- "localField" : "__joined_t6.a6",
- "foreignField" : "b40",
- "unwinding" : {
- "preserveNullAndEmptyArrays" : false
- },
- "matching" : {
- "$nor" : [
- {
- "a40" : {
- "$eq" : null
- }
- }
- ]
- }
- }
- },
- {
- "$lookup" : {
- "from" : "t13",
- "as" : "__joined_t13",
- "localField" : "__joined_t40.a40",
- "foreignField" : "b13",
- "unwinding" : {
- "preserveNullAndEmptyArrays" : false
- },
- "matching" : {
- "$nor" : [
- {
- "a13" : {
- "$eq" : null
- }
- }
- ]
- }
- }
- },
- {
- "$lookup" : {
- "from" : "t30",
- "as" : "__joined_t30",
- "localField" : "__joined_t13.a13",
- "foreignField" : "b30",
- "unwinding" : {
- "preserveNullAndEmptyArrays" : false
- },
- "matching" : {
- "$nor" : [
- {
- "a30" : {
- "$eq" : null
- }
- }
- ]
- }
- }
- },
- {
- "$lookup" : {
- "from" : "t55",
- "as" : "__joined_t55",
- "localField" : "__joined_t30.a30",
- "foreignField" : "b55",
- "unwinding" : {
- "preserveNullAndEmptyArrays" : false
- },
- "matching" : {
- "$nor" : [
- {
- "a55" : {
- "$eq" : null
- }
- }
- ]
- }
- }
- },
- {
- "$lookup" : {
- "from" : "t9",
- "as" : "__joined_t9",
- "localField" : "__joined_t55.a55",
- "foreignField" : "b9",
- "unwinding" : {
- "preserveNullAndEmptyArrays" : false
- },
- "matching" : {
- "$nor" : [
- {
- "a9" : {
- "$eq" : null
- }
- }
- ]
- }
- }
- },
- {
- "$lookup" : {
- "from" : "t37",
- "as" : "__joined_t37",
- "localField" : "__joined_t9.a9",
- "foreignField" : "b37",
- "unwinding" : {
- "preserveNullAndEmptyArrays" : false
- },
- "matching" : {
- "$nor" : [
- {
- "a37" : {
- "$eq" : null
- }
- }
- ]
- }
- }
- },
- {
- "$lookup" : {
- "from" : "t50",
- "as" : "__joined_t50",
- "localField" : "__joined_t37.a37",
- "foreignField" : "b50",
- "unwinding" : {
- "preserveNullAndEmptyArrays" : false
- },
- "matching" : {
- "$nor" : [
- {
- "a50" : {
- "$eq" : null
- }
- }
- ]
- }
- }
- },
- {
- "$lookup" : {
- "from" : "t8",
- "as" : "__joined_t8",
- "localField" : "__joined_t50.a50",
- "foreignField" : "b8",
- "unwinding" : {
- "preserveNullAndEmptyArrays" : false
- },
- "matching" : {
- "$nor" : [
- {
- "a8" : {
- "$eq" : null
- }
- }
- ]
- }
- }
- },
- {
- "$lookup" : {
- "from" : "t31",
- "as" : "__joined_t31",
- "localField" : "__joined_t8.a8",
- "foreignField" : "b31",
- "unwinding" : {
- "preserveNullAndEmptyArrays" : false
- },
- "matching" : {
- "$nor" : [
- {
- "a31" : {
- "$eq" : null
- }
- }
- ]
- }
- }
- },
- {
- "$lookup" : {
- "from" : "t19",
- "as" : "__joined_t19",
- "localField" : "__joined_t31.a31",
- "foreignField" : "b19",
- "unwinding" : {
- "preserveNullAndEmptyArrays" : false
- },
- "matching" : {
- "$nor" : [
- {
- "a19" : {
- "$eq" : null
- }
- }
- ]
- }
- }
- },
- {
- "$lookup" : {
- "from" : "t36",
- "as" : "__joined_t36",
- "localField" : "__joined_t19.a19",
- "foreignField" : "b36",
- "unwinding" : {
- "preserveNullAndEmptyArrays" : false
- },
- "matching" : {
- "$nor" : [
- {
- "a36" : {
- "$eq" : null
- }
- }
- ]
- }
- }
- },
- {
- "$lookup" : {
- "from" : "t64",
- "as" : "__joined_t64",
- "localField" : "__joined_t36.a36",
- "foreignField" : "b64",
- "unwinding" : {
- "preserveNullAndEmptyArrays" : false
- },
- "matching" : {
- "$nor" : [
- {
- "a64" : {
- "$eq" : null
- }
- }
- ]
- }
- }
- },
- {
- "$lookup" : {
- "from" : "t27",
- "as" : "__joined_t27",
- "localField" : "__joined_t64.a64",
- "foreignField" : "b27",
- "unwinding" : {
- "preserveNullAndEmptyArrays" : false
- },
- "matching" : {
- "$nor" : [
- {
- "a27" : {
- "$eq" : null
- }
- }
- ]
- }
- }
- },
- {
- "$lookup" : {
- "from" : "t3",
- "as" : "__joined_t3",
- "localField" : "__joined_t27.a27",
- "foreignField" : "b3",
- "unwinding" : {
- "preserveNullAndEmptyArrays" : false
- }
- }
- },
- {
- "$project" : {
- "_id" : false,
- "memtest_DOT_t14_DOT_x14" : "$__joined_t14.x14",
- "memtest_DOT_t13_DOT_x13" : "$__joined_t13.x13",
- "memtest_DOT_t36_DOT_x36" : "$__joined_t36.x36",
- "memtest_DOT_t33_DOT_x33" : "$__joined_t33.x33",
- "memtest_DOT_t50_DOT_x50" : "$__joined_t50.x50",
- "memtest_DOT_t23_DOT_x23" : "$__joined_t23.x23",
- "memtest_DOT_t27_DOT_x27" : "$__joined_t27.x27",
- "memtest_DOT_t15_DOT_x15" : "$__joined_t15.x15",
- "memtest_DOT_t55_DOT_x55" : "$__joined_t55.x55",
- "memtest_DOT_t10_DOT_x10" : "$__joined_t10.x10",
- "memtest_DOT_t4_DOT_x4" : "$__joined_t4.x4",
- "memtest_DOT_t34_DOT_x34" : "$__joined_t34.x34",
- "memtest_DOT_t29_DOT_x29" : "$__joined_t29.x29",
- "memtest_DOT_t62_DOT_x62" : "$__joined_t62.x62",
- "memtest_DOT_t22_DOT_x22" : "$__joined_t22.x22",
- "memtest_DOT_t43_DOT_x43" : "$__joined_t43.x43",
- "memtest_DOT_t3_DOT_x3" : "$__joined_t3.x3",
- "memtest_DOT_t7_DOT_x7" : "$__joined_t7.x7",
- "memtest_DOT_t26_DOT_x26" : "$__joined_t26.x26",
- "memtest_DOT_t28_DOT_x28" : "$__joined_t28.x28",
- "memtest_DOT_t19_DOT_x19" : "$__joined_t19.x19",
- "memtest_DOT_t39_DOT_x39" : "$__joined_t39.x39",
- "memtest_DOT_t45_DOT_x45" : "$__joined_t45.x45",
- "memtest_DOT_t24_DOT_x24" : "$__joined_t24.x24",
- "memtest_DOT_t42_DOT_x42" : "$__joined_t42.x42",
- "memtest_DOT_t2_DOT_x2" : "$__joined_t2.x2",
- "memtest_DOT_t25_DOT_x25" : "$__joined_t25.x25",
- "memtest_DOT_t53_DOT_x53" : "$__joined_t53.x53",
- "memtest_DOT_t51_DOT_x51" : "$__joined_t51.x51",
- "memtest_DOT_t31_DOT_x31" : "$__joined_t31.x31",
- "memtest_DOT_t58_DOT_x58" : "$__joined_t58.x58",
- "memtest_DOT_t47_DOT_x47" : "$__joined_t47.x47",
- "memtest_DOT_t64_DOT_x64" : "$__joined_t64.x64",
- "memtest_DOT_t56_DOT_x56" : "$__joined_t56.x56",
- "memtest_DOT_t37_DOT_x37" : "$__joined_t37.x37",
- "memtest_DOT_t9_DOT_x9" : "$__joined_t9.x9",
- "memtest_DOT_t63_DOT_x63" : "$__joined_t63.x63",
- "memtest_DOT_t49_DOT_x49" : "$__joined_t49.x49",
- "memtest_DOT_t6_DOT_x6" : "$__joined_t6.x6",
- "memtest_DOT_t18_DOT_x18" : "$__joined_t18.x18",
- "memtest_DOT_t17_DOT_x17" : "$__joined_t17.x17",
- "memtest_DOT_t59_DOT_x59" : "$__joined_t59.x59",
- "memtest_DOT_t48_DOT_x48" : "$__joined_t48.x48",
- "memtest_DOT_t41_DOT_x41" : "$__joined_t41.x41",
- "memtest_DOT_t60_DOT_x60" : "$__joined_t60.x60",
- "memtest_DOT_t5_DOT_x5" : "$__joined_t5.x5",
- "memtest_DOT_t46_DOT_x46" : "$__joined_t46.x46",
- "memtest_DOT_t1_DOT_x1" : "$__joined_t1.x1",
- "memtest_DOT_t32_DOT_x32" : "$__joined_t32.x32",
- "memtest_DOT_t20_DOT_x20" : "$__joined_t20.x20",
- "memtest_DOT_t38_DOT_x38" : "$__joined_t38.x38",
- "memtest_DOT_t40_DOT_x40" : "$__joined_t40.x40",
- "memtest_DOT_t30_DOT_x30" : "$__joined_t30.x30",
- "memtest_DOT_t52_DOT_x52" : "$__joined_t52.x52",
- "memtest_DOT_t8_DOT_x8" : "$__joined_t8.x8",
- "memtest_DOT_t35_DOT_x35" : "$x35",
- "memtest_DOT_t57_DOT_x57" : "$__joined_t57.x57",
- "memtest_DOT_t61_DOT_x61" : "$__joined_t61.x61"
- }
- }
- ],
- "ok" : 1
- }
- MongoDB Enterprise >
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement