Re: Postgres 9.3 beta log - Mailing list pgsql-general

From Bruce Momjian
Subject Re: Postgres 9.3 beta log
Date
Msg-id 20130810210442.GH30558@momjian.us
Whole thread Raw
In response to Re: Postgres 9.3 beta log  (Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>)
List pgsql-general
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. +


pgsql-general by date:

Previous
From: "ascot.moss@gmail.com"
Date:
Subject: Replication delay
Next
From: Tom Lane
Date:
Subject: Re: Convincing the query planner to play nice