ProjectNode + Relational Node ID:2 + Output Columns: 0: infectionid (long) 1: linkcultureid (integer) 2: expr3 (integer) + Statistics: 0: Node Output Rows: 2048 1: Node Next Batch Process Time: 0 2: Node Cumulative Next Batch Process Time: 337 3: Node Cumulative Process Time: 0 4: Node Next Batch Calls: 19 5: Node Blocks: 18 + Cost Estimates:Estimated Node Cardinality: 1053.7462 + Child 0: GroupingNode + Relational Node ID:3 + Output Columns: 0: gcol0 (long) 1: gcol1 (integer) 2: agg0 (integer) + Statistics: 0: Node Output Rows: 2048 1: Node Next Batch Process Time: 0 2: Node Cumulative Next Batch Process Time: 337 3: Node Cumulative Process Time: 0 4: Node Next Batch Calls: 19 5: Node Blocks: 18 + Cost Estimates:Estimated Node Cardinality: 1053.7462 + Child 0: JoinNode + Relational Node ID:4 + Output Columns: 0: gcol4 (long) 1: gcol5 (integer) + Statistics: 0: Node Output Rows: 74033 1: Node Next Batch Process Time: 53 2: Node Cumulative Next Batch Process Time: 117 3: Node Cumulative Process Time: 4900 4: Node Next Batch Calls: 55 5: Node Blocks: 18 + Cost Estimates:Estimated Node Cardinality: 30864.824 + Child 0: JoinNode + Relational Node ID:5 + Output Columns: 0: gcol1 (integer) 1: gcol2 (string) 2: gcol3 (timestamp) 3: gcol4 (long) 4: gcol5 (integer) + Statistics: 0: Node Output Rows: 12791 1: Node Next Batch Process Time: 7 2: Node Cumulative Next Batch Process Time: 20 3: Node Cumulative Process Time: 129 4: Node Next Batch Calls: 29 5: Node Blocks: 16 + Cost Estimates:Estimated Node Cardinality: 3161.2388 + Child 0: AccessNode + Relational Node ID:6 + Output Columns: 0: gcol0 (string) 1: gcol1 (integer) 2: gcol2 (string) 3: gcol3 (timestamp) 4: gcol4 (long) 5: gcol5 (integer) + Statistics: 0: Node Output Rows: 16322 1: Node Next Batch Process Time: 1 2: Node Cumulative Next Batch Process Time: 1 3: Node Cumulative Process Time: 110 4: Node Next Batch Calls: 48 5: Node Blocks: 16 + Cost Estimates:Estimated Node Cardinality: 5476.951 + Query:SELECT g_0.admissionid AS c_0, g_1.culturenr AS c_1, g_1.culturespecimennr AS c_2, g_1.culturesampleinsertts AS c_3, g_0.infectionid AS c_4, g_1.linkcultureid AS c_5 FROM cosara2.cos2_links AS g_0, cosara2.cos2_link_culture AS g_1 WHERE g_1.linkid = g_0.id GROUP BY g_0.admissionid, g_1.culturenr, g_1.culturespecimennr, g_1.culturesampleinsertts, g_0.infectionid, g_1.linkcultureid ORDER BY c_0 + Model Name:cosara2 + Child 1: SelectNode + Relational Node ID:7 + Output Columns: 0: patientid (integer) 1: expr (string) + Statistics: 0: Node Output Rows: 8047 1: Node Next Batch Process Time: 5 2: Node Cumulative Next Batch Process Time: 12 3: Node Cumulative Process Time: 12 4: Node Next Batch Calls: 8 5: Node Blocks: 0 + Child 0: ProjectNode + Relational Node ID:8 + Output Columns: 0: patientid (integer) 1: expr (string) + Statistics: 0: Node Output Rows: 8047 1: Node Next Batch Process Time: 5 2: Node Cumulative Next Batch Process Time: 7 3: Node Cumulative Process Time: 12 4: Node Next Batch Calls: 8 5: Node Blocks: 0 + Cost Estimates:Estimated Node Cardinality: 8047.0 + Child 0: AccessNode + Relational Node ID:9 + Output Columns:patientid (integer) + Statistics: 0: Node Output Rows: 8047 1: Node Next Batch Process Time: 2 2: Node Cumulative Next Batch Process Time: 2 3: Node Cumulative Process Time: 10 4: Node Next Batch Calls: 4 5: Node Blocks: 0 + Cost Estimates:Estimated Node Cardinality: 8047.0 + Query:SELECT #tmp_admissions.patientid FROM #tmp_admissions + Model Name:__TEMP__ + Select Columns: 0: adm.patientid 1: convert(adm.patientid, string) + Criteria:convert(adm.patientid, string) IN () + Dependent Join:true + Join Strategy:ENHANCED SORT JOIN RAN AS SORT MERGE (ALREADY_SORTED/SORT) + Join Type:INNER JOIN + Join Criteria:anon_grp1.gcol0=convert(adm.patientid, string) + Child 1: DependentAccessNode + Relational Node ID:10 + Output Columns: 0: culturenumber (integer) 1: specimennumber (string) 2: sampleinsertts (timestamp) + Statistics: 0: Node Output Rows: 58151 1: Node Next Batch Process Time: 44 2: Node Cumulative Next Batch Process Time: 44 3: Node Cumulative Process Time: 4748 4: Node Next Batch Calls: 61 5: Node Blocks: 4 + Cost Estimates:Estimated Node Cardinality: 301224.2 + Query:SELECT g_0.culturenumber AS c_0, g_0.specimennumber AS c_1, g_0.sampleinsertts AS c_2 FROM (cosara2.cos2_lab_culture AS g_0 LEFT OUTER JOIN cosara2.cos2_lab_sample AS g_1 ON g_1.inserttime = g_0.sampleinsertts AND g_1.specimennumber = g_0.specimennumber) LEFT OUTER JOIN cosara2.cos2_antibiogramresistences AS g_2 ON g_2.specimennumber = g_0.specimennumber AND g_2.culturenumber = g_0.culturenumber AND g_2.sampleinsertts = g_0.sampleinsertts WHERE (g_0.culturenumber IN ()) AND (g_0.specimennumber IN ()) AND (g_0.sampleinsertts IN ()) ORDER BY c_0, c_1, c_2 + Model Name:cosara2 + Dependent Join:true + Join Strategy:ENHANCED SORT JOIN RAN AS SORT MERGE (SORT/ALREADY_SORTED) + Join Type:LEFT OUTER JOIN + Join Criteria: 0: anon_grp1.gcol1=cl.culturenumber 1: anon_grp1.gcol2=cl.specimennumber 2: anon_grp1.gcol3=cl.sampleinsertts + Grouping Columns: 0: anon_grp1.gcol4 1: anon_grp1.gcol5 + Grouping Mapping: 0: anon_grp0.gcol0=anon_grp1.gcol4 1: anon_grp0.gcol1=anon_grp1.gcol5 2: anon_grp0.agg0=COUNT(*) + Sort Mode:false + Select Columns: 0: anon_grp0.gcol0 AS infectionid 1: anon_grp0.gcol1 AS linkcultureid 2: anon_grp0.agg0 AS expr3 + Data Bytes Sent:33711 + Planning Time:18