perf.main.O3.data.out
application/octet-stream
Filename: perf.main.O3.data.out
Type: application/octet-stream
Part: 1
# To display the perf.data header info, please use --header/--header-only options.
#
# dso: postgres
#
# Total Lost Samples: 0
#
# Samples: 1K of event 'cpu_core/cycles/P'
# Event count (approx.): 1008540817
#
# Children Self Command Symbol
# ........ ........ ........ .......................................
#
66.67% 0.00% postgres [.] standard_ProcessUtility
|
---standard_ProcessUtility
ExecVacuum
vacuum
vac_update_datfrozenxid
|
|--61.89%--systable_getnext
| |
| |--57.70%--table_scan_getnextslot (inlined)
| | |
| | --55.92%--heap_getnextslot
| | |
| | |--48.88%--heapgettup_pagemode
| | | |
| | | |--35.43%--heap_fetch_next_buffer (inlined)
| | | | |
| | | | --34.89%--read_stream_next_buffer
| | | | |
| | | | |--28.60%--WaitReadBuffers
| | | | | |
| | | | | |--26.88%--mdreadv
| | | | | | FileReadV
| | | | | | |
| | | | | | --26.82%--pg_preadv (inlined)
| | | | | | |
| | | | | | |--13.60%--pread (inlined)
| | | | | | | |
| | | | | | | --13.55%--__libc_pread64 (inlined)
| | | | | | | entry_SYSCALL_64_after_hwframe
| | | | | | | do_syscall_64
| | | | | | | |
| | | | | | | --13.44%--x64_sys_call
| | | | | | | __x64_sys_pread64
| | | | | | | |
| | | | | | | --13.39%--vfs_read
| | | | | | | |
| | | | | | | --13.33%--ext4_file_read_iter
| | | | | | | generic_file_read_iter
| | | | | | | |
| | | | | | | --13.06%--filemap_read
| | | | | | | |
| | | | | | | |--11.40%--copy_page_to_iter
| | | | | | | | |
| | | | | | | | --11.29%--_copy_to_iter
| | | | | | | |
| | | | | | | --0.97%--filemap_get_pages
| | | | | | | |
| | | | | | | --0.86%--filemap_get_read_batch
| | | | | | |
| | | | | | --13.22%--__GI_preadv64 (inlined)
| | | | | | |
| | | | | | --13.12%--entry_SYSCALL_64_after_hwframe
| | | | | | do_syscall_64
| | | | | | |
| | | | | | --13.06%--x64_sys_call
| | | | | | __x64_sys_preadv
| | | | | | vfs_readv
| | | | | | do_iter_readv_writev
| | | | | | ext4_file_read_iter
| | | | | | generic_file_read_iter
| | | | | | |
| | | | | | --12.96%--filemap_read
| | | | | | |
| | | | | | --11.83%--copy_page_to_iter
| | | | | | |
| | | | | | --11.67%--_copy_to_iter
| | | | | |
| | | | | |--0.70%--TerminateBufferIO (inlined)
| | | | | |
| | | | | --0.70%--WaitReadBuffersCanStartIO (inlined)
| | | | | WaitReadBuffersCanStartIO (inlined)
| | | | | StartBufferIO (inlined)
| | | | |
| | | | --5.76%--read_stream_start_pending_read
| | | | |
| | | | --5.70%--StartReadBuffers
| | | | StartReadBuffersImpl (inlined)
| | | | |
| | | | --5.60%--PinBufferForBlock (inlined)
| | | | |
| | | | --5.54%--BufferAlloc (inlined)
| | | | |
| | | | |--2.42%--GetVictimBuffer
| | | | | |
| | | | | --1.88%--InvalidateVictimBuffer
| | | | |
| | | | |--0.92%--LWLockAcquire
| | | | | |
| | | | | --0.70%--LWLockAttemptLock (inlined)
| | | | | |
| | | | | --0.54%--pg_atomic_compare_exchange_u32 (inlined)
| | | | | pg_atomic_compare_exchange_u32_impl (inlined)
| | | | |
| | | | --0.54%--ReservePrivateRefCountEntry (inlined)
| | | |
| | | |--9.41%--heap_prepare_pagescan
| | | | |
| | | | |--8.61%--page_collect_tuples (inlined)
| | | | | |
| | | | | |--3.93%--HeapTupleSatisfiesVisibility
| | | | | | |
| | | | | | --2.31%--HeapTupleSatisfiesMVCC (inlined)
| | | | | | |
| | | | | | --1.08%--XidInMVCCSnapshot
| | | | | | |
| | | | | | --0.75%--TransactionIdPrecedes
| | | | | |
| | | | | |--0.86%--PageGetItem (inlined)
| | | | | |
| | | | | --0.81%--ItemPointerSet (inlined)
| | | | | BlockIdSet (inlined)
| | | | |
| | | | --0.59%--LWLockAcquire
| | | | |
| | | | --0.54%--LWLockAttemptLock (inlined)
| | | |
| | | |--0.81%--PageGetItem (inlined)
| | | |
| | | --0.54%--ItemPointerSet (inlined)
| | | BlockIdSet (inlined)
| | |
| | --6.35%--ExecStoreBufferHeapTuple
| | tts_buffer_heap_store_tuple (inlined)
| | |
| | |--1.40%--IncrBufferRefCount
| | | |
| | | --1.24%--GetPrivateRefCountEntry
| | | |
| | | --0.54%--hash_search_with_hash_value
| | |
| | |--0.65%--ReleaseBuffer
| | | |
| | | --0.59%--UnpinBuffer (inlined)
| | |
| | --0.59%--UnpinBufferNoOwner
| |
| --1.08%--ExecFetchSlotHeapTuple
|
|--1.40%--MultiXactIdPrecedes
|
--1.02%--TransactionIdPrecedes
10.28% 5.54% postgres [.] heap_prepare_pagescan
|
|--4.95%--_start
| __libc_start_main_impl (inlined)
| __libc_start_call_main
| main
| PostmasterMain
| ServerLoop (inlined)
| BackendStartup (inlined)
| postmaster_child_launch
| BackendMain
| PostgresMain
| exec_simple_query
| PortalRun
| PortalRunMulti
| PortalRunUtility
| standard_ProcessUtility
| ExecVacuum
| vacuum
| vac_update_datfrozenxid
| systable_getnext
| table_scan_getnextslot (inlined)
| heap_getnextslot
| heapgettup_pagemode
| heap_prepare_pagescan
| |
| --4.79%--page_collect_tuples (inlined)
| |
| |--0.86%--PageGetItem (inlined)
| |
| --0.81%--ItemPointerSet (inlined)
| BlockIdSet (inlined)
|
--4.73%--heap_prepare_pagescan
|
|--4.04%--page_collect_tuples (inlined)
| |
| --3.98%--HeapTupleSatisfiesVisibility
| |
| --2.31%--HeapTupleSatisfiesMVCC (inlined)
| |
| --1.08%--XidInMVCCSnapshot
| |
| --0.75%--TransactionIdPrecedes
|
--0.64%--LWLockAcquire
|
--0.54%--LWLockAttemptLock (inlined)
9.31% 0.00% postgres [.] page_collect_tuples (inlined)
|
---page_collect_tuples (inlined)
|
|--3.98%--HeapTupleSatisfiesVisibility
| |
| --2.31%--HeapTupleSatisfiesMVCC (inlined)
| |
| --1.08%--XidInMVCCSnapshot
| |
| --0.75%--TransactionIdPrecedes
|
|--0.86%--PageGetItem (inlined)
|
--0.81%--ItemPointerSet (inlined)
BlockIdSet (inlined)
6.99% 4.25% postgres [.] ExecStoreBufferHeapTuple
|
|--3.71%--_start
| __libc_start_main_impl (inlined)
| __libc_start_call_main
| main
| PostmasterMain
| ServerLoop (inlined)
| BackendStartup (inlined)
| postmaster_child_launch
| BackendMain
| PostgresMain
| exec_simple_query
| PortalRun
| PortalRunMulti
| PortalRunUtility
| standard_ProcessUtility
| ExecVacuum
| vacuum
| vac_update_datfrozenxid
| systable_getnext
| table_scan_getnextslot (inlined)
| heap_getnextslot
| |
| |--3.07%--ExecStoreBufferHeapTuple
| | tts_buffer_heap_store_tuple (inlined)
| |
| --0.64%--0x55ba8b09a62d
| 0x55ba8b09a62d
|
--2.96%--0x55ba8b09a6a4
|
--2.69%--0x55ba8b09a6a4
|
|--1.40%--0x55ba8b23083b
| |
| --1.24%--0x55ba8b22c09d
|
|--0.65%--0x55ba8b23075b
| |
| --0.59%--0x55ba8b23075b
|
--0.54%--0x55ba8b22e1d3
6.81% 5.74% postgres [.] HeapTupleSatisfiesVisibility
|
|--2.91%--_start
| __libc_start_main_impl (inlined)
| __libc_start_call_main
| main
| PostmasterMain
| ServerLoop (inlined)
| BackendStartup (inlined)
| postmaster_child_launch
| BackendMain
| PostgresMain
| exec_simple_query
| PortalRun
| PortalRunMulti
| PortalRunUtility
| standard_ProcessUtility
| ExecVacuum
| vacuum
| vac_update_datfrozenxid
| systable_getnext
| table_scan_getnextslot (inlined)
| heap_getnextslot
| heapgettup_pagemode
| heap_prepare_pagescan
| page_collect_tuples (inlined)
| |
| |--2.31%--0x55ba8af0e283
| | |
| | --0.97%--0x55ba8af0e2b5
| |
| --0.54%--0x55ba8af0e542
|
|--1.08%--0x55ba8af0e29e
| 0x55ba8af0e29e
| 0x55ba8b4484aa
| |
| --0.75%--0x55ba8af53fcb
|
|--1.08%--0x55ba8cdd0bef
| |
| --1.02%--0x55ba8af0e29a
| |
| --0.54%--0x55ba8af0e29a
|
--0.75%--0x55ba8b48158b
HeapTupleSatisfiesVisibility
6.45% 0.00% postgres [.] tts_buffer_heap_store_tuple (inlined)
|
---tts_buffer_heap_store_tuple (inlined)
|
|--1.45%--IncrBufferRefCount
| |
| --1.29%--GetPrivateRefCountEntry
| |
| --0.54%--hash_search_with_hash_value
|
|--0.65%--ReleaseBuffer
| |
| --0.59%--UnpinBuffer (inlined)
|
--0.59%--UnpinBufferNoOwner
5.97% 0.05% postgres [.] read_stream_start_pending_read
|
--5.92%--read_stream_start_pending_read
StartReadBuffers
StartReadBuffersImpl (inlined)
|
--5.81%--PinBufferForBlock (inlined)
|
--5.76%--BufferAlloc (inlined)
|
|--2.53%--GetVictimBuffer
| |
| --1.94%--InvalidateVictimBuffer
| |
| --0.54%--BufTableDelete
|
|--0.97%--LWLockAcquire
| |
| --0.75%--LWLockAttemptLock (inlined)
| |
| --0.59%--pg_atomic_compare_exchange_u32 (inlined)
| pg_atomic_compare_exchange_u32_impl (inlined)
|
|--0.54%--BufTableInsert
|
--0.54%--ReservePrivateRefCountEntry (inlined)
5.92% 0.65% postgres [.] StartReadBuffers
|
|--5.27%--StartReadBuffers
| StartReadBuffersImpl (inlined)
| PinBufferForBlock (inlined)
| BufferAlloc (inlined)
| |
| |--2.53%--GetVictimBuffer
| | |
| | --1.94%--InvalidateVictimBuffer
| | |
| | --0.54%--BufTableDelete
| |
| |--0.97%--LWLockAcquire
| | |
| | --0.75%--LWLockAttemptLock (inlined)
| | |
| | --0.59%--pg_atomic_compare_exchange_u32 (inlined)
| | pg_atomic_compare_exchange_u32_impl (inlined)
| |
| --0.54%--BufTableInsert
|
--0.65%--_start
__libc_start_main_impl (inlined)
__libc_start_call_main
main
PostmasterMain
ServerLoop (inlined)
BackendStartup (inlined)
postmaster_child_launch
BackendMain
PostgresMain
exec_simple_query
PortalRun
PortalRunMulti
PortalRunUtility
standard_ProcessUtility
ExecVacuum
vacuum
vac_update_datfrozenxid
systable_getnext
table_scan_getnextslot (inlined)
heap_getnextslot
heapgettup_pagemode
heap_fetch_next_buffer (inlined)
read_stream_next_buffer
read_stream_start_pending_read
StartReadBuffers
StartReadBuffersImpl (inlined)
|
--0.54%--PinBufferForBlock (inlined)
5.92% 0.00% postgres [.] StartReadBuffersImpl (inlined)
|
---StartReadBuffersImpl (inlined)
|
--5.81%--PinBufferForBlock (inlined)
|
--5.76%--BufferAlloc (inlined)
|
|--2.53%--GetVictimBuffer
| |
| --1.94%--InvalidateVictimBuffer
| |
| --0.54%--BufTableDelete
|
|--0.97%--LWLockAcquire
| |
| --0.75%--LWLockAttemptLock (inlined)
| |
| --0.59%--pg_atomic_compare_exchange_u32 (inlined)
| pg_atomic_compare_exchange_u32_impl (inlined)
|
|--0.54%--BufTableInsert
|
--0.54%--ReservePrivateRefCountEntry (inlined)
5.81% 0.00% postgres [.] PinBufferForBlock (inlined)
|
---PinBufferForBlock (inlined)
|
--5.76%--BufferAlloc (inlined)
|
|--2.53%--GetVictimBuffer
| |
| --1.94%--InvalidateVictimBuffer
| |
| --0.54%--BufTableDelete
|
|--0.97%--LWLockAcquire
| |
| --0.75%--LWLockAttemptLock (inlined)
| |
| --0.59%--pg_atomic_compare_exchange_u32 (inlined)
| pg_atomic_compare_exchange_u32_impl (inlined)
|
|--0.54%--BufTableInsert
|
--0.54%--ReservePrivateRefCountEntry (inlined)
5.76% 0.00% postgres [.] BufferAlloc (inlined)
|
---BufferAlloc (inlined)
|
|--2.53%--GetVictimBuffer
| |
| --1.94%--InvalidateVictimBuffer
| |
| --0.54%--BufTableDelete
|
|--0.97%--LWLockAcquire
| |
| --0.75%--LWLockAttemptLock (inlined)
| |
| --0.59%--pg_atomic_compare_exchange_u32 (inlined)
| pg_atomic_compare_exchange_u32_impl (inlined)
|
|--0.54%--BufTableInsert
|
--0.54%--ReservePrivateRefCountEntry (inlined)
4.52% 0.00% postgres [.] 0x00000000000002da
|
---0x2da
|
|--2.48%--systable_getnext
| |
| --0.75%--table_scan_getnextslot (inlined)
|
--1.88%--heap_getnextslot
4.03% 4.03% postgres [.] TransactionIdPrecedes
|
|--1.94%--_start
| __libc_start_main_impl (inlined)
| __libc_start_call_main
| main
| PostmasterMain
| ServerLoop (inlined)
| BackendStartup (inlined)
| postmaster_child_launch
| BackendMain
| PostgresMain
| exec_simple_query
| PortalRun
| PortalRunMulti
| PortalRunUtility
| standard_ProcessUtility
| ExecVacuum
| vacuum
| vac_update_datfrozenxid
| |
| |--1.18%--TransactionIdPrecedes
| |
| --0.75%--systable_getnext
| table_scan_getnextslot (inlined)
| heap_getnextslot
| heapgettup_pagemode
| heap_prepare_pagescan
| page_collect_tuples (inlined)
| HeapTupleSatisfiesVisibility
| HeapTupleSatisfiesMVCC (inlined)
| XidInMVCCSnapshot
| TransactionIdPrecedes
|
|--1.08%--0x7c0e74a3859f
| TransactionIdPrecedes
|
--0.54%--0x7c0e6b8c1fff
TransactionIdPrecedes
3.50% 0.00% postgres [.] 0x00007c0e74a3859f
|
---0x7c0e74a3859f
|
|--1.14%--MultiXactIdPrecedes
|
|--1.13%--systable_getnext
|
--1.08%--TransactionIdPrecedes
2.85% 2.10% postgres [.] XidInMVCCSnapshot
|
--0.75%--XidInMVCCSnapshot
TransactionIdPrecedes
2.85% 0.00% postgres [.] HeapTupleSatisfiesMVCC (inlined)
|
---HeapTupleSatisfiesMVCC (inlined)
|
--1.08%--XidInMVCCSnapshot
|
--0.75%--TransactionIdPrecedes
2.69% 0.00% postgres [.] 0x000000000268776f
|
---0x268776f
|
|--1.02%--heap_getnextslot
|
|--0.75%--tts_buffer_heap_get_heap_tuple
|
--0.64%--ExecFetchSlotHeapTuple
2.64% 2.64% postgres [.] MultiXactIdPrecedes
|
|--1.50%--_start
| __libc_start_main_impl (inlined)
| __libc_start_call_main
| main
| PostmasterMain
| ServerLoop (inlined)
| BackendStartup (inlined)
| postmaster_child_launch
| BackendMain
| PostgresMain
| exec_simple_query
| PortalRun
| PortalRunMulti
| PortalRunUtility
| standard_ProcessUtility
| ExecVacuum
| vacuum
| vac_update_datfrozenxid
| MultiXactIdPrecedes
|
--1.14%--0x7c0e74a3859f
MultiXactIdPrecedes
2.53% 0.05% postgres [.] GetVictimBuffer
|
--2.26%--0x55ba8b23253a
|
--1.88%--0x55ba8b22d9df
2.37% 2.37% postgres [.] LWLockAcquire
|
--1.99%--_start
__libc_start_main_impl (inlined)
__libc_start_call_main
main
PostmasterMain
ServerLoop (inlined)
BackendStartup (inlined)
postmaster_child_launch
BackendMain
PostgresMain
exec_simple_query
PortalRun
PortalRunMulti
PortalRunUtility
standard_ProcessUtility
ExecVacuum
vacuum
vac_update_datfrozenxid
systable_getnext
table_scan_getnextslot (inlined)
heap_getnextslot
heapgettup_pagemode
|
|--1.02%--0x55ba8af08fe3
| 0x55ba8b22b3f2
| 0x55ba8b22add8
| 0x55ba8b2329cf
| 0x55ba8b2329cf
| 0x55ba8b2329cf
| 0x55ba8b2329cf
| |
| --0.65%--0x55ba8b25f783
|
--0.64%--heap_prepare_pagescan
2.26% 1.99% postgres [.] hash_search_with_hash_value
|
--1.67%--_start
__libc_start_main_impl (inlined)
__libc_start_call_main
main
PostmasterMain
ServerLoop (inlined)
BackendStartup (inlined)
postmaster_child_launch
BackendMain
PostgresMain
exec_simple_query
PortalRun
PortalRunMulti
PortalRunUtility
standard_ProcessUtility
ExecVacuum
vacuum
vac_update_datfrozenxid
systable_getnext
table_scan_getnextslot (inlined)
|
--1.56%--heap_getnextslot
|
--1.13%--heapgettup_pagemode
heap_fetch_next_buffer (inlined)
read_stream_next_buffer
read_stream_start_pending_read
StartReadBuffers
StartReadBuffersImpl (inlined)
PinBufferForBlock (inlined)
BufferAlloc (inlined)
2.04% 0.48% postgres [.] InvalidateVictimBuffer
|
--1.51%--0x55ba8b22d9df
1.83% 1.83% postgres [.] ExecFetchSlotHeapTuple
|
|--1.13%--_start
| __libc_start_main_impl (inlined)
| __libc_start_call_main
| main
| PostmasterMain
| ServerLoop (inlined)
| BackendStartup (inlined)
| postmaster_child_launch
| BackendMain
| PostgresMain
| exec_simple_query
| PortalRun
| PortalRunMulti
| PortalRunUtility
| standard_ProcessUtility
| ExecVacuum
| vacuum
| vac_update_datfrozenxid
| systable_getnext
| |
| --1.08%--0x55ba8b09ac53
|
--0.64%--0x268776f
0x55ba8b09ac7a
1.56% 0.00% postgres [.] LWLockAttemptLock (inlined)
|
---LWLockAttemptLock (inlined)
|
--1.24%--pg_atomic_compare_exchange_u32 (inlined)
pg_atomic_compare_exchange_u32_impl (inlined)
1.56% 0.22% postgres [.] IncrBufferRefCount
|
--1.34%--IncrBufferRefCount
|
--1.29%--GetPrivateRefCountEntry
1.29% 0.32% postgres [.] GetPrivateRefCountEntry
|
--0.97%--GetPrivateRefCountEntry
1.24% 0.00% postgres [.] pg_atomic_compare_exchange_u32 (inlined)
|
---pg_atomic_compare_exchange_u32 (inlined)
pg_atomic_compare_exchange_u32_impl (inlined)
1.24% 0.00% postgres [.] pg_atomic_compare_exchange_u32_impl (inlined)
|
---pg_atomic_compare_exchange_u32_impl (inlined)
1.18% 0.00% postgres [.] 0x000055ba8cdd0bef
|
---0x55ba8cdd0bef
|
--1.08%--HeapTupleSatisfiesVisibility
|
--0.54%--HeapTupleSatisfiesMVCC (inlined)
1.13% 1.13% postgres [.] LWLockRelease
|
--1.07%--_start
__libc_start_main_impl (inlined)
__libc_start_call_main
main
PostmasterMain
ServerLoop (inlined)
BackendStartup (inlined)
postmaster_child_launch
BackendMain
PostgresMain
exec_simple_query
PortalRun
PortalRunMulti
PortalRunUtility
standard_ProcessUtility
ExecVacuum
vacuum
vac_update_datfrozenxid
systable_getnext
table_scan_getnextslot (inlined)
heap_getnextslot
heapgettup_pagemode
|
--0.64%--0x55ba8af08fe3
0x55ba8b22b3f2
0x55ba8b22add8
0x55ba8b232adf
0x55ba8b232adf
0x55ba8b232adf
0x55ba8b232adf
1.02% 0.70% postgres [.] UnpinBufferNoOwner
|
--0.54%--_start
__libc_start_main_impl (inlined)
__libc_start_call_main
main
PostmasterMain
ServerLoop (inlined)
BackendStartup (inlined)
postmaster_child_launch
BackendMain
PostgresMain
exec_simple_query
PortalRun
PortalRunMulti
PortalRunUtility
standard_ProcessUtility
ExecVacuum
vacuum
vac_update_datfrozenxid
systable_getnext
table_scan_getnextslot (inlined)
heap_getnextslot
0.91% 0.00% postgres [.] TerminateBufferIO (inlined)
|
---TerminateBufferIO (inlined)
0.86% 0.00% postgres [.] PageGetItem (inlined)
|
---PageGetItem (inlined)
0.86% 0.00% postgres [.] PageGetItem (inlined)
|
---PageGetItem (inlined)
0.81% 0.38% postgres [.] ReleaseBuffer
0.81% 0.00% postgres [.] ItemPointerSet (inlined)
|
---ItemPointerSet (inlined)
BlockIdSet (inlined)
0.81% 0.00% postgres [.] BlockIdSet (inlined)
|
---BlockIdSet (inlined)
0.81% 0.38% postgres [.] hash_search
0.81% 0.00% postgres [.] StartBufferIO (inlined)
|
---StartBufferIO (inlined)
0.75% 0.00% postgres [.] 0x000055ba8b48158b
|
---0x55ba8b48158b
HeapTupleSatisfiesVisibility
0.75% 0.75% postgres [.] tts_buffer_heap_get_heap_tuple
|
---0x268776f
tts_buffer_heap_get_heap_tuple
0.75% 0.00% postgres [.] WaitReadBuffersCanStartIO (inlined)
|
---WaitReadBuffersCanStartIO (inlined)
WaitReadBuffersCanStartIO (inlined)
StartBufferIO (inlined)
0.70% 0.70% postgres [.] ResourceOwnerForget
|
--0.65%--_start
__libc_start_main_impl (inlined)
__libc_start_call_main
main
PostmasterMain
ServerLoop (inlined)
BackendStartup (inlined)
postmaster_child_launch
BackendMain
PostgresMain
exec_simple_query
PortalRun
PortalRunMulti
PortalRunUtility
standard_ProcessUtility
ExecVacuum
vacuum
vac_update_datfrozenxid
systable_getnext
table_scan_getnextslot (inlined)
heap_getnextslot
0.70% 0.00% postgres [.] pg_atomic_sub_fetch_u32 (inlined)
|
---pg_atomic_sub_fetch_u32 (inlined)
pg_atomic_sub_fetch_u32_impl (inlined)
pg_atomic_fetch_sub_u32_impl (inlined)
0.70% 0.00% postgres [.] pg_atomic_sub_fetch_u32_impl (inlined)
|
---pg_atomic_sub_fetch_u32_impl (inlined)
pg_atomic_fetch_sub_u32_impl (inlined)
0.70% 0.00% postgres [.] pg_atomic_fetch_sub_u32_impl (inlined)
|
---pg_atomic_fetch_sub_u32_impl (inlined)
0.65% 0.00% postgres [.] UnpinBuffer (inlined)
|
---UnpinBuffer (inlined)
0.59% 0.00% postgres [.] ItemPointerSet (inlined)
|
---ItemPointerSet (inlined)
BlockIdSet (inlined)
0.59% 0.00% postgres [.] BlockIdSet (inlined)
|
---BlockIdSet (inlined)
0.59% 0.11% postgres [.] BufTableDelete
0.59% 0.00% postgres [.] 0x00007c0e6b8c1fff
|
---0x7c0e6b8c1fff
|
--0.54%--TransactionIdPrecedes
0.59% 0.11% postgres [.] BufTableInsert
0.54% 0.54% postgres [.] hash_bytes
|
---_start
__libc_start_main_impl (inlined)
__libc_start_call_main
main
PostmasterMain
ServerLoop (inlined)
BackendStartup (inlined)
postmaster_child_launch
BackendMain
PostgresMain
exec_simple_query
PortalRun
PortalRunMulti
PortalRunUtility
standard_ProcessUtility
ExecVacuum
vacuum
vac_update_datfrozenxid
systable_getnext
table_scan_getnextslot (inlined)
heap_getnextslot
heapgettup_pagemode
heap_fetch_next_buffer (inlined)
read_stream_next_buffer
read_stream_start_pending_read
StartReadBuffers
StartReadBuffersImpl (inlined)
PinBufferForBlock (inlined)
BufferAlloc (inlined)
0.54% 0.00% postgres [.] ReservePrivateRefCountEntry (inlined)
|
---ReservePrivateRefCountEntry (inlined)
0.48% 0.00% postgres [.] ResourceOwnerForgetBuffer (inlined)
0.48% 0.16% postgres [.] StrategyGetBuffer
0.48% 0.00% postgres [.] 0x00007c0e6b8e1fff
0.48% 0.48% postgres [.] uint32_hash
0.48% 0.48% postgres [.] StartBufferIO.constprop.0
0.48% 0.00% postgres [.] LockBufHdr (inlined)
0.43% 0.00% postgres [.] BufferGetPage (inlined)
0.43% 0.00% postgres [.] BufferGetBlock (inlined)
0.43% 0.00% postgres [.] 0x00007c0e6b8edfff
0.43% 0.00% postgres [.] GetBufferFromRing (inlined)
0.43% 0.00% postgres [.] LockBufHdr (inlined)
0.43% 0.00% postgres [.] pg_atomic_fetch_or_u32 (inlined)
0.43% 0.00% postgres [.] pg_atomic_fetch_or_u32_impl (inlined)
0.43% 0.00% postgres [.] hash_bytes_uint32 (inlined)
0.43% 0.43% postgres [.] ResourceOwnerEnlarge
0.38% 0.00% postgres [.] 0x000055ba8cd9127f
0.38% 0.00% postgres [.] LockBufHdr (inlined)
0.38% 0.38% postgres [.] GetPrivateRefCountEntry.constprop.0
0.38% 0.00% postgres [.] GetPrivateRefCountEntry (inlined)
0.38% 0.00% postgres [.] pg_atomic_fetch_or_u32 (inlined)
0.38% 0.00% postgres [.] pg_atomic_fetch_or_u32_impl (inlined)
0.32% 0.00% postgres [.] 0x00007c0e6b8cdfff
0.32% 0.27% postgres [.] LockBufHdr
0.32% 0.00% postgres [.] get_hash_entry (inlined)
0.27% 0.00% postgres [.] pg_atomic_compare_exchange_u32 (inlined)
0.27% 0.00% postgres [.] pg_atomic_compare_exchange_u32_impl (inlined)
0.27% 0.00% postgres [.] pg_rotate_left32 (inlined)
0.27% 0.00% postgres [.] tas (inlined)
0.27% 0.00% postgres [.] pg_atomic_fetch_or_u32 (inlined)
0.27% 0.00% postgres [.] pg_atomic_fetch_or_u32_impl (inlined)
0.27% 0.21% postgres [.] PageIsVerifiedExtended
0.27% 0.00% postgres [.] ResourceOwnerAddToHash (inlined)
0.22% 0.00% postgres [.] pg_atomic_read_u32 (inlined)
0.22% 0.00% postgres [.] pg_atomic_read_u32_impl (inlined)
0.22% 0.00% postgres [.] pg_rotate_left32 (inlined)
0.22% 0.00% postgres [.] pg_atomic_fetch_or_u32 (inlined)
0.22% 0.00% postgres [.] pg_atomic_fetch_or_u32_impl (inlined)
0.22% 0.00% postgres [.] 0x000055ba8cdd11e7
0.22% 0.00% postgres [.] 0x000040000000067e
0.21% 0.00% postgres [.] ResourceOwnerForgetBufferIO (inlined)
0.21% 0.00% postgres [.] 0x000055ba8cd915c7
0.21% 0.00% postgres [.] 0xffffffffffffffff
0.21% 0.16% postgres [.] read_stream_look_ahead
0.16% 0.00% postgres [.] 0x000055ba8cdd095f
0.16% 0.00% postgres [.] 0x00007fffb2cc4c3a
0.16% 0.00% postgres [.] hash_initial_lookup (inlined)
0.16% 0.00% postgres [.] 0x00007c0e6b8effff
0.16% 0.00% postgres [.] LockBufHdr (inlined)
0.16% 0.00% postgres [.] pg_atomic_fetch_or_u32 (inlined)
0.16% 0.00% postgres [.] pg_atomic_fetch_or_u32_impl (inlined)
0.16% 0.00% postgres [.] hash_resource_elem (inlined)
0.16% 0.16% postgres [.] finish_spin_delay
0.11% 0.00% postgres [.] PinBuffer_Locked (inlined)
0.11% 0.11% postgres [.] ResourceOwnerRemember
0.11% 0.00% postgres [.] 0x000000000000001b
0.11% 0.00% postgres [.] UnlockBufHdr (inlined)
0.11% 0.00% postgres [.] pg_atomic_write_u32 (inlined)
0.11% 0.00% postgres [.] pg_atomic_write_u32_impl (inlined)
0.11% 0.00% postgres [.] 0x000000000000001e
0.11% 0.00% postgres [.] 0x00007c0e6b8d1fff
0.11% 0.00% postgres [.] BufTableLookup
0.11% 0.11% postgres [.] BufferGetBlockNumber
0.11% 0.11% postgres [.] DataChecksumsEnabled
0.11% 0.00% postgres [.] 0x000000000000000d
0.11% 0.00% postgres [.] 0x0000000000000004
0.11% 0.00% postgres [.] 0x0000000000000024
0.11% 0.00% postgres [.] 0x000055ba00000000
0.11% 0.00% postgres [.] hash_resource_elem (inlined)
0.11% 0.00% postgres [.] hash_combine64 (inlined)
0.11% 0.00% postgres [.] 0x000055ba0000000f
0.11% 0.11% postgres [.] ConditionVariableBroadcast
0.11% 0.00% postgres [.] tas (inlined)
0.11% 0.00% postgres [.] murmurhash64 (inlined)
0.06% 0.00% postgres [.] 0x00007c0e6b8bacbf
0.06% 0.00% postgres [.] ResourceOwnerRememberBuffer (inlined)
0.05% 0.00% postgres [.] 0x00007c0e6b8c3fff
0.05% 0.00% postgres [.] 0x00007c0e6b8bd39f
0.05% 0.00% postgres [.] GetBufferDescriptor (inlined)
0.05% 0.00% postgres [.] 0x00007fffb2cc4e2b
0.05% 0.00% postgres [.] 0x00007c0e6b8dffff
0.05% 0.00% postgres [.] expand_table (inlined)
0.05% 0.00% postgres [.] calc_bucket (inlined)
0.05% 0.00% postgres [.] 0x00007c0e6b8f7b2f
0.05% 0.00% postgres [.] GetBufferDescriptor (inlined)
0.05% 0.00% postgres [.] 0x00007c0e6b8c944f
0.05% 0.00% postgres [.] BufferGetPage (inlined)
0.05% 0.00% postgres [.] BufferGetBlock (inlined)
0.05% 0.00% postgres [.] hash_combine64 (inlined)
0.05% 0.05% postgres [.] ReservePrivateRefCountEntry
0.05% 0.00% postgres [.] 0x00007c0e6b8f3fff
0.05% 0.00% postgres [.] pg_atomic_read_u32 (inlined)
0.05% 0.00% postgres [.] pg_atomic_read_u32_impl (inlined)
0.05% 0.00% postgres [.] 0x0000000000000002
0.05% 0.00% postgres [.] BufMappingPartitionLock (inlined)
0.05% 0.00% postgres [.] BufferDescriptorGetBuffer (inlined)
0.05% 0.00% postgres [.] InitBufferTag (inlined)
0.05% 0.00% postgres [.] 0x00007c0e7383b087
0.05% 0.00% postgres [.] 0x000000000000000f
0.05% 0.00% postgres [.] 0x00007c0e6b8ebfff
0.05% 0.05% postgres [.] get_hash_value
0.05% 0.05% postgres [.] FileAccess
0.05% 0.00% postgres [.] BufferDescriptorGetIOCV (inlined)
0.05% 0.00% postgres [.] init_spin_delay (inlined)
0.05% 0.00% postgres [.] 0x00007c0e6b8ea31f
0.05% 0.05% postgres [.] heap_scan_stream_read_next_serial
0.05% 0.00% postgres [.] read_stream_get_block (inlined)
0.05% 0.00% postgres [.] 0x0000000000000025
0.05% 0.05% postgres [.] smgrreadv
0.05% 0.00% postgres [.] 0x00007c0e6b8bbfff
0.05% 0.00% postgres [.] UnlockBufHdr (inlined)
0.05% 0.00% postgres [.] 0x0000000000000012
0.05% 0.00% postgres [.] 0x000000000000001f
0.05% 0.00% postgres [.] 0x00007c0e6b8c5fff
0.05% 0.00% postgres [.] 0x00007c0e6b8d89ff
0.05% 0.00% postgres [.] ResourceOwnerRememberBuffer (inlined)
0.05% 0.00% postgres [.] 0x0000000000000021
0.05% 0.00% postgres [.] 0x00007fffb2cc4c27
0.05% 0.00% postgres [.] 0x00007c0e6b8bde9f
0.05% 0.00% postgres [.] 0x00007c0e6b8bffff
0.05% 0.00% postgres [.] 0x00007c0e6b8e5fff
0.05% 0.00% postgres [.] 0x000000000232d59e
0.05% 0.00% postgres [.] 0x00000000e4dd2f18
0.05% 0.05% postgres [.] heap_page_prune_opt
0.05% 0.00% postgres [.] 0x0000000000000017
0.05% 0.00% postgres [.] 0x000000000000001c
0.05% 0.00% postgres [.] 0x00007c0e6b8d9fff
0.05% 0.00% postgres [.] 0x00007c0e6b8f410f
0.05% 0.00% postgres [.] 0x000000000000001a
0.05% 0.00% postgres [.] 0x000055ba8cdd0917
0.05% 0.00% postgres [.] 0x0000000001b51ee3
0.05% 0.00% postgres [.] 0x00007c0e6b8d3fff
0.03% 0.00% postgres [.] 0x00007c0e6b8cbbdf
#
# (Cannot load tips.txt file, please install perf!)
#