pcp_proc_info

Description

pcp_proc_info displays the information on the given Pgpool-II child process ID.

Options

Example

Here is an example output:

    $ pcp_proc_info -p 11001
    test t-ishii 2018-05-09 11:10:16 2018-05-09 11:10:40 3 0 1 4157 1
    test t-ishii 2018-05-09 11:10:16 2018-05-09 11:10:40 3 0 1 4158 1
   

The result is in the following order:

    1. connected database name
    2. connected user name
    3. process start-up timestamp
    4. connection created timestamp
    5. protocol major version
    6. protocol minor version
    7. connection-reuse counter
    8. PostgreSQL backend process id
    9. 1 if frontend conncted 0 if not
   

If there is no connection to the backends, nothing will be displayed. If there are multiple connections, one connection's information will be displayed on each line multiple times.

The --verbose option can help understand the output. For example:

   $ pcp_proc_info -p 11001 --verbose
   Database     : test
   Username     : t-ishii
   Start time   : 2018-05-09 11:10:16
   Creation time: 2018-05-09 11:10:40
   Major        : 3
   Minor        : 0
   Counter      : 1
   Backend PID  : 4157
   Connected    : 1
   Database     : test
   Username     : t-ishii
   Start time   : 2018-05-09 11:10:16
   Creation time: 2018-05-09 11:10:40
   Major        : 3
   Minor        : 0
   Counter      : 1
   Backend PID  : 4158
   Connected    : 1