​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 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.

...

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

On 09/04/16 06:07, Constantine Feng wrote: 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