ASH Report

           Cluster Name: oceanbase45103
       Observer Version: OceanBase_CE 4.3.5.5 (105010032025121323-524cb9015f8e905b5361bd410f99cf97c7df6557)
  Operation System Info: Linux(6.6.117-45.oc9.x86_64)_x86_64
  User Input Begin Time: 2026-07-23 08:00:00
    User Input End Time: 2026-07-23 10:00:00
Ash Analysis Begin Time: 2026-07-23 09:36:10
  Ash Analysis End Time: 2026-07-23 09:59:59
 Wr Analysis Begin Time: 2026-07-23 08:00:00
   Wr Analysis End Time: 2026-07-23 09:36:06
        Ash Data Source: oceanbase.GV$ACTIVE_SESSION_HISTORY
         Wr Data Source: oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY
           Elapsed Time: 7195
      Ash Num of Sample: 7835
       Wr Num of Sample: 59370
Average Active Sessions: 9.34

Top Active Tenants

this section lists top active tenant information
Total Samples: num of records during ash report analysis time period
Wait Event Samples: num of records when session is on wait event
On CPU Samples: num of records when session is on cpu
Avg Active Sessions: average active sessions during ash report analysis time period
% Activity: activity(cpu + wait) percentage for given tenant
Equivalent Client Load: equivalent client average active sessions during ash report analysis time period

Tenant Name	Session Type	Total Samples	Wait Event Samples	On CPU Samples	Avg Active Sessions	% Activity	Equivalent Client Load
zzlabel	FOREGROUND	35062	29913	5149	4.87	52.17%	4.59
zzlabel	BACKGROUND	32143	19002	13141	4.47	47.83%	-

Top Node Load

this section lists top node measured by DB time
IP: OceanBase instance svr_ip
Port: OceanBase instance svr_port
Total Samples: num of records during ash report analysis time period
Wait Event Samples: num of records when session is on wait event
On CPU Samples: num of records when session is on cpu
Avg Active Sessions: average active sessions during ash report analysis time period
% Activity: activity(cpu + wait) percentage for given tenant
Equivalent Client Load: equivalent client average active sessions during ash report analysis time period

IP	Port	Session Type	Total Samples	Wait Event Samples	On CPU Samples	Avg Active Sessions	% Activity	Equivalent Client Load
10.40.67.44	44103	FOREGROUND	12107	10032	2075	1.68	18.02%	2.14
10.40.66.249	44103	FOREGROUND	11867	10240	1627	1.65	17.66%	2.11
10.40.67.44	44103	BACKGROUND	11676	7825	3851	1.62	17.37%	-
10.40.65.76	44103	FOREGROUND	11086	9641	1445	1.54	16.50%	1.99
10.40.66.249	44103	BACKGROUND	7607	4066	3541	1.06	11.32%	-
10.40.66.120	44103	BACKGROUND	6487	3645	2842	0.90	9.65%	-
10.40.65.76	44103	BACKGROUND	6371	3465	2906	0.89	9.48%	-
10.40.66.120	44103	FOREGROUND	1	0	1	0.00	0.00%	0.00

Top Groups

this section lists top resource consumer groups
Group Name: resource consumer group name
Group Samples: num of sampled session activity records in the current resource group
% Activity: activity percentage for given event resource group
Avg Active Sessions: average active sessions during ash report analysis time period

Node	Group Name	Group Samples	% Activity	Program	% Program	Module	% Module	Action	% Action	Avg Active Sessions
10.40.67.44:44103	tenant:1004/group:0	23361	34.76%	T1004_SQL_CMD	18.33%	ReqWorker(Level:0)	17.92%	COM_QUERY	17.92%	1.67
				T1004_RPC_REQUEST	8.02%	ReqWorker(Level:0)	7.32%	OB_GAIS_PUSH_AUTO_INC_REQUEST	4.49%	0.42
								FastDFO	2.10%	0.20
				T1004_LogService	4.28%	LogIOWorker	3.66%	aggregate io task	3.65%	0.34
				T1004_DAG	3.15%	COMPACTION	3.15%	MAJOR_MERGE/MEDIUM_MERGE	2.99%	0.28
10.40.66.249:44103	tenant:1004/group:0	19261	28.66%	T1004_SQL_CMD	17.66%	ReqWorker(Level:0)	17.61%	COM_QUERY	17.61%	1.65
				T1004_LogService	4.01%	LogIOWorker	3.50%	aggregate io task	3.49%	0.33
				T1004_DAG	3.48%	COMPACTION	3.48%	MAJOR_MERGE/MEDIUM_MERGE	3.39%	0.32
				T1004_RPC_REQUEST	2.66%	ReqWorker(Level:0)	2.64%	FastDFO	2.18%	0.20
10.40.65.76:44103	tenant:1004/group:0	17457	25.98%	T1004_SQL_CMD	16.50%	ReqWorker(Level:0)	16.46%	COM_QUERY	16.46%	1.54
				T1004_DAG	3.33%	COMPACTION	3.33%	MAJOR_MERGE/MEDIUM_MERGE	3.18%	0.30
				T1004_LogService	3.22%	LogIOWorker	2.86%	aggregate io task	2.85%	0.27
				T1004_RPC_REQUEST	2.18%	ReqWorker(Level:0)	2.18%	FastDFO	1.91%	0.18
10.40.66.120:44103	tenant:1004/group:0	6392	9.51%	T1004_DAG	4.88%	COMPACTION	4.88%	MAJOR_MERGE/MEDIUM_MERGE	4.30%	0.40
				T1004_LogService	3.58%	LogIOWorker	3.02%	aggregate io task	3.00%	0.28

