On Thu, Jan 13, 2005 at 10:33:50AM -0700, Ed L. wrote: > On Thursday January 13 2005 10:09, Michael Fuhr wrote: > > > > For idle transactions pg_stat_activity shows "<IDLE> in transaction" > > and the query_start column shows when the transaction became idle > > That will help, thanks. Unfortunately, that doesn't appear to work for many > of our pre-7.4 clusters, of which we have 60, but that will definitely help > as we migrate forward. Ah yes, I see in the Relase Notes that the query start time was added in 7.4. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx
