MIME-Version: 1.0
References: 
 <CA+wokJ_QejkPWUym3njMQCkeFQ_kRcRdah5S2eseocwsHLc-4w@mail.gmail.com>
 <CAKFQuwZunKoiM4AO0BBAbRc73_unJoMJA5WmPFWYnUWj+s0Q_Q@mail.gmail.com>
 <CA+wokJ96V5UuHhPStt+eMigkXsn7RJbMaiL-aK1K=S5aFQg66g@mail.gmail.com>
In-Reply-To: 
 <CA+wokJ96V5UuHhPStt+eMigkXsn7RJbMaiL-aK1K=S5aFQg66g@mail.gmail.com>
From: Edwin UY <edwin.uy@gmail.com>
Date: Mon, 11 Nov 2024 17:13:17 +1300
Message-ID: 
 <CA+wokJ9RhEvaWaP1hwsCp_Qk9hsBGUw9bc22oFJ7qKFC03KiSA@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="00000000000020bd8006269b5410"
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2BwokJ9RhEvaWaP1hwsCp_Qk9hsBGUw9bc22oFJ7qKFC03KiSA%40mail.gmail.com>
Precedence: bulk

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

Need to Google how to trace a RDS session then :( and see what's the SQL
that's getting run, the clue may be something in there

On Mon, Nov 11, 2024 at 5:08=E2=80=AFPM Edwin UY <edwin.uy@gmail.com> wrote=
:

> 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 i=
s
>>> proof that it is not a hung thread.
>>>
>>
>> The definition of a =E2=80=9Chung process=E2=80=9D is a process whose st=
ate is not
>> changing.
>>
>> David J.
>>
>>
>

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

<div dir=3D"ltr"><div dir=3D"ltr">Need to Google how to trace a RDS session=
 then :( and see what&#39;s the SQL that&#39;s getting run, the clue may be=
 something in there<br></div><br><div class=3D"gmail_quote"><div dir=3D"ltr=
" class=3D"gmail_attr">On Mon, Nov 11, 2024 at 5:08=E2=80=AFPM Edwin UY &lt=
;<a href=3D"mailto:edwin.uy@gmail.com">edwin.uy@gmail.com</a>&gt; wrote:<br=
></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;=
border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><=
div>Hi David,</div><div><br></div><div>Thanks for the clarification.=C2=A0<=
/div><div>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.</div><div><br></div></div><br><div class=3D"gmail_quote"><div di=
r=3D"ltr" class=3D"gmail_attr">On Mon, Nov 11, 2024 at 4:44=E2=80=AFPM Davi=
d G. Johnston &lt;<a href=3D"mailto:david.g.johnston@gmail.com" target=3D"_=
blank">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>
</blockquote></div></div>

--00000000000020bd8006269b5410--