[pgpool-committers: 6953] pgpool: Add statistics for INSERT/UPDATE/DELETE etc. SQL commands.
Tatsuo Ishii
ishii at sraoss.co.jp
Fri Aug 14 10:51:24 JST 2020
Add statistics for INSERT/UPDATE/DELETE etc. SQL commands.
We already allow to collect stats for SELECT, but it would be useful
to collect stats for other types of SQL commands. APIs to fetch stats
data is also added. No UI is added yet. Currently, any SQL commands
(besides SELECT/INSERT/UPDATE/DELETE) other than:
case(T_CheckPointStmt):
case(T_DeallocateStmt):
case(T_DiscardStmt):
case(T_ExecuteStmt):
case(T_ExplainStmt):
case(T_ListenStmt):
case(T_LoadStmt):
case(T_LockStmt):
case(T_NotifyStmt):
case(T_PrepareStmt):
case(T_TransactionStmt):
case(T_UnlistenStmt):
case(T_VacuumStmt):
case(T_VariableSetStmt):
case(T_VariableShowStmt):
are counted as DDL commands.
Discussion: https://www.pgpool.net/pipermail/pgpool-hackers/2020-July/003754.html
Branch
------
master
Details
-------
https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=9f74a2281f6f10b5160051c8291713b9f5ed5205
Modified Files
--------------
src/include/utils/statistics.h | 5 +++
src/utils/statistics.c | 72 ++++++++++++++++++++++++++++++++++++++++++
2 files changed, 77 insertions(+)
More information about the pgpool-committers
mailing list