Check reads per sec and CPU utilization

Stefan Manegold Stefan.Manegold at cwi.nl
Mon Apr 11 21:11:26 CEST 2016


Hi,

here are links to timing and performance monitoring tools that MonetDB provides,
i.e., "stethoscope", "tomograph", & "tachograph":
https://www.monetdb.org/Documentation/Manuals/MonetDB/Profiler
https://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/QueryTiming

For more, please consult the tools that your OS provides and their documentation.

Best,
Stefan


----- On Apr 11, 2016, at 7:07 PM, Shmagi Kavtaradze kavtaradze.s at gmail.com wrote:

> Maybe there are already some scripts at least to get some raw data?
> 
> On Mon, Apr 11, 2016 at 6:52 PM, Martin Kersten < Martin.Kersten at cwi.nl > wrote:
> 
> 
> indeed. for such details you should become an OS expert, starting by
> understanding memory-mapped file technology.
> 
>> On 11 apr. 2016, at 18:12, Shmagi Kavtaradze < kavtaradze.s at gmail.com > wrote:
>> 
>> I was not able to find any information how to check CPU utilization and read per
>> sec for a query. Any ideas how to get these results?
>> 
>> Thanks in advance.
>> _______________________________________________
>> users-list mailing list
>> users-list at monetdb.org
>> https://www.monetdb.org/mailman/listinfo/users-list
> 
> _______________________________________________
> users-list mailing list
> users-list at monetdb.org
> https://www.monetdb.org/mailman/listinfo/users-list
> 
> 
> _______________________________________________
> users-list mailing list
> users-list at monetdb.org
> https://www.monetdb.org/mailman/listinfo/users-list

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


More information about the users-list mailing list