On Tue, 26 Aug 2003, Neil Conway wrote:
>
> Would it be possible to get a profile (e.g. gprof output) for a postgres
> backend executing the query on the Sun machine?
>
Heh. Never thought of doing a profile!
I attached the entire gprof output, but here's the top few functions.
I did the test, 1 beater, 100 searches: 148 seconds total.
30.9 45.55 45.55 nocachegetattr [16]
16.0 69.20 23.65 internal_mcount [22]
6.9 79.37 10.17 5245902 0.00 0.00 heapgettup [21]
6.0 88.28 8.91 3663201 0.00 0.00
ExecMakeFunctionResult
<cycle 5> [23]
5.4 96.27 7.99 11431400 0.00 0.00 ExecEvalVar [25]
3.0 100.73 4.46 18758201 0.00 0.00 ExecEvalExpr
<cycle 5
> [24]
3.0 105.17 4.44 5246005 0.00 0.00 AllocSetReset [29]
2.5 108.89 3.72 5245700 0.00 0.00
HeapTupleSatisfiesSnapshot
[30]
2.0 111.78 2.89 5650632 0.00 0.00 LWLockRelease [32]
1.6 114.10 2.32 5650632 0.00 0.00 LWLockAcquire [34]
1.6 116.40 2.30 5245800 0.00 0.01 SeqNext [17]
1.4 118.54 2.14 5438301 0.00 0.00 ExecStoreTuple [27]
1.4 120.62 2.08 5245700 0.00 0.01 ExecQual [18]
1.3 122.50 1.88 5379202 0.00 0.00 ReleaseAndReadBuffer
[35]
1.1 124.16 1.66 178400 0.01 0.40 ExecScan [15]
1.1 125.80 1.64 _mcount (6247)
1.1 127.41 1.61 5245902 0.00 0.01 heap_getnext [20]
.. as it turns out the profile gzipped is still huge (100kb) so I put it
on my web server - snag it at
http://www.jefftrout.com/~threshar/postgres/postgres-7.3.4-sol8-gprof.txt.gz
I'll do a profile for hte p2 and send post that in an hour or two
--
Jeff Trout <jeff@jefftrout.com>
http://www.jefftrout.com/
http://www.stuarthamm.net/
