On 6/18/07, Sabin Coanda <[EMAIL PROTECTED]> wrote:


""Guillaume Smet"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Sabin,
>
> On 6/14/07, Sabin Coanda <[EMAIL PROTECTED]> 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,[EMAIL PROTECTED]'.B @
M9&%T86)A<V4@<WES=&5M('=A<R!S:'5T(&[EMAIL PROTECTED]@,C P-RTP-BTQ." Q
M-CHP,#HT-R!%15-4"C(P,#<M,#8M,3@@,38Z,# [EMAIL PROTECTED]"!;,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,# [EMAIL PROTECTED]"!;,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,[EMAIL PROTECTED]'.B @;F5X="!T<F%N<V%C=&EO;B!)
M1#H@,"[EMAIL PROTECTED],C$[(&YE>'[EMAIL PROTECTED] V-C,W.#<*,C P-RTP-BTQ." 
Q-CHP
M,#HT.2!%15-4(%LQ.3 W.5TZ(%LM,[EMAIL PROTECTED]'.B @;F5X="!-=6QT:5AA8W1)
M9#H@,S8[(&YE>'[EMAIL PROTECTED]&E886-T3V9F<V5T.B W,0HR,# W+3 V+3$X(#$V
M.C P.C0Y([EMAIL PROTECTED],#<[EMAIL PROTECTED],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,[EMAIL PROTECTED]'.B @9'5R871I;VXZ([EMAIL PROTECTED]"!M<R 
@<W1A=&5M96YT.B!3
[EMAIL PROTECTED]&%T95-T>6QE/4E33SM314Q%0U0@;VED+"!P9U]E;F-O9&EN9U]T;U]C
M:&%R*&5N8V]D:6YG*2!!4R!E;F-O9&[EMAIL PROTECTED]&%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([EMAIL PROTECTED],[EMAIL PROTECTED],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,[EMAIL PROTECTED]'.B @9'5R871I;VXZ(#DX+C8S-R!M<R @<W1A=&5M96YT.B!314Q%
[EMAIL PROTECTED]&4D]-(")T8D-O;&QE8W1I;VYS(@HR,# W+3 V+3$X(#$V.C Q.C,W
M([EMAIL PROTECTED],[EMAIL PROTECTED],3T<Z("!D=7)A=&EO;[EMAIL PROTECTED](@;7,@
M('-T871E;[EMAIL PROTECTED],14-4(&9O<FUA=%]T>7!E*&]I9"PM,[EMAIL PROTECTED],@='EP
M;F%M92!&4D]-('!G7W1Y<&[EMAIL PROTECTED]@;VED(#T@,C,*,C P-RTP-BTQ." Q
M-CHP,3HS-R!%15-4(%LQ.3 Y-UTZ(%LM,[EMAIL PROTECTED]'.B @9'5R871I;VXZ(#0N
M,S<Q(&US("!S=&%T96UE;G0Z(%-%3$5#5"!#05-%(%=([EMAIL PROTECTED]'EP8F%S971Y
M<&4],"!42$5.(&]I9"!E;'-E('1Y<&)A<V5T>7!E($5.1"!!4R!B87-E='EP
M90H)("!&4D]-('!G7W1Y<&[EMAIL PROTECTED]@;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=&[EMAIL PROTECTED];6%T7W1Y<&4H;VED+#$P-"D@
M87,@='EP;F%M92!&4D]-('!G7W1Y<&[EMAIL PROTECTED]@;VED(#T@,3 T,PHR,# W
M+3 V+3$X(#$V.C Q.C,W([EMAIL PROTECTED],[EMAIL PROTECTED],3T<Z("!D=7)A
M=&EO;CH@,"XU,C,@;7,@('-T871E;[EMAIL PROTECTED],14-4([EMAIL PROTECTED]
M>7!B87-E='EP93TP(%1(14X@;VED(&5L<[EMAIL PROTECTED]'EP8F%S971Y<&[EMAIL 
PROTECTED]($%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([EMAIL PROTECTED],[EMAIL PROTECTED],3T<Z("!D=7)A
M=&EO;CH@,"XS-S$@;7,@('-T871E;[EMAIL PROTECTED],14-4(&9O<FUA=%]T>7!E
M*&]I9"PM,[EMAIL PROTECTED],@='EP;F%M92!&4D]-('!G7W1Y<&[EMAIL 
PROTECTED]@;VED(#T@
M,C,*,C P-RTP-BTQ." Q-CHP,3HS-R!%15-4(%LQ.3 Y-UTZ(%LM,[EMAIL PROTECTED]'
M.B @9'5R871I;VXZ(# N-3$T(&US("!S=&%T96UE;G0Z(%-%3$5#5"!#05-%
M(%=([EMAIL PROTECTED]'EP8F%S971Y<&4],"!42$5.(&]I9"!E;'-E('1Y<&)A<V5T>7!E
M($5.1"!!4R!B87-E='EP90H)("!&4D]-('!G7W1Y<&[EMAIL PROTECTED]@;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=&[EMAIL PROTECTED];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([EMAIL PROTECTED],[EMAIL PROTECTED]
M72!,3T<Z("!D=7)A=&EO;CH@,"XU,3<@;7,@('-T871E;[EMAIL PROTECTED],14-4
M([EMAIL PROTECTED]>7!B87-E='EP93TP(%1(14X@;VED(&5L<[EMAIL PROTECTED]'EP8F%S
M971Y<&[EMAIL PROTECTED]($%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;[EMAIL PROTECTED])/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
[EMAIL PROTECTED]('1Y<&)A<V5T>7!E/3 @5$A%3B!O:[EMAIL PROTECTED]
M>7!B87-E='[EMAIL PROTECTED],@8F%S971Y<&4*"2 @1E)/32!P9U]T>7!E(%=(
M15)%(&]I9#TR,PHR,# W+3 V+3$X(#$V.C Q.C,W([EMAIL PROTECTED],#DW73H@
M6RTQ72!,3T<Z("!D=7)A=&EO;CH@,"XS-S$@;7,@('-T871E;[EMAIL PROTECTED],
M14-4(&9O<FUA=%]T>7!E*&]I9"PM,[EMAIL PROTECTED],@='EP;F%M92!&4D]-('!G7W1Y
M<&[EMAIL PROTECTED]@;VED(#T@,C,*,C P-RTP-BTQ." Q-CHP,3HS-R!%15-4(%LQ
M.3 Y-UTZ(%LM,[EMAIL PROTECTED]'.B @9'5R871I;VXZ(# N-3$Y(&US("!S=&%T96UE
M;G0Z(%-%3$5#5"!#05-%(%=([EMAIL PROTECTED]'EP8F%S971Y<&4],"!42$5.(&]I9"!E
M;'-E('1Y<&)A<V5T>7!E($5.1"!!4R!B87-E='EP90H)("!&4D]-('!G7W1Y
0<&[EMAIL PROTECTED]@;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

Reply via email to