The index of backend node to get information of.
Here is an example output:
$ pcp_node_info -h localhost -U postgres 1 /tmp 11003 2 0.500000 up standby 0 streaming async 2019-04-23 13:58:40
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. replication state (taken from pg_stat_replication, if PostgreSQL is 9.1 or later) 9. sync replication state (taken from pg_stat_replication, if PostgreSQL is 9.2 or later) 10. last status change time
Status is represented by a digit from [0 to 3]. To correctly 7, 8, 9 are displayed, sr_check_period must not be 0. 8, 9 will not be displayed if sr_check_user is not PostgreSQL super user nor it's not in "pg_monitor" group.
GRANT pg_monitor TO sr_check_user;
For PostgreSQL 9.6, there's no pg_monitor group and sr_check_user must be PostgreSQL super user.
0 - This state is only used during the initialization. PCP will never display it.
1 - Node is up. No connections yet.
2 - Node is up. Connections are pooled.
3 - Node is down.
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 : 0 Replication State : streaming Replication Sync State : async Last Status Change : 2019-04-23 13:58:40