Re: Postgres 9.3 beta log

On Sat, Aug 10, 2013 at 09:52:48PM +0200, Stefan Kaltenbrunner wrote:
> On 08/10/2013 04:21 PM, Bruce Momjian wrote:
> > On Sat, Aug 10, 2013 at 06:38:57AM +0000, Arvind Singh wrote:
> >> 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
> >
> > You should look get the getrusage manual pages for the meaning of the
> > values, and perhaps this for the meaning of these stages of a query:
> >
> >     http://www.postgresql.org/developer/backend/
>
> true - but it seems a bit dubious that all of them show basically zero
> (or a constant time)

Yes, in an ideal world, the majority of time should be spent in the
executor.  Those earlier stages are designed to set thing up for the
executor.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +