The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Memory in management console in Activity -> Query Montioring



I am monioring queries using MC in Activity -> Query Montioring.

I am confused when i look at Memory (MB) column of it.

It shows much more than what i can seee in the system tables like RESOURCE_ACQUISITIONS (MEMORY_INUSE_KB).

Is there any diffrence in both of them?


Can somebody clear the picture for me?

What is the correct way/system table/query to get the memory acquired by a query and memory used by a quey?




  • Hi Abhi112, 


    MC uses vs_resource_acquisitions.in_memory_use_kb to get the average memory use for a running query across the nodes. This should be the same as what you see in resource_acquisitions, if you sum all the memory values where request_type != 'Acquire', and then average that value over the nodes. 


    Just in case, what version of MC and Vertica are you using? 




  • Hi Chris,


    Thanks for the response.


    Both are  v7.1.2.


    As per my understanding  (pardon me i if i am wrong, i am new to this) there is a diffrence between memory aquired by a memory and memory used by a query. Just wanted to understand how can i speciafically measure that?

  • Hi Abhi112, 


    You are right in that there is a difference. This is partially discussed in ; does that address what you're asking about?



  • Hi Chris,


    Thanks a lot!

    I am clear on this now.



Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file