PGPOOL_A...ODE_COUNT(3)

💖 PGPOOL_A...ODE_COUNT(3) 💖

okay bestie, welcome to the pgpool-II 4.7.2 Documentation glow-up of this page, no cap ✨

---

✨ NAME ✨

pgpool_adm_pcp_node_count — a function that tells you how many backend nodes you've got. it counts them. that's the whole job. 💅

---

🌸 SYNOPSIS 🌸

pcp_node_count returns integer(text host, integer port, text username,
                               text password);

pcp_node_count returns integer(text pcp_server);

two whole ways to call it, pick your fighter 🎀

---

🦋 DESCRIPTION 🦋

pcp_node_count retrieves the number of DB nodes. literally just that. it's giving headcount for your backend 👑

---

💜 ARGUMENTS 💜

• pcp_server — the foreign server name for the pcp server. like, the name of the server you already set up, and it just goes and asks that one 🫶
• Other arguments — see pcp_common_options(1). iykyk, the whole squad of shared options lives over there 💖

---

🔥 EXAMPLE 🔥

here's what it looks like when it actually pops off:

test=# SELECT * FROM pcp_node_count(host => 'localhost', port => 11001, username => 't-ishii', password => 't-ishii');
node_count
------------
2
(1 row)

two nodes. ate. no crumbs. 😭✨

---

bestie reminder: that's localhost, port 11001, user t-ishii, password t-ishii in the example — keep those exactly as-is if you're copy-pasting, don't get creative with it 🙈

---

and that's the whole page! brought to you by pgpool-II 4.7.2, dated 2023, straight from the PGPOOL_A...ODE_COUNT(3) corner of the manual 💅🎀 bye bestie, go count some nodes 🦋