X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 980B79DC826 for ; Fri, 10 Feb 2006 17:13:32 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 11463-03 for ; Fri, 10 Feb 2006 17:13:33 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from fusion.bennyvision.com (fusion.bennyvision.com [71.32.179.125]) by postgresql.org (Postfix) with SMTP id 085359DC800 for ; Fri, 10 Feb 2006 17:13:29 -0400 (AST) Received: (qmail 22924 invoked by uid 1007); 10 Feb 2006 21:13:31 -0000 Received: from localhost (HELO webmail.stinkweasel.net) (127.0.0.1) by fusion.bennyvision.com with SMTP; 10 Feb 2006 21:13:31 -0000 Received: from 134.244.169.17 (SquirrelMail authenticated user benny) by webmail.stinkweasel.net with HTTP; Fri, 10 Feb 2006 15:13:31 -0600 (CST) Message-ID: <4131.134.244.169.17.1139606011.squirrel@webmail.stinkweasel.net> In-Reply-To: <6064nneznu.fsf@dba2.int.libertyrms.com> References: <2894.134.244.169.17.1139587037.squirrel@webmail.stinkweasel.net> <6064nneznu.fsf@dba2.int.libertyrms.com> Date: Fri, 10 Feb 2006 15:13:31 -0600 (CST) Subject: Re: Is the database being VACUUMed? From: "C. Bensend" To: pgsql-admin@postgresql.org User-Agent: SquirrelMail/1.4.5 MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) Importance: Normal X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.12 required=5 tests=[AWL=0.120] X-Spam-Score: 0.12 X-Spam-Level: X-Archive-Number: 200602/114 X-Sequence-Number: 20535 > If you have command string monitoring turned on, via > stats_command_string in the postgresql.conf file, then you could get > this information from the system view pg_stat_activity. > > Generally, you could look to see if a current_query is a vacuum, perhaps > via... > > select * from pg_stat_activity where lower(current_query) like 'vacuum%' ; Are there any drawbacks to turning this on (mine is not)? If not, I can certainly do that. > If that parameter is not turned on, then ps auxww | egrep [something > finding your PG processes] | grep VACUUM could perhaps do the trick, > albeit not from a straightforward database query... Yes, I could do that, but I'd rather avoid it if I can. :) Thanks much! Benny -- "'And you've got 10 gig of files to put through our mail system?' I ask, squeezing my mouse in a non-approved manner." -- BOFH, 2006-01