diff --git a/doc.ja/src/sgml/ref/pcp_proc_info.sgml b/doc.ja/src/sgml/ref/pcp_proc_info.sgml index 9d4ff93..ad95193 100644 --- a/doc.ja/src/sgml/ref/pcp_proc_info.sgml +++ b/doc.ja/src/sgml/ref/pcp_proc_info.sgml @@ -118,9 +118,9 @@ Pgpool-II documentation --> 例を示します。 - $ pcp_proc_info -p 11001 1406 - test t-ishii 2018-07-09 16:43:53 2018-07-09 16:44:08 3 0 1 1435 1 1406 0 - test t-ishii 2018-07-09 16:43:53 2018-07-09 16:44:08 3 0 1 1436 1 1406 1 +$ pcp_proc_info -p 11001 2871 +postgres postgres 2021-09-07 02:12:53 (remaining: 0:27) 1 3 0 2021-09-07 02:16:59 2021-09-07 02:16:59 273 2021-09-07 02:16:56 1 3016 1 2871 0 Idle +postgres postgres 2021-09-07 02:12:53 (remaining: 0:27) 1 3 0 2021-09-07 02:16:59 2021-09-07 02:16:59 0 2021-09-07 02:16:56 1 3017 1 2871 1 Idle @@ -132,27 +132,37 @@ Pgpool-II documentation 1. 接続先のデータベース名 2. 接続先のユーザ名 - 3. Pgpool-IIプロセスの起動時刻 - 4. バックエンドへの接続時刻 + 3. Pgpool-IIプロセスの起動時刻 (による残り時間。client_idle_limitが0の場合、remainingは表示されません) + 4. プロセスの利用カウンタ(を参照) 5. プロトコルのメジャーバージョン 6. プロトコルのマイナーバージョン - 7. 接続の再利用カウンタ値 - 8. PostgreSQLバックエンドプロセスのプロセスID - 9. フロントエンドが接続中なら1、そうでなければ0 - 10. pgpool子プロセスID - 11. PostgreSQLバックエンドID + 7. バックエンドへの接続時刻 + 8. クライアントが最後に接続開始した時刻 + 9. 接続がidleとなっている時間(秒)(を参照) + 10. クライアントが最後に接続終了した時刻 + 11. 接続の再利用カウンタ値 + 12. PostgreSQLバックエンドプロセスのプロセスID + 13. フロントエンドが接続中なら1、そうでなければ0 + 14. pgpool子プロセスID + 15. PostgreSQLバックエンドID + 16. プロセスの状態 @@ -171,29 +181,40 @@ Pgpool-II documentation オプションは出力内容を理解するのに役に立ちます。例： - $ pcp_proc_info -p 11001 --verbose 1406 - Database : test - Username : t-ishii - Start time : 2018-07-09 16:43:53 - Creation time: 2018-07-09 16:44:08 - Major : 3 - Minor : 0 - Counter : 1 - Backend PID : 1435 - Connected : 1 - PID : 1406 - Backend ID : 0 - Database : test - Username : t-ishii - Start time : 2018-07-09 16:43:53 - Creation time: 2018-07-09 16:44:08 - Major : 3 - Minor : 0 - Counter : 1 - Backend PID : 1436 - Connected : 1 - PID : 1406 - Backend ID : 1 +$ pcp_proc_info -p 11001 --verbose 2871 +Database : postgres +Username : postgres +Start time : 2021-09-07 02:12:53 (remaining: 3:36) +Client connection count : 1 +Major : 3 +Minor : 0 +Backend connection time : 2021-09-07 02:16:59 +Client connection time : 2021-09-07 02:16:59 +Client idle duration : 84 +Client disconnection time : 2021-09-07 02:16:56 +Pool Counter : 1 +Backend PID : 3016 +Connected : 1 +PID : 2871 +Backend ID : 0 +Status : Idle + +Database : postgres +Username : postgres +Start time : 2021-09-07 02:12:53 (remaining: 3:36) +Client connection count : 1 +Major : 3 +Minor : 0 +Backend connection time : 2021-09-07 02:16:59 +Client connection time : 2021-09-07 02:16:59 +Client idle duration : 0 +Client disconnection time : 2021-09-07 02:16:56 +Pool Counter : 1 +Backend PID : 3017 +Connected : 1 +PID : 2871 +Backend ID : 1 +Status : Idle diff --git a/doc.ja/src/sgml/ref/show_pool_pools.sgml b/doc.ja/src/sgml/ref/show_pool_pools.sgml index 226f6cf..2d158cf 100644 --- a/doc.ja/src/sgml/ref/show_pool_pools.sgml +++ b/doc.ja/src/sgml/ref/show_pool_pools.sgml @@ -46,9 +46,9 @@ - 12のカラムがあります。 + 17のカラムがあります。 @@ -66,7 +66,32 @@ start_time is the timestamp of when this process was launched. --> - start_time はこのプロセスが起動された時刻です (1970年1月1日からの経過秒で表示されます)。 + start_time はこのプロセスが起動された時刻です。 + + + + + remaining はに + よる残り時間です。client_idle_limit が 0 の場合、 + remaining は表示されません。 + + + + + + + + + + client_connection_count はこのプロセスが使用された回数です。 @@ -114,10 +139,40 @@ - create_time はこの接続が作成された時刻です。 + backend_connection_time はこの接続が作成された時刻です。 + + + + + + + client_connection_time は最後にクライアントが接続した時刻です。 + + + + + + + client_disconnection_time は最後にクライアントが切断した時刻です。 + + + + + + + client_idle_duration はクライアントからのコマンドを待機している時間(秒)です。 @@ -165,6 +220,50 @@ + + + + status は現在のプロセスの状態です。以下のいずれかの値を取ります: + + + + + Execute command: コマンドを実行中です。 + + + + + + Idle: クライアントからのコマンドを待機しています。 + + + + + + Idle in transaction: トランザクション中にクライアントからのコマンドを待機しています。 + + + + + + Wait for connection: クライアントからの接続を待機しています。 + + + + + + @@ -175,266 +274,74 @@ 返却行数は常に * * 「バックエンドの数」になります。ここでは例を示します。 - test=# show pool_pools; - pool_pid | start_time | pool_id | backend_id | database | username | create_time | majorversion | minorversion | pool_counter | pool_backendpid | pool_connected - ----------+---------------------+---------+------------+----------+----------+---------------------+--------------+--------------+--------------+-----------------+---------------- - 19696 | 2016-10-17 13:24:17 | 0 | 0 | postgres | t-ishii | 2016-10-17 13:35:12 | 3 | 0 | 1 | 20079 | 1 - 19696 | 2016-10-17 13:24:17 | 0 | 1 | postgres | t-ishii | 2016-10-17 13:35:12 | 3 | 0 | 1 | 20080 | 1 - 19696 | 2016-10-17 13:24:17 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19696 | 2016-10-17 13:24:17 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19696 | 2016-10-17 13:24:17 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19696 | 2016-10-17 13:24:17 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19696 | 2016-10-17 13:24:17 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19696 | 2016-10-17 13:24:17 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19697 | 2016-10-17 13:24:17 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19697 | 2016-10-17 13:24:17 | 0 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19697 | 2016-10-17 13:24:17 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19697 | 2016-10-17 13:24:17 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19697 | 2016-10-17 13:24:17 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19697 | 2016-10-17 13:24:17 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19697 | 2016-10-17 13:24:17 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19697 | 2016-10-17 13:24:17 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19698 | 2016-10-17 13:24:17 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19698 | 2016-10-17 13:24:17 | 0 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19698 | 2016-10-17 13:24:17 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19698 | 2016-10-17 13:24:17 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19698 | 2016-10-17 13:24:17 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19698 | 2016-10-17 13:24:17 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19698 | 2016-10-17 13:24:17 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19698 | 2016-10-17 13:24:17 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19699 | 2016-10-17 13:24:17 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19699 | 2016-10-17 13:24:17 | 0 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19699 | 2016-10-17 13:24:17 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19699 | 2016-10-17 13:24:17 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19699 | 2016-10-17 13:24:17 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19699 | 2016-10-17 13:24:17 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19699 | 2016-10-17 13:24:17 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19699 | 2016-10-17 13:24:17 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19700 | 2016-10-17 13:24:17 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19700 | 2016-10-17 13:24:17 | 0 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19700 | 2016-10-17 13:24:17 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19700 | 2016-10-17 13:24:17 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19700 | 2016-10-17 13:24:17 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19700 | 2016-10-17 13:24:17 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19700 | 2016-10-17 13:24:17 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19700 | 2016-10-17 13:24:17 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19701 | 2016-10-17 13:24:17 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19701 | 2016-10-17 13:24:17 | 0 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19701 | 2016-10-17 13:24:17 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19701 | 2016-10-17 13:24:17 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19701 | 2016-10-17 13:24:17 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19701 | 2016-10-17 13:24:17 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19701 | 2016-10-17 13:24:17 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19701 | 2016-10-17 13:24:17 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19702 | 2016-10-17 13:24:17 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19702 | 2016-10-17 13:24:17 | 0 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19702 | 2016-10-17 13:24:17 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19702 | 2016-10-17 13:24:17 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19702 | 2016-10-17 13:24:17 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19702 | 2016-10-17 13:24:17 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19702 | 2016-10-17 13:24:17 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19702 | 2016-10-17 13:24:17 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19703 | 2016-10-17 13:24:17 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19703 | 2016-10-17 13:24:17 | 0 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19703 | 2016-10-17 13:24:17 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19703 | 2016-10-17 13:24:17 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19703 | 2016-10-17 13:24:17 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19703 | 2016-10-17 13:24:17 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19703 | 2016-10-17 13:24:17 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19703 | 2016-10-17 13:24:17 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19704 | 2016-10-17 13:24:17 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19704 | 2016-10-17 13:24:17 | 0 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19704 | 2016-10-17 13:24:17 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19704 | 2016-10-17 13:24:17 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19704 | 2016-10-17 13:24:17 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19704 | 2016-10-17 13:24:17 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19704 | 2016-10-17 13:24:17 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19704 | 2016-10-17 13:24:17 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19705 | 2016-10-17 13:24:17 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19705 | 2016-10-17 13:24:17 | 0 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19705 | 2016-10-17 13:24:17 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19705 | 2016-10-17 13:24:17 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19705 | 2016-10-17 13:24:17 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19705 | 2016-10-17 13:24:17 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19705 | 2016-10-17 13:24:17 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19705 | 2016-10-17 13:24:17 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19706 | 2016-10-17 13:24:17 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19706 | 2016-10-17 13:24:17 | 0 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19706 | 2016-10-17 13:24:17 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19706 | 2016-10-17 13:24:17 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19706 | 2016-10-17 13:24:17 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19706 | 2016-10-17 13:24:17 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19706 | 2016-10-17 13:24:17 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19706 | 2016-10-17 13:24:17 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19707 | 2016-10-17 13:24:17 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19707 | 2016-10-17 13:24:17 | 0 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19707 | 2016-10-17 13:24:17 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19707 | 2016-10-17 13:24:17 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19707 | 2016-10-17 13:24:17 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19707 | 2016-10-17 13:24:17 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19707 | 2016-10-17 13:24:17 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19707 | 2016-10-17 13:24:17 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19708 | 2016-10-17 13:24:17 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19708 | 2016-10-17 13:24:17 | 0 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19708 | 2016-10-17 13:24:17 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19708 | 2016-10-17 13:24:17 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19708 | 2016-10-17 13:24:17 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19708 | 2016-10-17 13:24:17 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19708 | 2016-10-17 13:24:17 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19708 | 2016-10-17 13:24:17 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19709 | 2016-10-17 13:24:17 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19709 | 2016-10-17 13:24:17 | 0 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19709 | 2016-10-17 13:24:17 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19709 | 2016-10-17 13:24:17 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19709 | 2016-10-17 13:24:17 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19709 | 2016-10-17 13:24:17 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19709 | 2016-10-17 13:24:17 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19709 | 2016-10-17 13:24:17 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19710 | 2016-10-17 13:24:17 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19710 | 2016-10-17 13:24:17 | 0 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19710 | 2016-10-17 13:24:17 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19710 | 2016-10-17 13:24:17 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19710 | 2016-10-17 13:24:17 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19710 | 2016-10-17 13:24:17 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19710 | 2016-10-17 13:24:17 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19710 | 2016-10-17 13:24:17 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19711 | 2016-10-17 13:24:17 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19711 | 2016-10-17 13:24:17 | 0 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19711 | 2016-10-17 13:24:17 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19711 | 2016-10-17 13:24:17 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19711 | 2016-10-17 13:24:17 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19711 | 2016-10-17 13:24:17 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19711 | 2016-10-17 13:24:17 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19711 | 2016-10-17 13:24:17 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19712 | 2016-10-17 13:24:17 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19712 | 2016-10-17 13:24:17 | 0 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19712 | 2016-10-17 13:24:17 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19712 | 2016-10-17 13:24:17 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19712 | 2016-10-17 13:24:17 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19712 | 2016-10-17 13:24:17 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19712 | 2016-10-17 13:24:17 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19712 | 2016-10-17 13:24:17 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19713 | 2016-10-17 13:24:17 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19713 | 2016-10-17 13:24:17 | 0 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19713 | 2016-10-17 13:24:17 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19713 | 2016-10-17 13:24:17 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19713 | 2016-10-17 13:24:17 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19713 | 2016-10-17 13:24:17 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19713 | 2016-10-17 13:24:17 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19713 | 2016-10-17 13:24:17 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19714 | 2016-10-17 13:24:17 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19714 | 2016-10-17 13:24:17 | 0 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19714 | 2016-10-17 13:24:17 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19714 | 2016-10-17 13:24:17 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19714 | 2016-10-17 13:24:17 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19714 | 2016-10-17 13:24:17 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19714 | 2016-10-17 13:24:17 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19714 | 2016-10-17 13:24:17 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19715 | 2016-10-17 13:24:17 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19715 | 2016-10-17 13:24:17 | 0 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19715 | 2016-10-17 13:24:17 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19715 | 2016-10-17 13:24:17 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19715 | 2016-10-17 13:24:17 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19715 | 2016-10-17 13:24:17 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19715 | 2016-10-17 13:24:17 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19715 | 2016-10-17 13:24:17 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19716 | 2016-10-17 13:24:17 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19716 | 2016-10-17 13:24:17 | 0 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19716 | 2016-10-17 13:24:17 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19716 | 2016-10-17 13:24:17 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19716 | 2016-10-17 13:24:17 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19716 | 2016-10-17 13:24:17 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19716 | 2016-10-17 13:24:17 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19716 | 2016-10-17 13:24:17 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19717 | 2016-10-17 13:24:17 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19717 | 2016-10-17 13:24:17 | 0 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19717 | 2016-10-17 13:24:17 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19717 | 2016-10-17 13:24:17 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19717 | 2016-10-17 13:24:17 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19717 | 2016-10-17 13:24:17 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19717 | 2016-10-17 13:24:17 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19717 | 2016-10-17 13:24:17 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19718 | 2016-10-17 13:24:17 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19718 | 2016-10-17 13:24:17 | 0 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19718 | 2016-10-17 13:24:17 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19718 | 2016-10-17 13:24:17 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19718 | 2016-10-17 13:24:17 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19718 | 2016-10-17 13:24:17 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19718 | 2016-10-17 13:24:17 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19718 | 2016-10-17 13:24:17 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19719 | 2016-10-17 13:24:17 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19719 | 2016-10-17 13:24:17 | 0 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19719 | 2016-10-17 13:24:17 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19719 | 2016-10-17 13:24:17 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19719 | 2016-10-17 13:24:17 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19719 | 2016-10-17 13:24:17 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19719 | 2016-10-17 13:24:17 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19719 | 2016-10-17 13:24:17 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19720 | 2016-10-17 13:24:17 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19720 | 2016-10-17 13:24:17 | 0 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19720 | 2016-10-17 13:24:17 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19720 | 2016-10-17 13:24:17 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19720 | 2016-10-17 13:24:17 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19720 | 2016-10-17 13:24:17 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19720 | 2016-10-17 13:24:17 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19720 | 2016-10-17 13:24:17 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 20024 | 2016-10-17 13:33:46 | 0 | 0 | test | t-ishii | 2016-10-17 14:30:53 | 3 | 0 | 1 | 22055 | 1 - 20024 | 2016-10-17 13:33:46 | 0 | 1 | test | t-ishii | 2016-10-17 14:30:53 | 3 | 0 | 1 | 22056 | 1 - 20024 | 2016-10-17 13:33:46 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 20024 | 2016-10-17 13:33:46 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 20024 | 2016-10-17 13:33:46 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 20024 | 2016-10-17 13:33:46 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 20024 | 2016-10-17 13:33:46 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 20024 | 2016-10-17 13:33:46 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 20600 | 2016-10-17 13:46:58 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 20600 | 2016-10-17 13:46:58 | 0 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 20600 | 2016-10-17 13:46:58 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 20600 | 2016-10-17 13:46:58 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 20600 | 2016-10-17 13:46:58 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 20600 | 2016-10-17 13:46:58 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 20600 | 2016-10-17 13:46:58 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 20600 | 2016-10-17 13:46:58 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19723 | 2016-10-17 13:24:17 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19723 | 2016-10-17 13:24:17 | 0 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19723 | 2016-10-17 13:24:17 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19723 | 2016-10-17 13:24:17 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19723 | 2016-10-17 13:24:17 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19723 | 2016-10-17 13:24:17 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19723 | 2016-10-17 13:24:17 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19723 | 2016-10-17 13:24:17 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19724 | 2016-10-17 13:24:17 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19724 | 2016-10-17 13:24:17 | 0 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19724 | 2016-10-17 13:24:17 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19724 | 2016-10-17 13:24:17 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19724 | 2016-10-17 13:24:17 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19724 | 2016-10-17 13:24:17 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19724 | 2016-10-17 13:24:17 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19724 | 2016-10-17 13:24:17 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19725 | 2016-10-17 13:24:17 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19725 | 2016-10-17 13:24:17 | 0 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19725 | 2016-10-17 13:24:17 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19725 | 2016-10-17 13:24:17 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19725 | 2016-10-17 13:24:17 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19725 | 2016-10-17 13:24:17 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19725 | 2016-10-17 13:24:17 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19725 | 2016-10-17 13:24:17 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19726 | 2016-10-17 13:24:17 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19726 | 2016-10-17 13:24:17 | 0 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19726 | 2016-10-17 13:24:17 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19726 | 2016-10-17 13:24:17 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19726 | 2016-10-17 13:24:17 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19726 | 2016-10-17 13:24:17 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19726 | 2016-10-17 13:24:17 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19726 | 2016-10-17 13:24:17 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19727 | 2016-10-17 13:24:17 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19727 | 2016-10-17 13:24:17 | 0 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19727 | 2016-10-17 13:24:17 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19727 | 2016-10-17 13:24:17 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19727 | 2016-10-17 13:24:17 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19727 | 2016-10-17 13:24:17 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19727 | 2016-10-17 13:24:17 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19727 | 2016-10-17 13:24:17 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - (256 rows) +postgres=# 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 +----------+---------------------------------------+-------------------------+---------+------------+----------+----------+-------------------------+------------------------+---------------------------+----------------------+--------------+--------------+--------------+-----------------+----------------+--------------------- + 3727 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 0 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3727 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 0 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3727 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 1 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3727 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 1 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3727 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 2 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3727 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 2 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3727 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 3 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3727 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 3 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3728 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 0 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3728 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 0 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3728 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 1 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3728 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 1 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3728 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 2 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3728 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 2 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3728 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 3 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3728 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 3 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3729 | 2021-09-07 02:29:38 (remaining: 3:30) | 1 | 0 | 0 | postgres | postgres | 2021-09-07 02:29:47 | 2021-09-07 02:29:47 | 2021-09-07 02:29:46 | 90 | 3 | 0 | 1 | 3749 | 1 | Idle + 3729 | 2021-09-07 02:29:38 (remaining: 3:30) | 1 | 0 | 1 | postgres | postgres | 2021-09-07 02:29:47 | 2021-09-07 02:29:47 | 2021-09-07 02:29:46 | 0 | 3 | 0 | 1 | 3750 | 1 | Idle + 3729 | 2021-09-07 02:29:38 (remaining: 3:30) | 1 | 1 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Idle + 3729 | 2021-09-07 02:29:38 (remaining: 3:30) | 1 | 1 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Idle + 3729 | 2021-09-07 02:29:38 (remaining: 3:30) | 1 | 2 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Idle + 3729 | 2021-09-07 02:29:38 (remaining: 3:30) | 1 | 2 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Idle + 3729 | 2021-09-07 02:29:38 (remaining: 3:30) | 1 | 3 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Idle + 3729 | 2021-09-07 02:29:38 (remaining: 3:30) | 1 | 3 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Idle + 3730 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 0 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3730 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 0 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3730 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 1 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3730 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 1 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3730 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 2 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3730 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 2 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3730 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 3 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3730 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 3 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3731 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 0 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3731 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 0 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3731 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 1 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3731 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 1 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3731 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 2 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3731 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 2 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3731 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 3 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3731 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 3 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3732 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 0 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3732 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 0 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3732 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 1 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3732 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 1 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3732 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 2 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3732 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 2 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3732 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 3 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3732 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 3 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3733 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 0 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3733 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 0 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3733 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 1 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3733 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 1 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3733 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 2 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3733 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 2 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3733 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 3 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3733 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 3 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3734 | 2021-09-07 02:29:38 (remaining: 5:00) | 4 | 0 | 0 | postgres | postgres | 2021-09-07 02:31:22 | 2021-09-07 02:31:22 | 2021-09-07 02:31:15 | 0 | 3 | 0 | 1 | 3823 | 1 | Execute command + 3734 | 2021-09-07 02:29:38 (remaining: 5:00) | 4 | 0 | 1 | postgres | postgres | 2021-09-07 02:31:22 | 2021-09-07 02:31:22 | 2021-09-07 02:31:15 | 0 | 3 | 0 | 1 | 3824 | 1 | Execute command + 3734 | 2021-09-07 02:29:38 (remaining: 5:00) | 4 | 1 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Execute command + 3734 | 2021-09-07 02:29:38 (remaining: 5:00) | 4 | 1 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Execute command + 3734 | 2021-09-07 02:29:38 (remaining: 5:00) | 4 | 2 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Execute command + 3734 | 2021-09-07 02:29:38 (remaining: 5:00) | 4 | 2 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Execute command + 3734 | 2021-09-07 02:29:38 (remaining: 5:00) | 4 | 3 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Execute command + 3734 | 2021-09-07 02:29:38 (remaining: 5:00) | 4 | 3 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Execute command +(64 rows) diff --git a/doc.ja/src/sgml/ref/show_pool_processes.sgml b/doc.ja/src/sgml/ref/show_pool_processes.sgml index 05c4951..6352e7a 100644 --- a/doc.ja/src/sgml/ref/show_pool_processes.sgml +++ b/doc.ja/src/sgml/ref/show_pool_processes.sgml @@ -48,9 +48,9 @@ - 6つのカラムがあります。 + 8つのカラムがあります。 @@ -68,6 +68,30 @@ this process was launched. --> start_time はこのプロセスが起動された時刻です。 + + + + + remaining はに + よる残り時間です。client_idle_limit が 0 の場合、 + remaining は表示されません。 + + + + + + + + + client_connection_count はこのプロセスが使用された回数です。 @@ -92,10 +116,10 @@ - create_time はこの接続が作成された時刻です。 + backend_connection_time はこの接続が作成された時刻です。 @@ -108,6 +132,49 @@ pool_counter はこの接続が使用された回数です。 + + + + status は現在のプロセスの状態です。以下のいずれかの値を取ります: + + + + + Execute command: コマンドを実行中です。 + + + + + + Idle: クライアントからのコマンドを待機しています。 + + + + + + Idle in transaction: トランザクション中にクライアントからのコマンドを待機しています。 + + + + + + Wait for connection: クライアントからの接続を待機しています。 + + + + + @@ -117,42 +184,18 @@ ここでは例を示します。 - test=# show pool_processes; - pool_pid | start_time | database | username | create_time | pool_counter - ----------+---------------------+----------+----------+---------------------+-------------- - 19696 | 2016-10-17 13:24:17 | postgres | t-ishii | 2016-10-17 13:35:12 | 1 - 19697 | 2016-10-17 13:24:17 | | | | - 19698 | 2016-10-17 13:24:17 | | | | - 19699 | 2016-10-17 13:24:17 | | | | - 19700 | 2016-10-17 13:24:17 | | | | - 19701 | 2016-10-17 13:24:17 | | | | - 19702 | 2016-10-17 13:24:17 | | | | - 19703 | 2016-10-17 13:24:17 | | | | - 19704 | 2016-10-17 13:24:17 | | | | - 19705 | 2016-10-17 13:24:17 | | | | - 19706 | 2016-10-17 13:24:17 | | | | - 19707 | 2016-10-17 13:24:17 | | | | - 19708 | 2016-10-17 13:24:17 | | | | - 19709 | 2016-10-17 13:24:17 | | | | - 19710 | 2016-10-17 13:24:17 | | | | - 19711 | 2016-10-17 13:24:17 | | | | - 19712 | 2016-10-17 13:24:17 | | | | - 19713 | 2016-10-17 13:24:17 | | | | - 19714 | 2016-10-17 13:24:17 | | | | - 19715 | 2016-10-17 13:24:17 | | | | - 19716 | 2016-10-17 13:24:17 | | | | - 19717 | 2016-10-17 13:24:17 | | | | - 19718 | 2016-10-17 13:24:17 | | | | - 19719 | 2016-10-17 13:24:17 | | | | - 19720 | 2016-10-17 13:24:17 | | | | - 20024 | 2016-10-17 13:33:46 | | | | - 19722 | 2016-10-17 13:24:17 | test | t-ishii | 2016-10-17 13:34:42 | 1 - 19723 | 2016-10-17 13:24:17 | | | | - 19724 | 2016-10-17 13:24:17 | | | | - 19725 | 2016-10-17 13:24:17 | | | | - 19726 | 2016-10-17 13:24:17 | | | | - 19727 | 2016-10-17 13:24:17 | | | | - (32 rows) +postgres=# show pool_processes; + pool_pid | start_time | client_connection_count | database | username | backend_connection_time | pool_counter | status +----------+---------------------------------------+-------------------------+----------+----------+-------------------------+--------------+--------------------- + 6685 | 2021-09-07 02:41:13 (remaining: 5:00) | 0 | | | | | Wait for connection + 6686 | 2021-09-07 02:41:13 (remaining: 5:00) | 0 | | | | | Wait for connection + 6687 | 2021-09-07 02:41:13 (remaining: 5:00) | 0 | | | | | Wait for connection + 6688 | 2021-09-07 02:41:13 (remaining: 4:10) | 1 | postgres | postgres | 2021-09-07 02:41:48 | 1 | Idle + 6689 | 2021-09-07 02:41:13 (remaining: 5:00) | 0 | | | | | Wait for connection + 6690 | 2021-09-07 02:41:13 (remaining: 5:00) | 0 | | | | | Wait for connection + 6691 | 2021-09-07 02:41:13 (remaining: 5:00) | 0 | | | | | Wait for connection + 6692 | 2021-09-07 02:41:13 (remaining: 5:00) | 2 | postgres | postgres | 2021-09-07 02:42:38 | 1 | Execute command +(8 rows) diff --git a/doc/src/sgml/ref/pcp_proc_info.sgml b/doc/src/sgml/ref/pcp_proc_info.sgml index de07f30..6602d4e 100644 --- a/doc/src/sgml/ref/pcp_proc_info.sgml +++ b/doc/src/sgml/ref/pcp_proc_info.sgml @@ -85,9 +85,9 @@ Pgpool-II documentation Here is an example output: - $ pcp_proc_info -p 11001 1406 - test t-ishii 2018-07-09 16:43:53 2018-07-09 16:44:08 3 0 1 1435 1 1406 0 - test t-ishii 2018-07-09 16:43:53 2018-07-09 16:44:08 3 0 1 1436 1 1406 1 +$ pcp_proc_info -p 11001 2871 +postgres postgres 2021-09-07 02:12:53 (remaining: 0:27) 1 3 0 2021-09-07 02:16:59 2021-09-07 02:16:59 273 2021-09-07 02:16:56 1 3016 1 2871 0 Idle +postgres postgres 2021-09-07 02:12:53 (remaining: 0:27) 1 3 0 2021-09-07 02:16:59 2021-09-07 02:16:59 0 2021-09-07 02:16:56 1 3017 1 2871 1 Idle @@ -95,15 +95,20 @@ Pgpool-II documentation 1. connected database name 2. connected user name - 3. process start-up timestamp - 4. connection created timestamp + 3. process start-up timestamp (remaining time by . If client_idle_limit is set 0, remaining is not desplayed.) + 4. process-reuse counter for 5. protocol major version 6. protocol minor version - 7. connection-reuse counter - 8. PostgreSQL backend process id - 9. 1 if frontend connected 0 if not - 10. pgpool child process id - 11. PostgreSQL backend id + 7. connection created timestamp + 8. last client connected timestamp + 9. client idle duration (sec) for + 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 @@ -116,29 +121,40 @@ Pgpool-II documentation The option can help understand the output. For example: - $ pcp_proc_info -p 11001 --verbose 1406 - Database : test - Username : t-ishii - Start time : 2018-07-09 16:43:53 - Creation time: 2018-07-09 16:44:08 - Major : 3 - Minor : 0 - Counter : 1 - Backend PID : 1435 - Connected : 1 - PID : 1406 - Backend ID : 0 - Database : test - Username : t-ishii - Start time : 2018-07-09 16:43:53 - Creation time: 2018-07-09 16:44:08 - Major : 3 - Minor : 0 - Counter : 1 - Backend PID : 1436 - Connected : 1 - PID : 1406 - Backend ID : 1 +$ pcp_proc_info -p 11001 --verbose 2871 +Database : postgres +Username : postgres +Start time : 2021-09-07 02:12:53 (remaining: 3:36) +Client connection count : 1 +Major : 3 +Minor : 0 +Backend connection time : 2021-09-07 02:16:59 +Client connection time : 2021-09-07 02:16:59 +Client idle duration : 84 +Client disconnection time : 2021-09-07 02:16:56 +Pool Counter : 1 +Backend PID : 3016 +Connected : 1 +PID : 2871 +Backend ID : 0 +Status : Idle + +Database : postgres +Username : postgres +Start time : 2021-09-07 02:12:53 (remaining: 3:36) +Client connection count : 1 +Major : 3 +Minor : 0 +Backend connection time : 2021-09-07 02:16:59 +Client connection time : 2021-09-07 02:16:59 +Client idle duration : 0 +Client disconnection time : 2021-09-07 02:16:56 +Pool Counter : 1 +Backend PID : 3017 +Connected : 1 +PID : 2871 +Backend ID : 1 +Status : Idle diff --git a/doc/src/sgml/ref/show_pool_pools.sgml b/doc/src/sgml/ref/show_pool_pools.sgml index 54c6643..5ece2ee 100644 --- a/doc/src/sgml/ref/show_pool_pools.sgml +++ b/doc/src/sgml/ref/show_pool_pools.sgml @@ -37,7 +37,7 @@ Pgpool-II - It has 12 columns: + It has 17 columns: @@ -50,6 +50,23 @@ start_time is the timestamp of when this process was launched. + + + + remaining is the remaining time by + . If + client_idle_limit is set 0, + remaining is not desplayed. + + + + + + + + + client_connection_count counts the number of times + this process has been used by clients. @@ -83,13 +100,34 @@ - create_time is the creation time and + backend_connection_time is the creation time and date of the connection. + client_connection_time is the date when a client + last used this connection. + + + + + + client_disconnection_time is the date when a client + last disconnected from this connection. + + + + + + client_idle_duration is the time (sec) that a client + is in idle. + + + + + majorversion and minorversion are the protocol version numbers used in this connection. @@ -118,272 +156,109 @@ + + + status is current status of this process. Possible values are: + + + + Execute command: Executing a command. + + + + + Idle: The process is waiting for a new client command. + + + + + Idle in transaction: The process is waiting for a new client command + in a transaction. + + + + + Wait for connection: The process is waiting for a new client connection. + + + + + + It'll always return * * number_of_backends lines. Here is an example session: - test=# show pool_pools; - pool_pid | start_time | pool_id | backend_id | database | username | create_time | majorversion | minorversion | pool_counter | pool_backendpid | pool_connected - ----------+---------------------+---------+------------+----------+----------+---------------------+--------------+--------------+--------------+-----------------+---------------- - 19696 | 2016-10-17 13:24:17 | 0 | 0 | postgres | t-ishii | 2016-10-17 13:35:12 | 3 | 0 | 1 | 20079 | 1 - 19696 | 2016-10-17 13:24:17 | 0 | 1 | postgres | t-ishii | 2016-10-17 13:35:12 | 3 | 0 | 1 | 20080 | 1 - 19696 | 2016-10-17 13:24:17 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19696 | 2016-10-17 13:24:17 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19696 | 2016-10-17 13:24:17 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19696 | 2016-10-17 13:24:17 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19696 | 2016-10-17 13:24:17 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19696 | 2016-10-17 13:24:17 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19697 | 2016-10-17 13:24:17 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19697 | 2016-10-17 13:24:17 | 0 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19697 | 2016-10-17 13:24:17 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19697 | 2016-10-17 13:24:17 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19697 | 2016-10-17 13:24:17 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19697 | 2016-10-17 13:24:17 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19697 | 2016-10-17 13:24:17 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19697 | 2016-10-17 13:24:17 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19698 | 2016-10-17 13:24:17 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19698 | 2016-10-17 13:24:17 | 0 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19698 | 2016-10-17 13:24:17 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19698 | 2016-10-17 13:24:17 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19698 | 2016-10-17 13:24:17 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19698 | 2016-10-17 13:24:17 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19698 | 2016-10-17 13:24:17 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19698 | 2016-10-17 13:24:17 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19699 | 2016-10-17 13:24:17 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19699 | 2016-10-17 13:24:17 | 0 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19699 | 2016-10-17 13:24:17 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19699 | 2016-10-17 13:24:17 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19699 | 2016-10-17 13:24:17 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19699 | 2016-10-17 13:24:17 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19699 | 2016-10-17 13:24:17 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19699 | 2016-10-17 13:24:17 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19700 | 2016-10-17 13:24:17 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19700 | 2016-10-17 13:24:17 | 0 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19700 | 2016-10-17 13:24:17 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19700 | 2016-10-17 13:24:17 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19700 | 2016-10-17 13:24:17 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19700 | 2016-10-17 13:24:17 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19700 | 2016-10-17 13:24:17 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19700 | 2016-10-17 13:24:17 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19701 | 2016-10-17 13:24:17 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19701 | 2016-10-17 13:24:17 | 0 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19701 | 2016-10-17 13:24:17 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19701 | 2016-10-17 13:24:17 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19701 | 2016-10-17 13:24:17 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19701 | 2016-10-17 13:24:17 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19701 | 2016-10-17 13:24:17 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19701 | 2016-10-17 13:24:17 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19702 | 2016-10-17 13:24:17 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19702 | 2016-10-17 13:24:17 | 0 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19702 | 2016-10-17 13:24:17 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19702 | 2016-10-17 13:24:17 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19702 | 2016-10-17 13:24:17 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19702 | 2016-10-17 13:24:17 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19702 | 2016-10-17 13:24:17 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19702 | 2016-10-17 13:24:17 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19703 | 2016-10-17 13:24:17 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19703 | 2016-10-17 13:24:17 | 0 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19703 | 2016-10-17 13:24:17 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19703 | 2016-10-17 13:24:17 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19703 | 2016-10-17 13:24:17 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19703 | 2016-10-17 13:24:17 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19703 | 2016-10-17 13:24:17 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19703 | 2016-10-17 13:24:17 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19704 | 2016-10-17 13:24:17 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19704 | 2016-10-17 13:24:17 | 0 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19704 | 2016-10-17 13:24:17 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19704 | 2016-10-17 13:24:17 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19704 | 2016-10-17 13:24:17 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19704 | 2016-10-17 13:24:17 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19704 | 2016-10-17 13:24:17 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19704 | 2016-10-17 13:24:17 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19705 | 2016-10-17 13:24:17 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19705 | 2016-10-17 13:24:17 | 0 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19705 | 2016-10-17 13:24:17 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19705 | 2016-10-17 13:24:17 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19705 | 2016-10-17 13:24:17 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19705 | 2016-10-17 13:24:17 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19705 | 2016-10-17 13:24:17 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19705 | 2016-10-17 13:24:17 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19706 | 2016-10-17 13:24:17 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19706 | 2016-10-17 13:24:17 | 0 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19706 | 2016-10-17 13:24:17 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19706 | 2016-10-17 13:24:17 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19706 | 2016-10-17 13:24:17 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19706 | 2016-10-17 13:24:17 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19706 | 2016-10-17 13:24:17 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19706 | 2016-10-17 13:24:17 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19707 | 2016-10-17 13:24:17 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19707 | 2016-10-17 13:24:17 | 0 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19707 | 2016-10-17 13:24:17 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19707 | 2016-10-17 13:24:17 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19707 | 2016-10-17 13:24:17 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19707 | 2016-10-17 13:24:17 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19707 | 2016-10-17 13:24:17 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19707 | 2016-10-17 13:24:17 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19708 | 2016-10-17 13:24:17 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19708 | 2016-10-17 13:24:17 | 0 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19708 | 2016-10-17 13:24:17 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19708 | 2016-10-17 13:24:17 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19708 | 2016-10-17 13:24:17 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19708 | 2016-10-17 13:24:17 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19708 | 2016-10-17 13:24:17 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19708 | 2016-10-17 13:24:17 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19709 | 2016-10-17 13:24:17 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19709 | 2016-10-17 13:24:17 | 0 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19709 | 2016-10-17 13:24:17 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19709 | 2016-10-17 13:24:17 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19709 | 2016-10-17 13:24:17 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19709 | 2016-10-17 13:24:17 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19709 | 2016-10-17 13:24:17 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19709 | 2016-10-17 13:24:17 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19710 | 2016-10-17 13:24:17 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19710 | 2016-10-17 13:24:17 | 0 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19710 | 2016-10-17 13:24:17 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19710 | 2016-10-17 13:24:17 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19710 | 2016-10-17 13:24:17 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19710 | 2016-10-17 13:24:17 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19710 | 2016-10-17 13:24:17 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19710 | 2016-10-17 13:24:17 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19711 | 2016-10-17 13:24:17 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19711 | 2016-10-17 13:24:17 | 0 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19711 | 2016-10-17 13:24:17 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19711 | 2016-10-17 13:24:17 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19711 | 2016-10-17 13:24:17 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19711 | 2016-10-17 13:24:17 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19711 | 2016-10-17 13:24:17 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19711 | 2016-10-17 13:24:17 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19712 | 2016-10-17 13:24:17 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19712 | 2016-10-17 13:24:17 | 0 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19712 | 2016-10-17 13:24:17 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19712 | 2016-10-17 13:24:17 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19712 | 2016-10-17 13:24:17 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19712 | 2016-10-17 13:24:17 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19712 | 2016-10-17 13:24:17 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19712 | 2016-10-17 13:24:17 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19713 | 2016-10-17 13:24:17 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19713 | 2016-10-17 13:24:17 | 0 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19713 | 2016-10-17 13:24:17 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19713 | 2016-10-17 13:24:17 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19713 | 2016-10-17 13:24:17 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19713 | 2016-10-17 13:24:17 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19713 | 2016-10-17 13:24:17 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19713 | 2016-10-17 13:24:17 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19714 | 2016-10-17 13:24:17 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19714 | 2016-10-17 13:24:17 | 0 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19714 | 2016-10-17 13:24:17 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19714 | 2016-10-17 13:24:17 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19714 | 2016-10-17 13:24:17 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19714 | 2016-10-17 13:24:17 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19714 | 2016-10-17 13:24:17 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19714 | 2016-10-17 13:24:17 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19715 | 2016-10-17 13:24:17 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19715 | 2016-10-17 13:24:17 | 0 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19715 | 2016-10-17 13:24:17 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19715 | 2016-10-17 13:24:17 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19715 | 2016-10-17 13:24:17 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19715 | 2016-10-17 13:24:17 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19715 | 2016-10-17 13:24:17 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19715 | 2016-10-17 13:24:17 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19716 | 2016-10-17 13:24:17 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19716 | 2016-10-17 13:24:17 | 0 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19716 | 2016-10-17 13:24:17 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19716 | 2016-10-17 13:24:17 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19716 | 2016-10-17 13:24:17 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19716 | 2016-10-17 13:24:17 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19716 | 2016-10-17 13:24:17 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19716 | 2016-10-17 13:24:17 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19717 | 2016-10-17 13:24:17 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19717 | 2016-10-17 13:24:17 | 0 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19717 | 2016-10-17 13:24:17 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19717 | 2016-10-17 13:24:17 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19717 | 2016-10-17 13:24:17 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19717 | 2016-10-17 13:24:17 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19717 | 2016-10-17 13:24:17 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19717 | 2016-10-17 13:24:17 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19718 | 2016-10-17 13:24:17 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19718 | 2016-10-17 13:24:17 | 0 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19718 | 2016-10-17 13:24:17 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19718 | 2016-10-17 13:24:17 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19718 | 2016-10-17 13:24:17 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19718 | 2016-10-17 13:24:17 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19718 | 2016-10-17 13:24:17 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19718 | 2016-10-17 13:24:17 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19719 | 2016-10-17 13:24:17 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19719 | 2016-10-17 13:24:17 | 0 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19719 | 2016-10-17 13:24:17 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19719 | 2016-10-17 13:24:17 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19719 | 2016-10-17 13:24:17 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19719 | 2016-10-17 13:24:17 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19719 | 2016-10-17 13:24:17 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19719 | 2016-10-17 13:24:17 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19720 | 2016-10-17 13:24:17 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19720 | 2016-10-17 13:24:17 | 0 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19720 | 2016-10-17 13:24:17 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19720 | 2016-10-17 13:24:17 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19720 | 2016-10-17 13:24:17 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19720 | 2016-10-17 13:24:17 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19720 | 2016-10-17 13:24:17 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19720 | 2016-10-17 13:24:17 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 20024 | 2016-10-17 13:33:46 | 0 | 0 | test | t-ishii | 2016-10-17 14:30:53 | 3 | 0 | 1 | 22055 | 1 - 20024 | 2016-10-17 13:33:46 | 0 | 1 | test | t-ishii | 2016-10-17 14:30:53 | 3 | 0 | 1 | 22056 | 1 - 20024 | 2016-10-17 13:33:46 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 20024 | 2016-10-17 13:33:46 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 20024 | 2016-10-17 13:33:46 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 20024 | 2016-10-17 13:33:46 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 20024 | 2016-10-17 13:33:46 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 20024 | 2016-10-17 13:33:46 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 20600 | 2016-10-17 13:46:58 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 20600 | 2016-10-17 13:46:58 | 0 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 20600 | 2016-10-17 13:46:58 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 20600 | 2016-10-17 13:46:58 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 20600 | 2016-10-17 13:46:58 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 20600 | 2016-10-17 13:46:58 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 20600 | 2016-10-17 13:46:58 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 20600 | 2016-10-17 13:46:58 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19723 | 2016-10-17 13:24:17 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19723 | 2016-10-17 13:24:17 | 0 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19723 | 2016-10-17 13:24:17 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19723 | 2016-10-17 13:24:17 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19723 | 2016-10-17 13:24:17 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19723 | 2016-10-17 13:24:17 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19723 | 2016-10-17 13:24:17 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19723 | 2016-10-17 13:24:17 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19724 | 2016-10-17 13:24:17 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19724 | 2016-10-17 13:24:17 | 0 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19724 | 2016-10-17 13:24:17 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19724 | 2016-10-17 13:24:17 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19724 | 2016-10-17 13:24:17 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19724 | 2016-10-17 13:24:17 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19724 | 2016-10-17 13:24:17 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19724 | 2016-10-17 13:24:17 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19725 | 2016-10-17 13:24:17 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19725 | 2016-10-17 13:24:17 | 0 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19725 | 2016-10-17 13:24:17 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19725 | 2016-10-17 13:24:17 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19725 | 2016-10-17 13:24:17 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19725 | 2016-10-17 13:24:17 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19725 | 2016-10-17 13:24:17 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19725 | 2016-10-17 13:24:17 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19726 | 2016-10-17 13:24:17 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19726 | 2016-10-17 13:24:17 | 0 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19726 | 2016-10-17 13:24:17 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19726 | 2016-10-17 13:24:17 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19726 | 2016-10-17 13:24:17 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19726 | 2016-10-17 13:24:17 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19726 | 2016-10-17 13:24:17 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19726 | 2016-10-17 13:24:17 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19727 | 2016-10-17 13:24:17 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19727 | 2016-10-17 13:24:17 | 0 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19727 | 2016-10-17 13:24:17 | 1 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19727 | 2016-10-17 13:24:17 | 1 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19727 | 2016-10-17 13:24:17 | 2 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19727 | 2016-10-17 13:24:17 | 2 | 1 | | | | 0 | 0 | 0 | 0 | 0 - 19727 | 2016-10-17 13:24:17 | 3 | 0 | | | | 0 | 0 | 0 | 0 | 0 - 19727 | 2016-10-17 13:24:17 | 3 | 1 | | | | 0 | 0 | 0 | 0 | 0 - (256 rows) +postgres=# 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 +----------+---------------------------------------+-------------------------+---------+------------+----------+----------+-------------------------+------------------------+---------------------------+----------------------+--------------+--------------+--------------+-----------------+----------------+--------------------- + 3727 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 0 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3727 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 0 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3727 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 1 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3727 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 1 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3727 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 2 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3727 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 2 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3727 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 3 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3727 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 3 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3728 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 0 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3728 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 0 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3728 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 1 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3728 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 1 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3728 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 2 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3728 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 2 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3728 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 3 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3728 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 3 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3729 | 2021-09-07 02:29:38 (remaining: 3:30) | 1 | 0 | 0 | postgres | postgres | 2021-09-07 02:29:47 | 2021-09-07 02:29:47 | 2021-09-07 02:29:46 | 90 | 3 | 0 | 1 | 3749 | 1 | Idle + 3729 | 2021-09-07 02:29:38 (remaining: 3:30) | 1 | 0 | 1 | postgres | postgres | 2021-09-07 02:29:47 | 2021-09-07 02:29:47 | 2021-09-07 02:29:46 | 0 | 3 | 0 | 1 | 3750 | 1 | Idle + 3729 | 2021-09-07 02:29:38 (remaining: 3:30) | 1 | 1 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Idle + 3729 | 2021-09-07 02:29:38 (remaining: 3:30) | 1 | 1 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Idle + 3729 | 2021-09-07 02:29:38 (remaining: 3:30) | 1 | 2 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Idle + 3729 | 2021-09-07 02:29:38 (remaining: 3:30) | 1 | 2 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Idle + 3729 | 2021-09-07 02:29:38 (remaining: 3:30) | 1 | 3 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Idle + 3729 | 2021-09-07 02:29:38 (remaining: 3:30) | 1 | 3 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Idle + 3730 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 0 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3730 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 0 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3730 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 1 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3730 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 1 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3730 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 2 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3730 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 2 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3730 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 3 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3730 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 3 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3731 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 0 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3731 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 0 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3731 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 1 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3731 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 1 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3731 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 2 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3731 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 2 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3731 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 3 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3731 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 3 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3732 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 0 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3732 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 0 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3732 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 1 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3732 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 1 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3732 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 2 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3732 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 2 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3732 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 3 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3732 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 3 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3733 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 0 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3733 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 0 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3733 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 1 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3733 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 1 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3733 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 2 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3733 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 2 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3733 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 3 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3733 | 2021-09-07 02:29:38 (remaining: 5:00) | 0 | 3 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Wait for connection + 3734 | 2021-09-07 02:29:38 (remaining: 5:00) | 4 | 0 | 0 | postgres | postgres | 2021-09-07 02:31:22 | 2021-09-07 02:31:22 | 2021-09-07 02:31:15 | 0 | 3 | 0 | 1 | 3823 | 1 | Execute command + 3734 | 2021-09-07 02:29:38 (remaining: 5:00) | 4 | 0 | 1 | postgres | postgres | 2021-09-07 02:31:22 | 2021-09-07 02:31:22 | 2021-09-07 02:31:15 | 0 | 3 | 0 | 1 | 3824 | 1 | Execute command + 3734 | 2021-09-07 02:29:38 (remaining: 5:00) | 4 | 1 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Execute command + 3734 | 2021-09-07 02:29:38 (remaining: 5:00) | 4 | 1 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Execute command + 3734 | 2021-09-07 02:29:38 (remaining: 5:00) | 4 | 2 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Execute command + 3734 | 2021-09-07 02:29:38 (remaining: 5:00) | 4 | 2 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Execute command + 3734 | 2021-09-07 02:29:38 (remaining: 5:00) | 4 | 3 | 0 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Execute command + 3734 | 2021-09-07 02:29:38 (remaining: 5:00) | 4 | 3 | 1 | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | Execute command +(64 rows) diff --git a/doc/src/sgml/ref/show_pool_processes.sgml b/doc/src/sgml/ref/show_pool_processes.sgml index 30cae79..3036737 100644 --- a/doc/src/sgml/ref/show_pool_processes.sgml +++ b/doc/src/sgml/ref/show_pool_processes.sgml @@ -37,7 +37,7 @@ connections and dealing with a connection. - It has 6 columns: + It has 8 columns: @@ -49,6 +49,22 @@ start_time is the timestamp of when this process was launched. + + + + remaining is the remaining time by + . If + client_idle_limit is set 0, + remaining is not desplayed. + + + + + + + + client_connection_count counts the number of times + this process has been used by clients. @@ -66,7 +82,7 @@ - create_time is the creation time and + backend_connection_time is the creation time and date of the connection. @@ -77,47 +93,51 @@ clients. + + + status is 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. + + + + + Here is an example session: - test=# show pool_processes; - pool_pid | start_time | database | username | create_time | pool_counter - ----------+---------------------+----------+----------+---------------------+-------------- - 19696 | 2016-10-17 13:24:17 | postgres | t-ishii | 2016-10-17 13:35:12 | 1 - 19697 | 2016-10-17 13:24:17 | | | | - 19698 | 2016-10-17 13:24:17 | | | | - 19699 | 2016-10-17 13:24:17 | | | | - 19700 | 2016-10-17 13:24:17 | | | | - 19701 | 2016-10-17 13:24:17 | | | | - 19702 | 2016-10-17 13:24:17 | | | | - 19703 | 2016-10-17 13:24:17 | | | | - 19704 | 2016-10-17 13:24:17 | | | | - 19705 | 2016-10-17 13:24:17 | | | | - 19706 | 2016-10-17 13:24:17 | | | | - 19707 | 2016-10-17 13:24:17 | | | | - 19708 | 2016-10-17 13:24:17 | | | | - 19709 | 2016-10-17 13:24:17 | | | | - 19710 | 2016-10-17 13:24:17 | | | | - 19711 | 2016-10-17 13:24:17 | | | | - 19712 | 2016-10-17 13:24:17 | | | | - 19713 | 2016-10-17 13:24:17 | | | | - 19714 | 2016-10-17 13:24:17 | | | | - 19715 | 2016-10-17 13:24:17 | | | | - 19716 | 2016-10-17 13:24:17 | | | | - 19717 | 2016-10-17 13:24:17 | | | | - 19718 | 2016-10-17 13:24:17 | | | | - 19719 | 2016-10-17 13:24:17 | | | | - 19720 | 2016-10-17 13:24:17 | | | | - 20024 | 2016-10-17 13:33:46 | | | | - 19722 | 2016-10-17 13:24:17 | test | t-ishii | 2016-10-17 13:34:42 | 1 - 19723 | 2016-10-17 13:24:17 | | | | - 19724 | 2016-10-17 13:24:17 | | | | - 19725 | 2016-10-17 13:24:17 | | | | - 19726 | 2016-10-17 13:24:17 | | | | - 19727 | 2016-10-17 13:24:17 | | | | - (32 rows) +postgres=# show pool_processes; + pool_pid | start_time | client_connection_count | database | username | backend_connection_time | pool_counter | status +----------+---------------------------------------+-------------------------+----------+----------+-------------------------+--------------+--------------------- + 6685 | 2021-09-07 02:41:13 (remaining: 5:00) | 0 | | | | | Wait for connection + 6686 | 2021-09-07 02:41:13 (remaining: 5:00) | 0 | | | | | Wait for connection + 6687 | 2021-09-07 02:41:13 (remaining: 5:00) | 0 | | | | | Wait for connection + 6688 | 2021-09-07 02:41:13 (remaining: 4:10) | 1 | postgres | postgres | 2021-09-07 02:41:48 | 1 | Idle + 6689 | 2021-09-07 02:41:13 (remaining: 5:00) | 0 | | | | | Wait for connection + 6690 | 2021-09-07 02:41:13 (remaining: 5:00) | 0 | | | | | Wait for connection + 6691 | 2021-09-07 02:41:13 (remaining: 5:00) | 0 | | | | | Wait for connection + 6692 | 2021-09-07 02:41:13 (remaining: 5:00) | 2 | postgres | postgres | 2021-09-07 02:42:38 | 1 | Execute command +(8 rows) diff --git a/src/context/pool_process_context.c b/src/context/pool_process_context.c index 6e6402c..51b08be 100644 --- a/src/context/pool_process_context.c +++ b/src/context/pool_process_context.c @@ -292,6 +292,7 @@ pool_coninfo_set_frontend_connected(int proc_id, int pool_index) return; } con->connected = true; + con->client_connection_time = time(NULL); } } @@ -317,6 +318,7 @@ pool_coninfo_unset_frontend_connected(int proc_id, int pool_index) return; } con->connected = false; + con->client_disconnection_time = time(NULL); } } diff --git a/src/include/pcp/libpcp_ext.h b/src/include/pcp/libpcp_ext.h index b62c3b2..acf9407 100644 --- a/src/include/pcp/libpcp_ext.h +++ b/src/include/pcp/libpcp_ext.h @@ -118,6 +118,14 @@ typedef struct BackendInfo backend_info[MAX_NUM_BACKENDS]; } BackendDesc; +typedef enum +{ + WAIT_FOR_CONNECT, + COMMAND_EXECUTE, + IDLE, + IDLE_IN_TRANS +} ProcessStatus; + /* * Connection pool information. Placed on shared memory area. */ @@ -132,6 +140,9 @@ typedef struct int key; /* cancel key */ int counter; /* used counter */ time_t create_time; /* connection creation time */ + time_t client_connection_time; /* client connection time */ + time_t client_disconnection_time; /* client last disconnection time */ + int client_idle_duration; /* client idle duration time (s) */ int load_balancing_node; /* load balancing node */ char connected; /* True if frontend connected. Please note * that we use "char" instead of "bool". Since @@ -160,6 +171,8 @@ typedef struct time_t start_time; /* fork() time */ ConnectionInfo *connection_info; /* head of the connection info for * this process */ + int client_connection_count; /* how many times clients used this process */ + ProcessStatus status; char need_to_restart; /* If non 0, exit this child process as * soon as current session ends. Typical * case this flag being set is failback a @@ -181,7 +194,7 @@ typedef struct #define POOLCONFIG_MAXDATELEN 128 #define POOLCONFIG_MAXCOUNTLEN 16 #define POOLCONFIG_MAXLONGCOUNTLEN 20 - +#define POOLCONFIG_MAXPROCESSSTATUSLEN 20 /* config report struct*/ typedef struct { @@ -213,28 +226,35 @@ typedef struct typedef struct { char pool_pid[POOLCONFIG_MAXCOUNTLEN + 1]; - char start_time[POOLCONFIG_MAXDATELEN + 1]; + char process_start_time[POOLCONFIG_MAXDATELEN + 1]; + char client_connection_count[POOLCONFIG_MAXCOUNTLEN + 1]; char database[POOLCONFIG_MAXIDENTLEN + 1]; char username[POOLCONFIG_MAXIDENTLEN + 1]; - char create_time[POOLCONFIG_MAXDATELEN + 1]; + char backend_connection_time[POOLCONFIG_MAXDATELEN + 1]; char pool_counter[POOLCONFIG_MAXCOUNTLEN + 1]; + char status[POOLCONFIG_MAXPROCESSSTATUSLEN + 1]; } POOL_REPORT_PROCESSES; /* pools reporting struct */ typedef struct { char pool_pid[POOLCONFIG_MAXCOUNTLEN + 1]; - char start_time[POOLCONFIG_MAXDATELEN + 1]; + char process_start_time[POOLCONFIG_MAXDATELEN + 1]; + char client_connection_count[POOLCONFIG_MAXCOUNTLEN + 1]; char pool_id[POOLCONFIG_MAXCOUNTLEN + 1]; char backend_id[POOLCONFIG_MAXCOUNTLEN + 1]; char database[POOLCONFIG_MAXIDENTLEN + 1]; char username[POOLCONFIG_MAXIDENTLEN + 1]; - char create_time[POOLCONFIG_MAXDATELEN + 1]; + char backend_connection_time[POOLCONFIG_MAXDATELEN + 1]; + char client_connection_time[POOLCONFIG_MAXDATELEN + 1]; + char client_disconnection_time[POOLCONFIG_MAXDATELEN + 1]; + char client_idle_duration[POOLCONFIG_MAXCOUNTLEN + 1]; char pool_majorversion[POOLCONFIG_MAXCOUNTLEN + 1]; char pool_minorversion[POOLCONFIG_MAXCOUNTLEN + 1]; char pool_counter[POOLCONFIG_MAXCOUNTLEN + 1]; char pool_backendpid[POOLCONFIG_MAXCOUNTLEN + 1]; char pool_connected[POOLCONFIG_MAXCOUNTLEN + 1]; + char status[POOLCONFIG_MAXPROCESSSTATUSLEN + 1]; } POOL_REPORT_POOLS; /* version struct */ diff --git a/src/include/pool.h b/src/include/pool.h index d15a0a1..940ba39 100644 --- a/src/include/pool.h +++ b/src/include/pool.h @@ -619,7 +619,7 @@ extern int send_to_pg_frontend(char *data, int len, bool flush); extern int pg_frontend_exists(void); extern int set_pg_frontend_blocking(bool blocking); extern int get_frontend_protocol_version(void); - +extern void set_process_status(ProcessStatus status); /*pool_shmem.c*/ extern void *pool_shared_memory_create(size_t size); diff --git a/src/main/pgpool_main.c b/src/main/pgpool_main.c index c4453a7..45039c3 100644 --- a/src/main/pgpool_main.c +++ b/src/main/pgpool_main.c @@ -409,6 +409,8 @@ PgpoolMain(bool discard_status, bool clear_memcache_oidmaps) { process_info[i].pid = fork_a_child(fds, i); process_info[i].start_time = time(NULL); + process_info[i].client_connection_count = 0; + process_info[i].status = WAIT_FOR_CONNECT; } /* create pipe for delivering event */ @@ -2022,6 +2024,8 @@ failover(void) process_info[i].pid = fork_a_child(fds, i); process_info[i].start_time = time(NULL); + process_info[i].client_connection_count = 0; + process_info[i].status = WAIT_FOR_CONNECT; } } else @@ -2489,6 +2493,8 @@ reaper(void) process_info[i].pid = fork_a_child(fds, i); process_info[i].start_time = time(NULL); new_pid = process_info[i].pid; + process_info[i].client_connection_count = 0; + process_info[i].status = WAIT_FOR_CONNECT; } else process_info[i].pid = 0; @@ -4242,6 +4248,8 @@ sync_backend_from_watchdog(void) process_info[i].pid = fork_a_child(fds, i); process_info[i].start_time = time(NULL); + process_info[i].client_connection_count = 0; + process_info[i].status = WAIT_FOR_CONNECT; } } else diff --git a/src/protocol/child.c b/src/protocol/child.c index 4fb6f77..427c809 100644 --- a/src/protocol/child.c +++ b/src/protocol/child.c @@ -162,6 +162,8 @@ do_child(int *fds) ereport(DEBUG2, (errmsg("I am Pgpool Child process with pid: %d", getpid()))); + ProcessInfo* proc_info = pool_get_process_info(getpid()); + /* Identify myself via ps */ init_ps_display("", "", "", ""); @@ -284,6 +286,8 @@ do_child(int *fds) if (pool_config->child_max_connections > 0) connections_count++; + proc_info->client_connection_count++; + /* check if maximum connections count for this child reached */ if ((pool_config->child_max_connections > 0) && (connections_count >= pool_config->child_max_connections)) @@ -410,6 +414,7 @@ do_child(int *fds) snprintf(psbuf, sizeof(psbuf), "%s %s %s idle", sp->user, sp->database, remote_ps_data); set_ps_display(psbuf, false); + set_process_status(IDLE); /* * Initialize per session context @@ -468,6 +473,8 @@ do_child(int *fds) if (pool_config->child_max_connections > 0) connections_count++; + proc_info->client_connection_count++; + /* check if maximum connections count for this child reached */ if ((pool_config->child_max_connections > 0) && (connections_count >= pool_config->child_max_connections)) @@ -1481,6 +1488,8 @@ wait_for_new_connections(int *fds, struct timeval *timeout, SockAddr *saddr) else set_ps_display("wait for connection request", false); + set_process_status(WAIT_FOR_CONNECT); + memcpy((char *) &rmask, (char *) &readmask, sizeof(fd_set)); if (timeout->tv_sec == 0 && timeout->tv_usec == 0) @@ -1551,6 +1560,7 @@ wait_for_new_connections(int *fds, struct timeval *timeout, SockAddr *saddr) } set_ps_display("wait for connection request", false); + set_process_status(WAIT_FOR_CONNECT); ereport(DEBUG1, (errmsg("LOCKING select()"))); } @@ -2124,3 +2134,10 @@ static int opt_sort(const void *a, const void *b) { return strcmp( *(char **)a, *(char **)b); } + +void +set_process_status(ProcessStatus status) +{ + ProcessInfo* proc_info = pool_get_process_info(getpid()); + proc_info->status = status; +} \ No newline at end of file diff --git a/src/protocol/pool_connection_pool.c b/src/protocol/pool_connection_pool.c index e84822e..ed28d87 100644 --- a/src/protocol/pool_connection_pool.c +++ b/src/protocol/pool_connection_pool.c @@ -968,6 +968,7 @@ static POOL_CONNECTION_POOL * new_connection(POOL_CONNECTION_POOL * p) else { p->info[i].create_time = time(NULL); + p->info[i].client_idle_duration = 0; p->slots[i] = s; pool_init_params(&s->con->params); diff --git a/src/protocol/pool_process_query.c b/src/protocol/pool_process_query.c index 898c558..0e4bfa0 100644 --- a/src/protocol/pool_process_query.c +++ b/src/protocol/pool_process_query.c @@ -238,6 +238,7 @@ pool_process_query(POOL_CONNECTION * frontend, bool cont = true; status = read_packets_and_process(frontend, backend, reset_request, &state, &num_fields, &cont); + backend->info->client_idle_duration = 0; if (status != POOL_CONTINUE) return status; else if (!cont) /* Detected admin shutdown */ @@ -289,6 +290,7 @@ pool_process_query(POOL_CONNECTION * frontend, bool cont = true; status = read_packets_and_process(frontend, backend, reset_request, &state, &num_fields, &cont); + backend->info->client_idle_duration = 0; if (status != POOL_CONTINUE) return status; else if (!cont) /* Detected admin shutdown */ @@ -3862,6 +3864,7 @@ query_ps_status(char *query, POOL_CONNECTION_POOL * backend) psbuf[i] = '\0'; set_ps_display(psbuf, false); + set_process_status(COMMAND_EXECUTE); } /* compare function for bsearch() */ @@ -4751,6 +4754,7 @@ SELECT_RETRY: /* select timeout */ if (fds == 0) { + backend->info->client_idle_duration++; if (*InRecovery == RECOVERY_INIT && pool_config->client_idle_limit > 0) { idle_count++; diff --git a/src/tools/pcp/pcp_frontend_client.c b/src/tools/pcp/pcp_frontend_client.c index af1c08b..235fcf6 100644 --- a/src/tools/pcp/pcp_frontend_client.c +++ b/src/tools/pcp/pcp_frontend_client.c @@ -701,14 +701,16 @@ output_procinfo_result(PCPResultInfo * pcpResInfo, bool all, bool verbose) int array_size = pcp_result_slot_count(pcpResInfo); const char *titles[] = { - "Database", "Username", "Start time", "Creation time", - "Major", "Minor", "Counter", "Backend PID", - "Connected", "PID", "Backend ID" + "Database", "Username", "Start time", "Client connection count", + "Major", "Minor", "Backend connection time", "Client connection time", + "Client idle duration", "Client disconnection time", "Pool Counter", "Backend PID", + "Connected", "PID", "Backend ID", "Status" }; const char *types[] = { "s", "s", "s", "s", "s", "s", "s", "s", - "s", "s", "s" + "s", "s", "s", "s", + "s", "s", "s", "s" }; @@ -716,7 +718,7 @@ output_procinfo_result(PCPResultInfo * pcpResInfo, bool all, bool verbose) format = format_titles(titles, types, sizeof(titles)/sizeof(char *)); else { - format = "%s %s %s %s %s %s %s %s %s %s %s\n"; + format = "%s %s %s %s %s %s %s %s %s %s %s %s %s %s %s %s\n"; } for (i = 0; i < array_size; i++) @@ -732,15 +734,20 @@ output_procinfo_result(PCPResultInfo * pcpResInfo, bool all, bool verbose) printf(format, pools->database, pools->username, - pools->start_time, - pools->create_time, + pools->process_start_time, + pools->client_connection_count, pools->pool_majorversion, pools->pool_minorversion, + pools->backend_connection_time, + pools->client_connection_time, + pools->client_idle_duration, + pools->client_disconnection_time, pools->pool_counter, pools->pool_backendpid, pools->pool_connected, pools->pool_pid, - pools->backend_id); + pools->backend_id, + pools->status); } if (printed == false) printf("No process information available\n\n"); diff --git a/src/utils/pool_health_check_stats.c b/src/utils/pool_health_check_stats.c index b90fd5c..b062ed2 100644 --- a/src/utils/pool_health_check_stats.c +++ b/src/utils/pool_health_check_stats.c @@ -69,17 +69,22 @@ int * pool_report_pools_offsets(int *n) static int offsettbl[] = { offsetof(POOL_REPORT_POOLS, pool_pid), - offsetof(POOL_REPORT_POOLS, start_time), + offsetof(POOL_REPORT_POOLS, process_start_time), + offsetof(POOL_REPORT_POOLS, client_connection_count), offsetof(POOL_REPORT_POOLS, pool_id), offsetof(POOL_REPORT_POOLS, backend_id), offsetof(POOL_REPORT_POOLS, database), offsetof(POOL_REPORT_POOLS, username), - offsetof(POOL_REPORT_POOLS, create_time), + offsetof(POOL_REPORT_POOLS, backend_connection_time), + offsetof(POOL_REPORT_POOLS, client_connection_time), + offsetof(POOL_REPORT_POOLS, client_disconnection_time), + offsetof(POOL_REPORT_POOLS, client_idle_duration), offsetof(POOL_REPORT_POOLS, pool_majorversion), offsetof(POOL_REPORT_POOLS, pool_minorversion), offsetof(POOL_REPORT_POOLS, pool_counter), offsetof(POOL_REPORT_POOLS, pool_backendpid), - offsetof(POOL_REPORT_POOLS, pool_connected) + offsetof(POOL_REPORT_POOLS, pool_connected), + offsetof(POOL_REPORT_POOLS, status) }; *n = sizeof(offsettbl)/sizeof(int); diff --git a/src/utils/pool_process_reporting.c b/src/utils/pool_process_reporting.c index 78a2927..1bfc2e4 100644 --- a/src/utils/pool_process_reporting.c +++ b/src/utils/pool_process_reporting.c @@ -1419,6 +1419,20 @@ get_pools(int *nrows) proc_id = process_info[child].pid; pi = pool_get_process_info(proc_id); + int remaining_time = pool_config->client_idle_limit; + if (pool_config->client_idle_limit) + { + for (pool = 0; pool < pool_config->max_pool; pool++) + { + for (backend_id = 0; backend_id < NUM_BACKENDS; backend_id++) + { + poolBE = pool * MAX_NUM_BACKENDS + backend_id; + if (pi->connection_info[poolBE].client_idle_duration > 0) + remaining_time = pool_config->client_idle_limit - pi->connection_info[poolBE].client_idle_duration; + } + } + } + for (pool = 0; pool < pool_config->max_pool; pool++) { for (backend_id = 0; backend_id < NUM_BACKENDS; backend_id++) @@ -1427,20 +1441,59 @@ get_pools(int *nrows) snprintf(pools[lines].pool_pid, sizeof(pools[lines].pool_pid), "%d", proc_id); if (pi->start_time) - strftime(pools[lines].start_time, sizeof(pools[lines].start_time), "%Y-%m-%d %H:%M:%S", - localtime(&pi->start_time)); + { + if (pool_config->client_idle_limit) + { + char proc_start_time[POOLCONFIG_MAXDATELEN + 1]; + strftime(proc_start_time, sizeof(proc_start_time), + "%Y-%m-%d %H:%M:%S", localtime(&pi->start_time)); + snprintf(pools[lines].process_start_time, sizeof(pools[lines].process_start_time), + "%s (remaining: %d:%02d)", proc_start_time, + remaining_time / 60, + remaining_time % 60); + } + else + { + strftime(pools[lines].process_start_time, sizeof(pools[lines].process_start_time), + "%Y-%m-%d %H:%M:%S", localtime(&pi->start_time)); + } + } else - *(pools[lines].start_time) = '\0'; + *(pools[lines].process_start_time) = '\0'; snprintf(pools[lines].pool_id, sizeof(pools[lines].pool_id), "%d", pool); snprintf(pools[lines].backend_id, sizeof(pools[lines].backend_id), "%d", backend_id); + snprintf(pools[lines].client_connection_count, sizeof(pools[lines].client_connection_count), + "%d", pi->client_connection_count); + + if (pi->connection_info[poolBE].client_connection_time == 0){ + *(pools[lines].client_connection_time) = '\0'; + } + else + { + strftime(pools[lines].client_connection_time, sizeof(pools[lines].client_connection_time), + "%Y-%m-%d %H:%M:%S", localtime(&pi->connection_info[poolBE].client_connection_time)); + } + + if (pi->connection_info[poolBE].client_disconnection_time == 0){ + *(pools[lines].client_disconnection_time) = '\0'; + } + else + { + strftime(pools[lines].client_disconnection_time, sizeof(pools[lines].client_disconnection_time), + "%Y-%m-%d %H:%M:%S", localtime(&pi->connection_info[poolBE].client_disconnection_time)); + } + + snprintf(pools[lines].client_idle_duration, sizeof(pools[lines].client_idle_duration), "%d", + pi->connection_info[poolBE].client_idle_duration); + if (strlen(pi->connection_info[poolBE].database) == 0) { StrNCpy(pools[lines].database, "", POOLCONFIG_MAXIDENTLEN); StrNCpy(pools[lines].username, "", POOLCONFIG_MAXIDENTLEN); - *(pools[lines].create_time) = '\0'; + *(pools[lines].backend_connection_time) = '\0'; snprintf(pools[lines].pool_majorversion, sizeof(pools[lines].pool_majorversion), "%d", 0); snprintf(pools[lines].pool_minorversion, sizeof(pools[lines].pool_minorversion), "%d", 0); } @@ -1448,8 +1501,8 @@ get_pools(int *nrows) { StrNCpy(pools[lines].database, pi->connection_info[poolBE].database, POOLCONFIG_MAXIDENTLEN); StrNCpy(pools[lines].username, pi->connection_info[poolBE].user, POOLCONFIG_MAXIDENTLEN); - strftime(pools[lines].create_time, sizeof(pools[lines].create_time), "%Y-%m-%d %H:%M:%S", - localtime(&pi->connection_info[poolBE].create_time)); + strftime(pools[lines].backend_connection_time, sizeof(pools[lines].backend_connection_time), + "%Y-%m-%d %H:%M:%S", localtime(&pi->connection_info[poolBE].create_time)); snprintf(pools[lines].pool_majorversion, sizeof(pools[lines].pool_majorversion), "%d", pi->connection_info[poolBE].major); snprintf(pools[lines].pool_minorversion, sizeof(pools[lines].pool_minorversion), "%d", @@ -1462,6 +1515,24 @@ get_pools(int *nrows) snprintf(pools[lines].pool_connected, sizeof(pools[lines].pool_connected), "%d", pi->connection_info[poolBE].connected); + switch(pi->status) + { + case WAIT_FOR_CONNECT: + StrNCpy(pools[lines].status, "Wait for connection", POOLCONFIG_MAXPROCESSSTATUSLEN); + break; + case COMMAND_EXECUTE: + StrNCpy(pools[lines].status, "Execute command", POOLCONFIG_MAXPROCESSSTATUSLEN); + break; + case IDLE: + StrNCpy(pools[lines].status, "Idle", POOLCONFIG_MAXPROCESSSTATUSLEN); + break; + case IDLE_IN_TRANS: + StrNCpy(pools[lines].status, "Idle in transaction", POOLCONFIG_MAXPROCESSSTATUSLEN); + break; + default: + *(pools[lines].status) = '\0'; + } + lines++; } } @@ -1478,8 +1549,10 @@ void pools_reporting(POOL_CONNECTION * frontend, POOL_CONNECTION_POOL * backend) { short num_fields; - static char *field_names[] = {"pool_pid", "start_time", "pool_id", "backend_id", "database", "username", "create_time", - "majorversion", "minorversion", "pool_counter", "pool_backendpid", "pool_connected"}; + static char *field_names[] = {"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"}; int n; int *offsettbl; int nrows; @@ -1511,11 +1584,42 @@ get_processes(int *nrows) proc_id = process_info[child].pid; pi = pool_get_process_info(proc_id); + int remaining_time = pool_config->client_idle_limit; + if (pool_config->client_idle_limit) + { + int backend_id; + for (pool = 0; pool < pool_config->max_pool; pool++) + { + for (backend_id = 0; backend_id < NUM_BACKENDS; backend_id++) + { + poolBE = pool * MAX_NUM_BACKENDS + backend_id; + if (pi->connection_info[poolBE].client_idle_duration > 0) + remaining_time = pool_config->client_idle_limit - pi->connection_info[poolBE].client_idle_duration; + } + } + } + snprintf(processes[child].pool_pid, POOLCONFIG_MAXCOUNTLEN, "%d", proc_id); - strftime(processes[child].start_time, POOLCONFIG_MAXDATELEN, "%Y-%m-%d %H:%M:%S", localtime(&pi->start_time)); + if (pool_config->client_idle_limit) + { + char proc_start_time[POOLCONFIG_MAXDATELEN + 1]; + strftime(proc_start_time, sizeof(proc_start_time), + "%Y-%m-%d %H:%M:%S", localtime(&pi->start_time)); + snprintf(processes[child].process_start_time, sizeof(processes[child].process_start_time), + "%s (remaining: %d:%02d)", proc_start_time, + remaining_time / 60, + remaining_time % 60); + } + else + { + strftime(processes[child].process_start_time, sizeof(processes[child].process_start_time), + "%Y-%m-%d %H:%M:%S", localtime(&pi->start_time)); + } + snprintf(processes[child].client_connection_count, sizeof(processes[child].client_connection_count), + "%d", pi->client_connection_count); StrNCpy(processes[child].database, "", POOLCONFIG_MAXIDENTLEN); StrNCpy(processes[child].username, "", POOLCONFIG_MAXIDENTLEN); - StrNCpy(processes[child].create_time, "", POOLCONFIG_MAXDATELEN); + StrNCpy(processes[child].backend_connection_time, "", POOLCONFIG_MAXDATELEN); StrNCpy(processes[child].pool_counter, "", POOLCONFIG_MAXCOUNTLEN); for (pool = 0; pool < pool_config->max_pool; pool++) @@ -1525,10 +1629,27 @@ get_processes(int *nrows) { StrNCpy(processes[child].database, pi->connection_info[poolBE].database, POOLCONFIG_MAXIDENTLEN); StrNCpy(processes[child].username, pi->connection_info[poolBE].user, POOLCONFIG_MAXIDENTLEN); - strftime(processes[child].create_time, POOLCONFIG_MAXDATELEN, "%Y-%m-%d %H:%M:%S", localtime(&pi->connection_info[poolBE].create_time)); + strftime(processes[child].backend_connection_time, POOLCONFIG_MAXDATELEN, "%Y-%m-%d %H:%M:%S", localtime(&pi->connection_info[poolBE].create_time)); snprintf(processes[child].pool_counter, POOLCONFIG_MAXCOUNTLEN, "%d", pi->connection_info[poolBE].counter); } } + switch(pi->status) + { + case WAIT_FOR_CONNECT: + StrNCpy(processes[child].status, "Wait for connection", POOLCONFIG_MAXPROCESSSTATUSLEN); + break; + case COMMAND_EXECUTE: + StrNCpy(processes[child].status, "Execute command", POOLCONFIG_MAXPROCESSSTATUSLEN); + break; + case IDLE: + StrNCpy(processes[child].status, "Idle", POOLCONFIG_MAXPROCESSSTATUSLEN); + break; + case IDLE_IN_TRANS: + StrNCpy(processes[child].status, "Idle in transaction", POOLCONFIG_MAXPROCESSSTATUSLEN); + break; + default: + *(processes[child].status) = '\0'; + } } *nrows = child; @@ -1542,15 +1663,18 @@ get_processes(int *nrows) void processes_reporting(POOL_CONNECTION * frontend, POOL_CONNECTION_POOL * backend) { - static char *field_names[] = {"pool_pid", "start_time", "database", "username", "create_time", "pool_counter"}; + static char *field_names[] = {"pool_pid", "start_time", "client_connection_count", + "database", "username", "backend_connection_time", "pool_counter", "status"}; static int offsettbl[] = { offsetof(POOL_REPORT_PROCESSES, pool_pid), - offsetof(POOL_REPORT_PROCESSES, start_time), + offsetof(POOL_REPORT_PROCESSES, process_start_time), + offsetof(POOL_REPORT_PROCESSES, client_connection_count), offsetof(POOL_REPORT_PROCESSES, database), offsetof(POOL_REPORT_PROCESSES, username), - offsetof(POOL_REPORT_PROCESSES, create_time), - offsetof(POOL_REPORT_PROCESSES, pool_counter) + offsetof(POOL_REPORT_PROCESSES, backend_connection_time), + offsetof(POOL_REPORT_PROCESSES, pool_counter), + offsetof(POOL_REPORT_PROCESSES, status), }; int nrows; diff --git a/src/utils/ps_status.c b/src/utils/ps_status.c index 6d7d9ee..bedcfc6 100644 --- a/src/utils/ps_status.c +++ b/src/utils/ps_status.c @@ -399,10 +399,16 @@ pool_ps_idle_display(POOL_CONNECTION_POOL * backend) sp = MAIN_CONNECTION(backend)->sp; if (MAIN(backend)->tstate == 'T') + { snprintf(psbuf, sizeof(psbuf), "%s %s %s idle in transaction", sp->user, sp->database, remote_ps_data); + set_process_status(IDLE_IN_TRANS); + } else + { snprintf(psbuf, sizeof(psbuf), "%s %s %s idle", sp->user, sp->database, remote_ps_data); + set_process_status(IDLE); + } set_ps_display(psbuf, false); }