Thread: pgsql: Track statistics for spilling of changes from ReorderBuffer.
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(-)