Re: vacuum vs open transactions

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
Cc: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: vacuum vs open transactions
Date: 2005-01-13 06:30:50
Message-ID: 20050113063050.GA72291@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Jan 12, 2005 at 11:49:12AM -0700, Ed L. wrote:
>
> Is it possible via SQL query to tell how long a transaction has been open?

I'm not aware of a way to find out when a transaction started, but
if you have stats_command_string enabled then you can query
pg_stat_activity to see when a session's current query started.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2005-01-13 06:38:37 Re: Question about pg_stat_activity
Previous Message Tony Caduto 2005-01-13 06:28:02 Working on a new Postgres Admin tool and was wondering...