Display the Vertica Process Memory Allocated

Jim_KnicelyJim_Knicely - Select Field - 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”.

Example:

[dbadmin@s18384357 ~]$ ps ax | grep "[/]opt/vertica/bin/vertica " | awk '{print $1}'
493879

[dbadmin@s18384357 ~]$ pmap 493879 | tail -n 1
total          8073324K

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

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

Helpful Link:
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/AdministratorsGuide/Monitoring/Vertica/MonitoringProcessStatusPs.htm

Sign In or Register to comment.