pgpool_adm_pcp_node_info - a function to display the information on the given node ID

node_id
           The index of backend node to get information of.

       pcp_server
           The foreign server name for pcp server.

       Otherarguments
           See pcp_common_options(1).

pcp_node_info displays the information on the given node ID.

       Here is an example output:

           test=# SELECT * FROM pcp_node_info(node_id => 1, host => '', port => 11001, username => 't-ishii', password => 't-ishii');
            host | port  |      status       | pg_status | weight |  role   | pg_role | replication_delay | replication_state | replication_sync_state | last_status_change
           ------+-------+-------------------+-----------+--------+---------+---------+-------------------+-------------------+------------------------+---------------------
            /tmp | 11003 | Connection in use | up        |    0.5 | Standby | standby |                 0 | streaming         | async                  | 2021-02-27 15:10:19
           (1 row)

           Noterole, replication_delay, last_status_change out parameters are new from Pgpool-II 4.0. If you have
           already installed pre-4.0 pgpool_adm extension, you can upgrade to the new one by using ALTER
           EXTENSION SQL command.

                    ALTER EXTENSION pgpool_adm UPDATE;

           Notereplication_state and replication_sync_state out parameters are new from Pgpool-II 4.1. If you have
           already installed pre-4.1 pgpool_adm extension, you can upgrade to the new one by using ALTER
           EXTENSION SQL command.

                    ALTER EXTENSION pgpool_adm UPDATE;

           Notepg_status, pg_role out parameters are new from Pgpool-II 4.3. If you have already installed pre-4.2
           pgpool_adm extension, you can upgrade to the new one by using ALTER EXTENSION SQL command.

                    ALTER EXTENSION pgpool_adm UPDATE;

pgpool-II 4.6.1                                       2023                           PGPOOL_ADM_PCP_NODE_INFO(3)

       pgpool_adm_pcp_node_info - a function to display the information on the given node ID

pcp_node_inforeturnsrecord(integernode_id,texthost,integerport,textusername,textpassword,outstatustext,outpg_statustext,outweightfloat4,outroletext,outpg_roletext,outreplication_delaybigint,outreplication_statetext,outreplication_sync_statetext,outlast_status_changetimestamp);pcp_node_inforeturnsrecord(integernode_id,textpcp_server,outstatustext,outpg_statustext,outweightfloat4,outroletext,outpg_roletext,outreplication_delaybigint,outreplication_statetext,outreplication_sync_statetext,outlast_status_changetimestamp);