Slot Begin Time	Slot Count	Action Key	Action Samples	% Activity	Avg Active Sessions
2026-07-23 08:00:00(+720s)	10310	10.40.67.44:44103-tenant:1004/group:0-T1004_SQL_CMD-ReqWorker(Level:0)-COM_QUERY	1820	17.65%	2.53
2026-07-23 08:00:00(+720s)	10310	10.40.66.249:44103-tenant:1004/group:0-T1004_SQL_CMD-ReqWorker(Level:0)-COM_QUERY	1700	16.49%	2.36
2026-07-23 08:00:00(+720s)	10310	10.40.65.76:44103-tenant:1004/group:0-T1004_SQL_CMD-ReqWorker(Level:0)-COM_QUERY	1390	13.48%	1.93
2026-07-23 08:00:00(+720s)	10310	10.40.66.120:44103-tenant:1004/group:0-T1004_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE	720	6.98%	1.00
2026-07-23 08:00:00(+720s)	10310	10.40.67.44:44103-tenant:1004/group:0-T1004_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE	710	6.89%	0.99
2026-07-23 08:00:00(+720s)	10310	10.40.66.249:44103-tenant:1004/group:0-T1004_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE	670	6.50%	0.93
2026-07-23 08:00:00(+720s)	10310	10.40.65.76:44103-tenant:1004/group:0-T1004_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE	610	5.92%	0.85
2026-07-23 08:00:00(+720s)	10310	10.40.67.44:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	370	3.59%	0.51
2026-07-23 08:00:00(+720s)	10310	10.40.66.249:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	290	2.81%	0.40
2026-07-23 08:00:00(+720s)	10310	10.40.66.120:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	270	2.62%	0.38
2026-07-23 08:00:00(+720s)	10310	10.40.67.44:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-OB_GAIS_PUSH_AUTO_INC_REQUEST	220	2.13%	0.31
2026-07-23 08:00:00(+720s)	10310	10.40.65.76:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-FastDFO	210	2.04%	0.29
2026-07-23 08:00:00(+720s)	10310	10.40.65.76:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	180	1.75%	0.25
2026-07-23 08:00:00(+720s)	10310	10.40.66.249:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-FastDFO	180	1.75%	0.25
2026-07-23 08:00:00(+720s)	10310	10.40.67.44:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-FastDFO	160	1.55%	0.22
2026-07-23 08:12:00(+720s)	8540	10.40.66.249:44103-tenant:1004/group:0-T1004_SQL_CMD-ReqWorker(Level:0)-COM_QUERY	1790	20.96%	2.49
2026-07-23 08:12:00(+720s)	8540	10.40.65.76:44103-tenant:1004/group:0-T1004_SQL_CMD-ReqWorker(Level:0)-COM_QUERY	1720	20.14%	2.39
2026-07-23 08:12:00(+720s)	8540	10.40.67.44:44103-tenant:1004/group:0-T1004_SQL_CMD-ReqWorker(Level:0)-COM_QUERY	1580	18.50%	2.19
2026-07-23 08:12:00(+720s)	8540	10.40.67.44:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-OB_GAIS_PUSH_AUTO_INC_REQUEST	620	7.26%	0.86
2026-07-23 08:12:00(+720s)	8540	10.40.67.44:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	360	4.21%	0.50
2026-07-23 08:12:00(+720s)	8540	10.40.66.120:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	260	3.04%	0.36
2026-07-23 08:12:00(+720s)	8540	10.40.66.120:44103-tenant:1004/group:0-T1004_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE	260	3.04%	0.36
2026-07-23 08:12:00(+720s)	8540	10.40.65.76:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	240	2.81%	0.33
2026-07-23 08:12:00(+720s)	8540	10.40.66.249:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	210	2.46%	0.29
2026-07-23 08:12:00(+720s)	8540	10.40.66.249:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-FastDFO	190	2.23%	0.26
2026-07-23 08:12:00(+720s)	8540	10.40.67.44:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-FastDFO	150	1.76%	0.21
2026-07-23 08:12:00(+720s)	8540	10.40.66.249:44103-tenant:1004/group:0-T1004_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE	140	1.64%	0.19
2026-07-23 08:12:00(+720s)	8540	10.40.65.76:44103-tenant:1004/group:0-T1004_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE	90	1.05%	0.12
2026-07-23 08:12:00(+720s)	8540	10.40.65.76:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-FastDFO	80	0.94%	0.11
2026-07-23 08:12:00(+720s)	8540	10.40.67.44:44103-tenant:1004/group:0-T1004_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE	40	0.47%	0.06
2026-07-23 08:24:00(+720s)	7050	10.40.66.249:44103-tenant:1004/group:0-T1004_SQL_CMD-ReqWorker(Level:0)-COM_QUERY	1530	21.70%	2.12
2026-07-23 08:24:00(+720s)	7050	10.40.67.44:44103-tenant:1004/group:0-T1004_SQL_CMD-ReqWorker(Level:0)-COM_QUERY	1450	20.57%	2.01
2026-07-23 08:24:00(+720s)	7050	10.40.65.76:44103-tenant:1004/group:0-T1004_SQL_CMD-ReqWorker(Level:0)-COM_QUERY	1280	18.16%	1.78
2026-07-23 08:24:00(+720s)	7050	10.40.67.44:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-OB_GAIS_PUSH_AUTO_INC_REQUEST	410	5.82%	0.57
2026-07-23 08:24:00(+720s)	7050	10.40.66.249:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	330	4.68%	0.46
2026-07-23 08:24:00(+720s)	7050	10.40.67.44:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	310	4.40%	0.43
2026-07-23 08:24:00(+720s)	7050	10.40.65.76:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	210	2.98%	0.29
2026-07-23 08:24:00(+720s)	7050	10.40.66.120:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	180	2.55%	0.25
2026-07-23 08:24:00(+720s)	7050	10.40.65.76:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-FastDFO	120	1.70%	0.17
2026-07-23 08:24:00(+720s)	7050	10.40.65.76:44103-tenant:1004/group:0-T1004_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE	110	1.56%	0.15
2026-07-23 08:24:00(+720s)	7050	10.40.66.249:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-FastDFO	110	1.56%	0.15
2026-07-23 08:24:00(+720s)	7050	10.40.66.120:44103-tenant:1004/group:0-T1004_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE	110	1.56%	0.15
2026-07-23 08:24:00(+720s)	7050	10.40.66.249:44103-tenant:1004/group:0-T1004_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE	100	1.42%	0.14
2026-07-23 08:24:00(+720s)	7050	10.40.67.44:44103-tenant:1004/group:0-T1004_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE	80	1.14%	0.11
2026-07-23 08:24:00(+720s)	7050	10.40.67.44:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-FastDFO	80	1.14%	0.11
2026-07-23 08:36:00(+720s)	6180	10.40.65.76:44103-tenant:1004/group:0-T1004_SQL_CMD-ReqWorker(Level:0)-COM_QUERY	1610	26.05%	2.24
2026-07-23 08:36:00(+720s)	6180	10.40.67.44:44103-tenant:1004/group:0-T1004_SQL_CMD-ReqWorker(Level:0)-COM_QUERY	1320	21.36%	1.83
2026-07-23 08:36:00(+720s)	6180	10.40.66.249:44103-tenant:1004/group:0-T1004_SQL_CMD-ReqWorker(Level:0)-COM_QUERY	1100	17.80%	1.53
2026-07-23 08:36:00(+720s)	6180	10.40.67.44:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	260	4.21%	0.36
2026-07-23 08:36:00(+720s)	6180	10.40.66.249:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	240	3.88%	0.33
2026-07-23 08:36:00(+720s)	6180	10.40.66.120:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	230	3.72%	0.32
2026-07-23 08:36:00(+720s)	6180	10.40.65.76:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	200	3.24%	0.28
2026-07-23 08:36:00(+720s)	6180	10.40.67.44:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-OB_GAIS_PUSH_AUTO_INC_REQUEST	170	2.75%	0.24
2026-07-23 08:36:00(+720s)	6180	10.40.66.249:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-FastDFO	170	2.75%	0.24
2026-07-23 08:36:00(+720s)	6180	10.40.67.44:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-FastDFO	140	2.27%	0.19
2026-07-23 08:36:00(+720s)	6180	10.40.65.76:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-FastDFO	120	1.94%	0.17
2026-07-23 08:48:00(+720s)	8420	10.40.67.44:44103-tenant:1004/group:0-T1004_SQL_CMD-ReqWorker(Level:0)-COM_QUERY	1610	19.12%	2.24
2026-07-23 08:48:00(+720s)	8420	10.40.66.249:44103-tenant:1004/group:0-T1004_SQL_CMD-ReqWorker(Level:0)-COM_QUERY	1360	16.15%	1.89
2026-07-23 08:48:00(+720s)	8420	10.40.65.76:44103-tenant:1004/group:0-T1004_SQL_CMD-ReqWorker(Level:0)-COM_QUERY	1310	15.56%	1.82
2026-07-23 08:48:00(+720s)	8420	10.40.65.76:44103-tenant:1004/group:0-T1004_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE	400	4.75%	0.56
2026-07-23 08:48:00(+720s)	8420	10.40.66.120:44103-tenant:1004/group:0-T1004_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE	360	4.28%	0.50
2026-07-23 08:48:00(+720s)	8420	10.40.65.76:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	320	3.80%	0.44
2026-07-23 08:48:00(+720s)	8420	10.40.67.44:44103-tenant:1004/group:0-T1004_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE	310	3.68%	0.43
2026-07-23 08:48:00(+720s)	8420	10.40.67.44:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	270	3.21%	0.38
2026-07-23 08:48:00(+720s)	8420	10.40.66.249:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	270	3.21%	0.38
2026-07-23 08:48:00(+720s)	8420	10.40.66.249:44103-tenant:1004/group:0-T1004_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE	240	2.85%	0.33
2026-07-23 08:48:00(+720s)	8420	10.40.66.120:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	230	2.73%	0.32
2026-07-23 08:48:00(+720s)	8420	10.40.66.249:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-FastDFO	200	2.38%	0.28
2026-07-23 08:48:00(+720s)	8420	10.40.67.44:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-FastDFO	190	2.26%	0.26
2026-07-23 08:48:00(+720s)	8420	10.40.67.44:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-OB_GAIS_PUSH_AUTO_INC_REQUEST	180	2.14%	0.25
2026-07-23 08:48:00(+720s)	8420	10.40.65.76:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-FastDFO	150	1.78%	0.21
2026-07-23 09:00:00(+720s)	8040	10.40.66.249:44103-tenant:1004/group:0-T1004_SQL_CMD-ReqWorker(Level:0)-COM_QUERY	1210	15.05%	1.68
2026-07-23 09:00:00(+720s)	8040	10.40.67.44:44103-tenant:1004/group:0-T1004_SQL_CMD-ReqWorker(Level:0)-COM_QUERY	1010	12.56%	1.40
2026-07-23 09:00:00(+720s)	8040	10.40.65.76:44103-tenant:1004/group:0-T1004_SQL_CMD-ReqWorker(Level:0)-COM_QUERY	840	10.45%	1.17
2026-07-23 09:00:00(+720s)	8040	10.40.66.120:44103-tenant:1004/group:0-T1004_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE	760	9.45%	1.06
2026-07-23 09:00:00(+720s)	8040	10.40.66.249:44103-tenant:1004/group:0-T1004_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE	690	8.58%	0.96
2026-07-23 09:00:00(+720s)	8040	10.40.67.44:44103-tenant:1004/group:0-T1004_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE	670	8.33%	0.93
2026-07-23 09:00:00(+720s)	8040	10.40.65.76:44103-tenant:1004/group:0-T1004_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE	600	7.46%	0.83
2026-07-23 09:00:00(+720s)	8040	10.40.67.44:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-OB_GAIS_PUSH_AUTO_INC_REQUEST	360	4.48%	0.50
2026-07-23 09:00:00(+720s)	8040	10.40.66.249:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	290	3.61%	0.40
2026-07-23 09:00:00(+720s)	8040	10.40.66.120:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	260	3.23%	0.36
2026-07-23 09:00:00(+720s)	8040	10.40.65.76:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	220	2.74%	0.31
2026-07-23 09:00:00(+720s)	8040	10.40.67.44:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	170	2.11%	0.24
2026-07-23 09:00:00(+720s)	8040	10.40.67.44:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-FastDFO	150	1.87%	0.21
2026-07-23 09:00:00(+720s)	8040	10.40.66.249:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-FastDFO	120	1.49%	0.17
2026-07-23 09:00:00(+720s)	8040	10.40.65.76:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-FastDFO	50	0.62%	0.07
2026-07-23 09:12:00(+720s)	6440	10.40.66.249:44103-tenant:1004/group:0-T1004_SQL_CMD-ReqWorker(Level:0)-COM_QUERY	1070	16.61%	1.49
2026-07-23 09:12:00(+720s)	6440	10.40.67.44:44103-tenant:1004/group:0-T1004_SQL_CMD-ReqWorker(Level:0)-COM_QUERY	1010	15.68%	1.40
2026-07-23 09:12:00(+720s)	6440	10.40.65.76:44103-tenant:1004/group:0-T1004_SQL_CMD-ReqWorker(Level:0)-COM_QUERY	940	14.60%	1.31
2026-07-23 09:12:00(+720s)	6440	10.40.67.44:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-OB_GAIS_PUSH_AUTO_INC_REQUEST	590	9.16%	0.82
2026-07-23 09:12:00(+720s)	6440	10.40.66.120:44103-tenant:1004/group:0-T1004_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE	390	6.06%	0.54
2026-07-23 09:12:00(+720s)	6440	10.40.67.44:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	220	3.42%	0.31
2026-07-23 09:12:00(+720s)	6440	10.40.66.249:44103-tenant:1004/group:0-T1004_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE	210	3.26%	0.29
2026-07-23 09:12:00(+720s)	6440	10.40.66.249:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	190	2.95%	0.26
2026-07-23 09:12:00(+720s)	6440	10.40.66.120:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	180	2.79%	0.25
2026-07-23 09:12:00(+720s)	6440	10.40.65.76:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	130	2.02%	0.18
2026-07-23 09:12:00(+720s)	6440	10.40.66.249:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-FastDFO	130	2.02%	0.18
2026-07-23 09:12:00(+720s)	6440	10.40.65.76:44103-tenant:1004/group:0-T1004_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE	120	1.86%	0.17
2026-07-23 09:12:00(+720s)	6440	10.40.65.76:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-FastDFO	120	1.86%	0.17
2026-07-23 09:12:00(+720s)	6440	10.40.67.44:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-FastDFO	80	1.24%	0.11
2026-07-23 09:12:00(+720s)	6440	10.40.67.44:44103-tenant:1004/group:0-T1004_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE	70	1.09%	0.10
2026-07-23 09:24:00(+720s)	4390	10.40.66.249:44103-tenant:1004/group:0-T1004_SQL_CMD-ReqWorker(Level:0)-COM_QUERY	720	16.40%	1.00
2026-07-23 09:24:00(+720s)	4390	10.40.67.44:44103-tenant:1004/group:0-T1004_SQL_CMD-ReqWorker(Level:0)-COM_QUERY	700	15.95%	0.97
2026-07-23 09:24:00(+720s)	4390	10.40.65.76:44103-tenant:1004/group:0-T1004_SQL_CMD-ReqWorker(Level:0)-COM_QUERY	600	13.67%	0.83
2026-07-23 09:24:00(+720s)	4390	10.40.66.120:44103-tenant:1004/group:0-T1004_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE	230	5.24%	0.32
2026-07-23 09:24:00(+720s)	4390	10.40.66.249:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	210	4.78%	0.29
2026-07-23 09:24:00(+720s)	4390	10.40.67.44:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-OB_GAIS_PUSH_AUTO_INC_REQUEST	200	4.56%	0.28
2026-07-23 09:24:00(+720s)	4390	10.40.66.249:44103-tenant:1004/group:0-T1004_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE	180	4.10%	0.25
2026-07-23 09:24:00(+720s)	4390	10.40.65.76:44103-tenant:1004/group:0-T1004_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE	160	3.65%	0.22
2026-07-23 09:24:00(+720s)	4390	10.40.66.120:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	150	3.42%	0.21
2026-07-23 09:24:00(+720s)	4390	10.40.67.44:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-FastDFO	150	3.42%	0.21
2026-07-23 09:24:00(+720s)	4390	10.40.65.76:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-FastDFO	140	3.19%	0.19
2026-07-23 09:24:00(+720s)	4390	10.40.67.44:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	140	3.19%	0.19
2026-07-23 09:24:00(+720s)	4390	10.40.66.249:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-FastDFO	110	2.51%	0.15
2026-07-23 09:24:00(+720s)	4390	10.40.65.76:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	110	2.51%	0.15
2026-07-23 09:24:00(+720s)	4390	10.40.67.44:44103-tenant:1004/group:0-T1004_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE	90	2.05%	0.12
2026-07-23 09:36:00(+720s)	4306	10.40.67.44:44103-tenant:1004/group:0-T1004_SQL_CMD-ReqWorker(Level:0)-COM_QUERY	912	21.18%	1.27
2026-07-23 09:36:00(+720s)	4306	10.40.66.249:44103-tenant:1004/group:0-T1004_SQL_CMD-ReqWorker(Level:0)-COM_QUERY	732	17.00%	1.02
2026-07-23 09:36:00(+720s)	4306	10.40.65.76:44103-tenant:1004/group:0-T1004_SQL_CMD-ReqWorker(Level:0)-COM_QUERY	711	16.51%	0.99
2026-07-23 09:36:00(+720s)	4306	10.40.67.44:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-FastDFO	201	4.67%	0.28
2026-07-23 09:36:00(+720s)	4306	10.40.67.44:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-OB_GAIS_PUSH_AUTO_INC_REQUEST	182	4.23%	0.25
2026-07-23 09:36:00(+720s)	4306	10.40.67.44:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	181	4.20%	0.25
2026-07-23 09:36:00(+720s)	4306	10.40.66.249:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-FastDFO	151	3.51%	0.21
2026-07-23 09:36:00(+720s)	4306	10.40.65.76:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-FastDFO	148	3.44%	0.21
2026-07-23 09:36:00(+720s)	4306	10.40.66.249:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	144	3.34%	0.20
2026-07-23 09:36:00(+720s)	4306	10.40.65.76:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	136	3.16%	0.19
2026-07-23 09:36:00(+720s)	4306	10.40.66.120:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	97	2.25%	0.14
2026-07-23 09:36:00(+720s)	4306	10.40.66.120:44103-tenant:1004/group:0-T1004_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE	57	1.32%	0.08
2026-07-23 09:36:00(+720s)	4306	10.40.66.249:44103-tenant:1004/group:0-T1004_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE	46	1.07%	0.06
2026-07-23 09:36:00(+720s)	4306	10.40.65.76:44103-tenant:1004/group:0-T1004_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE	46	1.07%	0.06
2026-07-23 09:36:00(+720s)	4306	10.40.67.44:44103-tenant:1004/group:0-T1004_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE	38	0.88%	0.05
2026-07-23 09:48:00(+719s)	3526	10.40.65.76:44103-tenant:1004/group:0-T1004_SQL_CMD-ReqWorker(Level:0)-COM_QUERY	661	18.75%	0.92
2026-07-23 09:48:00(+719s)	3526	10.40.67.44:44103-tenant:1004/group:0-T1004_SQL_CMD-ReqWorker(Level:0)-COM_QUERY	631	17.90%	0.88
2026-07-23 09:48:00(+719s)	3526	10.40.66.249:44103-tenant:1004/group:0-T1004_SQL_CMD-ReqWorker(Level:0)-COM_QUERY	626	17.75%	0.87
2026-07-23 09:48:00(+719s)	3526	10.40.66.249:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	174	4.93%	0.24
2026-07-23 09:48:00(+719s)	3526	10.40.65.76:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	173	4.91%	0.24
2026-07-23 09:48:00(+719s)	3526	10.40.67.44:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	170	4.82%	0.24
2026-07-23 09:48:00(+719s)	3526	10.40.66.120:44103-tenant:1004/group:0-T1004_LogService-LogIOWorker-aggregate io task	157	4.45%	0.22
2026-07-23 09:48:00(+719s)	3526	10.40.65.76:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-FastDFO	142	4.03%	0.20
2026-07-23 09:48:00(+719s)	3526	10.40.67.44:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-FastDFO	109	3.09%	0.15
2026-07-23 09:48:00(+719s)	3526	10.40.66.249:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-FastDFO	106	3.01%	0.15
2026-07-23 09:48:00(+719s)	3526	10.40.67.44:44103-tenant:1004/group:0-T1004_RPC_REQUEST-ReqWorker(Level:0)-OB_GAIS_PUSH_AUTO_INC_REQUEST	83	2.35%	0.12

