Hi, I can not be sure if it is not the case. But we are usin this system on a number of servers and it happen only by one. Can I with a pg_locks help detect the query that is running?
No the pg_locks detect only which process handle a lock on a database object. With pg_stat_activity you see the queries running.
Also the command
ps -eafwww | grep post
show you the connection and his state, I bet you have some connection "IDLE in TRANSACTION"
Regards Gaeatano Mendola
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend