Re: Parsing VACUUM VERBOSE

On 6/18/07, Sabin Coanda <sabin(dot)coanda(at)deuromedia(dot)ro> wrote:
>
>
> ""Guillaume Smet"" <guillaume(dot)smet(at)gmail(dot)com> wrote in message
> news:1d4e0c10706140752u30923a39v3f59a02408836ee4(at)mail(dot)gmail(dot)com(dot)(dot)(dot)
> > Sabin,
> >
> > On 6/14/07, Sabin Coanda <sabin(dot)coanda(at)deuromedia(dot)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(at)3$]'.B @
> M9&%T86)A<V4@<WES=&5M('=A<R!S:'5T(&1O=VX(at)870@,C P-RTP-BTQ." Q
> M-CHP,#HT-R!%15-4"C(P,#<M,#8M,3@@,38Z,# Z-#D(at)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(at)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(at)3$]'.B @;F5X="!T<F%N<V%C=&EO;B!)
> M1#H@,"\W(dot)#(at)V,C$[(&YE>'0(at)3TE$(dot)B V-C,W.#<*,C P-RTP-BTQ." Q-CHP
> M,#HT.2!%15-4(%LQ.3 W.5TZ(%LM,5T(at)3$]'.B @;F5X="!-=6QT:5AA8W1)
> M9#H@,S8[(&YE>'0(at)375L=&E886-T3V9F<V5T.B W,0HR,# W+3 V+3$X(#$V
> M.C P.C0Y($5%4U0(at)6S$Y,#<Y73H(at)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(at)3$]'.B @9'5R871I;VXZ(#(at)Q+C4P(dot)"!M<R @<W1A=&5M96YT.B!3
> M150(at)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(at)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(at)6S$Y,#DW73H(at)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(at)3$]'.B @9'5R871I;VXZ(#DX+C8S-R!M<R @<W1A=&5M96YT.B!314Q%
> M0U0(at)*B!&4D]-(")T8D-O;&QE8W1I;VYS(@HR,# W+3 V+3$X(#$V.C Q.C,W
> M($5%4U0(at)6S$Y,#DW73H(at)6RTQ72!,3T<Z("!D=7)A=&EO;CH(at)-2XT(dot)3(@;7,@
> M('-T871E;65N=#H(at)4T5,14-4(&9O<FUA=%]T>7!E*&]I9"PM,2D(at)87,@='EP
> M;F%M92!&4D]-('!G7W1Y<&4(at)5TA%4D4@;VED(#T@,C,*,C P-RTP-BTQ." Q
> M-CHP,3HS-R!%15-4(%LQ.3 Y-UTZ(%LM,5T(at)3$]'.B @9'5R871I;VXZ(#0N
> M,S<Q(&US("!S=&%T96UE;G0Z(%-%3$5#5"!#05-%(%=(14X(at)='EP8F%S971Y
> M<&4],"!42$5.(&]I9"!E;'-E('1Y<&)A<V5T>7!E($5.1"!!4R!B87-E='EP
> M90H)("!&4D]-('!G7W1Y<&4(at)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(dot)B!314Q%0U0(at)9F]R;6%T7W1Y<&4H;VED+#$P-"D@
> M87,@='EP;F%M92!&4D]-('!G7W1Y<&4(at)5TA%4D4@;VED(#T@,3 T,PHR,# W
> M+3 V+3$X(#$V.C Q.C,W($5%4U0(at)6S$Y,#DW73H(at)6RTQ72!,3T<Z("!D=7)A
> M=&EO;CH@,"XU,C,@;7,@('-T871E;65N=#H(at)4T5,14-4($-!4T4(at)5TA%3B!T
> M>7!B87-E='EP93TP(%1(14X@;VED(&5L<V4(at)='EP8F%S971Y<&4(at)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(at)6S$Y,#DW73H(at)6RTQ72!,3T<Z("!D=7)A
> M=&EO;CH@,"XS-S$@;7,@('-T871E;65N=#H(at)4T5,14-4(&9O<FUA=%]T>7!E
> M*&]I9"PM,2D(at)87,@='EP;F%M92!&4D]-('!G7W1Y<&4(at)5TA%4D4@;VED(#T@
> M,C,*,C P-RTP-BTQ." Q-CHP,3HS-R!%15-4(%LQ.3 Y-UTZ(%LM,5T(at)3$]'
> M.B @9'5R871I;VXZ(# N-3$T(&US("!S=&%T96UE;G0Z(%-%3$5#5"!#05-%
> M(%=(14X(at)='EP8F%S971Y<&4],"!42$5.(&]I9"!E;'-E('1Y<&)A<V5T>7!E
> M($5.1"!!4R!B87-E='EP90H)("!&4D]-('!G7W1Y<&4(at)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(dot)B!314Q%0U0(at)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(at)6S$Y,#DW73H(at)6RTQ
> M72!,3T<Z("!D=7)A=&EO;CH@,"XU,3<@;7,@('-T871E;65N=#H(at)4T5,14-4
> M($-!4T4(at)5TA%3B!T>7!B87-E='EP93TP(%1(14X@;VED(&5L<V4(at)='EP8F%S
> M971Y<&4(at)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(at)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(at)0T%312!72$5(dot)('1Y<&)A<V5T>7!E/3 @5$A%3B!O:60(at)96QS92!T
> M>7!B87-E='EP92!%3D0(at)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(at)6S$Y,#DW73H@
> M6RTQ72!,3T<Z("!D=7)A=&EO;CH@,"XS-S$@;7,@('-T871E;65N=#H(at)4T5,
> M14-4(&9O<FUA=%]T>7!E*&]I9"PM,2D(at)87,@='EP;F%M92!&4D]-('!G7W1Y
> M<&4(at)5TA%4D4@;VED(#T@,C,*,C P-RTP-BTQ." Q-CHP,3HS-R!%15-4(%LQ
> M.3 Y-UTZ(%LM,5T(at)3$]'.B @9'5R871I;VXZ(# N-3$Y(&US("!S=&%T96UE
> M;G0Z(%-%3$5#5"!#05-%(%=(14X(at)='EP8F%S971Y<&4],"!42$5.(&]I9"!E
> M;'-E('1Y<&)A<V5T>7!E($5.1"!!4R!B87-E='EP90H)("!&4D]-('!G7W1Y
> 0<&4(at)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