[pgpool-committers: 8012] pgpool: Add new fields to pcp_proc_info, show pool_processes, show pool

[Masaya Kawamoto]

Add new fields to pcp_proc_info, show pool_processes, show pool_pools command.

The purpose of this commit is to get more information about the process stats
and how pgpool is working with "client_idle_limit" and "child_max_connections".

Start time:
I add “remaining” that is the remaining time beforl the process is restarted by
client_idle_limit.

Client connection count:
The connection count from clients to this pgpool process. Useful to know how
many times clients can connect to this pgpool process before
child_max_connections reaches.

Backend connection time:
I just rename create_time for clarity.

Client connection time:
The time when the client last connected. If the client uses its own connection
pooling, this helps to know when the connection was actually made from pgpool's
point of view.

Client idle duration:
The elapsed time (in seconds) since the client became in idle state.

Client disconnection time:
This is the last time the client disconnects. The use case is the same as above.

Status:
This is the process status. This shows 4 status: “Wait for connections”, “Idle”,
“Idle in transaction”, “Execute command”.

Branch
------
master

Details
-------
https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=45152975fdf8d57deaff07dc6c34117fa8eeb3db

Modified Files
--------------
doc.ja/src/sgml/ref/pcp_proc_info.sgml       | 101 +++---
doc.ja/src/sgml/ref/show_pool_pools.sgml     | 439 +++++++++++----------------
doc.ja/src/sgml/ref/show_pool_processes.sgml | 127 +++++---
doc/src/sgml/ref/pcp_proc_info.sgml          |  82 +++--
doc/src/sgml/ref/show_pool_pools.sgml        | 399 +++++++++---------------
doc/src/sgml/ref/show_pool_processes.sgml    |  96 +++---
src/context/pool_process_context.c           |   2 +
src/include/pcp/libpcp_ext.h                 |  30 +-
src/include/pool.h                           |   2 +-
src/main/pgpool_main.c                       |   8 +
src/protocol/child.c                         |  17 ++
src/protocol/pool_connection_pool.c          |   1 +
src/protocol/pool_process_query.c            |   4 +
src/tools/pcp/pcp_frontend_client.c          |  23 +-
src/utils/pool_health_check_stats.c          |  11 +-
src/utils/pool_process_reporting.c           | 154 +++++++++-
src/utils/ps_status.c                        |   6 +
17 files changed, 789 insertions(+), 713 deletions(-)