Edwin UY <edwin.uy@xxxxxxxxx> 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
