​Hi Martin,

Thanks. stethoscope does do some work. But since it is for online monitoring, it is inconvenient for offline analysis of trace profiles.
After reading more docs on the web, I find Tachograph comes closest to what I want.
A minor problem is that the schema of the generated files (.trace, .csv, .json) is not given.
Somehow I have to guess. And seems that each file format covers a different subset of attributes.

- Neo​

 

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

Message: 2
Date: Sat, 9 Apr 2016 08:17:15 +0200
From: Martin Kersten <martin.kersten@cwi.nl>
To: users-list@monetdb.org
Subject: Re: How to do profiling in MAL interface?
Message-ID: <57089E6B.7050504@cwi.nl>
Content-Type: text/plain; charset=windows-1252; format=flowed

You better consider using the stethoscope for doing this kind of analysis.
The documentation need some updates.


On 09/04/16 06:07, Constantine Feng wrote:
> Hi all,
>
> I know I can use the TRACE SQL command. But I want to do it in the "-lmal" interface (because I massaged the MAL plans a bit to test my research ideas).
>
> Particularly, I find the information given on this website (https://www.monetdb.org/Documentation/Manuals/MonetDB/Modules/profiler ) doesn't match the source code. I can't find the profiler.activate() or profiler.deactivate(), for example.
>
>
> mal>manual.help("profiler.*");
> profiler.cpuload
> profiler.cpustats
> profiler.cleanup
> profiler.closeStream
> profiler.dumpTrace
> profiler.getSystemTime
> profiler.getUserTime
> profiler.getDiskWrites
> profiler.getDiskReads
> profiler.getTrace
> profiler.noop
> profiler.openStream
> profiler.reset
> profiler.setHeartbeat
> profiler.stop
> profiler.stethoscope
> profiler.tomograph
>
>
> Version: (Jul2015-SP3). Build from source.
>
> - Neo
>
>
> _______________________________________________
> users-list mailing list
> users-list@monetdb.org
> https://www.monetdb.org/mailman/listinfo/users-list
>