Mike Goldner <[EMAIL PROTECTED]> writes:
> Is there any way to increase the debug logging or issue a query so that
> I could find the actual select statements that are idle?
Huh? "Idle in transaction" means there *isn't* any active SQL statement
--- those backends are waiting for the next client command. What you
seem to need is more visibility into the state of your client code,
which I'm afraid we can't help you with. Possibly you could get useful
help on a JBoss-related list.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
