Re: Process title for autovac - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Process title for autovac
Date
Msg-id 1365857806.20086.1.camel@vanquo.pezone.net
Whole thread Raw
In response to Process title for autovac  (Jeff Janes <jeff.janes@gmail.com>)
Responses Re: Process title for autovac
List pgsql-hackers
On Sat, 2013-04-06 at 13:20 -0700, Jeff Janes wrote:
> I've often wanted to know what the autovacuum worker was doing.  The
> process title seems like the best place to get this information, but
> the process title tells me what database it is in, but not what table
> it is working on. 

Because the process title is publicly visible, you shouldn't put any
"interesting" information in it.

I think what you want might be better kept in pg_stat_activity.





pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Enabling Checksums
Next
From: Peter Eisentraut
Date:
Subject: Re: PROPOSAL: tracking aggregated numbers from pg_stat_database