Hai Mahmoud,
On 11 Sep 2018, at 17:49, Mahmoud Mohsen mmohsen35@gmail.com wrote:
Hello,
Is there away to measure the physical or virtual memory consumption of Monetdb using an SQL query.
No, not with an SQL query.
you can use ‘top -p <pid-of-your-mserver5>’ to observe/measure the memory consumption of MonetDB during the execution of an SQL query.
Alsternatively, you can capture the execution trace of a query using the “Stethoscope” tool (https://www.monetdb.org/Documentation/Manuals/MonetDB/Profiler/Stethoscope). The trace contains a.o. the RSS info. Note that that web page for Stethoscope is out-dated. You can get the trace in JSON format by default, i.s.o. per line. Just search for “rss” in the JSON data...
Something similar to select * from storage() where table_name = name;
I believe storage() helps with the disk consumption not main memory consumption, am I right?
Yes, you’re right.
Jennie
Thank you a lot in advance,
Mahmoud Mohsen _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list