"anarazel@anarazel.de" <andres@anarazel.de> wrote:
> Kevin Grittner <Kevin.Grittner@wicourts.gov> schrieb:
>>samples % image name symbol name
>>933394 4.9651 postgres AllocSetAlloc
>>848476 4.5134 postgres base_yyparse
>>719515 3.8274 postgres SearchCatCache
> That profile looks like you ran pgbench with -m simple. How does
> it look with prepared instead?
samples % image name symbol name
495463 3.6718 postgres hash_search_with_hash_value
490971 3.6385 postgres GetSnapshotData
443965 3.2902 postgres LWLockAcquire
443566 3.2872 postgres AllocSetAlloc
302388 2.2409 postgres XLogInsert
286889 2.1261 postgres SearchCatCache
246417 1.8262 postgres PostgresMain
235018 1.7417 postgres heap_page_prune
198442 1.4706 postgres _bt_compare
181446 1.3447 postgres hash_any
177131 1.3127 postgres ExecInitExpr
175775 1.3026 postgres LWLockRelease
152324 1.1288 postgres PinBuffer
150285 1.1137 postgres exec_bind_message
145214 1.0762 postgres fmgr_info_cxt_security
140493 1.0412 postgres s_lock
124162 0.9201 postgres LockAcquireExtended
120429 0.8925 postgres MemoryContextAlloc
117076 0.8676 postgres pfree
116493 0.8633 postgres AllocSetFree
105027 0.7783 postgres pgstat_report_activity
101407 0.7515 postgres ProcArrayLockAcquire
100797 0.7470 postgres MemoryContextAllocZeroAligned
98360 0.7289 postgres ProcArrayLockRelease
86938 0.6443 postgres heap_hot_search_buffer
82635 0.6124 postgres hash_search
79902 0.5921 postgres errstart
79465 0.5889 postgres HeapTupleSatisfiesVacuum
78709 0.5833 postgres ResourceOwnerReleaseInternal
76068 0.5637 postgres ExecModifyTable
73043 0.5413 postgres heap_update
72175 0.5349 postgres strlcpy
71253 0.5280 postgres MemoryContextAllocZero
tps = 27392.219364 (including connections establishing)
-Kevin