Measure the memory footprint of Monetdb from an SQL client
Hello, Is there away to measure the physical or virtual memory consumption of Monetdb using an SQL query. 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? Thank you a lot in advance, Mahmoud Mohsen
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
participants (2)
-
Mahmoud Mohsen -
Ying Zhang