If we ran same proc from psql and pgadmin we could able to run successfully and able to get response and no "Idle_in_transaction" state.[...]We are not sure from where we have to start troubleshooting.
pgsql-admin by date:
Соглашаюсь с условиями обработки персональных данных