Re: Add pg_stat_recovery system view

Michael Paquier <michael@paquier.xyz>

From: Michael Paquier <michael@paquier.xyz>

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

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

Date: 2026-03-06T05:28:20Z

Lists: pgsql-hackers

On Fri, Mar 06, 2026 at 02:19:01PM +0900, Shinya Kato wrote:
> 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).

Oops, indeed.  Will fix shortly.
--
Michael

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