[j0:s0:sec0] {"t":{"$date":"2021-05-05T00:30:09.590+00:00"},"s":"I",  "c":"QUERY",    "id":4822860, "ctx":"conn47","msg":"SBE plan","attr":{"slots":"$$RESULT=s17 $$RID=s13 env: { NOW = s3 (1620174609582), timeZoneDB = s1 (TimeZoneDatabase(America/Maceio...America/Fort_Wayne)), CLUSTER_TIME = s2 (Timestamp(1620174600, 1)) }","stages":"
[3] mkbson s17 s12 [val] keep [] true false 
[2] filter {! fillEmpty (s16, false)} 
[2] traverse s16 s15 s14 [s12, s13] {s16 || s15} {s16} 
from 
    [2] project [s14 = getField (s12, \"val\")] 
    [2] nlj [] [s8, s4, s5, s6, s7] 
        left 
            [1] unique [s8] 
            [1] nlj [s5, s7] [s9, s10] 
                left 
                    [1] project [s5 = \"val_1\", s7 = {\"val\" : 1}, s9 = KS(0A0104), s10 = KS(F0FE04)] 
                    [1] limit 1 
                    [1] coscan 
                right 
                    [1] project [s4 = s11] 
                    [1] ixseek s9 s10 s6 s8 s11 [] @\"5ad59443-fedd-4ffa-ab25-53938078a2ef\" @\"val_1\" true 
                
            
        right 
            [2] limit 1 
            [2] seek s8 s12 s13 s4 s5 s6 s7 [] @\"5ad59443-fedd-4ffa-ab25-53938078a2ef\" true false 
        
    
in 
    [2] project [s15 = fillEmpty (if (! exists (s14) || typeMatch (s14, 0x00000440), null, s14) == null, false)] 
    [2] limit 1 
    [2] coscan 
","querySolution":"
PROJ
---proj = { _id: false, val: true }
---type = SIMPLE_DOC
---nodeId = 3
---fetched = 1
---sortedByDiskLoc = 0
---providedSorts = {baseSortPattern: {}, ignoredFields: []}
---Child:
------FETCH
---------filter:
                $not
                    val $eq null
---------nodeId = 2
---------fetched = 1
---------sortedByDiskLoc = 0
---------providedSorts = {baseSortPattern: { val: 1 }, ignoredFields: []}
---------Child:
------------IXSCAN
---------------indexName = val_1
---------------keyPattern = { val: 1.0 }
---------------direction = 1
---------------bounds = field #0['val']: [MinKey, MaxKey]
---------------nodeId = 1
---------------fetched = 0
---------------sortedByDiskLoc = 0
---------------providedSorts = {baseSortPattern: { val: 1 }, ignoredFields: []}
","comment":"storchprint"}}
[j0:s0:prim] {"t":{"$date":"2021-05-05T00:30:09.594+00:00"},"s":"I",  "c":"QUERY",    "id":4822861, "ctx":"conn74","msg":"SBE plan","attr":{"slots":"$$RESULT=s17 $$RID=s13 env: { timeZoneDB = s1 (TimeZoneDatabase(Etc/GMT+4...Etc/GMT-4)), NOW = s3 (1620174609582), CLUSTER_TIME = s2 (Timestamp(1620174600, 1)) }","stages":"
[3] mkbson s17 s12 [val] keep [] true false 
[2] filter {! fillEmpty (s16, false)} 
[2] traverse s16 s15 s14 [s12, s13] {s16 || s15} {s16} 
from 
    [2] project [s14 = getField (s12, \"val\")] 
    [2] nlj [] [s8, s4, s5, s6, s7] 
        left 
            [1] unique [s8] 
            [1] nlj [s5, s7] [s9, s10] 
                left 
                    [1] project [s5 = \"val_1\", s7 = {\"val\" : 1}, s9 = KS(0A0104), s10 = KS(F0FE04)] 
                    [1] limit 1 
                    [1] coscan 
                right 
                    [1] project [s4 = s11] 
                    [1] ixseek s9 s10 s6 s8 s11 [] @\"5ad59443-fedd-4ffa-ab25-53938078a2ef\" @\"val_1\" true 
                
            
        right 
            [2] limit 1 
            [2] seek s8 s12 s13 s4 s5 s6 s7 [] @\"5ad59443-fedd-4ffa-ab25-53938078a2ef\" true false 
        
    
in 
    [2] project [s15 = fillEmpty (if (! exists (s14) || typeMatch (s14, 0x00000440), null, s14) == null, false)] 
    [2] limit 1 
    [2] coscan 
","querySolution":"
PROJ
---proj = { _id: false, val: true }
---type = SIMPLE_DOC
---nodeId = 3
---fetched = 1
---sortedByDiskLoc = 0
---providedSorts = {baseSortPattern: {}, ignoredFields: []}
---Child:
------FETCH
---------filter:
                $not
                    val $eq null
---------nodeId = 2
---------fetched = 1
---------sortedByDiskLoc = 0
---------providedSorts = {baseSortPattern: { val: 1 }, ignoredFields: []}
---------Child:
------------IXSCAN
---------------indexName = val_1
---------------keyPattern = { val: 1.0 }
---------------direction = 1
---------------bounds = field #0['val']: [MinKey, MaxKey]
---------------nodeId = 1
---------------fetched = 0
---------------sortedByDiskLoc = 0
---------------providedSorts = {baseSortPattern: { val: 1 }, ignoredFields: []}
","comment":"storchprint"}}
[j0:s0:sec1] {"t":{"$date":"2021-05-05T00:30:09.626+00:00"},"s":"I",  "c":"QUERY",    "id":4822860, "ctx":"conn45","msg":"SBE plan","attr":{"slots":"$$RESULT=s9 $$RID=s5 env: { CLUSTER_TIME = s2 (Timestamp(1620174600, 1)), NOW = s3 (1620174609618), timeZoneDB = s1 (TimeZoneDatabase(Asia/Tokyo...Asia/Karachi)) }","stages":"
[3] sort [s13] [asc] [s9, s5] 
[3] project [s13 = fillEmpty (s12, undefined)] 
[3] traverse s12 s11 s10 {if (s11 <=> s12 < 0, s11, s12)} {} 
from 
    [3] project [s10 = fillEmpty (getField (s9, \"val\"), null)] 
    [2] mkbson s9 s4 [val] keep [] true false 
    [1] filter {! fillEmpty (s8, false)} 
    [1] traverse s8 s7 s6 [s4, s5] {s8 || s7} {s8} 
    from 
        [1] project [s6 = getField (s4, \"val\")] 
        [1] scan s4 s5 none none none none [] @\"f5524f4d-d41d-4c05-a88c-dcec54d966a4\" true false 
    in 
        [1] project [s7 = fillEmpty (if (! exists (s6) || typeMatch (s6, 0x00000440), null, s6) == null, false)] 
        [1] limit 1 
        [1] coscan 
    
in 
    [3] project [s11 = s10] 
    [3] limit 1 
    [3] coscan 
","querySolution":"
SORT
---type = SIMPLE
---pattern = { val: 1.0 }
---limit = 0
---nodeId = 3
---fetched = 1
---sortedByDiskLoc = 0
---providedSorts = {baseSortPattern: { val: 1.0 }, ignoredFields: []}
---Child:
------PROJ
---------proj = { _id: false, val: true }
---------type = SIMPLE_DOC
---------nodeId = 2
---------fetched = 1
---------sortedByDiskLoc = 0
---------providedSorts = {baseSortPattern: {}, ignoredFields: []}
---------Child:
------------COLLSCAN
---------------ns = test.nonIndexedColl
---------------filter = $not
    val $eq null
---------------nodeId = 1
---------------fetched = 1
---------------sortedByDiskLoc = 0
---------------providedSorts = {baseSortPattern: {}, ignoredFields: []}
","comment":"storchprint"}}
[j0:s0:prim] {"t":{"$date":"2021-05-05T00:30:09.627+00:00"},"s":"I",  "c":"QUERY",    "id":4822860, "ctx":"conn83","msg":"SBE plan","attr":{"slots":"$$RESULT=s9 $$RID=s5 env: { NOW = s3 (1620174609618), CLUSTER_TIME = s2 (Timestamp(1620174600, 1)), timeZoneDB = s1 (TimeZoneDatabase(Etc/GMT+4...Etc/GMT-4)) }","stages":"
[3] sort [s13] [asc] [s9, s5] 
[3] project [s13 = fillEmpty (s12, undefined)] 
[3] traverse s12 s11 s10 {if (s11 <=> s12 < 0, s11, s12)} {} 
from 
    [3] project [s10 = fillEmpty (getField (s9, \"val\"), null)] 
    [2] mkbson s9 s4 [val] keep [] true false 
    [1] filter {! fillEmpty (s8, false)} 
    [1] traverse s8 s7 s6 [s4, s5] {s8 || s7} {s8} 
    from 
        [1] project [s6 = getField (s4, \"val\")] 
        [1] scan s4 s5 none none none none [] @\"f5524f4d-d41d-4c05-a88c-dcec54d966a4\" true false 
    in 
        [1] project [s7 = fillEmpty (if (! exists (s6) || typeMatch (s6, 0x00000440), null, s6) == null, false)] 
        [1] limit 1 
        [1] coscan 
    
in 
    [3] project [s11 = s10] 
    [3] limit 1 
    [3] coscan 
","querySolution":"
SORT
---type = SIMPLE
---pattern = { val: 1.0 }
---limit = 0
---nodeId = 3
---fetched = 1
---sortedByDiskLoc = 0
---providedSorts = {baseSortPattern: { val: 1.0 }, ignoredFields: []}
---Child:
------PROJ
---------proj = { _id: false, val: true }
---------type = SIMPLE_DOC
---------nodeId = 2
---------fetched = 1
---------sortedByDiskLoc = 0
---------providedSorts = {baseSortPattern: {}, ignoredFields: []}
---------Child:
------------COLLSCAN
---------------ns = test.nonIndexedColl
---------------filter = $not
    val $eq null
---------------nodeId = 1
---------------fetched = 1
---------------sortedByDiskLoc = 0
---------------providedSorts = {baseSortPattern: {}, ignoredFields: []}
","comment":"storchprint"}}