diff options
| author | Neil Conway <neilc@samurai.com> | 2006-12-06 18:06:48 +0000 |
|---|---|---|
| committer | Neil Conway <neilc@samurai.com> | 2006-12-06 18:06:48 +0000 |
| commit | 886a02d1cb19fe25859bd3c2d1f6a64b04cdc710 (patch) | |
| tree | a0684de747e49ba23b5c7fead1052d378ecbb4dd /src/backend/access/transam/xact.c | |
| parent | dd740e1fd066a5df628ba28dfdaee02d58dee0c5 (diff) | |
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.
Diffstat (limited to 'src/backend/access/transam/xact.c')
| -rw-r--r-- | src/backend/access/transam/xact.c | 5 |
1 files changed, 4 insertions, 1 deletions
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(). |