Skip site navigation (1) Skip section navigation (2)

Transaction start in pg_stat_activity

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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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: txn_start_time-1.patch
Description: text/x-patch (17.3 KB)

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2006-11-19 06:46:19
Subject: Re: Nasty VACUUM/bgwriter/segmentation bug
Previous:From: Mike RylanderDate: 2006-11-19 01:37:44
Subject: Re: Ontology on PostgreSQL - is there something?

pgsql-patches by date

Next:From: Neil ConwayDate: 2006-11-19 22:26:51
Subject: Re: add external pl language section, clean up some links
Previous:From: Simon RiggsDate: 2006-11-18 12:58:51
Subject: Re: Proposed patch for xact-vs-multixact bugs

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group