Top Foreground DB Time

This section lists top foreground db time categorized by event
Event Name: comprise wait event and on cpu event
Event Samples: num of sampled session activity records
% Activity: activity percentage for given event
Avg Active Sessions: average active sessions during ash report analysis time period

Node	Event Name	Wait Class	Event Samples	Avg Active Sessions	% Activity
10.40.67.44:44103	tx commiting wait	COMMIT	5852	0.81	8.71%
	ON CPU	NULL	2075	0.29	3.09%
	db file data read	USER_IO	1388	0.19	2.06%
	wait dtl data receive response	NETWORK	1231	0.17	1.83%
	latch: auto increment GAIS lock wait	CONCURRENCY	1136	0.16	1.69%
	exec inner sql wait	OTHER	273	0.04	0.41%
	sleep: lock for read need wait for concurrency control	CONCURRENCY	97	0.01	0.14%
	wait in request queue	CONFIGURATION	42	0.01	0.06%
	mysql response wait client	IDLE	11	0.00	0.02%
	row lock wait	APPLICATION	2	0.00	0.00%
10.40.66.249:44103	tx commiting wait	COMMIT	5643	0.78	8.40%
	db file data read	USER_IO	1746	0.24	2.60%
	sync rpc	NETWORK	1651	0.23	2.46%
	ON CPU	NULL	1627	0.23	2.42%
	wait dtl data receive response	NETWORK	1085	0.15	1.61%
	sync get gts timestamp wait	NETWORK	45	0.01	0.07%
	sleep: lock for read need wait for concurrency control	CONCURRENCY	43	0.01	0.06%
	wait in request queue	CONFIGURATION	27	0.00	0.04%
10.40.65.76:44103	tx commiting wait	COMMIT	5743	0.80	8.54%
	ON CPU	NULL	1445	0.20	2.15%
	db file data read	USER_IO	1445	0.20	2.15%
	sync rpc	NETWORK	1219	0.17	1.81%
	wait dtl data receive response	NETWORK	1027	0.14	1.53%
	sync get gts timestamp wait	NETWORK	91	0.01	0.14%
	sleep: lock for read need wait for concurrency control	CONCURRENCY	48	0.01	0.07%
	mysql response wait client	IDLE	33	0.01	0.05%
	wait in request queue	CONFIGURATION	24	0.00	0.04%
	row lock wait	APPLICATION	11	0.00	0.02%
10.40.66.120:44103	ON CPU	NULL	1	0.00	0.00%

Top Background DB Time

this section lists top DB Time for background sessions
Program: process name for background sessions
Event Name: comprise wait event and on cpu event
Event Samples: num of sampled session activity records
% Activity: activity percentage for given event
Avg Active Sessions: average active sessions during ash report analysis time period

Node	Program	Module	Action	Event Name	Wait Class	Event Samples	% Activity	Avg Active Sessions
10.40.67.44:44103	T1004_LogService	LogIOWorker	aggregate io task	palf write	SYSTEM_IO	2418	3.60%	0.34
	T1004_RPC_REQUEST	ReqWorker(Level:0)	OB_GAIS_PUSH_AUTO_INC_REQUEST	latch: auto increment GAIS lock wait	CONCURRENCY	2339	3.48%	0.33
	T1004_DAG	COMPACTION	MAJOR_MERGE/MEDIUM_MERGE	ON CPU	NULL	1609	2.39%	0.22
	T1004_RPC_REQUEST	ReqWorker(Level:0)	FastDFO	db file data read	USER_IO	794	1.18%	0.11
	T1004_RPC_REQUEST	ReqWorker(Level:0)	OB_GAIS_PUSH_AUTO_INC_REQUEST	exec inner sql wait	OTHER	507	0.75%	0.07
	T1004_RPC_REQUEST	ReqWorker(Level:0)	FastDFO	ON CPU	NULL	487	0.72%	0.07
	T1004_RPC_REQUEST	LOCAL INNER SQL EXEC	NULL_INNER_SQL	sync tx commiting wait	COMMIT	353	0.53%	0.05
	T1004_DAG	COMPACTION	MAJOR_MERGE/MEDIUM_MERGE	db file compact read	SYSTEM_IO	316	0.47%	0.04
	T1004_LogService	LogReplayService	TRANS_SERVICE	ON CPU	NULL	295	0.44%	0.04
	T1004_RPC_REQUEST	ReqWorker(Level:0)	OB_PX_FAST_INIT_SQC	ON CPU	NULL	291	0.43%	0.04
	T1004_RPC_REQUEST	ReqWorker(Level:0)	OB_GAIS_PUSH_AUTO_INC_REQUEST	ON CPU	NULL	169	0.25%	0.02
10.40.66.249:44103	T1004_LogService	LogIOWorker	aggregate io task	palf write	SYSTEM_IO	2305	3.43%	0.32
	T1004_DAG	COMPACTION	MAJOR_MERGE/MEDIUM_MERGE	ON CPU	NULL	1805	2.69%	0.25
	T1004_RPC_REQUEST	ReqWorker(Level:0)	FastDFO	db file data read	USER_IO	706	1.05%	0.10
	T1004_RPC_REQUEST	ReqWorker(Level:0)	FastDFO	ON CPU	NULL	638	0.95%	0.09
	T1004_DAG	COMPACTION	MAJOR_MERGE/MEDIUM_MERGE	db file compact read	SYSTEM_IO	408	0.61%	0.06
	T1004_LogService	LogReplayService	TRANS_SERVICE	ON CPU	NULL	248	0.37%	0.03
	T1004_RPC_REQUEST	ReqWorker(Level:0)	OB_PX_FAST_INIT_SQC	ON CPU	NULL	246	0.37%	0.03
10.40.66.120:44103	T1004_DAG	COMPACTION	MAJOR_MERGE/MEDIUM_MERGE	ON CPU	NULL	2152	3.20%	0.30
	T1004_LogService	LogIOWorker	aggregate io task	palf write	SYSTEM_IO	2010	2.99%	0.28
	T1004_DAG	COMPACTION	MAJOR_MERGE/MEDIUM_MERGE	db file compact read	SYSTEM_IO	370	0.55%	0.05
	T1004_DAG	COMPACTION	MAJOR_MERGE/MEDIUM_MERGE	db file data read	USER_IO	365	0.54%	0.05
	T1004_LogService	LogReplayService	TRANS_SERVICE	ON CPU	NULL	353	0.53%	0.05
	T1004_TimerWK	TimerWK	UNDEFINED	db file compact read	SYSTEM_IO	232	0.34%	0.03
10.40.65.76:44103	T1004_LogService	LogIOWorker	aggregate io task	palf write	SYSTEM_IO	1892	2.81%	0.26
	T1004_DAG	COMPACTION	MAJOR_MERGE/MEDIUM_MERGE	ON CPU	NULL	1735	2.58%	0.24
	T1004_RPC_REQUEST	ReqWorker(Level:0)	FastDFO	db file data read	USER_IO	606	0.90%	0.08
	T1004_RPC_REQUEST	ReqWorker(Level:0)	FastDFO	ON CPU	NULL	537	0.80%	0.07
	T1004_DAG	COMPACTION	MAJOR_MERGE/MEDIUM_MERGE	db file compact read	SYSTEM_IO	315	0.47%	0.04
	T1004_LogService	LogReplayService	TRANS_SERVICE	ON CPU	NULL	178	0.27%	0.03

Top Sessions

this section lists top Active Sessions with the largest wait event and SQL_ID
Session ID: user session id
% Activity: represents the load on the database caused by this session
Avg Active Sessions: average active sessions during ash report analysis time period
Event Name: comprise wait event and on cpu event
% Event: represents the activity load of the event on the database
% SQL ID: represents the activity load of the event on the database
Sql Executions: represents the execution count of the SQL_ID

