Display the Vertica Process Memory Allocated

Jim_KnicelyJim_Knicely Administrator, Moderator, Employee, Registered User, VerticaExpert
edited April 10 in Vertica Tips

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:

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

[[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:
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/AdministratorsGuide/Monitoring/Vertica/MonitoringProcessStatusPs.htm

Sign In or Register to comment.