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 like > > IDLE: last query: SELECT * FROM mytable; I think the clearest option would be leave the query column empty and add a new column last_query. But this suggestion may still do its job in clarifying that the query is not running.
