pg_stat_replication.*_lag sometimes shows NULL during active replication

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v7, Patch count: 2, First patch: +19−16, All patches: +68−51

Tags

Bugfix Monitoring Physical Replication

Created

2026-02-24 06:58:44

Last modified

2026-03-26 11:57:54 (2 weeks ago)

Latest email

2026-03-26 11:56:35 (2 weeks ago)

Status

PG19-Final (2026-03-01 – 2026-04-09): Committed

Target version

stable

Authors

Shinya Kato (shinyakato)

Reviewers

Fujii Masao (masaofujii)Become reviewer

Committer

Fujii Masao (masaofujii)

Links

Emails

pg_stat_replication.*_lag sometimes shows NULL during active replication: First at 2026-02-24 06:53:54 by Shinya Kato <shinya11.kato at gmail.com>
Latest at 2026-03-26 11:56:35 by Fujii Masao <masao.fujii at gmail.com>
Latest attachment (v7-0002-Avoid-sending-duplicate-WAL-locations-in-standby-.patch) at 2026-03-25 15:30:42 from Fujii Masao <masao.fujii at gmail.com>
    Attachment (v7-0002-Avoid-sending-duplicate-WAL-locations-in-standby-.patch) at 2026-03-25 15:30:42 from Fujii Masao <masao.fujii at gmail.com> (Patch: Yes)
    Attachment (v6-0001-Avoid-sending-duplicate-WAL-locations-in-standby-.patch) at 2026-03-23 15:31:10 from Fujii Masao <masao.fujii at gmail.com> (Patch: Yes)
    Attachment (v5-0001-Avoid-sending-duplicate-WAL-locations-in-standby-.patch) at 2026-03-19 17:13:25 from Fujii Masao <masao.fujii at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Avoid-sending-duplicate-WAL-locations-in-standby-.patch) at 2026-03-12 15:27:32 from Fujii Masao <masao.fujii at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Fix-spurious-NULL-lag-in-pg_stat_replication.patch) at 2026-03-11 02:38:23 from Shinya Kato <shinya11.kato at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Fix-spurious-NULL-lag-in-pg_stat_replication.patch) at 2026-03-06 07:12:48 from Shinya Kato <shinya11.kato at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Fix-pg_stat_replication.-_lag-showing-NULL-during.patch) at 2026-02-24 06:53:54 from Shinya Kato <shinya11.kato at gmail.com> (Patch: Yes)

History

When	Who	What
2026-03-26 11:57:54	Fujii Masao (masaofujii)	Closed in commitfest PG19-Final with status: Committed
2026-03-09 11:21:58	Fujii Masao (masaofujii)	Added masaofujii as committer
2026-03-09 11:21:55	Fujii Masao (masaofujii)	Added masaofujii as reviewer
2026-02-24 06:58:44	Shinya Kato (shinyakato)	Attached mail thread CAOzEurTzcUrEzrH97DD7+Yz=HGPU81kzWQonKZvqBwYhx2G9_A@mail.gmail.com
2026-02-24 06:58:44	Shinya Kato (shinyakato)	Created patch record