SHOW_POOL_PROCESSES(1)

💖 NAME 💖

SHOW_POOL_PROCESSES — bestie, this one slides back a whole list of every Pgpool-II process that's just vibing, waiting for connections, or actively dealing with one.

---

✨ SYNOPSIS ✨

SHOW POOL_PROCESSES

---

🌸 DESCRIPTION 🌸

okay so SHOW_POOL_PROCESSES sends back a list of all the Pgpool-II processes that are waiting for connections and dealing with a connection. that's it, that's the whole job. icon behavior honestly.

it's giving 8 columns, and here they are, no skipping:

• pool_pid — the PID of the Pgpool-II process that's on display. that's its whole government name.
• start_time — the timestamp of when this process was launched. it's the process's birthday, basically 🎂
  • if child_life_time is set to not 0, the time before process restarting gets displayed too. (yes, "is set not 0" — that's the original wording, i don't make the rules 💅)
• client_connection_count — counts the number of times this process has been used by clients. how many times the girlies came through.
• database — the database name of the currently active backend for this process.
• username — the user name used in the connection of the currently active backend for this process.
• backend_connection_time — the creation time and date of the connection.
• pool_counter — counts the number of times this pool of connections (the process) has been used by clients. lowkey the same energy as client_connection_count but for the whole pool, and yes they both live here, we don't question it.
• status — current status of this process. possible values are:
  • Execute command: Executing a command.
  • Idle: The process is waiting for a new client command.
  • Idle: The process is waiting for a new client command in a transaction.
  • Wait for connection: The process is waiting for a new client connection.

the Idle status shows up twice on purpose, bestie — one for plain idle, one for idle inside a transaction. don't come for me, that's just what the page says 🫶

---

🦋 here's a lil example session 🦋

test=# show pool_processes;
 pool_pid |                      start_time                      | client_connection_count | database | username | backend_connection_time | pool_counter |       status
----------+------------------------------------------------------+-------------------------+----------+----------+-------------------------+--------------+---------------------
 32641    | 2021-09-28 04:40:45                                  | 0                       |          |          |                         |              | Wait for connection
 32642    | 2021-09-28 04:40:45                                  | 0                       |          |          |                         |              | Wait for connection
 32643    | 2021-09-28 04:40:45                                  | 0                       | test     | kawamoto | 2021-09-28 04:40:48     | 1            | Idle
 32644    | 2021-09-28 04:40:45                                  | 0                       | test     | kawamoto | 2021-09-28 04:43:15     | 1            | Execute command
 32645    | 2021-09-28 04:40:45                                  | 0                       |          |          |                         |              | Wait for connection
 32646    | 2021-09-28 04:40:45                                  | 0                       |          |          |                         |              | Wait for connection
 32647    | 2021-09-28 04:40:45                                  | 0                       |          |          |                         |              | Wait for connection
 32648    | 2021-09-28 04:40:45 (3:15 before process restarting) | 2                       |          |          |                         |              | Wait for connection
(8 rows)

look at that last row staying booked and busy with (3:15 before process restarting) — she's counting down her own rest, main character energy fr fr 💀

---

✨ that's the whole page bestie, we ate and left no crumbs ✨

this was pgpool-II 4.7.2 Documentation for the SHOW_POOL_PROCESSES(1) page, dated 2023. mwah, go query something 💜🌸✨