Re: How to check if session is a hung thread/session - Mailing list pgsql-admin

From Edwin UY
Subject Re: How to check if session is a hung thread/session
Date
Msg-id CA+wokJ9RhEvaWaP1hwsCp_Qk9hsBGUw9bc22oFJ7qKFC03KiSA@mail.gmail.com
Whole thread Raw
In response to Re: How to check if session is a hung thread/session  (Edwin UY <edwin.uy@gmail.com>)
List pgsql-admin
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.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 PM 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 “hung process” is a process whose state is not changing.

David J.
 

pgsql-admin by date:

Previous
From: Edwin UY
Date:
Subject: Re: How to check if session is a hung thread/session
Next
From: Tom Lane
Date:
Subject: Re: How to check if session is a hung thread/session