[j0:s0:prim] {"t":{"$date":"2021-05-05T00:21:40.654+00:00"},"s":"I",  "c":"QUERY",    "id":4822861, "ctx":"conn83","msg":"SBE plan","attr":{"slots":"$$RESULT=s27 $$RID=s23 env: { timeZoneDB = s1 (TimeZoneDatabase(Indian/Comoro...Pacific/Majuro)), CLUSTER_TIME = s2 (Timestamp(1620174091, 1)), NOW = s3 (1620174100638) }","stages":"
[4] sort [s31] [asc] [s27, s23] 
[4] project [s31 = fillEmpty (s30, undefined)] 
[4] traverse s30 s29 s28 {if (s29 <=> s30 < 0, s29, s30)} {} 
from 
    [4] project [s28 = fillEmpty (getField (s27, \"val\"), null)] 
    [3] mkbson s27 s22 [val] keep [] true false 
    [2] filter {! fillEmpty (s26, false)} 
    [2] traverse s26 s25 s24 [s23, s22] {s26 || s25} {s26} 
    from 
        [2] project [s24 = getField (s22, \"val\")] 
        [2] nlj [] [s8, s4, s5, s6, s7] 
            left 
                [1] unique [s8] 
                [1] filter {isRecordId (s8)} 
                [1] lspool sp1 [s8, s4, s5, s6, s7] {! isRecordId (s8)} 
                [1] union [s8, s4, s5, s6, s7] [
                    [s13, s9, s10, s11, s12] [1] project [s9 = Nothing, s10 = Nothing, s11 = Nothing, s12 = Nothing, s13 = KS(0A0104)] 
                    [1] limit 1 
                    [1] coscan , 
                    [s21, s14, s15, s16, s17] [1] nlj [] [s19, s15, s17] 
                        left 
                            [1] sspool sp1 [s19, s15, s17] 
                        right 
                            [1] chkbounds s16 s18 s21 
                            [1] nlj [s15, s17] [s20] 
                                left 
                                    [1] project [s15 = \"val_1\", s17 = {\"val\" : 1}, s20 = s19] 
                                    [1] limit 1 
                                    [1] coscan 
                                right 
                                    [1] ixseek s20 none s16 s18 s14 [] @\"d1f575e1-3a15-42a0-bc82-ce1d4c3e9153\" @\"val_1\" true 
                                
                            
                        
                    
               ] 
            right 
                [2] limit 1 
                [2] seek s8 s22 s23 s4 s5 s6 s7 [] @\"d1f575e1-3a15-42a0-bc82-ce1d4c3e9153\" true false 
            
        
    in 
        [2] project [s25 = fillEmpty (if (! exists (s24) || typeMatch (s24, 0x00000440), null, s24) == null, false)] 
        [2] limit 1 
        [2] coscan 
    
in 
    [4] project [s29 = s28] 
    [4] limit 1 
    [4] coscan 
","querySolution":"
SORT
---type = SIMPLE
---pattern = { val: 1.0 }
---limit = 0
---nodeId = 4
---fetched = 1
---sortedByDiskLoc = 0
---providedSorts = {baseSortPattern: { val: 1.0 }, ignoredFields: []}
---Child:
------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  || Selected Index #1 pos 0 combine 1
---------------nodeId = 2
---------------fetched = 1
---------------sortedByDiskLoc = 0
---------------providedSorts = {baseSortPattern: {}, ignoredFields: []}
---------------Child:
------------------IXSCAN
---------------------indexName = val_1
---------------------keyPattern = { val: 1.0 }
---------------------direction = 1
---------------------bounds = field #0['val']: [MinKey, undefined), (null, MaxKey]
---------------------nodeId = 1
---------------------fetched = 0
---------------------sortedByDiskLoc = 0
---------------------providedSorts = {baseSortPattern: {}, ignoredFields: []}
","comment":"storchprint"}}
[j0:s0:sec1] {"t":{"$date":"2021-05-05T00:21:40.654+00:00"},"s":"I",  "c":"QUERY",    "id":4822861, "ctx":"conn45","msg":"SBE plan","attr":{"slots":"$$RESULT=s27 $$RID=s23 env: { timeZoneDB = s1 (TimeZoneDatabase(Indian/Mauritius...Indian/Mahe)), NOW = s3 (1620174100638), CLUSTER_TIME = s2 (Timestamp(1620174091, 1)) }","stages":"
[4] sort [s31] [asc] [s23, s27] 
[4] project [s31 = fillEmpty (s30, undefined)] 
[4] traverse s30 s29 s28 {if (s29 <=> s30 < 0, s29, s30)} {} 
from 
    [4] project [s28 = fillEmpty (getField (s27, \"val\"), null)] 
    [3] mkbson s27 s22 [val] keep [] true false 
    [2] filter {! fillEmpty (s26, false)} 
    [2] traverse s26 s25 s24 [s22, s23] {s26 || s25} {s26} 
    from 
        [2] project [s24 = getField (s22, \"val\")] 
        [2] nlj [] [s8, s4, s5, s6, s7] 
            left 
                [1] unique [s8] 
                [1] filter {isRecordId (s8)} 
                [1] lspool sp1 [s8, s4, s5, s6, s7] {! isRecordId (s8)} 
                [1] union [s8, s4, s5, s6, s7] [
                    [s13, s9, s10, s11, s12] [1] project [s9 = Nothing, s10 = Nothing, s11 = Nothing, s12 = Nothing, s13 = KS(0A0104)] 
                    [1] limit 1 
                    [1] coscan , 
                    [s21, s14, s15, s16, s17] [1] nlj [] [s19, s15, s17] 
                        left 
                            [1] sspool sp1 [s19, s15, s17] 
                        right 
                            [1] chkbounds s16 s18 s21 
                            [1] nlj [s15, s17] [s20] 
                                left 
                                    [1] project [s15 = \"val_1\", s17 = {\"val\" : 1}, s20 = s19] 
                                    [1] limit 1 
                                    [1] coscan 
                                right 
                                    [1] ixseek s20 none s16 s18 s14 [] @\"d1f575e1-3a15-42a0-bc82-ce1d4c3e9153\" @\"val_1\" true 
                                
                            
                        
                    
               ] 
            right 
                [2] limit 1 
                [2] seek s8 s22 s23 s4 s5 s6 s7 [] @\"d1f575e1-3a15-42a0-bc82-ce1d4c3e9153\" true false 
            
        
    in 
        [2] project [s25 = fillEmpty (if (! exists (s24) || typeMatch (s24, 0x00000440), null, s24) == null, false)] 
        [2] limit 1 
        [2] coscan 
    
in 
    [4] project [s29 = s28] 
    [4] limit 1 
    [4] coscan 
","querySolution":"
SORT
---type = SIMPLE
---pattern = { val: 1.0 }
---limit = 0
---nodeId = 4
---fetched = 1
---sortedByDiskLoc = 0
---providedSorts = {baseSortPattern: { val: 1.0 }, ignoredFields: []}
---Child:
------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  || Selected Index #1 pos 0 combine 1
---------------nodeId = 2
---------------fetched = 1
---------------sortedByDiskLoc = 0
---------------providedSorts = {baseSortPattern: {}, ignoredFields: []}
---------------Child:
------------------IXSCAN
---------------------indexName = val_1
---------------------keyPattern = { val: 1.0 }
---------------------direction = 1
---------------------bounds = field #0['val']: [MinKey, undefined), (null, MaxKey]
---------------------nodeId = 1
---------------------fetched = 0
---------------------sortedByDiskLoc = 0
---------------------providedSorts = {baseSortPattern: {}, ignoredFields: []}
","comment":"storchprint"}}
[j0:s0:sec1] {"t":{"$date":"2021-05-05T00:21:40.689+00:00"},"s":"I",  "c":"QUERY",    "id":4822860, "ctx":"conn57","msg":"SBE plan","attr":{"slots":"$$RESULT=s9 $$RID=s5 env: { CLUSTER_TIME = s2 (Timestamp(1620174091, 1)), NOW = s3 (1620174100679), timeZoneDB = s1 (TimeZoneDatabase(Indian/Mauritius...Indian/Mahe)) }","stages":"
[3] sort [s13] [asc] [s5, s9] 
[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 [] @\"82864bca-da56-4167-bf24-d0a15b0f40f4\" 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:21:40.689+00:00"},"s":"I",  "c":"QUERY",    "id":4822860, "ctx":"conn83","msg":"SBE plan","attr":{"slots":"$$RESULT=s9 $$RID=s5 env: { CLUSTER_TIME = s2 (Timestamp(1620174091, 1)), NOW = s3 (1620174100679), timeZoneDB = s1 (TimeZoneDatabase(Indian/Comoro...Pacific/Majuro)) }","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 [] @\"82864bca-da56-4167-bf24-d0a15b0f40f4\" 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"}}