MySQL [(none)]> select * from oceanbase.gv$ob_sql_audit where trace_id='YB4285C5CC0A-0005F7542F4E6A02-0-0' \G *************************** 1. row *************************** SVR_IP: 133.197.204.10 SVR_PORT: 2882 REQUEST_ID: 10912795 SQL_EXEC_ID: 324519153 TRACE_ID: YB4285C5CC0A-0005F7542F4E6A02-0-0 SID: 3222271108 CLIENT_IP: 133.197.204.3 CLIENT_PORT: 35302 TENANT_ID: 1002 TENANT_NAME: daren EFFECTIVE_TENANT_ID: 1002 USER_ID: 200001 USER_NAME: root USER_GROUP: 0 USER_CLIENT_IP: 10.60.253.7 DB_ID: 500005 DB_NAME: wcnkafa SQL_ID: 597159F9B078C7D932B17784CB04FA72 QUERY_SQL: INSERT INTO gjfq SELECT * FROM gj where eventMonth = 202201 PLAN_ID: 65193 AFFECTED_ROWS: 2606 RETURN_ROWS: 0 PARTITION_CNT: 28 RET_CODE: 0 QC_ID: 0 DFO_ID: 0 SQC_ID: 0 WORKER_ID: 0 EVENT: sync rpc P1TEXT: pcode P1: 1313 P2TEXT: size P2: 1688448 P3TEXT: P3: 0 LEVEL: 0 WAIT_CLASS_ID: 107 WAIT_CLASS#: 7 WAIT_CLASS: NETWORK STATE: WAITED KNOWN TIME WAIT_TIME_MICRO: 442253 TOTAL_WAIT_TIME_MICRO: 586618 TOTAL_WAITS: 66 RPC_COUNT: 6 PLAN_TYPE: 3 IS_INNER_SQL: 0 IS_EXECUTOR_RPC: 0 IS_HIT_PLAN: 0 REQUEST_TIME: 1681890047087086 ELAPSED_TIME: 628779 NET_TIME: 0 NET_WAIT_TIME: 1 QUEUE_TIME: 16 DECODE_TIME: 0 GET_PLAN_TIME: 112967 EXECUTE_TIME: 515785 APPLICATION_WAIT_TIME: 0 CONCURRENCY_WAIT_TIME: 0 USER_IO_WAIT_TIME: 0 SCHEDULE_TIME: 0 ROW_CACHE_HIT: 0 BLOOM_FILTER_CACHE_HIT: 0 BLOCK_CACHE_HIT: 0 DISK_READS: 12 RETRY_CNT: 0 TABLE_SCAN: 0 CONSISTENCY_LEVEL: 3 MEMSTORE_READ_ROW_COUNT: 0 SSSTORE_READ_ROW_COUNT: 0 DATA_BLOCK_READ_CNT: 0 DATA_BLOCK_CACHE_HIT: 0 INDEX_BLOCK_READ_CNT: 0 INDEX_BLOCK_CACHE_HIT: 0 BLOCKSCAN_BLOCK_CNT: 0 BLOCKSCAN_ROW_CNT: 0 PUSHDOWN_STORAGE_FILTER_ROW_CNT: 0 REQUEST_MEMORY_USED: 14045599 EXPECTED_WORKER_COUNT: 0 USED_WORKER_COUNT: 0 SCHED_INFO: NULL FUSE_ROW_CACHE_HIT: 0 PS_CLIENT_STMT_ID: -1 PS_INNER_STMT_ID: -1 TX_ID: 91584731 SNAPSHOT_VERSION: 1681890047195823397 REQUEST_TYPE: 2 IS_BATCHED_MULTI_STMT: 0 OB_TRACE_INFO: NULL PLAN_HASH: 12929688451864734301 LOCK_FOR_READ_TIME: 0 PARAMS_VALUE: *************************** 2. row *************************** SVR_IP: 133.197.204.3 SVR_PORT: 2882 REQUEST_ID: 40180598 SQL_EXEC_ID: 507068779 TRACE_ID: YB4285C5CC0A-0005F7542F4E6A02-0-0 SID: 3221503593 CLIENT_IP: 133.197.204.3 CLIENT_PORT: 35302 TENANT_ID: 1002 TENANT_NAME: EFFECTIVE_TENANT_ID: 1002 USER_ID: 200001 USER_NAME: USER_GROUP: 0 USER_CLIENT_IP: 10.60.253.7 DB_ID: 500005 DB_NAME: SQL_ID: 597159F9B078C7D932B17784CB04FA72 QUERY_SQL: PLAN_ID: 65193 AFFECTED_ROWS: 0 RETURN_ROWS: 0 PARTITION_CNT: 0 RET_CODE: 0 QC_ID: 1 DFO_ID: 0 SQC_ID: 0 WORKER_ID: 0 EVENT: default condition wait P1TEXT: address P1: 140229021222360 P2TEXT: P2: 0 P3TEXT: P3: 0 LEVEL: 0 WAIT_CLASS_ID: 104 WAIT_CLASS#: 4 WAIT_CLASS: CONCURRENCY STATE: WAITED SHORT TIME WAIT_TIME_MICRO: 1083 TOTAL_WAIT_TIME_MICRO: 5732 TOTAL_WAITS: 15 RPC_COUNT: 25 PLAN_TYPE: 3 IS_INNER_SQL: 0 IS_EXECUTOR_RPC: 1 IS_HIT_PLAN: 1 REQUEST_TIME: 1681890047198543 ELAPSED_TIME: 63279 NET_TIME: 0 NET_WAIT_TIME: 0 QUEUE_TIME: 0 DECODE_TIME: 0 GET_PLAN_TIME: 0 EXECUTE_TIME: 63279 APPLICATION_WAIT_TIME: 0 CONCURRENCY_WAIT_TIME: 0 USER_IO_WAIT_TIME: 0 SCHEDULE_TIME: 0 ROW_CACHE_HIT: 252 BLOOM_FILTER_CACHE_HIT: 5181 BLOCK_CACHE_HIT: 408 DISK_READS: 0 RETRY_CNT: 0 TABLE_SCAN: 0 CONSISTENCY_LEVEL: -1 MEMSTORE_READ_ROW_COUNT: 2606 SSSTORE_READ_ROW_COUNT: 10424 DATA_BLOCK_READ_CNT: 2387 DATA_BLOCK_CACHE_HIT: 2387 INDEX_BLOCK_READ_CNT: 9955 INDEX_BLOCK_CACHE_HIT: 2387 BLOCKSCAN_BLOCK_CNT: 0 BLOCKSCAN_ROW_CNT: 0 PUSHDOWN_STORAGE_FILTER_ROW_CNT: 0 REQUEST_MEMORY_USED: 2319784 EXPECTED_WORKER_COUNT: 0 USED_WORKER_COUNT: 0 SCHED_INFO: NULL FUSE_ROW_CACHE_HIT: 0 PS_CLIENT_STMT_ID: -1 PS_INNER_STMT_ID: -1 TX_ID: 0 SNAPSHOT_VERSION: 0 REQUEST_TYPE: 4 IS_BATCHED_MULTI_STMT: 0 OB_TRACE_INFO: NULL PLAN_HASH: 0 LOCK_FOR_READ_TIME: 0 PARAMS_VALUE: 2 rows in set (0.838 sec) MySQL [(none)]>