Postgres 9.3 beta log

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

Responses

Browse pgsql-general by date

  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

Browse pgsql-hackers by date

  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