summaryrefslogtreecommitdiff
path: root/doc/src
diff options
context:
space:
mode:
authorTatsuo Ishii2025-06-24 10:16:15 +0000
committerTatsuo Ishii2025-06-24 11:57:43 +0000
commit706ca859c64c50a47e6dc2ff31f6be22c6ce5a13 (patch)
tree03e231df84bf7a8617ded16669ae809bde53f784 /doc/src
parent83f12e1505f95b02c89eabec55d2f9a061ccaa6b (diff)
Feature: add pgpool_adm_pcp_proc_info.
This commit adds new pgpool_adm extension function: pcp_proc_info. Also add new fields: client_host, client_port and SQL statement to pcp_proc_info and "show pool_pools". With these additions now it is possible to track the relationship among clients of pgpool, pgpool itself and PostgreSQL. Moreover the commit allows to know what commands (statements) are last executed by using pcp_proc_info. Previously it was not possible unless looking into the pgpool log. lipcp.so version is bumped from 2.0 to 2.1.
Diffstat (limited to 'doc/src')
-rw-r--r--doc/src/sgml/ref/allfiles.sgml1
-rw-r--r--doc/src/sgml/ref/pcp_proc_info.sgml118
-rw-r--r--doc/src/sgml/ref/pgpool_adm_pcp_proc_info.sgml271
-rw-r--r--doc/src/sgml/ref/show_pool_pools.sgml172
-rw-r--r--doc/src/sgml/reference.sgml1
5 files changed, 378 insertions, 185 deletions
diff --git a/doc/src/sgml/ref/allfiles.sgml b/doc/src/sgml/ref/allfiles.sgml
index 89be154bc..7127cb553 100644
--- a/doc/src/sgml/ref/allfiles.sgml
+++ b/doc/src/sgml/ref/allfiles.sgml
@@ -45,3 +45,4 @@ Complete list of usable sgml source files in this directory.
<!ENTITY pgpoolAdmPcpNodeCount SYSTEM "pgpool_adm_pcp_node_count.sgml">
<!ENTITY pgpoolAdmPcpAttachNode SYSTEM "pgpool_adm_pcp_attach_node.sgml">
<!ENTITY pgpoolAdmPcpDetachNode SYSTEM "pgpool_adm_pcp_detach_node.sgml">
+<!ENTITY pgpoolAdmPcpProcInfo SYSTEM "pgpool_adm_pcp_proc_info.sgml">
diff --git a/doc/src/sgml/ref/pcp_proc_info.sgml b/doc/src/sgml/ref/pcp_proc_info.sgml
index df61d551b..9a433da4f 100644
--- a/doc/src/sgml/ref/pcp_proc_info.sgml
+++ b/doc/src/sgml/ref/pcp_proc_info.sgml
@@ -85,14 +85,11 @@ Pgpool-II documentation
<para>
Here is an example output:
<programlisting>
-$ pcp_proc_info -p 1100
-test postgres 2021-09-28 04:16:00 (4:56 before process restarting) 1 3 0 2021-09-28 04:16:16 2021-09-28 04:16:16 0 2021-09-28 04:16:33 1 30795 0 30750 0 Wait for connection
-test postgres 2021-09-28 04:16:00 (4:56 before process restarting) 1 3 0 2021-09-28 04:16:16 2021-09-28 04:16:16 0 2021-09-28 04:16:33 1 30796 0 30750 1 Wait for connection
-test kawamoto 2021-09-28 04:16:00 0 3 0 2021-09-28 04:16:03 2021-09-28 04:16:03 34 (4:26 before client disconnected) 1 30763 1 30751 0 Idle
-test kawamoto 2021-09-28 04:16:00 0 3 0 2021-09-28 04:16:03 2021-09-28 04:16:03 34 (4:26 before client disconnected) 1 30764 1 30751 1 Idle
-$ pcp_proc_info -p 11001 30751
-test kawamoto 2021-09-28 04:16:00 0 3 0 2021-09-28 04:16:03 2021-09-28 04:16:03 58 (4:02 before client disconnected) 1 30763 1 30751 0 Idle
-test kawamoto 2021-09-28 04:16:00 0 3 0 2021-09-28 04:16:03 2021-09-28 04:16:03 58 (4:02 before client disconnected) 1 30764 1 30751 1 Idle
+$ 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
</programlisting>
</para>
<para>
@@ -115,6 +112,9 @@ test kawamoto 2021-09-28 04:16:00 0 3 0 2021-09-28 04:16:03 2021-09-28 04:16:03
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
</literallayout>
</para>
<para>
@@ -129,76 +129,88 @@ test kawamoto 2021-09-28 04:16:00 0 3 0 2021-09-28 04:16:03 2021-09-28 04:16:03
<programlisting>
$ pcp_proc_info -p 11001 --verbose
Database : test
-Username : postgres
-Start time : 2021-09-28 04:16:00 (2:52 before process restarting)
-Client connection count : 1
+Username : t-ishii
+Start time : 2025-06-24 10:53:35
+Client connection count : 0
Major : 3
Minor : 0
-Backend connection time : 2021-09-28 04:16:16
-Client connection time : 2021-09-28 04:16:16
+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 : 2021-09-28 04:16:33
+Client disconnection time :
Pool Counter : 1
-Backend PID : 30795
-Connected : 0
-PID : 30750
+Backend PID : 1336703
+Connected : 1
+PID : 1336537
Backend ID : 0
-Status : Wait for connection
+Status : Idle
Load balance node : 0
+client_host : 192.168.10.11
+client_port : 39216
+statement :
Database : test
-Username : postgres
-Start time : 2021-09-28 04:16:00 (2:52 before process restarting)
-Client connection count : 1
+Username : t-ishii
+Start time : 2025-06-24 10:53:35
+Client connection count : 0
Major : 3
Minor : 0
-Backend connection time : 2021-09-28 04:16:16
-Client connection time : 2021-09-28 04:16:16
+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 : 2021-09-28 04:16:33
+Client disconnection time :
Pool Counter : 1
-Backend PID : 30796
-Connected : 0
-PID : 30750
+Backend PID : 1336704
+Connected : 1
+PID : 1336537
Backend ID : 1
-Status : Wait for connection
-Load balance node : 0
+Status : Idle
+Load balance node : 1
+client_host : 192.168.10.11
+client_port : 39216
+statement : select 1;
Database : test
-Username : kawamoto
-Start time : 2021-09-28 04:16:00
-Client connection count : 0
+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 : 2021-09-28 04:16:03
-Client connection time : 2021-09-28 04:16:03
-Client idle duration : 158 (2:22 before client disconnected)
-Client disconnection time :
+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 : 30763
-Connected : 1
-PID : 30751
+Backend PID : 1336573
+Connected : 0
+PID : 1336544
Backend ID : 0
-Status : Idle
-Load balance node : 1
+Status : Wait for connection
+Load balance node : 0
+client_host : 192.168.10.11
+client_port : 39162
+statement : DISCARD ALL
Database : test
-Username : kawamoto
-Start time : 2021-09-28 04:16:00
-Client connection count : 0
+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 : 2021-09-28 04:16:03
-Client connection time : 2021-09-28 04:16:03
-Client idle duration : 158 (2:22 before client disconnected)
-Client disconnection time :
+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 : 30764
-Connected : 1
-PID : 30751
+Backend PID : 1336574
+Connected : 0
+PID : 1336544
Backend ID : 1
-Status : Idle
-Load balance node : 1
+Status : Wait for connection
+Load balance node : 0
+client_host : 192.168.10.11
+client_port : 39162
+statement :
</programlisting>
</refsect1>
diff --git a/doc/src/sgml/ref/pgpool_adm_pcp_proc_info.sgml b/doc/src/sgml/ref/pgpool_adm_pcp_proc_info.sgml
new file mode 100644
index 000000000..4346e68fd
--- /dev/null
+++ b/doc/src/sgml/ref/pgpool_adm_pcp_proc_info.sgml
@@ -0,0 +1,271 @@
+<!--
+doc/src/sgml/ref/pgpool_adm_pcp_proc_info.sgml
+Pgpool-II documentation
+-->
+
+<refentry id="PGPOOL-ADM-PCP-PROC-INFO">
+ <indexterm zone="pgpool-adm-pcp-proc-info">
+ <primary>pgpool_adm_pcp_proc_info</primary>
+ </indexterm>
+
+ <refmeta>
+ <refentrytitle>pgpool_adm_pcp_proc_info</refentrytitle>
+ <manvolnum>3</manvolnum>
+ <refmiscinfo>pgpool_adm extension</refmiscinfo>
+ </refmeta>
+
+ <refnamediv>
+ <refname>pgpool_adm_pcp_proc_info</refname>
+ <refpurpose>
+ a function to display the information
+ on <productname>Pgpool-II</productname> child process
+ </refpurpose>
+ </refnamediv>
+
+ <refsynopsisdiv>
+ <funcsynopsis>
+ <funcprototype>
+ <funcdef><function>pcp_proc_info</function> returns record</funcdef>
+ <paramdef>text <parameter>host</parameter></paramdef>
+ <paramdef>integer <parameter>port</parameter></paramdef>
+ <paramdef>text <parameter>username</parameter></paramdef>
+ <paramdef>text <parameter>password</parameter></paramdef>
+ <paramdef>out <parameter>database text</parameter></paramdef>
+ <paramdef>out <parameter>username text</parameter></paramdef>
+ <paramdef>out <parameter>start_time text</parameter></paramdef>
+ <paramdef>out <parameter>client_connection_count text</parameter></paramdef>
+ <paramdef>out <parameter>major text</parameter></paramdef>
+ <paramdef>out <parameter>minor text</parameter></paramdef>
+ <paramdef>out <parameter>backend_connection_time text</parameter></paramdef>
+ <paramdef>out <parameter>client_connection_time text</parameter></paramdef>
+ <paramdef>out <parameter>client_idle_duration text</parameter></paramdef>
+ <paramdef>out <parameter>client_disconnection_time text</parameter></paramdef>
+ <paramdef>out <parameter>pool_counter text</parameter></paramdef>
+ <paramdef>out <parameter>backend_pid text</parameter></paramdef>
+ <paramdef>out <parameter>connected text</parameter></paramdef>
+ <paramdef>out <parameter>pid text</parameter></paramdef>
+ <paramdef>out <parameter>backend_id text</parameter></paramdef>
+ <paramdef>out <parameter>status text</parameter></paramdef>
+ <paramdef>out <parameter>load_balance_node text</parameter></paramdef>
+ <paramdef>out <parameter>client_host text</parameter></paramdef>
+ <paramdef>out <parameter>client_port text</parameter></paramdef>
+ <paramdef>out <parameter>statement </parameter></paramdef>
+ </funcprototype>
+
+ <funcprototype>
+ <funcdef><function>pcp_proc_info</function> returns record</funcdef>
+ <paramdef>integer <parameter>node_id</parameter></paramdef>
+ <paramdef>text <parameter>pcp_server</parameter></paramdef>
+ <paramdef>out <parameter>database text</parameter></paramdef>
+ <paramdef>out <parameter>username text</parameter></paramdef>
+ <paramdef>out <parameter>start_time text</parameter></paramdef>
+ <paramdef>out <parameter>client_connection_count text</parameter></paramdef>
+ <paramdef>out <parameter>major text</parameter></paramdef>
+ <paramdef>out <parameter>minor text</parameter></paramdef>
+ <paramdef>out <parameter>backend_connection_time text</parameter></paramdef>
+ <paramdef>out <parameter>client_connection_time text</parameter></paramdef>
+ <paramdef>out <parameter>client_idle_duration text</parameter></paramdef>
+ <paramdef>out <parameter>client_disconnection_time text</parameter></paramdef>
+ <paramdef>out <parameter>pool_counter text</parameter></paramdef>
+ <paramdef>out <parameter>backend_pid text</parameter></paramdef>
+ <paramdef>out <parameter>connected text</parameter></paramdef>
+ <paramdef>out <parameter>pid text</parameter></paramdef>
+ <paramdef>out <parameter>backend_id text</parameter></paramdef>
+ <paramdef>out <parameter>status text</parameter></paramdef>
+ <paramdef>out <parameter>load_balance_node text</parameter></paramdef>
+ <paramdef>out <parameter>client_host text</parameter></paramdef>
+ <paramdef>out <parameter>client_port text</parameter></paramdef>
+ <paramdef>out <parameter>statement </parameter></paramdef>
+ </funcprototype>
+
+ </funcsynopsis>
+ </refsynopsisdiv>
+
+ <refsect1 id="R3-PCP-PROC-INFO-3">
+ <title>Description</title>
+ <para>
+ <function>pcp_proc_info</function>
+ displays the information
+ on <productname>Pgpool-II</productname> child process.
+ All the information is same as <xref linkend="pcp-proc-info">.
+ All the data types are "text".
+ </para>
+ </refsect1>
+
+ <refsect1>
+ <title>Arguments</title>
+ <para>
+ <variablelist>
+
+ <varlistentry>
+ <term><replaceable class="parameter">pcp_server</replaceable></term>
+ <listitem>
+ <para>
+ The foreign server name for pcp server.
+ </para>
+ </listitem>
+ </varlistentry>
+
+ <varlistentry>
+ <term><option>Other arguments </option></term>
+ <listitem>
+ <para>
+ See <xref linkend="pcp-common-options">.
+ </para>
+ </listitem>
+ </varlistentry>
+ </variablelist>
+ </para>
+ </refsect1>
+
+ <refsect1>
+ <title>Example</title>
+ <para>
+ In the example below a search condition "connected" column = '1' is
+ specified, and only the information on the process connected from
+ clients. In this psql session pcp_proc_info is called in the from
+ clause, and the information is shown on row 1 and 2. The select
+ statement is sent to only backend_id = '0' (which is probably the
+ primary), and the "status" column of the row 1 is "Execute
+ command", the "statement" column shows the select statement which
+ was executed. On the other hand the "statement" column of the row 2
+ is empty, since the select statement is was not sent to backend_id
+ = '1'.
+ </para>
+ <para>
+ The information on the other psql session is shown on the row 2 and
+ 3. In this example "select 1" was sent to "backend_id" = '1'
+ (probably standby).
+ <programlisting>
+test=# select * from pcp_proc_info(host => '', port => 11001, username => 't-ishii', password => 't-ishii') where connected = '1';
+-[ RECORD 1 ]-------------+----------------------------------------------------------------------------------------------------------------------------
+database | test
+username | t-ishii
+start_time | 2025-02-22 20:56:08
+client_connection_count | 0
+major | 3
+minor | 0
+backend_connection_time | 2025-02-22 20:58:37
+client_connection_time | 2025-02-22 20:58:37
+client_idle_duration | 0
+client_disconnection_time |
+pool_counter | 1
+backend_pid | 14750
+connected | 1
+pid | 14585
+backend_id | 0
+status | Execute command
+load_balance_node | 1
+client_host | 127.0.0.1
+client_port | 59120
+statement | select * from pcp_proc_info(host => '', port => 11001, username => 't-ishii', password => 't-ishii') where connected = '1';
+-[ RECORD 2 ]-------------+----------------------------------------------------------------------------------------------------------------------------
+database | test
+username | t-ishii
+start_time | 2025-02-22 20:56:08
+client_connection_count | 0
+major | 3
+minor | 0
+backend_connection_time | 2025-02-22 20:58:37
+client_connection_time | 2025-02-22 20:58:37
+client_idle_duration | 0
+client_disconnection_time |
+pool_counter | 1
+backend_pid | 14751
+connected | 1
+pid | 14585
+backend_id | 1
+status | Execute command
+load_balance_node | 0
+client_host | 127.0.0.1
+client_port | 59120
+statement |
+-[ RECORD 3 ]-------------+----------------------------------------------------------------------------------------------------------------------------
+database | test
+username | t-ishii
+start_time | 2025-02-22 20:56:08
+client_connection_count | 0
+major | 3
+minor | 0
+backend_connection_time | 2025-02-22 20:58:56
+client_connection_time | 2025-02-22 20:58:56
+client_idle_duration | 0
+client_disconnection_time |
+pool_counter | 1
+backend_pid | 14767
+connected | 1
+pid | 14601
+backend_id | 0
+status | Idle
+load_balance_node | 0
+client_host | 127.0.0.1
+client_port | 54072
+statement |
+-[ RECORD 4 ]-------------+----------------------------------------------------------------------------------------------------------------------------
+database | test
+username | t-ishii
+start_time | 2025-02-22 20:56:08
+client_connection_count | 0
+major | 3
+minor | 0
+backend_connection_time | 2025-02-22 20:58:56
+client_connection_time | 2025-02-22 20:58:56
+client_idle_duration | 0
+client_disconnection_time |
+pool_counter | 1
+backend_pid | 14768
+connected | 1
+pid | 14601
+backend_id | 1
+status | Idle
+load_balance_node | 1
+client_host | 127.0.0.1
+client_port | 54072
+statement | select 1;
+ </programlisting>
+ </para>
+ <para>
+ In the example below we define a function called
+ "pgpool_query_info" which shows last executed query in each pgpool
+ child process along with associated information: usernae, database,
+ client host, client port, pgpool host, pgpool port, pgpool pid,
+ backend host, backend port, backend pid, backend role and SQL
+ statement, by joining pgpool_adm_pcp_proc_info,
+ pgpool_adm_pcp_node_info and pgpool_adm_pcp_pool_status.
+ <programlisting>
+create function pgpool_query_info(pcp_host text, pcp_port int, pgpool_username text, password text)
+returns table (username text, database text, client_host text, client_port text,
+pgpool_host text, pgpool_port text, pgpool_pid text,
+backend_host text, backend_port text, backend_pid text, backend_role text, statement text) as $$
+select p.username, p.database, p.client_host,p.client_port,
+$1 as pgpool_host, s.value as pgpool_port, p.pid as pgpool_pid,
+b.host as backend_host, b.port as backend_port, p.backend_pid as backend_pid,
+b.role as backend_role,
+p.statement
+from pcp_proc_info(host=> $1, port => $2, username => $3, password => $4) as p,
+pcp_node_info(node_id=>p.backend_id::int, host => $1, port => $2,
+username => $3, password => $4) as b,
+pcp_pool_status(host=> $1, port => $2, username => $3, password => $4) as s
+where p.connected = 1::text and p.statement != '' and
+p.statement !~ 'pcp_proc_info' and p.statement !~ 'pgpool_query_info' and
+s.item = 'port'
+$$
+language SQL;
+CREATE FUNCTION
+
+select * from pgpool_query_info('192.168.10.11', 11001, 't-ishii', 't-ishii');
+ username | database | client_host | client_port | pgpool_host | pgpool_port | pgpool_pid | backend_host | backend_port | backend_pid | backend_role | statement
+----------+----------+---------------+-------------+---------------+-------------+------------+--------------+--------------+-------------+--------------+-----------
+ t-ishii | test | 192.168.10.11 | 60542 | 192.168.10.11 | 11000 | 1356156 | localhost | 11002 | 1356240 | Primary | select 2;
+ t-ishii | test | 192.168.10.11 | 43856 | 192.168.10.11 | 11000 | 1356167 | localhost | 11003 | 1356255 | Standby | select 1;
+(2 rows)
+ </programlisting>
+ </para>
+ <para>
+ See <xref linkend="pcp-proc-info"> for more information on each
+ shown data.
+ </para>
+
+ </refsect1>
+
+</refentry>
diff --git a/doc/src/sgml/ref/show_pool_pools.sgml b/doc/src/sgml/ref/show_pool_pools.sgml
index 07a604e59..6dad9279b 100644
--- a/doc/src/sgml/ref/show_pool_pools.sgml
+++ b/doc/src/sgml/ref/show_pool_pools.sgml
@@ -37,7 +37,7 @@
<productname>Pgpool-II</productname>
</para>
<para>
- It has 17 columns:
+ It has 20 columns:
<itemizedlist>
<listitem>
<para>
@@ -197,6 +197,23 @@
frontend is currently using this backend and the backend is load balance node.
</para>
</listitem>
+ <listitem>
+ <para>
+ <literal>client_host</literal> is client's host name or IP address.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>client_port</literal> is client's port number.
+ </para>
+ </listitem>
+ <listitem>
+ <para>
+ <literal>statement</literal> is the SQL statement last executed.
+ </para>
+ </listitem>
+
</itemizedlist>
</para>
<para>
@@ -204,137 +221,28 @@
number_of_backends lines. Here is an example session:
<programlisting>
test=# show pool_pools;
- pool_pid | start_time | client_connection_count | pool_id | backend_id | database | username | backend_connection_time | client_connection_time | client_disconnection_time | client_idle_duration | majorversion | minorversion | pool_counter | pool_backendpid | pool_connected | status | load_balance_node
-----------+---------------------+-------------------------+---------+------------+----------+----------+-------------------------+------------------------+---------------------------+----------------------+--------------+--------------+--------------+-----------------+----------------+---------------------+-------------------
- 641408 | 2023-07-10 13:20:51 | 0 | 0 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641408 | 2023-07-10 13:20:51 | 0 | 0 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641408 | 2023-07-10 13:20:51 | 0 | 1 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641408 | 2023-07-10 13:20:51 | 0 | 1 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641408 | 2023-07-10 13:20:51 | 0 | 2 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641408 | 2023-07-10 13:20:51 | 0 | 2 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641408 | 2023-07-10 13:20:51 | 0 | 3 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641408 | 2023-07-10 13:20:51 | 0 | 3 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641409 | 2023-07-10 13:20:51 | 0 | 0 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641409 | 2023-07-10 13:20:51 | 0 | 0 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641409 | 2023-07-10 13:20:51 | 0 | 1 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641409 | 2023-07-10 13:20:51 | 0 | 1 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641409 | 2023-07-10 13:20:51 | 0 | 2 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641409 | 2023-07-10 13:20:51 | 0 | 2 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641409 | 2023-07-10 13:20:51 | 0 | 3 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641409 | 2023-07-10 13:20:51 | 0 | 3 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641410 | 2023-07-10 13:20:51 | 0 | 0 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641410 | 2023-07-10 13:20:51 | 0 | 0 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641410 | 2023-07-10 13:20:51 | 0 | 1 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641410 | 2023-07-10 13:20:51 | 0 | 1 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641410 | 2023-07-10 13:20:51 | 0 | 2 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641410 | 2023-07-10 13:20:51 | 0 | 2 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641410 | 2023-07-10 13:20:51 | 0 | 3 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641410 | 2023-07-10 13:20:51 | 0 | 3 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641411 | 2023-07-10 13:20:51 | 0 | 0 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641411 | 2023-07-10 13:20:51 | 0 | 0 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641411 | 2023-07-10 13:20:51 | 0 | 1 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641411 | 2023-07-10 13:20:51 | 0 | 1 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641411 | 2023-07-10 13:20:51 | 0 | 2 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641411 | 2023-07-10 13:20:51 | 0 | 2 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641411 | 2023-07-10 13:20:51 | 0 | 3 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641411 | 2023-07-10 13:20:51 | 0 | 3 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641412 | 2023-07-10 13:20:51 | 0 | 0 | 0 | test | t-ishii | 2023-07-10 13:20:56 | 2023-07-10 13:20:56 | | 0 | 3 | 0 | 1 | 641448 | 1 | Idle | 1
- 641412 | 2023-07-10 13:20:51 | 0 | 0 | 1 | test | t-ishii | 2023-07-10 13:20:56 | 2023-07-10 13:20:56 | | 0 | 3 | 0 | 1 | 641449 | 1 | Idle | 0
- 641412 | 2023-07-10 13:20:51 | 0 | 1 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Idle | 0
- 641412 | 2023-07-10 13:20:51 | 0 | 1 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Idle | 0
- 641412 | 2023-07-10 13:20:51 | 0 | 2 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Idle | 0
- 641412 | 2023-07-10 13:20:51 | 0 | 2 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Idle | 0
- 641412 | 2023-07-10 13:20:51 | 0 | 3 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Idle | 0
- 641412 | 2023-07-10 13:20:51 | 0 | 3 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Idle | 0
- 641413 | 2023-07-10 13:20:51 | 0 | 0 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641413 | 2023-07-10 13:20:51 | 0 | 0 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641413 | 2023-07-10 13:20:51 | 0 | 1 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641413 | 2023-07-10 13:20:51 | 0 | 1 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641413 | 2023-07-10 13:20:51 | 0 | 2 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641413 | 2023-07-10 13:20:51 | 0 | 2 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641413 | 2023-07-10 13:20:51 | 0 | 3 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641413 | 2023-07-10 13:20:51 | 0 | 3 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641414 | 2023-07-10 13:20:51 | 0 | 0 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641414 | 2023-07-10 13:20:51 | 0 | 0 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641414 | 2023-07-10 13:20:51 | 0 | 1 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641414 | 2023-07-10 13:20:51 | 0 | 1 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641414 | 2023-07-10 13:20:51 | 0 | 2 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641414 | 2023-07-10 13:20:51 | 0 | 2 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641414 | 2023-07-10 13:20:51 | 0 | 3 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641414 | 2023-07-10 13:20:51 | 0 | 3 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641415 | 2023-07-10 13:20:51 | 0 | 0 | 0 | test | t-ishii | 2023-07-10 13:21:04 | 2023-07-10 13:21:04 | | 0 | 3 | 0 | 1 | 641455 | 1 | Execute command | 0
- 641415 | 2023-07-10 13:20:51 | 0 | 0 | 1 | test | t-ishii | 2023-07-10 13:21:04 | 2023-07-10 13:21:04 | | 0 | 3 | 0 | 1 | 641456 | 1 | Execute command | 1
- 641415 | 2023-07-10 13:20:51 | 0 | 1 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Execute command | 0
- 641415 | 2023-07-10 13:20:51 | 0 | 1 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Execute command | 0
- 641415 | 2023-07-10 13:20:51 | 0 | 2 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Execute command | 0
- 641415 | 2023-07-10 13:20:51 | 0 | 2 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Execute command | 0
- 641415 | 2023-07-10 13:20:51 | 0 | 3 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Execute command | 0
- 641415 | 2023-07-10 13:20:51 | 0 | 3 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Execute command | 0
- 641416 | 2023-07-10 13:20:51 | 0 | 0 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641416 | 2023-07-10 13:20:51 | 0 | 0 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641416 | 2023-07-10 13:20:51 | 0 | 1 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641416 | 2023-07-10 13:20:51 | 0 | 1 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641416 | 2023-07-10 13:20:51 | 0 | 2 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641416 | 2023-07-10 13:20:51 | 0 | 2 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641416 | 2023-07-10 13:20:51 | 0 | 3 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641416 | 2023-07-10 13:20:51 | 0 | 3 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641417 | 2023-07-10 13:20:51 | 0 | 0 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641417 | 2023-07-10 13:20:51 | 0 | 0 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641417 | 2023-07-10 13:20:51 | 0 | 1 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641417 | 2023-07-10 13:20:51 | 0 | 1 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641417 | 2023-07-10 13:20:51 | 0 | 2 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641417 | 2023-07-10 13:20:51 | 0 | 2 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641417 | 2023-07-10 13:20:51 | 0 | 3 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641417 | 2023-07-10 13:20:51 | 0 | 3 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641418 | 2023-07-10 13:20:51 | 0 | 0 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641418 | 2023-07-10 13:20:51 | 0 | 0 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641418 | 2023-07-10 13:20:51 | 0 | 1 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641418 | 2023-07-10 13:20:51 | 0 | 1 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641418 | 2023-07-10 13:20:51 | 0 | 2 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641418 | 2023-07-10 13:20:51 | 0 | 2 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641418 | 2023-07-10 13:20:51 | 0 | 3 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641418 | 2023-07-10 13:20:51 | 0 | 3 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641419 | 2023-07-10 13:20:51 | 0 | 0 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641419 | 2023-07-10 13:20:51 | 0 | 0 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641419 | 2023-07-10 13:20:51 | 0 | 1 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641419 | 2023-07-10 13:20:51 | 0 | 1 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641419 | 2023-07-10 13:20:51 | 0 | 2 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641419 | 2023-07-10 13:20:51 | 0 | 2 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641419 | 2023-07-10 13:20:51 | 0 | 3 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641419 | 2023-07-10 13:20:51 | 0 | 3 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641420 | 2023-07-10 13:20:51 | 0 | 0 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641420 | 2023-07-10 13:20:51 | 0 | 0 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641420 | 2023-07-10 13:20:51 | 0 | 1 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641420 | 2023-07-10 13:20:51 | 0 | 1 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641420 | 2023-07-10 13:20:51 | 0 | 2 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641420 | 2023-07-10 13:20:51 | 0 | 2 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641420 | 2023-07-10 13:20:51 | 0 | 3 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641420 | 2023-07-10 13:20:51 | 0 | 3 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641421 | 2023-07-10 13:20:51 | 0 | 0 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641421 | 2023-07-10 13:20:51 | 0 | 0 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641421 | 2023-07-10 13:20:51 | 0 | 1 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641421 | 2023-07-10 13:20:51 | 0 | 1 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641421 | 2023-07-10 13:20:51 | 0 | 2 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641421 | 2023-07-10 13:20:51 | 0 | 2 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641421 | 2023-07-10 13:20:51 | 0 | 3 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641421 | 2023-07-10 13:20:51 | 0 | 3 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641422 | 2023-07-10 13:20:51 | 0 | 0 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641422 | 2023-07-10 13:20:51 | 0 | 0 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641422 | 2023-07-10 13:20:51 | 0 | 1 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641422 | 2023-07-10 13:20:51 | 0 | 1 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641422 | 2023-07-10 13:20:51 | 0 | 2 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641422 | 2023-07-10 13:20:51 | 0 | 2 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641422 | 2023-07-10 13:20:51 | 0 | 3 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641422 | 2023-07-10 13:20:51 | 0 | 3 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641423 | 2023-07-10 13:20:51 | 0 | 0 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641423 | 2023-07-10 13:20:51 | 0 | 0 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641423 | 2023-07-10 13:20:51 | 0 | 1 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641423 | 2023-07-10 13:20:51 | 0 | 1 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641423 | 2023-07-10 13:20:51 | 0 | 2 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641423 | 2023-07-10 13:20:51 | 0 | 2 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641423 | 2023-07-10 13:20:51 | 0 | 3 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
- 641423 | 2023-07-10 13:20:51 | 0 | 3 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0
-(128 rows)
+ pool_pid | start_time | client_connection_count | pool_id | backend_id | database | username | backend_connection_time | client_connection_time | client_disconnection_time | client_idle_duration | majorversion | minorversion | pool_counter | pool_backendpid | pool_connected | status | load_balance_node | client_host | client_port | statement
+----------+------------------------------------------------------+-------------------------+---------+------------+----------+----------+-------------------------+------------------------+---------------------------+----------------------+--------------+--------------+--------------+-----------------+----------------+---------------------+-------------------+---------------+-------------+-------------
+[snip]
+ 1336537 | 2025-06-24 10:53:35 | 0 | 0 | 0 | test | t-ishii | 2025-06-24 10:55:58 | 2025-06-24 10:55:59 | | 0 | 3 | 0 | 1 | 1336703 | 1 | Idle | 0 | 192.168.10.11 | 39216 |
+ 1336537 | 2025-06-24 10:53:35 | 0 | 0 | 1 | test | t-ishii | 2025-06-24 10:55:58 | 2025-06-24 10:55:59 | | 0 | 3 | 0 | 1 | 1336704 | 1 | Idle | 1 | 192.168.10.11 | 39216 | select 1;
+ 1336537 | 2025-06-24 10:53:35 | 0 | 1 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Idle | 0 | 192.168.10.11 | 39216 |
+ 1336537 | 2025-06-24 10:53:35 | 0 | 1 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Idle | 0 | 192.168.10.11 | 39216 | select 1;
+ 1336537 | 2025-06-24 10:53:35 | 0 | 2 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Idle | 0 | 192.168.10.11 | 39216 |
+ 1336537 | 2025-06-24 10:53:35 | 0 | 2 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Idle | 0 | 192.168.10.11 | 39216 | select 1;
+ 1336537 | 2025-06-24 10:53:35 | 0 | 3 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Idle | 0 | 192.168.10.11 | 39216 |
+ 1336537 | 2025-06-24 10:53:35 | 0 | 3 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Idle | 0 | 192.168.10.11 | 39216 | select 1;
+[snip]
+ 1336544 | 2025-06-24 10:53:35 (0:23 before process restarting) | 1 | 0 | 0 | test | t-ishii | 2025-06-24 10:53:42 | 2025-06-24 10:53:42 | 2025-06-24 10:55:37 | 0 | 3 | 0 | 1 | 1336573 | 0 | Wait for connection | 0 | 192.168.10.11 | 39162 | DISCARD ALL
+ 1336544 | 2025-06-24 10:53:35 (0:23 before process restarting) | 1 | 0 | 1 | test | t-ishii | 2025-06-24 10:53:42 | 2025-06-24 10:53:42 | 2025-06-24 10:55:37 | 0 | 3 | 0 | 1 | 1336574 | 0 | Wait for connection | 0 | 192.168.10.11 | 39162 |
+ 1336544 | 2025-06-24 10:53:35 (0:23 before process restarting) | 1 | 1 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0 | 192.168.10.11 | 39162 | DISCARD ALL
+ 1336544 | 2025-06-24 10:53:35 (0:23 before process restarting) | 1 | 1 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0 | 192.168.10.11 | 39162 |
+ 1336544 | 2025-06-24 10:53:35 (0:23 before process restarting) | 1 | 2 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0 | 192.168.10.11 | 39162 | DISCARD ALL
+ 1336544 | 2025-06-24 10:53:35 (0:23 before process restarting) | 1 | 2 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0 | 192.168.10.11 | 39162 |
+ 1336544 | 2025-06-24 10:53:35 (0:23 before process restarting) | 1 | 3 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0 | 192.168.10.11 | 39162 | DISCARD ALL
+ 1336544 | 2025-06-24 10:53:35 (0:23 before process restarting) | 1 | 3 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection | 0 | 192.168.10.11 | 39162 |
+[snip]
+(256 rows)
</programlisting>
</para>
diff --git a/doc/src/sgml/reference.sgml b/doc/src/sgml/reference.sgml
index 2b2db4947..6d2ea97ce 100644
--- a/doc/src/sgml/reference.sgml
+++ b/doc/src/sgml/reference.sgml
@@ -254,6 +254,7 @@
&pgpoolAdmPcpNodeCount
&pgpoolAdmPcpAttachNode
&pgpoolAdmPcpDetachNode
+ &pgpoolAdmPcpProcInfo
</reference>
generated by cgit v1.2.3 (git 2.39.1) at 2025-12-24 22:50:00 +0000