Node	Session ID	Program	% Activity	Avg Active Sessions	Event Name	Wait Class	% Event	SQL ID	Plan Hash	% SQL ID	Sql Executions
10.40.65.76:44103	4319964	T1004_SQL_CMD	0.12%	0.01	tx commiting wait	COMMIT	0.06%	7BE9D4B3DF60DC4968FD178C6DD2661A	11561260236707163724	0.02%	3
10.40.66.249:44103	3935825	T1004_SQL_CMD	0.12%	0.01	tx commiting wait	COMMIT	0.11%	FAF443A7C5FFB84C377E0F179798D853	11561260236707163724	0.06%	4
10.40.65.76:44103	3953286	T1004_SQL_CMD	0.11%	0.01	tx commiting wait	COMMIT	0.08%	69E30EFBCF5EDD2CB6A3E5D8BA410B8C	8894128478548303855	0.03%	3
10.40.67.44:44103	4319964	T1004_SQL_CMD	0.11%	0.01	tx commiting wait	COMMIT	0.07%	6B11CBD7D2DDDA4910B0FEA5F9C5F963	2618661474761681335	0.03%	2
10.40.65.76:44103	4225062	T1004_SQL_CMD	0.11%	0.01	tx commiting wait	COMMIT	0.11%	69E30EFBCF5EDD2CB6A3E5D8BA410B8C	8894128478548303855	0.06%	4
10.40.67.44:44103	4484667	T1004_SQL_CMD	0.11%	0.01	tx commiting wait	COMMIT	0.07%	69E30EFBCF5EDD2CB6A3E5D8BA410B8C	8894128478548303855	0.03%	2
10.40.67.44:44103	4534628	T1004_SQL_CMD	0.11%	0.01	tx commiting wait	COMMIT	0.08%	27040E6FA3ED7D059EC4D2BD8FF798DC	2618661474761681335	0.03%	3
10.40.65.76:44103	4536953	T1004_SQL_CMD	0.11%	0.01	tx commiting wait	COMMIT	0.06%	6B11CBD7D2DDDA4910B0FEA5F9C5F963	2618661474761681335	0.03%	2
10.40.66.249:44103	4496114	T1004_SQL_CMD	0.11%	0.01	tx commiting wait	COMMIT	0.06%	6B11CBD7D2DDDA4910B0FEA5F9C5F963	2618661474761681335	0.03%	2
10.40.66.249:44103	4041610	T1004_SQL_CMD	0.10%	0.01	tx commiting wait	COMMIT	0.07%	6B11CBD7D2DDDA4910B0FEA5F9C5F963	2618661474761681335	0.03%	2
10.40.67.44:44103	4468869	T1004_SQL_CMD	0.10%	0.01	tx commiting wait	COMMIT	0.03%	69E30EFBCF5EDD2CB6A3E5D8BA410B8C	8894128478548303855	0.02%	2
10.40.66.249:44103	4517005	T1004_SQL_CMD	0.10%	0.01	tx commiting wait	COMMIT	0.08%	69E30EFBCF5EDD2CB6A3E5D8BA410B8C	8894128478548303855	0.04%	3
10.40.65.76:44103	4016623	T1004_SQL_CMD	0.10%	0.01	tx commiting wait	COMMIT	0.08%	27040E6FA3ED7D059EC4D2BD8FF798DC	2618661474761681335	0.05%	7
10.40.65.76:44103	4233457	T1004_SQL_CMD	0.10%	0.01	tx commiting wait	COMMIT	0.05%	7BE9D4B3DF60DC4968FD178C6DD2661A	11561260236707163724	0.02%	2
10.40.67.44:44103	4276246	T1004_SQL_CMD	0.10%	0.01	tx commiting wait	COMMIT	0.03%	7BE9D4B3DF60DC4968FD178C6DD2661A	11561260236707163724	0.02%	2

Top IO Bandwidth

This section lists the top io bandwidth from the perspective of SQL and background tasks
Node: The IP address and port number of the observer
Program Module Action / SQL ID: Program Module Action represent the type of background tasks, which is only effective in background tasks. And SQL ID is only effective in foreground tasks
Plan Hash: Numeric representation of the current SQL plan, which is only effective in foreground tasks.
IOPS: Average IO requests executed per second
IO Size: The total read or write size(MB) of background task or SQL
IO Bandwidth: Average IO size(MB) consumed per second
Type: read or write
Object ID: The tablet_id with the highest read or write bytes
% Object ID: The ratio of the tablet_id with the highest read or write bytes to the total bytes of tablet_ids in entire background task or SQL

Node	Program Module Action / SQL ID	Plan Hash	Type	IOPS	IO Size(MB)	IO Bandwidth(MB/s)	Object ID	% Object ID
10.40.65.76:44103	51DBC286C2E893B1511A66A6FC6DA119	18231308322961799645	disk_read	1858.74	0.47	29.36	1152921504606851003	100.00%
10.40.65.76:44103	T1004_DAG/COMPACTION/MINI_MERGE	0	disk_write	143.51	603.16	12.51	0	100.00%
10.40.65.76:44103	T1004_DAG/COMPACTION/MAJOR_MERGE/MEDIUM_MERGE	0	disk_read	20.79	130485.33	11.50	0	100.00%
10.40.65.76:44103	T1004_DAG/COMPACTION/TX_TABLE_MERGE	0	disk_read	32.04	404.11	11.49	0	100.00%
10.40.66.249:44103	T1004_DAG/COMPACTION/TX_TABLE_MERGE	0	disk_read	10.08	164.67	10.77	0	100.00%
10.40.67.44:44103	T1004_DAG/COMPACTION/MAJOR_MERGE/MEDIUM_MERGE	0	disk_read	19.42	107573.65	10.38	0	100.00%
10.40.65.76:44103	T1004_DAG/COMPACTION/MINOR_EXECUTE	0	disk_read	76.90	540.18	10.31	0	100.00%
10.40.65.76:44103	T1004_DAG/COMPACTION/MINOR_EXECUTE	0	disk_write	25.47	532.51	10.17	0	100.00%
10.40.67.44:44103	T1004_DAG/COMPACTION/MINOR_EXECUTE	0	disk_read	111.00	240.90	9.58	0	100.00%
10.40.65.76:44103	T1004_DAG/COMPACTION/TX_TABLE_MERGE	0	disk_write	8.62	322.93	9.18	0	100.00%
10.40.66.249:44103	T1004_DAG/COMPACTION/MAJOR_MERGE/MEDIUM_MERGE	0	disk_read	16.46	133522.06	9.11	0	100.00%
10.40.66.120:44103	T1004_DAG/COMPACTION/MAJOR_MERGE/MEDIUM_MERGE	0	disk_read	16.61	155431.31	8.62	0	100.00%
10.40.66.249:44103	T1004_DAG/COMPACTION/TX_TABLE_MERGE	0	disk_write	4.12	120.86	7.91	0	100.00%
10.40.65.76:44103	T1004_DAG/COMPACTION/MINI_MERGE	0	disk_read	261.50	379.73	7.88	0	100.00%
10.40.67.44:44103	T1004_DAG/COMPACTION/MINOR_EXECUTE	0	disk_write	38.59	192.07	7.64	0	100.00%
10.40.65.76:44103	T1004_DAG/COMPACTION/MAJOR_MERGE/MEDIUM_MERGE	0	disk_write	3.87	68684.52	6.05	0	100.00%
10.40.67.44:44103	T1004_DAG/COMPACTION/MAJOR_MERGE/MEDIUM_MERGE	0	disk_write	4.09	56775.16	5.48	0	100.00%
10.40.66.249:44103	T1004_DAG/COMPACTION/MAJOR_MERGE/MEDIUM_MERGE	0	disk_write	3.46	70407.38	4.80	0	100.00%
10.40.66.120:44103	T1004_DAG/COMPACTION/MINOR_EXECUTE	0	disk_write	22.46	788.62	4.73	0	100.00%
10.40.66.120:44103	T1004_DAG/COMPACTION/MAJOR_MERGE/MEDIUM_MERGE	0	disk_write	3.04	81905.72	4.54	0	100.00%
10.40.66.120:44103	T1004_DAG/COMPACTION/MINOR_EXECUTE	0	disk_read	52.53	731.79	4.39	0	100.00%
10.40.66.249:44103	T1004_DAG/COMPACTION/MINI_MERGE	0	disk_write	43.34	149.88	3.68	0	100.00%
10.40.66.120:44103	T1004_DAG/COMPACTION/TX_TABLE_MERGE	0	disk_read	11.18	388.44	2.36	0	100.00%
10.40.67.44:44103	T1004_DAG/COMPACTION/MINI_MERGE	0	disk_write	19.16	689.75	2.08	0	100.00%
10.40.67.44:44103	T1004_DAG/COMPACTION/MINI_MERGE	0	disk_read	38.51	622.07	1.88	0	100.00%
10.40.66.249:44103	T1004_DAG/COMPACTION/MINI_MERGE	0	disk_read	74.94	69.17	1.70	0	100.00%
10.40.67.44:44103	T1004_LogService/LogIOWorker/	0	disk_write	283.28	295.14	1.66	0	100.00%
10.40.66.120:44103	T1004_DAG/COMPACTION/TX_TABLE_MERGE	0	disk_write	1.13	211.22	1.28	0	100.00%
10.40.65.76:44103	T1004_LogService/LogIOWorker/aggregate io task	0	disk_write	189.29	19740.09	1.03	0	100.00%
10.40.67.44:44103	T1004_LogService/LogIOWorker/aggregate io task	0	disk_write	191.58	22498.18	1.02	0	100.00%
10.40.66.249:44103	T1004_LogService/LogIOWorker/aggregate io task	0	disk_write	185.69	21489.09	1.00	0	100.00%
10.40.66.120:44103	T1004_LogService/LogIOWorker/aggregate io task	0	disk_write	138.17	18355.30	0.76	0	100.00%
10.40.66.249:44103	T1004_DAG/COMPACTION/MINOR_EXECUTE	0	disk_write	4.15	586.67	0.74	0	100.00%
10.40.66.249:44103	T1004_DAG/COMPACTION/MINOR_EXECUTE	0	disk_read	11.01	584.08	0.74	0	100.00%
10.40.66.120:44103	T1004_LogService/LogIOWorker/	0	disk_write	123.36	249.22	0.61	0	100.00%
10.40.67.44:44103	T1004_BFBuildTask/BFBuildTask/BloomFilterBuild	0	disk_read	0.24	348.00	0.47	0	100.00%
10.40.65.76:44103	T1004_LogService/LogIOWorker/	0	disk_write	64.27	40.48	0.31	0	100.00%
10.40.66.249:44103	T1004_LogService/LogIOWorker/	0	disk_write	55.35	14.71	0.26	0	100.00%
10.40.66.249:44103	T1004_BFBuildTask/BFBuildTask/BloomFilterBuild	0	disk_read	0.12	2794.00	0.24	0	100.00%
10.40.66.120:44103	T1004_DAG/COMPACTION/MINI_MERGE	0	disk_write	2.66	783.00	0.22	0	100.00%
10.40.67.44:44103	T1004_RPC_REQUEST/ReqWorker(Level:5)/OB_PX_TARGET_REQUEST	0	disk_read	12.37	3.65	0.19	0	100.00%
10.40.66.120:44103	T1004_DAG/COMPACTION/MINI_MERGE	0	disk_read	4.89	561.90	0.16	0	100.00%
10.40.67.44:44103	T1004_RPC_REQUEST/ReqWorker(Level:0)/OB_CHECK_SYS_TABLE_SCHEMA	0	disk_read	9.15	10.38	0.14	0	100.00%
10.40.67.44:44103	T1004_RPC_REQUEST/ReqWorker(Level:5)/OB_REMOTE_SYNC_EXECUTE	0	disk_read	8.32	5.50	0.13	0	100.00%
10.40.67.44:44103	D9EB4937E65F94AA38F6B0FE72B06D13	12254811659671915614	disk_read	8.00	1.95	0.12	0	100.00%
10.40.65.76:44103	T1004_BFBuildTask/BFBuildTask/BloomFilterBuild	0	disk_read	0.06	76.00	0.12	0	100.00%
10.40.67.44:44103	T1004_RPC_REQUEST/ReqWorker(Level:0)/OB_LOG_ELECTION_ACCEPT_RESPONSE	0	disk_read	8.55	0.08	0.12	0	100.00%
10.40.66.249:44103	436B7D91382306E4054AE9A99C10A846	4024070737857038369	disk_read	6.89	4.29	0.11	0	100.00%
10.40.67.44:44103	9CA2F8D24467EB1A28CA50EE09743A86	15402238335871689439	disk_read	6.96	2.34	0.10	0	100.00%

Top Blocking Sessions

Blocking session activity percentages are calculated with respect to waits on enqueues, latches and "buffer busy" only.
'% Activity' represents the load on the database caused by a particular blocking session.
'# Avg Active Sessions' shows the number of ASH samples in which the blocking session was found active.

