Display the Vertica Process Memory Allocated

Posted April 10, 2019 by James Knicely, Vertica Field Chief Technologist

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/latest/HTML/Content/Authoring/AdministratorsGuide/Monitoring/Vertica/MonitoringProcessStatusPs.htm

Have fun!