pgsql: Track statistics for spilling of changes from ReorderBuffer.

From: Amit Kapila <akapila(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Track statistics for spilling of changes from ReorderBuffer.
Date: 2020-10-08 03:47:19
Message-ID: E1kQMtj-0005dQ-1I@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Michael Paquier 2020-10-08 04:40:21 pgsql: Improve set of candidate multipliers for perfect hash function g
Previous Message Fujii Masao 2020-10-08 03:43:17 Re: pgsql: postgres_fdw: reestablish new connection if cached one is detect