> Date: Sun, 13 Oct 2013 22:29:22 +0200
> From: Stefan.Manegold@cwi.nl
> To: users-list@monetdb.org
> Subject: Re: Query execution time
>
>
> http://lmgtfy.com/?q=man+mclient
>
> http://lmgtfy.com/?q=man+tail
>
> $ echo 'select 1;' > /tmp/Q.sql
> $ echo 'select 2;' >> /tmp/Q.sql
> $ cat /tmp/Q.sql
> select 1;
> select 2;
> $ mclient -i /tmp/Q.sql | tail -n1
> 1 tuple (0.078ms)
> $ mclient -i /tmp/Q.sql | grep -E '^[0-9]+ tuples? \(.*\)$'
> 1 tuple (0.742ms)
> 1 tuple (0.682ms)
>
> http://lmgtfy.com/?q=man+grep
>
>
> Best,
> Stefan
>
> ----- Original Message -----
> > 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
> >
> > _______________________________________________
> > users-list mailing list
> > users-list@monetdb.org
> > https://www.monetdb.org/mailman/listinfo/users-list
> >
>
> --
> | Stefan.Manegold@CWI.nl | DB Architectures (DA) |
> | www.CWI.nl/~manegold/ | Science Park 123 (L321) |
> | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |
>
> _______________________________________________
> users-list mailing list
> users-list@monetdb.org
> https://www.monetdb.org/mailman/listinfo/users-list