[murkt]

Have you passed a string into Postgres and then hashed it into bigint with another function? If yes, what function did you use?

I assume that if you do it this way, then you see a string key in logs, views of current/locked queries, etc. Which should immensely help when debugging any kind of problems.