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

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.

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