On Thu, Jan 13, 2005 at 08:45:38AM -0700, Ed L. wrote: > On Thursday January 13 2005 5:50, Alvaro Herrera wrote: > > 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? > > now() returns the current transaction's start time. > > That would be perfect if I could see that for transactions other than my > own. No, there's no way to know that. Unless, of course, you save it yourself somewhere at transaction start (though because of isolation, using a regular table would not help you any. Perhaps some PL's shared data can help you there.) -- Alvaro Herrera (<alvherre[@]dcc.uchile.cl>) Este mail se entrega garantizadamente 100% libre de sarcasmo. ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
