Re: How could I obtain the running time information in the MAL interface of mclient?

In other words: stethoscope produces two events (incl. Timestamp) for each mal statement, one when its execution "start" and one when it's "done"; for each event, the usec value is the difference between the very event's time stamp and the timestamp of its matching start event (for start events that's the event itself, hence, used == 0). Stefan On August 5, 2016 10:56:35 AM CEST, Stefan Manegold wrote:

Wenjian,

Afaik, the used value with start events should always be 0. Let us know if not.

Stefan

On August 5, 2016 8:23:31 AM CEST, "Xu,Wenjian" wrote:

...

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

------------------------------------------------------------------------

_______________________________________________ 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

-- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |