doc: Mention possible ephemeral discrepancies in pg_stat_activity

Michael Paquier <michael@paquier.xyz>

Commit: f056f75dafd0025d26efaca026a87f14c079a130
Author: Michael Paquier <michael@paquier.xyz>
Date: 2025-03-26T23:07:54Z
Releases: 18.0
doc: Mention possible ephemeral discrepancies in pg_stat_activity

Ephemeral inconsistencies across multiple attributes of pg_stat_activity
can exist as the system is designed to be efficient with a low overhead.
This question is raised by users from time to time based on the data
read in the view, so let's add a note in the docs about this
possibility.

Author: Alex Friedman <alexf01@gmail.com>
Reviewed-by: Sami Imseih <samimseih@gmail.com>
Discussion: https://postgr.es/m/8a275154-a654-44b0-ab37-197802f04c7b@gmail.com

Files

PathChange+/−
doc/src/sgml/monitoring.sgml modified +3 −1

Documentation touched

Discussion