pgpool-II 4.7.2 Documentation
Prev | Up |  | Next

# pcp_proc_info

## 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.

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 11001
    test t-ishii 2025-06-24 10:53:35 0 3 0 2025-06-24 10:55:58 2025-06-24 10:55:59 0  1 1336703 1 1336537 0 Idle 0 192.168.10.11 39216
    test t-ishii 2025-06-24 10:53:35 0 3 0 2025-06-24 10:55:58 2025-06-24 10:55:59 0  1 1336704 1 1336537 1 Idle 1 192.168.10.11 39216
    test t-ishii 2025-06-24 10:53:35 (4:03 before process restarting) 1 3 0 2025-06-24 10:53:42 2025-06-24 10:53:42 0 2025-06-24 10:55:37 1 1336573 0 1336544 0 Wait for connection 0 192.168.10.11 39162
    test t-ishii 2025-06-24 10:53:35 (4:03 before process restarting) 1 3 0 2025-06-24 10:53:42 2025-06-24 10:53:42 0 2025-06-24 10:55:37 1 1336574 0 1336544 1 Wait for connection 0 192.168.10.11 39162

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
        17. 1 if backend is load balance node and frontend connected, 0 otherwise
        18. client's host name
        19. client's port number (not shown if Unix domain socket or localhost)
        20. SQL statement last executed

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                  : t-ishii
    Start time                : 2025-06-24 10:53:35
    Client connection count   : 0
    Major                     : 3
    Minor                     : 0
    Backend connection time   : 2025-06-24 10:55:58
    Client connection time    : 2025-06-24 10:55:59
    Client idle duration      : 0
    Client disconnection time :
    Pool Counter              : 1
    Backend PID               : 1336703
    Connected                 : 1
    PID                       : 1336537
    Backend ID                : 0
    Status                    : Idle
    Load balance node         : 0
    client_host               : 192.168.10.11
    client_port               : 39216
    statement                 :

    Database                  : test
    Username                  : t-ishii
    Start time                : 2025-06-24 10:53:35
    Client connection count   : 0
    Major                     : 3
    Minor                     : 0
    Backend connection time   : 2025-06-24 10:55:58
    Client connection time    : 2025-06-24 10:55:59
    Client idle duration      : 0
    Client disconnection time :
    Pool Counter              : 1
    Backend PID               : 1336704
    Connected                 : 1
    PID                       : 1336537
    Backend ID                : 1
    Status                    : Idle
    Load balance node         : 1
    client_host               : 192.168.10.11
    client_port               : 39216
    statement                 : select 1;

    Database                  : test
    Username                  : t-ishii
    Start time                : 2025-06-24 10:53:35 (4:33 before process restarting)
    Client connection count   : 1
    Major                     : 3
    Minor                     : 0
    Backend connection time   : 2025-06-24 10:53:42
    Client connection time    : 2025-06-24 10:53:42
    Client idle duration      : 0
    Client disconnection time : 2025-06-24 10:55:37
    Pool Counter              : 1
    Backend PID               : 1336573
    Connected                 : 0
    PID                       : 1336544
    Backend ID                : 0
    Status                    : Wait for connection
    Load balance node         : 0
    client_host               : 192.168.10.11
    client_port               : 39162
    statement                 : DISCARD ALL

    Database                  : test
    Username                  : t-ishii
    Start time                : 2025-06-24 10:53:35 (4:33 before process restarting)
    Client connection count   : 1
    Major                     : 3
    Minor                     : 0
    Backend connection time   : 2025-06-24 10:53:42
    Client connection time    : 2025-06-24 10:53:42
    Client idle duration      : 0
    Client disconnection time : 2025-06-24 10:55:37
    Pool Counter              : 1
    Backend PID               : 1336574
    Connected                 : 0
    PID                       : 1336544
    Backend ID                : 1
    Status                    : Wait for connection
    Load balance node         : 0
    client_host               : 192.168.10.11
    client_port               : 39162
    statement                 :

Prev | Home | Next
pcp_proc_count | Up | pcp_pool_status