I tried to execute it with a file (Q.sql) containing more than one query, it seems that it gives me the total execution time with the number of tuple for the last query in the file. Is there something else to do in order to get the execution time of each of the queries.

mclient -i -u monetdb -d voc query.sql | tail -n1

Best regards,
Baraa

> Date: Sun, 13 Oct 2013 16:50:08 +0200
> From: martin@monetdb.org
> To: users-list@monetdb.org
> Subject: Re: Query execution time
>
> On 10/13/13 4:41 PM, Stefan Manegold wrote:
> >> GREAT EXPLICATION!
> >> Thanks for this helpful and clear explication. I think it's very benificial
> >> to add it somewhere on the documentation of MonetDB (if it's not already the
> >> case); I spent three days googling and trying to understand how is that
> >> works.
> See: http://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/QueryTiming
> Clear enough?
> > The explanation of "time" is on its man page.
> > We'll consider adding the explanation of mclient's "-i" option to its man page.
> >
> >> I have one more question please, what if I have more that one query in my
> >> Q.sql? can I get the time (2: reported by mclient -i option) for each of the
> >> queries or I can only get the total time?
> > unless you have more than one query per line, you'll get individual times.
> >
> > Stefan
> _______________________________________________
> 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