[pgpool-committers: 2349] pgpool: First cut of the implementation of SELECT count stats.

Tatsuo Ishii ishii at postgresql.org
Thu Dec 11 09:49:13 JST 2014


First cut of the implementation of SELECT count stats.

The SELECT counter is added to "show pool_nodes". Here is an example:
show pool_nodes;
 node_id | hostname | port  | status | lb_weight |  role   | select_cnt
---------+----------+-------+--------+-----------+---------+------------
 0       | /tmp     | 11002 | 2      | 0.500000  | primary | 9231
 1       | /tmp     | 11003 | 2      | 0.500000  | standby | 9469
(2 rows)

For now, the counter is in shared memory are and resets upon starting
up and there's no functionality without start/stop of
pgpool-II. Probably new pcp commands is necessary to reset the counter
without restarting.

Branch
------
master

Details
-------
http://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=900e00c986795fa0392ae3259eb16b1f85b4a757

Modified Files
--------------
doc/pgpool-en.html                 |   13 ++---
doc/pgpool-ja.html                 |   14 +++---
src/Makefile.am                    |    3 +-
src/Makefile.in                    |    8 ++-
src/context/pool_query_context.c   |    8 ++-
src/include/pcp/libpcp_ext.h       |    1 +
src/include/pool.h                 |    7 +++
src/main/pgpool_main.c             |    4 ++
src/utils/pool_process_reporting.c |   13 ++++-
src/utils/statistics.c             |   96 ++++++++++++++++++++++++++++++++++++
10 files changed, 149 insertions(+), 18 deletions(-)



More information about the pgpool-committers mailing list