Add wait events for recovery conflicts

Enterprise / PostgreSQL - Fujii Masao [postgresql.org] - 3 April 2020 03:15 EDT

This commit introduces new wait events RecoveryConflictSnapshot and RecoveryConflictTablespace. The former is reported while waiting for recovery conflict resolution on a vacuum cleanup. The latter is reported while waiting for recovery conflict resolution on dropping tablespace.

Also this commit changes the code so that the wait event Lock is reported while waiting in ResolveRecoveryConflictWithVirtualXIDs() for recovery conflict resolution on a lock. Basically the wait event Lock is reported during that wait, but previously was not reported only when that wait happened in ResolveRecoveryConflictWithVirtualXIDs().

Author: Masahiko Sawada

18808f8c89 Add wait events for recovery conflicts.
doc/src/sgml/monitoring.sgml | 10 +++++++++-
src/backend/postmaster/pgstat.c | 6 ++++++
src/backend/storage/ipc/standby.c | 16 ++++++++++++----
src/include/pgstat.h | 2 ++
4 files changed, 29 insertions(+), 5 deletions(-)

Upstream: git.postgresql.org


  • Share