Blocking Session ID	% Activity	Avg Active Sessions	Holder User	Holder TX ID	Holder SQL ID	Event Caused	% Event	XIDs	Top Waitting SQL ID	% SQL ID

Top Latchs

this section lists top latches
Latch Wait Event: event that waiting for latch
Event Samples: num of sampled session activity records
% Activity: activity percentage for given event
Avg Active Sessions: average active sessions during ash report analysis time period

Latch Wait Event	Event Samples	% Activity	Avg Active Sessions
latch: auto increment GAIS lock wait	3475	5.17%	0.48
latch: default mutex wait	10	0.01%	0.00

Top DB Objects

With respect to Application, Cluster, User I/O and buffer busy waits only.
Object ID: tablet_id of the database table.
Avg Active Sessions: average active sessions during ash report analysis time period.
% Activity:the load on the database caused by accessing the databsae object.
Execution Count:represents how many executions involve this object
Event:When accessing the object, the corresponding Top waiting events (up to 5 are printed).
% Event:The percentage of the corresponding Top wait events when accessing the object (up to 5 events are printed).
SQL ID:the SQL ID with the highest load when accessing the object and in the wait event.
%SQL ID/Module:The percentage of SQL ID or Module with the highest load in this wait event when accessing the object.
Object Name (Type/ Partition Name):the name and type/partition_name of the database object being accessed

Node Address	Tenant ID	Object ID	Avg Active Sessions	% Activity	Execution Count	Event	% Event	SQL ID	%SQL ID/Module	Object Name (Type/Partition Name)
10.40.66.249:44103	1004	1152921504606850995	0.01	0.08%	6	db file data read	0.04%	F473D8895D6EF4C707F27316AA9C2108	0.04%	db58_zzlabel.label_user.uniq_uid_labelid(p48)
						ON CPU	0.03%	F473D8895D6EF4C707F27316AA9C2108	0.03%
	1004	1152921504606850785	0.01	0.07%	5	db file data read	0.04%	325B3ABB9AD3AAA360CF70373A17FCF7	0.01%	db58_zzlabel.label_product.uniq_productid_labelid(p160)
						sleep: lock for read need wait for concurrency control	0.01%	8E2E0AA9F00B424D170DE0402491EE32	0.01%
						ON CPU	0.01%	325B3ABB9AD3AAA360CF70373A17FCF7	0.01%
	1004	202505	0.01	0.06%	6	db file data read	0.05%	BAD403F7FB82F91AB958154E2D5875CE	0.01%	db58_zzlabel.label_user(p42)
						ON CPU	0.01%	F473D8895D6EF4C707F27316AA9C2108	0.01%
	1004	202410	0.01	0.06%	5	db file data read	0.05%	325B3ABB9AD3AAA360CF70373A17FCF7	0.01%	db58_zzlabel.label_product(p205)
						ON CPU	0.01%	95FBCF0AC71561BC8A700D195FE6A5FA	0.01%
	1004	1152921504606850950	0.01	0.06%	4	ON CPU	0.03%	F473D8895D6EF4C707F27316AA9C2108	0.03%	db58_zzlabel.label_user.uniq_uid_labelid(p3)
						db file data read	0.03%	F473D8895D6EF4C707F27316AA9C2108	0.03%
	1004	202359	0.01	0.05%	7	ON CPU	0.03%	325B3ABB9AD3AAA360CF70373A17FCF7	0.02%	db58_zzlabel.label_product(p154)
						db file data read	0.02%	8E2E0AA9F00B424D170DE0402491EE32	0.02%
	1004	202440	0.01	0.05%	6	ON CPU	0.05%	325B3ABB9AD3AAA360CF70373A17FCF7	0.05%	db58_zzlabel.label_product(p235)
	1004	202206	0.01	0.05%	6	ON CPU	0.03%	8E2E0AA9F00B424D170DE0402491EE32	0.03%	db58_zzlabel.label_product(p1)
	1004	202212	0.01	0.05%	6	ON CPU	0.03%	325B3ABB9AD3AAA360CF70373A17FCF7	0.03%	db58_zzlabel.label_product(p7)
						db file data read	0.02%	73690A81DF7ADC3F72F124C9105F168F	0.01%
						sleep: lock for read need wait for concurrency control	0.01%	325B3ABB9AD3AAA360CF70373A17FCF7	0.01%
						db file data read	0.00%	325B3ABB9AD3AAA360CF70373A17FCF7	0.00%
						db file data read	0.00%	8E2E0AA9F00B424D170DE0402491EE32	0.00%
	1004	202413	0.00	0.05%	5	ON CPU	0.05%	325B3ABB9AD3AAA360CF70373A17FCF7	0.02%	db58_zzlabel.label_product(p208)
	1004	202329	0.00	0.05%	5	ON CPU	0.05%	27040E6FA3ED7D059EC4D2BD8FF798DC	0.00%	db58_zzlabel.label_product(p124)
10.40.67.44:44103	1004	1152921504606851012	0.01	0.16%	26	ON CPU	0.12%	4E275683D1EAFD9FE9685EC6A2A4C6C3	0.00%	db58_zzlabel.user_label_relation.unique_index
						db file data read	0.03%	68E91E95307599949E83AF352518A31A	0.03%
	1004	182	0.01	0.11%	10	ON CPU	0.11%	11BC02B00E5D559A2D0A0C7A3576A113	0.04%	oceanbase.__all_auto_increment
	1004	202396	0.01	0.08%	6	ON CPU	0.04%	325B3ABB9AD3AAA360CF70373A17FCF7	0.03%	db58_zzlabel.label_product(p191)
						db file data read	0.03%	325B3ABB9AD3AAA360CF70373A17FCF7	0.01%
	1004	202255	0.01	0.07%	11	ON CPU	0.06%	325B3ABB9AD3AAA360CF70373A17FCF7	0.05%	db58_zzlabel.label_product(p50)
						db file data read	0.01%	325B3ABB9AD3AAA360CF70373A17FCF7	0.00%
						sleep: lock for read need wait for concurrency control	0.00%	5F76C602C3B3E12F10C080272B0B3E4B	0.00%
	1004	202527	0.01	0.07%	9	db file data read	0.07%	68E91E95307599949E83AF352518A31A	0.07%	db58_zzlabel.user_label_relation
	1004	202201	0.01	0.06%	13	ON CPU	0.06%	41F1ACA07326B154880B224D7E8C92CA	0.04%	db58_zzlabel.label_core
	1004	1152921504606850720	0.01	0.06%	4	db file data read	0.03%	73690A81DF7ADC3F72F124C9105F168F	0.01%	db58_zzlabel.label_product.uniq_productid_labelid(p95)
						ON CPU	0.03%	325B3ABB9AD3AAA360CF70373A17FCF7	0.01%
	1004	202219	0.01	0.05%	7	ON CPU	0.03%	325B3ABB9AD3AAA360CF70373A17FCF7	0.03%	db58_zzlabel.label_product(p14)
						sleep: lock for read need wait for concurrency control	0.02%	325B3ABB9AD3AAA360CF70373A17FCF7	0.01%
						db file data read	0.00%	8E2E0AA9F00B424D170DE0402491EE32	0.00%
	1004	202258	0.01	0.05%	6	db file data read	0.03%	325B3ABB9AD3AAA360CF70373A17FCF7	0.01%	db58_zzlabel.label_product(p53)
	1004	1152921504606850834	0.01	0.05%	6	db file data read	0.03%	325B3ABB9AD3AAA360CF70373A17FCF7	0.00%	db58_zzlabel.label_product.uniq_productid_labelid(p209)
						ON CPU	0.02%	325B3ABB9AD3AAA360CF70373A17FCF7	0.00%
						ON CPU	0.01%	325B3ABB9AD3AAA360CF70373A17FCF7	0.01%
						sleep: lock for read need wait for concurrency control	0.00%	325B3ABB9AD3AAA360CF70373A17FCF7	0.00%
10.40.65.76:44103	1004	202361	0.01	0.07%	8	ON CPU	0.06%	27040E6FA3ED7D059EC4D2BD8FF798DC	0.00%	db58_zzlabel.label_product(p156)
						db file data read	0.00%	8E2E0AA9F00B424D170DE0402491EE32	0.00%
	1004	202418	0.01	0.06%	7	db file data read	0.05%	325B3ABB9AD3AAA360CF70373A17FCF7	0.03%	db58_zzlabel.label_product(p213)
						ON CPU	0.02%	325B3ABB9AD3AAA360CF70373A17FCF7	0.02%
	1004	202244	0.01	0.06%	6	ON CPU	0.05%	325B3ABB9AD3AAA360CF70373A17FCF7	0.02%	db58_zzlabel.label_product(p39)
						db file data read	0.02%	325B3ABB9AD3AAA360CF70373A17FCF7	0.01%
	1004	1152921504606850718	0.01	0.06%	5	db file data read	0.04%	325B3ABB9AD3AAA360CF70373A17FCF7	0.01%	db58_zzlabel.label_product.uniq_productid_labelid(p93)
						ON CPU	0.01%	8E2E0AA9F00B424D170DE0402491EE32	0.01%
						sleep: lock for read need wait for concurrency control	0.00%	325B3ABB9AD3AAA360CF70373A17FCF7	0.00%
	1004	202217	0.01	0.05%	9	ON CPU	0.04%	325B3ABB9AD3AAA360CF70373A17FCF7	0.02%	db58_zzlabel.label_product(p12)
						db file data read	0.02%	8E2E0AA9F00B424D170DE0402491EE32	0.02%
	1004	202352	0.01	0.05%	8	ON CPU	0.03%	325B3ABB9AD3AAA360CF70373A17FCF7	0.01%	db58_zzlabel.label_product(p147)
						db file data read	0.02%	325B3ABB9AD3AAA360CF70373A17FCF7	0.01%
	1004	202457	0.01	0.05%	7	ON CPU	0.05%	325B3ABB9AD3AAA360CF70373A17FCF7	0.03%	db58_zzlabel.label_product(p252)
						db file data read	0.00%	325B3ABB9AD3AAA360CF70373A17FCF7	0.00%
	1004	202358	0.01	0.05%	6	ON CPU	0.04%	27040E6FA3ED7D059EC4D2BD8FF798DC	0.01%	db58_zzlabel.label_product(p153)
	1004	1152921504606850958	0.01	0.05%	6	db file data read	0.03%	E59849E58B52DA244B5A1A05C776BD39	0.00%	db58_zzlabel.label_user.uniq_uid_labelid(p11)
						ON CPU	0.02%	F473D8895D6EF4C707F27316AA9C2108	0.02%
						db file data read	0.00%	5F76C602C3B3E12F10C080272B0B3E4B	0.00%

Activity Over Time

this section lists time slot information during the analysis period.
The numbers in parentheses represent the time (in seconds) that has passed since the beginning and end stages.
Slot Begin Time: current slot's begin time. current slot end with next slot begin time.
Event Name: comprise wait event and on cpu event.
Event Samples: num of sampled session activity records.
% Activity: activity percentage for given event.
Avg Active Sessions: average active sessions during ash report analysis time period.

Slot Begin Time	Slot Count	Event Name	Wait Class	Event Samples	% Activity	Avg Active Sessions
2026-07-23 08:00:00	10310	ON CPU	NULL	3470	33.66%	4.82
		tx commiting wait	COMMIT	2730	26.48%	3.79
		db file data read	USER_IO	1430	13.87%	1.99
		palf write	SYSTEM_IO	1100	10.67%	1.53
		wait dtl data receive response	NETWORK	390	3.78%	0.54
2026-07-23 08:12:00	8540	tx commiting wait	COMMIT	2740	32.08%	3.81
		ON CPU	NULL	1730	20.26%	2.40
		palf write	SYSTEM_IO	1060	12.41%	1.47
		db file data read	USER_IO	850	9.95%	1.18
		latch: auto increment GAIS lock wait	CONCURRENCY	710	8.31%	0.99
