mysql> SELECT MAX(ELAPSED_TIME),* FROM GV$OB_SQL_AUDIT WHERE QUERY_SQL like '%insert into widenetwork.pppoe_User_x%'\G
*************************** 1. row ***************************
              MAX(ELAPSED_TIME): 2589744
                         SVR_IP: 133.197.206.92
                       SVR_PORT: 2882
                     REQUEST_ID: 84413855
                    SQL_EXEC_ID: 543588868
                       TRACE_ID: YB4285C5CE5C-0005EEB0A59D95D4-0-0
                            SID: 3221779315
                      CLIENT_IP: 133.197.204.3
                    CLIENT_PORT: 49088
                      TENANT_ID: 1002
                    TENANT_NAME: daren
            EFFECTIVE_TENANT_ID: 1002
                        USER_ID: 200001
                      USER_NAME: root
                     USER_GROUP: 0
                 USER_CLIENT_IP: 133.197.206.97
                          DB_ID: 201001
                        DB_NAME: oceanbase
                         SQL_ID: 99B44EFB0A9CD14E900FFDA179ECB4AB
                      QUERY_SQL: SELECT * FROM GV$OB_SQL_AUDIT WHERE QUERY_SQL like '%insert into widenetwork.pppoe_User_x%'
                        PLAN_ID: 52083
                  AFFECTED_ROWS: 0
                    RETURN_ROWS: 56488
                  PARTITION_CNT: 2
                       RET_CODE: 0
                          QC_ID: 0
                         DFO_ID: 0
                         SQC_ID: 0
                      WORKER_ID: 0
                          EVENT: mysql response wait client
                         P1TEXT: 
                             P1: 0
                         P2TEXT: 
                             P2: 0
                         P3TEXT: 
                             P3: 0
                          LEVEL: 0
                  WAIT_CLASS_ID: 107
                    WAIT_CLASS#: 7
                     WAIT_CLASS: NETWORK
                          STATE: WAITED KNOWN TIME
                WAIT_TIME_MICRO: 41241
          TOTAL_WAIT_TIME_MICRO: 2437591
                    TOTAL_WAITS: 5209
                      RPC_COUNT: 18
                      PLAN_TYPE: 3
                   IS_INNER_SQL: 0
                IS_EXECUTOR_RPC: 0
                    IS_HIT_PLAN: 1
                   REQUEST_TIME: 1672039803820234
                   ELAPSED_TIME: 2589744
                       NET_TIME: 0
                  NET_WAIT_TIME: 2
                     QUEUE_TIME: 44
                    DECODE_TIME: 1
                  GET_PLAN_TIME: 324
                   EXECUTE_TIME: 2589267
          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: 0
                      RETRY_CNT: 1
                     TABLE_SCAN: 1
              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: 123070
          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: 2
          IS_BATCHED_MULTI_STMT: 0
                  OB_TRACE_INFO: NULL
                      PLAN_HASH: 13627910846214474637
             LOCK_FOR_READ_TIME: 0
                   PARAMS_VALUE: 
1 row in set (1.08 sec)

mysql>