PCP_PROC_INFO(1)

📦
version 4.7.2 · 7 versions
, in ubuntu stonking

🎀 PCP_PROC_INFO(1) — like, the pgpool-II 4.7.2 manual, but bestie-fied 💅

okay so hi, welcome to section 1 of the pgpool-II 4.7.2 docs, this is pcp_proc_info, and she is literally the girl who spills the tea on a Pgpool-II child process. no cap. 🫖✨

✨ NAME ✨

pcp_proc_info — shows you all the info on the Pgpool-II child process ID you hand her. it's giving receipts. 🧾

🌸 SYNOPSIS 🌸

pcp_proc_info [options...] [pgpool_child_processid]

🦋 DESCRIPTION 🦋

pcp_proc_info displays the information on the given Pgpool-II child process ID.

that's it, that's the whole vibe. you give her a child process ID, she tells you everything about it. main character behavior honestly. 👑

💖 OPTIONS 💖

  • -a, --all — display all child processes and their available connection slots. the full group chat, everyone's here. 💬
  • -P PID, --process-id=PID — PID of the Pgpool-II child process. like, specifically this one.

🌈 Other options

🫶 heads up bestie: if neither -a nor -P is not specified, process information of all connected Pgpool-II child process will be printed. In this case if there's no connected Pgpool-II child process, nothing but "No process information available" message will be printed. so like... you get something. sometimes that something is just a little sad sentence. 😭

🔥 EXAMPLE 🔥

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

$ pcp_proc_info -p 11001
test t-ishii 2025-06-24 10:53:35 0 3 0 2025-06-24 10:55:58 2025-06-24 10:55:59 0  1 1336703 1 1336537 0 Idle 0 192.168.10.11 39216
test t-ishii 2025-06-24 10:53:35 0 3 0 2025-06-24 10:55:58 2025-06-24 10:55:59 0  1 1336704 1 1336537 1 Idle 1 192.168.10.11 39216
test t-ishii 2025-06-24 10:53:35 (4:03 before process restarting) 1 3 0 2025-06-24 10:53:42 2025-06-24 10:53:42 0 2025-06-24 10:55:37 1 1336573 0 1336544 0 Wait for connection 0 192.168.10.11 39162
test t-ishii 2025-06-24 10:53:35 (4:03 before process restarting) 1 3 0 2025-06-24 10:53:42 2025-06-24 10:53:42 0 2025-06-24 10:55:37 1 1336574 0 1336544 1 Wait for connection 0 192.168.10.11 39162

the result is in the following order, and yes you need all 20, she does not skip steps:

  1. connected database name
  2. connected user name
  3. process start-up timestamp (If child_life_time is set not 0, the time before process restarting is displayed.)
  4. process-reuse counter for child_max_connections
  5. protocol major version
  6. protocol minor version
  7. connection created timestamp
  8. last client connected timestamp
  9. client idle duration (sec) (If client_idle_limit is set not 0, the time before client disconnected is displayed.)
  10. last client disconnected timestamp
  11. connection-reuse counter
  12. PostgreSQL backend process id
  13. 1 if frontend connected 0 if not
  14. pgpool child process id
  15. PostgreSQL backend id
  16. process status
  17. 1 if backend is load balance node and frontend connected, 0 otherwise
  18. client's host name
  19. client's port number (not shown if Unix domain socket or localhost)
  20. SQL statement last executed

ngl that's a lot of columns. slay. 👑

If -a or --all option is not specified and there is no connection to the backends, nothing will be displayed. If there are multiple connections, one connection's information will be displayed on each line multiple times. Timestamps are displayed in EPOCH format.

the --verbose option can help understand the output. for example:

$ pcp_proc_info -p 11001 --verbose
Database                  : test
Username                  : t-ishii
Start time                : 2025-06-24 10:53:35
Client connection count   : 0
Major                     : 3
Minor                     : 0
Backend connection time   : 2025-06-24 10:55:58
Client connection time    : 2025-06-24 10:55:59
Client idle duration      : 0
Client disconnection time :
Pool Counter              : 1
Backend PID               : 1336703
Connected                 : 1
PID                       : 1336537
Backend ID                : 0
Status                    : Idle
Load balance node         : 0
client_host               : 192.168.10.11
client_port               : 39216
statement                 :

Database                  : test
Username                  : t-ishii
Start time                : 2025-06-24 10:53:35
Client connection count   : 0
Major                     : 3
Minor                     : 0
Backend connection time   : 2025-06-24 10:55:58
Client connection time    : 2025-06-24 10:55:59
Client idle duration      : 0
Client disconnection time :
Pool Counter              : 1
Backend PID               : 1336704
Connected                 : 1
PID                       : 1336537
Backend ID                : 1
Status                    : Idle
Load balance node         : 1
client_host               : 192.168.10.11
client_port               : 39216
statement                 : select 1;

Database                  : test
Username                  : t-ishii
Start time                : 2025-06-24 10:53:35 (4:33 before process restarting)
Client connection count   : 1
Major                     : 3
Minor                     : 0
Backend connection time   : 2025-06-24 10:53:42
Client connection time    : 2025-06-24 10:53:42
Client idle duration      : 0
Client disconnection time : 2025-06-24 10:55:37
Pool Counter              : 1
Backend PID               : 1336573
Connected                 : 0
PID                       : 1336544
Backend ID                : 0
Status                    : Wait for connection
Load balance node         : 0
client_host               : 192.168.10.11
client_port               : 39162
statement                 : DISCARD ALL

Database                  : test
Username                  : t-ishii
Start time                : 2025-06-24 10:53:35 (4:33 before process restarting)
Client connection count   : 1
Major                     : 3
Minor                     : 0
Backend connection time   : 2025-06-24 10:53:42
Client connection time    : 2025-06-24 10:53:42
Client idle duration      : 0
Client disconnection time : 2025-06-24 10:55:37
Pool Counter              : 1
Backend PID               : 1336574
Connected                 : 0
PID                       : 1336544
Backend ID                : 1
Status                    : Wait for connection
Load balance node         : 0
client_host               : 192.168.10.11
client_port               : 39162
statement                 :

see? so much prettier with labels. the --verbose flag is the glow-up fr fr. ✨

okay that's the whole page bestie, go forth and inspect those processes 💜

this little love letter comes to you from pgpool-II 4.7.2, dated 2023, and it lives in section 1 of the manual. mwah. 💋🎀🦋

📦 where this page comes from