Is there any notion of pg_stat_get_backend_last_activity()? I've got
a rogue process someplace and I'm having a devil of a time tracking
down which process is not committing its transaction and letting the
rest of the world continue to access the tables. Based off of the
last query performed, I'd have some idea as to where to hunt and could
figure this out, but as best as I can tell, the only option available
is to setup a query log and cruize through there with grep/less. Am I
missing more programatic and obvious? -sc
PS, the archives didn't turn up anything for 'idle in transaction' ???
--
Sean Chittenden