Re: Transaction start in pg_stat_activity

On Sat, 2006-11-18 at 21:44 -0500, Neil Conway wrote:

> Attached is a first revision of a patch that adds a column to
> pg_stat_activity containing the time at which the backend's current
> transaction began, or NULL if the backend is not inside a transaction.
> This is useful for finding long-running transactions, and AFAIK this
> information is not otherwise easily available from outside the backend's
> session.
>
> Naturally, this is for 8.3.

Great idea. Would it be appropriate to show the time the current
snapshot was taken also/instead?

--
  Simon Riggs
  EnterpriseDB   http://www.enterprisedb.com