On Wed, Jan 12, 2005 at 11:30:50PM -0700, Michael Fuhr wrote: > 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. now() returns the current transaction's start time. -- Alvaro Herrera (<alvherre[@]dcc.uchile.cl>) "No necesitamos banderas No reconocemos fronteras" (Jorge González) ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
