Re: Fix pg_stat_get_backend_wait_event() for aux processes

Sami Imseih <samimseih@gmail.com>

From: Sami Imseih <samimseih@gmail.com>
To: Heikki Linnakangas <hlinnaka@iki.fi>
Cc: Robert Haas <robertmhaas@gmail.com>, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
Date: 2026-02-04T23:48:57Z
Lists: pgsql-hackers
>
> There is also a discussion [0] about wait event/activity field
> inconsistency
> with pg_stat_activity with a repro in [1].


The repro I was referring to in [1] is actually
https://www.postgresql.org/message-id/ab1c0a7d-e789-5ef5-1180-42708ac6fe2d%40postgrespro.ru


I linked a different message earlier.

--
Sami

Commits

  1. Fix pg_stat_get_backend_wait_event() for aux processes

  2. doc: Mention possible ephemeral discrepancies in pg_stat_activity

  3. Show more processes in pg_stat_activity.