Received: from localhost (maia-4.hub.org [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id A888C9FBF08
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Thu, 14 Jun 2007 12:30:30 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 15860-04 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Thu, 14 Jun 2007 12:30:22 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4
Received: from an-out-0708.google.com (an-out-0708.google.com
 [209.85.132.244])
	by postgresql.org (Postfix) with ESMTP id 411789FBEF1
	for <pgsql-performance@postgresql.org>;
	Thu, 14 Jun 2007 12:30:22 -0300 (ADT)
Received: by an-out-0708.google.com with SMTP id c36so122782ana
	for <pgsql-performance@postgresql.org>;
	Thu, 14 Jun 2007 08:30:21 -0700 (PDT)
DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta;
	h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references;
	b=mJdwWlvV2awwAkSBYFumNjL6GcswUdCNDlkMwkDcnqVPdt5ZyjN3eMJqQ3NewIH3ttnMn70vF0TmV1xjyi0ZnK162rgtZ+UXmv2nDYZNpdnxL1EfkRAgMtH54MDIKUocFKbOuwL4wLlcbtaosFLeVEpQ4CnNm1s67sfzBsbZsyE=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references;
	b=CELXHlrF+yHU7Bcjc8VLO8FshLZ2Lyk8msj1VnpRz+q/HITODsb969Jeott1PavLqqCAvn02CPo8vFLyCnn3XUA9OIyF9OZs+RclfISrV+mCm3VUT6zpr22Ra4PLX96fqZjlf2sse+d57+d/r8qJTfOj3Ednx/5GsnqlEV9wikg=
Received: by 10.101.14.16 with SMTP id r16mr1163741ani.1181835021403;
	Thu, 14 Jun 2007 08:30:21 -0700 (PDT)
Received: by 10.100.4.16 with HTTP; Thu, 14 Jun 2007 08:30:21 -0700 (PDT)
Message-ID: <b09064f30706140830g6d2e19d4v3059eb2be23292fb@mail.gmail.com>
Date: Thu, 14 Jun 2007 08:30:21 -0700
From: "Y Sidhu" <ysidhu@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Re: Parsing VACUUM VERBOSE
In-Reply-To: <200706141653.33808.dfontaine@hi-media.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_37150_14257896.1181835021380"
References: <f4rjfa$1187$1@news.hub.org>
	<200706141653.33808.dfontaine@hi-media.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200706/256
X-Sequence-Number: 25289

------=_Part_37150_14257896.1181835021380
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

On 6/14/07, Dimitri Fontaine <dfontaine@hi-media.com> wrote:
>
> Le jeudi 14 juin 2007, Sabin Coanda a =E9crit:
> > I'd like to understand completely the report generated by VACUUM
> VERBOSE.
> > Please tell me where is it documented ?
>
> Try the pgfouine reporting tool :
>   http://pgfouine.projects.postgresql.org/
>   http://pgfouine.projects.postgresql.org/reports/sample_vacuum.html
>
> It's easier to understand the vacuum verbose output from the generated
> report.
> --
> dim
>
>
Can anyone share what value they have set log_min_duration_statement to?

--=20
Yudhvir Singh Sidhu
408 375 3134 cell

------=_Part_37150_14257896.1181835021380
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

<br><br><div><span class=3D"gmail_quote">On 6/14/07, <b class=3D"gmail_send=
ername">Dimitri Fontaine</b> &lt;<a href=3D"mailto:dfontaine@hi-media.com">=
dfontaine@hi-media.com</a>&gt; wrote:</span><blockquote class=3D"gmail_quot=
e" style=3D"border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt =
0.8ex; padding-left: 1ex;">
Le jeudi 14 juin 2007, Sabin Coanda a =E9crit:<br>&gt; I&#39;d like to unde=
rstand completely the report generated by VACUUM VERBOSE.<br>&gt; Please te=
ll me where is it documented ?<br><br>Try the pgfouine reporting tool :<br>
&nbsp;&nbsp;<a href=3D"http://pgfouine.projects.postgresql.org/">http://pgf=
ouine.projects.postgresql.org/</a><br>&nbsp;&nbsp;<a href=3D"http://pgfouin=
e.projects.postgresql.org/reports/sample_vacuum.html">http://pgfouine.proje=
cts.postgresql.org/reports/sample_vacuum.html
</a><br><br>It&#39;s easier to understand the vacuum verbose output from th=
e generated report.<br>--<br>dim<br><br></blockquote></div><br>Can anyone s=
hare what value they have set log_min_duration_statement to?<br clear=3D"al=
l">
<br>-- <br>Yudhvir Singh Sidhu<br>408 375 3134 cell

------=_Part_37150_14257896.1181835021380--