MySQL [oceanbase]> select query_sql,svr_ip,sql_id,plan_id,hit_count,first_load_time,ps_stmt_id,SLOW_COUNT,SLOWEST_EXE_USEC from oceanbase.gv$plan_cache_plan_stat where query_sql like 'select trans%tbl_uosonl_bill%order_index%'; +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+----------------------------------+---------+-----------+----------------------------+------------+------------+------------------+ | query_sql | svr_ip | sql_id | plan_id | hit_count | first_load_time | ps_stmt_id | SLOW_COUNT | SLOWEST_EXE_USEC | +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+----------------------------------+---------+-----------+----------------------------+------------+------------+------------------+ | select trans_no, order_index, trans_idx, mchnt_cd, order_index_hash, org_trans_no, uos_sys_id, db_tag, rec_crt_ts, rec_upd_ts from odonldb.tbl_uosonl_bill where order_index = ? | 172.21.192.195 | F43227AA868916BEFF72C5147BCE9CF8 | 12518 | 15 | 2024-02-21 11:07:58.713435 | 0 | 1 | 2014702 | | select trans_no, order_index, trans_idx, mchnt_cd, order_index_hash, org_trans_no, uos_sys_id, db_tag, rec_crt_ts, rec_upd_ts from odonldb.tbl_uosonl_bill where order_index = ? | 172.21.192.195 | F43227AA868916BEFF72C5147BCE9CF8 | 12521 | 6 | 2024-02-21 11:08:00.307836 | 879 | 1 | 3490088 | | select trans_no, order_index, trans_idx, mchnt_cd, order_index_hash, org_trans_no, uos_sys_id, db_tag, rec_crt_ts, rec_upd_ts from odonldb.tbl_uosonl_bill where order_index = ? | 172.21.192.195 | F43227AA868916BEFF72C5147BCE9CF8 | 12525 | 4 | 2024-02-21 11:09:36.424650 | 879 | 1 | 2356725 | | select trans_no, order_index, trans_idx, mchnt_cd, order_index_hash, org_trans_no, uos_sys_id, db_tag, rec_crt_ts, rec_upd_ts from odonldb.tbl_uosonl_bill where order_index='707529000188712_9b6b749e41e551923b775114b8e0c0_20240306' | 172.21.192.194 | 2A836BB081C0033A3D4DDB817D60F53D | 128333 | 0 | 2024-02-21 10:27:38.118594 | -1 | 1 | 1931706 | | select trans_no, order_index, trans_idx, mchnt_cd, order_index_hash, org_trans_no, uos_sys_id, db_tag, rec_crt_ts, rec_upd_ts from odonldb.tbl_uosonl_bill where order_index = ? | 172.21.192.194 | F43227AA868916BEFF72C5147BCE9CF8 | 128437 | 7 | 2024-02-21 11:07:56.700455 | 807 | 2 | 3906439 | | select trans_no, order_index, trans_idx, mchnt_cd, order_index_hash, org_trans_no, uos_sys_id, db_tag, rec_crt_ts, rec_upd_ts from odonldb.tbl_uosonl_bill where order_index = ? | 172.21.192.194 | F43227AA868916BEFF72C5147BCE9CF8 | 128445 | 5 | 2024-02-21 11:08:02.166997 | 0 | 1 | 1858167 | | select trans_no, order_index, trans_idx, mchnt_cd, order_index_hash, org_trans_no, uos_sys_id, db_tag, rec_crt_ts, rec_upd_ts from odonldb.tbl_uosonl_bill where order_index = ? | 172.21.192.194 | F43227AA868916BEFF72C5147BCE9CF8 | 128451 | 4 | 2024-02-21 11:09:33.048047 | 807 | 1 | 1840975 | | select trans_no, order_index, trans_idx, mchnt_cd, order_index_hash, org_trans_no, uos_sys_id, db_tag, rec_crt_ts, rec_upd_ts from odonldb.tbl_uosonl_bill where order_index='707529000188712_9b6b749e41e551923b775114b8e0c0_20240306' | 172.21.192.196 | 2A836BB081C0033A3D4DDB817D60F53D | 11635 | 0 | 2024-02-21 10:27:36.187570 | -1 | 1 | 4672995 | | select trans_no, order_index, trans_idx, mchnt_cd, order_index_hash, org_trans_no, uos_sys_id, db_tag, rec_crt_ts, rec_upd_ts from odonldb.tbl_uosonl_bill where order_index = ? | 172.21.192.196 | F43227AA868916BEFF72C5147BCE9CF8 | 11644 | 12 | 2024-02-21 11:09:25.720908 | 821 | 1 | 2139594 | | select trans_no, order_index, trans_idx, mchnt_cd, order_index_hash, org_trans_no, uos_sys_id, db_tag, rec_crt_ts, rec_upd_ts from odonldb.tbl_uosonl_bill where order_index = ? | 172.21.192.196 | F43227AA868916BEFF72C5147BCE9CF8 | 11647 | 5 | 2024-02-21 11:09:31.134339 | 0 | 1 | 2005804 | | select trans_no, order_index, trans_idx, mchnt_cd, order_index_hash, org_trans_no, uos_sys_id, db_tag, rec_crt_ts, rec_upd_ts from odonldb.tbl_uosonl_bill where order_index = ? | 172.21.192.196 | F43227AA868916BEFF72C5147BCE9CF8 | 11652 | 7 | 2024-02-21 11:09:35.134315 | 821 | 1 | 2049656 | +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+----------------------------------+---------+-----------+----------------------------+------------+------------+------------------+ 11 rows in set (0.03 sec)