Displaying the Administration Tools Process ID

Jim_Knicely · October 2018

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 links:
https://www.vertica.com/docs/9.0.x/HTML/index.htm#Authoring/AdministratorsGuide/Monitoring/Vertica/MonitoringProcessStatusPs.htm

Have fun!