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) ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
