| From: | Neil Conway <neilc(at)samurai(dot)com> |
|---|---|
| To: | pgsql-patches <pgsql-patches(at)postgresql(dot)org> |
| Subject: | Transaction start in pg_stat_activity |
| Date: | 2006-11-19 02:44:55 |
| Message-ID: | 1163904295.23622.16.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
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.
-Neil
| Attachment | Content-Type | Size |
|---|---|---|
| txn_start_time-1.patch | text/x-patch | 17.3 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-11-19 06:46:19 | Re: Nasty VACUUM/bgwriter/segmentation bug |
| Previous Message | Mike Rylander | 2006-11-19 01:37:44 | Re: Ontology on PostgreSQL - is there something? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Neil Conway | 2006-11-19 22:26:51 | Re: add external pl language section, clean up some links |
| Previous Message | Simon Riggs | 2006-11-18 12:58:51 | Re: Proposed patch for xact-vs-multixact bugs |