improvement proposition

hi,
would it be possible for someone to add "last query" for
pg_stat_activity view?

there is a lot of cases that we have "idle in transaction" sitting for
long time, and since we dont log all queries it is next to impossible to
tell where in app code the problem lies.

it would be very useful to get something like "previous query".

is adding something like this possible?

depesz

--
quicksil1er: "postgres is excellent, but like any DB it requires a
highly paid DBA.  here's my CV!" :)
http://www.depesz.com/ - blog dla ciebie (i moje CV)