Content-Type: multipart/mixed; boundary="------------ZXuPr07AJiSqBFbLSyDjPiQo"
Message-ID: <8a275154-a654-44b0-ab37-197802f04c7b@gmail.com>
Date: Wed, 26 Feb 2025 20:12:44 +0200
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Content-Language: en-US
To: pgsql-hackers@lists.postgresql.org
From: Alex Friedman <alexf01@gmail.com>
Subject: Doc: clarify possibility of ephemeral discrepancies between state and
 wait_event in pg_stat_activity
Archived-At: 
 <https://www.postgresql.org/message-id/8a275154-a654-44b0-ab37-197802f04c7b%40gmail.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------ZXuPr07AJiSqBFbLSyDjPiQo
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

Hi,

This small doc change patch is following up on a past discussion about 
discrepancies between state and wait_event in pg_stat_activity:

https://www.postgresql.org/message-id/flat/ab1c0a7d-e789-5ef5-1180-42708ac6fe2d%40postgrespro.ru


As this kind of question is raised by PG users from time to time, the goal is to 
clarify that such discrepancies are to be expected. The attached patch reuses 
Robert Haas's eloquent wording from his response in the above thread. I've tried 
to keep it short and to the point, but it can be made more verbose if needed.


Best regards,

Alex Friedman
--------------ZXuPr07AJiSqBFbLSyDjPiQo
Content-Type: text/plain; charset=UTF-8;
 name="v1-0001-Clarify-possibility-of-ephemeral-discrepancies-be.patch"
Content-Disposition: attachment;
 filename*0="v1-0001-Clarify-possibility-of-ephemeral-discrepancies-be.pa";
 filename*1="tch"
Content-Transfer-Encoding: base64

RnJvbSAzY2FiNjIwZDY3ZDIwMGZmNGNjYjE4NzBmNjNjYmY3NWE1MGQwZGY2IE1vbiBTZXAg
MTcgMDA6MDA6MDAgMjAwMQpGcm9tOiBBbGV4IEZyaWVkbWFuIDxhbGV4ZjAxQGdtYWlsLmNv
bT4KRGF0ZTogV2VkLCAyNiBGZWIgMjAyNSAxOTo1OTo1OSArMDIwMApTdWJqZWN0OiBbUEFU
Q0ggdjFdIENsYXJpZnkgcG9zc2liaWxpdHkgb2YgZXBoZW1lcmFsIGRpc2NyZXBhbmNpZXMg
YmV0d2Vlbgogc3RhdGUgYW5kIHdhaXRfZXZlbnQgaW4gcGdfc3RhdF9hY3Rpdml0eS4KCi0t
LQogZG9jL3NyYy9zZ21sL21vbml0b3Jpbmcuc2dtbCB8IDQgKysrLQogMSBmaWxlIGNoYW5n
ZWQsIDMgaW5zZXJ0aW9ucygrKSwgMSBkZWxldGlvbigtKQoKZGlmZiAtLWdpdCBhL2RvYy9z
cmMvc2dtbC9tb25pdG9yaW5nLnNnbWwgYi9kb2Mvc3JjL3NnbWwvbW9uaXRvcmluZy5zZ21s
CmluZGV4IDkxNzhmMWQzNGVmLi41N2ZjZDhhYjUyYiAxMDA2NDQKLS0tIGEvZG9jL3NyYy9z
Z21sL21vbml0b3Jpbmcuc2dtbAorKysgYi9kb2Mvc3JjL3NnbWwvbW9uaXRvcmluZy5zZ21s
CkBAIC0xMDE2LDcgKzEwMTYsOSBAQCBwb3N0Z3JlcyAgIDI3MDkzICAwLjAgIDAuMCAgMzAw
OTYgIDI3NTIgPyAgICAgICAgU3MgICAxMTozNCAgIDA6MDAgcG9zdGdyZXM6IHNlcgogICAg
IGl0IG1heSBvciBtYXkgbm90IGJlIDxsaXRlcmFsPndhaXRpbmc8L2xpdGVyYWw+IG9uIHNv
bWUgZXZlbnQuICBJZiB0aGUgc3RhdGUKICAgICBpcyA8bGl0ZXJhbD5hY3RpdmU8L2xpdGVy
YWw+IGFuZCA8c3RydWN0ZmllbGQ+d2FpdF9ldmVudDwvc3RydWN0ZmllbGQ+IGlzIG5vbi1u
dWxsLCBpdAogICAgIG1lYW5zIHRoYXQgYSBxdWVyeSBpcyBiZWluZyBleGVjdXRlZCwgYnV0
IGlzIGJlaW5nIGJsb2NrZWQgc29tZXdoZXJlCi0gICAgaW4gdGhlIHN5c3RlbS4KKyAgICBp
biB0aGUgc3lzdGVtLiBUbyBrZWVwIHRoZSByZXBvcnRpbmcgbG93LW92ZXJoZWFkLCB0aGUg
c3lzdGVtIHVzZXMgdmVyeSBsaWdodHdlaWdodAorICAgIHN5bmNocm9uaXphdGlvbi4gQXMg
YSByZXN1bHQsIGVwaGVtZXJhbCBkaXNjcmVwYW5jaWVzIGJldHdlZW4gPHN0cnVjdGZpZWxk
PndhaXRfZXZlbnQ8L3N0cnVjdGZpZWxkPgorICAgIGFuZCA8c3RydWN0ZmllbGQ+c3RhdGU8
L3N0cnVjdGZpZWxkPiBhcmUgcG9zc2libGUgYnkgbmF0dXJlLgogICAgPC9wYXJhPgogICA8
L25vdGU+CiAKLS0gCjIuNDEuMAoK

--------------ZXuPr07AJiSqBFbLSyDjPiQo--