tristaZero commented on issue #8528: URL: https://github.com/apache/shardingsphere/issues/8528#issuecomment-744193803
I guess you can get the execution time, like ``` [INFO ] 14:05:43.837 [ShardingSphere-Command-8] ShardingSphere-SQL - Logic SQL: select * from t_order where order_id in (1,2) [INFO ] 14:05:43.837 [ShardingSphere-Command-8] ShardingSphere-SQL - SQLStatement: MySQLSelectStatement(limit=Optional.empty, lock=Optional.empty) [INFO ] 14:05:43.837 [ShardingSphere-Command-8] ShardingSphere-SQL - Actual SQL: ds_0 ::: select * from t_order_0 where order_id in (1,2) [INFO ] 14:05:43.837 [ShardingSphere-Command-8] ShardingSphere-SQL - Actual SQL: ds_0 ::: select * from t_order_1 where order_id in (1,2) [INFO ] 14:05:43.837 [ShardingSphere-Command-8] ShardingSphere-SQL - Actual SQL: ds_1 ::: select * from t_order_0 where order_id in (1,2) [INFO ] 14:05:43.837 [ShardingSphere-Command-8] ShardingSphere-SQL - Actual SQL: ds_1 ::: select * from t_order_1 where order_id in (1,2) ---- New one [INFO ] 14:06:07.247 [ShardingSphere-Command-9] ShardingSphere-SQL - Logic SQL: select * from t_order_item [INFO ] 14:06:07.247 [ShardingSphere-Command-9] ShardingSphere-SQL - SQLStatement: MySQLSelectStatement(limit=Optional.empty, lock=Optional.empty) [INFO ] 14:06:07.247 [ShardingSphere-Command-9] ShardingSphere-SQL - Actual SQL: ds_0 ::: select * from t_order_item_0 [INFO ] 14:06:07.247 [ShardingSphere-Command-9] ShardingSphere-SQL - Actual SQL: ds_0 ::: select * from t_order_item_1 [INFO ] 14:06:07.247 [ShardingSphere-Command-9] ShardingSphere-SQL - Actual SQL: ds_1 ::: select * from t_order_item_0 [INFO ] 14:06:07.247 [ShardingSphere-Command-9] ShardingSphere-SQL - Actual SQL: ds_1 ::: select * from t_order_item_1 ``` ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected]
