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