obdiag version: 3.7.2 observer version: 4.2.5.5 ASH Report Cluster Name: eo_classroom Observer Version: OceanBase_CE 4.2.5.5 (105000032025071717-5a7fbc0449701109376a16260785c61c36989d8e) Operation System Info: Linux(4.14.141-2.el7.x86_64)_x86_64 User Input Begin Time: 2025-12-23 14:17:00 User Input End Time: 2025-12-23 14:21:00 Ash Analysis Begin Time: 2025-12-23 14:17:00 Ash Analysis End Time: 2025-12-23 14:20:59 Ash Data Source: oceanbase.GV$ACTIVE_SESSION_HISTORY Elapsed Time: 238 Ash Num of Sample: 5179 Average Active Sessions: 21.76 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| +----------------------------------------------------------------+------------+------------------+-----------------------+-------------------+--------------------+-----------+------------------------+ | classroom| BACKGROUND| 2465| 469| 1996| 10.36| 47.60%| -| | sys| BACKGROUND| 1456| 768| 688| 6.12| 28.11%| -| | classroom| FOREGROUND| 990| 215| 775| 4.16| 19.12%| 48.59| | sys| FOREGROUND| 158| 16| 142| 0.66| 3.05%| 3.92| | META$1002| BACKGROUND| 110| 28| 82| 0.46| 2.12%| -| +----------------------------------------------------------------+------------+------------------+-----------------------+-------------------+--------------------+-----------+------------------------+ 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.1.43.111| 2882| BACKGROUND| 1454| 401| 1053| 6.11| 28.07%| -| | 10.1.43.112| 2882| BACKGROUND| 1323| 440| 883| 5.56| 25.55%| -| | 10.1.43.113| 2882| BACKGROUND| 1254| 424| 830| 5.27| 24.21%| -| | 10.1.43.113| 2882| FOREGROUND| 403| 96| 307| 1.69| 7.78%| 31.30| | 10.1.43.112| 2882| FOREGROUND| 397| 68| 329| 1.67| 7.67%| 18.86| | 10.1.43.111| 2882| FOREGROUND| 348| 67| 281| 1.46| 6.72%| 22.30| +----------------+-------+------------+------------------+-----------------------+-------------------+--------------------+-----------+------------------------+ 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.1.43.111:2882| cgroup//tenant_1002//OBCG_DEFAULT| 902| 17.42%| T1002_DAG| 9.29%| COMPACTION| 9.29%| MAJOR_MERGE/MEDIUM_MERGE| 9.29%| 2.02| | | | | | T1002_SQL_CMD| 4.31%| ReqWorker(Level:0)| 3.01%| COM_STMT_EXECUTE| 3.01%| 0.66| | | | | | | | UNDEFINED| 1.29%| UNDEFINED| 1.29%| 0.28| | | | | | T1002_MysqlQueueTh| 1.35%| MysqlQueueTh| 1.35%| UNDEFINED| 1.35%| 0.29| | | | | | T1002_RPC_REQUEST| 1.25%| ReqWorker(Level:0)| 1.25%| FastDFO| 1.25%| 0.27| | | | | | T1002_LogService| 1.22%| LogArchiveService| 1.22%| ArchiveSender| 1.22%| 0.27| | | cgroup//tenant_0001//OBCG_DEFAULT| 337| 6.51%| SyslogCompress| 4.46%| SyslogCompress| 4.46%| UNDEFINED| 4.46%| 0.97| | | | | | T1_SQL_CMD| 1.06%| ReqWorker(Level:0)| 1.06%| COM_QUERY| 1.06%| 0.23| | | | | | DynamicThreadPool| 0.98%| DynamicMgrCheck| 0.98%| detect task| 0.98%| 0.21| | 10.1.43.112:2882| cgroup//tenant_1002//OBCG_DEFAULT| 933| 18.02%| T1002_DAG| 8.96%| COMPACTION| 8.96%| MAJOR_MERGE/MEDIUM_MERGE| 8.96%| 1.95| | | | | | T1002_SQL_CMD| 4.94%| ReqWorker(Level:0)| 2.70%| COM_STMT_EXECUTE| 2.70%| 0.59| | | | | | | | UNDEFINED| 2.24%| UNDEFINED| 2.24%| 0.49| | | | | | T1002_MysqlQueueTh| 2.92%| MysqlQueueTh| 2.92%| UNDEFINED| 2.92%| 0.63| | | | | | T1002_RPC_REQUEST| 1.20%| ReqWorker(Level:0)| 1.20%| FastDFO| 1.20%| 0.26| | | cgroup//tenant_0001//OBCG_DEFAULT| 291| 5.62%| SyslogCompress| 4.44%| SyslogCompress| 4.44%| UNDEFINED| 4.44%| 0.97| | | | | | T1_SQL_CMD| 1.18%| ReqWorker(Level:0)| 1.18%| COM_QUERY| 1.18%| 0.26| | 10.1.43.113:2882| cgroup//tenant_1002//OBCG_DEFAULT| 912| 17.61%| T1002_DAG| 8.84%| COMPACTION| 8.84%| MAJOR_MERGE/MEDIUM_MERGE| 8.84%| 1.92| | | | | | T1002_SQL_CMD| 5.04%| ReqWorker(Level:0)| 3.53%| COM_STMT_EXECUTE| 3.53%| 0.77| | | | | | | | UNDEFINED| 1.51%| UNDEFINED| 1.51%| 0.33| | | | | | T1002_LogService| 1.47%| LogArchiveService| 1.47%| ArchiveSender| 1.47%| 0.32| | | | | | T1002_MysqlQueueTh| 1.20%| MysqlQueueTh| 1.20%| UNDEFINED| 1.20%| 0.26| | | | | | T1002_RPC_REQUEST| 1.06%| ReqWorker(Level:0)| 1.06%| FastDFO| 1.06%| 0.23| | | cgroup//tenant_0001//OBCG_DEFAULT| 230| 4.44%| SyslogCompress| 4.44%| SyslogCompress| 4.44%| UNDEFINED| 4.44%| 0.97| +----------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------+-------------+-----------+----------------------------------------------------------------+-----------+--------------------------------+-----------+--------------------------------+-----------+--------------------+ +----------------------------+-------------+--------------------------------------------------------------------------------------------------------------------------------+--------------------+-----------+--------------------+ | Slot Begin Time| Slot Count| Action Key| Action Samples| % Activity| Avg Active Sessions| +----------------------------+-------------+--------------------------------------------------------------------------------------------------------------------------------+--------------------+-----------+--------------------+ | 2025-12-23 14:17:00(+13s)| 474| 10.1.43.113:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE| 71| 14.98%| 5.46| | | | 10.1.43.111:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE| 71| 14.98%| 5.46| | | | 10.1.43.112:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE| 70| 14.77%| 5.38| | | | 10.1.43.112:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_MysqlQueueTh-MysqlQueueTh-UNDEFINED| 17| 3.59%| 1.31| | | | 10.1.43.111:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogArchiveService-ArchiveSender| 14| 2.95%| 1.08| | | | 10.1.43.111:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 12| 2.53%| 0.92| | | | 10.1.43.113:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 12| 2.53%| 0.92| | | | 10.1.43.112:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 12| 2.53%| 0.92| | | | 10.1.43.112:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-UNDEFINED-UNDEFINED| 11| 2.32%| 0.85| | | | 10.1.43.111:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_STMT_EXECUTE| 10| 2.11%| 0.77| | | | 10.1.43.113:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-UNDEFINED-UNDEFINED| 10| 2.11%| 0.77| | | | 10.1.43.111:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-UNDEFINED-UNDEFINED| 8| 1.69%| 0.61| | | | 10.1.43.113:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_MysqlQueueTh-MysqlQueueTh-UNDEFINED| 8| 1.69%| 0.61| | | | 10.1.43.112:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_STMT_EXECUTE| 7| 1.48%| 0.54| | | | 10.1.43.113:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_STMT_EXECUTE| 7| 1.48%| 0.54| | | | 10.1.43.112:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 6| 1.27%| 0.46| | | | 10.1.43.111:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_MysqlQueueTh-MysqlQueueTh-UNDEFINED| 6| 1.27%| 0.46| | | | 10.1.43.113:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-FastDFO| 6| 1.27%| 0.46| | | | 10.1.43.112:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-FastDFO| 5| 1.05%| 0.39| | | | 10.1.43.111:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-DynamicThreadPool-DynamicMgrCheck-detect task| 3| 0.63%| 0.23| | | | 10.1.43.111:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 2| 0.42%| 0.15| | | | 10.1.43.111:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-FastDFO| 1| 0.21%| 0.08| | 2025-12-23 14:17:13(+23s)| 607| 10.1.43.112:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE| 138| 22.73%| 6.00| | | | 10.1.43.111:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE| 137| 22.57%| 5.96| | | | 10.1.43.111:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 23| 3.79%| 1.00| | | | 10.1.43.112:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 23| 3.79%| 1.00| | | | 10.1.43.113:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 22| 3.62%| 0.96| | | | 10.1.43.113:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_STMT_EXECUTE| 22| 3.62%| 0.96| | | | 10.1.43.112:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_STMT_EXECUTE| 19| 3.13%| 0.83| | | | 10.1.43.113:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE| 16| 2.64%| 0.70| | | | 10.1.43.111:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_STMT_EXECUTE| 14| 2.31%| 0.61| | | | 10.1.43.112:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-FastDFO| 11| 1.81%| 0.48| | | | 10.1.43.112:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 11| 1.81%| 0.48| | | | 10.1.43.111:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-FastDFO| 5| 0.82%| 0.22| | | | 10.1.43.111:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_MysqlQueueTh-MysqlQueueTh-UNDEFINED| 5| 0.82%| 0.22| | | | 10.1.43.113:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-UNDEFINED-UNDEFINED| 5| 0.82%| 0.22| | | | 10.1.43.113:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-FastDFO| 5| 0.82%| 0.22| | | | 10.1.43.112:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-UNDEFINED-UNDEFINED| 5| 0.82%| 0.22| | | | 10.1.43.111:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-DynamicThreadPool-DynamicMgrCheck-detect task| 4| 0.66%| 0.17| | | | 10.1.43.111:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 4| 0.66%| 0.17| | | | 10.1.43.112:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_MysqlQueueTh-MysqlQueueTh-UNDEFINED| 2| 0.33%| 0.09| | | | 10.1.43.113:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_MysqlQueueTh-MysqlQueueTh-UNDEFINED| 2| 0.33%| 0.09| | | | 10.1.43.111:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-UNDEFINED-UNDEFINED| 2| 0.33%| 0.09| | 2025-12-23 14:17:36(+23s)| 601| 10.1.43.111:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE| 132| 21.96%| 5.74| | | | 10.1.43.112:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE| 126| 20.96%| 5.48| | | | 10.1.43.111:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogArchiveService-ArchiveSender| 27| 4.49%| 1.17| | | | 10.1.43.112:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 22| 3.66%| 0.96| | | | 10.1.43.113:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 22| 3.66%| 0.96| | | | 10.1.43.111:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 22| 3.66%| 0.96| | | | 10.1.43.113:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_STMT_EXECUTE| 17| 2.83%| 0.74| | | | 10.1.43.113:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogArchiveService-ArchiveSender| 11| 1.83%| 0.48| | | | 10.1.43.112:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 11| 1.83%| 0.48| | | | 10.1.43.112:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_STMT_EXECUTE| 11| 1.83%| 0.48| | | | 10.1.43.112:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-FastDFO| 9| 1.50%| 0.39| | | | 10.1.43.111:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_STMT_EXECUTE| 7| 1.17%| 0.30| | | | 10.1.43.113:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-UNDEFINED-UNDEFINED| 7| 1.17%| 0.30| | | | 10.1.43.113:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-FastDFO| 6| 1.00%| 0.26| | | | 10.1.43.111:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-DynamicThreadPool-DynamicMgrCheck-detect task| 5| 0.83%| 0.22| | | | 10.1.43.112:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_MysqlQueueTh-MysqlQueueTh-UNDEFINED| 5| 0.83%| 0.22| | | | 10.1.43.111:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-FastDFO| 5| 0.83%| 0.22| | | | 10.1.43.111:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 5| 0.83%| 0.22| | | | 10.1.43.111:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_MysqlQueueTh-MysqlQueueTh-UNDEFINED| 4| 0.67%| 0.17| | | | 10.1.43.111:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-UNDEFINED-UNDEFINED| 3| 0.50%| 0.13| | | | 10.1.43.113:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_MysqlQueueTh-MysqlQueueTh-UNDEFINED| 3| 0.50%| 0.13| | | | 10.1.43.112:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-UNDEFINED-UNDEFINED| 1| 0.17%| 0.04| | 2025-12-23 14:17:59(+23s)| 573| 10.1.43.111:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE| 132| 23.04%| 5.74| | | | 10.1.43.112:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_MysqlQueueTh-MysqlQueueTh-UNDEFINED| 35| 6.11%| 1.52| | | | 10.1.43.112:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 22| 3.84%| 0.96| | | | 10.1.43.111:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 22| 3.84%| 0.96| | | | 10.1.43.113:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogArchiveService-ArchiveSender| 22| 3.84%| 0.96| | | | 10.1.43.113:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 22| 3.84%| 0.96| | | | 10.1.43.112:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-UNDEFINED-UNDEFINED| 20| 3.49%| 0.87| | | | 10.1.43.113:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_STMT_EXECUTE| 15| 2.62%| 0.65| | | | 10.1.43.112:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_STMT_EXECUTE| 12| 2.09%| 0.52| | | | 10.1.43.111:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_MysqlQueueTh-MysqlQueueTh-UNDEFINED| 11| 1.92%| 0.48| | | | 10.1.43.113:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-UNDEFINED-UNDEFINED| 11| 1.92%| 0.48| | | | 10.1.43.111:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_STMT_EXECUTE| 11| 1.92%| 0.48| | | | 10.1.43.111:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-UNDEFINED-UNDEFINED| 10| 1.75%| 0.43| | | | 10.1.43.113:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_MysqlQueueTh-MysqlQueueTh-UNDEFINED| 9| 1.57%| 0.39| | | | 10.1.43.111:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-FastDFO| 8| 1.40%| 0.35| | | | 10.1.43.113:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-FastDFO| 6| 1.05%| 0.26| | | | 10.1.43.112:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 6| 1.05%| 0.26| | | | 10.1.43.112:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-FastDFO| 4| 0.70%| 0.17| | | | 10.1.43.111:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 4| 0.70%| 0.17| | | | 10.1.43.112:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE| 2| 0.35%| 0.09| | | | 10.1.43.111:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-DynamicThreadPool-DynamicMgrCheck-detect task| 2| 0.35%| 0.09| | 2025-12-23 14:18:22(+23s)| 297| 10.1.43.111:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 22| 7.41%| 0.96| | | | 10.1.43.112:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 22| 7.41%| 0.96| | | | 10.1.43.113:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 22| 7.41%| 0.96| | | | 10.1.43.112:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_STMT_EXECUTE| 18| 6.06%| 0.78| | | | 10.1.43.111:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_STMT_EXECUTE| 13| 4.38%| 0.56| | | | 10.1.43.113:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_STMT_EXECUTE| 11| 3.70%| 0.48| | | | 10.1.43.111:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE| 9| 3.03%| 0.39| | | | 10.1.43.111:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-FastDFO| 9| 3.03%| 0.39| | | | 10.1.43.112:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-FastDFO| 6| 2.02%| 0.26| | | | 10.1.43.113:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-UNDEFINED-UNDEFINED| 5| 1.68%| 0.22| | | | 10.1.43.111:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 4| 1.35%| 0.17| | | | 10.1.43.113:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_MysqlQueueTh-MysqlQueueTh-UNDEFINED| 4| 1.35%| 0.17| | | | 10.1.43.112:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-UNDEFINED-UNDEFINED| 4| 1.35%| 0.17| | | | 10.1.43.112:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 3| 1.01%| 0.13| | | | 10.1.43.113:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-FastDFO| 3| 1.01%| 0.13| | | | 10.1.43.111:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-UNDEFINED-UNDEFINED| 3| 1.01%| 0.13| | | | 10.1.43.112:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_MysqlQueueTh-MysqlQueueTh-UNDEFINED| 2| 0.67%| 0.09| | | | 10.1.43.111:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-DynamicThreadPool-DynamicMgrCheck-detect task| 2| 0.67%| 0.09| | | | 10.1.43.111:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_MysqlQueueTh-MysqlQueueTh-UNDEFINED| 1| 0.34%| 0.04| | 2025-12-23 14:18:45(+23s)| 584| 10.1.43.112:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE| 102| 17.47%| 4.43| | | | 10.1.43.112:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_MysqlQueueTh-MysqlQueueTh-UNDEFINED| 33| 5.65%| 1.44| | | | 10.1.43.111:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_STMT_EXECUTE| 29| 4.97%| 1.26| | | | 10.1.43.113:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_STMT_EXECUTE| 23| 3.94%| 1.00| | | | 10.1.43.112:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-UNDEFINED-UNDEFINED| 23| 3.94%| 1.00| | | | 10.1.43.112:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 22| 3.77%| 0.96| | | | 10.1.43.111:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 22| 3.77%| 0.96| | | | 10.1.43.113:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 22| 3.77%| 0.96| | | | 10.1.43.112:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_STMT_EXECUTE| 17| 2.91%| 0.74| | | | 10.1.43.111:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-UNDEFINED-UNDEFINED| 17| 2.91%| 0.74| | | | 10.1.43.113:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_MysqlQueueTh-MysqlQueueTh-UNDEFINED| 15| 2.57%| 0.65| | | | 10.1.43.111:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_MysqlQueueTh-MysqlQueueTh-UNDEFINED| 15| 2.57%| 0.65| | | | 10.1.43.111:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogArchiveService-ArchiveSender| 11| 1.88%| 0.48| | | | 10.1.43.111:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 10| 1.71%| 0.43| | | | 10.1.43.113:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-UNDEFINED-UNDEFINED| 10| 1.71%| 0.43| | | | 10.1.43.113:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogArchiveService-ArchiveSender| 10| 1.71%| 0.43| | | | 10.1.43.111:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-FastDFO| 7| 1.20%| 0.30| | | | 10.1.43.111:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-DynamicThreadPool-DynamicMgrCheck-detect task| 7| 1.20%| 0.30| | | | 10.1.43.113:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-FastDFO| 6| 1.03%| 0.26| | | | 10.1.43.112:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 5| 0.86%| 0.22| | | | 10.1.43.112:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-FastDFO| 1| 0.17%| 0.04| | 2025-12-23 14:19:08(+23s)| 420| 10.1.43.113:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE| 107| 25.48%| 4.65| | | | 10.1.43.112:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE| 26| 6.19%| 1.13| | | | 10.1.43.113:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 23| 5.48%| 1.00| | | | 10.1.43.111:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 23| 5.48%| 1.00| | | | 10.1.43.112:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 22| 5.24%| 0.96| | | | 10.1.43.111:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_STMT_EXECUTE| 15| 3.57%| 0.65| | | | 10.1.43.113:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_STMT_EXECUTE| 14| 3.33%| 0.61| | | | 10.1.43.112:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_STMT_EXECUTE| 13| 3.10%| 0.56| | | | 10.1.43.111:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-FastDFO| 10| 2.38%| 0.43| | | | 10.1.43.111:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 9| 2.14%| 0.39| | | | 10.1.43.112:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_MysqlQueueTh-MysqlQueueTh-UNDEFINED| 8| 1.91%| 0.35| | | | 10.1.43.111:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-DynamicThreadPool-DynamicMgrCheck-detect task| 7| 1.67%| 0.30| | | | 10.1.43.111:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_MysqlQueueTh-MysqlQueueTh-UNDEFINED| 6| 1.43%| 0.26| | | | 10.1.43.112:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-FastDFO| 3| 0.71%| 0.13| | | | 10.1.43.112:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-UNDEFINED-UNDEFINED| 3| 0.71%| 0.13| | | | 10.1.43.113:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_MysqlQueueTh-MysqlQueueTh-UNDEFINED| 3| 0.71%| 0.13| | | | 10.1.43.113:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-FastDFO| 3| 0.71%| 0.13| | | | 10.1.43.113:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-UNDEFINED-UNDEFINED| 2| 0.48%| 0.09| | | | 10.1.43.111:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-UNDEFINED-UNDEFINED| 2| 0.48%| 0.09| | | | 10.1.43.113:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogArchiveService-ArchiveSender| 1| 0.24%| 0.04| | | | 10.1.43.112:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 1| 0.24%| 0.04| | 2025-12-23 14:19:31(+23s)| 415| 10.1.43.113:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE| 132| 31.81%| 5.74| | | | 10.1.43.112:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 22| 5.30%| 0.96| | | | 10.1.43.113:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 22| 5.30%| 0.96| | | | 10.1.43.111:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 22| 5.30%| 0.96| | | | 10.1.43.113:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_STMT_EXECUTE| 13| 3.13%| 0.56| | | | 10.1.43.111:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_STMT_EXECUTE| 11| 2.65%| 0.48| | | | 10.1.43.111:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-DynamicThreadPool-DynamicMgrCheck-detect task| 6| 1.45%| 0.26| | | | 10.1.43.112:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 6| 1.45%| 0.26| | | | 10.1.43.112:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_STMT_EXECUTE| 5| 1.21%| 0.22| | | | 10.1.43.112:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_MysqlQueueTh-MysqlQueueTh-UNDEFINED| 5| 1.21%| 0.22| | | | 10.1.43.112:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-UNDEFINED-UNDEFINED| 5| 1.21%| 0.22| | | | 10.1.43.111:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-FastDFO| 5| 1.21%| 0.22| | | | 10.1.43.111:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-UNDEFINED-UNDEFINED| 4| 0.96%| 0.17| | | | 10.1.43.111:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 4| 0.96%| 0.17| | | | 10.1.43.112:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-FastDFO| 4| 0.96%| 0.17| | | | 10.1.43.113:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-UNDEFINED-UNDEFINED| 3| 0.72%| 0.13| | | | 10.1.43.113:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_MysqlQueueTh-MysqlQueueTh-UNDEFINED| 3| 0.72%| 0.13| | | | 10.1.43.111:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_MysqlQueueTh-MysqlQueueTh-UNDEFINED| 3| 0.72%| 0.13| | | | 10.1.43.113:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-FastDFO| 1| 0.24%| 0.04| | 2025-12-23 14:19:54(+23s)| 597| 10.1.43.113:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE| 130| 21.78%| 5.65| | | | 10.1.43.112:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_MysqlQueueTh-MysqlQueueTh-UNDEFINED| 35| 5.86%| 1.52| | | | 10.1.43.112:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-UNDEFINED-UNDEFINED| 29| 4.86%| 1.26| | | | 10.1.43.113:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogArchiveService-ArchiveSender| 24| 4.02%| 1.04| | | | 10.1.43.112:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 23| 3.85%| 1.00| | | | 10.1.43.113:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 22| 3.69%| 0.96| | | | 10.1.43.113:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_STMT_EXECUTE| 22| 3.69%| 0.96| | | | 10.1.43.111:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 22| 3.69%| 0.96| | | | 10.1.43.111:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_STMT_EXECUTE| 20| 3.35%| 0.87| | | | 10.1.43.112:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_STMT_EXECUTE| 18| 3.02%| 0.78| | | | 10.1.43.113:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-UNDEFINED-UNDEFINED| 14| 2.35%| 0.61| | | | 10.1.43.111:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-UNDEFINED-UNDEFINED| 11| 1.84%| 0.48| | | | 10.1.43.111:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_MysqlQueueTh-MysqlQueueTh-UNDEFINED| 11| 1.84%| 0.48| | | | 10.1.43.112:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 9| 1.51%| 0.39| | | | 10.1.43.111:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-FastDFO| 8| 1.34%| 0.35| | | | 10.1.43.113:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_MysqlQueueTh-MysqlQueueTh-UNDEFINED| 7| 1.17%| 0.30| | | | 10.1.43.113:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-FastDFO| 7| 1.17%| 0.30| | | | 10.1.43.112:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-FastDFO| 5| 0.84%| 0.22| | | | 10.1.43.111:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-DynamicThreadPool-DynamicMgrCheck-detect task| 4| 0.67%| 0.17| | | | 10.1.43.111:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 4| 0.67%| 0.17| | 2025-12-23 14:20:17(+23s)| 342| 10.1.43.113:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_STMT_EXECUTE| 23| 6.72%| 1.00| | | | 10.1.43.113:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 22| 6.43%| 0.96| | | | 10.1.43.112:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 22| 6.43%| 0.96| | | | 10.1.43.111:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 22| 6.43%| 0.96| | | | 10.1.43.111:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_STMT_EXECUTE| 16| 4.68%| 0.70| | | | 10.1.43.112:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_STMT_EXECUTE| 12| 3.51%| 0.52| | | | 10.1.43.113:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-FastDFO| 11| 3.22%| 0.48| | | | 10.1.43.113:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogArchiveService-ArchiveSender| 8| 2.34%| 0.35| | | | 10.1.43.113:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-UNDEFINED-UNDEFINED| 8| 2.34%| 0.35| | | | 10.1.43.112:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-FastDFO| 8| 2.34%| 0.35| | | | 10.1.43.112:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-UNDEFINED-UNDEFINED| 7| 2.05%| 0.30| | | | 10.1.43.113:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_MysqlQueueTh-MysqlQueueTh-UNDEFINED| 6| 1.75%| 0.26| | | | 10.1.43.111:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-DynamicThreadPool-DynamicMgrCheck-detect task| 6| 1.75%| 0.26| | | | 10.1.43.112:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_MysqlQueueTh-MysqlQueueTh-UNDEFINED| 5| 1.46%| 0.22| | | | 10.1.43.111:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 5| 1.46%| 0.22| | | | 10.1.43.111:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-FastDFO| 4| 1.17%| 0.17| | | | 10.1.43.111:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_MysqlQueueTh-MysqlQueueTh-UNDEFINED| 4| 1.17%| 0.17| | | | 10.1.43.111:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogArchiveService-ArchiveSender| 3| 0.88%| 0.13| | | | 10.1.43.111:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-UNDEFINED-UNDEFINED| 3| 0.88%| 0.13| | | | 10.1.43.113:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_DAG-COMPACTION-MAJOR_MERGE/MEDIUM_MERGE| 2| 0.58%| 0.09| | | | 10.1.43.112:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 2| 0.58%| 0.09| | 2025-12-23 14:20:40(+19s)| 269| 10.1.43.113:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 19| 7.06%| 1.00| | | | 10.1.43.111:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 19| 7.06%| 1.00| | | | 10.1.43.112:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 18| 6.69%| 0.95| | | | 10.1.43.113:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_STMT_EXECUTE| 16| 5.95%| 0.84| | | | 10.1.43.111:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_STMT_EXECUTE| 10| 3.72%| 0.53| | | | 10.1.43.112:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_STMT_EXECUTE| 8| 2.97%| 0.42| | | | 10.1.43.111:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogArchiveService-ArchiveSender| 8| 2.97%| 0.42| | | | 10.1.43.112:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-UNDEFINED-UNDEFINED| 8| 2.97%| 0.42| | | | 10.1.43.112:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-FastDFO| 6| 2.23%| 0.32| | | | 10.1.43.111:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-DynamicThreadPool-DynamicMgrCheck-detect task| 5| 1.86%| 0.26| | | | 10.1.43.111:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_MysqlQueueTh-MysqlQueueTh-UNDEFINED| 4| 1.49%| 0.21| | | | 10.1.43.112:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_MysqlQueueTh-MysqlQueueTh-UNDEFINED| 4| 1.49%| 0.21| | | | 10.1.43.111:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-UNDEFINED-UNDEFINED| 4| 1.49%| 0.21| | | | 10.1.43.111:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 4| 1.49%| 0.21| | | | 10.1.43.113:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-UNDEFINED-UNDEFINED| 3| 1.11%| 0.16| | | | 10.1.43.111:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-FastDFO| 3| 1.11%| 0.16| | | | 10.1.43.113:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_MysqlQueueTh-MysqlQueueTh-UNDEFINED| 2| 0.74%| 0.10| | | | 10.1.43.112:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 1| 0.37%| 0.05| | | | 10.1.43.113:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-FastDFO| 1| 0.37%| 0.05| +----------------------------+-------------+--------------------------------------------------------------------------------------------------------------------------------+--------------------+-----------+--------------------+ 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.1.43.113:2882| ON CPU| NULL| 307| 1.29| 5.93%| | | px loop condition wait| NETWORK| 46| 0.19| 0.89%| | | tx commiting wait| COMMIT| 24| 0.10| 0.46%| | | wait in request queue| CONFIGURATION| 10| 0.04| 0.19%| | | sync get gts timestamp wait| NETWORK| 5| 0.02| 0.10%| | | exec inner sql wait| OTHER| 4| 0.02| 0.08%| | | sync rpc| NETWORK| 3| 0.01| 0.06%| | | db file data read| USER_IO| 2| 0.01| 0.04%| | | das wait remote response| NETWORK| 2| 0.01| 0.04%| | 10.1.43.112:2882| ON CPU| NULL| 329| 1.38| 6.35%| | | px loop condition wait| NETWORK| 49| 0.21| 0.95%| | | wait in request queue| CONFIGURATION| 6| 0.03| 0.12%| | | tx commiting wait| COMMIT| 5| 0.02| 0.10%| | | sync rpc| NETWORK| 3| 0.01| 0.06%| | | db file data read| USER_IO| 2| 0.01| 0.04%| | | sync get gts timestamp wait| NETWORK| 2| 0.01| 0.04%| | | das wait remote response| NETWORK| 1| 0.00| 0.02%| | 10.1.43.111:2882| ON CPU| NULL| 281| 1.18| 5.43%| | | px loop condition wait| NETWORK| 52| 0.22| 1.00%| | | wait in request queue| CONFIGURATION| 6| 0.03| 0.12%| | | tx commiting wait| COMMIT| 5| 0.02| 0.10%| | | db file data read| USER_IO| 3| 0.01| 0.06%| | | exec inner sql wait| OTHER| 1| 0.00| 0.02%| +----------------------------------------------------------------+----------------------------------------------------------------+--------------------+-------------+--------------------+-----------+ 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.1.43.111:2882| T1002_DAG| COMPACTION| MAJOR_MERGE/MEDIUM_MERGE| ON CPU| NULL| 377| 7.28%| 1.58| | | SyslogCompress| SyslogCompress| UNDEFINED| sleep wait| IDLE| 231| 4.46%| 0.97| | | T1002_MysqlQueueTh| MysqlQueueTh| UNDEFINED| ON CPU| NULL| 70| 1.35%| 0.29| | | T1002_LogService| LogArchiveService| ArchiveSender| ON CPU| NULL| 63| 1.22%| 0.27| | | T1002_RPC_REQUEST| ReqWorker(Level:0)| FastDFO| ON CPU| NULL| 60| 1.16%| 0.25| | | T1002_DAG| COMPACTION| MAJOR_MERGE/MEDIUM_MERGE| db file compact read| SYSTEM_IO| 54| 1.04%| 0.23| | | DynamicThreadPool| DynamicMgrCheck| detect task| ON CPU| NULL| 51| 0.98%| 0.21| | | pnio1| pnio1| UNDEFINED| ON CPU| NULL| 44| 0.85%| 0.18| | | T1002_RPC_REQUEST| ReqWorker(Level:0)| OB_PX_FAST_INIT_SQC| ON CPU| NULL| 40| 0.77%| 0.17| | | T1002_DAG| COMPACTION| MAJOR_MERGE/MEDIUM_MERGE| db file data read| USER_IO| 30| 0.58%| 0.13| | | KVCacheRep| KVCacheRep| UNDEFINED| ON CPU| NULL| 23| 0.44%| 0.10| | 10.1.43.112:2882| T1002_DAG| COMPACTION| MAJOR_MERGE/MEDIUM_MERGE| ON CPU| NULL| 357| 6.89%| 1.50| | | SyslogCompress| SyslogCompress| UNDEFINED| sleep wait| IDLE| 229| 4.42%| 0.96| | | T1002_MysqlQueueTh| MysqlQueueTh| UNDEFINED| ON CPU| NULL| 151| 2.92%| 0.63| | | T1002_DAG| COMPACTION| MAJOR_MERGE/MEDIUM_MERGE| db file compact read| SYSTEM_IO| 59| 1.14%| 0.25| | | T1002_RPC_REQUEST| ReqWorker(Level:0)| FastDFO| ON CPU| NULL| 51| 0.98%| 0.21| | | T1002_LogService| LogArchiveService| ArchiveSender| ON CPU| NULL| 37| 0.71%| 0.15| | | pnio1| pnio1| UNDEFINED| ON CPU| NULL| 27| 0.52%| 0.11| | | T1002_DAG| COMPACTION| MAJOR_MERGE/MEDIUM_MERGE| db file data read| USER_IO| 24| 0.46%| 0.10| | | T1002_DAG| COMPACTION| MAJOR_MERGE/MEDIUM_MERGE| db file compact write| SYSTEM_IO| 24| 0.46%| 0.10| | | DynamicThreadPool| DynamicMgrCheck| detect task| ON CPU| NULL| 24| 0.46%| 0.10| | | sql_nio| sql_nio| HandleEpollEvent| ON CPU| NULL| 21| 0.41%| 0.09| | 10.1.43.113:2882| T1002_DAG| COMPACTION| MAJOR_MERGE/MEDIUM_MERGE| ON CPU| NULL| 367| 7.09%| 1.54| | | SyslogCompress| SyslogCompress| UNDEFINED| sleep wait| IDLE| 230| 4.44%| 0.97| | | T1002_LogService| LogArchiveService| ArchiveSender| ON CPU| NULL| 76| 1.47%| 0.32| | | T1002_MysqlQueueTh| MysqlQueueTh| UNDEFINED| ON CPU| NULL| 62| 1.20%| 0.26| | | T1002_DAG| COMPACTION| MAJOR_MERGE/MEDIUM_MERGE| db file compact read| SYSTEM_IO| 61| 1.18%| 0.26| | | T1002_RPC_REQUEST| ReqWorker(Level:0)| FastDFO| ON CPU| NULL| 48| 0.93%| 0.20| | | pnio1| pnio1| UNDEFINED| ON CPU| NULL| 38| 0.73%| 0.16| | | DynamicThreadPool| DynamicMgrCheck| detect task| ON CPU| NULL| 21| 0.41%| 0.09| +----------------------------------------------------------------+-----------------------------------------------------------------+----------------------------------------------------------------+----------------------------------------------------------------+----------------------------------------------------------------+--------------------+-------------+-----------+--------------------+ 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.1.43.112:2882| 3221950043| T1_SQL_CMD| 0.29%| 0.06| ON CPU| NULL| 0.29%| C123537E124E8FE489A2782FCC75A0CC|13246721729889261947| 0.08%| 4| | 10.1.43.111:2882| 3221507760| T1_SQL_CMD| 0.23%| 0.05| ON CPU| NULL| 0.23%| C123537E124E8FE489A2782FCC75A0CC|13246721729889261947| 0.06%| 3| | 10.1.43.112:2882| 3221785014| T1_SQL_CMD| 0.17%| 0.04| ON CPU| NULL| 0.17%| C123537E124E8FE489A2782FCC75A0CC|13246721729889261947| 0.08%| 4| | 10.1.43.111:2882| 8503601| T1002_SQL_CMD| 0.17%| 0.04| ON CPU| NULL| 0.12%| | 0| 0.00%| 0| | 10.1.43.111:2882| 3221738180| T1_SQL_CMD| 0.15%| 0.03| ON CPU| NULL| 0.15%| C123537E124E8FE489A2782FCC75A0CC|13246721729889261947| 0.08%| 4| | 10.1.43.111:2882| 4294967295| T1002_SQL_CMD| 0.15%| 0.03| ON CPU| NULL| 0.15%| | 0| 0.00%| 0| | 10.1.43.111:2882| 3221675107| T1_SQL_CMD| 0.14%| 0.03| ON CPU| NULL| 0.14%| 0946C6719ED8F3FC38AB8B96CD6DF06F|13334539821956189746| 0.02%| 1| | 10.1.43.111:2882| 8231323| T1002_SQL_CMD| 0.14%| 0.03| ON CPU| NULL| 0.12%| | 0| 0.00%| 0| | 10.1.43.113:2882| 8226718| T1002_SQL_CMD| 0.12%| 0.03| ON CPU| NULL| 0.08%| | 0| 0.00%| 0| | 10.1.43.111:2882| 8436818| T1002_SQL_CMD| 0.12%| 0.03| ON CPU| NULL| 0.12%| 0A61B5C17FC1DC5A658A7A799E51798B|14794022413221784528| 0.06%| 3| | 10.1.43.112:2882| 3221786375| T1_SQL_CMD| 0.12%| 0.03| ON CPU| NULL| 0.12%| 4F1ADBA2D88CC0B8D6B410A36B879032|13334539821956189746| 0.04%| 2| | 10.1.43.113:2882| 8178651| T1002_SQL_CMD| 0.12%| 0.03| ON CPU| NULL| 0.08%| 78AB91580E8F1C5DC4AB96D6EFB03A4E| 6934159631568973308| 0.04%| 2| | 10.1.43.113:2882| 8740203| T1002_SQL_CMD| 0.12%| 0.03| tx commiting wait| COMMIT| 0.08%| 1D0BA376E273B9D622641124D8C59264| 0| 0.08%| 4| | 10.1.43.113:2882| 8193491| T1002_SQL_CMD| 0.12%| 0.03| ON CPU| NULL| 0.12%| | 0| 0.00%| 0| | 10.1.43.111:2882| 8409153| T1002_SQL_CMD| 0.12%| 0.03| ON CPU| NULL| 0.08%| | 0| 0.00%| 0| +--------------------------------+--------------------+----------------------------------------------------------------+-----------+--------------------+----------------------------------------------------------------+--------------------+-----------+----------------------------------------+--------------------+-----------+--------------------+ 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.1.43.112:2882| D2CD224FE21C387E9844DA64F0EE14BE| 4037823051346858648|disk_read| 6101.56| 20.43| 97.85| 200008| 100.00%| | 10.1.43.112:2882| 7623C5965CE2FAFF283FD50EB1A2105C| 4037823051346858648|disk_read| 3811.47| 13.05| 60.90| 200010| 100.00%| | 10.1.43.113:2882| T1002_DAG/COMPACTION/MINOR_EXECUTE| 0|disk_read| 13.96| 200.52| 21.54| 0| 100.00%| | 10.1.43.113:2882| T1002_DAG/COMPACTION/MINOR_EXECUTE| 0|disk_write| 8.59| 147.67| 15.86| 0| 100.00%| | 10.1.43.111:2882| DB4278BED84685EF86C0C5485852A1FC| 8894128478548303855|disk_read| 885.89| 0.24| 13.09| 0| 100.00%| | 10.1.43.111:2882| 1F4416599102F0E5B69481AE4A43B1F2| 9301922149903140001|disk_read| 1029.51| 0.04| 12.20| 0| 100.00%| | 10.1.43.111:2882| 66C38C32B378C311A4FF57B424A90A62| 8894128478548303855|disk_read| 753.90| 0.33| 11.86| 0| 100.00%| | 10.1.43.112:2882| T1002_DAG/COMPACTION/MINOR_EXECUTE| 0|disk_read| 4.83| 10.00| 9.66| 0| 100.00%| | 10.1.43.112:2882| T1002_DAG/COMPACTION/MINOR_EXECUTE| 0|disk_write| 4.83| 9.87| 9.54| 0| 100.00%| | 10.1.43.112:2882| 3CB7F81D3C8F937B1A01F60A8CECD61D| 2024022107463006675|disk_read| 501.76| 0.02| 7.93| 0| 100.00%| | 10.1.43.113:2882| 3CB7F81D3C8F937B1A01F60A8CECD61D| 2024022107463006675|disk_read| 573.15| 0.05| 7.72| 0| 63.66%| | 10.1.43.111:2882| 29E6EF317C2C60E155D2D6FC9027DBCA| 1633040689999067903|disk_read| 438.88| 0.03| 7.27| 0| 50.37%| | 10.1.43.111:2882| T1002_DAG/COMPACTION/MAJOR_MERGE/MEDIUM_MERGE| 0|disk_read| 23.31| 25300.59| 7.21| 0| 100.00%| | 10.1.43.113:2882| 1F4416599102F0E5B69481AE4A43B1F2| 9301922149903140001|disk_read| 445.75| 0.11| 7.16| 0| 56.91%| | 10.1.43.113:2882| F1AC6CF080A08605F614082567766503| 6278664499981799839|disk_read| 449.24| 0.02| 7.07| 200004| 100.00%| | 10.1.43.112:2882| BBE4A84206F5EE14F10FEED776EA87A8| 5781124863887735973|disk_read| 372.86| 0.02| 6.73| 0| 100.00%| | 10.1.43.111:2882| T1002_DAG/COMPACTION/MINOR_EXECUTE| 0|disk_read| 31.95| 431.07| 6.53| 0| 100.00%| | 10.1.43.111:2882| T1002_DAG/COMPACTION/MAJOR_MERGE/MEDIUM_MERGE| 0|disk_write| 3.27| 21094.29| 6.01| 0| 100.00%| | 10.1.43.111:2882| T1002_DAG/DAG/| 0|disk_read| 20.65| 88.49| 5.71| 0| 100.00%| | 10.1.43.113:2882| 4894BAFCF6DC1D06E8D69FAED05791CC|13110833342852738567|disk_read| 369.41| 0.01| 5.46| 0| 100.00%| | 10.1.43.111:2882| T1002_DAG/DAG/| 0|disk_write| 3.74| 81.58| 5.26| 0| 100.00%| | 10.1.43.111:2882| T1002_DAG/COMPACTION/MINOR_EXECUTE| 0|disk_write| 2.29| 288.13| 4.36| 0| 100.00%| | 10.1.43.112:2882| T1002_DAG/COMPACTION/MAJOR_MERGE/MEDIUM_MERGE| 0|disk_read| 11.77| 24234.78| 4.23| 0| 100.00%| | 10.1.43.113:2882| T1002_DAG/DAG/| 0|disk_read| 8.99| 53.85| 4.00| 0| 100.00%| | 10.1.43.112:2882| 5A0107802B05FF35D66D09AB09399AAF| 1900490854245156878|disk_read| 280.27| 0.01| 3.61| 0| 100.00%| | 10.1.43.112:2882| T1002_DAG/COMPACTION/MAJOR_MERGE/MEDIUM_MERGE| 0|disk_write| 1.92| 20488.97| 3.58| 0| 100.00%| | 10.1.43.112:2882| 1F4416599102F0E5B69481AE4A43B1F2| 9301922149903140001|disk_read| 197.55| 0.02| 3.58| 200008| 100.00%| | 10.1.43.112:2882| 1639359F37F8F0D9D719891FFBBE0AF9| 8894128478548303855|disk_read| 187.09| 0.02| 3.51| 0| 100.00%| | 10.1.43.113:2882| T1002_DAG/COMPACTION/MAJOR_MERGE/MEDIUM_MERGE| 0|disk_read| 8.14| 24612.33| 2.93| 0| 100.00%| | 10.1.43.113:2882| T1002_DAG/DAG/| 0|disk_write| 2.08| 38.16| 2.83| 0| 100.00%| | 10.1.43.111:2882| 1CF3EA3A1E2A9438A65E2EAD3F62CD78| 8894128478548303855|disk_read| 176.48| 0.03| 2.77| 0| 100.00%| | 10.1.43.112:2882| OB_PLOG/OB_PLOG/flush log| 0|disk_write| 1663.02| 492.80| 2.55| 0| 100.00%| | 10.1.43.113:2882| T1002_DAG/COMPACTION/MAJOR_MERGE/MEDIUM_MERGE| 0|disk_write| 1.33| 20687.45| 2.46| 0| 100.00%| | 10.1.43.111:2882| OB_PLOG/OB_PLOG/flush log| 0|disk_write| 1808.88| 517.63| 2.13| 0| 100.00%| | 10.1.43.113:2882| OB_PLOG/OB_PLOG/flush log| 0|disk_write| 587.54| 398.64| 1.63| 0| 100.00%| | 10.1.43.113:2882| 2228E30A01DC25FA73859449FE1FE1FA| 1871344645954572482|disk_read| 53.61| 0.29| 0.82|1152921504606846990| 100.00%| | 10.1.43.113:2882| T1002_SQL_CMD/ReqWorker(Level:0)/COM_STMT_EXECUTE| 0|disk_read| 42.58| 1.70| 0.67| 0| 100.00%| | 10.1.43.111:2882| EADABAC5BA976E904C6C6923D25AE448|15128700253572538477|disk_read| 34.46| 6.45| 0.55| 0| 72.27%| | 10.1.43.112:2882| 7E34FA1634D47C6F25D9953FA5C843B4| 3083750236581270736|disk_read| 34.46| 8.60| 0.55| 0| 57.57%| | 10.1.43.113:2882| 7E34FA1634D47C6F25D9953FA5C843B4| 3083750236581270736|disk_read| 34.12| 9.00| 0.54| 0| 48.05%| | 10.1.43.111:2882| BlkMgr/BlkMgr/| 0|disk_read| 6.66| 26.32| 0.45| 0| 100.00%| | 10.1.43.113:2882| BlkMgr/BlkMgr/| 0|disk_read| 5.18| 23.25| 0.43| 0| 100.00%| | 10.1.43.111:2882| 7E34FA1634D47C6F25D9953FA5C843B4| 3083750236581270736|disk_read| 25.28| 0.91| 0.40| 0| 56.49%| | 10.1.43.111:2882| T1002_BFBuildTask/BFBuildTask/BloomFilterBuild| 0|disk_read| 0.20| 40.00| 0.39| 0| 100.00%| | 10.1.43.112:2882| BlkMgr/BlkMgr/| 0|disk_read| 3.17| 32.47| 0.28| 0| 100.00%| | 10.1.43.113:2882| T1002_LogService/LogIOWorker/aggregate io task| 0|disk_write| 43.42| 138.29| 0.22| 0| 100.00%| | 10.1.43.112:2882| C52E3CCBE8BC80A60D7D681324474B81| 6278664499981799839|disk_read| 13.28| 0.02| 0.21| 0| 100.00%| | 10.1.43.112:2882| T1002_LogService/LogIOWorker/aggregate io task| 0|disk_write| 29.06| 149.58| 0.15| 0| 100.00%| | 10.1.43.111:2882| T1002_LogService/LogIOWorker/aggregate io task| 0|disk_write| 26.25| 184.82| 0.14| 0| 100.00%| | 10.1.43.112:2882| T1002_BFBuildTask/BFBuildTask/BloomFilterBuild| 0|disk_read| 0.04| 116.00| 0.09| 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| +----------------------------------------------------------------+-------------+-----------+--------------------+ +----------------------------------------------------------------+-------------+-----------+--------------------+ 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.1.43.111:2882| 1| 11004| 0.08| 0.35%| 18| ON CPU| 0.35%| 14659BB62C7D2D43C72D458B3514AA98| 0.02%| oceanbase.__all_virtual_plan_stat| | | 1002| 200164| 0.04| 0.17%| 9| ON CPU| 0.17%| 285CFBE18F930B5F76703A86E894F882| 0.02%| eo_course.eeo_course_member(p7)| | | 1002| 1152921504606847520| 0.03| 0.15%| 8| ON CPU| 0.15%| 3A8EA1322C3961A50933B25FA1DB0C44| 0.02%| eo_course.eeo_course_member.uniq_cu(p13)| | | 1002| 200158| 0.03| 0.14%| 7| ON CPU| 0.14%| 0350A0216C1A88810F7B7A3768E0461F| 0.02%| eo_course.eeo_course_member(p1)| | | 1002| 200170| 0.03| 0.14%| 7| ON CPU| 0.14%| 29E6EF317C2C60E155D2D6FC9027DBCA| 0.02%| eo_course.eeo_course_member(p13)| | | 1002| 1152921504606847556| 0.03| 0.12%| 6| ON CPU| 0.12%| 4894BAFCF6DC1D06E8D69FAED05791CC| 0.04%| eo_course.eeo_course_member.idx_usi(p1)| | | 1002| 1152921504606847514| 0.03| 0.12%| 6| ON CPU| 0.12%| 0A61B5C17FC1DC5A658A7A799E51798B| 0.02%| eo_course.eeo_course_member.uniq_cu(p7)| | | 1002| 1152921504606847536| 0.02| 0.08%| 4| ON CPU| 0.08%| 78AB91580E8F1C5DC4AB96D6EFB03A4E| 0.04%| eo_course.eeo_course_member.idx_csi(p13)| | | 1002| 1152921504606847597| 0.02| 0.08%| 4| ON CPU| 0.08%| 705353960430D3763A40B7A6ECB8A36C| 0.02%| ai_assistant.ai_summary_pregeneration_queue.idx_cs| | | 1002| 1152921504606847530| 0.02| 0.08%| 4| ON CPU| 0.08%| 32A2B2F41FF843DF94232AD5CDE3F0D7| 0.02%| eo_course.eeo_course_member.idx_csi(p7)| | | 1002| 1152921504606847524| 0.02| 0.08%| 4| ON CPU| 0.08%| 242CF6A934E7519E78765528A2360F6C| 0.02%| eo_course.eeo_course_member.idx_csi(p1)| | | 1002| 1152921504606847562| 0.01| 0.06%| 3| ON CPU| 0.06%| 4894BAFCF6DC1D06E8D69FAED05791CC| 0.02%| eo_course.eeo_course_member.idx_usi(p7)| | | 1002| 1152921504606847508| 0.01| 0.06%| 3| ON CPU| 0.06%| 0A61B5C17FC1DC5A658A7A799E51798B| 0.02%| eo_course.eeo_course_member.uniq_cu(p1)| | 10.1.43.112:2882| 1| 11004| 0.12| 0.54%| 28| ON CPU| 0.54%| 07F3B3BA76387852D4A72139BE936D14| 0.08%| oceanbase.__all_virtual_plan_stat| | | 1002| 200162| 0.03| 0.14%| 7| ON CPU| 0.14%| 7552981DDE94F072F7A7DE3C4061EC93| 0.04%| eo_course.eeo_course_member(p5)| | | 1002| 1152921504606847512| 0.03| 0.12%| 6| ON CPU| 0.12%| 0A61B5C17FC1DC5A658A7A799E51798B| 0.02%| eo_course.eeo_course_member.uniq_cu(p5)| | | 1002| 200168| 0.03| 0.12%| 6| ON CPU| 0.12%| 868C74B86274C257CF8AB3F1F645B97C| 0.02%| eo_course.eeo_course_member(p11)| | | 1002| 1152921504606847039| 0.02| 0.10%| 5| ON CPU| 0.10%| 0B01538DD1E7DA78999CE774E91B96A2| 0.06%| eo_classroom.eeo_class_file.idx_ci| | | 1002| 1152921504606847528| 0.02| 0.10%| 5| ON CPU| 0.10%| 4C1822585F80695B6DB9F85AF93A15B0| 0.02%| eo_course.eeo_course_member.idx_csi(p5)| | | 1| 11017| 0.02| 0.08%| 4| ON CPU| 0.08%| 1DF15473BF500C0D6F79C1C41FDCE4CC| 0.06%| oceanbase.__all_virtual_system_event| | | 1002| 200010| 0.02| 0.08%| 4| db file data read| 0.04%| 7E34FA1634D47C6F25D9953FA5C843B4| 0.04%| eo_classroom.eeo_class_member_time(p9)| | | | | | | | ON CPU| 0.04%| 58195EFB404E79206B48F32D1485DA1B| 0.02%| | | | 1| 12185| 0.01| 0.06%| 3| ON CPU| 0.06%| 201D9ED0465032D54BCDC648C5701EBB| 0.06%| oceanbase.__all_virtual_sql_plan_monitor| | | 1002| 200008| 0.01| 0.06%| 3| db file data read| 0.04%| 3CB7F81D3C8F937B1A01F60A8CECD61D| 0.02%| eo_classroom.eeo_class_member_time(p7)| | | | | | | | ON CPU| 0.02%| 1F4416599102F0E5B69481AE4A43B1F2| 0.02%| | | 10.1.43.113:2882| 1| 11004| 0.05| 0.23%| 12| ON CPU| 0.23%| 07F3B3BA76387852D4A72139BE936D14| 0.02%| oceanbase.__all_virtual_plan_stat| | | 1002| 200172| 0.03| 0.15%| 8| ON CPU| 0.15%| 2BC8084BF69FCEBBBB50CA1C464CAD4A| 0.02%| eo_course.eeo_course_member(p15)| | | 1002| 1152921504606847558| 0.03| 0.12%| 6| ON CPU| 0.12%| 4894BAFCF6DC1D06E8D69FAED05791CC| 0.02%| eo_course.eeo_course_member.idx_usi(p3)| | | 1002| 1152921504606847538| 0.02| 0.10%| 5| ON CPU| 0.10%| 4C1822585F80695B6DB9F85AF93A15B0| 0.02%| eo_course.eeo_course_member.idx_csi(p15)| | | 1002| 200160| 0.02| 0.10%| 5| ON CPU| 0.10%| 0A61B5C17FC1DC5A658A7A799E51798B| 0.02%| eo_course.eeo_course_member(p3)| | | 1002| 1152921504606847526| 0.02| 0.08%| 4| ON CPU| 0.08%| 4C1822585F80695B6DB9F85AF93A15B0| 0.02%| eo_course.eeo_course_member.idx_csi(p3)| | | 1002| 200006| 0.02| 0.08%| 4| db file data read| 0.06%| 1F4416599102F0E5B69481AE4A43B1F2| 0.02%| eo_classroom.eeo_class_member_time(p5)| | | | | | | | ON CPU| 0.02%| D2CD224FE21C387E9844DA64F0EE14BE| 0.02%| | +-------------------------+--------------------+--------------------+--------------------+--------------------+--------------------+----------------------------------------------------------------+--------------------+----------------------------------------------------------------+--------------------+--------------------------------------------------------------------------------------------------------------------------------+ 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| +----------------------------+-------------+----------------------------------------------------------------+--------------------+-------------+-----------+--------------------+ | 2025-12-23 14:17:00(+13s)| 474| ON CPU| NULL| 360| 75.95%| 27.69| | | | sleep wait| IDLE| 36| 7.59%| 2.77| | | | db file compact read| SYSTEM_IO| 34| 7.17%| 2.62| | | | exec inner sql wait| OTHER| 12| 2.53%| 0.92| | | | px loop condition wait| NETWORK| 9| 1.90%| 0.69| | 2025-12-23 14:17:13| 607| ON CPU| NULL| 426| 70.18%| 18.52| | | | sleep wait| IDLE| 68| 11.20%| 2.96| | | | db file compact read| SYSTEM_IO| 37| 6.10%| 1.61| | | | px loop condition wait| NETWORK| 20| 3.29%| 0.87| | | | db file data read| USER_IO| 19| 3.13%| 0.83| | 2025-12-23 14:17:36| 601| ON CPU| NULL| 436| 72.55%| 18.96| | | | sleep wait| IDLE| 66| 10.98%| 2.87| | | | db file compact read| SYSTEM_IO| 27| 4.49%| 1.17| | | | db file data read| USER_IO| 19| 3.16%| 0.83| | | | exec inner sql wait| OTHER| 19| 3.16%| 0.83| | 2025-12-23 14:17:59| 573| ON CPU| NULL| 424| 74.00%| 18.43| | | | sleep wait| IDLE| 66| 11.52%| 2.87| | | | db file compact read| SYSTEM_IO| 15| 2.62%| 0.65| | | | px loop condition wait| NETWORK| 15| 2.62%| 0.65| | | | exec inner sql wait| OTHER| 14| 2.44%| 0.61| | 2025-12-23 14:18:22| 297| ON CPU| NULL| 190| 63.97%| 8.26| | | | sleep wait| IDLE| 66| 22.22%| 2.87| | | | px loop condition wait| NETWORK| 15| 5.05%| 0.65| | | | exec inner sql wait| OTHER| 9| 3.03%| 0.39| | | | wait in request queue| CONFIGURATION| 5| 1.68%| 0.22| | 2025-12-23 14:18:45| 584| ON CPU| NULL| 439| 75.17%| 19.09| | | | sleep wait| IDLE| 66| 11.30%| 2.87| | | | exec inner sql wait| OTHER| 20| 3.42%| 0.87| | | | db file compact read| SYSTEM_IO| 15| 2.57%| 0.65| | | | db file data read| USER_IO| 15| 2.57%| 0.65| | 2025-12-23 14:19:08| 420| ON CPU| NULL| 287| 68.33%| 12.48| | | | sleep wait| IDLE| 68| 16.19%| 2.96| | | | db file compact read| SYSTEM_IO| 17| 4.05%| 0.74| | | | px loop condition wait| NETWORK| 13| 3.10%| 0.56| | | | exec inner sql wait| OTHER| 13| 3.10%| 0.56| | 2025-12-23 14:19:31| 415| ON CPU| NULL| 284| 68.43%| 12.35| | | | sleep wait| IDLE| 66| 15.90%| 2.87| | | | exec inner sql wait| OTHER| 17| 4.10%| 0.74| | | | db file compact read| SYSTEM_IO| 11| 2.65%| 0.48| | | | db file data read| USER_IO| 10| 2.41%| 0.43| | 2025-12-23 14:19:54| 597| ON CPU| NULL| 442| 74.04%| 19.22| | | | sleep wait| IDLE| 67| 11.22%| 2.91| | | | exec inner sql wait| OTHER| 23| 3.85%| 1.00| | | | db file compact read| SYSTEM_IO| 20| 3.35%| 0.87| | | | px loop condition wait| NETWORK| 12| 2.01%| 0.52| | 2025-12-23 14:20:17| 342| ON CPU| NULL| 226| 66.08%| 9.83| | | | sleep wait| IDLE| 66| 19.30%| 2.87| | | | px loop condition wait| NETWORK| 19| 5.56%| 0.83| | | | exec inner sql wait| OTHER| 11| 3.22%| 0.48| | | | palf write| SYSTEM_IO| 8| 2.34%| 0.35| +----------------------------+-------------+----------------------------------------------------------------+--------------------+-------------+-----------+--------------------+ 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_SQL_EXECUTION| 570| 11.01%| 78AB91580E8F1C5DC4AB96D6EFB03A4E| 0.91%| | | IN_STORAGE_READ| 201| 3.88%| 78AB91580E8F1C5DC4AB96D6EFB03A4E| 0.41%| | | IN_COMMITTING| 34| 0.66%| 1D0BA376E273B9D622641124D8C59264| 0.56%| | | IN_PLAN_CACHE| 30| 0.58%| D26B4A01511736CC33FBA2C680279E3C| 0.15%| | | IN_RPC_ENCODE| 25| 0.48%| 669A1F9D88B51221A6CD9886C03775E8| 0.06%| | | IN_EXTRACT_QUERY_RANGE| 23| 0.44%| 78AB91580E8F1C5DC4AB96D6EFB03A4E| 0.17%| | | IN_FILTER_ROWS| 10| 0.19%| D26B4A01511736CC33FBA2C680279E3C| 0.02%| | | IN_RESOLVE| 10| 0.19%| 33F598E23DF4C7A0F3C825772C8294DB| 0.04%| | | IN_STORAGE_WRITE| 7| 0.14%| E5E8C0FA607CF00048C4600D7C76B053| 0.04%| | | IN_CONNECTION_MGR| 7| 0.14%| | 0.12%| | | IN_CHECK_ROW_CONFLICTION| 3| 0.06%| E5E8C0FA607CF00048C4600D7C76B053| 0.02%| | | IN_PARSE| 2| 0.04%| BCD700721DEF129AC65746D748A95A79| 0.02%| | | IN_REWRITE| 2| 0.04%| D2A7C1A8F866E25C0B776F3BFB3AFAD7| 0.02%| | BACKGROUND| IN_SQL_EXECUTION| 220| 4.25%| 7552981DDE94F072F7A7DE3C4061EC93| 0.68%| | | IN_PX_EXECUTION| 192| 3.71%| 7552981DDE94F072F7A7DE3C4061EC93| 0.64%| | | IN_RPC_DECODE| 118| 2.28%| 32AB97A0126F566064F84DDDF4936F82| 0.15%| | | IN_STORAGE_READ| 108| 2.08%| 7552981DDE94F072F7A7DE3C4061EC93| 0.21%| | | IN_CONNECTION_MGR| 16| 0.31%| | 0.15%| | | IN_COMMITTING| 12| 0.23%| 24D486F20861EBD9E0217692DB0E9C61| 0.14%| | | IN_RPC_ENCODE| 6| 0.12%| 9BD2CBDD5EA9F75F7F51B770FCC9796C| 0.02%| | | IN_REMOTE_DAS_EXECUTION| 6| 0.12%| CBCF2AB396DC0A7452D51A38921A9D29| 0.02%| | | IN_CHECK_ROW_CONFLICTION| 4| 0.08%| DB4278BED84685EF86C0C5485852A1FC| 0.02%| | | IN_STORAGE_WRITE| 4| 0.08%| DB4278BED84685EF86C0C5485852A1FC| 0.02%| | | IN_DUPLICATE_CONFLICT_RESOLVE| 2| 0.04%| 7C895CA99D111B696EE33230828BDCC2| 0.02%| | | IN_PLAN_CACHE| 1| 0.02%| EC1E4162DDF070F6FE0E5BD0B2DAB6B6| 0.02%| +------------+----------------------------------------+--------------------+-----------+----------------------------------------+-----------+ 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.1.43.112:2882| T1002_DAG/COMPACTION/MAJOR_MERGE/MEDIUM_MERGE| 0| 107| 2.07%|db file compact read| SYSTEM_IO| 1.14%| 0.19| 58.59| 0.00| | 10.1.43.111:2882| T1002_DAG/COMPACTION/MAJOR_MERGE/MEDIUM_MERGE| 0| 104| 2.01%|db file compact read| SYSTEM_IO| 1.04%| 0.41| 53.26| 0.00| | 10.1.43.113:2882| T1002_DAG/COMPACTION/MAJOR_MERGE/MEDIUM_MERGE| 0| 91| 1.76%|db file compact read| SYSTEM_IO| 1.18%| 0.33| 60.42| 0.00| | 10.1.43.112:2882| T1002_LogService/LogIOWorker/aggregate io task| 0| 15| 0.29%|palf write| SYSTEM_IO| 0.29%| 1.30| 12.41| 0.00| | 10.1.43.111:2882| T1002_LogService/LogIOWorker/aggregate io task| 0| 11| 0.21%|palf write| SYSTEM_IO| 0.21%| 1.13| 9.43| 0.00| | 10.1.43.113:2882| T1002_LogService/LogIOWorker/aggregate io task| 0| 7| 0.14%|palf write| SYSTEM_IO| 0.14%| 0.76| 5.81| 0.00| | 10.1.43.112:2882| 7E34FA1634D47C6F25D9953FA5C843B4| 3083750236581270736| 2| 0.04%|db file data read| USER_IO| 0.04%| 0.03| 1.66| 0.30| | 10.1.43.113:2882| 7E34FA1634D47C6F25D9953FA5C843B4| 3083750236581270736| 2| 0.04%|db file data read| USER_IO| 0.04%| 0.10| 0.92| 0.90| | 10.1.43.111:2882| T1002_DAG/COMPACTION/MINOR_EXECUTE| 0| 2| 0.04%|db file data read| USER_IO| 0.02%| 0.05| 0.95| 0.00| | 10.1.43.111:2882| 1CF3EA3A1E2A9438A65E2EAD3F62CD78| 8894128478548303855| 1| 0.02%|db file data read| USER_IO| 0.02%| 0.03| 0.90| 0.06| | 10.1.43.111:2882| 66C38C32B378C311A4FF57B424A90A62| 8894128478548303855| 1| 0.02%|db file data read| USER_IO| 0.02%| 0.03| 0.76| 0.18| | 10.1.43.111:2882| 7E34FA1634D47C6F25D9953FA5C843B4| 3083750236581270736| 1| 0.02%|db file data read| USER_IO| 0.02%| 0.03| 0.34| 0.60| | 10.1.43.111:2882| 9E4BDC6B4F79BDCC745EC2D569FD262D| 8894128478548303855| 1| 0.02%|db file data read| USER_IO| 0.02%| 0.01| 0.95| 0.02| | 10.1.43.111:2882| BB636FC09FE91F3EF91E3055E773BD1D| 8894128478548303855| 1| 0.02%|db file data read| USER_IO| 0.02%| 0.05| 0.51| 0.36| | 10.1.43.111:2882| DB4278BED84685EF86C0C5485852A1FC| 8894128478548303855| 1| 0.02%|db file data read| USER_IO| 0.02%| 0.16| 0.77| 0.05| | 10.1.43.112:2882| T1001_LogService/LogIOWorker/aggregate io task| 0| 1| 0.02%|palf write| SYSTEM_IO| 0.02%| 0.09| 0.87| 0.00| | 10.1.43.112:2882| 1639359F37F8F0D9D719891FFBBE0AF9| 8894128478548303855| 1| 0.02%|db file data read| USER_IO| 0.02%| 0.01| 0.91| 0.07| | 10.1.43.112:2882| 3CB7F81D3C8F937B1A01F60A8CECD61D| 2024022107463006675| 1| 0.02%|db file data read| USER_IO| 0.02%| 0.00| 0.98| 0.02| | 10.1.43.112:2882| D2CD224FE21C387E9844DA64F0EE14BE| 4037823051346858648| 1| 0.02%|db file data read| USER_IO| 0.02%| 0.11| 0.87| 2.40| | 10.1.43.113:2882| 1F4416599102F0E5B69481AE4A43B1F2| 9301922149903140001| 1| 0.02%|db file data read| USER_IO| 0.02%| 0.03| 0.91| 0.28| | 10.1.43.113:2882| 3CB7F81D3C8F937B1A01F60A8CECD61D| 2024022107463006675| 1| 0.02%|db file data read| USER_IO| 0.02%| 0.01| 0.68| 0.28| | 10.1.43.113:2882| F1AC6CF080A08605F614082567766503| 6278664499981799839| 1| 0.02%|db file data read| USER_IO| 0.02%| 0.05| 0.32| 0.60| +---------------------+------------------------------------------------------------------------------------------------+--------------------+--------------------+--------------------+----------+--------------------+----------+--------------------+--------------------+--------------------+ 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| 3990| 77.04%| 202| 10.1.43.112:2882| 26.41%| 18.84%| 7.57%| | | | | | 10.1.43.111:2882| 26.38%| 19.04%| 7.34%| | | | | | 10.1.43.113:2882| 24.25%| 16.99%| 7.26%| | T_SELECT| 1086| 20.97%| 357| 10.1.43.111:2882| 7.76%| 6.37%| 1.39%| | | | | | 10.1.43.113:2882| 6.86%| 4.65%| 2.20%| | | | | | 10.1.43.112:2882| 6.35%| 4.31%| 2.05%| | T_END_TRANS| 37| 0.71%| 25| 10.1.43.113:2882| 0.48%| 0.04%| 0.44%| | | | | | 10.1.43.111:2882| 0.14%| 0.02%| 0.12%| | T_VARIABLE_SET| 23| 0.44%| 9| 10.1.43.111:2882| 0.17%| 0.15%| 0.02%| | | | | | 10.1.43.112:2882| 0.15%| 0.15%| 0.00%| | | | | | 10.1.43.113:2882| 0.12%| 0.12%| 0.00%| | T_UPDATE| 22| 0.42%| 4| 10.1.43.111:2882| 0.23%| 0.12%| 0.12%| | | | | | 10.1.43.113:2882| 0.15%| 0.12%| 0.04%| | T_INSERT| 18| 0.35%| 6| 10.1.43.112:2882| 0.15%| 0.06%| 0.10%| | | | | | 10.1.43.113:2882| 0.12%| 0.02%| 0.10%| +---------------------------------------------+---------------------+---------------------+---------------------+----------------------------------------------------------------+---------------------+---------------------+---------------------+ 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| +----------------------------------------+--------------------+--------------------+--------------+--------------------+----------------------------------------------------------------+--------------+--------------------------------------------------------------------------------------------------------------------------------+------------------------+----------------------------------------------------------------+ | 7552981DDE94F072F7A7DE3C4061EC93|10035088924663985725| 73| 1.41%| 63| ON CPU| 0.79%| 5:TABLE RANGE SCAN:eeo_course_member(idx_usi)| 0.37%| SELECT * FROM `eeo_course_member` WHERE user_id = ? AND| | | | | | | px loop condition wait| 0.44%| 1:PX COORDINATOR MERGE SORT | 0.44%| | | | | | | | default condition wait| 0.15%| IN_SQL_EXECUTION| 0.10%| | | | | | | | sync get gts timestamp wait| 0.02%| IN_SQL_EXECUTION| 0.02%| | | 78AB91580E8F1C5DC4AB96D6EFB03A4E| 6934159631568973308| 61| 1.18%| 61| ON CPU| 1.18%| 0:TABLE RANGE SCAN:eeo_course_member(idx_csi)| 0.68%| SELECT * FROM `eeo_course_member` WHERE `eeo_course_mem| | 669A1F9D88B51221A6CD9886C03775E8| 6462078650145968886| 51| 0.98%| 45| ON CPU| 0.60%| 5:TABLE RANGE SCAN:eeo_course_member(idx_usi)| 0.19%| SELECT count(*) FROM `eeo_course_member` WHERE user_id | | | | | | | px loop condition wait| 0.23%| 1:PX COORDINATOR | 0.23%| | | | | | | | default condition wait| 0.14%| IN_SQL_EXECUTION| 0.02%| | | | | | | | sync get gts timestamp wait| 0.02%| IN_SQL_EXECUTION| 0.02%| | +----------------------------------------+--------------------+--------------------+--------------+--------------------+----------------------------------------------------------------+--------------+--------------------------------------------------------------------------------------------------------------------------------+------------------------+----------------------------------------------------------------+ 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| +----------------------------------------+--------------------+--------------+--------------+--------------------+--------------------------------------------------------------------------------------------------------------------------------+--------------+----------------------------------------------------------------+--------------+----------------------------------------------------------------+ | 7552981DDE94F072F7A7DE3C4061EC93|10035088924663985725| 52| 1.00%| 45| 1:PX COORDINATOR MERGE SORT | 0.50%| px loop condition wait| 0.44%| SELECT * FROM `eeo_course_member` WHERE user_id = ? AND| | | | | | | 5:TABLE RANGE SCAN:eeo_course_member(idx_usi)| 0.37%| ON CPU| 0.37%| | | | | | | | 4:PX PARTITION ITERATOR| 0.06%| ON CPU| 0.06%| | | | | | | | 2:EXCHANGE OUT DISTR::EX10000| 0.04%| ON CPU| 0.04%| | | | | | | | 3:TOP-N SORT| 0.04%| ON CPU| 0.04%| | +----------------------------------------+--------------------+--------------+--------------+--------------------+--------------------------------------------------------------------------------------------------------------------------------+--------------+----------------------------------------------------------------+--------------+----------------------------------------------------------------+ 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: SQL ID: 33F598E23DF4C7A0F3C825772C8294DB SQL Text: use `eo_classroom`; SQL ID: 1F4416599102F0E5B69481AE4A43B1F2 SQL Text: select `class_id`, `is_late`, `is_early` from `eeo_class_member_time` where `school_uid` = ? and `member_uid` = ? SQL ID: 32AB97A0126F566064F84DDDF4936F82 SQL Text: SELECT * FROM __all_ls_meta_table WHERE tenant_id = ? ORDER BY tenant_id, ls_id, svr_ip, svr_port SQL ID: 669A1F9D88B51221A6CD9886C03775E8 SQL Text: SELECT count(*) FROM `eeo_course_member` WHERE user_id = ? AND state IN (?) AND identity IN (?,?,?,?) AND is_del = ? SQL ID: EADABAC5BA976E904C6C6923D25AE448 SQL Text: select * from `eeo_class_member_time_detail` where `class_id` = ? and `member_uid` = ? SQL ID: 7E34FA1634D47C6F25D9953FA5C843B4 SQL Text: select * from `eeo_class_member_time` where `class_id` = ? and `member_uid` = ? SQL ID: 29E6EF317C2C60E155D2D6FC9027DBCA SQL Text: SELECT * FROM `eeo_course_member` WHERE user_id = ? AND state IN (?) AND identity IN (?,?,?,?) AND process_flag > ? AND is_del = ? ORDER BY is_top desc,sort desc,lms_activity_latest_time desc,join_time desc,updated_at desc, id desc LIMIT ? SQL ID: 66C38C32B378C311A4FF57B424A90A62 SQL Text: INSERT INTO `eeo_storage_flow` (`uniq_key`,`org_id`,`course_id`,`class_id`,`activity_id`,`scence`,`file_id`,`file_size`,`is_count_num`,`action`,`business_id`,`ext`,`op_uid`,`op_time`,`es_time`,`created_time`,`updated_time`,`op_created_time`,`record_source_type`,`event_time`) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,? SQL ID: EC1E4162DDF070F6FE0E5BD0B2DAB6B6 SQL Text: select * from __all_ls_recovery_stat where ls_id = ? and tenant_id = ? for update SQL ID: 7623C5965CE2FAFF283FD50EB1A2105C SQL Text: SELECT id,class_id,member_uid,is_late,is_early FROM eeo_class_member_time WHERE school_uid = ? AND member_uid IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND id > ? ORDER BY id ASC LIMIT ? SQL ID: 24D486F20861EBD9E0217692DB0E9C61 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 = ? SQL ID: 4894BAFCF6DC1D06E8D69FAED05791CC SQL Text: select * from `eeo_course_member` where `user_id` = ? and `identity` = ? and `state` = ? and `is_del` = ? SQL ID: 7C895CA99D111B696EE33230828BDCC2 SQL Text: INSERT INTO __all_tablet_meta_table (tenant_id, tablet_id, svr_ip, svr_port, ls_id, compaction_scn, data_size, required_size) VALUES (?,?,?,?,?,?,?,?) ON DUPLICATE KEY UPDATE tenant_id=VALUES(tenant_id),tablet_id=VALUES(tablet_id),svr_ip=VALUES(svr_ip),svr_port=VALUES(svr_port),ls_id=VALUES(ls_id),compaction_scn=VALUES(compaction_scn),data_size=VALUES(data_size),required_size=VALUES(required_size) SQL ID: C52E3CCBE8BC80A60D7D681324474B81 SQL Text: select class_id,identity,member_uid,is_late,is_early,stayin_time from eeo_class_member_time where class_id in (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)and member_uid in (?) SQL ID: 3CB7F81D3C8F937B1A01F60A8CECD61D SQL Text: select class_id,member_uid,is_on,member_nickname,platform_type,identity from eeo_class_member_time where class_id in (?,?,?,?,?) SQL ID: 1D0BA376E273B9D622641124D8C59264 SQL Text: COMMIT SQL ID: DB4278BED84685EF86C0C5485852A1FC SQL Text: INSERT INTO `eeo_storage_flow` (`uniq_key`,`org_id`,`course_id`,`class_id`,`activity_id`,`scence`,`file_id`,`file_size`,`is_count_num`,`action`,`business_id`,`ext`,`op_uid`,`op_time`,`es_time`,`created_time`,`updated_time`,`op_created_time`,`record_source_type`,`event_time`) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,? SQL ID: BB636FC09FE91F3EF91E3055E773BD1D SQL Text: INSERT INTO `eeo_storage_flow` (`uniq_key`,`org_id`,`course_id`,`class_id`,`activity_id`,`scence`,`file_id`,`file_size`,`is_count_num`,`action`,`business_id`,`ext`,`op_uid`,`op_time`,`es_time`,`created_time`,`updated_time`,`op_created_time`,`record_source_type`,`event_time`) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,? SQL ID: 1639359F37F8F0D9D719891FFBBE0AF9 SQL Text: INSERT INTO `eeo_storage_flow` (`uniq_key`,`org_id`,`course_id`,`class_id`,`activity_id`,`scence`,`file_id`,`file_size`,`is_count_num`,`action`,`business_id`,`ext`,`op_uid`,`op_time`,`es_time`,`created_time`,`updated_time`,`op_created_time`,`record_source_type`,`event_time`) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,? SQL ID: 9E4BDC6B4F79BDCC745EC2D569FD262D SQL Text: INSERT INTO `eeo_storage_flow` (`uniq_key`,`org_id`,`course_id`,`class_id`,`activity_id`,`scence`,`file_id`,`file_size`,`is_count_num`,`action`,`business_id`,`ext`,`op_uid`,`op_time`,`es_time`,`created_time`,`updated_time`,`op_created_time`,`record_source_type`,`event_time`) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ON DUPLICATE KEY UPDATE `id`=`id` SQL ID: 9BD2CBDD5EA9F75F7F51B770FCC9796C SQL Text: SELECT * FROM `eeo_course_member` WHERE `eeo_course_member`.`identity` IN (?,?) AND `eeo_course_member`.`course_id` IN (?,?,?,?,?,?,?,?,?,?) AND `eeo_course_member`.`state` IN (?,?) SQL ID: CBCF2AB396DC0A7452D51A38921A9D29 SQL Text: SELECT id,org_id,es_time,scence,action,business_id,file_size FROM `eeo_storage_flow` WHERE uniq_key in (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) SQL ID: 1CF3EA3A1E2A9438A65E2EAD3F62CD78 SQL Text: INSERT INTO `eeo_storage_flow` (`uniq_key`,`org_id`,`course_id`,`class_id`,`activity_id`,`scence`,`file_id`,`file_size`,`is_count_num`,`action`,`business_id`,`ext`,`op_uid`,`op_time`,`es_time`,`created_time`,`updated_time`,`op_created_time`,`record_source_type`,`event_time`) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ON DUPLICATE KEY UPDATE `id`=`id` SQL ID: D2CD224FE21C387E9844DA64F0EE14BE SQL Text: SELECT id,class_id,member_uid,is_late,is_early FROM eeo_class_member_time WHERE school_uid = ? AND member_uid IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND id > ? ORDER BY id ASC LIMIT ? SQL ID: BBE4A84206F5EE14F10FEED776EA87A8 SQL Text: SELECT id FROM eeo_course_homework_log WHERE ? AND stu_homework_id = ? ORDER BY add_time DESC SQL ID: E5E8C0FA607CF00048C4600D7C76B053 SQL Text: INSERT INTO `eeo_storage_flow` (`uniq_key`,`org_id`,`course_id`,`class_id`,`activity_id`,`scence`,`file_id`,`file_size`,`is_count_num`,`action`,`business_id`,`ext`,`op_uid`,`op_time`,`es_time`,`created_time`,`updated_time`,`op_created_time`,`record_source_type`,`event_time`) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ON DUPLICATE KEY UPDATE `id`=`id` SQL ID: 78AB91580E8F1C5DC4AB96D6EFB03A4E SQL Text: SELECT * FROM `eeo_course_member` WHERE `eeo_course_member`.`identity` IN (?,?) AND `eeo_course_member`.`course_id` = ? AND `eeo_course_member`.`state` IN (?,?) SQL ID: 5A0107802B05FF35D66D09AB09399AAF SQL Text: SELECT * FROM `eeo_course_homework_log` WHERE stu_homework_id = ? SQL ID: D26B4A01511736CC33FBA2C680279E3C SQL Text: SELECT * FROM `eeo_course_member` WHERE `eeo_course_member`.`user_id` = ? AND `eeo_course_member`.`state` IN (?,?,?) AND `eeo_course_member`.`course_id` = ? SQL ID: D2A7C1A8F866E25C0B776F3BFB3AFAD7 SQL Text: select /*+ MONITOR_AGENT QUERY_TIMEOUT(100000000) */ distinct sql_id, statement from `V$OB_PLAN_CACHE_PLAN_STAT` where svr_ip = ? and svr_port = ? and sql_id in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, SQL ID: 2228E30A01DC25FA73859449FE1FE1FA SQL Text: SELECT * FROM eeo_class_member_time where class_id=? and member_uid=? ORDER BY add_time ASC SQL ID: BCD700721DEF129AC65746D748A95A79 SQL Text: SELECT COALESCE(t1.TENANT_ID, ?) as TENANT_ID, TENANT_NAME, SUM(MAX_CPU) AS MAX_CPU, SUM(MIN_CPU) AS MIN_CPU, SUM(MAX_MEMORY) AS MAX_MEMORY, SUM(MIN_MEMORY) AS MIN_MEMORY, SUM(LOG_DISK_SIZE) AS LOG_DISK_SIZE, SUM(LOG_DISK_IN_USE) AS LOG_DISK_IN_USE, SUM(DATA_DISK_IN_USE) AS DATA_DISK_IN_USE FROM (SELECT T1.UNIT_ID, T1.SVR_IP, T1.SVR_PORT, T1.ZONE, T2.TENANT_ID, T1.MIN_CPU, T1.MAX_CPU, T1.MIN_MEMORY, T1.MAX_MEMORY, T1.MIN_IOPS, T1.MAX_IOPS, T1.IOPS_WEIGHT, T1.LOG_DISK_SIZE, T1.LOG_DISK_IN_USE, T1.DATA_DISK_IN_USE FROM (SELECT UNIT_ID, SVR_IP, SVR_PORT, ZONE, SUM(MIN_CPU) AS MIN_CPU, SUM(MAX_CPU) AS MAX_CPU, SUM(MEMORY_SIZE) AS MIN_MEMORY, SUM(MEMORY_SIZE) AS MAX_MEMORY, SUM(MIN_IOPS) AS MIN_IOPS, SUM(MAX_IOPS) AS MAX_IOPS, SUM(IOPS_WEIGHT) AS IOPS_WEIGHT, SUM(LOG_DISK_SIZE) AS LOG_DISK_SIZE, SUM(LOG_DISK_IN_USE) AS LOG_DISK_IN_USE, SUM(DATA_DISK_IN_USE) AS DATA_DISK_IN_USE FROM oceanbase.GV$OB_UNITS GROUP BY UNIT_ID, SVR_IP, SVR_PORT ) T1 JOIN oceanbase.DBA_OB_UNITS T2 ON T1.UNIT_ID = T2.UNIT_ID AND T1 SQL ID: F1AC6CF080A08605F614082567766503 SQL Text: select class_id,identity,member_uid,is_late,is_early,stayin_time from eeo_class_member_time where class_id in (?,?,?,?,?,?)and member_uid in (?) SQL ID: 7552981DDE94F072F7A7DE3C4061EC93 SQL Text: SELECT * FROM `eeo_course_member` WHERE user_id = ? AND state IN (?) AND identity IN (?,?,?,?) AND is_del = ? ORDER BY is_top desc,sort desc,lms_activity_latest_time desc,join_time desc,updated_at desc, id desc LIMIT ?