PCP_HEALT...ECK_STATS(1)

💖 pcp_health_check_stats(1) — the pgpool-II 4.7.2 glow-up edition 💖

okay bestie, sit down, hydrate, because we're about to read some health check statistics together and honestly? it's giving main character energy for your backend nodes. this is part of the pgpool-II 4.7.2 docs, and yes, the manual page is literally called pcp_health_check_stats(1). iconic.

---

🌸 NAME 🌸

pcp_health_check_stats</p> — displays health check statistics data on given node ID 💅

---

✨ SYNOPSIS ✨

pcp_health_check_stats [option...] [node_id]

---

🦋 DESCRIPTION 🦋

so like, pcp_health_check_stats displays health check statistics data on given node ID. that's the whole vibe. you point it at a node, it spills the tea about that node's health checks. periodt. 💖

---

🎀 OPTIONS 🎀

• -n _node_id_, --node-id=_node_id_ — the index of backend node to get information of. that's the one you wanna snoop on, bestie 👑

other options 🫶

• See pcp_common_options(1). they're the shared ones, iykyk.

---

⭐ EXAMPLE ⭐

here's an example output, look at her go:

$ pcp_health_check_stats -h localhost -p 11001 -w 0
0 /tmp 11002 up primary 2020-02-24 22:02:42 3 3 0 0 0 0.000000 0 5 1 3.666667 2020-02-24 22:02:47 2020-02-24 22:02:47
$ pcp_health_check_stats -h localhost -p 11001 -w -v 0
Node Id                       : 0
Host Name                     : /tmp
Port                          : 11002
Status                        : up
Role                          : primary
Last Status Change            : 2020-02-24 22:02:42
Total Count                   : 5
Success Count                 : 5
Fail Count                    : 0
Skip Count                    : 0
Retry Count                   : 0
Average Retry Count           : 0.000000
Max Retry Count               : 0
Max Health Check Duration     : 5
Minimum Health Check Duration : 1
Average Health Check Duration : 4.200000
Last Health Check             : 2020-02-24 22:03:07
Last Successful Health Check  : 2020-02-24 22:03:07
Last Skip Health Check        :
Last Failed Health Check      :

and before you ask — yes, the -v version is the verbose one and it ate. every single field is right there. no cap.

See Table 29, “Statistics data shown by pool_health_check_stats command” for details of data. 📖✨

---

that's the whole page, bestie, you're officially fluent. this little gem lives in the pgpool-II 4.7.2 documentation, dated 2023, filed under PCP_HEALT...ECK_STATS(1). go check on your nodes, they miss you 🫶💖🌈