obdiag version: 3.7.1 observer version: 4.4.2.0 ASH Report Cluster Name: myoceanbase Observer Version: OceanBase_CE 4.4.2.0 (100000032026021017-e859d1b9c9a6d11d856f4fed5b6385f1a6795820) Operation System Info: Linux(4.19.90-2409.6.0.0297.101.uel20.x86_64)_x86_64 User Input Begin Time: 2026-05-09 09:00:00 User Input End Time: 2026-05-09 09:30:00 Wr Analysis Begin Time: 2026-05-09 09:00:00 Wr Analysis End Time: 2026-05-09 09:29:59 Wr Data Source: oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY Elapsed Time: 1799 Wr Num of Sample: 136100 Average Active Sessions: 75.65 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| +----------------------------------------------------------------+------------+------------------+-----------------------+-------------------+--------------------+-----------+------------------------+ | mysql1| FOREGROUND| 51358| 49598| 1760| 28.55| 37.73%| 31.71| | sys| BACKGROUND| 35825| 11665| 24160| 19.91| 26.32%| -| | mysql1| BACKGROUND| 24673| 20263| 4410| 13.71| 18.13%| -| | ocp_monitor| BACKGROUND| 9531| 8701| 830| 5.30| 7.00%| -| | ocp_meta| BACKGROUND| 9125| 8615| 510| 5.07| 6.71%| -| | sys| FOREGROUND| 1680| 250| 1430| 0.93| 1.23%| 0.31| | ocp_meta| FOREGROUND| 1553| 1073| 480| 0.86| 1.14%| 1.60| | ocp_monitor| FOREGROUND| 984| 944| 40| 0.55| 0.72%| 1.84| +----------------------------------------------------------------+------------+------------------+-----------------------+-------------------+--------------------+-----------+------------------------+ 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.4.197.23| 2882| FOREGROUND| 36595| 35395| 1200| 20.34| 26.89%| 32.78| | 10.4.197.23| 2882| BACKGROUND| 34634| 20674| 13960| 19.25| 25.45%| -| | 10.4.197.21| 2882| BACKGROUND| 22790| 14610| 8180| 12.67| 16.75%| -| | 10.4.197.22| 2882| BACKGROUND| 21730| 13960| 7770| 12.08| 15.97%| -| | 10.4.197.22| 2882| FOREGROUND| 9560| 8530| 1030| 5.31| 7.02%| 17.07| | 10.4.197.21| 2882| FOREGROUND| 9420| 7940| 1480| 5.24| 6.92%| 15.98| +----------------+-------+------------+------------------+-----------------------+-------------------+--------------------+-----------+------------------------+ 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.4.197.23:2882| cgroup//tenant_1006//OBCG_DEFAULT| 46581| 34.23%| T1006_SQL_CMD| 26.16%| ReqWorker(Level:0)| 26.12%| COM_QUERY| 26.12%| 19.76| | | | | | T1006_LogService| 6.10%| LogIOWorker| 4.31%| aggregate io task| 4.31%| 3.26| | | | | | | | LogRestoreService| 1.24%| RemoteLogWriter| 1.24%| 0.94| | | cgroup//tenant_0001//OBCG_DEFAULT| 17095| 12.56%| IOManager| 8.38%| SyncIO_Device:DeviceType:2/Medi| 8.37%| UNDEFINED| 8.37%| 6.33| | | | | | T1_LogService| 1.46%| LogRestoreService| 1.15%| RemoteLogWriter| 1.15%| 0.87| | | | | | SyslogCompress| 1.32%| SyslogCompress| 1.32%| UNDEFINED| 1.32%| 1.00| | | cgroup//tenant_1004//OBCG_DEFAULT| 3725| 2.74%| T1004_LogService| 1.71%| LogIOWorker| 1.02%| aggregate io task| 1.01%| 0.77| | | cgroup//tenant_1002//OBCG_DEFAULT| 3698| 2.72%| T1002_LogService| 2.23%| LogIOWorker| 1.28%| aggregate io task| 1.28%| 0.97| | 10.4.197.21:2882| cgroup//tenant_1006//OBCG_DEFAULT| 13980| 10.27%| T1006_SQL_CMD| 5.43%| ReqWorker(Level:0)| 5.37%| COM_QUERY| 5.37%| 4.06| | | | | | T1006_LogService| 3.95%| LogIOWorker| 2.27%| aggregate io task| 2.26%| 1.71| | | | | | | | LogRestoreService| 1.21%| RemoteLogWriter| 1.21%| 0.92| | | cgroup//tenant_0001//OBCG_DEFAULT| 10110| 7.43%| IOManager| 3.23%| SyncIO_Device:DeviceType:2/Medi| 3.21%| UNDEFINED| 3.21%| 2.43| | | | | | SyslogCompress| 1.39%| SyslogCompress| 1.39%| UNDEFINED| 1.39%| 1.05| | | | | | T1_LogService| 1.30%| LogRestoreService| 1.24%| RemoteLogWriter| 1.24%| 0.94| | | cgroup//tenant_1002//OBCG_DEFAULT| 4100| 3.01%| T1002_LogService| 1.84%| LogRestoreService| 1.36%| RemoteLogWriter| 1.36%| 1.03| | | cgroup//tenant_1004//OBCG_DEFAULT| 3380| 2.48%| T1004_LogService| 1.62%| LogRestoreService| 1.43%| RemoteLogWriter| 1.43%| 1.08| | 10.4.197.22:2882| cgroup//tenant_1006//OBCG_DEFAULT| 14720| 10.82%| T1006_SQL_CMD| 6.14%| ReqWorker(Level:0)| 6.11%| COM_QUERY| 6.11%| 4.62| | | | | | T1006_LogService| 4.03%| LogIOWorker| 2.23%| aggregate io task| 2.23%| 1.68| | | | | | | | LogRestoreService| 1.28%| RemoteLogWriter| 1.28%| 0.97| | | cgroup//tenant_0001//OBCG_DEFAULT| 10220| 7.51%| IOManager| 3.06%| SyncIO_Device:DeviceType:2/Medi| 3.06%| UNDEFINED| 3.06%| 2.31| | | | | | T1_LogService| 1.37%| LogRestoreService| 1.32%| RemoteLogWriter| 1.32%| 1.00| | | | | | SyslogCompress| 1.31%| SyslogCompress| 1.31%| UNDEFINED| 1.31%| 0.99| | | cgroup//tenant_1004//OBCG_DEFAULT| 3240| 2.38%| T1004_LogService| 1.76%| LogRestoreService| 1.46%| RemoteLogWriter| 1.46%| 1.11| | | cgroup//tenant_1002//OBCG_DEFAULT| 2730| 2.01%| T1002_LogService| 1.66%| LogRestoreService| 1.34%| RemoteLogWriter| 1.34%| 1.01| +----------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------+-------------+-----------+----------------------------------------------------------------+-----------+--------------------------------+-----------+--------------------------------+-----------+--------------------+ +----------------------------+-------------+--------------------------------------------------------------------------------------------------------------------------------+--------------------+-----------+--------------------+ | Slot Begin Time| Slot Count| Action Key| Action Samples| % Activity| Avg Active Sessions| +----------------------------+-------------+--------------------------------------------------------------------------------------------------------------------------------+--------------------+-----------+--------------------+ | 2026-05-09 09:00:00(+0s)| 13870| 10.4.197.23:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 4010| 28.91%| | | | | 10.4.197.23:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-IOManager-SyncIO_Device:DeviceType:2/Medi-UNDEFINED| 1070| 7.71%| | | | | 10.4.197.23:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_LogService-LogIOWorker-aggregate io task| 700| 5.05%| | | | | 10.4.197.22:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 670| 4.83%| | | | | 10.4.197.21:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 540| 3.89%| | | | | 10.4.197.21:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-IOManager-SyncIO_Device:DeviceType:2/Medi-UNDEFINED| 400| 2.88%| | | | | 10.4.197.22:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-IOManager-SyncIO_Device:DeviceType:2/Medi-UNDEFINED| 370| 2.67%| | | | | 10.4.197.23:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogIOWorker-aggregate io task| 350| 2.52%| | | | | 10.4.197.23:2882-cgroup/background/tenant_1004//OBCG_DEFAULT-T1004_LogService-LogIOWorker-aggregate io task| 330| 2.38%| | | | | 10.4.197.21:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_LogService-LogIOWorker-aggregate io task| 280| 2.02%| | | | | 10.4.197.22:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogRestoreService-RemoteLogWriter| 270| 1.95%| | | | | 10.4.197.21:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogRestoreService-RemoteLogWriter| 250| 1.80%| | | | | 10.4.197.22:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 240| 1.73%| | | | | 10.4.197.22:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_LogService-LogRestoreService-RemoteLogWriter| 230| 1.66%| | | | | 10.4.197.21:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_LogService-LogRestoreService-RemoteLogWriter| 200| 1.44%| | | | | 10.4.197.21:2882-cgroup/background/tenant_1004//OBCG_DEFAULT-T1004_LogService-LogRestoreService-RemoteLogWriter| 190| 1.37%| | | | | 10.4.197.21:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 190| 1.37%| | | | | 10.4.197.22:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_LogService-LogIOWorker-aggregate io task| 170| 1.23%| | | | | 10.4.197.23:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 160| 1.15%| | | | | 10.4.197.21:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_LogService-LogRestoreService-RemoteLogWriter| 160| 1.15%| | | | | 10.4.197.23:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_LogService-LogRestoreService-RemoteLogWriter| 160| 1.15%| | | | | 10.4.197.22:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_LogService-LogRestoreService-RemoteLogWriter| 150| 1.08%| | | | | 10.4.197.22:2882-cgroup/background/tenant_1004//OBCG_DEFAULT-T1004_LogService-LogRestoreService-RemoteLogWriter| 140| 1.01%| | | | | 10.4.197.23:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_LogService-LogRestoreService-RemoteLogWriter| 130| 0.94%| | | 2026-05-09 09:03:00(+180s)| 14018| 10.4.197.23:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 3520| 25.11%| 19.56| | | | 10.4.197.23:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-IOManager-SyncIO_Device:DeviceType:2/Medi-UNDEFINED| 1200| 8.56%| 6.67| | | | 10.4.197.22:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 820| 5.85%| 4.56| | | | 10.4.197.21:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 710| 5.07%| 3.94| | | | 10.4.197.23:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_LogService-LogIOWorker-aggregate io task| 620| 4.42%| 3.44| | | | 10.4.197.21:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-IOManager-SyncIO_Device:DeviceType:2/Medi-UNDEFINED| 430| 3.07%| 2.39| | | | 10.4.197.22:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-IOManager-SyncIO_Device:DeviceType:2/Medi-UNDEFINED| 380| 2.71%| 2.11| | | | 10.4.197.22:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_LogService-LogIOWorker-aggregate io task| 290| 2.07%| 1.61| | | | 10.4.197.21:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_LogService-LogIOWorker-aggregate io task| 290| 2.07%| 1.61| | | | 10.4.197.23:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogIOWorker-aggregate io task| 240| 1.71%| 1.33| | | | 10.4.197.22:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_LogService-LogRestoreService-RemoteLogWriter| 230| 1.64%| 1.28| | | | 10.4.197.23:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_LogService-LogRestoreService-RemoteLogWriter| 220| 1.57%| 1.22| | | | 10.4.197.22:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_LogService-LogRestoreService-RemoteLogWriter| 220| 1.57%| 1.22| | | | 10.4.197.22:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogRestoreService-RemoteLogWriter| 200| 1.43%| 1.11| | | | 10.4.197.21:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 200| 1.43%| 1.11| | | | 10.4.197.23:2882-cgroup/background/tenant_1004//OBCG_DEFAULT-T1004_LogService-LogIOWorker-aggregate io task| 200| 1.43%| 1.11| | | | 10.4.197.22:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 190| 1.35%| 1.06| | | | 10.4.197.21:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_LogService-LogRestoreService-RemoteLogWriter| 190| 1.35%| 1.06| | | | 10.4.197.21:2882-cgroup/background/tenant_1004//OBCG_DEFAULT-T1004_LogService-LogRestoreService-RemoteLogWriter| 180| 1.28%| 1.00| | | | 10.4.197.23:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_LogService-LogRestoreService-RemoteLogWriter| 180| 1.28%| 1.00| | | | 10.4.197.21:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogRestoreService-RemoteLogWriter| 170| 1.21%| 0.94| | | | 10.4.197.21:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_LogService-LogRestoreService-RemoteLogWriter| 170| 1.21%| 0.94| | | | 10.4.197.22:2882-cgroup/background/tenant_1004//OBCG_DEFAULT-T1004_LogService-LogRestoreService-RemoteLogWriter| 150| 1.07%| 0.83| | | | 10.4.197.23:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 140| 1.00%| 0.78| | 2026-05-09 09:06:00(+180s)| 13287| 10.4.197.23:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 3570| 26.87%| 19.83| | | | 10.4.197.23:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-IOManager-SyncIO_Device:DeviceType:2/Medi-UNDEFINED| 1080| 8.13%| 6.00| | | | 10.4.197.22:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 840| 6.32%| 4.67| | | | 10.4.197.21:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 780| 5.87%| 4.33| | | | 10.4.197.23:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_LogService-LogIOWorker-aggregate io task| 540| 4.06%| 3.00| | | | 10.4.197.22:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-IOManager-SyncIO_Device:DeviceType:2/Medi-UNDEFINED| 480| 3.61%| 2.67| | | | 10.4.197.21:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-IOManager-SyncIO_Device:DeviceType:2/Medi-UNDEFINED| 430| 3.24%| 2.39| | | | 10.4.197.21:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_LogService-LogIOWorker-aggregate io task| 290| 2.18%| 1.61| | | | 10.4.197.22:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_LogService-LogIOWorker-aggregate io task| 260| 1.96%| 1.44| | | | 10.4.197.21:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 250| 1.88%| 1.39| | | | 10.4.197.21:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogRestoreService-RemoteLogWriter| 250| 1.88%| 1.39| | | | 10.4.197.23:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 240| 1.81%| 1.33| | | | 10.4.197.22:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_LogService-LogRestoreService-RemoteLogWriter| 230| 1.73%| 1.28| | | | 10.4.197.22:2882-cgroup/background/tenant_1004//OBCG_DEFAULT-T1004_LogService-LogRestoreService-RemoteLogWriter| 220| 1.66%| 1.22| | | | 10.4.197.22:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogRestoreService-RemoteLogWriter| 200| 1.50%| 1.11| | | | 10.4.197.23:2882-cgroup/background/tenant_1004//OBCG_DEFAULT-T1004_LogService-LogIOWorker-aggregate io task| 190| 1.43%| 1.06| | | | 10.4.197.22:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 180| 1.35%| 1.00| | | | 10.4.197.23:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_LogService-LogRestoreService-RemoteLogWriter| 170| 1.28%| 0.94| | | | 10.4.197.21:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_LogService-LogRestoreService-RemoteLogWriter| 160| 1.20%| 0.89| | | | 10.4.197.21:2882-cgroup/background/tenant_1004//OBCG_DEFAULT-T1004_LogService-LogRestoreService-RemoteLogWriter| 160| 1.20%| 0.89| | | | 10.4.197.21:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_LogService-LogRestoreService-RemoteLogWriter| 160| 1.20%| 0.89| | | | 10.4.197.22:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_LogService-LogRestoreService-RemoteLogWriter| 140| 1.05%| 0.78| | | | 10.4.197.23:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_LogService-LogRestoreService-RemoteLogWriter| 130| 0.98%| 0.72| | | | 10.4.197.23:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogIOWorker-aggregate io task| 110| 0.83%| 0.61| | 2026-05-09 09:09:00(+180s)| 12985| 10.4.197.23:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 3500| 26.95%| 19.44| | | | 10.4.197.23:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-IOManager-SyncIO_Device:DeviceType:2/Medi-UNDEFINED| 1170| 9.01%| 6.50| | | | 10.4.197.22:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 860| 6.62%| 4.78| | | | 10.4.197.21:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 790| 6.08%| 4.39| | | | 10.4.197.23:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_LogService-LogIOWorker-aggregate io task| 530| 4.08%| 2.94| | | | 10.4.197.21:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-IOManager-SyncIO_Device:DeviceType:2/Medi-UNDEFINED| 470| 3.62%| 2.61| | | | 10.4.197.22:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-IOManager-SyncIO_Device:DeviceType:2/Medi-UNDEFINED| 460| 3.54%| 2.56| | | | 10.4.197.22:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_LogService-LogIOWorker-aggregate io task| 390| 3.00%| 2.17| | | | 10.4.197.21:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_LogService-LogIOWorker-aggregate io task| 270| 2.08%| 1.50| | | | 10.4.197.21:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogRestoreService-RemoteLogWriter| 210| 1.62%| 1.17| | | | 10.4.197.21:2882-cgroup/background/tenant_1004//OBCG_DEFAULT-T1004_LogService-LogRestoreService-RemoteLogWriter| 210| 1.62%| 1.17| | | | 10.4.197.23:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 190| 1.46%| 1.06| | | | 10.4.197.21:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_LogService-LogRestoreService-RemoteLogWriter| 180| 1.39%| 1.00| | | | 10.4.197.22:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 160| 1.23%| 0.89| | | | 10.4.197.23:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_LogService-LogRestoreService-RemoteLogWriter| 160| 1.23%| 0.89| | | | 10.4.197.22:2882-cgroup/background/tenant_1004//OBCG_DEFAULT-T1004_LogService-LogRestoreService-RemoteLogWriter| 150| 1.16%| 0.83| | | | 10.4.197.23:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogIOWorker-aggregate io task| 150| 1.16%| 0.83| | | | 10.4.197.22:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_LogService-LogRestoreService-RemoteLogWriter| 140| 1.08%| 0.78| | | | 10.4.197.21:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 140| 1.08%| 0.78| | | | 10.4.197.21:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_LogService-LogRestoreService-RemoteLogWriter| 130| 1.00%| 0.72| | | | 10.4.197.22:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_LogService-LogRestoreService-RemoteLogWriter| 130| 1.00%| 0.72| | | | 10.4.197.23:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_LogService-LogRestoreService-RemoteLogWriter| 120| 0.92%| 0.67| | | | 10.4.197.22:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogRestoreService-RemoteLogWriter| 110| 0.85%| 0.61| | | | 10.4.197.23:2882-cgroup/background/tenant_1004//OBCG_DEFAULT-T1004_LogService-LogIOWorker-aggregate io task| 60| 0.46%| 0.33| | 2026-05-09 09:12:00(+180s)| 12395| 10.4.197.23:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 3420| 27.59%| 19.00| | | | 10.4.197.23:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-IOManager-SyncIO_Device:DeviceType:2/Medi-UNDEFINED| 990| 7.99%| 5.50| | | | 10.4.197.21:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 860| 6.94%| 4.78| | | | 10.4.197.22:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 800| 6.45%| 4.44| | | | 10.4.197.23:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_LogService-LogIOWorker-aggregate io task| 570| 4.60%| 3.17| | | | 10.4.197.21:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-IOManager-SyncIO_Device:DeviceType:2/Medi-UNDEFINED| 480| 3.87%| 2.67| | | | 10.4.197.22:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-IOManager-SyncIO_Device:DeviceType:2/Medi-UNDEFINED| 360| 2.90%| 2.00| | | | 10.4.197.21:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_LogService-LogIOWorker-aggregate io task| 310| 2.50%| 1.72| | | | 10.4.197.22:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_LogService-LogIOWorker-aggregate io task| 310| 2.50%| 1.72| | | | 10.4.197.21:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogRestoreService-RemoteLogWriter| 240| 1.94%| 1.33| | | | 10.4.197.22:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogRestoreService-RemoteLogWriter| 220| 1.77%| 1.22| | | | 10.4.197.21:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_LogService-LogRestoreService-RemoteLogWriter| 210| 1.69%| 1.17| | | | 10.4.197.22:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_LogService-LogRestoreService-RemoteLogWriter| 200| 1.61%| 1.11| | | | 10.4.197.21:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_LogService-LogRestoreService-RemoteLogWriter| 200| 1.61%| 1.11| | | | 10.4.197.21:2882-cgroup/background/tenant_1004//OBCG_DEFAULT-T1004_LogService-LogRestoreService-RemoteLogWriter| 180| 1.45%| 1.00| | | | 10.4.197.22:2882-cgroup/background/tenant_1004//OBCG_DEFAULT-T1004_LogService-LogRestoreService-RemoteLogWriter| 180| 1.45%| 1.00| | | | 10.4.197.22:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_LogService-LogRestoreService-RemoteLogWriter| 170| 1.37%| 0.94| | | | 10.4.197.23:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_LogService-LogRestoreService-RemoteLogWriter| 170| 1.37%| 0.94| | | | 10.4.197.23:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 170| 1.37%| 0.94| | | | 10.4.197.23:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogIOWorker-aggregate io task| 160| 1.29%| 0.89| | | | 10.4.197.21:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 130| 1.05%| 0.72| | | | 10.4.197.22:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 110| 0.89%| 0.61| | | | 10.4.197.23:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_LogService-LogRestoreService-RemoteLogWriter| 90| 0.73%| 0.50| | 2026-05-09 09:15:00(+180s)| 12694| 10.4.197.23:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 3420| 26.94%| 19.00| | | | 10.4.197.23:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-IOManager-SyncIO_Device:DeviceType:2/Medi-UNDEFINED| 1060| 8.35%| 5.89| | | | 10.4.197.22:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 910| 7.17%| 5.06| | | | 10.4.197.21:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 790| 6.22%| 4.39| | | | 10.4.197.23:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_LogService-LogIOWorker-aggregate io task| 590| 4.65%| 3.28| | | | 10.4.197.22:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-IOManager-SyncIO_Device:DeviceType:2/Medi-UNDEFINED| 450| 3.54%| 2.50| | | | 10.4.197.21:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-IOManager-SyncIO_Device:DeviceType:2/Medi-UNDEFINED| 370| 2.92%| 2.06| | | | 10.4.197.23:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogIOWorker-aggregate io task| 310| 2.44%| 1.72| | | | 10.4.197.22:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_LogService-LogIOWorker-aggregate io task| 290| 2.29%| 1.61| | | | 10.4.197.22:2882-cgroup/background/tenant_1004//OBCG_DEFAULT-T1004_LogService-LogRestoreService-RemoteLogWriter| 280| 2.21%| 1.56| | | | 10.4.197.21:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_LogService-LogIOWorker-aggregate io task| 280| 2.21%| 1.56| | | | 10.4.197.23:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_LogService-LogRestoreService-RemoteLogWriter| 210| 1.65%| 1.17| | | | 10.4.197.21:2882-cgroup/background/tenant_1004//OBCG_DEFAULT-T1004_LogService-LogRestoreService-RemoteLogWriter| 200| 1.58%| 1.11| | | | 10.4.197.22:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 200| 1.58%| 1.11| | | | 10.4.197.23:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 190| 1.50%| 1.06| | | | 10.4.197.21:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 190| 1.50%| 1.06| | | | 10.4.197.21:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_LogService-LogRestoreService-RemoteLogWriter| 170| 1.34%| 0.94| | | | 10.4.197.21:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogRestoreService-RemoteLogWriter| 160| 1.26%| 0.89| | | | 10.4.197.21:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_LogService-LogRestoreService-RemoteLogWriter| 160| 1.26%| 0.89| | | | 10.4.197.22:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_LogService-LogRestoreService-RemoteLogWriter| 160| 1.26%| 0.89| | | | 10.4.197.22:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogRestoreService-RemoteLogWriter| 140| 1.10%| 0.78| | | | 10.4.197.22:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_LogService-LogRestoreService-RemoteLogWriter| 130| 1.02%| 0.72| | | | 10.4.197.23:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_LogService-LogRestoreService-RemoteLogWriter| 80| 0.63%| 0.44| | 2026-05-09 09:18:00(+180s)| 12591| 10.4.197.23:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 3340| 26.53%| 18.56| | | | 10.4.197.23:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-IOManager-SyncIO_Device:DeviceType:2/Medi-UNDEFINED| 1060| 8.42%| 5.89| | | | 10.4.197.22:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 940| 7.47%| 5.22| | | | 10.4.197.21:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 700| 5.56%| 3.89| | | | 10.4.197.23:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_LogService-LogIOWorker-aggregate io task| 590| 4.69%| 3.28| | | | 10.4.197.21:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-IOManager-SyncIO_Device:DeviceType:2/Medi-UNDEFINED| 440| 3.50%| 2.44| | | | 10.4.197.22:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-IOManager-SyncIO_Device:DeviceType:2/Medi-UNDEFINED| 430| 3.42%| 2.39| | | | 10.4.197.21:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_LogService-LogIOWorker-aggregate io task| 380| 3.02%| 2.11| | | | 10.4.197.22:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_LogService-LogIOWorker-aggregate io task| 340| 2.70%| 1.89| | | | 10.4.197.21:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 250| 1.99%| 1.39| | | | 10.4.197.23:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogIOWorker-aggregate io task| 240| 1.91%| 1.33| | | | 10.4.197.22:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogRestoreService-RemoteLogWriter| 210| 1.67%| 1.17| | | | 10.4.197.22:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_LogService-LogRestoreService-RemoteLogWriter| 200| 1.59%| 1.11| | | | 10.4.197.22:2882-cgroup/background/tenant_1004//OBCG_DEFAULT-T1004_LogService-LogRestoreService-RemoteLogWriter| 180| 1.43%| 1.00| | | | 10.4.197.21:2882-cgroup/background/tenant_1004//OBCG_DEFAULT-T1004_LogService-LogRestoreService-RemoteLogWriter| 180| 1.43%| 1.00| | | | 10.4.197.21:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_LogService-LogRestoreService-RemoteLogWriter| 160| 1.27%| 0.89| | | | 10.4.197.23:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_LogService-LogRestoreService-RemoteLogWriter| 150| 1.19%| 0.83| | | | 10.4.197.21:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_LogService-LogRestoreService-RemoteLogWriter| 150| 1.19%| 0.83| | | | 10.4.197.22:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 150| 1.19%| 0.83| | | | 10.4.197.23:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 140| 1.11%| 0.78| | | | 10.4.197.23:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_LogService-LogRestoreService-RemoteLogWriter| 130| 1.03%| 0.72| | | | 10.4.197.22:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_LogService-LogRestoreService-RemoteLogWriter| 130| 1.03%| 0.72| | | | 10.4.197.21:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogRestoreService-RemoteLogWriter| 120| 0.95%| 0.67| | 2026-05-09 09:21:00(+180s)| 13081| 10.4.197.23:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 3450| 26.37%| 19.17| | | | 10.4.197.23:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-IOManager-SyncIO_Device:DeviceType:2/Medi-UNDEFINED| 1200| 9.17%| 6.67| | | | 10.4.197.22:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 810| 6.19%| 4.50| | | | 10.4.197.21:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 740| 5.66%| 4.11| | | | 10.4.197.23:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_LogService-LogIOWorker-aggregate io task| 590| 4.51%| 3.28| | | | 10.4.197.21:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-IOManager-SyncIO_Device:DeviceType:2/Medi-UNDEFINED| 450| 3.44%| 2.50| | | | 10.4.197.22:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_LogService-LogIOWorker-aggregate io task| 360| 2.75%| 2.00| | | | 10.4.197.21:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_LogService-LogIOWorker-aggregate io task| 360| 2.75%| 2.00| | | | 10.4.197.22:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-IOManager-SyncIO_Device:DeviceType:2/Medi-UNDEFINED| 300| 2.29%| 1.67| | | | 10.4.197.22:2882-cgroup/background/tenant_1004//OBCG_DEFAULT-T1004_LogService-LogRestoreService-RemoteLogWriter| 240| 1.83%| 1.33| | | | 10.4.197.22:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_LogService-LogRestoreService-RemoteLogWriter| 200| 1.53%| 1.11| | | | 10.4.197.22:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogRestoreService-RemoteLogWriter| 200| 1.53%| 1.11| | | | 10.4.197.23:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_LogService-LogRestoreService-RemoteLogWriter| 200| 1.53%| 1.11| | | | 10.4.197.23:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogIOWorker-aggregate io task| 180| 1.38%| 1.00| | | | 10.4.197.21:2882-cgroup/background/tenant_1004//OBCG_DEFAULT-T1004_LogService-LogRestoreService-RemoteLogWriter| 180| 1.38%| 1.00| | | | 10.4.197.23:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 170| 1.30%| 0.94| | | | 10.4.197.21:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_LogService-LogRestoreService-RemoteLogWriter| 170| 1.30%| 0.94| | | | 10.4.197.23:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_LogService-LogRestoreService-RemoteLogWriter| 170| 1.30%| 0.94| | | | 10.4.197.21:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 170| 1.30%| 0.94| | | | 10.4.197.21:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogRestoreService-RemoteLogWriter| 150| 1.15%| 0.83| | | | 10.4.197.22:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 150| 1.15%| 0.83| | | | 10.4.197.22:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_LogService-LogRestoreService-RemoteLogWriter| 140| 1.07%| 0.78| | | | 10.4.197.21:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_LogService-LogRestoreService-RemoteLogWriter| 100| 0.76%| 0.56| | 2026-05-09 09:24:00(+180s)| 12852| 10.4.197.23:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 3290| 25.60%| 18.28| | | | 10.4.197.23:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-IOManager-SyncIO_Device:DeviceType:2/Medi-UNDEFINED| 1040| 8.09%| 5.78| | | | 10.4.197.22:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 900| 7.00%| 5.00| | | | 10.4.197.21:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 720| 5.60%| 4.00| | | | 10.4.197.21:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-IOManager-SyncIO_Device:DeviceType:2/Medi-UNDEFINED| 520| 4.05%| 2.89| | | | 10.4.197.22:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-IOManager-SyncIO_Device:DeviceType:2/Medi-UNDEFINED| 460| 3.58%| 2.56| | | | 10.4.197.23:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_LogService-LogIOWorker-aggregate io task| 430| 3.35%| 2.39| | | | 10.4.197.21:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_LogService-LogIOWorker-aggregate io task| 330| 2.57%| 1.83| | | | 10.4.197.22:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_LogService-LogIOWorker-aggregate io task| 310| 2.41%| 1.72| | | | 10.4.197.23:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 270| 2.10%| 1.50| | | | 10.4.197.23:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_LogService-LogRestoreService-RemoteLogWriter| 250| 1.95%| 1.39| | | | 10.4.197.21:2882-cgroup/background/tenant_1004//OBCG_DEFAULT-T1004_LogService-LogRestoreService-RemoteLogWriter| 230| 1.79%| 1.28| | | | 10.4.197.22:2882-cgroup/background/tenant_1004//OBCG_DEFAULT-T1004_LogService-LogRestoreService-RemoteLogWriter| 220| 1.71%| 1.22| | | | 10.4.197.22:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_LogService-LogRestoreService-RemoteLogWriter| 210| 1.63%| 1.17| | | | 10.4.197.22:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 200| 1.56%| 1.11| | | | 10.4.197.23:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_LogService-LogRestoreService-RemoteLogWriter| 190| 1.48%| 1.06| | | | 10.4.197.21:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 190| 1.48%| 1.06| | | | 10.4.197.21:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogRestoreService-RemoteLogWriter| 180| 1.40%| 1.00| | | | 10.4.197.21:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_LogService-LogRestoreService-RemoteLogWriter| 180| 1.40%| 1.00| | | | 10.4.197.22:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogRestoreService-RemoteLogWriter| 160| 1.25%| 0.89| | | | 10.4.197.23:2882-cgroup/background/tenant_1004//OBCG_DEFAULT-T1004_LogService-LogIOWorker-aggregate io task| 160| 1.25%| 0.89| | | | 10.4.197.22:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_LogService-LogRestoreService-RemoteLogWriter| 160| 1.25%| 0.89| | | | 10.4.197.21:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_LogService-LogRestoreService-RemoteLogWriter| 110| 0.86%| 0.61| | 2026-05-09 09:27:00(+0s)| 16946| 10.4.197.23:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 4030| 23.78%| | | | | 10.4.197.23:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-IOManager-SyncIO_Device:DeviceType:2/Medi-UNDEFINED| 1520| 8.97%| | | | | 10.4.197.22:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 760| 4.49%| | | | | 10.4.197.23:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_LogService-LogIOWorker-aggregate io task| 710| 4.19%| | | | | 10.4.197.21:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 680| 4.01%| | | | | 10.4.197.22:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-IOManager-SyncIO_Device:DeviceType:2/Medi-UNDEFINED| 470| 2.77%| | | | | 10.4.197.23:2882-cgroup/background/tenant_1004//OBCG_DEFAULT-T1004_LogService-LogIOWorker-aggregate io task| 440| 2.60%| | | | | 10.4.197.21:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-IOManager-SyncIO_Device:DeviceType:2/Medi-UNDEFINED| 380| 2.24%| | | | | 10.4.197.22:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_LogService-LogIOWorker-aggregate io task| 310| 1.83%| | | | | 10.4.197.21:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_LogService-LogIOWorker-aggregate io task| 290| 1.71%| | | | | 10.4.197.22:2882-cgroup/background/tenant_1004//OBCG_DEFAULT-T1004_LogService-LogRestoreService-RemoteLogWriter| 230| 1.36%| | | | | 10.4.197.21:2882-cgroup/background/tenant_1004//OBCG_DEFAULT-T1004_LogService-LogRestoreService-RemoteLogWriter| 230| 1.36%| | | | | 10.4.197.22:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_LogService-LogRestoreService-RemoteLogWriter| 200| 1.18%| | | | | 10.4.197.22:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 200| 1.18%| | | | | 10.4.197.21:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_LogService-LogRestoreService-RemoteLogWriter| 190| 1.12%| | | | | 10.4.197.21:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_LogService-LogRestoreService-RemoteLogWriter| 190| 1.12%| | | | | 10.4.197.21:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 180| 1.06%| | | | | 10.4.197.23:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_LogService-LogRestoreService-RemoteLogWriter| 180| 1.06%| | | | | 10.4.197.22:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_LogService-LogRestoreService-RemoteLogWriter| 170| 1.00%| | | | | 10.4.197.23:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_LogService-LogRestoreService-RemoteLogWriter| 160| 0.94%| | | | | 10.4.197.23:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 130| 0.77%| | | | | 10.4.197.21:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogRestoreService-RemoteLogWriter| 120| 0.71%| | | | | 10.4.197.22:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogRestoreService-RemoteLogWriter| 110| 0.65%| | | 2026-05-09 09:30:00(+0s)| 10| 10.4.197.22:2882-cgroup/background/tenant_1006//OBCG_DEFAULT-T1006_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 10| 100.00%| | +----------------------------+-------------+--------------------------------------------------------------------------------------------------------------------------------+--------------------+-----------+--------------------+ 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.4.197.23:2882| tx commiting wait| COMMIT| 34680| 19.28| 25.48%| | | ON CPU| NULL| 1200| 0.67| 0.88%| | | sync rpc| NETWORK| 410| 0.23| 0.30%| | | default condition wait| CONCURRENCY| 110| 0.06| 0.08%| | | wait dtl data receive response| NETWORK| 90| 0.05| 0.07%| | | wait in request queue| CONFIGURATION| 65| 0.04| 0.05%| | | sync get gts timestamp wait| NETWORK| 20| 0.01| 0.01%| | | db file data read| USER_IO| 10| 0.01| 0.01%| | | sleep: lock for read need wait for concurrency control| CONCURRENCY| 10| 0.01| 0.01%| | 10.4.197.22:2882| tx commiting wait| COMMIT| 7520| 4.18| 5.53%| | | ON CPU| NULL| 1030| 0.57| 0.76%| | | sync rpc| NETWORK| 400| 0.22| 0.29%| | | default condition wait| CONCURRENCY| 280| 0.16| 0.21%| | | wait dtl data receive response| NETWORK| 210| 0.12| 0.15%| | | exec inner sql wait| OTHER| 70| 0.04| 0.05%| | | wait in request queue| CONFIGURATION| 50| 0.03| 0.04%| | 10.4.197.21:2882| tx commiting wait| COMMIT| 6980| 3.88| 5.13%| | | ON CPU| NULL| 1480| 0.82| 1.09%| | | wait in request queue| CONFIGURATION| 470| 0.26| 0.34%| | | default condition wait| CONCURRENCY| 250| 0.14| 0.18%| | | wait dtl data receive response| NETWORK| 140| 0.08| 0.10%| | | das wait remote response| NETWORK| 40| 0.02| 0.03%| | | mysql response wait client| IDLE| 20| 0.01| 0.01%| | | sync rpc| NETWORK| 20| 0.01| 0.01%| | | sleep: lock for read need wait for concurrency control| CONCURRENCY| 10| 0.01| 0.01%| | | exec inner sql wait| OTHER| 10| 0.01| 0.01%| +----------------------------------------------------------------+----------------------------------------------------------------+--------------------+-------------+--------------------+-----------+ 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.4.197.23:2882| IOManager| SyncIO_Device:DeviceType:2/Medi| UNDEFINED| ON CPU| NULL| 11390| 8.37%| 6.33| | | T1006_LogService| LogIOWorker| aggregate io task| palf write| SYSTEM_IO| 5840| 4.29%| 3.25| | | SyslogCompress| SyslogCompress| UNDEFINED| sleep wait| IDLE| 1800| 1.32%| 1.00| | | T1002_LogService| LogIOWorker| aggregate io task| palf write| SYSTEM_IO| 1740| 1.28%| 0.97| | | T1006_LogService| LogRestoreService| RemoteLogWriter| default condition wait| CONCURRENCY| 1690| 1.24%| 0.94| | | T1_LogService| LogRestoreService| RemoteLogWriter| default condition wait| CONCURRENCY| 1560| 1.15%| 0.87| | | T1004_LogService| LogIOWorker| aggregate io task| palf write| SYSTEM_IO| 1380| 1.01%| 0.77| | | T1002_LogService| LogRestoreService| RemoteLogWriter| default condition wait| CONCURRENCY| 1280| 0.94%| 0.71| | | T1004_LogService| LogRestoreService| RemoteLogWriter| default condition wait| CONCURRENCY| 920| 0.68%| 0.51| | | T1004_TimerWK| TimerWK| UNDEFINED| db file compact read| SYSTEM_IO| 760| 0.56%| 0.42| | | pnio1| pnio1| UNDEFINED| ON CPU| NULL| 560| 0.41%| 0.31| | | T1006_LogService| LogReplayService| TRANS_SERVICE| ON CPU| NULL| 480| 0.35%| 0.27| | 10.4.197.21:2882| IOManager| SyncIO_Device:DeviceType:2/Medi| UNDEFINED| ON CPU| NULL| 4370| 3.21%| 2.43| | | T1006_LogService| LogIOWorker| aggregate io task| palf write| SYSTEM_IO| 3030| 2.23%| 1.68| | | T1004_LogService| LogRestoreService| RemoteLogWriter| default condition wait| CONCURRENCY| 1940| 1.43%| 1.08| | | SyslogCompress| SyslogCompress| UNDEFINED| sleep wait| IDLE| 1890| 1.39%| 1.05| | | T1002_LogService| LogRestoreService| RemoteLogWriter| default condition wait| CONCURRENCY| 1850| 1.36%| 1.03| | | T1_LogService| LogRestoreService| RemoteLogWriter| default condition wait| CONCURRENCY| 1690| 1.24%| 0.94| | | T1006_LogService| LogRestoreService| RemoteLogWriter| default condition wait| CONCURRENCY| 1650| 1.21%| 0.92| | | pnio1| pnio1| UNDEFINED| ON CPU| NULL| 820| 0.60%| 0.46| | | T1002_LogService| LogIOWorker| aggregate io task| palf write| SYSTEM_IO| 630| 0.46%| 0.35| | | T1006_LogService| LogReplayService| TRANS_SERVICE| ON CPU| NULL| 470| 0.34%| 0.26| | 10.4.197.22:2882| IOManager| SyncIO_Device:DeviceType:2/Medi| UNDEFINED| ON CPU| NULL| 4160| 3.06%| 2.31| | | T1006_LogService| LogIOWorker| aggregate io task| palf write| SYSTEM_IO| 2980| 2.19%| 1.66| | | T1004_LogService| LogRestoreService| RemoteLogWriter| default condition wait| CONCURRENCY| 1990| 1.46%| 1.11| | | T1002_LogService| LogRestoreService| RemoteLogWriter| default condition wait| CONCURRENCY| 1820| 1.34%| 1.01| | | T1_LogService| LogRestoreService| RemoteLogWriter| default condition wait| CONCURRENCY| 1800| 1.32%| 1.00| | | SyslogCompress| SyslogCompress| UNDEFINED| sleep wait| IDLE| 1780| 1.31%| 0.99| | | T1006_LogService| LogRestoreService| RemoteLogWriter| default condition wait| CONCURRENCY| 1740| 1.28%| 0.97| | | pnio1| pnio1| UNDEFINED| ON CPU| NULL| 580| 0.43%| 0.32| +----------------------------------------------------------------+-----------------------------------------------------------------+----------------------------------------------------------------+----------------------------------------------------------------+----------------------------------------------------------------+--------------------+-------------+-----------+--------------------+ 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.4.197.23:2882| 1253667956| T1006_SQL_CMD| 0.97%| 0.73| tx commiting wait| COMMIT| 0.95%| 053CDCD4E834A19EAC7EA61B089A1FE7| 3290318591324336132| 0.03%| 4| | 10.4.197.23:2882| 1253629480| T1006_SQL_CMD| 0.97%| 0.73| tx commiting wait| COMMIT| 0.95%| C66B1CFC0A7BB97109861544465D153D| 3290318591324336132| 0.04%| 5| | 10.4.197.23:2882| 1253655804| T1006_SQL_CMD| 0.95%| 0.72| tx commiting wait| COMMIT| 0.94%| 776139C6B0F1F8981CDE50723EFF380F| 3290318591324336132| 0.04%| 5| | 10.4.197.23:2882| 1253698168| T1006_SQL_CMD| 0.93%| 0.70| tx commiting wait| COMMIT| 0.88%| BCB9BC068D5A7BCE781D921677BF5F3C| 3290318591324336132| 0.03%| 4| | 10.4.197.23:2882| 1253661559| T1006_SQL_CMD| 0.90%| 0.68| tx commiting wait| COMMIT| 0.87%| A24296D6C5EAA12160A049F65F4565E4| 3290318591324336132| 0.04%| 5| | 10.4.197.23:2882| 1253696075| T1006_SQL_CMD| 0.89%| 0.67| tx commiting wait| COMMIT| 0.87%| A1A1FED5B162FC000835EEBBAFB66B75| 3290318591324336132| 0.04%| 5| | 10.4.197.23:2882| 1253656648| T1006_SQL_CMD| 0.87%| 0.66| tx commiting wait| COMMIT| 0.87%| 0BB8E4A5D2955B5BE876E62CF5162EC8| 3290318591324336132| 0.03%| 4| | 10.4.197.23:2882| 1253691692| T1006_SQL_CMD| 0.87%| 0.66| tx commiting wait| COMMIT| 0.84%| A62E591137EE5667A009427E3A8C8802| 3290318591324336132| 0.04%| 6| | 10.4.197.23:2882| 1253660449| T1006_SQL_CMD| 0.86%| 0.65| tx commiting wait| COMMIT| 0.84%| 65DA504EBBA55A1A05BFF9248A4D78F4| 3290318591324336132| 0.04%| 6| | 10.4.197.23:2882| 1253610915| T1006_SQL_CMD| 0.86%| 0.65| tx commiting wait| COMMIT| 0.85%| 182F1B051197A24F25E1C613292FFF9C| 3290318591324336132| 0.04%| 5| | 10.4.197.23:2882| 1253666373| T1006_SQL_CMD| 0.86%| 0.65| tx commiting wait| COMMIT| 0.85%| 3EDC5A3C8C97BCAB928A653455C9E4FD| 3290318591324336132| 0.04%| 5| | 10.4.197.23:2882| 1253694384| T1006_SQL_CMD| 0.84%| 0.63| tx commiting wait| COMMIT| 0.80%| 776F6242A9335BA6561C58F51551E58A| 3290318591324336132| 0.03%| 4| | 10.4.197.23:2882| 1253613020| T1006_SQL_CMD| 0.84%| 0.63| tx commiting wait| COMMIT| 0.80%| EA831C51183D03292A2F3973270625F7| 3290318591324336132| 0.04%| 5| | 10.4.197.23:2882| 1253681979| T1006_SQL_CMD| 0.84%| 0.63| tx commiting wait| COMMIT| 0.80%| C66B1CFC0A7BB97109861544465D153D| 3290318591324336132| 0.03%| 4| | 10.4.197.23:2882| 1253683801| T1006_SQL_CMD| 0.84%| 0.63| tx commiting wait| COMMIT| 0.82%| 0BB8E4A5D2955B5BE876E62CF5162EC8| 3290318591324336132| 0.04%| 5| +--------------------------------+--------------------+----------------------------------------------------------------+-----------+--------------------+----------------------------------------------------------------+--------------------+-----------+----------------------------------------+--------------------+-----------+--------------------+ 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.4.197.22:2882| T1006_DAG/COMPACTION/MINI_MERGE| 0|disk_write| 26.10| 1760.59| 19.81| 0| 100.00%| | 10.4.197.23:2882| T1002_DAG/COMPACTION/MINOR_EXECUTE| 0|disk_read| 56.46| 93.25| 11.45| 0| 100.00%| | 10.4.197.21:2882| T1006_DAG/COMPACTION/MINOR_EXECUTE| 0|disk_read| 17.03| 9816.73| 9.53| 0| 100.00%| | 10.4.197.21:2882| T1006_DAG/COMPACTION/MINOR_EXECUTE| 0|disk_write| 5.84| 9497.11| 9.22| 0| 100.00%| | 10.4.197.22:2882| T1006_DAG/COMPACTION/MINOR_EXECUTE| 0|disk_read| 18.56| 13726.99| 7.80| 0| 100.00%| | 10.4.197.22:2882| T1006_DAG/COMPACTION/MINOR_EXECUTE| 0|disk_write| 5.29| 13138.28| 7.47| 0| 100.00%| | 10.4.197.23:2882| T1002_DAG/COMPACTION/MINOR_EXECUTE| 0|disk_write| 6.14| 31.80| 3.90| 0| 100.00%| | 10.4.197.22:2882| T1004_DAG/COMPACTION/MINOR_EXECUTE| 0|disk_write| 20.15| 117.50| 3.76| 0| 100.00%| | 10.4.197.23:2882| T1004_DAG/COMPACTION/TX_TABLE_MERGE| 0|disk_write| 18.91| 9.18| 2.89| 0| 100.00%| | 10.4.197.23:2882| T1006_DAG/COMPACTION/MINOR_EXECUTE| 0|disk_read| 9.05| 1997.81| 2.47| 0| 100.00%| | 10.4.197.21:2882| T1004_DAG/COMPACTION/MINI_MERGE| 0|disk_write| 28.15| 48.44| 2.44| 0| 100.00%| | 10.4.197.21:2882| T1006_LogService/LogIOWorker/| 0|disk_write| 247.99| 24.10| 2.40| 0| 100.00%| | 10.4.197.23:2882| T1004_DAG/COMPACTION/TX_TABLE_MERGE| 0|disk_read| 25.21| 7.24| 2.28| 0| 100.00%| | 10.4.197.23:2882| T1006_DAG/COMPACTION/MINI_MERGE| 0|disk_write| 2.88| 2628.36| 2.21| 0| 100.00%| | 10.4.197.22:2882| T1004_DAG/COMPACTION/MINOR_EXECUTE| 0|disk_read| 36.77| 64.61| 2.07| 0| 100.00%| | 10.4.197.23:2882| T1006_DAG/COMPACTION/MINOR_EXECUTE| 0|disk_write| 1.43| 1644.30| 2.03| 0| 100.00%| | 10.4.197.23:2882| T1004_DAG/COMPACTION/MAJOR_MERGE/MEDIUM_MERGE| 0|disk_read| 1.50| 40.00| 2.00| 0| 100.00%| | 10.4.197.21:2882| T1006_DAG/COMPACTION/MINI_MERGE| 0|disk_write| 1.85| 2849.30| 1.47| 0| 100.00%| | 10.4.197.21:2882| T1006_LogService/LogIOWorker/aggregate io task| 0|disk_write| 128.57| 9830.31| 1.38| 0| 100.00%| | 10.4.197.22:2882| T1006_LogService/LogIOWorker/aggregate io task| 0|disk_write| 110.13| 9539.14| 1.12| 0| 100.00%| | 10.4.197.23:2882| T1006_LogService/LogIOWorker/aggregate io task| 0|disk_write| 40.39| 7498.87| 1.06| 0| 100.00%| | 10.4.197.23:2882| T1004_DAG/COMPACTION/MAJOR_MERGE/MEDIUM_MERGE| 0|disk_write| 1.50| 17.81| 0.89| 0| 100.00%| | 10.4.197.21:2882| T1004_DAG/COMPACTION/MINI_MERGE| 0|disk_read| 54.80| 9.39| 0.47| 0| 100.00%| | 10.4.197.23:2882| T1004_DAG/COMPACTION/MINOR_EXECUTE| 0|disk_write| 1.46| 70.00| 0.34| 0| 100.00%| | 10.4.197.23:2882| T1004_LogService/LogIOWorker/| 0|disk_write| 9.76| 16.25| 0.32| 0| 100.00%| | 10.4.197.23:2882| T1004_DAG/COMPACTION/MINI_MERGE| 0|disk_write| 8.79| 10.98| 0.28| 0| 100.00%| | 10.4.197.23:2882| T1004_DAG/COMPACTION/MINOR_EXECUTE| 0|disk_read| 3.40| 54.70| 0.27| 0| 100.00%| | 10.4.197.21:2882| T1006_OB_SLOG/OB_SLOG/| 0|disk_write| 34.80| 4.38| 0.15| 0| 100.00%| | 10.4.197.22:2882| T1006_DAG/COMPACTION/MINI_MERGE| 0|disk_read| 37.58| 11.94| 0.13| 0| 100.00%| | 10.4.197.22:2882| T1006_OB_SLOG/OB_SLOG/| 0|disk_write| 29.09| 2.46| 0.12| 0| 100.00%| | 10.4.197.21:2882| T1006_DAG/COMPACTION/MINI_MERGE| 0|disk_read| 2.74| 214.63| 0.11| 0| 100.00%| | 10.4.197.22:2882| T1004_LogService/LogIOWorker/aggregate io task| 0|disk_write| 14.23| 688.09| 0.10| 0| 100.00%| | 10.4.197.21:2882| T1004_LogService/LogIOWorker/aggregate io task| 0|disk_write| 12.29| 313.20| 0.08| 0| 100.00%| | 10.4.197.22:2882| T1002_LogService/LogIOWorker/aggregate io task| 0|disk_write| 18.00| 330.66| 0.08| 0| 100.00%| | 10.4.197.23:2882| T1004_DAG/COMPACTION/MINI_MERGE| 0|disk_read| 15.82| 3.08| 0.08| 0| 100.00%| | 10.4.197.23:2882| T1004_LogService/LogIOWorker/aggregate io task| 0|disk_write| 11.19| 297.62| 0.07| 0| 100.00%| | 10.4.197.21:2882| T1002_LogService/LogIOWorker/aggregate io task| 0|disk_write| 15.53| 687.62| 0.07| 0| 100.00%| | 10.4.197.21:2882| T1006_DAG/COMPACTION/TX_TABLE_MERGE| 0|disk_write| 0.04| 342.42| 0.06| 0| 100.00%| | 10.4.197.22:2882| T1_LogService/LogIOWorker/aggregate io task| 0|disk_write| 12.87| 92.42| 0.06| 0| 100.00%| | 10.4.197.21:2882| T1_LogService/LogIOWorker/aggregate io task| 0|disk_write| 12.83| 106.95| 0.06| 0| 100.00%| | 10.4.197.21:2882| T1006_DAG/COMPACTION/TX_TABLE_MERGE| 0|disk_read| 0.05| 305.58| 0.06| 0| 100.00%| | 10.4.197.22:2882| T1004_DAG/COMPACTION/MAJOR_MERGE/MEDIUM_MERGE| 0|disk_read| 0.84| 51.16| 0.05| 0| 100.00%| | 10.4.197.22:2882| T1004_DAG/COMPACTION/MINI_MERGE| 0|disk_read| 0.49| 48.96| 0.05| 0| 100.00%| | 10.4.197.23:2882| T1002_LogService/LogIOWorker/aggregate io task| 0|disk_write| 12.07| 366.99| 0.05| 0| 100.00%| | 10.4.197.23:2882| T1_LogService/LogIOWorker/aggregate io task| 0|disk_write| 10.97| 67.03| 0.05| 0| 100.00%| | 10.4.197.22:2882| T1004_DAG/COMPACTION/MINI_MERGE| 0|disk_write| 0.34| 42.93| 0.05| 0| 100.00%| | 10.4.197.23:2882| T1006_DAG/COMPACTION/TX_TABLE_MERGE| 0|disk_write| 0.05| 110.59| 0.05| 0| 100.00%| | 10.4.197.23:2882| T1004_TimerWK/TimerWK/| 0|disk_read| 84.82| 43.44| 0.04| 0| 100.00%| | 10.4.197.21:2882| T1004_TimerWK/TimerWK/| 0|disk_read| 65.09| 78.42| 0.03| 0| 100.00%| | 10.4.197.21:2882| T1004_OB_SLOG/OB_SLOG/| 0|disk_write| 4.07| 23.98| 0.02| 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: default mutex wait| 10| 0.01%| 0.01| +----------------------------------------------------------------+-------------+-----------+--------------------+ 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.4.197.21:2882| 1| 11004| 0.14| 0.18%| 25| ON CPU| 0.18%| 08282664B36C5230B0D579753DA5D92E| 0.01%| oceanbase.__all_virtual_plan_stat| | | 1002| 200153| 0.06| 0.07%| 10| ON CPU| 0.07%| 420BD8E0D672A432EA226B6D34DB7119| 0.07%| meta_database.distributed_lock| | | | | | | | sleep: lock for read need wait for concurrency control| 0.01%| 420BD8E0D672A432EA226B6D34DB7119| 0.01%| | | | 1| 14993| 0.04| 0.05%| 7| ON CPU| 0.05%| DB67EA4A762E50D9FE5F9E8DB2ACA2A7| 0.05%| oceanbase.__all_virtual_sysstat.__idx_11021_all_virtual_sysstat_i1| | | 1004| 1152921504606857193| 0.03| 0.04%| 6| ON CPU| 0.04%| 0991E2A2C3F824C5DF96AA5BA045AB9F| 0.04%| monitor_database.ob_hist_plan_cache_plan_logic_explain.idx_ob_db_id_sql_id_plan_union_hash(P20260508sp9)| | | 1| 12034| 0.03| 0.04%| 5| ON CPU| 0.04%| 3D0D0A422A31BB32AC90277717D0B7F1| 0.01%| oceanbase.__all_virtual_table_mgr| | | 1004| 1152921504606857548| 0.02| 0.02%| 3| ON CPU| 0.02%| 0991E2A2C3F824C5DF96AA5BA045AB9F| 0.02%| monitor_database.ob_hist_plan_cache_plan_logic_explain.idx_ob_db_id_sql_id_plan_union_hash(P20260509sp9)| | | 1| 12325| 0.02| 0.02%| 3| ON CPU| 0.02%| AE4BC5E3E083DE5CB87BB844592594D8| 0.02%| oceanbase.__all_virtual_query_response_time| | | 1006| 201094| 0.01| 0.01%| 2| ON CPU| 0.01%| FA17B11047AF1C1212B9ECC69342957E| 0.01%| dz_hotdata_mob.dz_hotdata_qr_mobile_61_202507| | | 1004| 206860| 0.01| 0.01%| 2| ON CPU| 0.01%| 9E1C218016EFF1B30A1385613EBE69FC| 0.01%| monitor_database.ob_hist_v2_sql_audit_stat_0(P20260509sp9)| | | 1| 11031| 0.01| 0.01%| 2| ON CPU| 0.01%| 24C1C3B00896BF27EB924FA0ED8F85B2| 0.01%| oceanbase.__all_virtual_sql_audit| | | 1002| 200132| 0.01| 0.01%| 1| ON CPU| 0.01%| FA787A73AE468FFD7302BC4CBD260582| 0.01%| meta_database.compute_idc| | | 1002| 200095| 0.01| 0.01%| 1| ON CPU| 0.01%| 90DA0D8BD98C523A5A80499876B70C83| 0.01%| meta_database.ocp_exporter_address| | | 1002| 1152921504606847143| 0.01| 0.01%| 1| ON CPU| 0.01%| DD632B826C14296A51DAD65B388AF28E| 0.01%| meta_database.compute_host_process.idx_compute_host_process_host_id| | | 1002| 1152921504606847197| 0.01| 0.01%| 1| ON CPU| 0.01%| 330478675757CEEBD2CA5C4C6F6C9451| 0.01%| meta_database.ocp2_alarm_event.uk_alarm_event_alarm_type_target| | | 1| 12554| 0.01| 0.01%| 1| exec inner sql wait| 0.01%| 76FB63299A0DF5D88783E02AF84B6823| 0.01%| oceanbase.__all_virtual_unit_mysql_sys_agent| | | 1| 11013| 0.01| 0.01%| 1| ON CPU| 0.01%| 360E5C5D3B96623585DD03DE2D3C3A07| 0.01%| oceanbase.__all_virtual_session_event| | 10.4.197.23:2882| 1| 11017| 0.11| 0.15%| 20| ON CPU| 0.15%| 1DF15473BF500C0D6F79C1C41FDCE4CC| 0.07%| oceanbase.__all_virtual_system_event| | | 1| 11004| 0.07| 0.10%| 13| ON CPU| 0.10%| 1A03C07391F257A2D5053CB5DDA50D25| 0.01%| oceanbase.__all_virtual_plan_stat| | | 1| 11008| 0.05| 0.07%| 9| ON CPU| 0.07%| D950AAAD6DBD4DD227884EBFAC784569| 0.07%| oceanbase.__all_virtual_kvcache_info| | | 1| 14993| 0.03| 0.04%| 5| ON CPU| 0.04%| 3422DF64D50F313DB8A160E38C396B10| 0.03%| oceanbase.__all_virtual_sysstat.__idx_11021_all_virtual_sysstat_i1| | | 1004| 1152921504606857548| 0.01| 0.01%| 2| ON CPU| 0.01%| 0991E2A2C3F824C5DF96AA5BA045AB9F| 0.01%| monitor_database.ob_hist_plan_cache_plan_logic_explain.idx_ob_db_id_sql_id_plan_union_hash(P20260509sp9)| | | 1006| 201055| 0.01| 0.01%| 0| ON CPU| 0.01%| LogReplayService.TRANS_SERVICE| 0.01%| dz_hotdata_mob.dz_hotdata_qr_mobile_22_202507| | 10.4.197.22:2882| 1| 11004| 0.10| 0.13%| 18| ON CPU| 0.13%| 1A03C07391F257A2D5053CB5DDA50D25| 0.01%| oceanbase.__all_virtual_plan_stat| | | 1| 12034| 0.03| 0.04%| 6| ON CPU| 0.04%| 3D0D0A422A31BB32AC90277717D0B7F1| 0.01%| oceanbase.__all_virtual_table_mgr| | | 1004| 1152921504606857193| 0.02| 0.03%| 4| ON CPU| 0.03%| 0991E2A2C3F824C5DF96AA5BA045AB9F| 0.03%| monitor_database.ob_hist_plan_cache_plan_logic_explain.idx_ob_db_id_sql_id_plan_union_hash(P20260508sp9)| | | 1| 11031| 0.02| 0.03%| 3| ON CPU| 0.03%| 24C1C3B00896BF27EB924FA0ED8F85B2| 0.01%| oceanbase.__all_virtual_sql_audit| | | 1| 12241| 0.02| 0.03%| 4| exec inner sql wait| 0.02%| 817514881A64C8BA54616B15950D6DFA| 0.01%| oceanbase.__all_virtual_tablet_to_ls| | | | | | | | ON CPU| 0.01%| 817514881A64C8BA54616B15950D6DFA| 0.01%| | | | 1| 12240| 0.02| 0.02%| 3| exec inner sql wait| 0.01%| 2DA888017C37449ABECED792B21F929A| 0.01%| oceanbase.__all_virtual_tablet_meta_table| | | | | | | | ON CPU| 0.01%| 2332CD20A8AF3BF7E917C0A0F3355632| 0.01%| | | | 1006| 1152921504606848044| 0.01| 0.01%| 0| ON CPU| 0.01%| LogReplayService.TRANS_SERVICE| 0.01%| dz_hotdata_mob.dz_hotdata_qr_mobile_39_202507.pid_query_index| | | 1006| 1152921504606848060| 0.01| 0.01%| 0| ON CPU| 0.01%| LogReplayService.TRANS_SERVICE| 0.01%| dz_hotdata_mob.dz_hotdata_qr_mobile_55_202507.pid_query_index| +-------------------------+--------------------+--------------------+--------------------+--------------------+--------------------+----------------------------------------------------------------+--------------------+----------------------------------------------------------------+--------------------+--------------------------------------------------------------------------------------------------------------------------------+ 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-05-09 09:00:00(+0s)| 13870| tx commiting wait| COMMIT| 5160| 37.20%| | | | | ON CPU| NULL| 2880| 20.76%| | | | | default condition wait| CONCURRENCY| 2220| 16.01%| | | | | palf write| SYSTEM_IO| 2030| 14.64%| | | | | sleep wait| IDLE| 590| 4.25%| | | 2026-05-09 09:03:00| 14018| tx commiting wait| COMMIT| 4780| 34.10%| 26.56| | | | ON CPU| NULL| 3240| 23.11%| 18.00| | | | default condition wait| CONCURRENCY| 2500| 17.83%| 13.89| | | | palf write| SYSTEM_IO| 1880| 13.41%| 10.44| | | | sleep wait| IDLE| 530| 3.78%| 2.94| | 2026-05-09 09:06:00| 13287| tx commiting wait| COMMIT| 4910| 36.95%| 27.28| | | | ON CPU| NULL| 3340| 25.14%| 18.56| | | | default condition wait| CONCURRENCY| 2200| 16.56%| 12.22| | | | palf write| SYSTEM_IO| 1540| 11.59%| 8.56| | | | sleep wait| IDLE| 670| 5.04%| 3.72| | 2026-05-09 09:09:00| 12985| tx commiting wait| COMMIT| 4850| 37.35%| 26.94| | | | ON CPU| NULL| 3560| 27.42%| 19.78| | | | default condition wait| CONCURRENCY| 1770| 13.63%| 9.83| | | | palf write| SYSTEM_IO| 1680| 12.94%| 9.33| | | | sleep wait| IDLE| 490| 3.77%| 2.72| | 2026-05-09 09:12:00| 12395| tx commiting wait| COMMIT| 4940| 39.85%| 27.44| | | | ON CPU| NULL| 3100| 25.01%| 17.22| | | | default condition wait| CONCURRENCY| 2150| 17.35%| 11.94| | | | palf write| SYSTEM_IO| 1520| 12.26%| 8.44| | | | sleep wait| IDLE| 410| 3.31%| 2.28| | 2026-05-09 09:15:00| 12694| tx commiting wait| COMMIT| 4840| 38.13%| 26.89| | | | ON CPU| NULL| 3180| 25.05%| 17.67| | | | default condition wait| CONCURRENCY| 1960| 15.44%| 10.89| | | | palf write| SYSTEM_IO| 1680| 13.23%| 9.33| | | | sleep wait| IDLE| 580| 4.57%| 3.22| | 2026-05-09 09:18:00| 12591| tx commiting wait| COMMIT| 4790| 38.04%| 26.61| | | | ON CPU| NULL| 3360| 26.69%| 18.67| | | | default condition wait| CONCURRENCY| 1840| 14.61%| 10.22| | | | palf write| SYSTEM_IO| 1700| 13.50%| 9.44| | | | sleep wait| IDLE| 540| 4.29%| 3.00| | 2026-05-09 09:21:00| 13081| tx commiting wait| COMMIT| 4750| 36.31%| 26.39| | | | ON CPU| NULL| 3400| 25.99%| 18.89| | | | default condition wait| CONCURRENCY| 1970| 15.06%| 10.94| | | | palf write| SYSTEM_IO| 1730| 13.22%| 9.61| | | | sleep wait| IDLE| 490| 3.75%| 2.72| | 2026-05-09 09:24:00| 12852| tx commiting wait| COMMIT| 4680| 36.41%| 26.00| | | | ON CPU| NULL| 3420| 26.61%| 19.00| | | | default condition wait| CONCURRENCY| 2170| 16.89%| 12.06| | | | palf write| SYSTEM_IO| 1360| 10.58%| 7.56| | | | sleep wait| IDLE| 670| 5.21%| 3.72| | 2026-05-09 09:27:00(+0s)| 16946| tx commiting wait| COMMIT| 5470| 32.28%| | | | | ON CPU| NULL| 4140| 24.43%| | | | | palf write| SYSTEM_IO| 2110| 12.45%| | | | | default condition wait| CONCURRENCY| 2080| 12.27%| | | | | db file compact read| SYSTEM_IO| 870| 5.13%| | +----------------------------+-------------+----------------------------------------------------------------+--------------------+-------------+-----------+--------------------+ 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| 49810| 36.60%| D8D26AA1A789A8988169B03F5D0414D7| 0.42%| | | IN_SQL_EXECUTION| 5080| 3.73%| 774013183C850744D367DC3F68200D68| 0.32%| | | IN_STORAGE_READ| 1330| 0.98%| 65D3F5BF2B8448B0CFDD69684B19BBEE| 0.10%| | | IN_SEQUENCE_LOAD| 880| 0.65%| 13BCDB66A6A2F237748250FE589AA6AF| 0.02%| | | IN_STORAGE_WRITE| 480| 0.35%| 2DA95C989BCFFA359AB8457911E0F2A3| 0.01%| | | IN_PLAN_CACHE| 250| 0.18%| 09DFD06333B3387E9441B43D2E6AFB47| 0.01%| | | IN_FILTER_ROWS| 60| 0.04%| B314AFB7CA7C3A43ED63ED5EADAF8E9F| 0.01%| | | IN_RPC_ENCODE| 40| 0.03%| 7F5D222952DA1113575CA3A974BA7D4B| 0.01%| | | IN_CHECK_ROW_CONFLICTION| 20| 0.01%| 2EC09DD73012EB01FCE9C05382278C45| 0.01%| | | IN_CHECK_TX_STATUS| 20| 0.01%| 420BD8E0D672A432EA226B6D34DB7119| 0.01%| | | IN_DUPLICATE_CONFLICT_RESOLVE| 10| 0.01%| 4A0A149D1151539180A800AB2141928F| 0.01%| | | IN_REWRITE| 10| 0.01%| 549981E00A3D95F03DD5A9EF6044AA20| 0.01%| | | IN_PARSE| 10| 0.01%| F03FF241B6856741136DF2ACC4F75449| 0.01%| | | IN_RESOLVE| 10| 0.01%| 549981E00A3D95F03DD5A9EF6044AA20| 0.01%| | | IN_DEADLOCK_ROW_REGISTER| 10| 0.01%| C457AEC3D8859973D2840AD450CEAFCB| 0.01%| | BACKGROUND| IN_SQL_EXECUTION| 630| 0.46%| 0991E2A2C3F824C5DF96AA5BA045AB9F| 0.13%| | | IN_PX_EXECUTION| 520| 0.38%| 0991E2A2C3F824C5DF96AA5BA045AB9F| 0.13%| | | IN_STORAGE_READ| 400| 0.29%| 0991E2A2C3F824C5DF96AA5BA045AB9F| 0.12%| | | IN_COMMITTING| 320| 0.23%| 24D486F20861EBD9E0217692DB0E9C61| 0.11%| | | IN_RPC_DECODE| 210| 0.15%| | 0.02%| | | IN_RPC_ENCODE| 80| 0.06%| | 0.06%| | | IN_FILTER_ROWS| 70| 0.05%| 0991E2A2C3F824C5DF96AA5BA045AB9F| 0.02%| | | IN_CONNECTION_MGR| 60| 0.04%| | 0.01%| | | IN_PLSQL_EXECUTION| 20| 0.01%| BE13019306986C2816EDAD7592669E8B| 0.01%| | | IN_DUPLICATE_CONFLICT_RESOLVE| 10| 0.01%| B8D6C23A5B6488FE9E3869401AF8AAC3| 0.01%| | | IN_CHECK_TX_STATUS| 10| 0.01%| 69D4EC82CE11CB6BA481591FD96467E2| 0.01%| | | IN_RESOLVE| 10| 0.01%| 549981E00A3D95F03DD5A9EF6044AA20| 0.01%| | | IN_PLAN_CACHE| 10| 0.01%| C1E2430AB262026E78AEC95046F18601| 0.01%| | | IN_REMOTE_DAS_EXECUTION| 10| 0.01%| 0F8C5BB0E72461A999182DC2F5A83F5F| 0.01%| +------------+----------------------------------------+--------------------+-----------+----------------------------------------+-----------+ 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.4.197.23:2882| T1006_LogService/LogIOWorker/aggregate io task| 0| 5840| 4.29%|palf write| SYSTEM_IO| 4.29%| 1570.53| 4256.86| 0.00| | 10.4.197.21:2882| T1006_LogService/LogIOWorker/aggregate io task| 0| 3030| 2.23%|palf write| SYSTEM_IO| 2.23%| 93.36| 2881.69| 0.00| | 10.4.197.22:2882| T1006_LogService/LogIOWorker/aggregate io task| 0| 2980| 2.19%|palf write| SYSTEM_IO| 2.19%| 22.04| 2911.18| 0.00| | 10.4.197.23:2882| T1002_LogService/LogIOWorker/aggregate io task| 0| 1740| 1.28%|palf write| SYSTEM_IO| 1.28%| 444.53| 1291.38| 0.00| | 10.4.197.23:2882| T1004_LogService/LogIOWorker/aggregate io task| 0| 1380| 1.01%|palf write| SYSTEM_IO| 1.01%| 673.67| 704.86| 0.00| | 10.4.197.23:2882| T1006_DAG/COMPACTION/MINI_MERGE| 0| 860| 0.63%|db file compact read| SYSTEM_IO| 0.32%| 391.55| 0.91| 41.82| | 10.4.197.23:2882| T1006_DAG/COMPACTION/MINOR_EXECUTE| 0| 740| 0.54%|db file data read| USER_IO| 0.29%| 379.62| 1.07| 0.00| | 10.4.197.21:2882| T1002_LogService/LogIOWorker/aggregate io task| 0| 630| 0.46%|palf write| SYSTEM_IO| 0.46%| 119.49| 503.57| 0.00| | 10.4.197.23:2882| T1_LogService/LogIOWorker/aggregate io task| 0| 430| 0.32%|palf write| SYSTEM_IO| 0.32%| 264.39| 165.17| 0.00| | 10.4.197.22:2882| T1002_LogService/LogIOWorker/aggregate io task| 0| 410| 0.30%|palf write| SYSTEM_IO| 0.30%| 1.97| 403.99| 0.00| | 10.4.197.22:2882| T1004_LogService/LogIOWorker/aggregate io task| 0| 400| 0.29%|palf write| SYSTEM_IO| 0.29%| 2.03| 363.78| 0.00| | 10.4.197.21:2882| T1004_LogService/LogIOWorker/aggregate io task| 0| 250| 0.18%|palf write| SYSTEM_IO| 0.18%| 1.85| 243.84| 0.00| | 10.4.197.21:2882| T1_LogService/LogIOWorker/aggregate io task| 0| 80| 0.06%|palf write| SYSTEM_IO| 0.06%| 0.80| 77.64| 0.00| | 10.4.197.21:2882| T1006_DAG/COMPACTION/MINOR_EXECUTE| 0| 80| 0.06%|db file compact write| SYSTEM_IO| 0.03%| 0.33| 31.16| 0.00| | 10.4.197.22:2882| T1006_DAG/COMPACTION/MINOR_EXECUTE| 0| 80| 0.06%|db file compact read| SYSTEM_IO| 0.03%| 0.16| 32.72| 0.00| | 10.4.197.22:2882| T1_LogService/LogIOWorker/aggregate io task| 0| 60| 0.04%|palf write| SYSTEM_IO| 0.04%| 0.63| 56.67| 0.00| | 10.4.197.23:2882| T1006_IOManager/DiskCB/ObStorageMetaIOCallback| 0| 50| 0.04%|db file data read| USER_IO| 0.04%| 47.95| 0.07| 0.00| | 10.4.197.23:2882| T1004_DAG/COMPACTION/MINOR_EXECUTE| 0| 40| 0.03%|db file data read| USER_IO| 0.01%| 12.40| 0.58| 0.00| | 10.4.197.22:2882| T1006_DAG/COMPACTION/MINI_MERGE| 0| 30| 0.02%|db file compact write| SYSTEM_IO| 0.01%| 0.15| 19.83| 0.00| | 10.4.197.23:2882| T1004_DAG/COMPACTION/MINI_MERGE| 0| 30| 0.02%|db file compact write| SYSTEM_IO| 0.02%| 14.10| 1.98| 0.00| | 10.4.197.22:2882| 0F8C5BB0E72461A999182DC2F5A83F5F| 8894128478548303855| 10| 0.01%|db file data read| USER_IO| 0.01%| 0.39| 8.43| 0.72| +---------------------+------------------------------------------------------------------------------------------------+--------------------+--------------------+--------------------+----------+--------------------+----------+--------------------+--------------------+--------------------+ 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| 77779| 57.15%| 51| 10.4.197.23:2882| 25.32%| 10.18%| 15.14%| | | | | | 10.4.197.21:2882| 16.33%| 5.75%| 10.58%| | | | | | 10.4.197.22:2882| 15.50%| 5.39%| 10.11%| | T_INSERT| 51270| 37.67%| 3550| 10.4.197.23:2882| 26.10%| 0.35%| 25.75%| | | | | | 10.4.197.22:2882| 6.18%| 0.40%| 5.78%| | | | | | 10.4.197.21:2882| 5.39%| 0.40%| 4.99%| | T_SELECT| 3530| 2.59%| 136| 10.4.197.21:2882| 1.06%| 0.65%| 0.41%| | | | | | 10.4.197.22:2882| 0.83%| 0.53%| 0.30%| | | | | | 10.4.197.23:2882| 0.70%| 0.54%| 0.15%| | T_END_TRANS| 840| 0.62%| 43| 10.4.197.21:2882| 0.32%| 0.07%| 0.24%| | | | | | 10.4.197.22:2882| 0.21%| 0.05%| 0.15%| | T_REPLACE| 690| 0.51%| 22| 10.4.197.21:2882| 0.23%| 0.02%| 0.21%| | | | | | 10.4.197.22:2882| 0.18%| 0.01%| 0.16%| | T_VARIABLE_SET| 220| 0.16%| 16| 10.4.197.21:2882| 0.12%| 0.09%| 0.03%| | T_UPDATE| 190| 0.14%| 0| 10.4.197.21:2882| 0.10%| 0.02%| 0.08%| +---------------------------------------------+---------------------+---------------------+---------------------+----------------------------------------------------------------+---------------------+---------------------+---------------------+ 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| +----------------------------------------+--------------------+--------------------+--------------+--------------------+----------------------------------------------------------------+--------------+--------------------------------------------------------------------------------------------------------------------------------+------------------------+----------------------------------------------------------------+ +----------------------------------------+--------------------+--------------------+--------------+--------------------+----------------------------------------------------------------+--------------+--------------------------------------------------------------------------------------------------------------------------------+------------------------+----------------------------------------------------------------+ 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| +----------------------------------------+--------------------+--------------+--------------+--------------------+--------------------------------------------------------------------------------------------------------------------------------+--------------+----------------------------------------------------------------+--------------+----------------------------------------------------------------+ +----------------------------------------+--------------------+--------------+--------------+--------------------+--------------------------------------------------------------------------------------------------------------------------------+--------------+----------------------------------------------------------------+--------------+----------------------------------------------------------------+ 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:24D486F20861EBD9E0217692DB0E9C61 Plan Hash:10435171333981900908 First Load Time:2026-04-28 15:47:33 SQL Text:update __all_weak_read_service set min_version=?, max_version=? where tenant_id = ? and level_id = ? and level_value = ? and min_version = ? and max_version = ? Plan Cache Hit Rate:99.97% AVG RPC:0.00 AVG Partition:1.00 Route Miss Rate:0.00% AVG Disk Reads:0.00 Muti Query Rate:0.00% Muti Query Batch Rate:0.00% AVG Error:0.00 Full Table Scan Rate:0.00% AVG Retry:0.00 Executions:28204192 AVG Elapsed Time:611.62 SQL ID:69D4EC82CE11CB6BA481591FD96467E2 Plan Hash:328255627683374751 First Load Time:2026-04-28 15:49:06 SQL Text: Plan Cache Hit Rate:99.54% AVG RPC:0.00 AVG Partition:0.33 Route Miss Rate:0.00% AVG Disk Reads:0.00 Muti Query Rate:0.00% Muti Query Batch Rate:0.00% AVG Error:0.00 Full Table Scan Rate:100.00% AVG Retry:0.00 Executions:2568264 AVG Elapsed Time:271.32 SQL ID:0991E2A2C3F824C5DF96AA5BA045AB9F Plan Hash:17443109189639010620 First Load Time:2026-04-28 15:56:12 SQL Text: Plan Cache Hit Rate:100.00% AVG RPC:0.82 AVG Partition:2.00 Route Miss Rate:0.00% AVG Disk Reads:0.07 Muti Query Rate:100.00% Muti Query Batch Rate:0.00% AVG Error:0.00 Full Table Scan Rate:0.00% AVG Retry:0.00 Executions:796 AVG Elapsed Time:196991.31 SQL ID:774013183C850744D367DC3F68200D68 Plan Hash:9223643895202507952 First Load Time:2026-04-28 15:57:14 SQL Text:REPLACE INTO `metric_data_second` (`series_id`, `timestamp`, `data`, `interval`) VALUES (?, ?, _binary ?, ?); Plan Cache Hit Rate:100.00% AVG RPC:1.80 AVG Partition:1.00 Route Miss Rate:0.00% AVG Disk Reads:0.00 Muti Query Rate:100.00% Muti Query Batch Rate:0.00% AVG Error:0.00 Full Table Scan Rate:0.00% AVG Retry:0.00 Executions:8459 AVG Elapsed Time:15196.42 SQL ID:4A0A149D1151539180A800AB2141928F Plan Hash:9223643895202507952 First Load Time:2026-04-28 15:58:11 SQL Text: Plan Cache Hit Rate:100.00% AVG RPC:1.91 AVG Partition:1.00 Route Miss Rate:0.00% AVG Disk Reads:0.00 Muti Query Rate:100.00% Muti Query Batch Rate:0.00% AVG Error:0.00 Full Table Scan Rate:0.00% AVG Retry:0.00 Executions:3651 AVG Elapsed Time:16175.27 SQL ID:65D3F5BF2B8448B0CFDD69684B19BBEE Plan Hash:9559875791366745569 First Load Time:2026-04-28 15:49:59 SQL Text: Plan Cache Hit Rate:100.00% AVG RPC:0.00 AVG Partition:1.00 Route Miss Rate:0.00% AVG Disk Reads:0.00 Muti Query Rate:100.00% Muti Query Batch Rate:0.00% AVG Error:0.00 Full Table Scan Rate:100.00% AVG Retry:0.00 Executions:399 AVG Elapsed Time:129922.89 SQL ID:B314AFB7CA7C3A43ED63ED5EADAF8E9F Plan Hash:13334539821956189746 First Load Time:2026-04-28 15:56:10 SQL Text: Plan Cache Hit Rate:100.00% AVG RPC:0.00 AVG Partition:1.00 Route Miss Rate:0.00% AVG Disk Reads:0.00 Muti Query Rate:100.00% Muti Query Batch Rate:0.00% AVG Error:0.00 Full Table Scan Rate:100.00% AVG Retry:0.00 Executions:299 AVG Elapsed Time:62737.47 SQL ID:7F5D222952DA1113575CA3A974BA7D4B Plan Hash:16548555668458898005 First Load Time:2026-05-09 08:12:28 SQL Text:select hpe1_0.`id`,hpe1_0.`command_args`,hpe1_0.`create_time`,hpe1_0.`host_id`,h1_0.`id`,a1_0.`id`,a1_0.`create_time`,a1_0.`host_id`,a1_0.`install_home`,a1_0.`last_available_time`,a1_0.`last_install_time`,a1_0.`log_home`,a1_0.`manager_port`,a1_0.`monitor_port`,a1_0.`software_package_id`,a1_0.`status`,a1_0.`update_time`,a1_0.`version`,h1_0.`alias`,h1_0.`architecture`,h1_0.`create_time`,h1_0.`description`,h1_0.`hardware_config`,h1_0.`host_type_id`,ht1_0.`id`,ht1_0.`create_time`,ht1_0.`description`,ht1_0.`name`,ht1_0.`update_time`,h1_0.`idc_id`,i1_0.`id`,i1_0.`create_time`,i1_0.`description`,i1_0.`name`,i1_0.`region_id`,i1_0.`update_time`,h1_0.`inner_ip_address`,h1_0.`io_performance`,h1_0.`kind`,h1_0.`name`,h1_0.`operating_system`,h1_0.`publish_ports`,h1_0.`serial_number`,h1_0.`ssh_port`,h1_0.`status`,h1_0.`update_time`,v1_0.`id`,v1_0.`config_server_url`,v1_0.`create_time`,v1_0.`description`,v1_0.`monitordb_address`,v1_0.`monitordb_port`,v1_0.`name`,v1_0.`ocp_url`,v1_0.`update_time`,s1_0.`host_id`,s1_0.`id`,s1_ Plan Cache Hit Rate:100.00% AVG RPC:2.00 AVG Partition:2.25 Route Miss Rate:0.00% AVG Disk Reads:0.00 Muti Query Rate:100.00% Muti Query Batch Rate:0.00% AVG Error:0.00 Full Table Scan Rate:25.00% AVG Retry:0.00 Executions:4212 AVG Elapsed Time:3217.99 SQL ID:549981E00A3D95F03DD5A9EF6044AA20 Plan Hash:1425725760721880712 First Load Time:2026-04-28 15:49:13 SQL Text: Plan Cache Hit Rate:0.00% AVG RPC:1.00 AVG Partition:1.00 Route Miss Rate:100.00% AVG Disk Reads:0.00 Muti Query Rate:100.00% Muti Query Batch Rate:0.00% AVG Error:0.00 Full Table Scan Rate:0.00% AVG Retry:0.00 Executions:944 AVG Elapsed Time:9963.54 SQL ID:420BD8E0D672A432EA226B6D34DB7119 Plan Hash:14700968893400814929 First Load Time:2026-04-28 15:54:52 SQL Text: Plan Cache Hit Rate:99.98% AVG RPC:0.00 AVG Partition:1.00 Route Miss Rate:0.00% AVG Disk Reads:0.00 Muti Query Rate:100.01% Muti Query Batch Rate:0.00% AVG Error:0.00 Full Table Scan Rate:100.01% AVG Retry:0.00 Executions:9847 AVG Elapsed Time:837.75 SQL ID:B8D6C23A5B6488FE9E3869401AF8AAC3 Plan Hash:8894128478548303855 First Load Time:2026-04-28 15:48:09 SQL Text:INSERT INTO __all_space_usage (tenant_id, svr_ip, svr_port, start_seq, file_type, data_size, used_size) VALUES (?, ?, ?, ?, ?, ?, ?) ON DUPLICATE KEY UPDATE data_size = ?, used_size = ? Plan Cache Hit Rate:99.82% AVG RPC:3.43 AVG Partition:1.00 Route Miss Rate:0.00% AVG Disk Reads:0.00 Muti Query Rate:0.00% Muti Query Batch Rate:0.00% AVG Error:0.00 Full Table Scan Rate:0.00% AVG Retry:0.00 Executions:1652 AVG Elapsed Time:3045.04 SQL ID:549981E00A3D95F03DD5A9EF6044AA20 Plan Hash:3966528588401756211 First Load Time:2026-04-30 17:41:38 SQL Text: Plan Cache Hit Rate:0.00% AVG RPC:0.00 AVG Partition:0.11 Route Miss Rate:0.00% AVG Disk Reads:0.00 Muti Query Rate:100.00% Muti Query Batch Rate:0.00% AVG Error:0.00 Full Table Scan Rate:0.00% AVG Retry:0.00 Executions:1056 AVG Elapsed Time:4333.35 SQL ID:69D4EC82CE11CB6BA481591FD96467E2 Plan Hash:9768484004270476077 First Load Time:2026-04-28 15:47:09 SQL Text:SELECT value from oceanbase.__all_sys_stat where name = ? Plan Cache Hit Rate:99.96% AVG RPC:1.33 AVG Partition:1.00 Route Miss Rate:100.04% AVG Disk Reads:0.00 Muti Query Rate:0.00% Muti Query Batch Rate:0.00% AVG Error:0.00 Full Table Scan Rate:100.04% AVG Retry:0.00 Executions:2339 AVG Elapsed Time:1763.75 SQL ID:C1E2430AB262026E78AEC95046F18601 Plan Hash:9636370553839645566 First Load Time:2026-04-28 15:47:03 SQL Text:SELECT primary_zone FROM __all_tenant where tenant_id = ? Plan Cache Hit Rate:100.00% AVG RPC:1.00 AVG Partition:1.00 Route Miss Rate:100.00% AVG Disk Reads:0.00 Muti Query Rate:0.00% Muti Query Batch Rate:0.00% AVG Error:0.00 Full Table Scan Rate:0.00% AVG Retry:0.00 Executions:1571 AVG Elapsed Time:1182.40 SQL ID:C1E2430AB262026E78AEC95046F18601 Plan Hash:14853178661168737544 First Load Time:2026-04-28 15:46:11 SQL Text:SELECT primary_zone FROM __all_tenant where tenant_id = ? Plan Cache Hit Rate:100.00% AVG RPC:0.00 AVG Partition:0.33 Route Miss Rate:0.00% AVG Disk Reads:0.00 Muti Query Rate:0.00% Muti Query Batch Rate:0.00% AVG Error:0.00 Full Table Scan Rate:0.00% AVG Retry:0.00 Executions:2355 AVG Elapsed Time:117.06