Re: Doc: clarify possibility of ephemeral discrepancies between state and wait_event in pg_stat_activity

Alex Friedman <alexf01@gmail.com>

From: Alex Friedman <alexf01@gmail.com>
To: Sami Imseih <samimseih@gmail.com>
Cc: pgsql-hackers@lists.postgresql.org
Date: 2025-03-02T10:42:17Z
Lists: pgsql-hackers

Attachments

> discrepancy will look like. What about we do something much more
> simplified, such
> as the below:
> 
> """
> To keep the reporting overhead low, the system does not attempt to synchronize
> activity data for a backend. As a result, ephemeral discrepancies may
> exist between
> the view’s columns.
> """

Yes, I believe it makes sense to make it more generic. Attached v3 with a slight 
tweak:

+    in the system. To keep the reporting overhead low, the system does not 
attempt to
+    synchronize different aspects of activity data for a backend. As a result, 
ephemeral
+    discrepancies may exist between the view's columns.


Best regards,

Alex Friedman

Commits

  1. doc: Mention possible ephemeral discrepancies in pg_stat_activity