SHOW POOL NODES

Name

SHOW POOL_NODES --  sends back a list of all configured nodes

Synopsis

   SHOW POOL_NODES
  

Description

SHOW POOL_NODES displays the node id, the hostname, the port, the status, the weight (only meaningful if you use the load balancing mode), the role, the SELECT query counts issued to each backend, whether each node is the load balance node or not, and the replication delay (only if in streaming replication mode). The possible values in the status column are explained in the pcp_node_info reference. If the hostname is something like "/tmp", that means Pgpool-II is connecting to backend by using UNIX domain sockets. The SELECT count does not include internal queries used by Pgpool-II. Also the counters are reset to zero upon starting up of Pgpool-II.

Here is an example session:

    test=# show pool_nodes;
    node_id | hostname | port  | status | lb_weight |  role   | select_cnt | load_balance_node | replication_delay
    ---------+----------+-------+--------+-----------+---------+------------+-------------------+-------------------
    0       | /tmp     | 11002 | up     | 0.500000  | primary | 0          | false             | 0
    1       | /tmp     | 11003 | up     | 0.500000  | standby | 0          | true              | 0
    (2 rows)