doc: Add more details about pg_stat_get_xact_blocks_{fetched,hit}

Michael Paquier <michael@paquier.xyz>

Commit: e126d817c7af989c47366b0e344ee83d761f334a
Author: Michael Paquier <michael@paquier.xyz>
Date: 2023-04-04T22:59:43Z
Releases: 16.0
doc: Add more details about pg_stat_get_xact_blocks_{fetched,hit}

The explanation describing the dependency to system read() calls for
these two functions has been removed in ddfc2d9.  And after more
discussion about d69c404, we have concluded that adding more details
makes them easier to understand.

While on it, use the term "block read requests" (maybe found in cache)
rather than "buffers fetched" and "buffer hits".

Per discussion with Melanie Plageman, Kyotaro Horiguchi, Bertrand
Drouvot and myself.

Discussion: https://postgr.es/m/CAAKRu_ZmdiScT4q83OAbfmR5AH-L5zWya3SXjaxiJvhCob-e2A@mail.gmail.com
Backpatch-through: 11

Files

PathChange+/−
doc/src/sgml/monitoring.sgml modified +8 −4

Documentation touched

Discussion