---
name: "pgpool_adm_pcp_node_info"
section: "3"
platform: "linux"
package: "pgpool2"
version: "4.6.1-2"
release: "Debian 13 (Trixie)"
platforms: ["linux"]
url: "https://new.carta.tech/pgpool_adm_pcp_node_info"
---

# pgpool\_adm\_pcp\_node\_info(3)

a function to display the information on the given node ID

## 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**(1)](/pcp_common_options/1.md).

## 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;
```