| 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 19:21:23 |
| Message-ID: | 20050113192123.GA40725@winnie.fuhr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Jan 13, 2005 at 10:33:50AM -0700, Ed L. wrote:
> On Thursday January 13 2005 10:09, Michael Fuhr wrote:
> >
> > For idle transactions pg_stat_activity shows "<IDLE> in transaction"
> > and the query_start column shows when the transaction became idle
>
> That will help, thanks. Unfortunately, that doesn't appear to work for many
> of our pre-7.4 clusters, of which we have 60, but that will definitely help
> as we migrate forward.
Ah yes, I see in the Relase Notes that the query start time was
added in 7.4.
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Fuhr | 2005-01-13 19:23:42 | Re: vacuum vs open transactions |
| Previous Message | Ed L. | 2005-01-13 19:04:28 | Re: vacuum vs open transactions |