Suggestions for optimizing the log output function

Suggestions for optimizing the log output function

1、SQL1.sql
truncate aaa;
truncate bbb;
truncate ccc;
truncate ddd;
truncate eee;
truncate fff;
truncate ggg;
truncate hhh;
truncate iii;
truncate jjj;
truncate kkk;
truncate lll;
truncate mmm;
truncate nnn;
truncate ooo;

2、SQL2.sql
truncate aaa;
truncate bbb;
truncate ccc;
truncate ddd;
truncate eee;
truncate fff;
truncate ggg;
truncate hhh;
truncate iii;
truncate jjj;
truncate kkk;
truncate lll;
truncate mmm;
truncate nnn;
truncate ooo;


3、SQL3.sql
truncate aaa;
truncate bbb;
truncate ccc;
truncate ddd;
truncate eee;
truncate fff;
truncate ggg;
truncate hhh;
truncate iii;
truncate jjj;
truncate kkk;
truncate lll;
truncate mmm;
truncate nnn;
truncate ooo;


4、The output results

------ Execution started: Connection: SQL1.sql ------

DML succeeded [0.221s]
Execute succeeded [0.167s]
Execute succeeded [0.182s]

------ Execution started: Connection: SQL2.sql ------

Execute succeeded [0.200s]
DML succeeded [0.274s]
Execute succeeded [0.268s]
Execute succeeded [0.117s]
Execute succeeded [0.165s]
Execute succeeded [0.157s]
Execute succeeded [0.150s]
Execute succeeded [0.158s]

------ Execution started: Connection: SQL3.sql ------

Execute succeeded [0.200s]
Execute succeeded [0.200s]
DML succeeded [0.205s]
Execute succeeded [0.167s]
Execute succeeded [0.198s]
Execute succeeded [0.214s]
Execute succeeded [0.184s]
Execute succeeded [0.178s]
Execute succeeded [0.211s]
Execute succeeded [0.183s]
Execute succeeded [0.209s]
Execute succeeded [0.167s]
Execute succeeded [0.167s]
Execute succeeded [0.172s]
Execute succeeded [0.167s]
Execute succeeded [0.151s]
Execute succeeded [0.158s]
Execute succeeded [0.172s]
Execute succeeded [0.192s]
Execute succeeded [0.142s]
Execute succeeded [0.164s]
Execute succeeded [0.192s]

------------ Done: SQL1.sql [2.769s] -------------
Execute succeeded [0.200s]
Execute succeeded [0.194s]
Execute succeeded [0.133s]
Execute succeeded [0.181s]
Execute succeeded [0.153s]
Execute succeeded [0.153s]
Execute succeeded [0.183s]

------------ Done: SQL2.sql [2.632s] -------------
Execute succeeded [0.117s]
Execute succeeded [0.141s]
Execute succeeded [0.125s]
Execute succeeded [0.100s]
Execute succeeded [0.116s]

------------ Done: SQL3.sql [2.447s] -------------



5、Suggestion Explanation
For example, with the above three SQL query windows（1、2、3）, I executed queries on all three windows simultaneously, and the output results（4）.

Question:
a. The log output corresponding to each window is segmented.
b. It is difficult to know the execution duration of each SQL statement (as one needs to compare each one individually), and the overall situation is quite chaotic. I am not sure if the correspondence between the outputs above is consistent.
Suggestion:
a. One SQL query window corresponds to one log output, or they are integrated.
b. The output log is recommended to follow the following format:


truncate aaa
> Execute succeeded
> Query TIme: 0.153s


truncate bbb
> Execute succeeded
> Query TIme: 0.136s


truncate ccc
> Execute succeeded
> Query TIme: 0.146s


truncate ddd
> Execute succeeded
> Query TIme: 0.125s


truncate eee
> Execute succeeded
> Query TIme: 0.124s


truncate fff
> Execute succeeded
> Query TIme: 0.128s


truncate ggg
> Execute succeeded
> Query TIme: 0.121s


truncate hhh
> Execute succeeded
> Query TIme: 0.119s


truncate iii
> Execute succeeded
> Query TIme: 0.113s


truncate jjj
> Execute succeeded
> Query TIme: 0.116s


truncate kkk
> Execute succeeded
> Query TIme: 0.144s


truncate lll
> Execute succeeded
> Query TIme: 0.116s


truncate mmm
> Execute succeeded
> Query TIme: 0.130s


truncate nnn
> Execute succeeded
> Query TIme: 0.116s


truncate ooo
> Execute succeeded
> Query TIme: 0.117s