2026-07-23 08:24:00	7050	tx commiting wait	COMMIT	2240	31.77%	3.11
		ON CPU	NULL	1580	22.41%	2.19
		palf write	SYSTEM_IO	1030	14.61%	1.43
		db file data read	USER_IO	610	8.65%	0.85
		latch: auto increment GAIS lock wait	CONCURRENCY	490	6.95%	0.68
2026-07-23 08:36:00	6180	tx commiting wait	COMMIT	2550	41.26%	3.54
		ON CPU	NULL	1180	19.09%	1.64
		palf write	SYSTEM_IO	910	14.72%	1.26
		db file data read	USER_IO	530	8.58%	0.74
		wait dtl data receive response	NETWORK	290	4.69%	0.40
2026-07-23 08:48:00	8420	tx commiting wait	COMMIT	2550	30.29%	3.54
		ON CPU	NULL	2270	26.96%	3.15
		db file data read	USER_IO	1070	12.71%	1.49
		palf write	SYSTEM_IO	1070	12.71%	1.49
		db file compact read	SYSTEM_IO	400	4.75%	0.56
2026-07-23 09:00:00	8040	ON CPU	NULL	3240	40.30%	4.50
		db file data read	USER_IO	970	12.06%	1.35
		palf write	SYSTEM_IO	930	11.57%	1.29
		tx commiting wait	COMMIT	820	10.20%	1.14
		db file compact read	SYSTEM_IO	460	5.72%	0.64
2026-07-23 09:12:00	6440	ON CPU	NULL	1690	26.24%	2.35
		tx commiting wait	COMMIT	920	14.29%	1.28
		latch: auto increment GAIS lock wait	CONCURRENCY	750	11.65%	1.04
		palf write	SYSTEM_IO	720	11.18%	1.00
		sync rpc	NETWORK	600	9.32%	0.83
2026-07-23 09:24:00	4390	ON CPU	NULL	1310	29.84%	1.82
		tx commiting wait	COMMIT	910	20.73%	1.26
		palf write	SYSTEM_IO	590	13.44%	0.82
		db file data read	USER_IO	430	9.79%	0.60
		wait dtl data receive response	NETWORK	300	6.83%	0.42
2026-07-23 09:36:00	4296	ON CPU	NULL	999	23.25%	1.39
		tx commiting wait	COMMIT	869	20.23%	1.21
		db file data read	USER_IO	560	13.04%	0.78
		palf write	SYSTEM_IO	551	12.83%	0.77
		wait dtl data receive response	NETWORK	471	10.96%	0.65
2026-07-23 09:48:00(+719s)	3526	tx commiting wait	COMMIT	909	25.78%	1.26
		ON CPU	NULL	813	23.06%	1.13
		palf write	SYSTEM_IO	664	18.83%	0.92
		db file data read	USER_IO	410	11.63%	0.57
		wait dtl data receive response	NETWORK	302	8.56%	0.42

Top Execution Phase

this section lists top phases of execution, such as SQL, PL/SQL, STORAGE, etc.

Session Type	Phase of Execution	Active Samples	% Activity	SQL_ID	% SQL_ID
FOREGROUND	IN_COMMITTING	17238	25.65%	6B11CBD7D2DDDA4910B0FEA5F9C5F963	5.57%
	IN_SQL_EXECUTION	16732	24.90%	69E30EFBCF5EDD2CB6A3E5D8BA410B8C	5.77%
	IN_STORAGE_READ	5974	8.89%	325B3ABB9AD3AAA360CF70373A17FCF7	3.50%
	IN_STORAGE_WRITE	1461	2.17%	6B11CBD7D2DDDA4910B0FEA5F9C5F963	0.88%
	IN_PLAN_CACHE	476	0.71%	F473D8895D6EF4C707F27316AA9C2108	0.23%
	IN_CHECK_TX_STATUS	188	0.28%	325B3ABB9AD3AAA360CF70373A17FCF7	0.26%
	IN_RPC_ENCODE	81	0.12%	8E2E0AA9F00B424D170DE0402491EE32	0.05%
	IN_PARSE	64	0.10%	F473D8895D6EF4C707F27316AA9C2108	0.03%
	IN_DUPLICATE_CONFLICT_RESOLVE	46	0.07%	69E30EFBCF5EDD2CB6A3E5D8BA410B8C	0.07%
	IN_EXTRACT_QUERY_RANGE	42	0.06%	325B3ABB9AD3AAA360CF70373A17FCF7	0.02%
	IN_CHECK_ROW_CONFLICTION	1	0.00%	BF476985C35D830ED51728D978A506DF	0.00%
	IN_CONNECTION_MGR	1	0.00%	69E30EFBCF5EDD2CB6A3E5D8BA410B8C	0.00%
BACKGROUND	IN_SQL_EXECUTION	4283	6.37%	8E2E0AA9F00B424D170DE0402491EE32	3.71%
	IN_PX_EXECUTION	4153	6.18%	8E2E0AA9F00B424D170DE0402491EE32	3.64%
	IN_STORAGE_READ	3605	5.36%	8E2E0AA9F00B424D170DE0402491EE32	3.24%
	IN_COMMITTING	654	0.97%	1D0BA376E273B9D622641124D8C59264	0.88%
	IN_RPC_DECODE	482	0.72%	8E2E0AA9F00B424D170DE0402491EE32	0.30%
	IN_CHECK_TX_STATUS	234	0.35%	8E2E0AA9F00B424D170DE0402491EE32	0.22%
	IN_STORAGE_WRITE	73	0.11%	794DC67C718DD908C6F8371776EE6795	0.06%
	IN_CONNECTION_MGR	43	0.06%		0.05%
	IN_RPC_ENCODE	19	0.03%		0.02%
	IN_DUPLICATE_CONFLICT_RESOLVE	11	0.02%	BCEA3A0E2C966C0B7A399D59A8EBB142	0.01%
	IN_PLSQL_EXECUTION	11	0.02%	E9E2014C8CE705871C555597A6A32456	0.02%
	IN_PLAN_CACHE	4	0.01%	794DC67C718DD908C6F8371776EE6795	0.00%

Top IO Events

This section lists the top io event from the perspective of SQL and background tasks
Node: The IP address and port number of the observer
Program Module Action / SQL ID: Program Module Action represent the type of background tasks, which is only effective in background tasks. And SQL ID is only effective in foreground tasks
Plan Hash: Numeric representation of the current SQL plan, which is only effective in foreground tasks
IO Event Samples: The total samples of io wait event during task execution.
%IO Event Samples: The proportion of total io wait event samples among all sampled points
Top Event: The top io wait event name.
IO Type: The type of io wait event.
% EVENT: activity percentage for the io wait event.
Enqueue Time: The total time(in seconds) spent queuing for I/O requests.
Device Time: The total time (in seconds) spent executing I/O requests on the device.
Callback Time: The total time (in seconds) spent executing callbacks for I/O requests.

Node	Program Module Action / SQL ID	Plan Hash	IO Event Samples	%IO Event Samples	Top Event	IO Type	% EVENT	Enqueue Time(S)	Device Time(S)	Callback Time(S)
10.40.67.44:44103	T1004_LogService/LogIOWorker/aggregate io task	0	2418	3.60%	palf write	SYSTEM_IO	3.60%	320.63	3104.48	0.00
10.40.66.249:44103	T1004_LogService/LogIOWorker/aggregate io task	0	2305	3.43%	palf write	SYSTEM_IO	3.43%	256.06	2825.40	0.00
10.40.66.120:44103	T1004_LogService/LogIOWorker/aggregate io task	0	2010	2.99%	palf write	SYSTEM_IO	2.99%	9.24	2231.98	0.00
10.40.65.76:44103	T1004_LogService/LogIOWorker/aggregate io task	0	1892	2.81%	palf write	SYSTEM_IO	2.81%	284.74	2244.51	0.00
10.40.66.120:44103	T1004_DAG/COMPACTION/MAJOR_MERGE/MEDIUM_MERGE	0	735	1.09%	db file compact read	SYSTEM_IO	0.55%	5.76	424.54	0.96
10.40.66.249:44103	F473D8895D6EF4C707F27316AA9C2108	14928774872249983864	487	0.72%	db file data read	USER_IO	0.72%	419.15	251.15	0.30
10.40.66.249:44103	T1004_DAG/COMPACTION/MAJOR_MERGE/MEDIUM_MERGE	0	471	0.70%	db file compact read	SYSTEM_IO	0.61%	12.12	491.40	41.65
10.40.67.44:44103	8E2E0AA9F00B424D170DE0402491EE32	2029748640274024157	445	0.66%	db file data read	USER_IO	0.66%	424.93	220.67	0.47
10.40.65.76:44103	T1004_DAG/COMPACTION/MAJOR_MERGE/MEDIUM_MERGE	0	401	0.60%	db file compact read	SYSTEM_IO	0.47%	10.64	428.57	0.00
10.40.67.44:44103	T1004_DAG/COMPACTION/MAJOR_MERGE/MEDIUM_MERGE	0	399	0.59%	db file compact read	SYSTEM_IO	0.47%	15.74	408.18	6.57
10.40.66.249:44103	325B3ABB9AD3AAA360CF70373A17FCF7	11013570064090107881	391	0.58%	db file data read	USER_IO	0.58%	211.20	342.32	0.76
10.40.65.76:44103	8E2E0AA9F00B424D170DE0402491EE32	2029748640274024157	376	0.56%	db file data read	USER_IO	0.56%	320.49	202.84	0.41
10.40.66.249:44103	8E2E0AA9F00B424D170DE0402491EE32	2029748640274024157	342	0.51%	db file data read	USER_IO	0.51%	227.21	227.73	0.53
10.40.65.76:44103	F473D8895D6EF4C707F27316AA9C2108	14928774872249983864	296	0.44%	db file data read	USER_IO	0.44%	242.44	143.36	0.23
10.40.67.44:44103	325B3ABB9AD3AAA360CF70373A17FCF7	11013570064090107881	288	0.43%	db file data read	USER_IO	0.43%	168.31	226.31	0.37
10.40.65.76:44103	325B3ABB9AD3AAA360CF70373A17FCF7	11013570064090107881	257	0.38%	db file data read	USER_IO	0.38%	188.11	164.49	0.38
10.40.67.44:44103	F473D8895D6EF4C707F27316AA9C2108	14928774872249983864	257	0.38%	db file data read	USER_IO	0.38%	158.41	192.20	0.17
10.40.65.76:44103	7BE9D4B3DF60DC4968FD178C6DD2661A	11561260236707163724	240	0.36%	db file data read	USER_IO	0.36%	89.89	237.92	0.44
10.40.66.249:44103	7BE9D4B3DF60DC4968FD178C6DD2661A	11561260236707163724	221	0.33%	db file data read	USER_IO	0.33%	12.92	282.78	0.59
10.40.66.120:44103	T1004_DAG/COMPACTION/MINI_MERGE	0	196	0.29%	db file compact write	SYSTEM_IO	0.15%	102.04	10.26	0.00
10.40.66.249:44103	C535FF13485F55FD455B52BF6F4381A5	9505620650660437702	173	0.26%	db file data read	USER_IO	0.26%	121.10	99.51	0.32
10.40.67.44:44103	7BE9D4B3DF60DC4968FD178C6DD2661A	11561260236707163724	160	0.24%	db file data read	USER_IO	0.24%	61.42	167.90	0.27
10.40.65.76:44103	6B11CBD7D2DDDA4910B0FEA5F9C5F963	2618661474761681335	160	0.24%	db file data read	USER_IO	0.24%	137.55	92.49	0.42
10.40.67.44:44103	73690A81DF7ADC3F72F124C9105F168F	2029748640274024157	154	0.23%	db file data read	USER_IO	0.23%	107.12	116.77	0.20

Top SQL Statement Types

