-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 10/16/07 08:21, hubert depesz lubaczewski wrote: > 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". Transaction analysis is the way to go here. It requires a serious code review, though. > is adding something like this possible? - -- Ron Johnson, Jr. Jefferson LA USA Give a man a fish, and he eats for a day. Hit him with a fish, and he goes away for good! -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHFRUuS9HxQb37XmcRAkvuAKCrVQZK1wEAxLquo8ZHHCTLyOmEUgCfYc5o 55pO2d/P4nEp8a8l3GRl0bk= =Kkkd -----END PGP SIGNATURE----- ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
