From 886a02d1cb19fe25859bd3c2d1f6a64b04cdc710 Mon Sep 17 00:00:00 2001
From: Neil Conway <neilc@samurai.com>
Date: Wed, 6 Dec 2006 18:06:48 +0000
Subject: Add a txn_start column to pg_stat_activity. This makes it easier to
 identify long-running transactions. Since we already need to record the
 transaction-start time (e.g. for now()), we don't need any additional system
 calls to report this information.

Catversion bumped, initdb required.
---
 src/backend/access/transam/xact.c | 5 ++++-
 1 file changed, 4 insertions(+), 1 deletion(-)

(limited to 'src/backend/access/transam/xact.c')

diff --git a/src/backend/access/transam/xact.c b/src/backend/access/transam/xact.c
index 673a34ad034..b0b8970380e 100644
--- a/src/backend/access/transam/xact.c
+++ b/src/backend/access/transam/xact.c
@@ -10,7 +10,7 @@
  *
  *
  * IDENTIFICATION
- *	  $PostgreSQL: pgsql/src/backend/access/transam/xact.c,v 1.229 2006/11/23 01:14:59 tgl Exp $
+ *	  $PostgreSQL: pgsql/src/backend/access/transam/xact.c,v 1.230 2006/12/06 18:06:47 neilc Exp $
  *
  *-------------------------------------------------------------------------
  */
@@ -1416,6 +1416,7 @@ StartTransaction(void)
 	 * GetCurrentTimestamp() call (which'd be expensive anyway).
 	 */
 	xactStartTimestamp = stmtStartTimestamp;
+	pgstat_report_txn_timestamp(xactStartTimestamp);
 
 	/*
 	 * initialize current transaction state fields
@@ -1628,6 +1629,7 @@ CommitTransaction(void)
 	/* smgrcommit already done */
 	AtEOXact_Files();
 	pgstat_count_xact_commit();
+	pgstat_report_txn_timestamp(0);
 
 	CurrentResourceOwner = NULL;
 	ResourceOwnerDelete(TopTransactionResourceOwner);
@@ -1994,6 +1996,7 @@ AbortTransaction(void)
 	smgrabort();
 	AtEOXact_Files();
 	pgstat_count_xact_rollback();
+	pgstat_report_txn_timestamp(0);
 
 	/*
 	 * State remains TRANS_ABORT until CleanupTransaction().
-- 
cgit v1.2.3