Tom Lane wrote: > Christopher Kings-Lynne <[EMAIL PROTECTED]> writes: > >> It sure would be nice to be able to have a way to query the start time > >> of the eldest transaction on the system. If that could be done at a > >> not-too-high cost, it would be eminently helpful for various sorts of > >> maintenance processes so that you could assortedly: > > > You can get that from pg_stat_activity, if you have the relevant stats > > turned on. > > pg_stat_activity will tell you about the oldest active query, but not > about oldest open transaction.
And pg_stat_activity can lose information when the network is under heavy load too. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
