Provided by: pgpool2_4.3.5-1_amd64 bug

NAME

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

SYNOPSIS

       pcp_proc_info [options...] [pgpool_child_processid]

DESCRIPTION

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

OPTIONS

       -a
       --all
           Display all child processes and their available connection slots.

       -P PID
       --process-id=PID
           PID of Pgpool-II child process.

       Other options
           See pcp_common_options(1).
       If -a nor -P is not specified, process information of all connected Pgpool-II child
       process will be printed. In this case if there's no connected Pgpool-II child process,
       nothing but "No process information available" message will be printed.

EXAMPLE

       Here is an example output:

           $ pcp_proc_info -p 1100
           test postgres 2021-09-28 04:16:00 (4:56 before process restarting) 1 3 0 2021-09-28 04:16:16 2021-09-28 04:16:16 0 2021-09-28 04:16:33 1 30795 0 30750 0 Wait for connection
           test postgres 2021-09-28 04:16:00 (4:56 before process restarting) 1 3 0 2021-09-28 04:16:16 2021-09-28 04:16:16 0 2021-09-28 04:16:33 1 30796 0 30750 1 Wait for connection
           test kawamoto 2021-09-28 04:16:00 0 3 0 2021-09-28 04:16:03 2021-09-28 04:16:03 34 (4:26 before client disconnected)  1 30763 1 30751 0 Idle
           test kawamoto 2021-09-28 04:16:00 0 3 0 2021-09-28 04:16:03 2021-09-28 04:16:03 34 (4:26 before client disconnected)  1 30764 1 30751 1 Idle
           $ pcp_proc_info -p 11001 30751
           test kawamoto 2021-09-28 04:16:00 0 3 0 2021-09-28 04:16:03 2021-09-28 04:16:03 58 (4:02 before client disconnected)  1 30763 1 30751 0 Idle
           test kawamoto 2021-09-28 04:16:00 0 3 0 2021-09-28 04:16:03 2021-09-28 04:16:03 58 (4:02 before client disconnected)  1 30764 1 30751 1 Idle

       The result is in the following order:

               1. connected database name
               2. connected user name
               3. process start-up timestamp (If child_life_time is set not 0, the time before process restarting is displayed.)
               4. process-reuse counter for child_max_connections
               5. protocol major version
               6. protocol minor version
               7. connection created timestamp
               8. last client connected timestamp
               9. client idle duration (sec) (If client_idle_limit is set not 0, the time before client disconnected is displayed.)
               10. last client disconnected timestamp
               11. connection-reuse counter
               12. PostgreSQL backend process id
               13. 1 if frontend connected 0 if not
               14. pgpool child process id
               15. PostgreSQL backend id
               16. process status

       If -a or --all option is not specified and 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. Timestamps are displayed in EPOCH format.

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

           $ pcp_proc_info -p 11001 --verbose
           Database                  : test
           Username                  : postgres
           Start time                : 2021-09-28 04:16:00 (2:52 before process restarting)
           Client connection count   : 1
           Major                     : 3
           Minor                     : 0
           Backend connection time   : 2021-09-28 04:16:16
           Client connection time    : 2021-09-28 04:16:16
           Client idle duration      : 0
           Client disconnection time : 2021-09-28 04:16:33
           Pool Counter              : 1
           Backend PID               : 30795
           Connected                 : 0
           PID                       : 30750
           Backend ID                : 0
           Status                    : Wait for connection

           Database                  : test
           Username                  : postgres
           Start time                : 2021-09-28 04:16:00 (2:52 before process restarting)
           Client connection count   : 1
           Major                     : 3
           Minor                     : 0
           Backend connection time   : 2021-09-28 04:16:16
           Client connection time    : 2021-09-28 04:16:16
           Client idle duration      : 0
           Client disconnection time : 2021-09-28 04:16:33
           Pool Counter              : 1
           Backend PID               : 30796
           Connected                 : 0
           PID                       : 30750
           Backend ID                : 1
           Status                    : Wait for connection

           Database                  : test
           Username                  : kawamoto
           Start time                : 2021-09-28 04:16:00
           Client connection count   : 0
           Major                     : 3
           Minor                     : 0
           Backend connection time   : 2021-09-28 04:16:03
           Client connection time    : 2021-09-28 04:16:03
           Client idle duration      : 158 (2:22 before client disconnected)
           Client disconnection time :
           Pool Counter              : 1
           Backend PID               : 30763
           Connected                 : 1
           PID                       : 30751
           Backend ID                : 0
           Status                    : Idle

           Database                  : test
           Username                  : kawamoto
           Start time                : 2021-09-28 04:16:00
           Client connection count   : 0
           Major                     : 3
           Minor                     : 0
           Backend connection time   : 2021-09-28 04:16:03
           Client connection time    : 2021-09-28 04:16:03
           Client idle duration      : 158 (2:22 before client disconnected)
           Client disconnection time :
           Pool Counter              : 1
           Backend PID               : 30764
           Connected                 : 1
           PID                       : 30751
           Backend ID                : 1
           Status                    : Idle