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

Re: Transaction start in pg_stat_activity

From: "Simon Riggs" <simon(at)2ndquadrant(dot)com>
To: "Neil Conway" <neilc(at)samurai(dot)com>
Cc: "pgsql-patches" <pgsql-patches(at)postgresql(dot)org>
Subject: Re: Transaction start in pg_stat_activity
Date: 2006-11-20 10:02:27
Message-ID: 1164016947.3841.6.camel@silverbirch.site (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
On Sat, 2006-11-18 at 21:44 -0500, Neil Conway wrote:

> 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.

Great idea. Would it be appropriate to show the time the current
snapshot was taken also/instead?

-- 
  Simon Riggs             
  EnterpriseDB   http://www.enterprisedb.com



In response to

Responses

pgsql-hackers by date

Next:From: arkadiusz.staronDate: 2006-11-20 10:19:34
Subject: Tsearch + polish ispell + polish locale
Previous:From: Markus SchiltknechtDate: 2006-11-20 09:43:33
Subject: Re: [HACKERS] Replication documentation addition

pgsql-patches by date

Next:From: Tom LaneDate: 2006-11-20 15:58:02
Subject: Re: Transaction start in pg_stat_activity
Previous:From: Neil ConwayDate: 2006-11-19 22:26:51
Subject: Re: add external pl language section, clean up some links

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