Skip to main content

Display the Vertica Process Memory Allocated

  • April 10, 2019
  • 0 replies
  • 1 view

Jim_Knicely
Forum|alt.badge.img+2

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