Re: Sun vs. Mac - gprof output

From: CaptainX0r <captainx0r(at)yahoo(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Sun vs. Mac - gprof output
Date: 2003-01-16 13:45:02
Message-ID: 20030116134502.36697.qmail@web21105.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message CaptainX0r 2003-01-16 13:51:40 schema/db design wrt performance
Previous Message Andrew Sullivan 2003-01-16 13:17:38 Re: 7.3.1 New install, large queries are slow