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
YB42AC1EE0B2-0006229DB85D2EDA-0-0 SELECT
/*+monitor */
*
from prod_sync_s_lazada testlazada1000
where store_sub_sku in
(
'TKDS36S51-L/ELZG0','TKDS36S51-DL/RM7RD','TKDS36S51-H/9AS4T','TKDS36S51-P/AEXT6','TKDS36S51-R/75G4R','HADQ8K69-F-XL/BZZK2','HADQ8K69-B-3XL/ZLUWG','HADQ8K69-X-3XL/2BEYA','HADQ8K69-B-2XL/QF3EA','HADQ8K69-B-XL/4M8HN','HADQ8K69-X-2XL/1DA7C','HADQ8K69-F-M/J32S6','HADQ8K69-F-L/DYMWI','HADQ8K69-H-XL/GUX5Y','HADQ8K69-X-M/8CMZW','HADQ8K69-H-L/0C8FU','HADQ8K69-H-2XL/OO7E9','HADQ8K69-B-L/FBDUW','HADQ8K69-H-3XL/2ZGXI','HADQ8K69-F-2XL/BMSMV','HADQ8K69-X-XL/SUQFL','HADQ8K69-H-M/1G40G','HADQ8K69-X-L/XWNBD','HADQ8K69-B-M/DLCQM','HADQ8K69-F-3XL/2XYE0','XFZB1E06-W/EV26Z','XFZB1E06-R/D9BJG','XFZB1E06-O/ME73M','XFZB1E06-LV/18Y58','XFZB1E06-L/TJM0U','XFZB1E06-B/KL6J1','XFZB1E06-1/5K5ZN','HADT2B52-EU/VP1MW','HADT2B52-UK/ZXNIQ','HADT2B52-US/BAYOR','HADT2B52-AU/BMCWK','SHPC1C42-L/CPZS1','SHPC1C42-P/GECPP','SHPC1C42-B/LP8NG','SHPC1C42-Z/BSYQ7','SHPC1C42-W/GLDAG','SHPC1C42-Y/U5JXR','HADG14G52-6/N9V5J','HADG14G52-5/NG8MJ','HADG14G52-10/K7HYC','HADG14G52-4/2L87V','HADG14G52-2/BQM19','HADG14G52-3/78EOU','HADG14G52-1/B0YOJ','HADG14G52-7/9GM6D','HADG14G52-9/SK0PN','HADG14G52-8/TAN94','DZYB66V38/FTUP2','WJZH1V83-4/MT4SY','WJZH1V83-3/927YM','WJZH1V83-2/99QPZ','WJZH1V83-1/VH8AP','WJZF1R70-L/X0LMM','WJZF1R70-XB/D7J5S','WJZF1R70-S/4508E','WJZF1R70-W/U2BUV','WJZF1R70-R/Q7S5H','SHPC1C42-L/55CBZ','SHPC1C42-B/8B754','SHPC1C42-Y/0AQYY','SHPC1C42-W/23R85','SHPC1C42-Z/DZFL2','SHPC1C42-P/WKQCV','SHPC1C42-W/QJW76','SHPC1C42-P/NVL0Q','SHPC1C42-Z/N5BZ3','SHPC1C42-Y/8IJXI','SHPC1C42-B/7INUP','SHPC1C42-L/VK1Q8','MYZG1W18-C/8VJ6C','MYZG1W18-B/03HJA','MYZG1W18-W/TWS6K','MYZG1W18-K/OUNRD','MYZG1W18-H/ZOMQ5','AMKD50M67-B4243/QVU33','AMKD50M67-BR3839/T9HW2','AMKD50M67-BR4041/1USO2','AMKD50M67-BR3637/WJKGI','AMKD50M67-B3637/UELHK','AMKD50M67-B4445/GKTO6','AMKD50M67-C3637/FZU70','AMKD50M67-B4041/20KE1','AMKD50M67-C3839/MATBO','AMKD50M67-C4041/DF3HV','AMKD50M67-B3839/C083U','DZYB66V49-B/05P5L','DZYB66V49-W/CHU04','DZYB66V49-P/QCJKU','DZYB66V49-L/VIMOW','DZYB66V49-XB/RG513','DZYB66V49-BE/R38D7','HADG14G52-5/553MH','HADG14G52-4/4KB0W','HADG14G52-6/FVFJA','HADG14G52-10/0U83O','HADG14G52-3/0ORGH','HADG14G52-2/HHXS2','HADG14G52-7/PZ9Q2','HADG14G52-1/MWBXP','HADG14G52-8/WA5VJ','HADG14G52-9/U5LH2','DZYJ66Y90-M/FHMTU','DZYJ66Y90-C/X1MIP','DZYJ66Y90-H/S7B54','DZYJ66Y90-B/PFTIX','DZYJ66Y90-DH/JOI5J','HADK20D20-7/TU8EW','HADK20D20-1/OH2OK','HADK20D20-3/JF0RH','HADK20D20-5/23GTT','HADK20D20-4/WLR1G','HADK20D20-2/CYKGJ','HADK20D20-6/M8WOX','AMKD50M67-BR3637/K1TGE','AMKD50M67-C3637/1ZQ3P','AMKD50M67-C4041/E8G4D','AMKD50M67-B3637/TD68G','AMKD50M67-B3839/U4S7V','AMKD50M67-B4041/IHRZO','AMKD50M67-BR4041/1P2T4','AMKD50M67-B4243/VTBYB','AMKD50M67-B4445/FLEH2','AMKD50M67-C3839/8XVB9','AMKD50M67-BR3839/XDRM4','XFZD1L47-Y-36/W4PKL','XFZD1L47-B-39/YSGFR','XFZD1L47-B-37/5MGM4','XFZD1L47-B-38/2FRDI','XFZD1L47-Y-40/J8BVY','XFZD1L47-B-40/ZXUMF','XFZD1L47-B-36/JPZ3P','XFZD1L47-Y-38/Y35XX','XFZD1L47-Y-39/YKC3X','XFZD1L47-Y-37/6SC6J','DZYL20Y73-W/EFCDD','DZYL20Y73-B/9UO9O','AMKD50M82-B/6YGDT','AMKD50M82-A/EIJK3','XFZD1L48-K-36/ABCVL','XFZD1L48-K-38/DAP7Q','XFZD1L48-K-37/GVF87','XFZD1L48-DF-39/AIUN9','XFZD1L48-K-40/JYN8E','XFZD1L48-DF-36/Q1FOT','XFZD1L48-DF-40/LPGWN','XFZD1L48-DF-38/7QBNS','XFZD1L48-DF-37/XKG61','XFZD1L48-K-39/U7A6Q','MYZG1W14-B/492D9','MYZG1W14-K/W5ZK6','MYZG1W14-C/IVVTU','MYZG1W14-E/3Q0ZA','MYZG1W14-H/14MFI','DZYB66V41-B/L3RZ8','DZYB66V41-W/CYA0O','MYZS2B45-8/3KAML','MYZS2B45-6/J8U95','MYZS2B45-7/I8SJF','MYZS2B45-10/5QYB5','MYZS2B45-9/YQKW5','MYZS2B45-5/NQKZI','MYZS2B45-11/YDVBF','MYZS2B45-3/5RFUS','MYZS2B45-2/X08BT','MYZS2B45-4/2GWLU','MYZS2B45-1/9B2LK','SHPC1C42-Y/JKTKC','SHPC1C42-B/VZU17','SHPC1C42-P/D7LKA','SHPC1C42-L/M3TJB','SHPC1C42-W/JRSSG','SHPC1C42-Z/YLGL5','TKDO42O57-Y-1/8K93N','TKDO42O57-S-2/5Y6XM','TKDO42O57-S-1/OTGEE','TKDO42O57-Y-2/SJQZK','DZYB66V39-W/BH2XF','DZYB66V39-B1/BB9K7','DZYB66V39-C/8HTQC','DZYB66V39-B2/M23WH','DZYB66V39-B3/BHQOC','WJZY1E27-LV2/399ZB','WJZY1E27-H1/OHX3Q','WJZY1E27-W3/J49TN','WJZY1E27-H3/JMESN','WJZY1E27-W1/MVJ9Q','WJZY1E27-C2/0PATL','WJZY1E27-W2/08B5M','WJZY1E27-P1/J5RTC','WJZY1E27-H2/3D1GI','WJZY1E27-Z3/BNXME','WJZY1E27-P2/YOTNK','WJZY1E27-P3/9Z5Q3','WJZY1E27-C1/W07ZL','WJZY1E27-LV3/FQR1D','WJZY1E27-LV1/EQ7P2','WJZY1E27-Z2/37CJG','WJZY1E27-Z1/2TY3B','WJZY1E27-C3/KMVSZ','WJZJ1S66-R/2A2DN','WJZJ1S66-LV/JDTIU','DZYG66T69-H/06MB2','DZYG66T69-B/EFOK0','DZYG66T69-DL/OJES4','SHPC1C42-Y/6CPHG','SHPC1C42-Z/ZHSO0','SHPC1C42-W/JS2MQ','SHPC1C42-P/6UHJ4','SHPC1C42-L/SAYYX','SHPC1C42-B/BIL38','HADG21G05-P/JE548','HADG21G05-J/YW4Q4','HADG21G05-L/DBKFI','HADG21G05-Y/D1R4R','HADG21G05-LV/A8GDA','HADG21G05-Z/8WZLP','HADG21G05-R/6DG7N','MYZB1J44-1/XBSSM','MYZB1J44-7/X0FOH','MYZB1J44-4/2WK01','MYZB1J44-3/Q4TUT','MYZB1J44-6/EKSZ8','MYZB1J44-2/78CAX','MYZB1J44-5/PGJRA','MYZB1J44-9/QJIBO','MYZB1J44-8/KEQJB','HADG23G79-P/2XNHN','HADG23G79-W/S90EN','HADH1C55-T/DYV9L','HADH1C55-FU/96MYX','HADH1C55-P/1X697','HADG23G7-LV/X5LTQ','HADG23G7-Z/6PHS0','HADG23G79-FU/CCFLW','HADG23G7-L/LBNOI','SHPC1C42-Y/0V4OP','SHPC1C42-L/Z2YL4','SHPC1C42-B/AVPNC','SHPC1C42-P/HBUVA','SHPC1C42-W/1OCCA','SHPC1C42-Z/PT9FJ','SHPC1C42-Z/FX8RZ','SHPC1C42-B/U1RIK','SHPC1C42-L/SUILM','SHPC1C42-P/6U4LU','SHPC1C42-Y/XDEVY','SHPC1C42-W/E0PA2','WJZD1A02-2/6ENXH','WJZD1A02-1/ZNHOI','WJZD1A02-3/NKH5Z','WJZD1A02-5/X41RW','WJZD1A02-6/I6VEB','WJZD1A02-7/CEHTI','WJZD1A02-4/EVW9M','MYZK2J19-W/2P9J1','MYZK2J19-B/2GXPF','MYZK2J19-C/QCE93','MYZK2J19-H/ZAB3R','MYZK2J19-K/Y0WXG','MYZK2J19-DH/C6M0D','MYZK2J19-WR/EVS6P','MYZE2C31/LRJW2','TKDU3U33-B/HDY4K','TKDU3U33-LH/1FLM2','TKDU3U33-K/KRDYI','TKDU3U33-DH/IGRJE','MYZF1L58-1-S/90RLL','MYZF1L58-2-S/APSLT','MYZF1L58-4-S/L5L55','MYZF1L58-3-S/EV60P','MYZF1L58-4-L/3JMZL','MYZF1L58-1-L/I9SPC','MYZF1L58-2-L/JA6Z0','MYZF1L58-3-L/C1LS4','DZYW30B12-K/WFSFK','DZYW30B12-C/7UJ5C','DZYW30B12-W/DOTGL','DZYW30B12-B/J642R','DZYW30B12-H/22CXK','SHPC1C42-W/RUGSE','SHPC1C42-P/ZR8P7','SHPC1C42-Z/ASVAA','SHPC1C42-Y/ES5UP','SHPC1C42-L/QH08L','SHPC1C42-B/8RVE9','WJZF1R73-4/AKNIJ','WJZF1R73-3/OGSW0','WJZF1R73-1/BGR2I','WJZF1R73-2/9FCN8','KFBB10H77/F1DN6','DZYD66V26-B/JXHMA','DZYD66V26-P/SZHLR','DZYD66V26-H/CY6LS','SHPD2U19-2/3Z4AS','SHPD2U19-1/Y6SAI','SHPD2U19-3/RFJQ2','SHPD2U19-5/WVZI2','MYZE1W33-2/QCAXR','MYZE1W33-1/1HB5R','DZYL30A01-B/EEE0Y','DZYL30A01-L/Q7I9Z','DZYL30A01-E/FILD0','SHPC1C42-Z/8DQDH','SHPC1C42-P/683VF','SHPC1C42-Y/G8GYC','SHPC1C42-W/8OONP','SHPC1C42-L/FAMLT','SHPC1C42-B/Q5ZSG','WJZF1R72-R/959DQ','WJZF1R72-W/8BD93','WJZF1R72-G/VOQBA','WJZF1R72-P/8ZPNF','WJZF1R72-S/0VMEV','WJZF1R72-C/N92OY','AMKD50M73-DH/O7WMI','AMKD50M73-N/7HGDS','AMKD50M73-B/B1FAD','WJZF1R71-XB/UCS6B','WJZF1R71-P/PN9WT','WJZF1R71-W/YNM4H','WJZF1R71-G/393F6','WJZF1R71-R/36WA1','WJZF1R71-LV/CNYOI','DZYD66V18-K/SJ5IN','DZYD66V18-W/7E7RZ','DZYD66V18-P/LSN87','DZYD66V18-E/X9W6H','MYZL1W78-4/61H52','MYZL1W78-1/Q8TNA','MYZL1W78-3/4KXUN','MYZL1W78-2/8U5ZJ','MRZE32L55-2/F9YVU','MRZE32L55-4/1F7HS','MRZE32L55-5/ME0YX','MRZE32L55-1/0M6VD','MRZE32L55-3/NKVWC','WJZD1R38-1/SA7D4','WJZD1R38-5/6XKP3','WJZD1R38-4/LK92M','WJZD1R38-3/HJ86B','WJZD1R38-2/J5ZH1','WJZF1Q66-R/R76OX','WJZF1Q66-S/JIO2M','WJZF1Q66-XB/37SLA','WJZF1Q66-G/A1GWE','MYZC1Q53/OU5QM','WJZD1B35-6/5QV1U','WJZD1P97-1/ZLMZ4','WJZD1P97-4/O6FCE','WJZD1P97-6/BAAVD','WJZD1B35-4/V8PFL','WJZD1B35-3/7TAXZ','WJZD1P97-2/YEUK6','WJZD1B35-5/ZMXNV','WJZD1P97-5/615WM','WJZD1P97-3/8LMTG','WJZD1B35-2/PP8MY','WJZD1B35-8/AKQ37','WJZD1B35-1/JS6IZ','WJZD1B35-7/MUHR6','WJZH1V84-3/53M25','WJZH1V84-4/DF4GY','WJZH1V84-1/BHPWR','WJZH1V84-2/9HE20','WJZH1V84-5/UFVOW','WJZF1R32-G/CM1PO','WJZF1R32-LV/IHZZQ','MYZJ1K13-4/I9UVJ','MYZJ1K13-7/FOUHT','MYZJ1K13-1/57SDX','MYZJ1K13-6/Y0ZW4','MYZJ1K13-10/A6H8F','MYZJ1K13-8/EJPRY','MYZJ1K13-9/5MIHY','MYZJ1K13-3/P9BNB','MYZJ1K13-2/2BGHC','MYZJ1K13-5/UAKOU','WJZH1T33-5/05F4D','WJZH1T33-4/H39SL','WJZH1T33-1/OBW24','WJZH1T33-2/4OHPB','WJZH1T33-3/09G3Q','WJZL1T09-4/YM0DE','WJZL1T09-3/MYBQ4','WJZL1T09-8/GWA3G','WJZL1T09-7/JUKJJ','WJZL1T09-2/4Q4OV','WJZL1T09-1/KX5OZ','WJZL1T09-6/HYOKZ','WJZL1T09-5/SE8V5','DZYB66R69-C/6I28D','DZYB66R69-G/13XBW','DZYB66R69-F/OG5AG','DZYB66R69-E/IMWS4','DZYB66R69-B/K0VMM','DZYB66R69-A/G5XD3','DZYB66R69-D/WGJAA','DZYB66R69-J/CZ7MP','DZYB66R69-H/LDNO2','WJZF1T25/6JFJF','WJZH1S01-1/NOK0I','WJZH1S01-3/UPVQ1','WJZH1S01-4/IIOW6','WJZH1S01-6/4H8HK','WJZH1S01-2/BMLAE','WJZH1S01-5/YA5Z6','MYZE1W94-7/K0278','MYZE1W94-4/GSL51','MYZE1W94-3/RE0M4','MYZE1W94-10/LJ58S','MYZE1W94-1/2WZDJ','MYZE1W94-8/N8PLF','MYZE1W94-6/92ZJU','MYZE1W94-5/KMEUQ','MYZE1W94-9/VSMJL','MYZE1W94-2/5GTAG','WJZL1Q97-2/M4VHV','WJZL1Q97-1/UTZB3','AMKD50M78-WR/E409Q','AMKD50M78-L/NWP5I','AMKD50M78-M/VDGEN','AMKD50M78-PUP/U9FXY','AMKD50M78-LH/3ZFQI','AMKD50M78-B/7Y69J','AMKD50M78-C/LBXFO','AMKD50M78-DH/XOQOS','AMKD50M78-BH/L2C5P','WJZF1Q14-7/C46WM','WJZF1Q14-4/EGP8Z','WJZF1Q14-1/Z8W4V','WJZF1Q14-6/VBNIK','WJZF1Q14-2/K7RMD','WJZF1Q14-3/5YZPB','WJZF1Q14-5/IABTZ','WJZF1Q14-8/TX80L','MYZK2J21-P/ASJE6','MYZK2J21-WW/12I77','MYZK2J21-BW/06HSH','MYZK2J21-LV/A8JGH','MYZK2J21-Z/CPHNZ','MYZK2J21-WB/4EIGV','DZYD66V06-E/JVAVL','DZYD66V06-P/GGORE','DZYD66V06-B/YE1CH','DZYD66V06-H/Z72B6','DZYD66V06-W/AVCX9','MYZE1X98-5/FOEQM','MYZE1X98-6/CRL88','MYZE1X98-3/L85NM','MYZE1X98-4/1NO96','MYZE1X98-1/QW8JY','MYZE1X98-2/USR8J','XFZH1B22-H/9TU6E','XFZH1B22-B/4XZ4S','XFZH1B22-R/YMBGE','XFZH1B22-L/ZZ6GB','XFZH1B22-E/TX7WT','WJZM2T14-3/ZUMPK','WJZM2T14-2/2EHBW','WJZM2T14-5/G074H','WJZM2T14-4/QVO7S','WJZH1T24-2/KJ8HD','WJZH1T24-9/3P6XS','WJZH1T24-4/G8BSB','WJZH1T24-1/VNPWA','WJZH1T24-7/EUHAP','WJZH1T24-6/NLG7Y','WJZH1T24-8/LRO75','WJZH1T24-10/5TCE2','WJZH1T24-5/M40IT','WJZH1T24-3/LXMN8','MYZE1V96-1/J9WZ5','MYZE1V96-6/U867Y','MYZE1V96-2/3KNXL','MYZE1V96-5/58VU8','MYZE1V96-3/EUAEL','MYZE1V96-4/0ZIBT','MYZS2A27-6/KPRZE','MYZS2A27-5/5ZZJ7','MYZS2A27-4/OYQYJ','MYZS2A27-3/M7Q20','MYZS2A27-1/UFPCQ','MYZS2A27-2/BYC7X','MYZR1C74-1/8RN82','MYZR1C74-2/C5WVO','MYZD1R61-4/ARMMA','MYZD1R61-1/UCVRD','MYZD1R61-2/EI7RY','MYZD1R61-5/WL53N','MYZD1R61-9/2AVG9','MYZD1R61-10/52Z7A','MYZD1R61-7/DH1OO','MYZD1R61-6/8DVL4','MYZD1R61-8/CDO3J','MYZD1R61-3/WSUZ2','WJZD1Q82/R5554','MYZD1Q97-6/YX7GD','MYZD1Q97-5/PPF6H','MYZD1Q97-7/U8LKS','MYZD1Q97-4/0GPLF','MYZD1Q97-3/WNMIA','MYZD1Q97-2/XFAWL','MYZD1Q97-1/TRU50','HADK20C53-3/XX920','HADK20C53-6/9Z1JC','HADK20C53-5/EZZ3D','HADK20C53-1/3KMVK','HADK20C53-2/R7LSP','HADK20C53-4/MV51X','WJZM2T13-W15/4QK99','WJZM2T13-LV15/WEEES','WJZM2T13-LV25/7IXPP','WJZM2T13-W25/L5ZTM','WJZM2T13-LV35/WXUA4','WJZM2T13-W35/FAMYN','XFZH1B13-2/2WK9T','XFZH1B13-5/57DKR','XFZH1B13-4/W66NN','XFZH1B13-1/QPD6G','XFZH1B13-3/1Q1LW','XFZH1B13-6/UY5Z0','MYZJ1K21-3/MNOMW','MYZJ1K21-1/9HWEA','MYZJ1K21-6/FRUTK','MYZJ1K21-4/3NWYU','MYZJ1K21-2/S658I','MYZJ1K21-5/XPB0O','DZYD66V05-L/KEQHJ','DZYD66V05-Y/IAS8Q','DZYD66V05-E/I41GQ','DZYD66V05-B/UGRN6','DZYD66V05-C/HV9ED','MYZM1T40-4/LA96H','MYZM1T40-3/GMRTK','MYZM1T40-9/1FJJ6','MYZM1T40-1/S6AHS','MYZM1T40-8/9FQK8','MYZM1T40-10/9OR8D','MYZM1T40-5/GLS7X','MYZM1T40-2/BYMOU','MYZM1T40-7/0G4BJ','MYZM1T40-6/O2CLW','WJZG1A13-5/MH2F9','WJZG1A13-6/XSNKC','WJZG1A13-4/QMWLO','WJZG1A13-8/FGJEE','WJZG1A13-1/T6P2N','WJZG1A13-7/BGY80','WJZG1A13-2/P9B84','WJZG1A13-3/QYSOU','XFZD1K71-3/BSRQZ','XFZD1K71-1/4GA8Y','XFZD1K71-5/ZPQ4W','XFZD1K71-2/RUNBA','XFZD1K71-4/Q1DMM','WJZD1S16-8/6I4S9','WJZD1S16-9/0WZP3','WJZD1S16-7/XZE3K','WJZD1S16-3/AYD0K','WJZD1S16-6/WTY5F','WJZD1S16-5/HNZSV','WJZD1S16-1/RCYSH','WJZD1S16-2/DPJQ1','WJZD1S16-10/GFGFZ','WJZD1S16-4/0HBQL','TKDA65A65-G/V68UM','MYZL1Y10-2/YPN2O','MYZL1Y10-5/NQT5H','MYZL1Y10-3/L1U6E','MYZL1Y10-4/8JF51','MYZL1Y10-1/T5SGZ','MYZD1R66-4/2JI3V','MYZD1R66-3/KJHBC','MYZD1R66-5/3TLQS','MYZD1R66-7/W3I75','MYZD1R66-6/GUTPY','MYZD1R66-1/C62NI','MYZD1R66-2/M4MGM','MYZD1R66-8/SFME2','WJZM2R38-G/ZQ1E5','WJZM2R38-D/IQ5LZ','WJZM2R38-B/R4YMH','WJZM2R38-E/RR8JP','WJZM2R38-C/3ORTH','WJZM2R38-H/GA3VW','WJZM2R38-K/F1OS1','WJZM2R38-A/J34LF','WJZM2R38-J/DR1QP','WJZM2R38-F/F9L7M','WJZD1S26-7/P2NYP','WJZD1S26-2/OMRKL','WJZD1S26-8/61K22','WJZD1S26-4/VEKIB','WJZD1S26-6/4U4UE','WJZD1S26-5/AIC32','WJZD1S26-1/OXDEH','WJZD1S26-3/J7M0Z','DZYW30B09-H/1YAAK','DZYW30B09-B/QOZE9','DZYW30B09-C/EBIFX','DZYW30B09-W/NYRDN','MYZE1Y61-2/N46OZ','MYZE1Y61-1/EEIUG','DZYG66P48-LV/GGQMH','DZYG66P48-R/LAN8Q','FASK1Q77-B/MV9C0','FASK1Q77-E/G04O6','FASK1Q77-A/FU0PG','FASK1Q77-D/7Z06C','FASK1Q77-C/I0LK9','WJZJ1U36-B2/378LO','WJZJ1U36-A1/XD0HK','WJZJ1U36-B1/6M1AW','WJZJ1U36-B5/NDH7C','WJZJ1U36-A5/TYLNU','WJZJ1U36-A4/XEVF0','WJZJ1U36-B4/TLQ7J','WJZJ1U36-A3/C60AS','WJZJ1U36-B3/4AX6P','WJZJ1U36-A2/SUFUF','MRZE32H13/EUNXS','MYZD1R60-7/LUUQU','MYZD1R60-6/8851Y','MYZD1R60-4/6E9O6','MYZD1R60-10/QLTX1','MYZD1R60-5/9T9FI','MYZD1R60-9/Y0H9M','MYZD1R60-1/1ME55','MYZD1R60-3/KCEW0','MYZD1R60-8/8W6I1','MYZD1R60-2/HK5OZ','MYZE1V97-3/HXWPU','MYZE1V97-1/I3I78','MYZE1V97-2/2OK6T','DZYG66T68-W/3R4IM','DZYG66T68-B/5OUZQ','WJZF1S08-R/92W76','WJZF1S08-P/ZYXGT','WJZF1S08-J/VB3GB','WJZF1S08-S/H51A5','WJZF1S08-L/SIECK','WJZF1S08-LV/ON4EB','DZYD66V23-Z-1/2IX2N','DZYD66V23-Z-2/ERS4L','DZYD66V23-H-1/N1DZN','DZYD66V23-H-2/A99W9','DZYD66V23-Z-3/0KPS7','DZYD66V23-H-3/TX1QV','DZYD66V23-H-4/N4CH7','MYZE1Y59-2/71M6W','MYZE1Y59-1/0EY84','MYZL1W79-4/P9YAR','MYZL1W79-5/9PG1E','MYZL1W79-6/HJ9S9','MYZL1W79-1/Z84IY','MYZL1W79-7/VNQG2','MYZL1W79-3/B8DJ3','MYZL1W79-2/7S1JT','CARF2H64-1/GW2V5','CARF2H64-2/SURJD','WJZD1R06/UKK89','MYZF1Q97/23ZL0','WJZF1R88-9/G9ZV8','WJZF1R88-4/5KBPV','WJZF1R88-5/I8LG1','WJZF1R88-10/DDH9M','WJZF1R88-7/8R9IS','WJZF1R88-1/IP9Y6','WJZF1R88-3/YJ9SJ','WJZF1R88-8/8BXJ4','WJZF1R88-6/V84JW','WJZF1R88-2/7A88P','HADY1C08-1/MFJK4','HADY1C08-3/XX9DC','HADY1C08-4/1LRRO','HADY1C08-5/SHHZN','HADY1C08-2/AHH2J','HADY1C08-6/5W36C','AMKD50M77-P-24/FJHR9','AMKD50M77-P-12/8T4ML','AMKD50M77-H-18/PCQ1Y','AMKD50M77-H-12/QTHXN','AMKD50M77-P-6/GWO26','AMKD50M77-H-6/1SPPW','AMKD50M77-P-18/4L37R','AMKD50M77-H-24/UR9KP','MYZC1R58/3G32Q','MYZL1X49-2-S/FHG3K','MYZL1X49-3-S/BGCQQ','MYZL1X49-3-G/7A5UL','MYZL1X49-2-CP/2QNQS','MYZL1X49-1-CP/NXNK0','MYZL1X49-1-S/SYZOX','WJZC1H27-D/D0ZBN','WJZC1H27-A/87XUT','WJZC1H27-C/FDF39','WJZC1H27-B/37GDA','WJZD1S27-E/8D3IQ','WJZD1S27-A/PMF03','WJZD1S27-B/8R10B','WJZD1S27-F/2XYLR','WJZD1S27-D/8F59G','WJZD1S27-C/OSEE1','MYZD1R61-8/ST0B7','MYZD1R61-4/1F5E8','MYZD1R61-1/96F79','MYZD1R61-2/RNDJM','MYZD1R61-7/JHGAV','MYZD1R61-6/ZHGI0','MYZD1R61-5/37938','MYZD1R61-3/Z3KGB','MYZD1R61-10/KW67M','MYZD1R61-9/PYJ49','MYZE1W30-5/DHFIZ','MYZE1W30-2/LH3KP','MYZE1W30-3/B716J','MYZE1W30-4/5GGNL','MYZE1W30-1/VINFC','DZYR20A01-SDM/QAGU2','DZYR20A01-SDS/8MYGR','MYZS1W20-1/4RJ5U','MYZS1X31-2/J8WRY','MYZS1X31-7/L4HY5','MYZS1X31-1/BDFQD','MYZS1X31-10/TDUIH','MYZS1X31-9/CVWS7','MYZS1W20-3/MDRIR','MYZS1X31-6/LOQWH','MYZS1W20-2/JFVUZ','MYZS1X31-5/SWR0Q','MYZS1X31-3/J6SZZ','MYZS1X31-8/U31ZB','MYZS1X31-4/BXLK8','MRZE32H44-3/UREMB','MRZE32H44-1/SE7WS','MRZE32H44-2/TEI4O','WJZD1S99-A/FQ640','WJZD1S99-C/W3AAF','WJZD1S99-B/DFOO5','MYZM1T56-5/JYLY8','MYZM1T56-3/YQWHX','MYZM1T56-2/F4IAW','MYZM1T56-1/RPAN5','MYZM1T56-4/NE68A','HADS2A52-4/V5AHW','HADS2A52-3/S9UVX','HADS2A52-1/SNTX0','HADS2A52-2/BE8EF','DZYB66V48/ERB82','WJZB1P96-4/1UHEB','WJZB1P96-2/86YY1','WJZB1P96-3/H5PPA','WJZB1P96-6/GNLGD','WJZB1P96-1/N9KU6','WJZB1P96-5/I5GLV','WJZB1P96-7/0MUXE','WJZD1B87-9/PTLQL','WJZD1B87-8/PQMS8','WJZD1B87-7/X3Z5Y','WJZD1B87-6/HZOKS','WJZD1B87-5/UIGKK','WJZD1B87-4/W8OAW','WJZD1B87-1/VDLGN','WJZD1B87-3/GYX0O','WJZD1B87-2/9T7JR','WJZD1B87-10/F0AJG','DZYW20Y40-LV/EW7ZK','DZYW20Y40-B/IBVHT','DZYW20Y40-R/NIYKJ','DZYW20Y40-L/E71XG','DZYW20Y40-P/YUFRZ','DZYW20Y40-Y/ZA89S','MRZE32L68/B3IC5','MYZE1W43-2/FZWSX','MYZE1W43-4/JSGXX','MYZE1W43-1/SNX98','MYZE1W43-3/CHNG9','MYZE1W43-5/EFLV7','HADS2B75-LV/JLMB0','HADS2B75-R/MRV3E','WJZD1S22-4/HC2TS','WJZD1S22-5/IZYBQ','WJZD1S22-3/FGK85','WJZD1S22-1/RBWEB','WJZD1S22-6/BOR7P','WJZD1S22-7/OBG7R','WJZD1S22-2/MCDRR','DZYJ88A01-2/HVNVX','DZYJ88A01-4/EUL5D','DZYJ88A01-3/OMPJ7','DZYJ88A01-1/DYJYZ','WJZL1B85-C/RGP6F','WJZL1B85-E/JEZOP','WJZL1B85-D/6BYXH','WJZL1B85-A/7T5KL','WJZL1B85-B/H0TUR','WJZJ1T24-B/4YHJR','WJZJ1T24-Y/DB1FH','WJZJ1T24-LL/R1HR1','WJZJ1T24-C/HNHHE','WJZJ1T24-R/CMS08','WJZJ1T24-F/MI1P5','WJZJ1T24-WR/413XY','WJZJ1T24-P/UN608','WJZJ1T24-W/2F492','WJZJ1T24-MLV/R5TF3','MYZE1Y60/O5ADU','MYZJ1K77-4/AJSNK','MYZJ1K77-1/J12DF','MYZJ1K77-3/3VCGE','MYZJ1K77-2/1KY70','MYZJ1K77-7/3GJ0U','MYZJ1K77-6/K3YIA','MYZJ1K77-5/HJL6V','MYZK2G51-J/Y24OM','MYZK2G51-DLV/6D4RI','MYZK2G51-S/7FF0D','MYZK2G51-LV/AUHK7','MYZK2G51-G/3VDE8','MYZK2G51-X/8J41P','MYZK2G51-P/NJTHG','MYZK2G51-R/L3WYS','MYZK2G51-WR/2RQHX','WJZF1R45-LV1/6H0AL','WJZF1R45-R1/5GZ3X','WJZF1R45-H1/YR4ZJ','WJZF1R45-H2/O5Y77','WJZF1R45-R2/LL3CK','WJZF1R45-LV2/D9PF2','HADT2A24-E/033VU','HADT2A24-D/R5L8O','HADT2A24-B/MJ1CC','HADT2A24-F/SDIXY','HADT2A24-A/TXQY8','HADT2A24-C/T6NYV','HADT2A24-G/CGWO4','MYZL1X57-RG/G7V8I','MYZL1X57-R/RDN0M','MYZL1X57-LV/S5EHC','MYZL1X57-CP/BV5KR','MYZL1X57-W/C6FPE','MYZL1X57-DL/ASM1M','MYZM1T72-2/1MDP5','MYZM1T72-3/5J1AN','MYZM1T72-1/TAJ3G','WJZJ1U49-1/F2QIX','WJZJ1U49-4/35OZQ','WJZJ1U49-2/5GO6K','WJZJ1U49-5/ITXSH','WJZJ1U49-3/5M5IW','DZYA66R65-B/E3443','DZYA66R65-C/74PAY','DZYA66R65-X/R7AP6','DZYA66R65-W/5FA79','MYZE1W94-6/5PA6P','MYZE1W94-5/XOZIK','MYZE1W94-1/SA7IK','MYZE1W94-2/CUS2B','MYZE1W94-7/E70CI','MYZE1W94-3/QJRTX','MYZE1W94-10/KUUWB','MYZE1W94-4/QRMW8','MYZE1W94-9/TSMW8','MYZE1W94-8/8CWVM','WJZD1S13-5/Q1T7M','WJZD1S13-4/DRQN3','WJZD1S13-6/XSEJW','WJZD1S13-3/4L5BP','WJZD1S13-2/46E7T','WJZD1S13-10/NJYFI','WJZD1S13-8/HA7ES','WJZD1S13-1/GXIRV','WJZD1S13-9/71BTH','WJZD1S13-7/DI6AR','MYZE1W36-6/RLATW','MYZE1W36-10/99FSK','MYZE1W36-9/2VR90','MYZE1W36-13/PV4BO','MYZE1W36-5/4Y1M6','MYZE1W36-4/5LZ6O','MYZE1W36-12/K0Y74','MYZE1W36-7/RNI1X','MYZE1W36-2/P8BNF','MYZE1W36-1/4ZQTH','MYZE1W36-8/C4R47','MYZE1W36-11/M4QQZ','MYZE1W36-14/BFN93','MYZE1W36-15/AMBZH','MYZE1W36-3/Q3GAE','DZYW20X25-LV/HZFGI','DZYW20X25-RLV/Q2TKX','DZYW20X25-R/DUC7I','DZYW20X25-W/PECG2','MYZM1T40-1/86L3P','MYZM1T40-6/109F7','MYZM1T40-3/RTCG0','MYZM1T40-4/FU9CZ','MYZM1T40-5/ADUW9','MYZM1T40-2/3RKA1','MYZM1T40-8/3JWZC','MYZM1T40-10/GFXVG','MYZM1T40-9/Y9N7F','MYZM1T40-7/0RXT1','MYZD1R61-4/J4EXN','MYZD1R61-2/J9Y8F','MYZD1R61-1/P6QAU','MYZD1R61-8/O10IF','MYZD1R61-10/VV8SL','MYZD1R61-3/D9GF1','MYZD1R61-6/WYDBS','MYZD1R61-5/XSD14','MYZD1R61-7/NBG5I','MYZD1R61-9/S6BNO','MYZE1Y30-5/N5U2M','MYZE1Y30-2/GH368','MYZE1Y30-3/P76MO','MYZE1Y30-1/P1DRE','MYZE1Y30-4/SBYY8','WJZR2F05-F-M/DJF51','WJZR2F05-F-L/DKFID','WJZR2F05-F-S/3AX5J','WJZR2F05-E-M/MKEL4','WJZR2F05-A-M/9HNUP','WJZR2F05-E-L/6O793','WJZR2F05-A-L/WGSEL','WJZR2F05-E-S/RHVBN','WJZR2F05-A-S/G7JVY','DZYL20W59-R/RS5N7','DZYL20W59-W/E2BS6','MYZB1H54-1/8LK31','MYZB1H54-2/MCGG6','MYZB1H54-3/Y3KTL','WJZC1H30-P/JPWHB','WJZC1H30-1-LV/DOJ6A','WJZC1H30-W/L61ZW','WJZC1H30-MS/N7F81','WJZC1H30-1-W/HV1ZY','WJZC1H30-1-P/9USKA','WJZC1H30-LV/VKDF0','WJZC1H30-1-MS/2HBNT','DZYW20Y21-W/8Y0BB','DZYW20Y21-P/7KFQJ','DZYW20Y21-Y/1IR7Y','DZYW20Y21-L/NTJ9F','WJZF1Q14-7/6O7QE','WJZF1Q14-6/DFL9R','WJZF1Q14-2/IC7OV','WJZF1Q14-5/EUSHI','WJZF1Q14-4/ZHJIA','WJZF1Q14-8/GXWHX','WJZF1Q14-3/H56FG','WJZF1Q14-1/3QSX1','MYZE1W51-2/Z3V0L','MYZE1W51-3/HSUY6','MYZE1W51-1/AIIE4','MYZE1X42-8/HNYY6','MYZE1X42-5/PFPW6','MYZE1X42-7/VIS0I','MYZE1X42-4/X159E','MYZE1X42-3/C5C0D','MYZE1X42-2/31VS1','MYZE1X42-6/H9XEO','MYZE1X42-1/RP389','DZYM10Q78-L/ZEFAS','DZYM10Q78-F/92CRC','DZYM10Q78-P/CQSDW','WJZM2Q84-6/UQ48L','WJZM2Q84-1/6CZJ8','WJZM2Q84-3/NYFOS','WJZM2Q84-5/LPBSV','WJZM2Q84-2/PJOB2','WJZM2Q84-4/A0FTD','MYZC1R38/6TTVQ','WJZL1S76-R2/N2GE9','WJZL1S76-W1/RTXXQ','WJZL1S76-C1/VAHOL','WJZL1S76-W2/AB81Z','WJZL1S76-B2/DBZSB','WJZL1S76-B1/N01EN','WJZL1S76-R1/WO7Z3','WJZL1S76-C2/AL44J','WJZL1S76-K1/7ST87','WJZL1S76-K2/2II0R','MYZS2B28-4/9JUT1','MYZS2B28-1/E3INW','MYZS2B28-6/QDKMN','MYZS2B28-2/IYNJM','MYZS2B28-5/5ZA8L','MYZS2B28-3/1FWMH','MYZS2B28-8/J81IV','MYZS2B28-7/OURER','EBAC3G87-F/9SZ46','EBAC3G87-H/SC2FR','SHPD2U08-3/IZYPQ','SHPD2U08-4/LA9D4'

)		 1000 2024-12-05 09:35:20.813200 2024-12-05 09:36:41.311200 80498015 epean epean_admin trade_online 43358462 1004 5.7.25-OceanBase_CE-v4.2.1.8 172.30.224.178 2882 
select * from oceanbase.gv$ob_plan_cache_plan_explain where tenant_id = 1004 and plan_id = 43358462  and svr_ip = '172.30.224.178' and svr_port = 2882
+-----------+----------------+----------+----------+------------+--------------+----------------+----------------+----------+----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| TENANT_ID | SVR_IP         | SVR_PORT | PLAN_ID  | PLAN_DEPTH | PLAN_LINE_ID | OPERATOR       | NAME           | ROWS     | COST     | PROPERTY                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |
+-----------+----------------+----------+----------+------------+--------------+----------------+----------------+----------+----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 1004      | 172.30.224.178 | 2882     | 43358462 | 0          | 0            | PHY_TABLE_SCAN | testlazada1000 | 52222770 | 43194533 | table_rows:49326280, physical_range_rows:60520812, logical_range_rows:52222770, index_back_rows:0, output_rows:52222770, avaiable_index_name[index_p_id,index_store_sub_id,idx_acct_id,idx_prod_s_id,idx_store_acct_id_product_status_available,idx_shop_sku,index_prod_s_sku,index_store_s_sku,prod_sync_s_lazada], pruned_index_name[index_p_id,index_store_sub_id,idx_acct_id,idx_prod_s_id,idx_store_acct_id_product_status_available,idx_shop_sku,index_prod_s_sku], estimation info[table_id:505916, (table_type:10, version:-1--1--1, logical_rc:53595577, physical_rc:53595577), (table_type:11, version:-1--1--1, logical_rc:-1385016, physical_rc:6120166), (table_type:11, version:-1--1--1, logical_rc:-4694, physical_rc:769256), (table_type:0, version:-1--1--1, logical_rc:16903, physical_rc:35813)] |
+-----------+----------------+----------+----------+------------+--------------+----------------+----------------+----------+----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

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 = 'YB42AC1EE0B2-0006229DB85D2EDA-0-0'
) plan_monitor
LEFT JOIN
(
 SELECT ROWS, PLAN_LINE_ID FROM oceanbase.gv$ob_plan_cache_plan_explain WHERE plan_id = 43358462 AND tenant_id = 1004 and svr_ip = '172.30.224.178'  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 = 'YB42AC1EE0B2-0006229DB85D2EDA-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 = 'YB42AC1EE0B2-0006229DB85D2EDA-0-0'
ORDER BY
  PLAN_LINE_ID ASC, SVR_IP, SVR_PORT, CHANGE_TS, PROCESS_NAME ASC;

报告生成时间： 2024-12-05 09:38:54