this section lists top sql statement type.
SQL Statement Type: SQL statement types such as SELECT or UPDATE
Total Samples: num of records during ash report analysis time period
% Event: activity percentage of records when session is on wait event
% On CPU: activity percentage of records when session is on cpu
% Activity: activity(cpu + wait) percentage for given tenant
Node: the server address where the statement was executed

SQL Statement Type	Total Samples	% Activity	Sampled Executions	Node	% Node	% On CPU	% Event
T_NONE	25930	38.58%	654	10.40.67.44:44103	13.42%	4.27%	9.15%
				10.40.66.120:44103	9.53%	4.23%	5.30%
				10.40.66.249:44103	8.49%	3.93%	4.55%
				10.40.65.76:44103	7.15%	3.32%	3.83%
T_SELECT	15813	23.53%	1362	10.40.67.44:44103	8.44%	3.49%	4.95%
				10.40.66.249:44103	8.11%	3.13%	4.98%
				10.40.65.76:44103	6.87%	2.59%	4.28%
T_DELETE	14066	20.93%	974	10.40.67.44:44103	7.68%	0.61%	7.07%
				10.40.65.76:44103	6.84%	0.38%	6.46%
				10.40.66.249:44103	6.41%	0.36%	6.05%
T_INSERT	10637	15.83%	685	10.40.66.249:44103	5.89%	0.26%	5.63%
				10.40.65.76:44103	5.03%	0.18%	4.85%
				10.40.67.44:44103	4.89%	0.35%	4.54%
T_END_TRANS	590	0.88%	115	10.40.67.44:44103	0.79%	0.02%	0.77%
T_UPDATE	134	0.20%	5	10.40.67.44:44103	0.15%	0.06%	0.09%

Top SQL with Top Events

This Section lists the SQL statements that accounted for the highest percentages event.
Plan Hash: Numeric representation of the current SQL plan
Active Samples: num of samples for top current SQL
% Activity: activity percentage for given SQL ID
Sampled Executions: represents the number of times the current SQL execution has been sampled
Top Event: top event name for current SQL plan
% Event: activity percentage for current SQL plan
Top Operator/ExecPhase: top operator name or execution phase for current event
% Operator/ExecPhase: activity percentage for given operator

