Re: Meaning of vacuum output - Mailing list pgsql-general

From Tom Lane
Subject Re: Meaning of vacuum output
Date
Msg-id 11503.1011205038@sss.pgh.pa.us
Whole thread Raw
In response to Meaning of vacuum output  ("Jeffrey W. Baker" <jwbaker@acm.org>)
List pgsql-general
"Jeffrey W. Baker" <jwbaker@acm.org> writes:
> I would be very surprised but it isn't impossible.  Is there a way to
> query the transaction counter for an open connection?

No easy way I can think of, short of gdb'ing each backend.  But you
could use "ps" and look at the start time of each backend process
that isn't showing status "idle".

            regards, tom lane

pgsql-general by date:

Previous
From: "Jeffrey W. Baker"
Date:
Subject: Meaning of vacuum output
Next
From: "Jeffrey W. Baker"
Date:
Subject: Re: Meaning of vacuum output