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

// determine the Estimated Time of Completion if ( pci->calls){ logadd("\"usec\":"LLFMT",%s", pci->totticks/pci->calls, prettify); } else{ logadd("\"usec\":"LLFMT",%s", pci->ticks, prettify); } Running the same MAL procedure leads to accumulated timings, which provides an indication how long a MAL instruction is likely to take. On 05/08/16 10:56, 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 mailto: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 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

-- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold http://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