Hi Moritz,

Thanks a lot for your help.

I have tried *stethscope*. When I looked at the output, I understand that entries with *done* state display the actual time needed for execution. But what about the entries with *start* state? What does *usec* refer to in those entries?

Best regards,

Wenjian

On Thu, Aug 4, 2016 at 9:17 PM, Moritz Bruder <moritz.bruder@student.uni-tuebingen.de> wrote:

Hi,

Hi all,

MonetDB version: 11.23.7
Ubuntu version: 14.04

How could I obtain the running time information in the MAL interface of
mclient? I tried to use the *--interactive* option but it did not work.

I think what you're looking for is *stethoscope*.

I would like to obtain the running time information after getting the
result of that query. How can I do it?

Start *stethoscope* and connect it to the same database, run your query. It should now show the needed execution time for every instruction while you run it (entries with *done* state display the actual time needed for execution), and additionally you will see the complete time for your function at the end. Works for both languages I use (*mal* and *sql*).

Further information: https://www.monetdb.org/Documentation/Manuals/MonetDB/Profiler/Stethoscope

Regards,

Moritz
_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list