Track statistics for spilling of changes from ReorderBuffer.
This adds the statistics about transactions spilled to disk from
ReorderBuffer. Users can query the pg_stat_replication_slots view to check
these stats and call pg_stat_reset_replication_slot to reset the stats of
a particular slot. Users can pass NULL in pg_stat_reset_replication_slot
to reset stats of all the slots.
This commit extends the statistics collector to track this information
about slots.
Author: Sawada Masahiko and Amit Kapila
Reviewed-by: Amit Kapila and Dilip Kumar
Discussion: https://postgr.es/m/CA+fd4k5_pPAYRTDrO2PbtTOe0eHQpBvuqmCr8ic39uTNmR49Eg@mail.gmail.com
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/98681675002d852d926a49d7bc4d4b4856b2fc4a
Modified Files
--------------
doc/src/sgml/monitoring.sgml | 112 +++++++++
src/backend/catalog/system_views.sql | 10 +
src/backend/postmaster/pgstat.c | 320 ++++++++++++++++++++++++
src/backend/replication/logical/decode.c | 9 +
src/backend/replication/logical/logical.c | 29 +++
src/backend/replication/logical/reorderbuffer.c | 22 ++
src/backend/replication/slot.c | 25 +-
src/backend/utils/adt/pgstatfuncs.c | 80 ++++++
src/include/catalog/catversion.h | 2 +-
src/include/catalog/pg_proc.dat | 12 +
src/include/pgstat.h | 52 +++-
src/include/replication/logical.h | 1 +
src/include/replication/reorderbuffer.h | 24 +-
src/include/replication/slot.h | 1 +
src/test/regress/expected/rules.out | 6 +
src/tools/pgindent/typedefs.list | 3 +
16 files changed, 700 insertions(+), 8 deletions(-)
