pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: CaptainX0r <captainx0r@yahoo.com>
To: pgsql-performance@postgresql.org
Subject: Re: Sun vs. Mac - gprof output
Date: Thu, 16 Jan 2003 05:45:02 -0800 (PST)
Message-ID: <20030116134502.36697.qmail@web21105.mail.yahoo.com> (raw)
In-Reply-To: <12202.1042697508@sss.pgh.pa.us>

> It'd not be surprising for libreadline to suck a good deal of the
> runtime of psql ... but I don't believe the backend will call it at all.
> So, either this trace is erroneous, or you profiled the wrong process
> (client instead of backend), or there's something truly weird going on.

You're right, I got the client, here's the backend:

   %  cumulative    self              self    total          
 time   seconds   seconds    calls  ms/call  ms/call name    
 23.4     125.31   125.31                            internal_mcount [13]
 21.2     239.07   113.76 79296415     0.00     0.00  ExecMakeFunctionResult   
<cycle 4> [14]
  7.8     280.68    41.61 98971658     0.00     0.00  AllocSetReset [23]
  6.8     317.13    36.45 193735603     0.00     0.00  ExecEvalVar [18]
  5.2     345.21    28.08 280731963     0.00     0.00  ExecEvalExpr     <cycle
4> [15]
  2.7     359.93    14.72 38140599     0.00     0.00  nocachegetattr [35]
  2.7     374.28    14.35   320207     0.04     0.04  _read [38]
  2.2     385.97    11.69 78969393     0.00     0.00  ExecQual  <cycle 4> [34]
  2.1     397.46    11.49 79296415     0.00     0.00  ExecEvalFuncArgs  <cycle
4> [42]
  1.4     404.71     7.25                            _mcount (6219)
  1.3     411.73     7.02 11293115     0.00     0.00  heapgettup [31]
  1.2     418.34     6.61 98975017     0.00     0.00  ExecClearTuple [43]
  1.0     423.93     5.59 98971592     0.00     0.00  ExecStoreTuple [33]
  0.9     428.87     4.94 197952332     0.00     0.00  MemoryContextSwitchTo
[53]
  0.9     433.53     4.66  7612547     0.00     0.00  heap_formtuple [39]
  0.8     437.96     4.43  7609318     0.00     0.01  ExecScanHashBucket       
<cycle 4> [17]
  0.8     442.34     4.38        8   547.50   547.50  .rem [55]
  0.8     446.64     4.30 79296261     0.00     0.00  ExecEvalOper      <cycle
4> [56]


I'm not sure what to make of this.

Thanks,

-X


__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com



view thread (3+ messages)

Message-ID: <20030116134502.36697.qmail@web21105.mail.yahoo.com>
Permalink:  ../20030116134502.36697.qmail@web21105.mail.yahoo.com/
Also on:    postgresql.org/message-id/20030116134502.36697.qmail@web21105.mail.yahoo.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-performance@postgresql.org
  Cc: captainx0r@yahoo.com
  Subject: Re: Sun vs. Mac - gprof output
  In-Reply-To: <20030116134502.36697.qmail@web21105.mail.yahoo.com>
  References: <12202.1042697508@sss.pgh.pa.us> <20030116134502.36697.qmail@web21105.mail.yahoo.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox