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@xxxxxxxxxx> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
