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))\n466 ms (28 ms, 91 ms, 115 ms (stage 1680.0: task 2242))";
2 [labelType="html" label="<br><b>Project</b><br><br>"];
3 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 42"];
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>160 ms (10 ms, 23 ms, 58 ms (stage 1680.0: task 2244))<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#266996 AS COL_AD630369_83AA_47E5_99A5_1BC51D22C541#267346, COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#267000 AS COL_1572BFA3_DDDA_4F31_8FAF_516D5C36472F#267347, COL_20AD4F6D_147A_4072_A6A0_C62D0125E2C7#267002 AS COL_0C2037FD_3581_461B_AEA3_DC760FD2AC67#267348, COL_54183A9C_BB78_4E5C_A82A_6463704C29E7#267008 AS COL_2D3D6E7B_1076_447A_8AC1_324180BDD199#267349, COL_9ECFD854_9A45_46E8_8152_73D647BA8492#267011 AS COL_5CCBA09B_828E_4247_BF1B_1F9B5A5E552D#267350, COL_7210BA0F_5C5A_403B_8D0D_FDA4825C09AF#267015 AS COL_D81BB554_A8C5_48BD_A343_214C2D9A7496#267351, COL_8158560B_3BDD_4F56_8693_E19CE3E307A2#267017 AS COL_A576D928_BEA8_4106_9C7C_B965F2065BE6#267352, COL_2FBBA722_3333_47A5_8FDC_A39C4810D864#267022 AS COL_E49C1A93_1121_4964_B611_F58301BF9540#267353, COL_F35FE9D7_9F9B_4932_AC23_6A16CF135287#267023 AS COL_FD918F65_4026_4DD2_9CCC_D24D14E4E832#267354, COL_D0645247_7443_420E_9CB1_B174B35E5D7C#267024L AS COL_FD4A5203_D41D_44A8_88E6_C994C001D545#267355L, COL_B5994D55_8078_4B80_A6C2_05C596D2AFD6#267032 AS COL_175A63B5_6467_4750_B596_BACC62A5D7EF#267356, COL_971CD607_9993_4586_97CB_B9EA6898834E#267037 AS COL_C4402863_5F96_4D87_9D7D_7AB76D196B38#267357, COL_4F9456B2_8E67_4DCC_A554_6449200831F5#267061 AS COL_8B29A36C_CEC1_434A_92AD_1F1A40F3A923#267365]
Filter (CASE WHEN isnull(StartsWith(str_remove_accent(upper(COL_54183A9C_BB78_4E5C_A82A_6463704C29E7#267008)), G24)) THEN false ELSE StartsWith(str_remove_accent(upper(COL_54183A9C_BB78_4E5C_A82A_6463704C29E7#267008)), G24) END AND CASE WHEN isnull(((COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#267000 >= 43.0) AND (COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#267000 <= 120.0))) THEN false ELSE ((COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#267000 >= 43.0) AND (COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#267000 <= 120.0)) END)