SQL Monitor Report

trace_id query_sql RETURN_ROWS REQUEST_TIME REQUEST_END_TIME ELAPSED_TIME TENANT_NAME user_name db_name plan_id tenant_id mysql_version svr_ip svr_port
YB42AC1A3181-000620B996AF95EA-0-0 select
/*test1000*/
*
from prod_sync_s_lazada
-- force index(index_store_s_sku)

where store_sub_sku in

(
'LA0133079577','LA012V16U998','LA017ES5A218','LA0191A34AZG','LA015E573U9K','LA012V16U998','LLA045E922C43493U','LLA047ZI6K46N3989','LLA045E922C43493U','LLA045XCYS8761ZNR','LLA045E922C43493U','LLA047ZI6K46N3989','LLA04R6J1N29J0MXK','LLA04935N9QO14F96','LZA03P34238B68Y00','LZA03E52W928DOVFS','LZA03L182E2T81877','LAD0920E29X6553','LAD10JSW12FX89A','LAD1117I92A7796','LAD20W92KE3S436','LAD200T32502M8J','LA01GRA4BA7O','LA02M12DUZK-Purple','LZ05T4W0L49951','LZ056674A11ONH','LZ0529290E3237','LAD20P91Z5W7S0X','LA01823IINRL','LAD09925BZ5L6N6','527zIDJt','LAD08U4X3AEZT52','LA01049AYC2U','07qpU4P3OX','07qpU4P3OX','Kp22ZeML','LA01GRA4BA7O','B9wz4W3z0z','zKsI7M23','LAD055JP0193261','LAD05IV04SW6HNS','LAD05T97476001O','LAD056B297J26I4','LAD10502QUW3G11','SQLaPe5F','CuA9251W','Q30DnW98','wK7pWYE2kB','LAD09MZK98II9KB','LAD20P91Z5W7S0X','LAD090D885M765M','LLA0448K72N5B45KJ','gYFl5Q6Azv7B','LAD10KL5097U6HN','27o6zXpZE8TF*5','yie1AJj1kEku','yie1AJj1kEku','W77L73Jr4uA2','LAD2027J66087Z6','6T33PG6N','hGQ0ew0l','48z3u97Q','j9Z79xa164JW','j9Z79xa164JW','ed8fmvzy2nT1','zbXuol9J55nr','LA0YS0052IMD','LAD092BF6BZ7H6F','9m9wY4SOa6jr','H86B13ithzh3','LA0TW0181VMD','LA1EI00UVEMD','yw2z59ZG','LAD09Z3Z7GJ66B5','LA13300IVWMD','LA13300IVWMD','LA1AE00QHLMD','LA1AE00QHLMD','LA1AE00QHLMD','LA1AE00QFRMD','LA1AE00QFQMD','LA0YS00RBLMD','LA1740056DMD','LA16800KB6MD','LA15Z011T1MD','LA0RZ008WMMD','LA0RZ008WJMD','LA13S00B6AMD','LZD04Z3Z3DPI*2','LZD04C5A821K*2','LZD0498522ZM*2','zGaSQqe3oi8y*6','LLA04V8ILGH13YYV1','LA0YS00RBMMD','LAD0603S6B659','LAD10Q5378V30JH','LZD04V2MOIZ4','LA1EU01CPJMD','LA1EU01CPHMD','LA1EU01CPGMD','LA1EU01CPFMD','sagrfuuyolio','sagrfuuyolio','LZD041VJ52VD','LZD041VJ52VD','LAD093HVV158718','LAD093HVV158718','LZD04C5A821K*2','LZD0498522ZM*2','1f942ZjQCIODY17','LZD044HSX788*2','LZD04G24YK50*2','LZD04R617954*2','LZD042S38N1F*2','LZD04Z3Z3DPI*2','LA01GSHT2061','LAD03TIE0030ZI0','LLA0448K72N5B45KJ','1AW6F645978sjep','LLA043I7A318JXN99','LAD09R72Z492VJ4','LA0RB01F5FMD','LA0RB01F5UMD','LA0RB01F5VMD','LA0RB01F5TMD','ZH1v99BJGC48','LAD206U3WOKZ08E','LA0T400ER7MD','LA0TW0181WMD','j9Z79xa164JW','LA0WY00U59MD*2','LA0WY00U57MD*2','LA0WY00U56MD*2','LA0YS00RBNMD','LA0YS00RBMMD','LA0YS00RBLMD','LA0YS0052NMD','LA0YS0052MMD','LA0YS0052LMD','LA0YS0052KMD','LA0YS0052JMD','LA0YS0052NMD','LA0YS0052MMD','LA0YS0052LMD','LA0YS0052KMD','LA0YS0052JMD','LA0YS0052IMD','LA0YS004W6MD','LA0YS004W5MD','LA0YS00RBNMD','LA0YS00RBMMD','LA0YS00RBOMD','LA0YS00RBNMD','LA0YS0052NMD','LA0YS0052MMD','LA0YS0052LMD','LA0YS0052KMD','LA0YS0052JMD','LA13D0052LMD','LA13D0052JMD','LA13D00L1CMD','LA13S01GZZMD','LA13300K8SMD','LA13300K8RMD','LA14M01CPMMD','LA14M01CPLMD','LA14M01CPKMD','LA14M01CPJMD','LA14M01CPIMD','LA14M01CPHMD','LA14M01CPGMD','LA14M01CPFMD','LA16800OY5MD','LA16800OY6MD','LA16800OY3MD','LA16F0129XMD','LA16F0129VMD','LA16F0129SMD','LA16Q008WLMD','LA17400IZMMD','48z3u97Q','LA18V01A27MD','LA18V01A26MD','LA18V01A25MD','LA18V01A24MD','LA18V01A23MD','LA18V01A22MD','LA19D00D3VMD','LA1AE00QFSMD','LA1A800Q75MD','LA1BP00ZISMD','LA1BP00ZIRMD','LA1BP00ZIQMD','LA1EI00UVDMD','LA1EI00UVCMD','LA02M12DUZK-Multicolor','LA02M12DUZK-Coffee','LA02M12DUZK-Blue','LA02994T65Q-E','LA02994T65Q-B','LA02994T65Q-A','LA1BU01H6DMD','9b797Ja3u253Z84','LA0TP01HNIMD','LAD09CJ9Y74B591','LAD09Y021NFG4YA','LAD09CJ9Y74B591','7Z72p4X9Hcpj','5W8v320yp1wEb3J','LAD09G6U6041WYK','LAD091S57O12Z29','LA13301A2EMD','LZD044HSX788*2','LZD04G24YK50*2','LZD0434G2AI2*2','LZD04R617954*2','LZD042S38N1F*2','6ej3rUS1GLt8','LA1E0010KKMD','LA1E0010PBMD','LA11101H5RMD','LA1AE00XKTMD','LA1AE014U8MD','LA1AE014U7MD','LZD0422P4WUC','LZD0422P4WUC','LA0RB01F5QMD','LA0RB01F5OMD','LA0RB01F5PMD','LA0RB01F5KMD','LA0RB01F5LMD','LA0RB01F5JMD','LA0RB01F5GMD','LA0RB01F5EMD','l7ALJPiJ2LhrY33','0E9R4T0GDiqQs6j','dWZZ843bc1hlr9g','30rZN9Jgx52J84K','q8Hg8cN12O3d77H','l2P2FnyyZ9ji','CHozBlRBUluX58e*4','LA0RB01F5RMD','LA0RB01F5MMD','LA0RB01F5NMD','LA0RB01F5IMD','LA0RB01F5HMD','LA0RB01F5WMD','LA0RB01F5XMD','LA0RB01F5SMD','LA0TA013AIMD','19Hp77LbON4lg48','2KUH5240848X84I','s5Wy4fYeWOQW','LD54p7azuzHq','a2pbUKs51CWxy8w','a2pbUKs51CWxy8w','yf718ULrEZg5a01','LA0Q6003LEMD','LA0Q600XQ0MD','LA0Q600XPZMD','LA0Q600XPYMD','LA0OK0041QMD','LA0OK0041QMD','LA0OK00FR9MD','LA0OK00FR8MD','LA0OK0041QMD','Wq28N0V1yBw8O2l','l52C35bQS5enM8f','xs4LCcvp1T0gcGG','BaKES0sUm09Md3J','87c58TZ32nnTN5i','LA0TW01KQNMD','LA0TW01KQOMD','V7Raq51h2kIF','4A9Z0Q7cG96cA78','Hxrh06H2zMcWR5t','of7aFLEhb3lBS2w','34Ho4ZK45zUrQIq','UQZpJVa9Qj8PhDV','LA0OK01G1CMD','LA0OK01G1AMD','LA0OK01G1BMD','LA0OK01G19MD','LA0OK01G1BMD','LA0OK01G19MD','LA0OK00774MD','LAD20GW81H362IQ','LA0OK00HXVMD','LA0OK00H39MD','LA0OK00H37MD','LA0OK00H38MD','LA0OK018CCMD','LA0OK018CBMD','LA0OK018CAMD','LA0OK018C9MD','LA0OK018C8MD','LA0OK00RKXMD','LA0OK00GMWMD','LA0OK006IIMD','LA0OK006QVMD','LA0OK006IHMD','LA0OK00AECMD','LA0OK01LPWMD','LA0OK0165XMD','LA0OK0165VMD','LA0OK01LIEMD','LA0OK01LILMD*3','LA0OK01LGAMD','LA0OK01LGZMD','LA0OK01LG7MD','72F2mnpLrZi7D75','LA0OX00ZK5MD','LA0OX00ZK6MD','LA0OX00ZK7MD','LA0OX00ZK8MD','LA0OK00MCHMD','LA0OK01QQZMD*50','LA0OK01QQXMD*50','LA0OK00S5LMD','LA0OK01N14MD','LA0OK01N12MD','LA0OK01N13MD','LA0OK01N10MD','LA0OK01N11MD','LA0OK01N0ZMD','LA0OK01CT3MD','LA0OK01CT1MD','LA0OK01CT0MD','LA0OK01CSZMD','LA0OK01CSYMD','LA0OK01CSXMD','LA0OK01CSWMD','LA0OK01CSVMD','LA0OK01CSUMD','LA0OK01CSTMD','LA0OK01CSSMD','LA0OK01CSRMD','LA0OK01CSQMD','LA0OK01CSOMD','LA0OK01CSNMD','LA0OK01A06MD','LA0OK01A05MD','LA0OK01A04MD','LA0OK01A03MD','LA0OK01A02MD','LA0OK01A01MD','LA0OK01A00MD','LA0OK019ZZMD','LA0OK019ZYMD','LA0OK019ZXMD','LA0OK019ZWMD','LA0OK019ZVMD','LA0OK01GDFMD','LA0OK01GDFMD','LA0OK00HHXMD','LA0OK00HHWMD','LA0OK00HHVMD','LA0OK00HHUMD','LA0OK00HHTMD','LA0OK00HHSMD','LA1J201FGLMD','LA1MO00RPDMD','LA0OK019MHMD','616pO18i3BSZ','LA1OB01KF4MD','LA1OB00IB9MD','LA1OB00IB8MD','LA1OB00IB6MD','LA1OB01KF4MD','LA1OB00ZQMMD','LA1OB00ZR0MD','LA1OB00ZQZMD','LA1OB00ZQYMD','LA1OB00ZQXMD','LA1OB00ZQWMD','LA1OB00ZQVMD','LA1OB00ZQUMD','LA1OB00ZQTMD','LA1OB00ZQSMD','LA1OB00ZQRMD','LA0OK01LHRMD','LLA04766GQ3ZZH706','488j0rpxjxJD5f9','LA0QC002MAMD','VzBavi2S9x97PMx','77vhgA5nFF08OZu','LA0OK006LBMD','LA0OK006LAMD','LA0OK006L9MD','LA0OK01TGXMD','LA0OK01TGVMD','LA0P300PPUMD','LA0Q0011DEMD','LA18501DSIMD','LA18501DSHMD','LA18501DSGMD','LA18501DSFMD','LA0P301NKAMD','LA0P301NK8MD','LA0P301NK9MD','LA0P301NK6MD','LA0P301NK7MD','LA1DU01A2DMD','LA1DU01A2CMD','LA1DU01A2BMD','LA1DU01A2AMD','LA1DU01A29MD','LA1DU01A2FMD','LA1DU01A2EMD','LA1DU01A2CMD','mi8FE90VP68rbmE','LA1TZ00M87MD','LA1TZ00M86MD','LA1TZ00M85MD','LA1U500I1PMD','LA1U500I1OMD','LA1U500I1NMD','LA1XT002LDMD','LA1XT002LCMD','LA1VT007F0MD/NX0','LA1VT007EZMD/NX0','LA1VT007EYMD/NX0','LA1VT007EXMD/NX0','LA1WZ00FVFMD','LA1XZ00WL9MD','LA18501OPBMD','LA18501OPBMD','LA0PU00R33MD','LA0PU00R32MD','LA0PU00R30MD','LA0P3016VTMD','LA0P3016VSMD','LA0P3016VRMD','LA0P3016VQMD','LA0P3016VPMD','LA0P300TAXMD','LA0P300TAWMD','LA0P300TAVMD','LA0P300TAUMD','LA0P300TASMD','LA0P3011RIMD','t5Gl04Tb6EyDK31','LA1850027QMD','LA1850027PMD','LA1850027OMD','LA1850027NMD','LA18501480MD','LA0P300QXOMD','LA0P300QXNMD','LA0P300QXMMD','LA0P300QXLMD','j66ZtTP5','LA0P3004W6MD','LA0P3004W5MD','LA0P301R9JMD','LA0PU01WNMMD','LA0PU01WNNMD','LA0PU01WNKMD','LA0PU01WNLMD','LA0OK01VDEMD','LA0OK01VDCMD','LA0OK01VDDMD','LA0OK01WMMMD','LA0OK01VEGMD-red','LA18500SBFMD','LA0OK01X78MD','LA0PA01XAAMD','LA0PA01XABMD','LA0PA01XA6MD','LA0PA01XA7MD','LA0PA01XA4MD','LA0PA01XA5MD','LA0PA01XA3MD','LA21I00H6SMD','NCjD8nib095Pv2a','mLPt9MzO8PEMe55','6imiLrQ1-Silver-16 MM*2','5W8v320yp1wEb3J','LA0Q0015OKMD','LA1ZI000KRMD','LA0OK01ZHYMD','LA0OK01ZHXMD','LA0OK01ZHUMD','LA0OK01ZHSMD','LA0OK01ZHTMD','LA0OK01ZLTMD','LA0OK01ZIKMD','LA0OK01ZILMD','LA0OK01ZIJMD','LA0OK01ZIGMD','LA0OK01ZIFMD','CD0HTgmHyOK8PuO','LA23U01WMJMD','LA23U01WMHMD','LA0QC0211GMD','LA0QC0211EMD','LA0QC0211DMD','LA0QC0211AMD','LA0QC0211BMD','70203q1z1Fj37eN','iWL1bl84M94b5Z0','An48NDB6kb6w3m7','u829v9SA5MbVMgw','64da389z7h9X1Oc','gHvbS3G3STV4KIG','LA28J021FOMD','LA28J021FNMD','Nu137r60r63k6l1','LA0OK0210MMD','LA0OK0210KMD','LA0OQ016CYMD','LA0OQ019BBMD','LA0OQ016CYMD','LA2BV00HH3MD','LA2BV00HH2MD','LA2FP022RVMD','LA2BP01R4NMD','LA1DU023HRMD','LA1D001WNPMD','LA0Q0023HVMD','LA23O01ZHNMD','LA23O01ZHIMD','LA23O01ZHFMD','LA23O01ZHDMD','LA0U6023KLMD','LA0U6023KJMD','LA2EJ0240UMD','LA0U601MNQMD','LA0U601MNPMD','LA2VJ017Z7MD','LA1XZ01ZPRMD','LA0OK023P3MD','LA0OK026OOMD','LA0OK026ONMD','LA0OK024K0MD','LA0OK024JYMD','LA0OK024JUMD','LA0OK024JVMD','LA0OK024JTMD','LA15301ZHHMD','LA15301ZHEMD','LA0WY028C5MD*10','LA0OQ021FPMD','ATMG3C04/WAS','LA2BV00QJAMD*2','LA2BV00QJAMD*2','LA2BV01G4RMD','LA1XZ0236IMD','LA34J00IY1MD','LA2U7003TKMD','LA2U700HATMD','LA34J00976MD','LA34J00975MD','LA34J00974MD','LA34J00VNUMD','LA34J00VNTMD','LA34J00VNSMD','LA34J00VNRMD','LA34J00JYFMD*10','45Bzg3KTZEiaXxT','7Z27zRds9b4Un43','LA0Q002AB4MD','LA0Q002AB5MD','LA34J00ROLMD','LA34J00ROKMD','LA0OX02AKVMD','LA0OX028AZMD','LA34J008XQMD','LA34J01RUYMD','LA34J01RUYMD','LA12X02BPNMD','LA15G01CR1MD','LA16Q02BOLMD','LA0Q0021KNMD','LA0Q0021KLMD','lgonqJ1NH0TveRA','C15o4EHRbv7TwM7','LA0Q001JSYMD','LA0Q001JSZMD','LA0Q001JSWMD','LA0Q001JSXMD','LA0Q001JSVMD','LA0Q001UN1MD','LA0Q001UMZMD','LA0Q0008HKMD','LA0Q00053FMD','LA0Q00053EMD','LA0Q00053DMD','LA0Q001T4MMD','LA13301JSVMD','LA13301JSYMD','LA13301JSZMD','LA13301JSWMD','LA13301JSXMD','LA2UD01KHDMD','LA2UD01KHAMD','LA2UD01KHBMD','LA2LJ015S2MD','LA2LJ016VTMD','LA2LJ016VRMD','LA2LJ016VQMD','LA2LJ016VPMD','LA17X01W6SMD','LA2PJ02BV7MD','LA0P302BZ2MD','LA0P302BZ3MD','LA34D01KJ4MD','LA34D01KJ5MD','LA2FP0294ZMD','LA2G702385MD','LA35J020UAMD','LA35J020U8MD','LA35J020U9MD','LA35J020U6MD','LA35J020U7MD','LA2CJ008CMMD','LA0Q600RBDMD','LA0Q600RBCMD','LA0Q600RBBMD','LA35702CR2MD','LA3570270SMD','LA31102BV8MD','LA31102BV7MD','LA0Q002DEEMD','LA1VT00XPZMD','LA13302DEEMD','LA13302DEFMD','LA13302DEDMD','LA2Q100XX0MD','LA0RT02BOOMD','LA0RT02BOPMD','LA0RT02BOMMD','LA0RT02BOLMD','LA2N2021D1MD','LA36100M3OMD','LA0OK02CSTMD','LA0OK02CSEMD','LA38P00J3SMD','LA19D01UGUMD','LA19D01UGVMD','LA19D01UGSMD','LA19D01UGTMD','LA19D01UGQMD','LA19D01UGRMD','LA19D01UGOMD','LA19D01UGPMD','LA19D01UGMMD','LA19D01UGNMD','LA19D01UGKMD','LA19D01UGLMD','LA19D01UGIMD','LA19D01UGJMD','LA19D01UGGMD','LA19D01UGHMD','LA19D01UGEMD','LA19D01UGFMD','LA19D01UHEMD','LA19D01UHCMD','LA19D01UHDMD','LA19D01UHAMD','LA19D01UHBMD','LA19D01UH8MD','LA19D01UH9MD','LA19D01UH6MD','LA19D01UH7MD','LA19D01UH4MD','LA19D01UH5MD','LA19D01UH2MD','LA19D01UH3MD','LA19D01UH0MD','LA19D01UH1MD','LA19D01UGYMD','LA19D01UGZMD','LA19D01UGWMD','LA19D01UGXMD','LA3FD02DXJMD','LA3FD02DXHMD','LA3FD026ONMD','LA2OV00UK6MD','LA33701A68MD','LA3570261BMD','LA2N8023JDMD','LA3N70218CMD','LA3N70218BMD','ATMC5A09-A/YUJKS','LA19D01JCDMD','LA19D01JCAMD','LA19D01JCBMD','LA19D01JC8MD','LA19D01JC9MD','LA3V101XCFMD','LA0QC00R7JMD','LA3Y20215MMD','LA3Y20215FMD','LA1D002FPVMD','LA0SH02EV4MD','LA0SH02EV5MD','LA3NV01DR8MD','LA0WY02EY8MD','LA0WY02EY9MD','LA0WY02EY6MD','LA0WY02EY7MD','LA0WY02EY4MD','LA0WY02EY5MD','LA0OK02EB0MD','LA0OK02EB1MD','LA0OK02EAYMD','LA0OK02EAZMD','LA0OK02EAXMD','LA22O02EUZMD','LA3SJ026B3MD','LA3SJ026B7MD','LA3SJ026B6MD','LA3SJ026B5MD','LA3SJ026B2MD','LA3SJ026AZMD','LA2KP0221IMD','LA2KP0221GMD','LA2KP0221HMD','LA2KP0221EMD','LA2KP0221FMD','LA2KP0221CMD','LA2KP0221DMD','LA3XQ02CR1MD','LA2OP02EBWMD','LA2OP02EBUMD','LA2OP02EBTMD','LA0UC00GV8MD','LA34J010ZKMD','LA0Q002FKJMD','LA0Q002FKIMD','LA0Q002FKJMD','LA0Q002FPVMD','LA0WY02EX5MD','LA0PA01XXEMD','LA0PA01XXCMD','LA0PA01XXDMD','LA0RT02GJ1MD','LA0RT02FKIMD','LA1RV02E7SMD','LA1RV02E7QMD','LA0RT02FPKMD','LA39P02GTWMD','LA2PJ00CUHMD','LA0OK02F2GMD','LA0OK02F2FMD','LA0OK02F2EMD','LA0OK02F2DMD','LA48S00NJJMD','LA2VP01CREMD*5','LA46400ROLMD','LA46400ROKMD','LA46400M3GMD','LA3W202CR7MD','LAD0915H960C7VP','LAD09Y8246EFN15','LAD099J54ABQQ64','LAD0944H5X70TKV','LAD09P3H2EY539Z','LAD0905T30VG6OP','LAD09WR544SR91E','LAD0952Z057002N','LAD090O01T4137C','LAD09EZM6JI48O2','LAD0991Z75EFB1S','LA0P302GHRMD','LA0P302GHOMD','LA0P302GHPMD','LA0P302GI4MD','LA0P302GI2MD','LA0P302GI3MD','LA0P302GI0MD','LA0P302GHYMD','LA0P302GHWMD','LA0P302GHUMD','LA0P302GHVMD','LA0P302GHTMD','LA0YM0094TMD','LA0YS0053EMD','LA3XW02CZGMD','LA3XW02CZHMD','LA3XW00XIRMD','LA2OP01E7TMD','LA2OP01E7RMD','LA2OP01E7QMD','LA1EI0218CMD','LA1EI0218DMD','LA1EI0218BMD','BCDB7B22-W/QWE','LA45A02FPQMD','LA45A02FPRMD','LA45A02FPOMD','LA45A02FPPMD','LA0OQ02AFGMD','LA0OQ02AFEMD','LA3WW02H10MD','LA3WW02H0WMD','LA3WW02H11MD','LA3WW02H0XMD','LA3WW02H0VMD','LA197020XLMD','LA197020XJMD','LA197020XHMD','LA197020XEMD','LA197020XAMD','LA197020XBMD','LA197020X8MD','LA197020XRMD','LA197020XOMD','LA3O702GLEMD','LA3T701RHBMD','LA45S00HHRMD','LA45S00HHQMD','LA3EV009GKMD','LA3TD02386MD','LA3TD02385MD','LA2SV00K3OMD','LA0YS01782MD','LA0YS01781MD','LA0YS01780MD','LA0YS0177ZMD','LA0YS0177YMD','LA0YS0177XMD','LA0P3015RTMD','LZA030RZN30M1SBHB','LA0P3021D6MD','LA39J0094TMD','LA39J0094SMD','LA0RT02I78MD','LA0RT02I77MD','LA0U601KJ4MD','LA0U601KJ5MD','LA46G00FQDMD','LA46G00FQCMD','LA0YS015JKMD','LA3Y800ZQWMD','LA54102BMJMD','LA16F019ZXMD','LA4JS00H9BMD','LA0OK023RVMD','LA0OK023RPMD','LA0OK0283OMD','LA0OK0283PMD','LA0OK0283NMD','938Ui502bQFzI94','LA3XW01QAIMD','LA1SN0050GMD','LA1SN0050BMD','dgoOI322xz7Zepq','LA1AQ02EZXMD','LA1AQ02EZWMD','LA3S101CSUMD','LA0QT02HV1MD*10','LA18J02IROMD','LA18J02IRMMD','LA18J02IRNMD','LA4H400RBBMD','LA1NZ0287OMD','LA1NZ0287PMD','LA1NZ0287MMD','LA1NZ0287NMD','LA0PU02FKIMD','LA0PU02FKJMD','LA1AK02CSDMD','LA2FV02410MD','LA4PP00MVVMD','LA0OK02GBOMD','LA18500JCHMD','LA18500JCHMD','LA3SJ01QIHMD','LA4T701BXLMD*4','LA3XW01OAPMD*4','LA0SB02IRNMD','LA18500K3PMD','LA18500K3OMD','LA4KS010I1MD','LA4OJ00TL6MD','q8Hg8cN12O3d77H','0E9R4T0GDiqQs6j','LA2BP01R4OMD','LA2BP01R4PMD','LA0P301R9LMD','LA0P301R9KMD','LZA03800739ZXYBP3','LZA03WP523CYIG4VZ','LZA038DU74ZW39F0L','LZA0378N7PQRULI32','LA18J00V4NMD','ZA4i1380-01','LA4ND00IRZMD','LA1DU01PEZMD','LA0OQ02AFKMD','LA0OQ02AFIMD','LA0YS00F2FMD','LA0P302B32MD','LA0P302B33MD','LA0P302B30MD','LA0P302B31MD','LA0YS00F2IMD','LA0YS00F2HMD','LA0YS00F2GMD','LA197020XKMD','LA197020XIMD','LA197020XFMD','LA197020XNMD','LA197011BLMD','LA2VP01CRJMD*5','LA2VP01CRIMD*5','LA2VP01CRHMD*5','LA2VP01CRGMD*5','LA2VP01CRFMD*5','LA2VP01CRDMD*5','LA2VP01CRCMD*5','LA2VP01CRBMD*5','LA2VP01CRAMD*5','LA3570261AMD','LA35702619MD','LA3SJ026AYMD','LA3SJ026B4MD','LA3SJ026B0MD','LA3SJ026B1MD','LA3SJ01QIJMD','LA3SJ01QIIMD','LA3WW02H0ZMD','LA3WW02H0YMD','LA3WW02H12MD','LA3W202CR3MD','LA3W202CR2MD','LA3W202CR8MD','LA3W202CR5MD','LA133017V7MD','LA0OQ019BAMD','LA0OQ019B9MD','LA13301A2NMD','LA13301A2LMD','LA13301A2IMD','LA13301A2MMD','LA13301A2KMD','LA13301A2JMD','LA0Q002GHTMD*2','LA0Q002FKIMD','LA17B01BABMD','LA1DU01PEYMD','LA029ZR842I-Purple','LA0OK023P2MD','LA0OX02AKTMD','LA0OX02AKSMD','LA0OX02AKUMD','LA0OX02AKXMD','LA0OX02AKWMD','LA0OX02AKZMD','LA0OX02AKYMD','LA0OX02AL0MD','LA0P302B2ZMD','LA13300IVXMD','LA13300IVYMD','LA133017V6MD','LA1VT00XPYMD','LA1VT00XQ0MD','LA54102BMHMD','LA54102BMGMD','LA17B00948MD','LA16Q02BOOMD','LA16Q02BOPMD','LA16Q02BOMMD','LA16Q02BONMD','LA16Q02BOKMD','LA16Q02BOIMD','LA16Q02BOJMD','LA16Q02BOHMD','LA0OQ015RYMD','LA0OQ015RUMD','LA0OQ015RRMD','LA0OQ015ROMD','LA0OQ015RNMD','LA01WM9Y60V0-B','LA0Q0023HWMD','LA0Q0023HUMD','LA0Q0023HSMD','LA0Q0023HTMD','LA0Q0023HRMD','LAD091ZX6909I56','LZA0325G634DLF445','LZA03ZI112IFZWU89','LZA03B2326FQ20KH0','LZA0375Z751T779B4','LA0QC00GJOMD','LA0QC00GJLMD','LA0QC00GJJMD','LA0QC00GJIMD','LA0QC00GJQMD','LA2N2021D2MD','LA0OK01G1CMD','LA0OK01G1AMD','ZA4i1380-06','ZA4i1380-05','ZA4i1380-04','ZA4i1380-03','ZA4i1380-02','LA0OK01WMOMD'
)		 1065 2024-12-04 16:28:58.675900 2024-12-04 16:38:58.730400 600054487 mengxuan mengxuan_admin trade_online 30705956 1002 5.7.25-OceanBase_CE-v4.2.1.8 172.26.49.129 2882 
select * from oceanbase.gv$ob_plan_cache_plan_explain where tenant_id = 1002 and plan_id = 30705956  and svr_ip = '172.26.49.129' and svr_port = 2882
+-----------+---------------+----------+----------+------------+--------------+----------------+--------------------+------+----------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| TENANT_ID | SVR_IP        | SVR_PORT | PLAN_ID  | PLAN_DEPTH | PLAN_LINE_ID | OPERATOR       | NAME               | ROWS | COST     | PROPERTY                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |
+-----------+---------------+----------+----------+------------+--------------+----------------+--------------------+------+----------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 1002      | 172.26.49.129 | 2882     | 30705956 | 0          | 0            | PHY_TABLE_SCAN | prod_sync_s_lazada | 911  | 20444006 | table_rows:323008203, physical_range_rows:510135215, logical_range_rows:307746287, index_back_rows:0, output_rows:910, avaiable_index_name[index_p_id,index_store_sub_id,idx_acct_id,idx_shop_sku,index_prod_s_sku,index_store_s_sku,idx_prod_s_id,prod_sync_s_lazada], pruned_index_name[index_p_id,index_store_sub_id,idx_acct_id,idx_shop_sku,index_prod_s_sku,idx_prod_s_id], estimation info[table_id:539647, (table_type:10, version:-1--1--1, logical_rc:316820074, physical_rc:316820074), (table_type:11, version:-1--1--1, logical_rc:-9649303, physical_rc:191551149), (table_type:12, version:-1--1--1, logical_rc:13418, physical_rc:633440), (table_type:0, version:-1--1--1, logical_rc:559682, physical_rc:1119365), (table_type:0, version:-1--1--1, logical_rc:2416, physical_rc:11187)] |
+-----------+---------------+----------+----------+------------+--------------+----------------+--------------------+------+----------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

SCHEMA 信息

SQL_AUDIT 信息

SQL_PLAN_MONITOR DFO 级调度时序汇总

调度时序图

数据时序图

SQL_PLAN_MONITOR SQC 级汇总

Goto 算子优先 Goto 机器优先

算子优先视图

机器优先视图

SQL_PLAN_MONITOR 详情

Goto 算子优先 Goto 线程优先

算子优先视图

线程优先视图

本报告在租户下使用的 SQL

DFO 级
select
  AVG(ROWS) EST_ROWS, /*0*/
  plan_monitor.PLAN_DEPTH PLAN_DEPTH,
  plan_monitor.PLAN_LINE_ID PLAN_LINE_ID,
  PLAN_OPERATION,
  COUNT(*) PARALLEL,
  MIN(FIRST_REFRESH_TIME) MIN_FIRST_REFRESH_TIME,/*5*/
  MAX(LAST_REFRESH_TIME) MAX_LAST_REFRESH_TIME,
  MIN(FIRST_CHANGE_TIME) MIN_FIRST_CHANGE_TIME,
  MAX(LAST_CHANGE_TIME) MAX_LAST_CHANGE_TIME,
  UNIX_TIMESTAMP(MIN(FIRST_REFRESH_TIME)) MIN_FIRST_REFRESH_TS,
  UNIX_TIMESTAMP(MAX(LAST_REFRESH_TIME)) MAX_LAST_REFRESH_TS, /*10*/
  UNIX_TIMESTAMP(MIN(FIRST_CHANGE_TIME)) MIN_FIRST_CHANGE_TS,
  UNIX_TIMESTAMP(MAX(LAST_CHANGE_TIME)) MAX_LAST_CHANGE_TS,
  AVG(TIMESTAMPDIFF(MICROSECOND, FIRST_REFRESH_TIME, LAST_REFRESH_TIME)) AVG_REFRESH_TIME,
  MAX(TIMESTAMPDIFF(MICROSECOND, FIRST_REFRESH_TIME, LAST_REFRESH_TIME)) MAX_REFRESH_TIME,
  MIN(TIMESTAMPDIFF(MICROSECOND, FIRST_REFRESH_TIME, LAST_REFRESH_TIME)) MIN_REFRESH_TIME, /*15 */
  AVG(TIMESTAMPDIFF(MICROSECOND, FIRST_CHANGE_TIME, LAST_CHANGE_TIME)) AVG_CHANGE_TIME,
  MAX(TIMESTAMPDIFF(MICROSECOND, FIRST_CHANGE_TIME, LAST_CHANGE_TIME)) MAX_CHANGE_TIME,
  MIN(TIMESTAMPDIFF(MICROSECOND, FIRST_CHANGE_TIME, LAST_CHANGE_TIME)) MIN_CHANGE_TIME,
  SUM(OUTPUT_ROWS) TOTAL_OUTPUT_ROWS,
  (MAX(TIMESTAMPDIFF(MICROSECOND, FIRST_CHANGE_TIME, LAST_CHANGE_TIME)) - MIN(TIMESTAMPDIFF(MICROSECOND, FIRST_CHANGE_TIME, LAST_CHANGE_TIME))) / MAX(TIMESTAMPDIFF(MICROSECOND, FIRST_CHANGE_TIME, LAST_CHANGE_TIME)+0.00000001) SKEWNESS,
  SUM(STARTS) TOTAL_RESCAN_TIMES,/* 20 */
  MAX(OTHERSTAT_1_ID) OTHERSTAT_1_ID,
  SUM(OTHERSTAT_1_VALUE) SUM_STAT_1,
  MAX(OTHERSTAT_1_VALUE) MAX_STAT_1,
  MIN(OTHERSTAT_1_VALUE) MIN_STAT_1,
  AVG(OTHERSTAT_1_VALUE) AVG_STAT_1, /* 25 */
  MAX(OTHERSTAT_2_ID) OTHERSTAT_2_ID,
  SUM(OTHERSTAT_2_VALUE) SUM_STAT_2,
  MAX(OTHERSTAT_2_VALUE) MAX_STAT_2,
  MIN(OTHERSTAT_2_VALUE) MIN_STAT_2,
  AVG(OTHERSTAT_2_VALUE) AVG_STAT_2, /* 30 */
  MAX(OTHERSTAT_3_ID) OTHERSTAT_3_ID,
  SUM(OTHERSTAT_3_VALUE) SUM_STAT_3,
  MAX(OTHERSTAT_3_VALUE) MAX_STAT_3,
  MIN(OTHERSTAT_3_VALUE) MIN_STAT_3,
  AVG(OTHERSTAT_3_VALUE) AVG_STAT_3, /* 35 */
  MAX(OTHERSTAT_4_ID) OTHERSTAT_4_ID,
  SUM(OTHERSTAT_4_VALUE) SUM_STAT_4,
  MAX(OTHERSTAT_4_VALUE) MAX_STAT_4,
  MIN(OTHERSTAT_4_VALUE) MIN_STAT_4,
  AVG(OTHERSTAT_4_VALUE) AVG_STAT_4, /* 40 */
  MAX(OTHERSTAT_5_ID) OTHERSTAT_5_ID,
  SUM(OTHERSTAT_5_VALUE) SUM_STAT_5,
  MAX(OTHERSTAT_5_VALUE) MAX_STAT_5,
  MIN(OTHERSTAT_5_VALUE) MIN_STAT_5,
  AVG(OTHERSTAT_5_VALUE) AVG_STAT_5, /* 45*/
  MAX(OTHERSTAT_6_ID) OTHERSTAT_6_ID,
  SUM(OTHERSTAT_6_VALUE) SUM_STAT_6,
  MAX(OTHERSTAT_6_VALUE) MAX_STAT_6,
  MIN(OTHERSTAT_6_VALUE) MIN_STAT_6,
  AVG(OTHERSTAT_6_VALUE) AVG_STAT_6 /* 50 */,
  TRUNCATE(AVG(DB_TIME)/1000000000.0/2.5, 4) MY_DB_TIME,
  TRUNCATE(AVG(DB_TIME-USER_IO_WAIT_TIME)/1000000000.0/2.5, 4) MY_CPU_TIME,
  TRUNCATE(AVG(USER_IO_WAIT_TIME)/1000000000.0/2.5, 4) MY_IO_TIME
