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
> Naturally, this is for 8.3.
Great idea. Would it be appropriate to show the time the current
snapshot was taken also/instead?
In response to
pgsql-hackers by date
|Next:||From: arkadiusz.staron||Date: 2006-11-20 10:19:34|
|Subject: Tsearch + polish ispell + polish locale|
|Previous:||From: Markus Schiltknecht||Date: 2006-11-20 09:43:33|
|Subject: Re: [HACKERS] Replication documentation addition|
pgsql-patches by date
|Next:||From: Tom Lane||Date: 2006-11-20 15:58:02|
|Subject: Re: Transaction start in pg_stat_activity |
|Previous:||From: Neil Conway||Date: 2006-11-19 22:26:51|
|Subject: Re: add external pl language section, clean up some links|