obdiag version: 3.7.2 observer version: 4.2.5.5 ASH Report Cluster Name: eeoob012 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-31 09:30:00 User Input End Time: 2025-12-31 10:30:00 Ash Analysis Begin Time: 2025-12-31 09:30:00 Ash Analysis End Time: 2025-12-31 10:29:59 Ash Data Source: oceanbase.GV$ACTIVE_SESSION_HISTORY Elapsed Time: 3598 Ash Num of Sample: 33245 Average Active Sessions: 9.24 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| +----------------------------------------------------------------+------------+------------------+-----------------------+-------------------+--------------------+-----------+------------------------+ | sys| BACKGROUND| 17837| 11364| 6473| 4.96| 53.65%| -| | flowin| BACKGROUND| 8433| 1737| 6696| 2.34| 25.37%| -| | flowin| FOREGROUND| 5055| 2657| 2398| 1.41| 15.21%| 1.41| | sys| FOREGROUND| 979| 119| 860| 0.27| 2.94%| 0.27| | META$1002| BACKGROUND| 941| 305| 636| 0.26| 2.83%| -| +----------------------------------------------------------------+------------+------------------+-----------------------+-------------------+--------------------+-----------+------------------------+ Top Node Load: - this section lists top node measured by DB time - IP: OceanBase instance svr_ip - Port: OceanBase instance svr_port - Total Samples: num of records during ash report analysis time period - Wait Event Samples: num of records when session is on wait event - On CPU Samples: num of records when session is on cpu - Avg Active Sessions: average active sessions during ash report analysis time period - % Activity: activity(cpu + wait) percentage for given tenant - Equivalent Client Load: equivalent client average active sessions during ash report analysis time period +----------------+-------+------------+------------------+-----------------------+-------------------+--------------------+-----------+------------------------+ | IP| Port|Session Type| Total Samples| Wait Event Samples| On CPU Samples| Avg Active Sessions| % Activity| Equivalent Client Load| +----------------+-------+------------+------------------+-----------------------+-------------------+--------------------+-----------+------------------------+ | 10.1.43.152| 2882| BACKGROUND| 9669| 4591| 5078| 2.69| 29.08%| -| | 10.1.43.153| 2882| BACKGROUND| 9488| 4612| 4876| 2.64| 28.54%| -| | 10.1.43.151| 2882| BACKGROUND| 8054| 4203| 3851| 2.24| 24.23%| -| | 10.1.43.152| 2882| FOREGROUND| 2156| 880| 1276| 0.60| 6.49%| 6.46| | 10.1.43.153| 2882| FOREGROUND| 2149| 996| 1153| 0.60| 6.46%| 6.26| | 10.1.43.151| 2882| FOREGROUND| 1729| 900| 829| 0.48| 5.20%| 3.44| +----------------+-------+------------+------------------+-----------------------+-------------------+--------------------+-----------+------------------------+ 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.152:2882| cgroup//tenant_0001//OBCG_DEFAULT| 3992| 12.01%| SyslogCompress| 10.41%| SyslogCompress| 10.41%| UNDEFINED| 10.41%| 0.96| | | | | | pnio1| 1.60%| pnio1| 1.60%| UNDEFINED| 1.60%| 0.15| | | cgroup//tenant_1002//OBCG_DEFAULT| 3837| 11.54%| T1002_SQL_CMD| 5.41%| ReqWorker(Level:0)| 5.41%| COM_QUERY| 5.41%| 0.50| | | | | | T1002_LogService| 3.96%| LogArchiveService| 2.75%| ArchiveSender| 2.75%| 0.26| | | | | | | | LogIOWorker| 1.20%| aggregate io task| 1.20%| 0.11| | | | | | T1002_RPC_REQUEST| 2.17%| ReqWorker(Level:0)| 2.17%| FastDFO| 1.10%| 0.10| | | | | | | | | | OB_PX_FAST_INIT_SQC| 1.07%| 0.10| | 10.1.43.153:2882| cgroup//tenant_0001//OBCG_DEFAULT| 3982| 11.98%| SyslogCompress| 10.40%| SyslogCompress| 10.40%| UNDEFINED| 10.40%| 0.96| | | | | | pnio1| 1.57%| pnio1| 1.57%| UNDEFINED| 1.57%| 0.14| | | cgroup//tenant_1002//OBCG_DEFAULT| 3508| 10.55%| T1002_SQL_CMD| 5.52%| ReqWorker(Level:0)| 5.52%| COM_QUERY| 5.52%| 0.51| | | | | | T1002_LogService| 4.03%| LogArchiveService| 2.78%| ArchiveSender| 2.78%| 0.26| | | | | | | | LogIOWorker| 1.25%| aggregate io task| 1.25%| 0.12| | | | | | T1002_RPC_REQUEST| 1.00%| ReqWorker(Level:0)| 1.00%| OB_PX_FAST_INIT_SQC| 1.00%| 0.09| | 10.1.43.151:2882| cgroup//tenant_0001//OBCG_DEFAULT| 4559| 13.71%| SyslogCompress| 10.57%| SyslogCompress| 10.57%| UNDEFINED| 10.57%| 0.98| | | | | | DynamicThreadPool| 1.99%| DynamicMgrCheck| 1.99%| detect task| 1.99%| 0.18| | | | | | T1_SQL_CMD| 1.16%| ReqWorker(Level:0)| 1.16%| COM_QUERY| 1.16%| 0.11| | | cgroup//tenant_1002//OBCG_DEFAULT| 2204| 6.63%| T1002_SQL_CMD| 3.98%| ReqWorker(Level:0)| 3.98%| COM_QUERY| 3.98%| 0.37| | | | | | T1002_LogService| 2.65%| LogArchiveService| 2.65%| ArchiveSender| 2.65%| 0.24| +----------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------+-------------+-----------+----------------------------------------------------------------+-----------+--------------------------------+-----------+--------------------------------+-----------+--------------------+ +----------------------------+-------------+--------------------------------------------------------------------------------------------------------------------------------+--------------------+-----------+--------------------+ | Slot Begin Time| Slot Count| Action Key| Action Samples| % Activity| Avg Active Sessions| +----------------------------+-------------+--------------------------------------------------------------------------------------------------------------------------------+--------------------+-----------+--------------------+ | 2025-12-31 09:30:00(+360s)| 3102| 10.1.43.151:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 351| 11.31%| 0.97| | | | 10.1.43.152:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 346| 11.15%| 0.96| | | | 10.1.43.153:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 345| 11.12%| 0.96| | | | 10.1.43.153:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 191| 6.16%| 0.53| | | | 10.1.43.152:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 119| 3.84%| 0.33| | | | 10.1.43.151:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogArchiveService-ArchiveSender| 113| 3.64%| 0.31| | | | 10.1.43.151:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 110| 3.55%| 0.31| | | | 10.1.43.152:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogArchiveService-ArchiveSender| 101| 3.26%| 0.28| | | | 10.1.43.153:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogArchiveService-ArchiveSender| 88| 2.84%| 0.24| | | | 10.1.43.151:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-DynamicThreadPool-DynamicMgrCheck-detect task| 70| 2.26%| 0.19| | | | 10.1.43.153:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-pnio1-pnio1-UNDEFINED| 41| 1.32%| 0.11| | | | 10.1.43.152:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-pnio1-pnio1-UNDEFINED| 39| 1.26%| 0.11| | | | 10.1.43.153:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogIOWorker-aggregate io task| 32| 1.03%| 0.09| | | | 10.1.43.153:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-OB_PX_FAST_INIT_SQC| 31| 1.00%| 0.09| | | | 10.1.43.151:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 28| 0.90%| 0.08| | | | 10.1.43.152:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-FastDFO| 26| 0.84%| 0.07| | | | 10.1.43.152:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogIOWorker-aggregate io task| 24| 0.77%| 0.07| | | | 10.1.43.152:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-OB_PX_FAST_INIT_SQC| 19| 0.61%| 0.05| | 2025-12-31 09:36:00(+360s)| 3352| 10.1.43.151:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 352| 10.50%| 0.98| | | | 10.1.43.153:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 346| 10.32%| 0.96| | | | 10.1.43.152:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 346| 10.32%| 0.96| | | | 10.1.43.152:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 191| 5.70%| 0.53| | | | 10.1.43.153:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 183| 5.46%| 0.51| | | | 10.1.43.151:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogArchiveService-ArchiveSender| 127| 3.79%| 0.35| | | | 10.1.43.152:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogArchiveService-ArchiveSender| 102| 3.04%| 0.28| | | | 10.1.43.151:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 100| 2.98%| 0.28| | | | 10.1.43.153:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogArchiveService-ArchiveSender| 82| 2.45%| 0.23| | | | 10.1.43.151:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-DynamicThreadPool-DynamicMgrCheck-detect task| 76| 2.27%| 0.21| | | | 10.1.43.153:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-pnio1-pnio1-UNDEFINED| 55| 1.64%| 0.15| | | | 10.1.43.152:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-pnio1-pnio1-UNDEFINED| 53| 1.58%| 0.15| | | | 10.1.43.153:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogIOWorker-aggregate io task| 47| 1.40%| 0.13| | | | 10.1.43.151:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 46| 1.37%| 0.13| | | | 10.1.43.152:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogIOWorker-aggregate io task| 45| 1.34%| 0.12| | | | 10.1.43.153:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-OB_PX_FAST_INIT_SQC| 26| 0.78%| 0.07| | | | 10.1.43.152:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-FastDFO| 24| 0.72%| 0.07| | | | 10.1.43.152:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-OB_PX_FAST_INIT_SQC| 22| 0.66%| 0.06| | 2025-12-31 09:42:00(+360s)| 3241| 10.1.43.151:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 351| 10.83%| 0.97| | | | 10.1.43.153:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 346| 10.68%| 0.96| | | | 10.1.43.152:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 346| 10.68%| 0.96| | | | 10.1.43.153:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 206| 6.36%| 0.57| | | | 10.1.43.152:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 158| 4.88%| 0.44| | | | 10.1.43.151:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 97| 2.99%| 0.27| | | | 10.1.43.153:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogArchiveService-ArchiveSender| 92| 2.84%| 0.26| | | | 10.1.43.152:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogArchiveService-ArchiveSender| 87| 2.68%| 0.24| | | | 10.1.43.151:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-DynamicThreadPool-DynamicMgrCheck-detect task| 66| 2.04%| 0.18| | | | 10.1.43.153:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-pnio1-pnio1-UNDEFINED| 53| 1.64%| 0.15| | | | 10.1.43.152:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-pnio1-pnio1-UNDEFINED| 44| 1.36%| 0.12| | | | 10.1.43.153:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogIOWorker-aggregate io task| 35| 1.08%| 0.10| | | | 10.1.43.152:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-FastDFO| 33| 1.02%| 0.09| | | | 10.1.43.152:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogIOWorker-aggregate io task| 33| 1.02%| 0.09| | | | 10.1.43.151:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 29| 0.90%| 0.08| | | | 10.1.43.153:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-OB_PX_FAST_INIT_SQC| 27| 0.83%| 0.07| | | | 10.1.43.152:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-OB_PX_FAST_INIT_SQC| 25| 0.77%| 0.07| | | | 10.1.43.151:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogArchiveService-ArchiveSender| 14| 0.43%| 0.04| | 2025-12-31 09:48:00(+360s)| 3221| 10.1.43.151:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 352| 10.93%| 0.98| | | | 10.1.43.153:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 346| 10.74%| 0.96| | | | 10.1.43.152:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 346| 10.74%| 0.96| | | | 10.1.43.152:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 169| 5.25%| 0.47| | | | 10.1.43.153:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 135| 4.19%| 0.38| | | | 10.1.43.151:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 123| 3.82%| 0.34| | | | 10.1.43.153:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogArchiveService-ArchiveSender| 98| 3.04%| 0.27| | | | 10.1.43.152:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogArchiveService-ArchiveSender| 88| 2.73%| 0.24| | | | 10.1.43.151:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-DynamicThreadPool-DynamicMgrCheck-detect task| 80| 2.48%| 0.22| | | | 10.1.43.152:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-pnio1-pnio1-UNDEFINED| 60| 1.86%| 0.17| | | | 10.1.43.152:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogIOWorker-aggregate io task| 57| 1.77%| 0.16| | | | 10.1.43.151:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogArchiveService-ArchiveSender| 47| 1.46%| 0.13| | | | 10.1.43.153:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-pnio1-pnio1-UNDEFINED| 43| 1.33%| 0.12| | | | 10.1.43.153:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogIOWorker-aggregate io task| 42| 1.30%| 0.12| | | | 10.1.43.151:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 38| 1.18%| 0.11| | | | 10.1.43.152:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-OB_PX_FAST_INIT_SQC| 37| 1.15%| 0.10| | | | 10.1.43.153:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-OB_PX_FAST_INIT_SQC| 28| 0.87%| 0.08| | | | 10.1.43.152:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-FastDFO| 26| 0.81%| 0.07| | 2025-12-31 09:54:00(+360s)| 3285| 10.1.43.151:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 351| 10.69%| 0.97| | | | 10.1.43.153:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 346| 10.53%| 0.96| | | | 10.1.43.152:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 346| 10.53%| 0.96| | | | 10.1.43.152:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 188| 5.72%| 0.52| | | | 10.1.43.153:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 174| 5.30%| 0.48| | | | 10.1.43.151:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 136| 4.14%| 0.38| | | | 10.1.43.153:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogArchiveService-ArchiveSender| 102| 3.10%| 0.28| | | | 10.1.43.151:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogArchiveService-ArchiveSender| 98| 2.98%| 0.27| | | | 10.1.43.152:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogArchiveService-ArchiveSender| 87| 2.65%| 0.24| | | | 10.1.43.151:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-DynamicThreadPool-DynamicMgrCheck-detect task| 65| 1.98%| 0.18| | | | 10.1.43.152:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-pnio1-pnio1-UNDEFINED| 48| 1.46%| 0.13| | | | 10.1.43.153:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-pnio1-pnio1-UNDEFINED| 47| 1.43%| 0.13| | | | 10.1.43.151:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 44| 1.34%| 0.12| | | | 10.1.43.153:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogIOWorker-aggregate io task| 44| 1.34%| 0.12| | | | 10.1.43.153:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-OB_PX_FAST_INIT_SQC| 39| 1.19%| 0.11| | | | 10.1.43.152:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogIOWorker-aggregate io task| 34| 1.03%| 0.09| | | | 10.1.43.152:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-FastDFO| 34| 1.03%| 0.09| | | | 10.1.43.152:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-OB_PX_FAST_INIT_SQC| 22| 0.67%| 0.06| | 2025-12-31 10:00:00(+360s)| 3246| 10.1.43.151:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 352| 10.84%| 0.98| | | | 10.1.43.152:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 346| 10.66%| 0.96| | | | 10.1.43.153:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 346| 10.66%| 0.96| | | | 10.1.43.153:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 183| 5.64%| 0.51| | | | 10.1.43.152:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 181| 5.58%| 0.50| | | | 10.1.43.151:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogArchiveService-ArchiveSender| 132| 4.07%| 0.37| | | | 10.1.43.151:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 98| 3.02%| 0.27| | | | 10.1.43.153:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogArchiveService-ArchiveSender| 93| 2.87%| 0.26| | | | 10.1.43.152:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogArchiveService-ArchiveSender| 78| 2.40%| 0.22| | | | 10.1.43.151:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-DynamicThreadPool-DynamicMgrCheck-detect task| 72| 2.22%| 0.20| | | | 10.1.43.152:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-pnio1-pnio1-UNDEFINED| 51| 1.57%| 0.14| | | | 10.1.43.151:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 43| 1.32%| 0.12| | | | 10.1.43.153:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-pnio1-pnio1-UNDEFINED| 43| 1.32%| 0.12| | | | 10.1.43.152:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogIOWorker-aggregate io task| 38| 1.17%| 0.11| | | | 10.1.43.153:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogIOWorker-aggregate io task| 35| 1.08%| 0.10| | | | 10.1.43.153:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-OB_PX_FAST_INIT_SQC| 29| 0.89%| 0.08| | | | 10.1.43.152:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-OB_PX_FAST_INIT_SQC| 28| 0.86%| 0.08| | | | 10.1.43.152:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-FastDFO| 17| 0.52%| 0.05| | 2025-12-31 10:06:00(+360s)| 3389| 10.1.43.151:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 351| 10.36%| 0.97| | | | 10.1.43.152:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 346| 10.21%| 0.96| | | | 10.1.43.153:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 346| 10.21%| 0.96| | | | 10.1.43.152:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 224| 6.61%| 0.62| | | | 10.1.43.153:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 207| 6.11%| 0.57| | | | 10.1.43.151:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 136| 4.01%| 0.38| | | | 10.1.43.152:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogArchiveService-ArchiveSender| 96| 2.83%| 0.27| | | | 10.1.43.153:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogArchiveService-ArchiveSender| 89| 2.63%| 0.25| | | | 10.1.43.152:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-pnio1-pnio1-UNDEFINED| 64| 1.89%| 0.18| | | | 10.1.43.151:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogArchiveService-ArchiveSender| 56| 1.65%| 0.16| | | | 10.1.43.151:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-DynamicThreadPool-DynamicMgrCheck-detect task| 55| 1.62%| 0.15| | | | 10.1.43.153:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-pnio1-pnio1-UNDEFINED| 49| 1.45%| 0.14| | | | 10.1.43.153:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogIOWorker-aggregate io task| 43| 1.27%| 0.12| | | | 10.1.43.151:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 41| 1.21%| 0.11| | | | 10.1.43.152:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-OB_PX_FAST_INIT_SQC| 38| 1.12%| 0.11| | | | 10.1.43.152:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogIOWorker-aggregate io task| 34| 1.00%| 0.09| | | | 10.1.43.152:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-FastDFO| 32| 0.94%| 0.09| | | | 10.1.43.153:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-OB_PX_FAST_INIT_SQC| 31| 0.92%| 0.09| | 2025-12-31 10:12:00(+360s)| 3922| 10.1.43.151:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 352| 8.97%| 0.98| | | | 10.1.43.153:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 346| 8.82%| 0.96| | | | 10.1.43.152:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 346| 8.82%| 0.96| | | | 10.1.43.151:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 284| 7.24%| 0.79| | | | 10.1.43.152:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 271| 6.91%| 0.75| | | | 10.1.43.153:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 191| 4.87%| 0.53| | | | 10.1.43.151:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogArchiveService-ArchiveSender| 128| 3.26%| 0.36| | | | 10.1.43.152:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-FastDFO| 118| 3.01%| 0.33| | | | 10.1.43.152:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogArchiveService-ArchiveSender| 98| 2.50%| 0.27| | | | 10.1.43.152:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-OB_PX_FAST_INIT_SQC| 98| 2.50%| 0.27| | | | 10.1.43.153:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogArchiveService-ArchiveSender| 88| 2.24%| 0.24| | | | 10.1.43.153:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-pnio1-pnio1-UNDEFINED| 82| 2.09%| 0.23| | | | 10.1.43.152:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-pnio1-pnio1-UNDEFINED| 79| 2.01%| 0.22| | | | 10.1.43.153:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-OB_PX_FAST_INIT_SQC| 57| 1.45%| 0.16| | | | 10.1.43.151:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-DynamicThreadPool-DynamicMgrCheck-detect task| 52| 1.33%| 0.14| | | | 10.1.43.152:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogIOWorker-aggregate io task| 48| 1.22%| 0.13| | | | 10.1.43.153:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogIOWorker-aggregate io task| 43| 1.10%| 0.12| | | | 10.1.43.151:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 36| 0.92%| 0.10| | 2025-12-31 10:18:00(+360s)| 3320| 10.1.43.151:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 351| 10.57%| 0.97| | | | 10.1.43.153:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 347| 10.45%| 0.96| | | | 10.1.43.152:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 347| 10.45%| 0.96| | | | 10.1.43.153:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 176| 5.30%| 0.49| | | | 10.1.43.151:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 136| 4.10%| 0.38| | | | 10.1.43.152:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 135| 4.07%| 0.38| | | | 10.1.43.151:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogArchiveService-ArchiveSender| 119| 3.58%| 0.33| | | | 10.1.43.152:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogArchiveService-ArchiveSender| 91| 2.74%| 0.25| | | | 10.1.43.153:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogArchiveService-ArchiveSender| 82| 2.47%| 0.23| | | | 10.1.43.151:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-DynamicThreadPool-DynamicMgrCheck-detect task| 60| 1.81%| 0.17| | | | 10.1.43.153:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-pnio1-pnio1-UNDEFINED| 57| 1.72%| 0.16| | | | 10.1.43.152:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-pnio1-pnio1-UNDEFINED| 51| 1.54%| 0.14| | | | 10.1.43.151:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 47| 1.42%| 0.13| | | | 10.1.43.153:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogIOWorker-aggregate io task| 45| 1.35%| 0.12| | | | 10.1.43.152:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-OB_PX_FAST_INIT_SQC| 45| 1.35%| 0.12| | | | 10.1.43.153:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-OB_PX_FAST_INIT_SQC| 41| 1.24%| 0.11| | | | 10.1.43.152:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-FastDFO| 34| 1.02%| 0.09| | | | 10.1.43.152:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogIOWorker-aggregate io task| 34| 1.02%| 0.09| | 2025-12-31 10:24:00(+359s)| 3167| 10.1.43.151:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 351| 11.08%| 0.98| | | | 10.1.43.152:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 345| 10.89%| 0.96| | | | 10.1.43.153:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-SyslogCompress-SyslogCompress-UNDEFINED| 345| 10.89%| 0.96| | | | 10.1.43.153:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 189| 5.97%| 0.53| | | | 10.1.43.152:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 164| 5.18%| 0.46| | | | 10.1.43.153:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogArchiveService-ArchiveSender| 110| 3.47%| 0.31| | | | 10.1.43.151:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 102| 3.22%| 0.28| | | | 10.1.43.152:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogArchiveService-ArchiveSender| 88| 2.78%| 0.24| | | | 10.1.43.151:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-DynamicThreadPool-DynamicMgrCheck-detect task| 65| 2.05%| 0.18| | | | 10.1.43.153:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-pnio1-pnio1-UNDEFINED| 53| 1.67%| 0.15| | | | 10.1.43.152:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogIOWorker-aggregate io task| 52| 1.64%| 0.14| | | | 10.1.43.153:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogIOWorker-aggregate io task| 50| 1.58%| 0.14| | | | 10.1.43.151:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_LogService-LogArchiveService-ArchiveSender| 48| 1.52%| 0.13| | | | 10.1.43.152:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-pnio1-pnio1-UNDEFINED| 43| 1.36%| 0.12| | | | 10.1.43.151:2882-cgroup/background/tenant_0001//OBCG_DEFAULT-T1_SQL_CMD-ReqWorker(Level:0)-COM_QUERY| 32| 1.01%| 0.09| | | | 10.1.43.153:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-OB_PX_FAST_INIT_SQC| 24| 0.76%| 0.07| | | | 10.1.43.152:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-FastDFO| 23| 0.73%| 0.06| | | | 10.1.43.152:2882-cgroup/background/tenant_1002//OBCG_DEFAULT-T1002_RPC_REQUEST-ReqWorker(Level:0)-OB_PX_FAST_INIT_SQC| 21| 0.66%| 0.06| +----------------------------+-------------+--------------------------------------------------------------------------------------------------------------------------------+--------------------+-----------+--------------------+ 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.152:2882| ON CPU| NULL| 1276| 0.35| 3.84%| | | tx commiting wait| COMMIT| 421| 0.12| 1.27%| | | px loop condition wait| NETWORK| 228| 0.06| 0.69%| | | db file data read| USER_IO| 118| 0.03| 0.35%| | | wait in request queue| CONFIGURATION| 31| 0.01| 0.09%| | | sync get gts timestamp wait| NETWORK| 28| 0.01| 0.08%| | | das wait remote response| NETWORK| 20| 0.01| 0.06%| | | default condition wait| CONCURRENCY| 18| 0.01| 0.05%| | | row lock wait| APPLICATION| 9| 0.00| 0.03%| | | exec inner sql wait| OTHER| 6| 0.00| 0.02%| | 10.1.43.153:2882| ON CPU| NULL| 1153| 0.32| 3.47%| | | tx commiting wait| COMMIT| 454| 0.13| 1.37%| | | px loop condition wait| NETWORK| 293| 0.08| 0.88%| | | db file data read| USER_IO| 127| 0.04| 0.38%| | | sync get gts timestamp wait| NETWORK| 30| 0.01| 0.09%| | | wait in request queue| CONFIGURATION| 27| 0.01| 0.08%| | | default condition wait| CONCURRENCY| 27| 0.01| 0.08%| | | row lock wait| APPLICATION| 13| 0.00| 0.04%| | | exec inner sql wait| OTHER| 10| 0.00| 0.03%| | | das wait remote response| NETWORK| 9| 0.00| 0.03%| | | sync rpc| NETWORK| 5| 0.00| 0.01%| | 10.1.43.151:2882| ON CPU| NULL| 829| 0.23| 2.49%| | | px loop condition wait| NETWORK| 437| 0.12| 1.31%| | | tx commiting wait| COMMIT| 319| 0.09| 0.96%| | | db file data read| USER_IO| 66| 0.02| 0.20%| | | default condition wait| CONCURRENCY| 21| 0.01| 0.06%| | | wait in request queue| CONFIGURATION| 17| 0.01| 0.05%| | | exec inner sql wait| OTHER| 16| 0.00| 0.05%| | | das wait remote response| NETWORK| 14| 0.00| 0.04%| | | row lock wait| APPLICATION| 7| 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.152:2882| SyslogCompress| SyslogCompress| UNDEFINED| sleep wait| IDLE| 3451| 10.38%| 0.96| | | T1002_LogService| LogArchiveService| ArchiveSender| ON CPU| NULL| 916| 2.75%| 0.26| | | pnio1| pnio1| UNDEFINED| ON CPU| NULL| 532| 1.60%| 0.15| | | DynamicThreadPool| DynamicMgrCheck| detect task| ON CPU| NULL| 313| 0.94%| 0.09| | | T1002_RPC_REQUEST| ReqWorker(Level:0)| FastDFO| ON CPU| NULL| 268| 0.81%| 0.07| | | T1002_RPC_REQUEST| ReqWorker(Level:0)| OB_PX_FAST_INIT_SQC| ON CPU| NULL| 264| 0.79%| 0.07| | | T1002_LogService| LogIOWorker| aggregate io task| ON CPU| NULL| 209| 0.63%| 0.06| | | IOManager| SyncIO_Device:DeviceType:3/Medi| UNDEFINED| ON CPU| NULL| 204| 0.61%| 0.06| | | T1002_LogService| LogIOWorker| aggregate io task| palf write| SYSTEM_IO| 190| 0.57%| 0.05| | | BlkMgr| BlkMgr| UNDEFINED| ON CPU| NULL| 183| 0.55%| 0.05| | | T1002_LogService| LogReplayService| TRANS_SERVICE| ON CPU| NULL| 179| 0.54%| 0.05| | | KVCacheRep| KVCacheRep| UNDEFINED| ON CPU| NULL| 119| 0.36%| 0.03| | 10.1.43.153:2882| SyslogCompress| SyslogCompress| UNDEFINED| sleep wait| IDLE| 3449| 10.37%| 0.96| | | T1002_LogService| LogArchiveService| ArchiveSender| ON CPU| NULL| 924| 2.78%| 0.26| | | pnio1| pnio1| UNDEFINED| ON CPU| NULL| 523| 1.57%| 0.14| | | DynamicThreadPool| DynamicMgrCheck| detect task| ON CPU| NULL| 295| 0.89%| 0.08| | | T1002_RPC_REQUEST| ReqWorker(Level:0)| FastDFO| ON CPU| NULL| 258| 0.78%| 0.07| | | T1002_RPC_REQUEST| ReqWorker(Level:0)| OB_PX_FAST_INIT_SQC| ON CPU| NULL| 252| 0.76%| 0.07| | | T1002_LogService| LogIOWorker| aggregate io task| palf write| SYSTEM_IO| 236| 0.71%| 0.07| | | BlkMgr| BlkMgr| UNDEFINED| ON CPU| NULL| 216| 0.65%| 0.06| | | IOManager| SyncIO_Device:DeviceType:3/Medi| UNDEFINED| ON CPU| NULL| 193| 0.58%| 0.05| | | T1002_LogService| LogIOWorker| aggregate io task| ON CPU| NULL| 180| 0.54%| 0.05| | | T1002_LogService| LogReplayService| TRANS_SERVICE| ON CPU| NULL| 160| 0.48%| 0.04| | 10.1.43.151:2882| SyslogCompress| SyslogCompress| UNDEFINED| sleep wait| IDLE| 3511| 10.56%| 0.98| | | T1002_LogService| LogArchiveService| ArchiveSender| ON CPU| NULL| 882| 2.65%| 0.24| | | DynamicThreadPool| DynamicMgrCheck| detect task| ON CPU| NULL| 661| 1.99%| 0.18| | | pnio1| pnio1| UNDEFINED| ON CPU| NULL| 259| 0.78%| 0.07| | | BlkMgr| BlkMgr| UNDEFINED| ON CPU| NULL| 140| 0.42%| 0.04| | | T1002_RPC_REQUEST| ReqWorker(Level:0)| OB_PX_FAST_INIT_SQC| ON CPU| NULL| 127| 0.38%| 0.04| | | T1001_RPC_REQUEST| ReqWorker(Level:5)| OB_REMOTE_SYNC_EXECUTE| ON CPU| NULL| 124| 0.37%| 0.03| +----------------------------------------------------------------+-----------------------------------------------------------------+----------------------------------------------------------------+----------------------------------------------------------------+----------------------------------------------------------------+--------------------+-------------+-----------+--------------------+ Top Sessions: - this section lists top Active Sessions with the largest wait event and SQL_ID - Session ID: user session id - % Activity: represents the load on the database caused by this session - Avg Active Sessions: average active sessions during ash report analysis time period - Event Name: comprise wait event and on cpu event - % Event: represents the activity load of the event on the database - % SQL ID: represents the activity load of the event on the database - Sql Executions: represents the execution count of the SQL_ID +--------------------------------+--------------------+----------------------------------------------------------------+-----------+--------------------+----------------------------------------------------------------+--------------------+-----------+----------------------------------------+--------------------+-----------+--------------------+ | Node| Session ID| Program| % Activity| Avg Active Sessions| Event Name| Wait Class| % Event| SQL ID| Plan Hash| % SQL ID| Sql Executions| +--------------------------------+--------------------+----------------------------------------------------------------+-----------+--------------------+----------------------------------------------------------------+--------------------+-----------+----------------------------------------+--------------------+-----------+--------------------+ | 10.1.43.152:2882| 4294967295| T1002_SQL_CMD| 2.16%| 0.20| ON CPU| NULL| 1.12%| 030572EB4329CBF0455B3394248CF702|12823416512453717823| 0.10%| 32| | 10.1.43.151:2882| 4294967295| T1002_SQL_CMD| 1.81%| 0.17| ON CPU| NULL| 0.64%| F898845B5825FBCD7C4CC8F67188DB9D| 3290318591324336132| 0.05%| 16| | 10.1.43.153:2882| 3222910135| T1_SQL_CMD| 0.07%| 0.01| ON CPU| NULL| 0.07%| 011808F179CB4B77F6FD7D6CBFE54C70|13246721729889261947| 0.03%| 10| | 10.1.43.153:2882| 9566939| T1002_SQL_CMD| 0.04%| 0.00| ON CPU| NULL| 0.02%| 54A8B0E0FCD6397C5706051E7CE315FD|17337673821950778480| 0.01%| 3| | 10.1.43.153:2882| 9471518| T1002_SQL_CMD| 0.04%| 0.00| ON CPU| NULL| 0.02%| 54A8B0E0FCD6397C5706051E7CE315FD|17337673821950778480| 0.01%| 3| | 10.1.43.153:2882| 9484705| T1002_SQL_CMD| 0.04%| 0.00| ON CPU| NULL| 0.02%| AB083679B928CF882A1E38A28C822ED4| 4005357145445878169| 0.01%| 2| | 10.1.43.153:2882| 9244913| T1002_SQL_CMD| 0.04%| 0.00| px loop condition wait| NETWORK| 0.01%| 54A8B0E0FCD6397C5706051E7CE315FD|17337673821950778480| 0.01%| 4| | 10.1.43.153:2882| 9489660| T1002_SQL_CMD| 0.04%| 0.00| ON CPU| NULL| 0.02%| 54A8B0E0FCD6397C5706051E7CE315FD|17337673821950778480| 0.01%| 2| | 10.1.43.153:2882| 3223042159| T1_SQL_CMD| 0.03%| 0.00| ON CPU| NULL| 0.03%| 011808F179CB4B77F6FD7D6CBFE54C70|13246721729889261947| 0.02%| 8| | 10.1.43.153:2882| 3222904443| T1_SQL_CMD| 0.03%| 0.00| ON CPU| NULL| 0.03%| 011808F179CB4B77F6FD7D6CBFE54C70|13246721729889261947| 0.02%| 7| | 10.1.43.152:2882| 9502153| T1002_SQL_CMD| 0.03%| 0.00| ON CPU| NULL| 0.01%| 030572EB4329CBF0455B3394248CF702|12823416512453717823| 0.01%| 2| | 10.1.43.153:2882| 9559312| T1002_SQL_CMD| 0.03%| 0.00| px loop condition wait| NETWORK| 0.02%| 54A8B0E0FCD6397C5706051E7CE315FD|17337673821950778480| 0.01%| 4| | 10.1.43.153:2882| 9469342| T1002_SQL_CMD| 0.03%| 0.00| px loop condition wait| NETWORK| 0.02%| 54A8B0E0FCD6397C5706051E7CE315FD|17337673821950778480| 0.02%| 6| | 10.1.43.152:2882| 9242859| T1002_SQL_CMD| 0.03%| 0.00| ON CPU| NULL| 0.02%| 2FD45F34AA6A412A55010FB665262699| 3290318591324336132| 0.01%| 2| | 10.1.43.152:2882| 3222724372| T1_SQL_CMD| 0.03%| 0.00| ON CPU| NULL| 0.03%| 011808F179CB4B77F6FD7D6CBFE54C70|13246721729889261947| 0.01%| 4| +--------------------------------+--------------------+----------------------------------------------------------------+-----------+--------------------+----------------------------------------------------------------+--------------------+-----------+----------------------------------------+--------------------+-----------+--------------------+ 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.153:2882| DA490A84A94007EADA98F8CD374EF9B4| 3290318591324336132|disk_read| 656.81| 0.12| 12.61| 202793| 73.50%| | 10.1.43.151:2882| BlkMgr/BlkMgr/| 0|disk_read| 201.69| 1602.53| 1.03| 0| 100.00%| | 10.1.43.151:2882| OB_PLOG/OB_PLOG/flush log| 0|disk_write| 255.12| 3435.24| 0.96| 0| 100.00%| | 10.1.43.153:2882| BlkMgr/BlkMgr/| 0|disk_read| 186.15| 1726.39| 0.93| 0| 100.00%| | 10.1.43.152:2882| OB_PLOG/OB_PLOG/flush log| 0|disk_write| 515.37| 2703.48| 0.76| 0| 100.00%| | 10.1.43.153:2882| OB_PLOG/OB_PLOG/flush log| 0|disk_write| 555.76| 2602.48| 0.73| 0| 100.00%| | 10.1.43.152:2882| BlkMgr/BlkMgr/| 0|disk_read| 133.53| 1639.60| 0.67| 0| 100.00%| | 10.1.43.153:2882| T1002_LogService/LogIOWorker/| 0|disk_write| 75.72| 29.22| 0.45| 0| 100.00%| | 10.1.43.151:2882| T1002_LogService/LogIOWorker/| 0|disk_write| 69.06| 100.51| 0.37| 0| 100.00%| | 10.1.43.152:2882| T1002_LogService/LogIOWorker/| 0|disk_write| 61.71| 28.27| 0.35| 0| 100.00%| | 10.1.43.152:2882| T1002_LogService/LogIOWorker/aggregate io task| 0|disk_write| 51.52| 3892.86| 0.28| 0| 100.00%| | 10.1.43.151:2882| T1002_LogService/LogIOWorker/aggregate io task| 0|disk_write| 51.99| 3973.70| 0.28| 0| 100.00%| | 10.1.43.153:2882| T1002_LogService/LogIOWorker/aggregate io task| 0|disk_write| 48.87| 3949.82| 0.27| 0| 100.00%| | 10.1.43.153:2882| T1002_BFBuildTask/BFBuildTask/BloomFilterBuild| 0|disk_read| 0.08| 604.00| 0.17| 0| 100.00%| | 10.1.43.152:2882| T1002_BFBuildTask/BFBuildTask/BloomFilterBuild| 0|disk_read| 0.07| 494.00| 0.14| 0| 100.00%| | 10.1.43.151:2882| T1002_BFBuildTask/BFBuildTask/BloomFilterBuild| 0|disk_read| 0.06| 508.00| 0.12| 0| 100.00%| | 10.1.43.151:2882| T1001_LogService/LogIOWorker/aggregate io task| 0|disk_write| 16.39| 252.46| 0.08| 0| 100.00%| | 10.1.43.153:2882| T1001_LogService/LogIOWorker/aggregate io task| 0|disk_write| 16.35| 267.74| 0.08| 0| 100.00%| | 10.1.43.152:2882| T1001_LogService/LogIOWorker/aggregate io task| 0|disk_write| 16.34| 271.12| 0.08| 0| 100.00%| | 10.1.43.151:2882| T1001_LogService/LogIOWorker/| 0|disk_write| 16.33| 53.52| 0.07| 0| 100.00%| | 10.1.43.151:2882| T1_LogService/LogIOWorker/aggregate io task| 0|disk_write| 10.69| 129.66| 0.05| 0| 100.00%| | 10.1.43.153:2882| T1_LogService/LogIOWorker/aggregate io task| 0|disk_write| 10.65| 155.63| 0.05| 0| 100.00%| | 10.1.43.152:2882| T1_LogService/LogIOWorker/aggregate io task| 0|disk_write| 10.64| 177.71| 0.05| 0| 100.00%| | 10.1.43.153:2882| 26F2D7AD20DE3063C7F4503C14193039|12124592075257367552|disk_read| 1.93| 0.04| 0.03| 0| 100.00%| | 10.1.43.151:2882| T1002_OB_SLOG/OB_SLOG/| 0|disk_write| 3.98| 75.45| 0.02| 0| 100.00%| | 10.1.43.153:2882| T1002_OB_SLOG/OB_SLOG/| 0|disk_write| 3.94| 71.00| 0.02| 0| 100.00%| | 10.1.43.152:2882| T1002_OB_SLOG/OB_SLOG/| 0|disk_write| 3.94| 38.88| 0.02| 0| 100.00%| | 10.1.43.153:2882| C58AEF2369F4694647C57609F7DF7C4B| 4431026948490215674|disk_read| 0.92| 135.22| 0.01| 0| 100.00%| | 10.1.43.151:2882| 7FA32AD549CA88227A1088C2C2256B6F| 6826649499877304821|disk_read| 0.58| 6.39| 0.01| 0| 100.00%| | 10.1.43.152:2882| C7263E0998C5F9406F0B3CF579253E45| 8405552009312705707|disk_read| 0.54| 0.08| 0.01| 0| 100.00%| | 10.1.43.152:2882| T1002_SQL_CMD/ReqWorker(Level:0)/COM_QUERY| 0|disk_read| 0.54| 1.15| 0.01| 0| 100.00%| | 10.1.43.151:2882| E541BD894D0480331F6B902E58AA8E3F| 3064099486399723373|disk_read| 0.41| 2.96| 0.01| 0| 92.08%| | 10.1.43.152:2882| 93A8B291DF81247A444758413D7FDF10| 3290318591324336132|disk_read| 0.37| 1.43| 0.01| 0| 100.00%| | 10.1.43.153:2882| 02AA7F5750EAC1DB64E545056CBFFA0C| 583869931832102939|disk_read| 0.36| 0.89| 0.01| 0| 100.00%| | 10.1.43.152:2882| 3C4260CF19B9DCBC1F0246121D9AE59C| 6826649499877304821|disk_read| 0.33| 0.68| 0.01| 0| 100.00%| | 10.1.43.151:2882| 5ED8A99789AAF52019CA698995AE37F7| 1593217401381375274|disk_read| 0.33| 0.02| 0.01| 203265| 100.00%| | 10.1.43.153:2882| 62FF1D6D48FF7640F3477960EC13E383| 6826649499877304821|disk_read| 0.35| 2.20| 0.01|1152921504606848719| 100.00%| | 10.1.43.152:2882| 2785B4725E5E945F4F8F85B23067834D|14948923606666639154|disk_read| 0.34| 5.38| 0.01| 0| 94.53%| | 10.1.43.151:2882| E1D2B1B981FCA4B727071661E0BF6C59| 2489732910421245184|disk_read| 0.28| 0.07| 0.01| 200525| 100.00%| | 10.1.43.153:2882| 2A579E151A560F478BB368A264B65D11|15627431508134708034|disk_read| 0.35| 0.05| 0.01| 0| 100.00%| | 10.1.43.152:2882| 7814CE37785DA0BB822B76BE94D09874| 6826649499877304821|disk_read| 0.31| 2.26| 0.00| 0| 100.00%| | 10.1.43.153:2882| FE60C8CDF7810B473414E11DD9F90553| 6677271480225087236|disk_read| 0.30| 0.34| 0.00| 0| 100.00%| | 10.1.43.153:2882| A14F631A4B7DBD641FCB8072EE363EBD| 3290318591324336132|disk_read| 0.32| 0.58| 0.00| 0| 100.00%| | 10.1.43.152:2882| 87ADDDF50338E3353323474EC60EE3C1| 4703512215678714686|disk_read| 0.26| 0.96| 0.00| 0| 100.00%| | 10.1.43.153:2882| IO_HEALTH/IO_HEALTH/| 0|disk_read| 1.00| 8.81| 0.00| 0| 100.00%| | 10.1.43.152:2882| IO_HEALTH/IO_HEALTH/| 0|disk_read| 1.00| 29.14| 0.00| 0| 100.00%| | 10.1.43.152:2882| T1002_IOManager/DiskCB/| 0|disk_read| 1.02| 0.00| 0.00| 0| 100.00%| | 10.1.43.153:2882| 9F7D5738898A2E5CA15BFB2826CCE08F| 6826649499877304821|disk_read| 0.26| 5.58| 0.00|1152921504606848720| 100.00%| | 10.1.43.152:2882| B78E3CA5637E71BEC720195BFEC26E32| 8280351538984566557|disk_read| 0.22| 0.88| 0.00| 0| 100.00%| | 10.1.43.153:2882| 7814CE37785DA0BB822B76BE94D09874| 6826649499877304821|disk_read| 0.23| 5.12| 0.00| 0| 54.38%| +---------------------+------------------------------------------------------------------------------------------------+--------------------+--------+----------------+--------------------+--------------------+----------+------------+ 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| +---------------------+--------------------+--------------------+----------------------------------------------------------------+---------------------+----------------------------------------+----------------------------------------------------------------+--------------------+--------------------+----------------------------------------+--------------------+ | 3222542311| 0.01%| 0.00| UNKNOWN_USER| 18727270148| UNKNOWN_SQL_ID| row lock wait| 0.01%| 5| 8A72F944EC3CE291B416336C2955D9A7| 0.01%| | 3222318268| 0.01%| 0.00| UNKNOWN_USER| 18726570306| UNKNOWN_SQL_ID| row lock wait| 0.01%| 4| 8A72F944EC3CE291B416336C2955D9A7| 0.01%| | 3222808264| 0.01%| 0.00| UNKNOWN_USER| 18726652584| UNKNOWN_SQL_ID| row lock wait| 0.01%| 4| 8A72F944EC3CE291B416336C2955D9A7| 0.01%| | 3222290778| 0.01%| 0.00| UNKNOWN_USER| 18726867089| UNKNOWN_SQL_ID| row lock wait| 0.01%| 3| 8A72F944EC3CE291B416336C2955D9A7| 0.01%| | 3222818697| 0.01%| 0.00| UNKNOWN_USER| 18727358247| UNKNOWN_SQL_ID| row lock wait| 0.01%| 3| 8A72F944EC3CE291B416336C2955D9A7| 0.01%| | 3222600332| 0.01%| 0.00| UNKNOWN_USER| 18726666606| UNKNOWN_SQL_ID| row lock wait| 0.01%| 2| 8A72F944EC3CE291B416336C2955D9A7| 0.01%| | 3222620390| 0.00%| 0.00| UNKNOWN_USER| 18727417251| UNKNOWN_SQL_ID| row lock wait| 0.00%| 1| CD91935A6C58176A38E0552FDBDFA0BE| 0.00%| | 3222624459| 0.00%| 0.00| UNKNOWN_USER| 18726726969| UNKNOWN_SQL_ID| row lock wait| 0.00%| 1| 2FD45F34AA6A412A55010FB665262699| 0.00%| | 3222803859| 0.00%| 0.00| eo_cosys_rw| 18726698221| CD91935A6C58176A38E0552FDBDFA0BE| row lock wait| 0.00%| 1| CD91935A6C58176A38E0552FDBDFA0BE| 0.00%| | 3222827501| 0.00%| 0.00| UNKNOWN_USER| 18726979239| UNKNOWN_SQL_ID| row lock wait| 0.00%| 1| E1006FC969855AD8770C0D2DC383F44D| 0.00%| | 3222827507| 0.00%| 0.00| UNKNOWN_USER| 18727431765| UNKNOWN_SQL_ID| row lock wait| 0.00%| 1| E1006FC969855AD8770C0D2DC383F44D| 0.00%| | 3222904048| 0.00%| 0.00| UNKNOWN_USER| 18727130305| UNKNOWN_SQL_ID| row lock wait| 0.00%| 1| F898845B5825FBCD7C4CC8F67188DB9D| 0.00%| +---------------------+--------------------+--------------------+----------------------------------------------------------------+---------------------+----------------------------------------+----------------------------------------------------------------+--------------------+--------------------+----------------------------------------+--------------------+ Top Latchs: - this section lists top latches - Latch Wait Event: event that waiting for latch - Event Samples: num of sampled session activity records - % Activity: activity percentage for given event - Avg Active Sessions: average active sessions during ash report analysis time period +----------------------------------------------------------------+-------------+-----------+--------------------+ | Latch Wait Event|Event Samples| % Activity| Avg Active Sessions| +----------------------------------------------------------------+-------------+-----------+--------------------+ | latch: ash lock wait| 6| 0.02%| 0.00| +----------------------------------------------------------------+-------------+-----------+--------------------+ Top DB Objects: - With respect to Application, Cluster, User I/O and buffer busy waits only. - Object ID: tablet_id of the database table. - Avg Active Sessions: average active sessions during ash report analysis time period. - % Activity:the load on the database caused by accessing the databsae object. - Execution Count:represents how many executions involve this object - Event:When accessing the object, the corresponding Top waiting events (up to 5 are printed). - % Event:The percentage of the corresponding Top wait events when accessing the object (up to 5 events are printed). - SQL ID:the SQL ID with the highest load when accessing the object and in the wait event. - %SQL ID/Module:The percentage of SQL ID or Module with the highest load in this wait event when accessing the object. - Object Name (Type/ Partition Name):the name and type/partition_name of the database object being accessed +-------------------------+--------------------+--------------------+--------------------+--------------------+--------------------+----------------------------------------------------------------+--------------------+----------------------------------------------------------------+--------------------+--------------------------------------------------------------------------------------------------------------------------------+ | Node Address| Tenant ID| Object ID| Avg Active Sessions| % Activity| Execution Count| Event| % Event| SQL ID| %SQL ID/Module| Object Name (Type/Partition Name)| +-------------------------+--------------------+--------------------+--------------------+--------------------+--------------------+----------------------------------------------------------------+--------------------+----------------------------------------------------------------+--------------------+--------------------------------------------------------------------------------------------------------------------------------+ | 10.1.43.152:2882| 1| 11004| 0.02| 0.24%| 81| ON CPU| 0.24%| 08282664B36C5230B0D579753DA5D92E| 0.00%| oceanbase.__all_virtual_plan_stat| | | 1| 11017| 0.01| 0.12%| 40| ON CPU| 0.12%| 1DF15473BF500C0D6F79C1C41FDCE4CC| 0.06%| oceanbase.__all_virtual_system_event| | | 1| 12287| 0.01| 0.12%| 39| ON CPU| 0.12%| DBCB5D52A5E14718345165081BC7EAE4| 0.12%| oceanbase.__all_virtual_ls_info| | | 1| 12239| 0.01| 0.08%| 4| exec inner sql wait| 0.05%| 468F773521ACD3F81205B6EB7B6E4174| 0.00%| oceanbase.__all_virtual_ls_meta_table| | | | | | | | ON CPU| 0.03%| 468F773521ACD3F81205B6EB7B6E4174| 0.01%| | | | 1002| 202731| 0.01| 0.07%| 22| ON CPU| 0.07%| 55C3E17DD1242A38678CEB6F52A83FEE| 0.07%| eo_coflowin.benefit_record_item(p5)| | | 1| 11021| 0.01| 0.07%| 22| ON CPU| 0.07%| 3422DF64D50F313DB8A160E38C396B10| 0.01%| oceanbase.__all_virtual_sysstat| | | 1002| 1152921504606853472| 0.01| 0.06%| 19| ON CPU| 0.06%| A7D4C06B9A297170EB4E44D2B0E9E146| 0.03%| co_converter.task_queue.idx_stcs| | | 1| 11008| 0.01| 0.05%| 18| ON CPU| 0.05%| D950AAAD6DBD4DD227884EBFAC784569| 0.05%| oceanbase.__all_virtual_kvcache_info| | | 1002| 1152921504606848405| 0.01| 0.05%| 18| ON CPU| 0.05%| 030572EB4329CBF0455B3394248CF702| 0.05%| eo_cosys.collection_node_snapshot.uniq_cnc(p92)| | | 1| 11031| 0.00| 0.04%| 15| ON CPU| 0.04%| 011808F179CB4B77F6FD7D6CBFE54C70| 0.04%| oceanbase.__all_virtual_sql_audit| | | 1002| 49403| 0.00| 0.04%| 0| ON CPU| 0.04%| LogReplayService.TRANS_SERVICE| 0.04%| | | | 1002| 202735| 0.00| 0.04%| 12| ON CPU| 0.04%| 55C3E17DD1242A38678CEB6F52A83FEE| 0.04%| eo_coflowin.benefit_record_item(p9)| | 10.1.43.153:2882| 1| 11004| 0.02| 0.17%| 56| ON CPU| 0.17%| 1A03C07391F257A2D5053CB5DDA50D25| 0.00%| oceanbase.__all_virtual_plan_stat| | | 1| 12287| 0.01| 0.12%| 41| ON CPU| 0.12%| DBCB5D52A5E14718345165081BC7EAE4| 0.12%| oceanbase.__all_virtual_ls_info| | | 1| 11017| 0.01| 0.10%| 34| ON CPU| 0.10%| 1DF15473BF500C0D6F79C1C41FDCE4CC| 0.04%| oceanbase.__all_virtual_system_event| | | 1| 12239| 0.01| 0.07%| 4| exec inner sql wait| 0.04%| 468F773521ACD3F81205B6EB7B6E4174| 0.00%| oceanbase.__all_virtual_ls_meta_table| | | | | | | | ON CPU| 0.03%| 468F773521ACD3F81205B6EB7B6E4174| 0.01%| | | | 1| 11031| 0.01| 0.06%| 21| ON CPU| 0.06%| 011808F179CB4B77F6FD7D6CBFE54C70| 0.06%| oceanbase.__all_virtual_sql_audit| | | 1| 11021| 0.01| 0.06%| 20| ON CPU| 0.06%| 3422DF64D50F313DB8A160E38C396B10| 0.01%| oceanbase.__all_virtual_sysstat| | | 1| 12325| 0.01| 0.06%| 19| ON CPU| 0.06%| 789E5A1354C1BE185C105620CC81D50D| 0.06%| oceanbase.__all_virtual_query_response_time| | | 1| 11008| 0.01| 0.05%| 17| ON CPU| 0.05%| D950AAAD6DBD4DD227884EBFAC784569| 0.05%| oceanbase.__all_virtual_kvcache_info| | | 1002| 202737| 0.01| 0.05%| 17| ON CPU| 0.05%| 55C3E17DD1242A38678CEB6F52A83FEE| 0.05%| eo_coflowin.benefit_record_item(p11)| | | 1002| 49403| 0.00| 0.04%| 0| ON CPU| 0.04%| LogReplayService.TRANS_SERVICE| 0.04%| | | | 1002| 202740| 0.00| 0.04%| 14| ON CPU| 0.04%| 55C3E17DD1242A38678CEB6F52A83FEE| 0.04%| eo_coflowin.benefit_record_item(p14)| | 10.1.43.151:2882| 1| 11004| 0.02| 0.20%| 67| ON CPU| 0.20%| 08282664B36C5230B0D579753DA5D92E| 0.00%| oceanbase.__all_virtual_plan_stat| | | 1002| 1152921504606854026| 0.02| 0.18%| 61| ON CPU| 0.18%| 35BF6604DD6AFB8D23AE0633C5AC8527| 0.13%| omni_ai.ai_job_queue.idx_sptc| | | 1| 12287| 0.01| 0.11%| 37| ON CPU| 0.11%| DBCB5D52A5E14718345165081BC7EAE4| 0.11%| oceanbase.__all_virtual_ls_info| | | 1| 11017| 0.01| 0.07%| 24| ON CPU| 0.07%| 1DF15473BF500C0D6F79C1C41FDCE4CC| 0.04%| oceanbase.__all_virtual_system_event| | | 1| 11021| 0.00| 0.05%| 16| ON CPU| 0.05%| 3422DF64D50F313DB8A160E38C396B10| 0.01%| oceanbase.__all_virtual_sysstat| | | 1002| 201800| 0.00| 0.04%| 14| ON CPU| 0.04%| 030572EB4329CBF0455B3394248CF702| 0.01%| eo_cosys.collection_node_snapshot(p56)| | | 1| 12072| 0.00| 0.04%| 14| ON CPU| 0.03%| 0E89B7F8952D0FB89DE583330AC0909A| 0.01%| oceanbase.__all_virtual_table| | | | | | | | exec inner sql wait| 0.01%| 0E89B7F8952D0FB89DE583330AC0909A| 0.00%| | | | | | | | | db file data read| 0.00%| E541BD894D0480331F6B902E58AA8E3F| 0.00%| | +-------------------------+--------------------+--------------------+--------------------+--------------------+--------------------+----------------------------------------------------------------+--------------------+----------------------------------------------------------------+--------------------+--------------------------------------------------------------------------------------------------------------------------------+ Activity Over Time: - this section lists time slot information during the analysis period. - The numbers in parentheses represent the time (in seconds) that has passed since the beginning and end stages. - Slot Begin Time: current slot's begin time. current slot end with next slot begin time. - Event Name: comprise wait event and on cpu event. - Event Samples: num of sampled session activity records. - % Activity: activity percentage for given event. - Avg Active Sessions: average active sessions during ash report analysis time period. +----------------------------+-------------+----------------------------------------------------------------+--------------------+-------------+-----------+--------------------+ | Slot Begin Time| Slot Count| Event Name| Wait Class|Event Samples| % Activity| Avg Active Sessions| +----------------------------+-------------+----------------------------------------------------------------+--------------------+-------------+-----------+--------------------+ | 2025-12-31 09:30:00| 3102| ON CPU| NULL| 1550| 49.97%| 4.31| | | | sleep wait| IDLE| 1040| 33.53%| 2.89| | | | exec inner sql wait| OTHER| 131| 4.22%| 0.36| | | | tx commiting wait| COMMIT| 109| 3.51%| 0.30| | | | px loop condition wait| NETWORK| 78| 2.52%| 0.22| | 2025-12-31 09:36:00| 3352| ON CPU| NULL| 1762| 52.57%| 4.89| | | | sleep wait| IDLE| 1043| 31.12%| 2.90| | | | exec inner sql wait| OTHER| 144| 4.30%| 0.40| | | | tx commiting wait| COMMIT| 115| 3.43%| 0.32| | | | px loop condition wait| NETWORK| 91| 2.71%| 0.25| | 2025-12-31 09:42:00| 3241| ON CPU| NULL| 1629| 50.26%| 4.53| | | | sleep wait| IDLE| 1042| 32.15%| 2.89| | | | exec inner sql wait| OTHER| 140| 4.32%| 0.39| | | | tx commiting wait| COMMIT| 129| 3.98%| 0.36| | | | px loop condition wait| NETWORK| 81| 2.50%| 0.23| | 2025-12-31 09:48:00| 3221| ON CPU| NULL| 1639| 50.88%| 4.55| | | | sleep wait| IDLE| 1041| 32.32%| 2.89| | | | exec inner sql wait| OTHER| 124| 3.85%| 0.34| | | | tx commiting wait| COMMIT| 102| 3.17%| 0.28| | | | palf write| SYSTEM_IO| 80| 2.48%| 0.22| | 2025-12-31 09:54:00| 3285| ON CPU| NULL| 1689| 51.42%| 4.69| | | | sleep wait| IDLE| 1041| 31.69%| 2.89| | | | exec inner sql wait| OTHER| 133| 4.05%| 0.37| | | | tx commiting wait| COMMIT| 124| 3.77%| 0.34| | | | px loop condition wait| NETWORK| 90| 2.74%| 0.25| | 2025-12-31 10:00:00| 3246| ON CPU| NULL| 1690| 52.06%| 4.69| | | | sleep wait| IDLE| 1043| 32.13%| 2.90| | | | exec inner sql wait| OTHER| 129| 3.97%| 0.36| | | | tx commiting wait| COMMIT| 105| 3.23%| 0.29| | | | px loop condition wait| NETWORK| 89| 2.74%| 0.25| | 2025-12-31 10:06:00| 3389| ON CPU| NULL| 1779| 52.49%| 4.94| | | | sleep wait| IDLE| 1041| 30.72%| 2.89| | | | tx commiting wait| COMMIT| 147| 4.34%| 0.41| | | | exec inner sql wait| OTHER| 125| 3.69%| 0.35| | | | px loop condition wait| NETWORK| 90| 2.66%| 0.25| | 2025-12-31 10:12:00| 3922| ON CPU| NULL| 2048| 52.22%| 5.69| | | | sleep wait| IDLE| 1041| 26.54%| 2.89| | | | px loop condition wait| NETWORK| 250| 6.37%| 0.69| | | | exec inner sql wait| OTHER| 137| 3.49%| 0.38| | | | tx commiting wait| COMMIT| 128| 3.26%| 0.36| | 2025-12-31 10:18:00| 3320| ON CPU| NULL| 1687| 50.81%| 4.69| | | | sleep wait| IDLE| 1043| 31.42%| 2.90| | | | exec inner sql wait| OTHER| 135| 4.07%| 0.38| | | | tx commiting wait| COMMIT| 104| 3.13%| 0.29| | | | px loop condition wait| NETWORK| 97| 2.92%| 0.27| | 2025-12-31 10:24:00(+359s)| 3167| ON CPU| NULL| 1590| 50.20%| 4.43| | | | sleep wait| IDLE| 1039| 32.81%| 2.89| | | | tx commiting wait| COMMIT| 131| 4.14%| 0.36| | | | exec inner sql wait| OTHER| 129| 4.07%| 0.36| | | | px loop condition wait| NETWORK| 79| 2.49%| 0.22| +----------------------------+-------------+----------------------------------------------------------------+--------------------+-------------+-----------+--------------------+ 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| 4196| 12.62%| 54A8B0E0FCD6397C5706051E7CE315FD| 0.92%| | | IN_STORAGE_READ| 1355| 4.08%| AB083679B928CF882A1E38A28C822ED4| 0.70%| | | IN_COMMITTING| 1258| 3.78%| F898845B5825FBCD7C4CC8F67188DB9D| 1.03%| | | IN_STORAGE_WRITE| 533| 1.60%| A33DD674E9EC4DEE0C2F3E0640D7EBC4| 0.38%| | | IN_PLAN_CACHE| 272| 0.82%| 030572EB4329CBF0455B3394248CF702| 0.10%| | | IN_CHECK_ROW_CONFLICTION| 249| 0.75%| A33DD674E9EC4DEE0C2F3E0640D7EBC4| 0.27%| | | IN_RPC_ENCODE| 119| 0.36%| 54A8B0E0FCD6397C5706051E7CE315FD| 0.12%| | | IN_EXTRACT_QUERY_RANGE| 77| 0.23%| 030572EB4329CBF0455B3394248CF702| 0.03%| | | IN_PARSE| 46| 0.14%| F898845B5825FBCD7C4CC8F67188DB9D| 0.02%| | | IN_DUPLICATE_CONFLICT_RESOLVE| 38| 0.11%| CD91935A6C58176A38E0552FDBDFA0BE| 0.04%| | | IN_FILTER_ROWS| 20| 0.06%| 661F8B1C39FA18B9BE8DAC293DA563C2| 0.02%| | | IN_REWRITE| 6| 0.02%| 4332502DAFDD2FC43A22E3B082922F12| 0.00%| | | IN_DEADLOCK_ROW_REGISTER| 4| 0.01%| F898845B5825FBCD7C4CC8F67188DB9D| 0.00%| | | IN_CONNECTION_MGR| 3| 0.01%| DB9FE488781AF5A3DE810062B8A168AB| 0.00%| | | IN_SQL_OPTIMIZE| 3| 0.01%| 02FC6AB36082C19176B8255C92217680| 0.00%| | | IN_RPC_DECODE| 1| 0.00%| 045C9E7247129600D68675A4AA4C5792| 0.00%| | BACKGROUND| IN_SQL_EXECUTION| 1377| 4.14%| DBCB5D52A5E14718345165081BC7EAE4| 0.45%| | | IN_PX_EXECUTION| 1109| 3.34%| DBCB5D52A5E14718345165081BC7EAE4| 0.37%| | | IN_RPC_DECODE| 811| 2.44%| 54A8B0E0FCD6397C5706051E7CE315FD| 0.57%| | | IN_STORAGE_READ| 642| 1.93%| DBCB5D52A5E14718345165081BC7EAE4| 0.50%| | | IN_COMMITTING| 116| 0.35%| 24D486F20861EBD9E0217692DB0E9C61| 0.22%| | | IN_STORAGE_WRITE| 91| 0.27%| BD726868E1EF777297E6D256C939FEF6| 0.20%| | | IN_REMOTE_DAS_EXECUTION| 90| 0.27%| BD726868E1EF777297E6D256C939FEF6| 0.21%| | | IN_CHECK_ROW_CONFLICTION| 66| 0.20%| BD726868E1EF777297E6D256C939FEF6| 0.17%| | | IN_CONNECTION_MGR| 45| 0.14%| | 0.09%| | | IN_RPC_ENCODE| 43| 0.13%| | 0.04%| | | IN_FILTER_ROWS| 40| 0.12%| FC5F38AA6F5F7B2082CCB180CE16D743| 0.04%| | | IN_DUPLICATE_CONFLICT_RESOLVE| 6| 0.02%| 20FC8BB45A1C6757FD3B701E96E471B1| 0.01%| | | IN_EXTRACT_QUERY_RANGE| 6| 0.02%| B50F969FD7AF0B6538B2E5C3E23E9F36| 0.01%| | | IN_RESOLVE| 3| 0.01%| | 0.00%| | | IN_PLAN_CACHE| 2| 0.01%| D26592AA77A0E0E9EB31E74B23159453| 0.00%| | | IN_PLSQL_EXECUTION| 2| 0.01%| E9E2014C8CE705871C555597A6A32456| 0.01%| | | IN_REWRITE| 1| 0.00%| 10E75F5875F87D11FF58F7D656075187| 0.00%| | | IN_PARSE| 1| 0.00%| 7DD44B88DFE09F21BB0F28C4F307517B| 0.00%| +------------+----------------------------------------+--------------------+-----------+----------------------------------------+-----------+ Top IO Events: - This section lists the top io event from the perspective of SQL and background tasks - Node: The IP address and port number of the observer - Program Module Action / SQL ID: Program Module Action represent the type of background tasks, which is only effective in background tasks. And SQL ID is only effective in foreground tasks - Plan Hash: Numeric representation of the current SQL plan, which is only effective in foreground tasks - IO Event Samples: The total samples of io wait event during task execution. - %IO Event Samples: The proportion of total io wait event samples among all sampled points - Top Event: The top io wait event name. - IO Type: The type of io wait event. - % EVENT: activity percentage for the io wait event. - Enqueue Time: The total time(in seconds) spent queuing for I/O requests. - Device Time: The total time (in seconds) spent executing I/O requests on the device. - Callback Time: The total time (in seconds) spent executing callbacks for I/O requests. +---------------------+------------------------------------------------------------------------------------------------+--------------------+--------------------+--------------------+----------+--------------------+----------+--------------------+--------------------+--------------------+ | Node| Program Module Action / SQL ID| Plan Hash| IO Event Samples| %IO Event Samples| Top Event| IO Type| % EVENT| Enqueue Time(S)| Device Time(S)| Callback Time(S)| +---------------------+------------------------------------------------------------------------------------------------+--------------------+--------------------+--------------------+----------+--------------------+----------+--------------------+--------------------+--------------------+ | 10.1.43.153:2882| T1002_LogService/LogIOWorker/aggregate io task| 0| 236| 0.71%|palf write| SYSTEM_IO| 0.71%| 8.51| 222.18| 0.00| | 10.1.43.152:2882| T1002_LogService/LogIOWorker/aggregate io task| 0| 190| 0.57%|palf write| SYSTEM_IO| 0.57%| 7.74| 176.50| 0.00| | 10.1.43.151:2882| T1002_LogService/LogIOWorker/aggregate io task| 0| 114| 0.34%|palf write| SYSTEM_IO| 0.34%| 8.24| 77.89| 0.00| | 10.1.43.152:2882| AB083679B928CF882A1E38A28C822ED4| 4005357145445878169| 68| 0.20%|db file data read| USER_IO| 0.20%| 2.81| 12.98| 48.10| | 10.1.43.153:2882| AB083679B928CF882A1E38A28C822ED4| 4005357145445878169| 62| 0.19%|db file data read| USER_IO| 0.19%| 3.17| 16.74| 39.96| | 10.1.43.151:2882| AB083679B928CF882A1E38A28C822ED4| 4005357145445878169| 27| 0.08%|db file data read| USER_IO| 0.08%| 1.20| 11.81| 13.47| | 10.1.43.151:2882| BD726868E1EF777297E6D256C939FEF6| 9223643895202507952| 26| 0.08%|db file data read| USER_IO| 0.08%| 1.51| 18.83| 4.11| | 10.1.43.153:2882| A33DD674E9EC4DEE0C2F3E0640D7EBC4| 3290318591324336132| 24| 0.07%|db file data read| USER_IO| 0.07%| 1.94| 13.22| 7.35| | 10.1.43.152:2882| T1001_LogService/LogIOWorker/aggregate io task| 0| 23| 0.07%|palf write| SYSTEM_IO| 0.07%| 2.76| 18.80| 0.00| | 10.1.43.153:2882| BD726868E1EF777297E6D256C939FEF6| 9223643895202507952| 21| 0.06%|db file data read| USER_IO| 0.06%| 0.92| 16.41| 2.65| | 10.1.43.152:2882| BD726868E1EF777297E6D256C939FEF6| 9223643895202507952| 20| 0.06%|db file data read| USER_IO| 0.06%| 2.17| 11.13| 5.34| | 10.1.43.153:2882| T1_LogService/LogIOWorker/aggregate io task| 0| 18| 0.05%|palf write| SYSTEM_IO| 0.05%| 1.77| 15.14| 0.00| | 10.1.43.152:2882| A33DD674E9EC4DEE0C2F3E0640D7EBC4| 3290318591324336132| 18| 0.05%|db file data read| USER_IO| 0.05%| 2.02| 6.23| 8.52| | 10.1.43.153:2882| T1001_LogService/LogIOWorker/aggregate io task| 0| 17| 0.05%|palf write| SYSTEM_IO| 0.05%| 1.73| 13.89| 0.00| | 10.1.43.152:2882| T1_LogService/LogIOWorker/aggregate io task| 0| 12| 0.04%|palf write| SYSTEM_IO| 0.04%| 1.24| 9.87| 0.00| | 10.1.43.151:2882| A33DD674E9EC4DEE0C2F3E0640D7EBC4| 3290318591324336132| 10| 0.03%|db file data read| USER_IO| 0.03%| 0.62| 7.57| 1.43| | 10.1.43.151:2882| T1_LogService/LogIOWorker/aggregate io task| 0| 9| 0.03%|palf write| SYSTEM_IO| 0.03%| 1.03| 7.62| 0.00| | 10.1.43.151:2882| T1001_LogService/LogIOWorker/aggregate io task| 0| 8| 0.02%|palf write| SYSTEM_IO| 0.02%| 0.84| 6.77| 0.00| | 10.1.43.152:2882| CB520A940306AE5426A11392BBF039BD|15145718992989151317| 7| 0.02%|db file data read| USER_IO| 0.02%| 0.39| 2.83| 3.39| | 10.1.43.152:2882| A975642EC1BB14C0B605908CC5253E6F| 8894128478548303855| 6| 0.02%|db file data read| USER_IO| 0.02%| 0.49| 3.40| 2.00| | 10.1.43.152:2882| E541BD894D0480331F6B902E58AA8E3F| 3064099486399723373| 5| 0.01%|db file data read| USER_IO| 0.01%| 0.24| 1.32| 3.11| | 10.1.43.153:2882| CB520A940306AE5426A11392BBF039BD|15145718992989151317| 5| 0.01%|db file data read| USER_IO| 0.01%| 0.27| 1.78| 2.63| | 10.1.43.153:2882| E541BD894D0480331F6B902E58AA8E3F| 3064099486399723373| 5| 0.01%|db file data read| USER_IO| 0.01%| 0.30| 1.46| 2.81| | 10.1.43.153:2882| A975642EC1BB14C0B605908CC5253E6F| 8894128478548303855| 4| 0.01%|db file data read| USER_IO| 0.01%| 0.22| 1.43| 2.22| | 10.1.43.153:2882| CAD55628BA4BC4035A77BF7DCE33A904|12542316718218270268| 4| 0.01%|db file data read| USER_IO| 0.01%| 0.14| 1.69| 2.01| | 10.1.43.153:2882| 7979874E288B8F7B6E19DC6F8CE33098| 3355479781047128221| 3| 0.01%|db file data read| USER_IO| 0.01%| 0.15| 1.40| 1.28| | 10.1.43.152:2882| DA490A84A94007EADA98F8CD374EF9B4| 3290318591324336132| 3| 0.01%|db file data read| USER_IO| 0.01%| 0.06| 1.91| 0.86| | 10.1.43.151:2882| 3DB49505C5E2B165C4B3A2B955EA1D61| 3290318591324336132| 3| 0.01%|db file data read| USER_IO| 0.01%| 0.11| 2.31| 0.47| | 10.1.43.151:2882| CAD55628BA4BC4035A77BF7DCE33A904|12542316718218270268| 3| 0.01%|db file data read| USER_IO| 0.01%| 0.10| 1.36| 1.49| | 10.1.43.151:2882| A975642EC1BB14C0B605908CC5253E6F| 8894128478548303855| 3| 0.01%|db file data read| USER_IO| 0.01%| 0.27| 1.80| 0.78| +---------------------+------------------------------------------------------------------------------------------------+--------------------+--------------------+--------------------+----------+--------------------+----------+--------------------+--------------------+--------------------+ 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| 23965| 72.09%| 136| 10.1.43.152:2882| 25.56%| 13.15%| 12.41%| | | | | | 10.1.43.153:2882| 25.12%| 12.60%| 12.53%| | | | | | 10.1.43.151:2882| 21.41%| 9.66%| 11.75%| | T_SELECT| 6761| 20.34%| 2033| 10.1.43.152:2882| 7.29%| 4.86%| 2.43%| | | | | | 10.1.43.153:2882| 7.02%| 4.43%| 2.59%| | | | | | 10.1.43.151:2882| 6.03%| 3.88%| 2.15%| | T_INSERT| 1995| 6.00%| 780| 10.1.43.153:2882| 2.38%| 0.93%| 1.45%| | | | | | 10.1.43.152:2882| 2.27%| 0.94%| 1.33%| | | | | | 10.1.43.151:2882| 1.35%| 0.43%| 0.92%| | T_REPLACE| 248| 0.75%| 97| 10.1.43.152:2882| 0.29%| 0.11%| 0.18%| | | | | | 10.1.43.153:2882| 0.23%| 0.10%| 0.14%| | | | | | 10.1.43.151:2882| 0.22%| 0.04%| 0.18%| | T_UPDATE| 220| 0.66%| 42| 10.1.43.151:2882| 0.36%| 0.05%| 0.31%| | | | | | 10.1.43.153:2882| 0.18%| 0.06%| 0.13%| | | | | | 10.1.43.152:2882| 0.11%| 0.04%| 0.08%| +---------------------------------------------+---------------------+---------------------+---------------------+----------------------------------------------------------------+---------------------+---------------------+---------------------+ Top SQL with Top Events: - This Section lists the SQL statements that accounted for the highest percentages event. - Plan Hash: Numeric representation of the current SQL plan - Active Samples: num of samples for top current SQL - % Activity: activity percentage for given SQL ID - Sampled Executions: represents the number of times the current SQL execution has been sampled - Top Event: top event name for current SQL plan - % Event: activity percentage for current SQL plan - Top Operator/ExecPhase: top operator name or execution phase for current event - % Operator/ExecPhase: activity percentage for given operator +----------------------------------------+--------------------+--------------------+--------------+--------------------+----------------------------------------------------------------+--------------+--------------------------------------------------------------------------------------------------------------------------------+------------------------+----------------------------------------------------------------+ | SQL ID| Plan Hash| Active Samples| % Activity| Sampled Executions| Top Event| % Event| Top Operator/ExecPhase| % Operator/ExecPhase| SQL Text| +----------------------------------------+--------------------+--------------------+--------------+--------------------+----------------------------------------------------------------+--------------+--------------------------------------------------------------------------------------------------------------------------------+------------------------+----------------------------------------------------------------+ | 54A8B0E0FCD6397C5706051E7CE315FD|17337673821950778480| 710| 2.14%| 623| ON CPU| 1.14%| IN_SQL_EXECUTION| 0.53%| SELECT crq_request_id,crq_channel,crq_loop_flag,crq_age| | | | | | | px loop condition wait| 0.62%| 0:PX COORDINATOR | 0.62%| | | | | | | | default condition wait| 0.33%| IN_SQL_EXECUTION| 0.13%| | | | | | | | sync get gts timestamp wait| 0.04%| IN_SQL_EXECUTION| 0.04%| | | | | | | | wait in request queue| 0.01%| UNDEFINED| 0.00%| | | F898845B5825FBCD7C4CC8F67188DB9D| 3290318591324336132| 528| 1.59%| 528| tx commiting wait| 1.03%| IN_COMMITTING| 1.03%| INSERT IGNORE INTO collection_node_snapshot(' cn| | | | | | | ON CPU| 0.54%| 0:DISTRIBUTED INSERT| 0.42%| | | | | | | | wait in request queue| 0.01%| UNDEFINED| 0.00%| | | | | | | | row lock wait| 0.01%| 0:DISTRIBUTED INSERT| 0.01%| | | A33DD674E9EC4DEE0C2F3E0640D7EBC4| 3290318591324336132| 418| 1.26%| 418| tx commiting wait| 0.73%| IN_COMMITTING| 0.73%| INSERT IGNORE INTO node(n_id, n_type, n_userId, n_colle| | | | | | | ON CPU| 0.35%| 0:DISTRIBUTED INSERT| 0.26%| | | | | | | | db file data read| 0.16%| 0:DISTRIBUTED INSERT| 0.16%| | | | | | | | wait in request queue| 0.01%| UNDEFINED| 0.00%| | | 2FD45F34AA6A412A55010FB665262699| 3290318591324336132| 337| 1.01%| 337| tx commiting wait| 0.67%| IN_COMMITTING| 0.67%| INSERT IGNORE INTO co_data_snapshot(cds_codataId, cds_v| | | | | | | ON CPU| 0.32%| 0:DISTRIBUTED INSERT| 0.21%| | | | | | | | wait in request queue| 0.01%| UNDEFINED| 0.00%| | | | | | | | db file data read| 0.01%| 0:DISTRIBUTED INSERT| 0.01%| | | | | | | | row lock wait| 0.00%| 0:DISTRIBUTED INSERT| 0.00%| | +----------------------------------------+--------------------+--------------------+--------------+--------------------+----------------------------------------------------------------+--------------+--------------------------------------------------------------------------------------------------------------------------------+------------------------+----------------------------------------------------------------+ 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| +----------------------------------------+--------------------+--------------+--------------+--------------------+--------------------------------------------------------------------------------------------------------------------------------+--------------+----------------------------------------------------------------+--------------+----------------------------------------------------------------+ | 54A8B0E0FCD6397C5706051E7CE315FD|17337673821950778480| 340| 1.02%| 324| 0:PX COORDINATOR | 0.87%| px loop condition wait| 0.62%| SELECT crq_request_id,crq_channel,crq_loop_flag,crq_age| | | | | | | 8:TABLE FULL SCAN:converter_request_queue| 0.08%| ON CPU| 0.08%| | | | | | | | 7:PX PARTITION ITERATOR| 0.04%| ON CPU| 0.04%| | | | | | | | 5:EXCHANGE IN DISTR| 0.01%| ON CPU| 0.01%| | | | | | | | 6:EXCHANGE OUT DISTR (HASH)::EX10000| 0.01%| ON CPU| 0.01%| | +----------------------------------------+--------------------+--------------+--------------+--------------------+--------------------------------------------------------------------------------------------------------------------------------+--------------+----------------------------------------------------------------+--------------+----------------------------------------------------------------+ 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: 54A8B0E0FCD6397C5706051E7CE315FD SQL Text: SELECT crq_request_id,crq_channel,crq_loop_flag,crq_age_ms,crq_create_at,crq_expired_at FROM ( SELECT crq_request_id,crq_channel,crq_loop_flag,crq_age_ms,crq_create_at,crq_expired_at, row_number() over ( partition by crq_channel order by crq_expired_at ASC ) AS rank FROM converter_request_queue WHERE crq_channel in (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND crq_expired_at <= ? ) AS T WHERE rank = ? SQL ID: BD726868E1EF777297E6D256C939FEF6 SQL Text: REPLACE INTO node_relation( nr_nodeId, nr_parentId, nr_collectionVersion, nr_status ) VALUES (?,?,?,?) SQL ID: A33DD674E9EC4DEE0C2F3E0640D7EBC4 SQL Text: INSERT IGNORE INTO node(n_id, n_type, n_userId, n_collectionId) VALUES(?,?,?,?) SQL ID: 4332502DAFDD2FC43A22E3B082922F12 SQL Text: SELECT n_id, n_type, n_userId, n_collectionId, n_createAt FROM node, ( SELECT nr_parentId, nr_status FROM ( SELECT nr_parentId, nr_status, ROW_NUMBER() OVER (PARTITION BY nr_parentId ORDER BY nr_collectionVersion DESC) AS rank FROM node_relation where nr_nodeId = ? ) AS t WHERE rank = ? AND nr_status = ? ) WHERE n_id = nr_parentId SQL ID: B50F969FD7AF0B6538B2E5C3E23E9F36 SQL Text: SELECT ct_role as role FROM team_members_cache, group_team, collection_team WHERE tmc_user_id = ? AND tmc_group_id = ? AND tmc_team_id = gt_team_id AND gt_group_id = ? AND tmc_team_id = ct_team_id AND ct_group_id = ? AND ct_collection_id = ? SQL ID: 2FD45F34AA6A412A55010FB665262699 SQL Text: INSERT IGNORE INTO co_data_snapshot(cds_codataId, cds_version, cds_data) VALUES(?,?,?) SQL ID: F898845B5825FBCD7C4CC8F67188DB9D SQL Text: INSERT IGNORE INTO collection_node_snapshot( cns_collectionId, cns_collectionVersion, cns_nodeId, cns_nodeVersion, cns_data, cns_beginVersion ) VALUES (?,?,?,?,?,?) SQL ID: CD91935A6C58176A38E0552FDBDFA0BE SQL Text: REPLACE INTO nodes_latest_update(nlu_nodeId, nlu_userId, nlu_updateAt) VALUES(?,?,?) SQL ID: DBCB5D52A5E14718345165081BC7EAE4 SQL Text: select a.svr_ip, a.svr_port, a.tenant_id, a.ls_id, a.role, nvl(b.weak_read_scn, ?) as weak_read_scn, nvl(b.migrate_status, ?) as migrate_status, nvl(b.tx_blocked, ?) as tx_blocked from oceanbase.__all_virtual_ls_meta_table a left join oceanbase.__all_virtual_ls_info b on a.svr_ip = b.svr_ip and a.svr_port = b.svr_port and a.tenant_id = b.tenant_id and a.ls_id = b.ls_id; SQL ID: DB9FE488781AF5A3DE810062B8A168AB SQL Text: select /*+ MONITOR_AGENT QUERY_TIMEOUT(100000000) */ con_id tenant_id, count(*) as cnt from CDB_TABLES group by con_id SQL ID: 26F2D7AD20DE3063C7F4503C14193039 SQL Text: SELECT cnv_user_id, GROUP_CONCAT(DISTINCT cnv_page_tag) AS tags FROM client_node_visit WHERE cnv_node_id = ? AND cnv_user_id IN (?,?) GROUP BY cnv_user_id SQL ID: C7263E0998C5F9406F0B3CF579253E45 SQL Text: SELECT np_id packetId,np_url url,np_type type,np_parent_ids parentIds, npr_status status,npr_update_at updateAt FROM node_packet_relation LEFT JOIN node_packet ON np_id = npr_packet_id where npr_node_id in (?, ?, ?) and npr_collection_id=? and npr_collection_version=? and npr_publish_node_id=? SQL ID: 02FC6AB36082C19176B8255C92217680 SQL Text: SELECT rr_room_id, rr_range_type, rr_range_id, rr_collection_id, rr_node_id, rr_extend_info, rr_status, rr_owner_id, rr_create_at, pi_attributes, u_nickname, u_avatar_url, gm_nick_name FROM rtc_rooms LEFT JOIN page_info ON rtc_rooms.rr_node_id = page_info.pi_node_id LEFT JOIN user ON rtc_rooms.rr_owner_id = user.u_id LEFT JOIN group_member ON rtc_rooms.rr_owner_id = group_member.gm_user_id AND rtc_rooms.rr_group_id = group_member.gm_group_id WHERE rr_range_type = ? AND rr_range_id = ? AND rr_collection_id = ? ORDER BY rr_create_at DESC SQL ID: 2785B4725E5E945F4F8F85B23067834D SQL Text: SELECT nr_toCollectionId, nr_fromCollectionId, nr_fromNodeId, nr_copyId, nr_fromCollectionVersion, nr_userId, n_type FROM node_reference, node WHERE nr_toNodeId=? and n_id = nr_fromNodeId SQL ID: E1D2B1B981FCA4B727071661E0BF6C59 SQL Text: SELECT nr_parent_id, nr_parent_type FROM node_relation WHERE nr_collection_id = ? AND nr_node_id = ? SQL ID: 7979874E288B8F7B6E19DC6F8CE33098 SQL Text: SELECT nu_user_id FROM node_update WHERE nu_collection_id = ? order by nu_update_at DESC LIMIT ? SQL ID: A975642EC1BB14C0B605908CC5253E6F SQL Text: INSERT INTO node_update(nu_node_id, nu_node_type, nu_user_id, nu_update_at, nu_collection_id, nu_collection_version) VALUES( ?,?,?,?,?,greatest(last_insert_id(?),?)) ON DUPLICATE KEY UPDATE nu_user_id = ?, nu_node_type=?, nu_update_at = ?, nu_collection_version = greatest(last_insert_id(nu_collection_version),?) SQL ID: FC5F38AA6F5F7B2082CCB180CE16D743 SQL Text: SELECT br_id, br_group_id, br_type, br_expire_time, br_extend_info, br_status, br_create_at, br_update_at FROM benefit_record WHERE br_group_id = ? AND br_status = ? ORDER By br_create_at ASC SQL ID: 3DB49505C5E2B165C4B3A2B955EA1D61 SQL Text: INSERT IGNORE INTO node_update_history( nuh_node_id, nuh_node_type, nuh_collection_version, nuh_user_id, nuh_update_at, nuh_update_count, nuh_collection_id ) VALUES(?,?,?,?,?,?,?) SQL ID: CB520A940306AE5426A11392BBF039BD SQL Text: SELECT nuh_node_id, nuh_node_type FROM node_update_history WHERE nuh_collection_id = ? AND nuh_collection_version = ? GROUP BY nuh_node_id 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: 5ED8A99789AAF52019CA698995AE37F7 SQL Text: SELECT c_id, c_title, c_avatar, c_cover, c_coverPos, c_group_id, c_size, c_last_update_at, c_last_active_at, cv_create_at FROM collection LEFT JOIN collection_visit ON c_id = cv_collection_id AND cv_user_id = ? WHERE c_status = ? AND c_group_id = ? AND c_public_type in (?, ?) SQL ID: 7DD44B88DFE09F21BB0F28C4F307517B SQL Text: select * from __all_ls_log_archive_progress where tenant_id=? and dest_id=? and round_id=? and ls_id=? order by piece_id desc limit ? SQL ID: AB083679B928CF882A1E38A28C822ED4 SQL Text: SELECT cds_version, cds_data FROM co_data_snapshot WHERE cds_codataId = ? ORDER BY cds_version DESC LIMIT ? SQL ID: E9E2014C8CE705871C555597A6A32456 SQL Text: CALL DBMS_STATS.ASYNC_GATHER_STATS_JOB_PROC(600000000); SQL ID: 8A72F944EC3CE291B416336C2955D9A7 SQL Text: INSERT IGNORE INTO collection_res_record( crr_collection_id, crr_path, crr_size ) VALUES (?,?,?) SQL ID: 2A579E151A560F478BB368A264B65D11 SQL Text: SELECT ui_id, ui_group_id, ui_nickname, ui_avatar_url, ranking FROM( SELECT ui_id, ui_group_id, ui_nickname, ui_avatar_url, RANK() OVER (PARTITION BY ui_id ORDER BY ui_group_id DESC) AS ranking FROM user_info WHERE ( ui_id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND ui_source = ? AND (ui_group_id = ? OR ui_group_id = ?) ) ) as ranking WHERE ranking=? SQL ID: 661F8B1C39FA18B9BE8DAC293DA563C2 SQL Text: select /*+ MONITOR_AGENT QUERY_TIMEOUT(10000000) */ distinct sql_id, statement from `V$OB_PLAN_CACHE_PLAN_STAT` where svr_ip = ? and svr_port = ? and sql_id in (?, ?) SQL ID: 7814CE37785DA0BB822B76BE94D09874 SQL Text: SELECT nr_toNodeId, nr_fromCollectionId, nr_fromNodeId, nr_userId FROM node_reference WHERE nr_toCollectionId=? AND nr_fromCollectionVersion=? AND nr_copyId=? AND nr_fromNodeId in(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) SQL ID: CAD55628BA4BC4035A77BF7DCE33A904 SQL Text: SELECT cdu_version, cdu_userId, cdu_src, cdu_seq, cdu_createAt, cdu_data FROM co_data_update WHERE cdu_codataId = ? AND cdu_version >= ? ORDER BY cdu_version SQL ID: DA490A84A94007EADA98F8CD374EF9B4 SQL Text: INSERT IGNORE INTO collection_res_relation( crr_collection_id, crr_collection_version, crr_node_id, crr_path, crr_size, crr_create_at, crr_update_at ) VALUES (?,?,?,?,?,?,?) SQL ID: E1006FC969855AD8770C0D2DC383F44D SQL Text: UPDATE collection_size_record SET csr_size = csr_size + ?, csr_update_at = ? WHERE csr_collection_id = ? SQL ID: 20FC8BB45A1C6757FD3B701E96E471B1 SQL Text: INSERT INTO __all_index_usage_info (tenant_id, object_id, name, owner, total_access_count, total_exec_count, total_rows_returned, bucket_0_access_count, bucket_1_access_count, bucket_2_10_access_count, bucket_2_10_rows_returned, bucket_11_100_access_count, bucket_11_100_rows_returned, bucket_101_1000_access_count, bucket_101_1000_rows_returned, bucket_1000_plus_access_count, bucket_1000_plus_rows_returned, last_used, last_flush_time) VALUES (?,?,?,?, ?,?,?,?,?,?,?,?,?,?,?,?,?,usec_to_time(?),now(6)),(?,?,?,?, ?,?,?,?,?,?,?,?,?,?,?,?,?,usec_to_time(?),now(6)),(?,?,?,?, ?,?,?,?,?,?,?,?,?,?,?,?,?,usec_to_time(?),now(6)),(?,?,?,?, ?,?,?,?,?,?,?,?,?,?,?,?,?,usec_to_time(?),now(6)),(?,?,?,?, ?,?,?,?,?,?,?,?,?,?,?,?,?,usec_to_time(?),now(6)),(?,?,?,?, ?,?,?,?,?,?,?,?,?,?,?,?,?,usec_to_time(?),now(6)),(?,?,?,?, ?,?,?,?,?,?,?,?,?,?,?,?,?,usec_to_time(?),now(6)),(?,?,?,?, ?,?,?,?,?,?,?,?,?,?,?,?,?,usec_to_time(?),now(6)) ON DUPLICATE KEY UPDATE total_access_count = total_access_count + VALUES(total_access_count), tota SQL ID: E541BD894D0480331F6B902E58AA8E3F SQL Text: SELECT ? FROM collection_node_snapshot WHERE cns_collectionId=? AND cns_collectionVersion = ? LIMIT ? SQL ID: B78E3CA5637E71BEC720195BFEC26E32 SQL Text: update collection set c_version = ? where c_id = ? SQL ID: 10E75F5875F87D11FF58F7D656075187 SQL Text: SELECT m.table_id, m.tablet_id, m.inserts FROM __all_monitor_modified m LEFT JOIN __all_optstat_user_prefs up ON m.table_id = up.table_id AND up.pname = ? JOIN __all_optstat_global_prefs gp ON gp.sname = ? WHERE (CASE WHEN m.last_inserts = ? THEN ? + cast(coalesce(up.valchar, gp.spare4) as signed) ELSE m.inserts * ? / m.last_inserts END) > cast(coalesce(up.valchar, gp.spare4) as signed) AND (m.tenant_id, m.table_id, m.tablet_id) in ((?, ?, ?) ,(?, ?, ?) ,(?, ?, ?) ,(?, ?, ?) ,(?, ?, ?) ,(?, ?, ?) ,(?, ?, ?) ,(?, ?, ?) ,(?, ?, ?) ,(?, ?, ?) ,(?, ?, ?) ,(?, ?, ?) ,(?, ?, ?) ,(?, ?, ?) ,(?, ?, ?) ,(?, ?, ?) ,(?, ?, ?) ,(?, ?, ?) ,(?, ?, ?) ,(?, ?, ?) ,(?, ?, ?) ,(?, ?, ?) ,(?, ?, ?) ,(?, ?, ?) ,(?, ?, ?) ,(?, ?, ?) ,(?, ?, ?) ,(?, ?, ?) ,(?, ?, ?) ,(?, ?, ?) ,(?, ?, ?) ,(?, ?, ?) ,(?, ?, ?) ,(?, ?, ?) ,(?, ?, ?) ,(?, ?, ?) ,(?, ?, ?) ,(?, ?, ?) ,(?, ?, ?) ,(?, ?, ?) ,(?, ?, ?) ,(?, ?, ?) ,(?, ?, ?) ,(?, ?, ?) ,(?, ?, ?) ,(?, ?, ?) ,(?, ?, ?) ,(?, ?, ?) ,(?, ?, ?) ,(?, ?, ?) ,(?, SQL ID: 7FA32AD549CA88227A1088C2C2256B6F SQL Text: SELECT nr_toNodeId, nr_fromCollectionId, nr_fromNodeId, nr_userId FROM node_reference WHERE nr_toCollectionId=? AND nr_fromCollectionVersion=? AND nr_copyId=? AND nr_fromNodeId in(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) SQL ID: 030572EB4329CBF0455B3394248CF702 SQL Text: SELECT cns_data, cns_nodeVersion,cns_collectionVersion, cns_beginVersion FROM collection_node_snapshot WHERE cns_collectionId=? AND cns_collectionVersion <= ? AND cns_nodeId=? order by cns_collectionVersion DESC limit ? SQL ID: 3C4260CF19B9DCBC1F0246121D9AE59C SQL Text: SELECT nr_toNodeId, nr_fromCollectionId, nr_fromNodeId, nr_userId FROM node_reference WHERE nr_toCollectionId=? AND nr_fromCollectionVersion=? AND nr_copyId=? AND nr_fromNodeId in(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) SQL ID: A14F631A4B7DBD641FCB8072EE363EBD SQL Text: INSERT INTO collection( c_id, c_app, c_rootNode, c_referenceFromCollectionId, c_copyFromCollectionId, c_copyFromCollectionVersion, c_createAt ) VALUES(?,?,?,?,?,?,?) SQL ID: C58AEF2369F4694647C57609F7DF7C4B SQL Text: UPDATE ai_job SET aj_status = ?, aj_progress = ?, aj_result = ?, aj_result_style = ?, aj_update_at = ? where aj_id in (?) SQL ID: D26592AA77A0E0E9EB31E74B23159453 SQL Text: SELECT a.`value` as `value`,(case when d.group_or_subplan is NULL then ? else c.consumer_group end) as `group`, (case when d.group_or_subplan is NULL then ? else c.consumer_group_id end) as group_id FROM __all_res_mgr_mapping_rule a left join __all_res_mgr_directive d ON a.consumer_group = d.group_or_subplan AND d.plan = ? AND d.tenant_id = ?,__all_res_mgr_consumer_group c WHERE a.TENANT_ID = ? AND c.tenant_id = ? AND a.tenant_id = c.tenant_id AND a.attribute = ? AND c.consumer_group = a.consumer_group SQL ID: 045C9E7247129600D68675A4AA4C5792 SQL Text: WITH RECURSIVE recursion (nr_node_id, nr_parent_id, path, depth) AS ( SELECT nr_node_id, nr_parent_id, cast(concat(nr_node_id, ?, nr_parent_id) as char(4000)) COLLATE utf8mb4_general_ci as path, ? as depth from node_relation where nr_collection_id =? AND nr_node_id=? UNION ALL SELECT current.nr_node_id, current.nr_parent_id, concat( previous.path COLLATE utf8mb4_general_ci, ?, current.nr_parent_id COLLATE utf8mb4_general_ci ) COLLATE utf8mb4_general_ci, previous.depth + ? from node_relation current, recursion previous WHERE previous.depth < ? AND current.nr_collection_id = ? AND find_in_set( current.nr_parent_id COLLATE utf8mb4_general_ci, previous.path COLLATE utf8mb4_general_ci ) = ? AND current.nr_node_id = previous.nr_parent_id AND previous.nr_parent_id <> ? ) SELECT path SQL ID: 62FF1D6D48FF7640F3477960EC13E383 SQL Text: SELECT nr_toNodeId, nr_fromCollectionId, nr_fromNodeId, nr_userId FROM node_reference WHERE nr_toCollectionId=? AND nr_fromCollectionVersion=? AND nr_copyId=? AND nr_fromNodeId in(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) SQL ID: 9F7D5738898A2E5CA15BFB2826CCE08F SQL Text: SELECT nr_toNodeId, nr_fromCollectionId, nr_fromNodeId, nr_userId FROM node_reference WHERE nr_toCollectionId=? AND nr_fromCollectionVersion=? AND nr_copyId=? AND nr_fromNodeId in(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) SQL ID: 93A8B291DF81247A444758413D7FDF10 SQL Text: INSERT IGNORE INTO collection_version(cv_collectionId,cv_version,cv_createAt) VALUES(?,?,?) SQL ID: 87ADDDF50338E3353323474EC60EE3C1 SQL Text: SELECT cgh_graph_snapshot as snapshot, cgh_collection_version as collectionVersion FROM collection_graph_history where cgh_collection_id=? and cgh_collection_version=? limit ? SQL ID: 02AA7F5750EAC1DB64E545056CBFFA0C SQL Text: SELECT cv_createAt FROM collection_version WHERE cv_collectionId=? AND cv_version=? SQL ID: FE60C8CDF7810B473414E11DD9F90553 SQL Text: SELECT psh_screenshot_url screenshot FROM page_snapshot_history WHERE psh_collection_id=? and psh_node_id = ? AND psh_screenshot_url <> ? AND psh_is_blank = ? ORDER BY psh_collection_version DESC LIMIT ?