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: 郭小龙 <[email protected]>
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: [email protected]
For additional commands, e-mail: [email protected]
