pgAdmin query tool stays frozen even after query is over

Question

I am running postgresql 9.6 in my windows 7 laptop. Nobody else connects to the database. I ran an insert SQL in Query Tool of Pgadmin4. The query got over after 20 minutes or so. The records got inserted & the state in pg_stat_activity went from active to idle which I checked by opening the other query tool window. But the original window in which the query was run continued to be frozen with message

"waiting for the query execution to complete"

How can I fix this problem. I did some research. Does it have something to do with TCP/IP connection getting broken as mentioned in below links

Link 1

and

Link 2 (under Connection to database dropped)

Answer 1

Restart pgadmin and try the query again.

as of 2018 pgadmin seems to handle connection timeouts really badly, so you will often need to restart the entire pgadmin appliction after a period of not using it, and then go through the process of expanding the tree again to get right down to the table you were working with.

It does make me wonder whether the authors of pgadmin actually eat their own dogfood, as it's quite painful to use day-to-day compared to say SQL Server's Management Studio.

Answer 2

Not exactly a solution but got a work around. The problem was that after query execution it was running the autovacuum and then even after it got over, pgadmin was staying frozen. I disabled autovacuum in the config file and it started working fine. Not sure if this will have any impact on performance or anything else. Will see.