PostgreSQL To Identify and Terminate Hang Query

ps -ef | grep postgres to list out all processes belong to postgres user.

Notice process id with "idle in transaction", this is the hanging query in PostgreSQL.

Issue following command to terminate the PostgreSQL process manually.

kill -9 {pid}