Re: How to check if session is a hung thread/session

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 PM Edwin UY <edwin(dot)uy(at)gmail(dot)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 PM David G. Johnston <
> david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
>
>>
>>
>> On Saturday, November 9, 2024, Edwin UY <edwin(dot)uy(at)gmail(dot)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 “hung process” is a process whose state is not
>> changing.
>>
>> David J.
>>
>>
>