Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 6C1A49FB9F5 for ; Mon, 18 Jun 2007 15:07:19 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 06233-01-3 for ; Mon, 18 Jun 2007 15:07:07 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.248]) by postgresql.org (Postfix) with ESMTP id 251E49FBB3E for ; Mon, 18 Jun 2007 15:06:48 -0300 (ADT) Received: by an-out-0708.google.com with SMTP id c36so349717ana for ; Mon, 18 Jun 2007 11:06:47 -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=RLOoiCRWeXk5ZspFPjGrbzd3ODGnjMwBz/S2ztU4P2Rqv0tXlnqh5QdFzHEEJajp36PImaA0HKJXOPd0+kxhH0laNLqVAg5w89DOC9cJ6QF6L5/WNRDgGIiX7335LveFAnJXvW8eR2JyPwyGNjaek3ISz8xZ8Lwv0Zf3Fd+CEqs= 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=Ok7CmJi4oFtucIIJOZqlue+Xh77b7GY8UzfSEdwr4wk7OpBZhXXOJQOy5P4d2PX9wFjRbghhKbPFxX2NDqY6CkAKXRUH2rAZdbnfmQNTtKMmdswWAoLGt3M99th8XzdITy/oXFtzX/OA/NLAYPKVlMO54kg+j7hLMLNMGMqlXgg= Received: by 10.100.167.7 with SMTP id p7mr3686547ane.1182190006997; Mon, 18 Jun 2007 11:06:46 -0700 (PDT) Received: by 10.100.143.13 with HTTP; Mon, 18 Jun 2007 11:06:46 -0700 (PDT) Message-ID: Date: Mon, 18 Jun 2007 11:06:46 -0700 From: "Y Sidhu" To: pgsql-performance@postgresql.org Subject: Re: Parsing VACUUM VERBOSE In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_118801_22142471.1182190006924" References: <1d4e0c10706140752u30923a39v3f59a02408836ee4@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/304 X-Sequence-Number: 25337 ------=_Part_118801_22142471.1182190006924 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline On 6/18/07, Sabin Coanda wrote: > > > ""Guillaume Smet"" wrote in message > news:1d4e0c10706140752u30923a39v3f59a02408836ee4@mail.gmail.com... > > Sabin, > > > > On 6/14/07, Sabin Coanda wrote: > >> I'd like to understand completely the report generated by VACUUM > VERBOSE. > >> Please tell me where is it documented ? > > > > You can take a look to what I did for pgFouine: > > http://pgfouine.projects.postgresql.org/vacuum.html > > > > Hi Guillaume, > > I tried pgFouine.php app on a sample log file but it reports me some > errors. > Could you give me some startup support, please ? > I attach the log here to find what's wrong. > > Regards, > Sabin > > > begin 666 postgresql-2007-06-18_160048.log > M,C P-RTP-BTQ." Q-CHP,#HT.2!%15-4(%LQ.3 W.5TZ(%LM,5T@3$]'.B @ > M9&%T86)A M-CHP,#HT-R!%15-4"C(P,# M.B!;+3%=($Q/1SH@(&-H96-K<&]I;G0@ M-C8T"C(P,# M1SH@(')E9&\@ M9"!I M.2!%15-4(%LQ.3 W.5TZ(%LM,5T@3$]'.B @;F5X="!T M1#H@,"\W.#@V,C$[(&YE>'0@3TE$.B V-C,W.#<*,C P-RTP-BTQ." Q-CHP > M,#HT.2!%15-4(%LQ.3 W.5TZ(%LM,5T@3$]'.B @;F5X="!-=6QT:5AA8W1) > M9#H@,S8[(&YE>'0@375L=&E886-T3V9F M.C P.C0Y($5%4U0@6S$Y,#7-T > M96T@:7,@ M(%LM,5T@3$]'.B @9'5R871I;VXZ(#@Q+C4P."!M M150@1&%T95-T>6QE/4E33SM314Q%0U0@;VED+"!P9U]E;F-O9&EN9U]T;U]C > M:&%R*&5N8V]D:6YG*2!!4R!E;F-O9&EN9RP@9&%T;&%S='-Y M4D]-('!G7V1A=&%B87-E(%=(15)%(&]I9" ](#0V.30R,PHR,# W+3 V+3$X > M(#$V.C Q.C(W($5%4U0@6S$Y,#DW73H@6RTQ72!,3T M,"XP.3$@;7,@('-T871E;65N=#H@ M54Y)0T]$12<*,C P-RTP-BTQ." Q-CHP,3HS-R!%15-4(%LQ.3 Y-UTZ(%LM > M,5T@3$]'.B @9'5R871I;VXZ(#DX+C8S-R!M M0U0@*B!&4D]-(")T8D-O;&QE8W1I;VYS(@HR,# W+3 V+3$X(#$V.C Q.C,W > M($5%4U0@6S$Y,#DW73H@6RTQ72!,3T M('-T871E;65N=#H@4T5,14-4(&9O7!E*&]I9"PM,2D@87,@='EP > M;F%M92!&4D]-('!G7W1Y<&4@5TA%4D4@;VED(#T@,C,*,C P-RTP-BTQ." Q > M-CHP,3HS-R!%15-4(%LQ.3 Y-UTZ(%LM,5T@3$]'.B @9'5R871I;VXZ(#0N > M,S M<&4],"!42$5.(&]I9"!E;'-E('1Y<&)A7!E($5.1"!!4R!B87-E='EP > M90H)("!&4D]-('!G7W1Y<&4@5TA%4D4@;VED/3(S"C(P,# M,#$Z,S<@14535"!;,3DP.3==.B!;+3%=($Q/1SH@(&1U M,B!M M87,@='EP;F%M92!&4D]-('!G7W1Y<&4@5TA%4D4@;VED(#T@,3 T,PHR,# W > M+3 V+3$X(#$V.C Q.C,W($5%4U0@6S$Y,#DW73H@6RTQ72!,3T M=&EO;CH@,"XU,C,@;7,@('-T871E;65N=#H@4T5,14-4($-!4T4@5TA%3B!T > M>7!B87-E='EP93TP(%1(14X@;VED(&5L M(&)A7!E"@D@($923TT@<&=?='EP92!72$5212!O:60],3 T,PHR,# W > M+3 V+3$X(#$V.C Q.C,W($5%4U0@6S$Y,#DW73H@6RTQ72!,3T M=&EO;CH@,"XS-S$@;7,@('-T871E;65N=#H@4T5,14-4(&9O7!E > M*&]I9"PM,2D@87,@='EP;F%M92!&4D]-('!G7W1Y<&4@5TA%4D4@;VED(#T@ > M,C,*,C P-RTP-BTQ." Q-CHP,3HS-R!%15-4(%LQ.3 Y-UTZ(%LM,5T@3$]' > M.B @9'5R871I;VXZ(# N-3$T(&US("!S=&%T96UE;G0Z(%-%3$5#5"!#05-% > M(%=(14X@='EP8F%S971Y<&4],"!42$5.(&]I9"!E;'-E('1Y<&)A7!E > M($5.1"!!4R!B87-E='EP90H)("!&4D]-('!G7W1Y<&4@5TA%4D4@;VED/3(S > M"C(P,# M(&1U M7W1Y<&4H;VED+"TQ*2!A7!N86UE($923TT@<&=?='EP92!72$5212!O > M:60@/2 R,PHR,# W+3 V+3$X(#$V.C Q.C,W($5%4U0@6S$Y,#DW73H@6RTQ > M72!,3T M($-!4T4@5TA%3B!T>7!B87-E='EP93TP(%1(14X@;VED(&5L M971Y<&4@14Y$($%3(&)A7!E"@D@($923TT@<&=?='EP92!72$5212!O > M:60],C,*,C P-RTP-BTQ." Q-CHP,3HS-R!%15-4(%LQ.3 Y-UTZ(%LM,5T@ > M3$]'.B @9'5R871I;VXZ(# N,S M;W)M871?='EP92AO:60L+3$I(&%S('1Y<&YA;64@1E)/32!P9U]T>7!E(%=( > M15)%(&]I9" ](#(S"C(P,# M.B!;+3%=($Q/1SH@(&1U M14Q%0U0@0T%312!72$5.('1Y<&)A7!E/3 @5$A%3B!O:60@96QS92!T > M>7!B87-E='EP92!%3D0@05,@8F%S971Y<&4*"2 @1E)/32!P9U]T>7!E(%=( > M15)%(&]I9#TR,PHR,# W+3 V+3$X(#$V.C Q.C,W($5%4U0@6S$Y,#DW73H@ > M6RTQ72!,3T M14-4(&9O7!E*&]I9"PM,2D@87,@='EP;F%M92!&4D]-('!G7W1Y > M<&4@5TA%4D4@;VED(#T@,C,*,C P-RTP-BTQ." Q-CHP,3HS-R!%15-4(%LQ > M.3 Y-UTZ(%LM,5T@3$]'.B @9'5R871I;VXZ(# N-3$Y(&US("!S=&%T96UE > M;G0Z(%-%3$5#5"!#05-%(%=(14X@='EP8F%S971Y<&4],"!42$5.(&]I9"!E > M;'-E('1Y<&)A7!E($5.1"!!4R!B87-E='EP90H)("!&4D]-('!G7W1Y > 0<&4@5TA%4D4@;VED/3(S"@`` > ` > end > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster > Guillaume and Sabin, 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. 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. -- Yudhvir Singh Sidhu 408 375 3134 cell ------=_Part_118801_22142471.1182190006924 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline

