This is an automated email from the ASF dual-hosted git repository.

yiguolei pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git


The following commit(s) were added to refs/heads/master by this push:
     new 24290799c4 [improvement](tpch) run-tpch-query.sh add analyze database 
with sync and calculate total time (#21652)
24290799c4 is described below

commit 24290799c444de95942860f719bc8fccf1d8c5f1
Author: 郭小龙 <467887...@qq.com>
AuthorDate: Mon Jul 10 22:04:57 2023 +0800

    [improvement](tpch) run-tpch-query.sh add analyze database with sync and 
calculate total time (#21652)
    
    * run-tpch-query shell add analyze database with sync and calculate total 
time
    
    * run-tpch-query shell add analyze database with sync and calculate total 
time
---
 tools/tpch-tools/bin/run-tpch-queries.sh | 6 +++++-
 1 file changed, 5 insertions(+), 1 deletion(-)

diff --git a/tools/tpch-tools/bin/run-tpch-queries.sh 
b/tools/tpch-tools/bin/run-tpch-queries.sh
index b0caa4e787..0c5ee8da38 100755
--- a/tools/tpch-tools/bin/run-tpch-queries.sh
+++ b/tools/tpch-tools/bin/run-tpch-queries.sh
@@ -102,7 +102,11 @@ run_sql "show variables;"
 echo '============================================'
 run_sql "show table status;"
 echo '============================================'
-run_sql "analyze database ${DB};"
+start=$(date +%s)
+run_sql "analyze database ${DB} with sync;"
+end=$(date +%s)
+totalTime=$((end - start))
+echo "analyze database ${DB} with sync total time: ${totalTime} s"
 echo '============================================'
 echo "Time Unit: ms"
 


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org

Reply via email to