The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

Display the Vertica Process Memory Allocated

Jim_KnicelyJim_Knicely Administrator
edited April 2019 in Tips from the Team

For common Vertica cluster configurations, there should be a single running Vertica process on each node. You can use the Linux “ps” command to determine the process id of the Vertica process. Once you have the process id, you can display the amount of memory that has been allocated to the Vertica process using the Linux command “pmap”.


[[email protected] ~]$ ps ax | grep "[/]opt/vertica/bin/vertica " | awk '{print $1}'

[[email protected] ~]$ pmap 493879 | tail -n 1
total          8073324K

You can also use “xargs” to do it all in one command!

[[email protected] ~]$ ps ax | grep "[/]opt/vertica/bin/vertica " | awk '{print $1}' | xargs pmap | tail -n 1
total          8073324K

Helpful Link:

Sign In or Register to comment.

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.