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.
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2006-11-19 06:46:19|
|Subject: Re: Nasty VACUUM/bgwriter/segmentation bug |
|Previous:||From: Mike Rylander||Date: 2006-11-19 01:37:44|
|Subject: Re: Ontology on PostgreSQL - is there something?|
pgsql-patches by date
|Next:||From: Neil Conway||Date: 2006-11-19 22:26:51|
|Subject: Re: add external pl language section, clean up some links|
|Previous:||From: Simon Riggs||Date: 2006-11-18 12:58:51|
|Subject: Re: Proposed patch for xact-vs-multixact bugs|