from
(
  select * FROM oceanbase.gv$sql_plan_monitor
where
  trace_id = 'YB42AC1A3181-000620B996AF95EA-0-0'
) plan_monitor
LEFT JOIN
(
 SELECT ROWS, PLAN_LINE_ID FROM oceanbase.gv$ob_plan_cache_plan_explain WHERE plan_id = 30705956 AND tenant_id = 1002 and svr_ip = '172.26.49.129'  and svr_port = 2882
) plan_explain
ON
  plan_monitor.PLAN_LINE_ID = plan_explain.PLAN_LINE_ID
GROUP BY
  plan_monitor.PLAN_LINE_ID, plan_monitor.PLAN_OPERATION
ORDER BY
  plan_monitor.PLAN_LINE_ID ASC;

机器级
select
  PLAN_DEPTH,
  PLAN_LINE_ID,
  PLAN_OPERATION,
  COUNT(*) PARALLEL,
  MIN(FIRST_REFRESH_TIME) MIN_FIRST_REFRESH_TIME,
  MAX(LAST_REFRESH_TIME) MAX_LAST_REFRESH_TIME,
  MIN(FIRST_CHANGE_TIME) MIN_FIRST_CHANGE_TIME,
  MAX(LAST_CHANGE_TIME) MAX_LAST_CHANGE_TIME,
  UNIX_TIMESTAMP(MIN(FIRST_REFRESH_TIME)) MIN_FIRST_REFRESH_TS,
  UNIX_TIMESTAMP(MAX(LAST_REFRESH_TIME)) MAX_LAST_REFRESH_TS,
  UNIX_TIMESTAMP(MIN(FIRST_CHANGE_TIME)) MIN_FIRST_CHANGE_TS,
  UNIX_TIMESTAMP(MAX(LAST_CHANGE_TIME)) MAX_LAST_CHANGE_TS,
  AVG(TIMESTAMPDIFF(MICROSECOND, FIRST_REFRESH_TIME, LAST_REFRESH_TIME)) AVG_REFRESH_TIME,
  MAX(TIMESTAMPDIFF(MICROSECOND, FIRST_REFRESH_TIME, LAST_REFRESH_TIME)) MAX_REFRESH_TIME,
  MIN(TIMESTAMPDIFF(MICROSECOND, FIRST_REFRESH_TIME, LAST_REFRESH_TIME)) MIN_REFRESH_TIME,
  AVG(TIMESTAMPDIFF(MICROSECOND, FIRST_CHANGE_TIME, LAST_CHANGE_TIME)) AVG_CHANGE_TIME,
  MAX(TIMESTAMPDIFF(MICROSECOND, FIRST_CHANGE_TIME, LAST_CHANGE_TIME)) MAX_CHANGE_TIME,
  MIN(TIMESTAMPDIFF(MICROSECOND, FIRST_CHANGE_TIME, LAST_CHANGE_TIME)) MIN_CHANGE_TIME,
  SUM(OUTPUT_ROWS) TOTAL_OUTPUT_ROWS,
  (MAX(TIMESTAMPDIFF(MICROSECOND, FIRST_CHANGE_TIME, LAST_CHANGE_TIME)) - MIN(TIMESTAMPDIFF(MICROSECOND, FIRST_CHANGE_TIME, LAST_CHANGE_TIME))) / MAX(TIMESTAMPDIFF(MICROSECOND, FIRST_CHANGE_TIME, LAST_CHANGE_TIME)) SKEWNESS,
  SUM(STARTS) TOTAL_RESCAN_TIMES,
  SVR_IP,
  SVR_PORT,
  MAX(OTHERSTAT_1_VALUE) MAX_STAT_1,
  MIN(OTHERSTAT_1_VALUE) MIN_STAT_1,
  AVG(OTHERSTAT_1_VALUE) AVG_STAT_1,
  MAX(OTHERSTAT_2_VALUE) MAX_STAT_2,
  MIN(OTHERSTAT_2_VALUE) MIN_STAT_2,
  AVG(OTHERSTAT_2_VALUE) AVG_STAT_2,
  MAX(OTHERSTAT_3_VALUE) MAX_STAT_3,
  MIN(OTHERSTAT_3_VALUE) MIN_STAT_3,
  AVG(OTHERSTAT_3_VALUE) AVG_STAT_3,
  MAX(OTHERSTAT_4_VALUE) MAX_STAT_4,
  MIN(OTHERSTAT_4_VALUE) MIN_STAT_4,
  AVG(OTHERSTAT_4_VALUE) AVG_STAT_4,
  MAX(OTHERSTAT_5_VALUE) MAX_STAT_5,
  MIN(OTHERSTAT_5_VALUE) MIN_STAT_5,
  AVG(OTHERSTAT_5_VALUE) AVG_STAT_5,
  MAX(OTHERSTAT_6_VALUE) MAX_STAT_6,
  MIN(OTHERSTAT_6_VALUE) MIN_STAT_6,
  AVG(OTHERSTAT_6_VALUE) AVG_STAT_6,
  TRUNCATE(AVG(DB_TIME)/1000000000.0/2.5, 4) MY_DB_TIME,
  TRUNCATE(AVG(DB_TIME-USER_IO_WAIT_TIME)/1000000000.0/2.5, 4) MY_CPU_TIME,
  TRUNCATE(AVG(USER_IO_WAIT_TIME)/1000000000.0/2.5, 4) MY_IO_TIME
from
  oceanbase.gv$sql_plan_monitor
where
  trace_id = 'YB42AC1A3181-000620B996AF95EA-0-0'
GROUP BY
  PLAN_LINE_ID,PLAN_OPERATION,SVR_IP,SVR_PORT
ORDER BY
  PLAN_LINE_ID ASC, MAX_CHANGE_TIME ASC, SVR_IP, SVR_PORT;

线程级
select
  PLAN_DEPTH,/*0*/
  SVR_IP,
  SVR_PORT,
  PROCESS_NAME,
  PLAN_LINE_ID,
  PLAN_OPERATION, /*5*/
  OUTPUT_ROWS,
  STARTS RESCAN_TIMES,
  FIRST_REFRESH_TIME,
  LAST_REFRESH_TIME,
  FIRST_CHANGE_TIME,/*10*/
  LAST_CHANGE_TIME,
  UNIX_TIMESTAMP(FIRST_REFRESH_TIME) FIRST_REFRESH_TS,
  UNIX_TIMESTAMP(LAST_REFRESH_TIME) LAST_REFRESH_TS,
  UNIX_TIMESTAMP(LAST_REFRESH_TIME) - UNIX_TIMESTAMP(FIRST_REFRESH_TIME) REFRESH_TS,
  UNIX_TIMESTAMP(FIRST_CHANGE_TIME) FIRST_CHANGE_TS, /*15*/
  UNIX_TIMESTAMP(LAST_CHANGE_TIME) LAST_CHANGE_TS,
  UNIX_TIMESTAMP(LAST_CHANGE_TIME) - UNIX_TIMESTAMP(FIRST_CHANGE_TIME) CHANGE_TS,
  OTHERSTAT_1_ID,
  OTHERSTAT_1_VALUE,
  OTHERSTAT_2_ID, /*20*/
  OTHERSTAT_2_VALUE,
  OTHERSTAT_3_ID,
  OTHERSTAT_3_VALUE,
  OTHERSTAT_4_ID,
  OTHERSTAT_4_VALUE, /*25*/
  OTHERSTAT_5_ID,
  OTHERSTAT_5_VALUE,
  OTHERSTAT_6_ID,
  OTHERSTAT_6_VALUE,
  TRUNCATE((DB_TIME)/1000000000.0/2.5, 4) MY_DB_TIME,
  TRUNCATE((DB_TIME-USER_IO_WAIT_TIME)/1000000000.0/2.5, 4) MY_CPU_TIME,
  TRUNCATE((USER_IO_WAIT_TIME)/1000000000.0/2.5, 4) MY_IO_TIME
from
  oceanbase.gv$sql_plan_monitor
where
    trace_id = 'YB42AC1A3181-000620B996AF95EA-0-0'
ORDER BY
  PLAN_LINE_ID ASC, SVR_IP, SVR_PORT, CHANGE_TS, PROCESS_NAME ASC;

报告生成时间： 2024-12-04 16:40:59