Re: Add pg_stat_recovery system view

Shinya Kato <shinya11.kato@gmail.com>

View thread View on postgr.es

From: Shinya Kato <shinya11.kato@gmail.com>

To: Michael Paquier <michael@paquier.xyz>

Cc: Xuneng Zhou <xunengzhou@gmail.com>, pgsql-hackers <pgsql-hackers@lists.postgresql.org>

Date: 2026-03-06T05:19:01Z

Lists: pgsql-hackers

Attachments

fix-swapped-timestamp-columns.diff (application/octet-stream) patch

Reading the committed patch, it appears that the values for
current_chunk_start_time and recovery_last_xact_time have been
swapped. Could you please look into this?

I have attached the patch (with redundant comments removed).

-- 
Best regards,
Shinya Kato
NTT OSS Center

Commits

Fix order of columns in pg_stat_recovery
- 2d4ead6f4bd0 19 (unreleased) landed
Add system view pg_stat_recovery
- 01d485b142e4 19 (unreleased) landed
Refactor code retrieving string for RecoveryPauseState
- 42a12856a6a0 19 (unreleased) landed
Move definition of XLogRecoveryCtlData to xlogrecovery.h
- 5f8124a0cf33 19 (unreleased) landed