The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

Displaying the Administration Tools Process ID

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!

Sign In or Register to comment.

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.