[pgsql-jp: 40138] ログの仕様につきまして

[Kayano Motoharu]

$B$O$8$a$F$*@$OC$K$J$j$^$9!#3~Ln$H?=$7$^$9!#(B

Postgresql 8.4.1$B$N%m%0$NFbMF$K$D$$$F(B
$B$4B8CN$G$"$l$P65$($F$/$@$5$$!#(B

DB$B%5!<%P>e$G<B9T$5$l$?(BSQL$BJ8$r5-O?$9$k$?$a(B
PosgreSQL$B$N%m%0$N%U%)!<%^%C%H$,$I$&$J$C$F$$$k$N$+(B
$BD4$Y$h$&$H$7$F$$$k$N$G$9$,!"$&$^$/>pJs$r8!:w$G$-$F$*$j$^$;$s!#(B

$B!V(BLOG:$B!W!V(BSTATEMENT:$B!W$NN>J}$G!"<B9T$5$l$?(BSQL$BJ8$,I=<($5$l$F$$$^$9$,(B
$B$3$N#2$D$N0c$$$K$D$$$F$4B8CN$G$7$g$&$+!)(B

$B<ALd$NGX7J(B :
$B!&8=:_(B pgpool-$B-6(B + PosgreSQL $B$G!"%l%W%j%1!<%7%g%s(B(select$B$NIi2YJ,;6(B)$B$9$k(B
  $B4D6-$r:n ＠ .$7$^$7$?!#(B

$B!&(Bselect $B$NIi2YJ,;6>u67$r3NG'$9$k$?$a!">e5-$N(BPosgreSQL$B$N%m%0$r(B
  $B8+$k$H0J2<$NMM$K$J$C$F$*$j$^$7$?!#(B
     (1) LOG:  00000: execute <unnamed>: select$B!&!&!&!&(B
         $B$H8@$&%m%0$O!"(B2$BBf ＠ _CV$7$?(B PosgreSQL $B%5!<%P!<$N(B
         1$BBf$@$1$K5-O?$5$l$F$$$k!#(B
         ($BIi2YJ,;6$5$l$F$$$k$H8+$($k(B)

     (2) STATEMENT:  select$B!&!&!&!&(B
         $B$H8@$&%m%0$O!"(B2$BBf$N(BPosgreSQL$B%5!<%P!<$NN>J}$K(B
         $B5-O?$5$l$F$$$k!#(B
         ($BIi2YJ,;6$5$l$F$$$J$$$h$&$K8+$($k(B)

$B!&8=>u$G$O(B (1) $B$N$h$&$K3NG'$5$l$F$$$k$N$G!"Ii2YJ,;6$5$l$F$$$k$H(B
  $B;W$C$F$$$k$N$G$9$,!"(B(2)$B$,5$$K$J$C$F$$$^$9!#(B


$B$A$J$_$K!"0J2<$N$h$&$K ＠ _Dj%U%!%$%k$rJQ$($F(B
$B$h$jB?$/$N>pJs$,I=<($5$l$k$h$&$K$7$F$$$^$9!#(B

log_min_error_statement = debug5
debug_print_plan = on
log_connections = on
log_disconnections = on
log_hostname = on
log_hostname = on
log_line_prefix = '%t %d [%p-%l]'
log_statement = 'all'


$B$h$m$7$/$*4j$$$7$^$9!#(B

-- 
Kayano Motoharu <M.Kayano ＠ cec-ltd.co.jp>