From 644c0898ba7d8629f7c5f3652de6f42063883224 Mon Sep 17 00:00:00 2001 From: Tatsuo Ishii Date: Mon, 17 Aug 2020 09:09:13 +0900 Subject: [PATCH] Doc: add description to "show pool_backend_stats". Mention that failed commands are also counted. --- doc.ja/src/sgml/ref/show_pool_backend_stats.sgml | 1 + doc/src/sgml/ref/show_pool_backend_stats.sgml | 5 +++-- 2 files changed, 4 insertions(+), 2 deletions(-) diff --git a/doc.ja/src/sgml/ref/show_pool_backend_stats.sgml b/doc.ja/src/sgml/ref/show_pool_backend_stats.sgml index 766b41f18..8e260aa47 100644 --- a/doc.ja/src/sgml/ref/show_pool_backend_stats.sgml +++ b/doc.ja/src/sgml/ref/show_pool_backend_stats.sgml @@ -38,6 +38,7 @@ select_cnt、insert_cnt、update_cnt、delete_cnt、ddl_cnt、other_cntはPgpool-IIが起動してからのSQLコマンド: SELECT、INSERT、UPDATE、DELETE、DDL、そして他のコマンドの数です。 + 失敗したコマンド(たとえば存在しないテーブルからのSELECT)は数えられます。 ロールバックされたコマンドも数えられます。 今の所SELECT/WITH/INSERT/UPDATE/DELETE/CHECKPOINT/DEALLOCATE/DISCARD/EXECUTE/EXPLAIN/LISTEN/LOAD/LOCK/NOTIFY/PREPARE/SET/SHOW/トランザクションコマンド/UNLISTEN以外のコマンドがDDLであると見なされます。 diff --git a/doc/src/sgml/ref/show_pool_backend_stats.sgml b/doc/src/sgml/ref/show_pool_backend_stats.sgml index 059762418..f6c760247 100644 --- a/doc/src/sgml/ref/show_pool_backend_stats.sgml +++ b/doc/src/sgml/ref/show_pool_backend_stats.sgml @@ -43,8 +43,9 @@ select_cnt, insert_cnt, update_cnt, delete_cnt, ddl_cnt, other_cnt are the numbers of SQL command: SELECT, INSERT, UPDATE, DELETE, DDL and others issued since Pgpool-II - started. Commands rolled back are also counted. Currently, other - than + started. Failed commands (for example SELECT from non-existing + table) are counted. Commands rolled back are also + counted. Currently, other than SELECT/WITH/INSERT/UPDATE/DELETE/CHECKPOINT/DEALLOCATE/DISCARD/EXECUTE/ EXPLAIN/LISTEN/LOAD/LOCK/NOTIFY/PREPARE/SET/SHOW/Transaction commands/UNLISTEN are considered as DDL. -- 2.39.5