From: | Arvind Singh <arvindps(at)hotmail(dot)com> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Postgres 9.3 beta log |
Date: | 2013-08-10 06:38:57 |
Message-ID: | BLU164-W368B0A8EC78C52D901966BCA590@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Travers | 2013-08-10 06:44:05 | Re: How To Install Extension Via Script File? |
Previous Message | hamann.w | 2013-08-10 06:00:11 | Re: incremental dumps |
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2013-08-10 06:39:15 | proposal: lob conversion functionality |
Previous Message | Noah Misch | 2013-08-10 04:36:06 | Re: Proposal: leave a hint when switching logging away from stderr |