improvement proposition - Mailing list pgsql-general

From hubert depesz lubaczewski
Subject improvement proposition
Date
Msg-id 20071016132131.GA4438@depesz.com
Whole thread Raw
Responses Re: improvement proposition  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: improvement proposition  (Ron Johnson <ron.l.johnson@cox.net>)
List pgsql-general
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)

pgsql-general by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: Calculation of per Capita on-the-fly - problems with SQL syntax
Next
From: Bruce Momjian
Date:
Subject: Re: Architecture diagram!