---
name: "pgpool_adm_pcp_node_count"
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_count"
---

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

a function to retrieves number of backend nodes.

## NAME

pgpool\_adm\_pcp\_node\_count - a function to retrieves number of backend nodes.

## SYNOPSIS

**pcp\_node\_count returns integer(text** *host***, integer** *port***, text** *username***, text** *password***);**

**pcp\_node\_count returns integer(text** *pcp\_server***);**

## DESCRIPTION

**pcp\_node\_count** retrieves number of DB nodes.

## ARGUMENTS

*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_count(host => 'localhost', port => 11001, username => 't-ishii', password => 't-ishii');
    node_count
    ------------
    2
    (1 row)
```