MIME-Version: 1.0
In-Reply-To: 
 <CA+wokJ_QejkPWUym3njMQCkeFQ_kRcRdah5S2eseocwsHLc-4w@mail.gmail.com>
References: 
 <CA+wokJ_QejkPWUym3njMQCkeFQ_kRcRdah5S2eseocwsHLc-4w@mail.gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Sun, 10 Nov 2024 20:44:15 -0700
Message-ID: 
 <CAKFQuwZunKoiM4AO0BBAbRc73_unJoMJA5WmPFWYnUWj+s0Q_Q@mail.gmail.com>
Subject: Re: How to check if session is a hung thread/session
To: Edwin UY <edwin.uy@gmail.com>
Cc: "pgsql-admin@lists.postgresql.org" <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000370ae006269aea2f"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKFQuwZunKoiM4AO0BBAbRc73_unJoMJA5WmPFWYnUWj%2Bs0Q_Q%40mail.gmail.com>
Precedence: bulk

--000000000000370ae006269aea2f
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Saturday, November 9, 2024, Edwin UY <edwin.uy@gmail.com> wrote:

>
> The state_change date is getting updated though, I don't know if this is
> proof that it is not a hung thread.
>

The definition of a =E2=80=9Chung process=E2=80=9D is a process whose state=
 is not changing.

David J.

--000000000000370ae006269aea2f
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<br><br>On Saturday, November 9, 2024, Edwin UY &lt;<a href=3D"mailto:edwin=
.uy@gmail.com">edwin.uy@gmail.com</a>&gt; wrote:<br><blockquote class=3D"gm=
ail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-le=
ft:1ex"><div dir=3D"ltr"><div><br></div><div><span style=3D"font-family:mon=
ospace">The state_change date is getting updated though, I don&#39;t know i=
f this is proof that it is not a hung thread.</span></div><div></div></div>=
</blockquote><div><br></div><div>The definition of a =E2=80=9Chung process=
=E2=80=9D is a process whose state is not changing.</div><div><br></div><di=
v>David J.</div><div>=C2=A0</div>

--000000000000370ae006269aea2f--