Thanks for the link and the explication. In fact I'm running the query normally first (without the time option) and I get about 600ms at the end of the execution. Then when I use time mclient -d db query.sql/dev/null that gives me real 1m3.895suser 0m15.640ssys 0m2.160s So it's not really the issu of cold and hot data because for the first normal execution I got a time much more smaller than the second one using Time. I really appriciate your help because I need to get the exact real execution time. One more question please what is the meaning of real, user and sys or where I can find the difinition of these parameters. Thanks again Date: Sun, 13 Oct 2013 14:36:16 +0200 From: martin@monetdb.org To: users-list@monetdb.org Subject: Re: Query execution time perhaps this might help http://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/QueryTiming On 10/13/13 12:31 PM, baraa Mohamad wrote: That's great! Thank you very much for your appreciated help. I just could't really understand the output of this command. This is my output: Real: 1m23 User: 0m24s Sys: 0m2.3s I'm a little bit confused because when I execute the same query directly without the time option i get 733,28ms. So i couldn't know what is the real execution time. Le 13 oct. 2013 à 11:29, "Martin Kersten" <Martin.Kersten@cwi.nl> a écrit : How about (time mclient -d db <inputfile >/dev/null) On 10/13/13 11:24 AM, baraa Mohamad wrote: Thank you for your answer. But in general I would like to know how to get the query exexution time without printing the results. It's for performance comparaison. I want to evaluate MonetDB for my research and i'm working with large tables. Please any idea?? Greetings, Baraa Le 13 oct. 2013 à 11:02, "Martin Kersten" <Martin.Kersten@cwi.nl <mailto:Martin.Kersten@cwi.nl>> a écrit : Hi On 10/13/13 10:55 AM, baraa Mohamad wrote: Hello dear MontDB users, I have a question please, I just need to get the query execution time without showing the results of the query (for performance comparaison) . Something which corresponds to the "traceonly" in Oracle. that will be greate if I can see the query plan but for the moment the most important for me is to get the query execution time. for example: I want to know the query exection time of this query (select * from source where a>10) knowing that I have more than one This is not the ind of query you fire when you expect a large outcome. Better use SELECT COUNT(*).... hundred million records which correspond to this predicate. Thank in advace for your appreciated help. Baraa _______________________________________________ users-list mailing list users-list@monetdb.org <mailto:users-list@monetdb.org> https://www.monetdb.org/mailman/listinfo/users-list _______________________________________________ users-list mailing list users-list@monetdb.org <mailto:users-list@monetdb.org> https://www.monetdb.org/mailman/listinfo/users-list _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list