pgpool-II 4.6.0 Documentation
Prev | Up |  | Next

# pgpool_adm_pcp_node_info

## Name

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

## Synopsis

``pcp_node_info returns record`(integer `node_id`, text `host`, integer `port`, text `username`, text `password`, out `status text`, out `pg_status text`, out `weight float4`, out `role text`, out `pg_role text`, out `replication_delay bigint`, out `replication_state text`, out `replication_sync_state text`, out `last_status_change timestamp`);`

``pcp_node_info returns record`(integer `node_id`, text `pcp_server`, out `status text`, out `pg_status text`, out `weight float4`, out `role text`, out `pg_role text`, out `replication_delay bigint`, out `replication_state text`, out `replication_sync_state text`, out `last_status_change timestamp`);`

## Description

`pcp_node_info` displays the information on the given node ID.

## Arguments

`node_id`

  The index of backend node to get information of.

`pcp_server`

  The foreign server name for pcp server.

`Other arguments`

  See pcp_common_options.

## Example

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)

> Note: `role`, `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;

> Note: `replication_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;

> Note: `pg_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;

Prev | Home | Next
pgpool_adm extension | Up | pgpool_adm_pcp_health_check_stats