From: Tom Lane <tgl@sss.pgh.pa.us>
To: Edwin UY <edwin.uy@gmail.com>
cc: "David G. Johnston" <david.g.johnston@gmail.com>,
        "pgsql-admin@lists.postgresql.org" <pgsql-admin@lists.postgresql.org>
Subject: Re: How to check if session is a hung thread/session
In-reply-to: 
 <CA+wokJ96V5UuHhPStt+eMigkXsn7RJbMaiL-aK1K=S5aFQg66g@mail.gmail.com>
References: 
 <CA+wokJ_QejkPWUym3njMQCkeFQ_kRcRdah5S2eseocwsHLc-4w@mail.gmail.com>
 <CAKFQuwZunKoiM4AO0BBAbRc73_unJoMJA5WmPFWYnUWj+s0Q_Q@mail.gmail.com>
 <CA+wokJ96V5UuHhPStt+eMigkXsn7RJbMaiL-aK1K=S5aFQg66g@mail.gmail.com>
Comments: In-reply-to Edwin UY <edwin.uy@gmail.com>
	message dated "Mon, 11 Nov 2024 17:08:55 +1300"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <216309.1731300338.1@sss.pgh.pa.us>
Date: Sun, 10 Nov 2024 23:45:38 -0500
Message-ID: <216310.1731300338@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/216310.1731300338%40sss.pgh.pa.us>
Precedence: bulk

Edwin UY <edwin.uy@gmail.com> writes:
> 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.

Your pg_stat_activity output shows the backend is idle, meaning it's
waiting for a client command.  While the session has been around for
days, we can see the last client command was about 47 minutes ago,
from your "now() - pg_stat_activity.query_start AS duration" column.
I see no reason to think there is anything interesting here at all,
except for a client that is sitting doing nothing for long periods.

			regards, tom lane