Show the Stage ID and Task ID that corresponds to the max metric
digraph G {
0 [labelType="html" label="<br><b>CollectLimit</b><br><br>"];
subgraph cluster1 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n290 ms (31 ms, 48 ms, 88 ms (stage 1705.0: task 2267))";
2 [labelType="html" label="<br><b>Project</b><br><br>"];
3 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 14"];
4 [labelType="html" label="<b>ColumnarToRow</b><br><br>number of output rows: 81,008<br>number of input batches: 25"];
}
5 [labelType="html" label="<b>Scan parquet </b><br><br>number of files read: 12<br>scan time total (min, med, max (stageId: taskId))<br>82 ms (9 ms, 13 ms, 20 ms (stage 1708.0: task 2280))<br>metadata time: 0 ms<br>size of files read: 5.2 MiB<br>number of output rows: 81,008"];
2->0;
3->2;
4->3;
5->4;
}
6
CollectLimit 500000
Project [COL_C5D93D9F_71F1_466B_9CF1_ED64875E8473#270513 AS COL_AD630369_83AA_47E5_99A5_1BC51D22C541#271234, COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#270517 AS COL_1572BFA3_DDDA_4F31_8FAF_516D5C36472F#271235, COL_20AD4F6D_147A_4072_A6A0_C62D0125E2C7#270519 AS COL_0C2037FD_3581_461B_AEA3_DC760FD2AC67#271236, COL_54183A9C_BB78_4E5C_A82A_6463704C29E7#270525 AS COL_2D3D6E7B_1076_447A_8AC1_324180BDD199#271237, COL_9ECFD854_9A45_46E8_8152_73D647BA8492#270528 AS COL_5CCBA09B_828E_4247_BF1B_1F9B5A5E552D#271238, COL_7210BA0F_5C5A_403B_8D0D_FDA4825C09AF#270532 AS COL_D81BB554_A8C5_48BD_A343_214C2D9A7496#271239, COL_8158560B_3BDD_4F56_8693_E19CE3E307A2#270534 AS COL_A576D928_BEA8_4106_9C7C_B965F2065BE6#271240, COL_2FBBA722_3333_47A5_8FDC_A39C4810D864#270539 AS COL_E49C1A93_1121_4964_B611_F58301BF9540#271241, COL_F35FE9D7_9F9B_4932_AC23_6A16CF135287#270540 AS COL_FD918F65_4026_4DD2_9CCC_D24D14E4E832#271242, COL_D0645247_7443_420E_9CB1_B174B35E5D7C#270541L AS COL_FD4A5203_D41D_44A8_88E6_C994C001D545#271243L, COL_B5994D55_8078_4B80_A6C2_05C596D2AFD6#270549 AS COL_175A63B5_6467_4750_B596_BACC62A5D7EF#271244, COL_971CD607_9993_4586_97CB_B9EA6898834E#270554 AS COL_C4402863_5F96_4D87_9D7D_7AB76D196B38#271245, COL_4F9456B2_8E67_4DCC_A554_6449200831F5#270578 AS COL_8B29A36C_CEC1_434A_92AD_1F1A40F3A923#271253]
Filter (CASE WHEN isnull(StartsWith(str_remove_accent(upper(COL_54183A9C_BB78_4E5C_A82A_6463704C29E7#270525)), G24)) THEN false ELSE StartsWith(str_remove_accent(upper(COL_54183A9C_BB78_4E5C_A82A_6463704C29E7#270525)), G24) END AND CASE WHEN isnull(((COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#270517 >= 70.0) AND (COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#270517 <= 120.0))) THEN false ELSE ((COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#270517 >= 70.0) AND (COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#270517 <= 120.0)) END)