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/