Re: vacuum vs open transactions

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
> (i.e., when the last statement completed).  So if long-lived idle
> transactions are the problem, then at least you can find out how
> long they've been 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.

Ed