DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=uX72lwskxXp766mZCIuLaiAti0QMLKeDUUzGmjk2wSTCOtUCo+9juFH1gzxW8jCkkeUXlIgp8EWUyPLuKyIrLB7nGRsoDoetpXMV4LGeyQniwQ3mtYQh9u2CFCopnx6rmHkymd1teB8gwkxL//FsdYJ3+C3eXlJG567eAbBfTPM=
Message-ID: <1d4e0c10706181511p27a0296bh6982c17b16ed96f2@mail.gmail.com>
Date: Tue, 19 Jun 2007 00:11:15 +0200
From: "Guillaume Smet" <guillaume.smet@gmail.com>
To: "Y Sidhu" <ysidhu@gmail.com>
Subject: Re: Parsing VACUUM VERBOSE
Cc: pgsql-performance@postgresql.org
In-Reply-To: <b09064f30706181106v78ca57caxb2db252df88fdecf@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <f4rjfa$1187$1@news.hub.org>
	<1d4e0c10706140752u30923a39v3f59a02408836ee4@mail.gmail.com>
	<f56050$1akh$1@news.hub.org>
	<b09064f30706181106v78ca57caxb2db252df88fdecf@mail.gmail.com>

On 6/18/07, Y Sidhu <ysidhu@gmail.com> wrote:
>  I am following this discussion with great interest. I have PG running on
> FreeBSD and am forced to run pgFouine on a separate Linux box. I am hoping I
> can create a log file. and then copy that over and have pgFouine analyze it
> on the Linux box.
>  a.  I created a log file out of vacuum verbose, is that right? It is not
> complete because I don't know how to dump it into a file in some sort of
> autmoated fashion. So, I have to take what is on the screen and copy it off.

If you want to analyze a VACUUM log, just run vacuumdb with the option
you need (for example -a -z -v -f for a vacuum full analyze verbose).

# vacuumdb -a -z -v -f > your_log_file.log

Then analyze this log file as explained on the pgFouine website.

>  b.  I can also set a variable "log_min_duration_statement" in pgsql.conf
>
>  I guess I am like Sabin,, and need some hand holding to get started.

This is completely different and it's useful for query log analysis.
So you don't care if you just want to analyze your vacuum behaviour.

--
Guillaume