Re: [GENERAL] pg_stat_activity xact_start and autovacuum

[Decibel!]

On Feb 11, 2008, at 8:14 AM, Alvaro Herrera wrote:

Actually it's not just autovacuum; it's any lazy vacuum.  It's hard to
tell those processes apart in pg_stat_activity.  Perhaps we could have

old tuples, but I feel that would have been a little too much.

added a column in pg_stat_activity indicating processes that don't hold

\s*vacuum((\s+full){0,1}\s+\S+){0,1};{0,1}



You could probably even simplify that to

\s*vacuum(\s+full){0}


--
Decibel!, aka Jim C. Nasby, Database Architect  [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828

I don't think it'd be too hard to construct a regex that would catch all vacuums, after which you could throw out FULLs. I'm thinking something like Where \s indicates whitespace and \S indicates not whitespace (sorry, don't have a regex manual handy...) Of course, you'd want to perform all of those in a case-insensitive manner.

smime.p7s
Description: S/MIME cryptographic signature