On 6/18/07, Sabin Coanda <sabin.coanda@deuromedia.ro> wrote:

""Guillaume Smet"" <guillaume.smet@gmail.com> wrote in message
news:1d4e0c10706140752u30923a39v3f59a02408836ee4@mail.gmail.com...
> Sabin,
>
> On 6/14/07, Sabin Coanda <sabin.coanda@deuromedia.ro> wrote:
>> I'd like to understand completely the report generated by VACUUM VERBOSE.
>> Please tell me where is it documented ?
>
> You can take a look to what I did for pgFouine:
> http://pgfouine.projects.postgresql.org/vacuum.html
>

Hi Guillaume,

I tried pgFouine.php app on a sample log file but it reports me some errors.
Could you give me some startup support, please ?
I attach the log here to find what's wrong.

Regards,
Sabin


begin 666 postgresql-2007-06-18_160048.log
M,C P-RTP-BTQ." Q-CHP,#HT.2!%15-4(%LQ.3 W.5TZ(%LM,5T@3$]'.B @
M9&%T86)A<V4@<WES=&5M('=A<R!S:'5T(&1O=VX@870 @,C P-RTP-BTQ." Q
M-CHP,#HT-R!%15-4"C(P,#<M,#8M,3@@,38Z,# Z-#D@14535"!;,3DP-SE=
M.B!;+3%=($Q/1SH@(&-H96-K<&]I;G0@<F5C;W)D(&ES(&%T(#,W+T$S-SDX
M-C8T"C(P,#<M,#8M,3@@,38Z,# Z-#D@14535"!;,3DP-SE=.B!;+3%=($Q/
M1SH@(')E9&\@<F5C;W)D(&ES(&%T(#,W+T$S-SDX-C8T.R!U;F1O(')E8V]R
M9"!I<R!A=" P+S [('-H=71D;W=N(%12544*,C P-RTP-BTQ." Q-CHP,#HT
M.2!%15-4 (%LQ.3 W.5TZ(%LM,5T@3$]'.B @;F5X="!T<F%N<V%C=&EO;B!)
M1#H@,"\W.#@V,C$[(&YE>'0@3TE$.B V-C,W.#<*,C P-RTP-BTQ." Q-CHP
M,#HT.2!%15-4(%LQ.3 W.5TZ(%LM,5T@3$]'.B @;F5X="!-=6QT:5AA8W1)
M9#H@,S8[(&YE>'0@375L=&E886-T3V9F<V5T.B W,0HR,# W+3 V+3$X(#$V
M.C P.C0Y($5%4U0@6S$Y,#<Y73H@6RTQ72!,3T<Z("!D871A8F%S92!S>7-T
M96T@:7,@<F5A9'D*,C P-RTP-BTQ." Q-CHP,3HR-R!%15-4(%LQ.3 Y-UTZ
M(%LM,5T@3$]'.B @9'5R871I;VXZ(#@Q+C4P."!M<R @<W1A=&5M96YT.B!3
M150@1&%T95-T>6QE/4E33SM314Q%0U0@;VED+"!P9U]E;F-O9&EN9U]T;U]C
M:&%R*&5N8V]D:6YG*2!!4R!E;F-O9&EN9RP@9 &%T;&%S='-Y<V]I9 H)("!&
M4D]-('!G7V1A=&%B87-E(%=(15)%(&]I9" ](#0V.30R,PHR,# W+3 V+3$X
M(#$V.C Q.C(W($5%4U0@6S$Y,#DW73H@6RTQ72!,3T<Z("!D=7)A=&EO;CH@
M,"XP.3$ @;7,@('-T871E;65N=#H@<V5T(&-L:65N=%]E;F-O9&EN9R!T;R G
M54Y)0T]$12<*,C P-RTP-BTQ." Q-CHP,3HS-R!%15-4(%LQ.3 Y-UTZ(%LM
M,5T@3$]'.B @9'5R871I;VXZ(#DX+C8S-R!M<R @<W1A=&5M96YT.B!314Q%
M0U0@*B!&4D]-(")T8D-O;&QE8W1I;VYS(@HR,# W+3 V+3$X(#$V.C Q.C,W
M($5%4U0@6S$Y,#DW73H@6RTQ72!,3T<Z("!D=7)A=&EO;CH@-2XT.3(@;7,@
M('-T871E;65N=#H@4T5,14-4(&9O<FUA=%]T>7!E*&]I9"PM, 2D@87,@='EP
M;F%M92!&4D]-('!G7W1Y<&4@5TA%4D4@;VED(#T@,C,*,C P-RTP-BTQ." Q
M-CHP,3HS-R!%15-4(%LQ.3 Y-UTZ(%LM,5T@3$]'.B @9'5R871I;VXZ(#0N
M,S<Q(&US("!S=&%T96UE;G0Z(%-%3$5#5"!#05-%(%=(14X@='EP8F%S971Y
M<&4],"!42$5.(&]I9"!E;'-E('1Y<&)A<V5T>7!E($5.1"!!4R!B87-E='EP
M90H)("!&4D]-('!G7W1Y<&4@5TA%4D4@;VED/3(S"C(P,#<M,#8M,3@@,38Z
M,#$Z,S<@14535"!;, 3DP.3==.B!;+3%=($Q/1SH@(&1U<F%T:6]N.B P+C0S
M,B!M<R @<W1A=&5M96YT.B!314Q%0U0@9F]R;6%T7W1Y<&4H;VED+#$P-"D@
M87,@='EP;F%M92!&4D]-('!G7W1Y<&4@5TA%4D4@;VED(#T@,3 T,PHR,# W
M+3 V+3$X(#$V.C Q.C,W($5%4U0@6S$Y,#DW73H@6RTQ72!,3T<Z("!D=7)A
M=&EO;CH@,"XU,C,@;7,@('-T871E;65N=#H@4T5,14-4($-!4T4@5TA%3B!T
M>7!B87-E='EP93TP(%1(14X@;VED(&5L<V4@='EP8F%S971Y<&4@14Y$($%3
M(&)A<V5T>7!E"@D@($923TT@<&=?='EP92!72$5212!O:60],3 T,PHR,# W
M+3 V+3$X(#$V.C Q.C,W($5%4U0@6S$Y,#DW73H@6RTQ72!,3T<Z("!D=7)A
M=&EO;CH@,"XS-S$@;7,@('-T871E;65N=#H@4T5,14-4(&9O<FUA=%]T>7!E
M*&]I9"PM,2D@87,@='EP;F%M92!&4D]-('!G7W1Y<&4@5TA%4D4@;VED(#T@
M,C,*,C P-RTP-BTQ." Q-CHP,3HS-R!%15-4(%LQ.3 Y-UTZ(%LM,5T@3$]'
M.B @9'5R871I;VXZ(# N-3$T(&US("!S=&%T96UE;G0Z(%-%3$5#5"!#05-%
M(%=(14X@='EP8F%S971Y<&4],"!42$5.(&]I9"!E;'-E('1Y<&)A<V5T>7!E
M($5.1"!!4R!B87-E='EP90H)("!&4D]-('!G7W1Y<&4@5TA%4D4@;VED/3(S
M"C(P,#<M,#8M,3@@,38Z,#$Z,S<@14535"!;, 3DP.3==.B!;+3%=($Q/1SH@
M(&1U<F%T:6]N.B P+C,W.2!M<R @<W1A=&5M96YT.B!314Q%0U0@9F]R;6%T
M7W1Y<&4H;VED+"TQ*2!A<R!T>7!N86UE($923TT@<&=?='EP92!72$5212!O
M:60@/2 R,PHR,# W+3 V+3$X(#$V.C Q.C,W($5%4U0@6S$Y,#DW73H@6RTQ
M72!,3T<Z("!D=7)A=&EO;CH@,"XU,3<@;7,@('-T871E;65N=#H@4T5,14-4
M($-!4T4@5TA%3B!T>7!B87-E='EP93TP(%1(14X@;VED(&5L<V4@='EP8F%S
M971Y<&4@14Y$($%3(&)A<V5T>7!E"@D@($923TT@<&=?='EP92!72$5212!O
M:60],C,*,C P-RTP-BTQ." Q-CHP,3HS-R!%15-4(%LQ.3 Y-UTZ(%LM,5T@
M3$]'.B @9'5R871I;VXZ(# N,S<Q(&US("!S=&%T96UE;G0Z(%-%3$5#5"!F
M;W)M871?='EP92AO:60L+3$I(&%S('1Y<&YA;64@1E)/32!P9U]T>7!E(%=(
M15)%(&]I9" ](#(S"C(P,#<M,#8M,3@@,38Z,#$Z,S<@14535"!;,3DP.3==
M.B!;+3%=($Q/1SH@(&1U<F%T:6]N.B P+C4Q,"!M<R @<W1A=&5M96YT.B!3
M14Q%0U0@0T%312!72$5.('1Y<&)A<V5T>7!E/3 @ 5$A%3B!O:60@96QS92!T
M>7!B87-E='EP92!%3D0@05,@8F%S971Y<&4*"2 @1E)/32!P9U]T>7!E(%=(
M15)%(&]I9#TR,PHR,# W+3 V+3$X(#$V.C Q.C,W($5%4U0@6S$Y,#DW73H@
M6RTQ72!,3T<Z("!D=7)A=&EO;CH@,"XS-S$@;7,@('-T871E;65N=#H@4T5,
M14-4(&9O<FUA=%]T>7!E*&]I9"PM,2D@87,@='EP;F%M92!&4D]-('!G7W1Y
M<&4@5TA%4D4@;VED(#T@,C,*,C P-RTP-BTQ." Q-CHP,3HS-R!%15-4(%LQ
M.3 Y-UTZ(%LM,5T@3$]'.B @9'5R871I;VXZ(# N-3$Y(&US("!S=&%T96UE
M;G0Z(%-%3$5#5"!#05-%(%=(14X@='EP8F%S971Y<&4],"!42$5.(&]I9"!E
M;'-E('1Y<&)A<V5T>7!E($5.1"!!4R!B87-E='EP90H)("!&4D]-('!G7W1Y
0<&4@5TA%4D4@;VED/3(S"@``
`
end


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Guillaume and Sabin,

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.
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.


--
Yudhvir Singh Sidhu
408 375 3134 cell ------=_Part_118801_22142471.1182190006924--