|
Hello and namaste,
I have installed the latest version an running tests on it. Since i analyze logs , i have found three new entries in log for each insert statement which isn't present in postgres 9.0 log --- 2013-08-10 11:59:27.031 IST,"postgres","aeppos",2780,"192.168.10.19:50935",5205dd5b.adc,352787,"idle",2013-08-10 11:57:39 IST,5/129358,0,LOG,00000,"PARSER STATISTICS","! system usage stats: ! 0.000000 elapsed 0.000000 user 0.000000 system sec ! [43.227877 user 19.250523 sys total]",,,,,"insert into loginmaster (loginid,fullname,empid,passwd) values ( 'login88193', 'fullname88193', 'empid88193', 'passwd88193')",,,"" 2013-08-10 11:59:27.032 IST,"postgres","aeppos",2780,"192.168.10.19:50935",5205dd5b.adc,352788,"INSERT",2013-08-10 11:57:39 IST,5/129358,0,LOG,00000,"PARSE ANALYSIS STATISTICS","! system usage stats: ! 0.000000 elapsed 0.000000 user 0.000000 system sec ! [43.227877 user 19.250523 sys total]",,,,,"insert into loginmaster (loginid,fullname,empid,passwd) values ( 'login88193', 'fullname88193', 'empid88193', 'passwd88193')",,,"" 2013-08-10 11:59:27.032 IST,"postgres","aeppos",2780,"192.168.10.19:50935",5205dd5b.adc,352789,"INSERT",2013-08-10 11:57:39 IST,5/129358,0,LOG,00000,"REWRITER STATISTICS","! system usage stats: ! 0.000000 elapsed 0.000000 user 0.000000 system sec ! [43.227877 user 19.250523 sys total]",,,,,"insert into loginmaster (loginid,fullname,empid,passwd) values ( 'login88193', 'fullname88193', 'empid88193', 'passwd88193')",,,"" --- as you can see it is for a single record "login88193" it places PARSER STATISTICS PARSE ANALYSIS STATISTICS REWRITER STATISTICS I know it appers because i have enabled log_parser_* options in log But what i request to know is the meaning of these statistics and how usefull is can be for a server load evaluation thanking you greetings from india arvind |
