
From within vsql you can run the Linux ps command to display the Administration Tools process on the local node. However, it’s a lot easier to use the GETPID function.
Example:
dbadmin=> \! ps -C vertica -o pid
PID
233418
dbadmin=> SELECT getpid();
getpid
--------
233418
(1 row)
dbadmin=> SELECT 'The Administration Tools process ID on node ' || local_node_name() || ' is ' || getpid() || '!' "Good 2 Know";
Good 2 Know
---------------------------------------------------------------------------
The Administration Tools process ID on node v_test_db_node0001 is 233418!
(1 row)
Helpful link:https://www.vertica.com/docs/latest/HTML/index.htm#Authoring/AdministratorsGuide/Monitoring/Vertica/MonitoringProcessStatusPs.htm
Have fun!