Postgres Pro
Downloads
Home   >   mailing lists

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+wokJ96V5UuHhPStt+eMigkXsn7RJbMaiL-aK1K=S5aFQg66g@mail.gmail.com
Whole thread Raw
In response to Re: How to check if session is a hung thread/session  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: How to check if session is a hung thread/session
Re: How to check if session is a hung thread/session
List pgsql-admin
Tree view
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: "David G. Johnston"
Date:
Subject: Re: How to check if session is a hung thread/session
Next
From: Edwin UY
Date:
Subject: Re: How to check if session is a hung thread/session