Horton

Re: bug reapper: Empty query_id in pg_stat_activity

Greg Sabino Mullane <htamfids@gmail.com>

View thread
From: Greg Sabino Mullane <htamfids@gmail.com>
To: Srinath Reddy Sadipiralla <srinath2133@gmail.com>
Cc: "duomi.peng" <duomi.peng@qq.com>, pgsql-bugs <pgsql-bugs@lists.postgresql.org>
Date: 2025-08-28T12:42:32Z
Lists: pgsql-bugs 
On Thu, Aug 28, 2025 at 8:25 AM Srinath Reddy Sadipiralla <
srinath2133@gmail.com> wrote:

> The fix I tried is to retain the previous query_id (prev_st_query_id) and
> return it when st_query_id is still 0 but query_id computation is enabled,
> thoughts?
>

This just moves the race condition around a little - you can end up with a
query that does not agree with its query_id.


Cheers,
Greg

--
Crunchy Data - https://www.crunchydata.com
Enterprise Postgres Software Products & Tech Support