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

Поиск
Список
Период
Сортировка
От Edwin UY
Тема Re: How to check if session is a hung thread/session
Дата
Msg-id CA+wokJ9RhEvaWaP1hwsCp_Qk9hsBGUw9bc22oFJ7qKFC03KiSA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How to check if session is a hung thread/session  (Edwin UY <edwin.uy@gmail.com>)
Список 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 по дате отправления: