| From: | Edwin UY <edwin(dot)uy(at)gmail(dot)com> |
|---|---|
| To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
| Cc: | "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: How to check if session is a hung thread/session |
| Date: | 2024-11-11 04:08:55 |
| Message-ID: | CA+wokJ96V5UuHhPStt+eMigkXsn7RJbMaiL-aK1K=S5aFQg66g@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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.
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Edwin UY | 2024-11-11 04:13:17 | Re: How to check if session is a hung thread/session |
| Previous Message | David G. Johnston | 2024-11-11 03:44:15 | Re: How to check if session is a hung thread/session |