MIME-Version: 1.0
References: 
 <CA+wokJ_QejkPWUym3njMQCkeFQ_kRcRdah5S2eseocwsHLc-4w@mail.gmail.com>
 <CAKFQuwZunKoiM4AO0BBAbRc73_unJoMJA5WmPFWYnUWj+s0Q_Q@mail.gmail.com>
In-Reply-To: 
 <CAKFQuwZunKoiM4AO0BBAbRc73_unJoMJA5WmPFWYnUWj+s0Q_Q@mail.gmail.com>
From: Edwin UY <edwin.uy@gmail.com>
Date: Mon, 11 Nov 2024 17:08:55 +1300
Message-ID: 
 <CA+wokJ96V5UuHhPStt+eMigkXsn7RJbMaiL-aK1K=S5aFQg66g@mail.gmail.com>
Subject: Re: How to check if session is a hung thread/session
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: "pgsql-admin@lists.postgresql.org" <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000008adc3f06269b4414"
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2BwokJ96V5UuHhPStt%2BeMigkXsn7RJbMaiL-aK1K%3DS5aFQg66g%40mail.gmail.com>
Precedence: bulk

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

Hi David,

Thanks for the clarification.
I thought it could be the backend has sent something back to the client but
it never received it and it just kept on doing the same at some intervals.


On Mon, Nov 11, 2024 at 4:44=E2=80=AFPM David G. Johnston <
david.g.johnston@gmail.com> wrote:

>
>
> 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 sta=
te is not
> changing.
>
> David J.
>
>

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

<div dir=3D"ltr"><div>Hi David,</div><div><br></div><div>Thanks for the cla=
rification.=C2=A0</div><div>I thought it could be the backend has sent some=
thing back to the client but it never received it and it just kept on doing=
 the same at some intervals.</div><div><br></div></div><br><div class=3D"gm=
ail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Mon, Nov 11, 2024 at 4:=
44=E2=80=AFPM David G. Johnston &lt;<a href=3D"mailto:david.g.johnston@gmai=
l.com">david.g.johnston@gmail.com</a>&gt; wrote:<br></div><blockquote class=
=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rg=
b(204,204,204);padding-left:1ex"><br><br>On Saturday, November 9, 2024, Edw=
in UY &lt;<a href=3D"mailto:edwin.uy@gmail.com" target=3D"_blank">edwin.uy@=
gmail.com</a>&gt; wrote:<br><blockquote class=3D"gmail_quote" style=3D"marg=
in:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1e=
x"><div dir=3D"ltr"><div><br></div><div><span style=3D"font-family:monospac=
e">The state_change date is getting updated though, I don&#39;t know if thi=
s is proof that it is not a hung thread.</span></div><div></div></div></blo=
ckquote><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><div>Davi=
d J.</div><div>=C2=A0</div>
</blockquote></div>

--0000000000008adc3f06269b4414--