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!

Monitoring memory usage

kxukxu Employee
edited April 2020 in General Discussion

The QUERY_EXECUTIONS table has all the information required to analyze a query except memory used. For memory consumption, we need to check the RESOURCE_ACQUISITIONS, which shows the memory consumed for query per node. Is there a way to view the total memory consumed by a query in the QUERY_EXECUTIONS table?
Optimizing Query Performance and Resource Pool Tuning
@rbankula @bat


  • You could sum it up for all nodes, but I'm not sure how useful that would be. Most nodes should generally have the same memory utilization, unless you have massive data skew.

Leave a Comment

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