SQL ID	Plan Hash	Active Samples	% Activity	Sampled Executions	Top Event	% Event	Top Operator/ExecPhase	% Operator/ExecPhase	SQL Text
69E30EFBCF5EDD2CB6A3E5D8BA410B8C	8894128478548303855	6782	10.09%	1139	tx commiting wait	4.28%	0:DISTRIBUTED INSERT_UP	4.28%	INSERT INTO label_product (id, product_id, label_id, la
					sync rpc	3.52%	0:DISTRIBUTED INSERT_UP	3.52%
					latch: auto increment GAIS lock wait	1.39%	0:DISTRIBUTED INSERT_UP	1.39%
					ON CPU	0.49%	0:DISTRIBUTED INSERT_UP	0.49%
					exec inner sql wait	0.31%	0:DISTRIBUTED INSERT_UP	0.31%
8E2E0AA9F00B424D170DE0402491EE32	2029748640274024157	4602	6.85%	1191	wait dtl data receive response	2.56%	0:PX COORDINATOR	2.56%	SELECT * FROM label_product WHERE product_id in (?,?,?,
					ON CPU	2.11%	3:TABLE RANGE SCAN:label_product(uniq_productid_labelid)	1.36%
					db file data read	1.73%	3:TABLE RANGE SCAN:label_product(uniq_productid_labelid)	1.73%
					sleep: lock for read need wait for concurrency control	0.22%	3:TABLE RANGE SCAN:label_product(uniq_productid_labelid)	0.22%
					wait dtl transmit message response	0.10%	1:EXCHANGE OUT DISTR::EX10000	0.10%
6B11CBD7D2DDDA4910B0FEA5F9C5F963	2618661474761681335	4453	6.63%	448	tx commiting wait	5.57%	0:DELETE	5.57%	DELETE FROM label_product WHERE product_id=? and label_
					db file data read	0.64%	0:DELETE	0.64%
					ON CPU	0.42%	0:DELETE	0.28%
FAF443A7C5FFB84C377E0F179798D853	11561260236707163724	3931	5.85%	394	tx commiting wait	5.49%	0:DELETE	5.49%	DELETE FROM info_label_relation WHERE info_id=? and lab
					ON CPU	0.30%	1:TABLE RANGE SCAN:info_label_relation(unique_index)	0.15%
					db file data read	0.06%	1:TABLE RANGE SCAN:info_label_relation(unique_index)	0.06%
325B3ABB9AD3AAA360CF70373A17FCF7	11013570064090107881	2860	4.26%	664	ON CPU	2.57%	0:TABLE RANGE SCAN:label_product(uniq_productid_labelid)	2.57%	SELECT * FROM label_product WHERE product_id in (?)
					db file data read	1.39%	0:TABLE RANGE SCAN:label_product(uniq_productid_labelid)	1.39%
					sleep: lock for read need wait for concurrency control	0.26%	0:TABLE RANGE SCAN:label_product(uniq_productid_labelid)	0.26%
					wait in request queue	0.03%	0:TABLE RANGE SCAN:label_product(uniq_productid_labelid)	0.03%
7BE9D4B3DF60DC4968FD178C6DD2661A	11561260236707163724	2751	4.09%	915	tx commiting wait	2.86%	0:DELETE	2.86%	DELETE FROM info_label_relation WHERE info_id=? and lab
					db file data read	0.92%	1:TABLE RANGE SCAN:info_label_relation(unique_index)	0.92%
					ON CPU	0.29%	1:TABLE RANGE SCAN:info_label_relation(unique_index)	0.15%
					wait in request queue	0.01%	0:DELETE	0.01%
27040E6FA3ED7D059EC4D2BD8FF798DC	2618661474761681335	2629	3.91%	892	tx commiting wait	3.41%	0:DELETE	3.41%	DELETE FROM label_product WHERE product_id=? and label_
					ON CPU	0.28%	0:DELETE	0.20%
					db file data read	0.22%	1:TABLE GET:label_product(uniq_productid_labelid)	0.18%
					wait in request queue	0.00%	0:DELETE	0.00%
97178AD500CF38C191139A4BD49538BB	3290318591324336132	2507	3.73%	338	tx commiting wait	2.93%	0:DISTRIBUTED INSERT	2.93%	INSERT INTO info_label_relation (id,info_id, label_id,
					db file data read	0.58%	0:DISTRIBUTED INSERT	0.58%
					ON CPU	0.21%	0:DISTRIBUTED INSERT	0.18%
F473D8895D6EF4C707F27316AA9C2108	14928774872249983864	1889	2.81%	413	db file data read	1.55%	0:TABLE RANGE SCAN:label_user(uniq_uid_labelid)	1.55%	SELECT * FROM label_user WHERE ?=? and uid in (?)
					ON CPU	1.19%	0:TABLE RANGE SCAN:label_user(uniq_uid_labelid)	1.19%
					wait in request queue	0.07%	0:TABLE RANGE SCAN:label_user(uniq_uid_labelid)	0.07%
					sleep: lock for read need wait for concurrency control	0.00%	0:TABLE RANGE SCAN:label_user(uniq_uid_labelid)	0.00%
73690A81DF7ADC3F72F124C9105F168F	2029748640274024157	1136	1.69%	241	wait dtl data receive response	0.69%	0:PX COORDINATOR	0.69%	SELECT * FROM label_product WHERE product_id in (?,?)
					db file data read	0.52%	3:TABLE RANGE SCAN:label_product(uniq_productid_labelid)	0.52%
					ON CPU	0.37%	3:TABLE RANGE SCAN:label_product(uniq_productid_labelid)	0.17%
					sleep: lock for read need wait for concurrency control	0.06%	3:TABLE RANGE SCAN:label_product(uniq_productid_labelid)	0.06%
					wait dtl receive message response	0.03%	0:PX COORDINATOR	0.03%
5F76C602C3B3E12F10C080272B0B3E4B	2029748640274024157	824	1.23%	178	wait dtl data receive response	0.55%	0:PX COORDINATOR	0.55%	SELECT * FROM label_product WHERE product_id in (?,?,?)
					db file data read	0.32%	3:TABLE RANGE SCAN:label_product(uniq_productid_labelid)	0.32%
					ON CPU	0.22%	3:TABLE RANGE SCAN:label_product(uniq_productid_labelid)	0.13%
					wait dtl transmit message response	0.05%	1:EXCHANGE OUT DISTR::EX10000	0.05%
					sync get gts timestamp wait	0.03%	0:PX COORDINATOR	0.03%
95FBCF0AC71561BC8A700D195FE6A5FA	2029748640274024157	804	1.20%	186	wait dtl data receive response	0.47%	0:PX COORDINATOR	0.47%	SELECT * FROM label_product WHERE product_id in (?,?,?,
					ON CPU	0.42%	3:TABLE RANGE SCAN:label_product(uniq_productid_labelid)	0.28%
					db file data read	0.21%	3:TABLE RANGE SCAN:label_product(uniq_productid_labelid)	0.21%
					sleep: lock for read need wait for concurrency control	0.04%	3:TABLE RANGE SCAN:label_product(uniq_productid_labelid)	0.04%
					wait dtl receive message response	0.04%	0:PX COORDINATOR	0.03%

Top SQL with Top Operator

This Section lists the SQL statements that accounted for the highest percentages of sampled session activity with sql operator
Plan Hash: Numeric representation of the current SQL plan
Active Samples: num of samples for top current SQL
% Activity: activity percentage for given SQL ID
Sampled Executions: represents the number of times the current SQL execution has been sampled
Top Operator: top operator name for current SQL plan
% Operator: activity percentage for given operator
Top Event: top event name for current operator
% Event: activity percentage for given event

SQL ID	Plan Hash	Active Samples	% Activity	Sampled Executions	Top Operator	% Operator	Top Event	% Event	SQL Text
69E30EFBCF5EDD2CB6A3E5D8BA410B8C	8894128478548303855	6782	10.09%	1139	0:DISTRIBUTED INSERT_UP	10.09%	tx commiting wait	4.28%	INSERT INTO label_product (id, product_id, label_id, la
8E2E0AA9F00B424D170DE0402491EE32	2029748640274024157	4530	6.74%	1178	3:TABLE RANGE SCAN:label_product(uniq_productid_labelid)	3.31%	db file data read	1.73%	SELECT * FROM label_product WHERE product_id in (?,?,?,
					0:PX COORDINATOR	3.16%	wait dtl data receive response	2.56%
					1:EXCHANGE OUT DISTR::EX10000	0.24%	ON CPU	0.14%
					2:PX PARTITION ITERATOR	0.04%	ON CPU	0.04%
6B11CBD7D2DDDA4910B0FEA5F9C5F963	2618661474761681335	4453	6.63%	448	0:DELETE	6.49%	tx commiting wait	5.57%	DELETE FROM label_product WHERE product_id=? and label_
					1:TABLE GET:label_product(uniq_productid_labelid)	0.13%	ON CPU	0.13%
FAF443A7C5FFB84C377E0F179798D853	11561260236707163724	3931	5.85%	394	0:DELETE	5.64%	tx commiting wait	5.49%	DELETE FROM info_label_relation WHERE info_id=? and lab
					1:TABLE RANGE SCAN:info_label_relation(unique_index)	0.21%	ON CPU	0.15%
325B3ABB9AD3AAA360CF70373A17FCF7	11013570064090107881	2860	4.26%	664	0:TABLE RANGE SCAN:label_product(uniq_productid_labelid)	4.26%	ON CPU	2.57%	SELECT * FROM label_product WHERE product_id in (?)
7BE9D4B3DF60DC4968FD178C6DD2661A	11561260236707163724	2751	4.09%	915	0:DELETE	3.02%	tx commiting wait	2.86%	DELETE FROM info_label_relation WHERE info_id=? and lab
					1:TABLE RANGE SCAN:info_label_relation(unique_index)	1.07%	db file data read	0.92%
27040E6FA3ED7D059EC4D2BD8FF798DC	2618661474761681335	2629	3.91%	892	0:DELETE	3.66%	tx commiting wait	3.41%	DELETE FROM label_product WHERE product_id=? and label_
					1:TABLE GET:label_product(uniq_productid_labelid)	0.25%	db file data read	0.18%
97178AD500CF38C191139A4BD49538BB	3290318591324336132	2507	3.73%	338	0:DISTRIBUTED INSERT	3.70%	tx commiting wait	2.93%	INSERT INTO info_label_relation (id,info_id, label_id,
					1:EXPRESSION	0.03%	ON CPU	0.03%
F473D8895D6EF4C707F27316AA9C2108	14928774872249983864	1889	2.81%	413	0:TABLE RANGE SCAN:label_user(uniq_uid_labelid)	2.81%	db file data read	1.55%	SELECT * FROM label_user WHERE ?=? and uid in (?)
73690A81DF7ADC3F72F124C9105F168F	2029748640274024157	1112	1.66%	238	0:PX COORDINATOR	0.89%	wait dtl data receive response	0.69%	SELECT * FROM label_product WHERE product_id in (?,?)
					3:TABLE RANGE SCAN:label_product(uniq_productid_labelid)	0.74%	db file data read	0.52%
					1:EXCHANGE OUT DISTR::EX10000	0.02%	ON CPU	0.02%
					2:PX PARTITION ITERATOR	0.00%	ON CPU	0.00%
5F76C602C3B3E12F10C080272B0B3E4B	2029748640274024157	820	1.22%	175	0:PX COORDINATOR	0.67%	wait dtl data receive response	0.55%	SELECT * FROM label_product WHERE product_id in (?,?,?)
					3:TABLE RANGE SCAN:label_product(uniq_productid_labelid)	0.46%	db file data read	0.32%
					1:EXCHANGE OUT DISTR::EX10000	0.07%	wait dtl transmit message response	0.05%
					2:PX PARTITION ITERATOR	0.02%	ON CPU	0.02%
95FBCF0AC71561BC8A700D195FE6A5FA	2029748640274024157	797	1.19%	182	0:PX COORDINATOR	0.64%	wait dtl data receive response	0.47%	SELECT * FROM label_product WHERE product_id in (?,?,?,
					3:TABLE RANGE SCAN:label_product(uniq_productid_labelid)	0.53%	ON CPU	0.28%
					1:EXCHANGE OUT DISTR::EX10000	0.02%	ON CPU	0.02%
					2:PX PARTITION ITERATOR	0.00%	ON CPU	0.00%

Top PL/SQL Procedures

"PL/SQL Entry Subprogram" represents the application's top-level entry-point(procedure, function, trigger, package initialization) into PL/SQL.
"PL/SQL Current Subprogram" is the pl/sql subprogram being executed at the point of sampling. If the value is "SQL", it represents the percentage of time spent executing SQL for the particular plsql entry subprogram.
"PL/SQL Entry Subprogram" represents the application's top-level subprogram name

PLSQL Entry Subprogram	% Activity	PLSQL Current Subprogram	% Current

Complete List of SQL Text And Status

This Section lists the SQL statements and status, but some top sql statements may be eliminated
First Load Time: plan generation time
Plan Cache Hit Rate: Percentage of plan cache hits
AVG RPC: Average number of RPC calls per execution
AVG Partition: Average number of partitions accessed per execution
Route Miss Rate: Percentage of partition routing errors
AVG Disk Reads: Average bytes of disk data read per execution
Muti Query Rate: Percentage of multi-statement queries
Muti Query Batch Rate: Percentage of batch executions
AVG Error: Average number of errors per request
Full Table Scan Rate: Percentage of full table scans
AVG Retry: Average number of retries per execution
Executions: Number of executions
AVG Elapsed Time: Average execution time per execution(nanoseconds)

SQL ID	Plan Hash	First Load Time	SQL Text	Plan Cache Hit Rate	AVG RPC	AVG Partition	Route Miss Rate	AVG Disk Reads	Muti Query Rate	Muti Query Batch Rate	Full Table Scan Rate	Executions	AVG Elapsed Time
D9EB4937E65F94AA38F6B0FE72B06D13	16424802065266473205	2026-07-19 11:12:54	SELECT column_value FROM __all_core_table WHERE TABLE_NAME = ? AND COLUMN_NAME = ?	100.00%	1.00	1.00	100.00%	0.00	0.00%	0.00%	0.00%	4128607	25055230.20
9CA2F8D24467EB1A28CA50EE09743A86	2596677564506151430	2026-07-19 11:12:54	SELECT * FROM __all_acquired_snapshot WHERE tenant_id = ?	100.00%	1.00	1.00	100.00%	0.00	0.00%	0.00%	0.00%	4128749	19777413.07
69E30EFBCF5EDD2CB6A3E5D8BA410B8C	8894128478548303855	2026-07-22 22:00:09	INSERT INTO label_product (id, product_id, label_id, label_value, is_delete, create_time) VALUES (?,?,?,?,?,?) on duplicate key update is_delete=VALUES(is_delete),label_value=VALUES(label_value)	100.00%	1.50	3.00	0.00%	0.03	100.00%	0.00%	0.00%	4374550	6863948.42
8E2E0AA9F00B424D170DE0402491EE32	2029748640274024157	2026-07-23 02:00:06	SELECT * FROM label_product WHERE product_id in (?,?,?,?,?)	100.00%	3.54	9.92	0.00%	0.00	100.00%	0.00%	0.00%	1081631	8980251.22
325B3ABB9AD3AAA360CF70373A17FCF7	11013570064090107881	2026-07-23 10:52:13	SELECT * FROM label_product WHERE product_id in (?)	100.00%	0.00	2.00	0.00%	0.18	100.00%	0.00%	0.00%	5757367	1153750.01
6B11CBD7D2DDDA4910B0FEA5F9C5F963	2618661474761681335	2026-07-22 22:00:10	DELETE FROM label_product WHERE product_id=? and label_id in (?,?,?,?,?)	100.00%	0.99	3.00	0.00%	0.44	100.00%	0.00%	0.00%	1476621	3196791.12
5F76C602C3B3E12F10C080272B0B3E4B	2029748640274024157	2026-07-23 02:00:12	SELECT * FROM label_product WHERE product_id in (?,?,?)	100.00%	3.06	5.98	0.00%	0.00	100.00%	0.00%	0.00%	372495	10941315.87
7BE9D4B3DF60DC4968FD178C6DD2661A	11561260236707163724	2026-07-22 19:37:44	DELETE FROM info_label_relation WHERE info_id=? and label_id in (?)	100.00%	1.03	2.00	0.00%	0.26	100.00%	0.00%	0.00%	3219057	893754.89
97178AD500CF38C191139A4BD49538BB	3290318591324336132	2026-07-22 19:37:44	INSERT INTO info_label_relation (id,info_id, label_id, source_type, source_key, is_show, added_timestamp) VALUES(?,?,?,?,?,?,?)	100.00%	1.04	2.00	0.00%	0.17	100.00%	0.00%	0.00%	3602000	623991.15
95FBCF0AC71561BC8A700D195FE6A5FA	2029748640274024157	2026-07-21 15:00:35	SELECT * FROM label_product WHERE product_id in (?,?,?,?)	100.00%	3.35	7.95	0.00%	0.00	100.00%	0.00%	0.00%	230284	8060483.73
27040E6FA3ED7D059EC4D2BD8FF798DC	2618661474761681335	2026-07-22 22:00:09	DELETE FROM label_product WHERE product_id=? and label_id in (?)	100.00%	1.03	3.00	0.00%	0.07	100.00%	0.00%	0.00%	2834449	648782.39
FAF443A7C5FFB84C377E0F179798D853	11561260236707163724	2026-07-22 19:38:33	DELETE FROM info_label_relation WHERE info_id=? and label_id in (?,?,?,?,?)	100.00%	0.99	2.00	0.00%	0.06	100.00%	0.00%	0.00%	1460080	847436.98
C535FF13485F55FD455B52BF6F4381A5	9505620650660437702	2026-07-23 08:31:17	select * from info_label_relation where info_id =? and label_id in (?) and source_type=? and source_key=?	100.00%	0.00	2.00	0.00%	0.25	100.00%	0.00%	0.00%	1278242	651090.49
F473D8895D6EF4C707F27316AA9C2108	14928774872249983864	2026-07-23 10:04:20	SELECT * FROM label_user WHERE ?=? and uid in (?)	100.00%	0.00	2.00	0.00%	0.02	100.00%	0.00%	0.00%	5921658	106487.15
BF476985C35D830ED51728D978A506DF	8894128478548303855	2026-07-22 22:00:09	INSERT INTO label_product (id, product_id, label_id, label_value, is_delete, create_time) VALUES (?,?,?,?,?,?),(?,?,?,?,?,?),(?,?,?,?,?,?),(?,?,?,?,?,?),(?,?,?,?,?,?) on duplicate key update is_delete=VALUES(is_delete),label_value=VALUES(label_value)	100.18%	1.99	3.01	0.00%	0.07	100.19%	0.00%	0.00%	16223	37472406.01
73690A81DF7ADC3F72F124C9105F168F	2029748640274024157	2026-07-23 10:08:03	SELECT * FROM label_product WHERE product_id in (?,?)	100.00%	2.67	4.00	0.00%	0.00	100.00%	0.00%	0.00%	67364	35945.99
436B7D91382306E4054AE9A99C10A846	4024070737857038369	2026-07-23 10:54:32	select lt.* from label_core lc left join label_type lt on lc.type_id = lt.type_id where lc.label_id = ? and lc.is_delete = ?	99.98%	1.00	2.00	0.00%	0.00	100.00%	0.00%	0.00%	6634	14177.23
794DC67C718DD908C6F8371776EE6795	18228284032386230447	2026-07-23 11:05:17	SELECT sequence_key, sequence_value, sync_value, truncate_version FROM __all_auto_increment WHERE tenant_id = ? AND sequence_key = ? AND column_id = ? FOR UPDATE	100.00%	0.00	1.00	0.00%	0.00	0.00%	0.00%	0.00%	151696	55.65
D9EB4937E65F94AA38F6B0FE72B06D13	12254811659671915614	2026-07-20 02:56:35	SELECT column_value FROM __all_core_table WHERE TABLE_NAME = ? AND COLUMN_NAME = ?	100.00%	0.00	0.25	0.00%	0.00	0.00%	0.00%	0.00%	3907	116.48
51DBC286C2E893B1511A66A6FC6DA119	18231308322961799645	2026-07-23 08:55:58	SELECT * FROM label_user WHERE ?=? and uid in (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)	98.54%	3.76	28.36	0.00%	0.33	100.00%	0.00%	0.00%	137	3071.96
73690A81DF7ADC3F72F124C9105F168F	11013570064090107881	2026-07-23 10:08:12	SELECT * FROM label_product WHERE product_id in (?,?)	99.23%	0.00	2.00	0.00%	1.02	100.00%	0.00%	0.00%	260	1262.72
9CA2F8D24467EB1A28CA50EE09743A86	15402238335871689439	2026-07-20 10:11:10	SELECT * FROM __all_acquired_snapshot WHERE tenant_id = ?	100.00%	0.00	0.25	0.00%	0.00	0.00%	0.00%	0.00%	3907	34.72
5F76C602C3B3E12F10C080272B0B3E4B	11013570064090107881	2026-07-23 03:27:21	SELECT * FROM label_product WHERE product_id in (?,?,?)	66.67%	0.00	2.00	0.00%	1.50	100.00%	0.00%	0.00%	6	1361.33

End of Report