MySQL [(none)]> select * from oceanbase.gv$ob_sql_audit where trace_id='YB4285C5CC03-0005F71D301FC28B-0-0' limit 1\G *************************** 1. row *************************** SVR_IP: 133.197.204.13 SVR_PORT: 2882 REQUEST_ID: 1342399 SQL_EXEC_ID: 279449644 TRACE_ID: YB4285C5CC03-0005F71D301FC28B-0-0 SID: 3222976369 CLIENT_IP: 10.60.154.36 CLIENT_PORT: 63700 TENANT_ID: 1002 TENANT_NAME: EFFECTIVE_TENANT_ID: 1002 USER_ID: 200001 USER_NAME: USER_GROUP: 0 USER_CLIENT_IP: 10.60.154.36 DB_ID: 500005 DB_NAME: SQL_ID: A6750E62248590736B903CAA953DCFBB QUERY_SQL: PLAN_ID: 213336 AFFECTED_ROWS: 0 RETURN_ROWS: 0 PARTITION_CNT: 0 RET_CODE: 0 QC_ID: 1 DFO_ID: 1 SQC_ID: 0 WORKER_ID: 7 EVENT: db file data read P1TEXT: fd P1: 8192 P2TEXT: offset P2: 0 P3TEXT: size P3: 0 LEVEL: 0 WAIT_CLASS_ID: 108 WAIT_CLASS#: 8 WAIT_CLASS: USER_IO STATE: WAITED KNOWN TIME WAIT_TIME_MICRO: 157693 TOTAL_WAIT_TIME_MICRO: 29308287 TOTAL_WAITS: 24543 RPC_COUNT: 45 PLAN_TYPE: 3 IS_INNER_SQL: 0 IS_EXECUTOR_RPC: 1 IS_HIT_PLAN: 1 REQUEST_TIME: 1681715093569025 ELAPSED_TIME: 31636694 NET_TIME: 0 NET_WAIT_TIME: 0 QUEUE_TIME: 0 DECODE_TIME: 0 GET_PLAN_TIME: 0 EXECUTE_TIME: 31636694 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: 151549 DISK_READS: 303 RETRY_CNT: 0 TABLE_SCAN: 0 CONSISTENCY_LEVEL: -1 MEMSTORE_READ_ROW_COUNT: 0 SSSTORE_READ_ROW_COUNT: 0 DATA_BLOCK_READ_CNT: 75926 DATA_BLOCK_CACHE_HIT: 75626 INDEX_BLOCK_READ_CNT: 151852 INDEX_BLOCK_CACHE_HIT: 75923 BLOCKSCAN_BLOCK_CNT: 0 BLOCKSCAN_ROW_CNT: 0 PUSHDOWN_STORAGE_FILTER_ROW_CNT: 0 REQUEST_MEMORY_USED: 82665512 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: 1 row in set (0.186 sec) MySQL [(none)]>