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.