Which Java thread is responsible for a PostgreSQL database process?

Question

Given a JVM connecting to a PostgreSQL database (on Linux), is there a way to find out which thread in Java is responsible for a process in the database?

NB: I'm debugging a resource-leak bug, which shows up as some idle-in-transaction processes in the database. It would be useful to match these up with the thread responsible, as the thread name will narrow down the search.

Answer 1

You could set application_name (with the SET statement) to something that you can match up with the Java thread name.