pcp_node_info

Name

pcp_node_info --  displays the information on the given node ID

Synopsis

pcp_node_info [option...] [node_id]

Description

pcp_node_info displays the information on the given node ID.

Options

-n node_id
--node-id=node_id

The index of backend node to get information of.

Other options

See pcp_common_options.

Example

Here is an example output:

    $ pcp_node_info -h localhost -U postgres 1
    /tmp 11003 2 0.500000 up standby 208 2018-07-03 08:26:39
   

The result is in the following order:

    1. hostname
    2. port number
    3. status
    4. load balance weight
    5. status name
    6. backend role
    7. replication delay
    8. last status change time
   

Status is represented by a digit from [0 to 3].

The load balance weight is displayed in normalized format.

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

   $ pcp_node_info --verbose -h localhost -U postgres 1
   Hostname          : /tmp
   Port              : 11003
   Status            : 2
   Weight            : 0.500000
   Status Name       : up
   Role              : standby
   Replication Delay : 208
   Last Status Change: 2018-07-03 08:26:39