From: Guillaume Smet <guillaume.smet@gmail.com>
To: Y Sidhu <ysidhu@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Parsing VACUUM VERBOSE
Date: Tue, 19 Jun 2007 00:11:15 +0200
Message-ID: <1d4e0c10706181511p27a0296bh6982c17b16ed96f2@mail.gmail.com> (raw)
In-Reply-To: <b09064f30706181106v78ca57caxb2db252df88fdecf@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: guillaume.smet@gmail.com, ysidhu@gmail.com
Subject: Re: Parsing VACUUM VERBOSE
In-Reply-To: <1d4e0c10706181511p27a0296bh6982c17b16ed96f2@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox