The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Displaying the Administration Tools Process ID

Jim_KnicelyJim_Knicely - Select Field - Administrator

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.


dbadmin=> \! ps -C vertica -o pid

dbadmin=> SELECT getpid();
(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:

Have fun!

Sign In or Register to comment.