[MonetDB-users] how to measure a query execution time

xxiao xxiao at iupui.edu
Mon Oct 8 17:02:55 CEST 2007


Hi, 

I need to measure the sql query execution time. So I used "-t" option with
mclient command. 

For example, I use "mclient -lsql -umonetdb -Pmonetdb -t < 15.sql" to
execute query 15 in TPC-H benchmark. I have the following outputs:

Timer     935.765 msec 
Timer     717.294 msec 
Timer       0.163 msec 
% sys.supplier, sys.supplier,   sys.supplier,   sys.supplier,   sys.revenue0
# table_name
% s_suppkey,    s_name, s_address,      s_phone,        total_revenue # name
% int,  varchar,        varchar,        varchar,        decimal # type
% 4,    18,     17,     15,     21 # length
[ 8449, "Supplier#000008449",   "Wp34zim9qYFbVctdW",    "20-469-856-8873",    
1772627.2087     ]
Timer    3559.856 msec 
Timer       0.079 msec 
Timer      63.676 msec 
Timer       0.890 msec 
% .stats,       .stats # table_name
% rewrite,      count # name
% clob, int # type
% 7,    1 # length
[ "joinidx",    0       ]
Timer       1.043 msec 


There are multiple lines started with "Timer" and ended by a time
measurement in milli-sec. So is the execution time of query 15 in TPC-H
equal to the sum of all these time measurements. 

In this case,
935.765+717.294+0.163+3559.856+0.079+63.676+0.890+1.043=5278.766 msec.

I appreciate your response.

Xiang
-- 
View this message in context: http://www.nabble.com/how-to-measure-a-query-execution-time-tf4588760.html#a13098410
Sent from the monetdb-users mailing list archive at Nabble.com.





More information about the users-list mailing list