Oh, I see. So the ROLLBACK command was executed! So I suppose the client was
waiting just for the ACK and the connection has been left open.
> I think this is a super common confusion among users. Maybe we should
> consider making it clearer that no query is currently being executed.
> Something
On Thu, 27 Jun 2024 at 17:21, Tom Lane wrote:
> (We used to show "" in the query column in this state, but that
> was deemed less helpful than the current behavior.)
I think this is a super common confusion among users. Maybe we should
consider making it clearer that no query is currently being e
Simone Giusso writes:
> I have a question regarding postgresql waiting for the client. I queried
> the pg_stat_activity because I noticed a connection that had not been
> released for days!!! I saw that the wait_event was ClientRead and the query
> was ROLLBACK. What the server is waiting for from
I have a question regarding postgresql waiting for the client. I queried
the pg_stat_activity because I noticed a connection that had not been
released for days!!! I saw that the wait_event was ClientRead and the query
was ROLLBACK. What the server is waiting for from the client? It is a
simple ROL
