perf.main.O0.data.out
application/octet-stream
Filename: perf.main.O0.data.out
Type: application/octet-stream
Part: 3
# To display the perf.data header info, please use --header/--header-only options.
#
# dso: postgres
#
# Total Lost Samples: 0
#
# Samples: 44 of event 'cpu_atom/cycles/P'
# Event count (approx.): 13134405
#
# Children Self Command Symbol
# ........ ........ ........ ..................................
#
33.54% 0.00% postgres [.] heap_fetch_next_buffer
|
---heap_fetch_next_buffer
read_stream_next_buffer
|
|--19.58%--read_stream_look_ahead
| |
| --16.79%--read_stream_start_pending_read
| StartReadBuffers
| StartReadBuffersImpl
| PinBufferForBlock
| |
| |--13.99%--BufferAlloc
| | |
| | |--5.59%--BufTableInsert
| | | hash_search_with_hash_value
| | | |
| | | --2.80%--get_hash_entry
| | | tas
| | |
| | |--2.81%--BufTableLookup
| | | hash_search_with_hash_value
| | | hash_initial_lookup
| | |
| | |--2.80%--GetVictimBuffer
| | | PinBuffer_Locked
| | |
| | --2.80%--LockBufHdr
| | pg_atomic_fetch_or_u32
| | pg_atomic_fetch_or_u32_impl
| |
| --2.80%--BufferDescriptorGetBuffer
|
--13.96%--WaitReadBuffers
|
|--11.17%--smgrreadv
| mdreadv
| FileReadV
| pg_preadv
| |
| |--5.59%--__GI_preadv64 (inlined)
| | entry_SYSCALL_64_after_hwframe
| | do_syscall_64
| | x64_sys_call
| | __x64_sys_preadv
| | vfs_readv
| | do_iter_readv_writev
| | ext4_file_read_iter
| | generic_file_read_iter
| | filemap_read
| | copy_page_to_iter
| | _copy_to_iter
| |
| --5.58%--__libc_pread64 (inlined)
| entry_SYSCALL_64_after_hwframe
| do_syscall_64
| x64_sys_call
| __x64_sys_pread64
| vfs_read
| ext4_file_read_iter
| generic_file_read_iter
| filemap_read
| copy_page_to_iter
| _copy_to_iter
| |
| --2.79%--asm_sysvec_apic_timer_interrupt
| sysvec_apic_timer_interrupt
|
--2.79%--BufferGetBlock
33.54% 0.00% postgres [.] read_stream_next_buffer
|
---read_stream_next_buffer
|
|--19.58%--read_stream_look_ahead
| |
| --16.79%--read_stream_start_pending_read
| StartReadBuffers
| StartReadBuffersImpl
| PinBufferForBlock
| |
| |--13.99%--BufferAlloc
| | |
| | |--5.59%--BufTableInsert
| | | hash_search_with_hash_value
| | | |
| | | --2.80%--get_hash_entry
| | | tas
| | |
| | |--2.81%--BufTableLookup
| | | hash_search_with_hash_value
| | | hash_initial_lookup
| | |
| | |--2.80%--GetVictimBuffer
| | | PinBuffer_Locked
| | |
| | --2.80%--LockBufHdr
| | pg_atomic_fetch_or_u32
| | pg_atomic_fetch_or_u32_impl
| |
| --2.80%--BufferDescriptorGetBuffer
|
--13.96%--WaitReadBuffers
|
|--11.17%--smgrreadv
| mdreadv
| FileReadV
| pg_preadv
| |
| |--5.59%--__GI_preadv64 (inlined)
| | entry_SYSCALL_64_after_hwframe
| | do_syscall_64
| | x64_sys_call
| | __x64_sys_preadv
| | vfs_readv
| | do_iter_readv_writev
| | ext4_file_read_iter
| | generic_file_read_iter
| | filemap_read
| | copy_page_to_iter
| | _copy_to_iter
| |
| --5.58%--__libc_pread64 (inlined)
| entry_SYSCALL_64_after_hwframe
| do_syscall_64
| x64_sys_call
| __x64_sys_pread64
| vfs_read
| ext4_file_read_iter
| generic_file_read_iter
| filemap_read
| copy_page_to_iter
| _copy_to_iter
| |
| --2.79%--asm_sysvec_apic_timer_interrupt
| sysvec_apic_timer_interrupt
|
--2.79%--BufferGetBlock
19.58% 2.79% postgres [.] read_stream_look_ahead
|
|--16.79%--read_stream_look_ahead
| read_stream_start_pending_read
| StartReadBuffers
| StartReadBuffersImpl
| PinBufferForBlock
| |
| |--13.99%--BufferAlloc
| | |
| | |--5.59%--BufTableInsert
| | | hash_search_with_hash_value
| | | |
| | | --2.80%--get_hash_entry
| | | tas
| | |
| | |--2.81%--BufTableLookup
| | | hash_search_with_hash_value
| | | hash_initial_lookup
| | |
| | |--2.80%--GetVictimBuffer
| | | PinBuffer_Locked
| | |
| | --2.80%--LockBufHdr
| | pg_atomic_fetch_or_u32
| | pg_atomic_fetch_or_u32_impl
| |
| --2.80%--BufferDescriptorGetBuffer
|
--2.79%--_start
__libc_start_main_impl (inlined)
__libc_start_call_main
main
PostmasterMain
ServerLoop
BackendStartup
postmaster_child_launch
BackendMain
PostgresMain
exec_simple_query
PortalRun
PortalRunMulti
PortalRunUtility
ProcessUtility
standard_ProcessUtility
ExecVacuum
vacuum
vac_update_datfrozenxid
systable_getnext
table_scan_getnextslot
heap_getnextslot
heapgettup_pagemode
heap_fetch_next_buffer
read_stream_next_buffer
read_stream_look_ahead
16.79% 0.00% postgres [.] read_stream_start_pending_read
|
---read_stream_start_pending_read
StartReadBuffers
StartReadBuffersImpl
PinBufferForBlock
|
|--13.99%--BufferAlloc
| |
| |--5.59%--BufTableInsert
| | hash_search_with_hash_value
| | |
| | --2.80%--get_hash_entry
| | tas
| |
| |--2.81%--BufTableLookup
| | hash_search_with_hash_value
| | hash_initial_lookup
| |
| |--2.80%--GetVictimBuffer
| | PinBuffer_Locked
| |
| --2.80%--LockBufHdr
| pg_atomic_fetch_or_u32
| pg_atomic_fetch_or_u32_impl
|
--2.80%--BufferDescriptorGetBuffer
16.79% 0.00% postgres [.] StartReadBuffers
|
---StartReadBuffers
StartReadBuffersImpl
PinBufferForBlock
|
|--13.99%--BufferAlloc
| |
| |--5.59%--BufTableInsert
| | hash_search_with_hash_value
| | |
| | --2.80%--get_hash_entry
| | tas
| |
| |--2.81%--BufTableLookup
| | hash_search_with_hash_value
| | hash_initial_lookup
| |
| |--2.80%--GetVictimBuffer
| | PinBuffer_Locked
| |
| --2.80%--LockBufHdr
| pg_atomic_fetch_or_u32
| pg_atomic_fetch_or_u32_impl
|
--2.80%--BufferDescriptorGetBuffer
16.79% 0.00% postgres [.] StartReadBuffersImpl
|
---StartReadBuffersImpl
PinBufferForBlock
|
|--13.99%--BufferAlloc
| |
| |--5.59%--BufTableInsert
| | hash_search_with_hash_value
| | |
| | --2.80%--get_hash_entry
| | tas
| |
| |--2.81%--BufTableLookup
| | hash_search_with_hash_value
| | hash_initial_lookup
| |
| |--2.80%--GetVictimBuffer
| | PinBuffer_Locked
| |
| --2.80%--LockBufHdr
| pg_atomic_fetch_or_u32
| pg_atomic_fetch_or_u32_impl
|
--2.80%--BufferDescriptorGetBuffer
16.79% 0.00% postgres [.] PinBufferForBlock
|
---PinBufferForBlock
|
|--13.99%--BufferAlloc
| |
| |--5.59%--BufTableInsert
| | hash_search_with_hash_value
| | |
| | --2.80%--get_hash_entry
| | tas
| |
| |--2.81%--BufTableLookup
| | hash_search_with_hash_value
| | hash_initial_lookup
| |
| |--2.80%--GetVictimBuffer
| | PinBuffer_Locked
| |
| --2.80%--LockBufHdr
| pg_atomic_fetch_or_u32
| pg_atomic_fetch_or_u32_impl
|
--2.80%--BufferDescriptorGetBuffer
13.99% 0.00% postgres [.] BufferAlloc
|
---BufferAlloc
|
|--5.59%--BufTableInsert
| hash_search_with_hash_value
| |
| --2.80%--get_hash_entry
| tas
|
|--2.81%--BufTableLookup
| hash_search_with_hash_value
| hash_initial_lookup
|
|--2.80%--GetVictimBuffer
| PinBuffer_Locked
|
--2.80%--LockBufHdr
pg_atomic_fetch_or_u32
pg_atomic_fetch_or_u32_impl
8.57% 8.57% postgres [.] HeapTupleSatisfiesMVCC
|
|--5.77%--_start
| __libc_start_main_impl (inlined)
| __libc_start_call_main
| main
| PostmasterMain
| ServerLoop
| BackendStartup
| postmaster_child_launch
| BackendMain
| PostgresMain
| exec_simple_query
| PortalRun
| PortalRunMulti
| PortalRunUtility
| ProcessUtility
| standard_ProcessUtility
| ExecVacuum
| vacuum
| vac_update_datfrozenxid
| systable_getnext
| table_scan_getnextslot
| heap_getnextslot
| heapgettup_pagemode
| heap_prepare_pagescan
| page_collect_tuples
| HeapTupleSatisfiesVisibility
| HeapTupleSatisfiesMVCC
|
--2.80%--0x7ffe6151033f
HeapTupleSatisfiesMVCC
8.56% 0.00% postgres [.] HeapTupleSatisfiesVisibility
|
---HeapTupleSatisfiesVisibility
|
|--5.77%--HeapTupleSatisfiesMVCC
|
--2.79%--asm_sysvec_apic_timer_interrupt
sysvec_apic_timer_interrupt
__sysvec_apic_timer_interrupt
hrtimer_interrupt
__hrtimer_run_queues
tick_nohz_highres_handler
tick_sched_handle
update_process_times
scheduler_tick
task_tick_fair
update_curr
__calc_delta.constprop.0
8.43% 5.64% postgres [.] TransactionIdPrecedes
|
|--5.64%--_start
| __libc_start_main_impl (inlined)
| __libc_start_call_main
| main
| PostmasterMain
| ServerLoop
| BackendStartup
| postmaster_child_launch
| BackendMain
| PostgresMain
| exec_simple_query
| PortalRun
| PortalRunMulti
| PortalRunUtility
| ProcessUtility
| standard_ProcessUtility
| ExecVacuum
| vacuum
| vac_update_datfrozenxid
| TransactionIdPrecedes
|
--2.79%--TransactionIdPrecedes
asm_sysvec_apic_timer_interrupt
sysvec_apic_timer_interrupt
__sysvec_apic_timer_interrupt
hrtimer_interrupt
__hrtimer_run_queues
tick_nohz_highres_handler
tick_sched_handle
update_process_times
rcu_sched_clock_irq
rcu_pending
8.40% 2.79% postgres [.] hash_search_with_hash_value
|
|--5.61%--hash_search_with_hash_value
| |
| |--2.81%--hash_initial_lookup
| |
| --2.80%--get_hash_entry
| tas
|
--2.79%--_start
__libc_start_main_impl (inlined)
__libc_start_call_main
main
PostmasterMain
ServerLoop
BackendStartup
postmaster_child_launch
BackendMain
PostgresMain
exec_simple_query
PortalRun
PortalRunMulti
PortalRunUtility
ProcessUtility
standard_ProcessUtility
ExecVacuum
vacuum
vac_update_datfrozenxid
systable_getnext
table_scan_getnextslot
heap_getnextslot
heapgettup_pagemode
heap_fetch_next_buffer
read_stream_next_buffer
read_stream_look_ahead
read_stream_start_pending_read
StartReadBuffers
StartReadBuffersImpl
PinBufferForBlock
BufferAlloc
BufTableInsert
hash_search_with_hash_value
5.77% 2.96% postgres [.] ItemPointerSet
|
|--2.96%--_start
| __libc_start_main_impl (inlined)
| __libc_start_call_main
| main
| PostmasterMain
| ServerLoop
| BackendStartup
| postmaster_child_launch
| BackendMain
| PostgresMain
| exec_simple_query
| PortalRun
| PortalRunMulti
| PortalRunUtility
| ProcessUtility
| standard_ProcessUtility
| ExecVacuum
| vacuum
| vac_update_datfrozenxid
| systable_getnext
| table_scan_getnextslot
| heap_getnextslot
| heapgettup_pagemode
| heap_prepare_pagescan
| page_collect_tuples
| ItemPointerSet
|
--2.82%--ItemPointerSet
BlockIdSet
5.59% 0.00% postgres [.] BufTableInsert
|
---BufTableInsert
hash_search_with_hash_value
|
--2.80%--get_hash_entry
tas
5.57% 2.79% postgres [.] HandleConcurrentAbort
|
|--2.79%--0x7ffe6151051f
| HandleConcurrentAbort
|
--2.79%--HandleConcurrentAbort
asm_sysvec_apic_timer_interrupt
sysvec_apic_timer_interrupt
__sysvec_apic_timer_interrupt
hrtimer_interrupt
__hrtimer_run_queues
tick_nohz_highres_handler
tick_sched_handle
update_process_times
scheduler_tick
perf_event_task_tick
perf_adjust_freq_unthr_context
2.82% 2.82% postgres [.] BlockIdSet
|
---_start
__libc_start_main_impl (inlined)
__libc_start_call_main
main
PostmasterMain
ServerLoop
BackendStartup
postmaster_child_launch
BackendMain
PostgresMain
exec_simple_query
PortalRun
PortalRunMulti
PortalRunUtility
ProcessUtility
standard_ProcessUtility
ExecVacuum
vacuum
vac_update_datfrozenxid
systable_getnext
table_scan_getnextslot
heap_getnextslot
heapgettup_pagemode
heap_prepare_pagescan
page_collect_tuples
ItemPointerSet
BlockIdSet
2.81% 2.81% postgres [.] hash_initial_lookup
|
---_start
__libc_start_main_impl (inlined)
__libc_start_call_main
main
PostmasterMain
ServerLoop
BackendStartup
postmaster_child_launch
BackendMain
PostgresMain
exec_simple_query
PortalRun
PortalRunMulti
PortalRunUtility
ProcessUtility
standard_ProcessUtility
ExecVacuum
vacuum
vac_update_datfrozenxid
systable_getnext
table_scan_getnextslot
heap_getnextslot
heapgettup_pagemode
heap_fetch_next_buffer
read_stream_next_buffer
read_stream_look_ahead
read_stream_start_pending_read
StartReadBuffers
StartReadBuffersImpl
PinBufferForBlock
BufferAlloc
BufTableLookup
hash_search_with_hash_value
hash_initial_lookup
2.81% 0.00% postgres [.] BufTableLookup
|
---BufTableLookup
hash_search_with_hash_value
hash_initial_lookup
2.80% 2.80% postgres [.] BufferDescriptorGetBuffer
|
---_start
__libc_start_main_impl (inlined)
__libc_start_call_main
main
PostmasterMain
ServerLoop
BackendStartup
postmaster_child_launch
BackendMain
PostgresMain
exec_simple_query
PortalRun
PortalRunMulti
PortalRunUtility
ProcessUtility
standard_ProcessUtility
ExecVacuum
vacuum
vac_update_datfrozenxid
systable_getnext
table_scan_getnextslot
heap_getnextslot
heapgettup_pagemode
heap_fetch_next_buffer
read_stream_next_buffer
read_stream_look_ahead
read_stream_start_pending_read
StartReadBuffers
StartReadBuffersImpl
PinBufferForBlock
BufferDescriptorGetBuffer
2.80% 2.80% postgres [.] PinBuffer_Locked
|
---_start
__libc_start_main_impl (inlined)
__libc_start_call_main
main
PostmasterMain
ServerLoop
BackendStartup
postmaster_child_launch
BackendMain
PostgresMain
exec_simple_query
PortalRun
PortalRunMulti
PortalRunUtility
ProcessUtility
standard_ProcessUtility
ExecVacuum
vacuum
vac_update_datfrozenxid
systable_getnext
table_scan_getnextslot
heap_getnextslot
heapgettup_pagemode
heap_fetch_next_buffer
read_stream_next_buffer
read_stream_look_ahead
read_stream_start_pending_read
StartReadBuffers
StartReadBuffersImpl
PinBufferForBlock
BufferAlloc
GetVictimBuffer
PinBuffer_Locked
2.80% 0.00% postgres [.] GetVictimBuffer
|
---GetVictimBuffer
PinBuffer_Locked
2.80% 2.80% postgres [.] tas
|
---_start
__libc_start_main_impl (inlined)
__libc_start_call_main
main
PostmasterMain
ServerLoop
BackendStartup
postmaster_child_launch
BackendMain
PostgresMain
exec_simple_query
PortalRun
PortalRunMulti
PortalRunUtility
ProcessUtility
standard_ProcessUtility
ExecVacuum
vacuum
vac_update_datfrozenxid
systable_getnext
table_scan_getnextslot
heap_getnextslot
heapgettup_pagemode
heap_fetch_next_buffer
read_stream_next_buffer
read_stream_look_ahead
read_stream_start_pending_read
StartReadBuffers
StartReadBuffersImpl
PinBufferForBlock
BufferAlloc
BufTableInsert
hash_search_with_hash_value
get_hash_entry
tas
2.80% 0.00% postgres [.] get_hash_entry
|
---get_hash_entry
tas
2.80% 2.80% postgres [.] pg_atomic_fetch_or_u32_impl
|
---_start
__libc_start_main_impl (inlined)
__libc_start_call_main
main
PostmasterMain
ServerLoop
BackendStartup
postmaster_child_launch
BackendMain
PostgresMain
exec_simple_query
PortalRun
PortalRunMulti
PortalRunUtility
ProcessUtility
standard_ProcessUtility
ExecVacuum
vacuum
vac_update_datfrozenxid
systable_getnext
table_scan_getnextslot
heap_getnextslot
heapgettup_pagemode
heap_fetch_next_buffer
read_stream_next_buffer
read_stream_look_ahead
read_stream_start_pending_read
StartReadBuffers
StartReadBuffersImpl
PinBufferForBlock
BufferAlloc
LockBufHdr
pg_atomic_fetch_or_u32
pg_atomic_fetch_or_u32_impl
2.80% 0.00% postgres [.] LockBufHdr
|
---LockBufHdr
pg_atomic_fetch_or_u32
pg_atomic_fetch_or_u32_impl
2.80% 0.00% postgres [.] pg_atomic_fetch_or_u32
|
---pg_atomic_fetch_or_u32
pg_atomic_fetch_or_u32_impl
2.80% 0.00% postgres [.] 0x00007ffe6151033f
|
---0x7ffe6151033f
HeapTupleSatisfiesMVCC
2.79% 2.79% postgres [.] LockBuffer
|
---_start
__libc_start_main_impl (inlined)
__libc_start_call_main
main
PostmasterMain
ServerLoop
BackendStartup
postmaster_child_launch
BackendMain
PostgresMain
exec_simple_query
PortalRun
PortalRunMulti
PortalRunUtility
ProcessUtility
standard_ProcessUtility
ExecVacuum
vacuum
vac_update_datfrozenxid
systable_getnext
table_scan_getnextslot
heap_getnextslot
heapgettup_pagemode
LockBuffer
2.79% 2.79% postgres [.] BufferGetBlock
|
---_start
__libc_start_main_impl (inlined)
__libc_start_call_main
main
PostmasterMain
ServerLoop
BackendStartup
postmaster_child_launch
BackendMain
PostgresMain
exec_simple_query
PortalRun
PortalRunMulti
PortalRunUtility
ProcessUtility
standard_ProcessUtility
ExecVacuum
vacuum
vac_update_datfrozenxid
systable_getnext
table_scan_getnextslot
heap_getnextslot
heapgettup_pagemode
heap_fetch_next_buffer
read_stream_next_buffer
WaitReadBuffers
BufferGetBlock
2.79% 0.00% postgres [.] 0x00007ffe6151051f
|
---0x7ffe6151051f
HandleConcurrentAbort
1.49% 1.49% postgres [.] ExecStoreBufferHeapTuple
|
---_start
__libc_start_main_impl (inlined)
__libc_start_call_main
main
PostmasterMain
ServerLoop
BackendStartup
postmaster_child_launch
BackendMain
PostgresMain
exec_simple_query
PortalRun
PortalRunMulti
PortalRunUtility
ProcessUtility
standard_ProcessUtility
ExecVacuum
vacuum
vac_update_datfrozenxid
systable_getnext
table_scan_getnextslot
heap_getnextslot
ExecStoreBufferHeapTuple
0.34% 0.34% postgres [.] PageGetItemId
0.34% 0.00% postgres [.] 0x00007ffe615103af
# Samples: 12K of event 'cpu_core/cycles/P'
# Event count (approx.): 4321766353
#
# Children Self Command Symbol
# ........ ........ ........ .........................................
#
91.13% 0.00% postgres [.] _start
|
---_start
__libc_start_main_impl (inlined)
__libc_start_call_main
main
PostmasterMain
ServerLoop
BackendStartup
postmaster_child_launch
BackendMain
PostgresMain
exec_simple_query
PortalRun
PortalRunMulti
PortalRunUtility
ProcessUtility
standard_ProcessUtility
ExecVacuum
vacuum
vac_update_datfrozenxid
|
|--81.42%--systable_getnext
| |
| |--76.61%--table_scan_getnextslot
| | |
| | --73.16%--heap_getnextslot
| | |
| | |--57.95%--heapgettup_pagemode
| | | |
| | | |--30.65%--heap_fetch_next_buffer
| | | | |
| | | | |--29.43%--read_stream_next_buffer
| | | | | |
| | | | | |--17.13%--WaitReadBuffers
| | | | | | |
| | | | | | |--13.62%--smgrreadv
| | | | | | | |
| | | | | | | --13.58%--mdreadv
| | | | | | | |
| | | | | | | --13.47%--FileReadV
| | | | | | | |
| | | | | | | --13.41%--pg_preadv
| | | | | | | |
| | | | | | | |--6.71%--__libc_pread64 (inlined)
| | | | | | | | |
| | | | | | | | --6.68%--entry_SYSCALL_64_after_hwframe
| | | | | | | | do_syscall_64
| | | | | | | | |
| | | | | | | | --6.66%--x64_sys_call
| | | | | | | | __x64_sys_pread64
| | | | | | | | |
| | | | | | | | --6.62%--vfs_read
| | | | | | | | |
| | | | | | | | --6.57%--ext4_file_read_iter
| | | | | | | | generic_file_read_iter
| | | | | | | | |
| | | | | | | | --6.53%--filemap_read
| | | | | | | | |
| | | | | | | | --5.57%--copy_page_to_iter
| | | | | | | | |
| | | | | | | | --5.45%--_copy_to_iter
| | | | | | | |
| | | | | | | --6.70%--__GI_preadv64 (inlined)
| | | | | | | |
| | | | | | | --6.64%--entry_SYSCALL_64_after_hwframe
| | | | | | | |
| | | | | | | --6.64%--do_syscall_64
| | | | | | | |
| | | | | | | --6.58%--x64_sys_call
| | | | | | | |
| | | | | | | --6.57%--__x64_sys_preadv
| | | | | | | |
| | | | | | | --6.55%--vfs_readv
| | | | | | | |
| | | | | | | --6.48%--do_iter_readv_writev
| | | | | | | |
| | | | | | | --6.47%--ext4_file_read_iter
| | | | | | | generic_file_read_iter
| | | | | | | |
| | | | | | | --6.46%--filemap_read
| | | | | | | |
| | | | | | | --5.72%--copy_page_to_iter
| | | | | | | |
| | | | | | | --5.63%--_copy_to_iter
| | | | | | |
| | | | | | |--1.58%--TerminateBufferIO
| | | | | | |
| | | | | | --1.30%--WaitReadBuffersCanStartIO
| | | | | | |
| | | | | | --1.24%--StartBufferIO
| | | | | | |
| | | | | | --0.55%--ResourceOwnerEnlarge
| | | | | |
| | | | | --11.90%--read_stream_look_ahead
| | | | | |
| | | | | --11.33%--read_stream_start_pending_read
| | | | | |
| | | | | --11.30%--StartReadBuffers
| | | | | StartReadBuffersImpl
| | | | | |
| | | | | --11.17%--PinBufferForBlock
| | | | | |
| | | | | --10.94%--BufferAlloc
| | | | | |
| | | | | |--5.08%--GetVictimBuffer
| | | | | | |
| | | | | | --3.45%--InvalidateVictimBuffer
| | | | | | |
| | | | | | |--0.95%--BufTableDelete
| | | | | | | |
| | | | | | | --0.91%--hash_search_with_hash_value
| | | | | | |
| | | | | | |--0.93%--BufTableHashCode
| | | | | | | |
| | | | | | | --0.90%--get_hash_value
| | | | | | | |
| | | | | | | --0.84%--tag_hash
| | | | | | | |
| | | | | | | --0.81%--hash_bytes
| | | | | | |
| | | | | | --0.56%--LWLockAcquire
| | | | | |
| | | | | |--0.96%--LWLockAcquire
| | | | | | |
| | | | | | --0.80%--LWLockAttemptLock
| | | | | |
| | | | | |--0.95%--BufTableHashCode
| | | | | | |
| | | | | | --0.93%--get_hash_value
| | | | | | |
| | | | | | --0.89%--tag_hash
| | | | | | |
| | | | | | --0.83%--hash_bytes
| | | | | |
| | | | | |--0.77%--BufTableLookup
| | | | | | |
| | | | | | --0.71%--hash_search_with_hash_value
| | | | | |
| | | | | |--0.74%--BufTableInsert
| | | | | | |
| | | | | | --0.67%--hash_search_with_hash_value
| | | | | |
| | | | | |--0.71%--LWLockRelease
| | | | | |
| | | | | --0.71%--ReservePrivateRefCountEntry
| | | | | |
| | | | | --0.55%--hash_search
| | | | |
| | | | --0.84%--ReleaseBuffer
| | | | |
| | | | --0.79%--UnpinBuffer
| | | | |
| | | | --0.58%--UnpinBufferNoOwner
| | | |
| | | |--16.44%--heap_prepare_pagescan
| | | | |
| | | | |--14.71%--page_collect_tuples
| | | | | |
| | | | | |--6.82%--HeapTupleSatisfiesVisibility
| | | | | | |
| | | | | | --4.85%--HeapTupleSatisfiesMVCC
| | | | | | |
| | | | | | --2.41%--XidInMVCCSnapshot
| | | | | | |
| | | | | | --1.10%--TransactionIdPrecedes
| | | | | |
| | | | | |--1.91%--ItemPointerSet
| | | | | | |
| | | | | | --0.81%--BlockIdSet
| | | | | |
| | | | | --0.80%--PageGetItemId
| | | | |
| | | | --1.11%--LockBuffer
| | | | |
| | | | --0.55%--LWLockAcquire
| | | |
| | | |--2.54%--ItemPointerSet
| | | | |
| | | | --0.81%--BlockIdSet
| | | |
| | | |--1.13%--BufferGetPage
| | | | |
| | | | --0.74%--BufferGetBlock
| | | |
| | | |--0.83%--PageGetItemId
| | | |
| | | --0.64%--PageGetItem
| | |
| | --9.51%--ExecStoreBufferHeapTuple
| | |
| | --7.65%--tts_buffer_heap_store_tuple
| | |
| | |--2.47%--IncrBufferRefCount
| | | |
| | | --2.11%--GetPrivateRefCountEntry
| | | |
| | | --1.54%--hash_search
| | | |
| | | |--0.87%--hash_search_with_hash_value
| | | |
| | | --0.57%--uint32_hash
| | | |
| | | --0.54%--hash_bytes_uint32
| | |
| | --2.04%--ReleaseBuffer
| | |
| | --1.95%--UnpinBuffer
| | |
| | |--1.25%--UnpinBufferNoOwner
| | |
| | --0.63%--ResourceOwnerForgetBuffer
| | |
| | --0.56%--ResourceOwnerForget
| |
| --1.83%--ExecFetchSlotHeapTuple
| |
| --0.83%--tts_buffer_heap_get_heap_tuple
|
|--2.20%--TransactionIdPrecedes
|
--1.18%--MultiXactIdPrecedes
91.13% 0.00% postgres [.] __libc_start_main_impl (inlined)
|
---__libc_start_main_impl (inlined)
__libc_start_call_main
main
PostmasterMain
ServerLoop
BackendStartup
postmaster_child_launch
BackendMain
PostgresMain
exec_simple_query
PortalRun
PortalRunMulti
PortalRunUtility
ProcessUtility
standard_ProcessUtility
ExecVacuum
vacuum
vac_update_datfrozenxid
|
|--81.42%--systable_getnext
| |
| |--76.61%--table_scan_getnextslot
| | |
| | --73.16%--heap_getnextslot
| | |
| | |--57.95%--heapgettup_pagemode
| | | |
| | | |--30.65%--heap_fetch_next_buffer
| | | | |
| | | | |--29.43%--read_stream_next_buffer
| | | | | |
| | | | | |--17.13%--WaitReadBuffers
| | | | | | |
| | | | | | |--13.62%--smgrreadv
| | | | | | | |
| | | | | | | --13.58%--mdreadv
| | | | | | | |
| | | | | | | --13.47%--FileReadV
| | | | | | | |
| | | | | | | --13.41%--pg_preadv
| | | | | | | |
| | | | | | | |--6.71%--__libc_pread64 (inlined)
| | | | | | | | |
| | | | | | | | --6.68%--entry_SYSCALL_64_after_hwframe
| | | | | | | | do_syscall_64
| | | | | | | | |
| | | | | | | | --6.66%--x64_sys_call
| | | | | | | | __x64_sys_pread64
| | | | | | | | |
| | | | | | | | --6.62%--vfs_read
| | | | | | | | |
| | | | | | | | --6.57%--ext4_file_read_iter
| | | | | | | | generic_file_read_iter
| | | | | | | | |
| | | | | | | | --6.53%--filemap_read
| | | | | | | | |
| | | | | | | | --5.57%--copy_page_to_iter
| | | | | | | | |
| | | | | | | | --5.45%--_copy_to_iter
| | | | | | | |
| | | | | | | --6.70%--__GI_preadv64 (inlined)
| | | | | | | |
| | | | | | | --6.64%--entry_SYSCALL_64_after_hwframe
| | | | | | | |
| | | | | | | --6.64%--do_syscall_64
| | | | | | | |
| | | | | | | --6.58%--x64_sys_call
| | | | | | | |
| | | | | | | --6.57%--__x64_sys_preadv
| | | | | | | |
| | | | | | | --6.55%--vfs_readv
| | | | | | | |
| | | | | | | --6.48%--do_iter_readv_writev
| | | | | | | |
| | | | | | | --6.47%--ext4_file_read_iter
| | | | | | | generic_file_read_iter
| | | | | | | |
| | | | | | | --6.46%--filemap_read
| | | | | | | |
| | | | | | | --5.72%--copy_page_to_iter
| | | | | | | |
| | | | | | | --5.63%--_copy_to_iter
| | | | | | |
| | | | | | |--1.58%--TerminateBufferIO
| | | | | | |
| | | | | | --1.30%--WaitReadBuffersCanStartIO
| | | | | | |
| | | | | | --1.24%--StartBufferIO
| | | | | | |
| | | | | | --0.55%--ResourceOwnerEnlarge
| | | | | |
| | | | | --11.90%--read_stream_look_ahead
| | | | | |
| | | | | --11.33%--read_stream_start_pending_read
| | | | | |
| | | | | --11.30%--StartReadBuffers
| | | | | StartReadBuffersImpl
| | | | | |
| | | | | --11.17%--PinBufferForBlock
| | | | | |
| | | | | --10.94%--BufferAlloc
| | | | | |
| | | | | |--5.08%--GetVictimBuffer
| | | | | | |
| | | | | | --3.45%--InvalidateVictimBuffer
| | | | | | |
| | | | | | |--0.95%--BufTableDelete
| | | | | | | |
| | | | | | | --0.91%--hash_search_with_hash_value
| | | | | | |
| | | | | | |--0.93%--BufTableHashCode
| | | | | | | |
| | | | | | | --0.90%--get_hash_value
| | | | | | | |
| | | | | | | --0.84%--tag_hash
| | | | | | | |
| | | | | | | --0.81%--hash_bytes
| | | | | | |
| | | | | | --0.56%--LWLockAcquire
| | | | | |
| | | | | |--0.96%--LWLockAcquire
| | | | | | |
| | | | | | --0.80%--LWLockAttemptLock
| | | | | |
| | | | | |--0.95%--BufTableHashCode
| | | | | | |
| | | | | | --0.93%--get_hash_value
| | | | | | |
| | | | | | --0.89%--tag_hash
| | | | | | |
| | | | | | --0.83%--hash_bytes
| | | | | |
| | | | | |--0.77%--BufTableLookup
| | | | | | |
| | | | | | --0.71%--hash_search_with_hash_value
| | | | | |
| | | | | |--0.74%--BufTableInsert
| | | | | | |
| | | | | | --0.67%--hash_search_with_hash_value
| | | | | |
| | | | | |--0.71%--LWLockRelease
| | | | | |
| | | | | --0.71%--ReservePrivateRefCountEntry
| | | | | |
| | | | | --0.55%--hash_search
| | | | |
| | | | --0.84%--ReleaseBuffer
| | | | |
| | | | --0.79%--UnpinBuffer
| | | | |
| | | | --0.58%--UnpinBufferNoOwner
| | | |
| | | |--16.44%--heap_prepare_pagescan
| | | | |
| | | | |--14.71%--page_collect_tuples
| | | | | |
| | | | | |--6.82%--HeapTupleSatisfiesVisibility
| | | | | | |
| | | | | | --4.85%--HeapTupleSatisfiesMVCC
| | | | | | |
| | | | | | --2.41%--XidInMVCCSnapshot
| | | | | | |
| | | | | | --1.10%--TransactionIdPrecedes
| | | | | |
| | | | | |--1.91%--ItemPointerSet
| | | | | | |
| | | | | | --0.81%--BlockIdSet
| | | | | |
| | | | | --0.80%--PageGetItemId
| | | | |
| | | | --1.11%--LockBuffer
| | | | |
| | | | --0.55%--LWLockAcquire
| | | |
| | | |--2.54%--ItemPointerSet
| | | | |
| | | | --0.81%--BlockIdSet
| | | |
| | | |--1.13%--BufferGetPage
| | | | |
| | | | --0.74%--BufferGetBlock
| | | |
| | | |--0.83%--PageGetItemId
| | | |
| | | --0.64%--PageGetItem
| | |
| | --9.51%--ExecStoreBufferHeapTuple
| | |
| | --7.65%--tts_buffer_heap_store_tuple
| | |
| | |--2.47%--IncrBufferRefCount
| | | |
| | | --2.11%--GetPrivateRefCountEntry
| | | |
| | | --1.54%--hash_search
| | | |
| | | |--0.87%--hash_search_with_hash_value
| | | |
| | | --0.57%--uint32_hash
| | | |
| | | --0.54%--hash_bytes_uint32
| | |
| | --2.04%--ReleaseBuffer
| | |
| | --1.95%--UnpinBuffer
| | |
| | |--1.25%--UnpinBufferNoOwner
| | |
| | --0.63%--ResourceOwnerForgetBuffer
| | |
| | --0.56%--ResourceOwnerForget
| |
| --1.83%--ExecFetchSlotHeapTuple
| |
| --0.83%--tts_buffer_heap_get_heap_tuple
|
|--2.20%--TransactionIdPrecedes
|
--1.18%--MultiXactIdPrecedes
91.13% 0.00% postgres [.] __libc_start_call_main
|
---__libc_start_call_main
main
PostmasterMain
ServerLoop
BackendStartup
postmaster_child_launch
BackendMain
PostgresMain
exec_simple_query
PortalRun
PortalRunMulti
PortalRunUtility
ProcessUtility
standard_ProcessUtility
ExecVacuum
vacuum
vac_update_datfrozenxid
|
|--81.42%--systable_getnext
| |
| |--76.61%--table_scan_getnextslot
| | |
| | --73.16%--heap_getnextslot
| | |
| | |--57.95%--heapgettup_pagemode
| | | |
| | | |--30.65%--heap_fetch_next_buffer
| | | | |
| | | | |--29.43%--read_stream_next_buffer
| | | | | |
| | | | | |--17.13%--WaitReadBuffers
| | | | | | |
| | | | | | |--13.62%--smgrreadv
| | | | | | | |
| | | | | | | --13.58%--mdreadv
| | | | | | | |
| | | | | | | --13.47%--FileReadV
| | | | | | | |
| | | | | | | --13.41%--pg_preadv
| | | | | | | |
| | | | | | | |--6.71%--__libc_pread64 (inlined)
| | | | | | | | |
| | | | | | | | --6.68%--entry_SYSCALL_64_after_hwframe
| | | | | | | | do_syscall_64
| | | | | | | | |
| | | | | | | | --6.66%--x64_sys_call
| | | | | | | | __x64_sys_pread64
| | | | | | | | |
| | | | | | | | --6.62%--vfs_read
| | | | | | | | |
| | | | | | | | --6.57%--ext4_file_read_iter
| | | | | | | | generic_file_read_iter
| | | | | | | | |
| | | | | | | | --6.53%--filemap_read
| | | | | | | | |
| | | | | | | | --5.57%--copy_page_to_iter
| | | | | | | | |
| | | | | | | | --5.45%--_copy_to_iter
| | | | | | | |
| | | | | | | --6.70%--__GI_preadv64 (inlined)
| | | | | | | |
| | | | | | | --6.64%--entry_SYSCALL_64_after_hwframe
| | | | | | | |
| | | | | | | --6.64%--do_syscall_64
| | | | | | | |
| | | | | | | --6.58%--x64_sys_call
| | | | | | | |
| | | | | | | --6.57%--__x64_sys_preadv
| | | | | | | |
| | | | | | | --6.55%--vfs_readv
| | | | | | | |
| | | | | | | --6.48%--do_iter_readv_writev
| | | | | | | |
| | | | | | | --6.47%--ext4_file_read_iter
| | | | | | | generic_file_read_iter
| | | | | | | |
| | | | | | | --6.46%--filemap_read
| | | | | | | |
| | | | | | | --5.72%--copy_page_to_iter
| | | | | | | |
| | | | | | | --5.63%--_copy_to_iter
| | | | | | |
| | | | | | |--1.58%--TerminateBufferIO
| | | | | | |
| | | | | | --1.30%--WaitReadBuffersCanStartIO
| | | | | | |
| | | | | | --1.24%--StartBufferIO
| | | | | | |
| | | | | | --0.55%--ResourceOwnerEnlarge
| | | | | |
| | | | | --11.90%--read_stream_look_ahead
| | | | | |
| | | | | --11.33%--read_stream_start_pending_read
| | | | | |
| | | | | --11.30%--StartReadBuffers
| | | | | StartReadBuffersImpl
| | | | | |
| | | | | --11.17%--PinBufferForBlock
| | | | | |
| | | | | --10.94%--BufferAlloc
| | | | | |
| | | | | |--5.08%--GetVictimBuffer
| | | | | | |
| | | | | | --3.45%--InvalidateVictimBuffer
| | | | | | |
| | | | | | |--0.95%--BufTableDelete
| | | | | | | |
| | | | | | | --0.91%--hash_search_with_hash_value
| | | | | | |
| | | | | | |--0.93%--BufTableHashCode
| | | | | | | |
| | | | | | | --0.90%--get_hash_value
| | | | | | | |
| | | | | | | --0.84%--tag_hash
| | | | | | | |
| | | | | | | --0.81%--hash_bytes
| | | | | | |
| | | | | | --0.56%--LWLockAcquire
| | | | | |
| | | | | |--0.96%--LWLockAcquire
| | | | | | |
| | | | | | --0.80%--LWLockAttemptLock
| | | | | |
| | | | | |--0.95%--BufTableHashCode
| | | | | | |
| | | | | | --0.93%--get_hash_value
| | | | | | |
| | | | | | --0.89%--tag_hash
| | | | | | |
| | | | | | --0.83%--hash_bytes
| | | | | |
| | | | | |--0.77%--BufTableLookup
| | | | | | |
| | | | | | --0.71%--hash_search_with_hash_value
| | | | | |
| | | | | |--0.74%--BufTableInsert
| | | | | | |
| | | | | | --0.67%--hash_search_with_hash_value
| | | | | |
| | | | | |--0.71%--LWLockRelease
| | | | | |
| | | | | --0.71%--ReservePrivateRefCountEntry
| | | | | |
| | | | | --0.55%--hash_search
| | | | |
| | | | --0.84%--ReleaseBuffer
| | | | |
| | | | --0.79%--UnpinBuffer
| | | | |
| | | | --0.58%--UnpinBufferNoOwner
| | | |
| | | |--16.44%--heap_prepare_pagescan
| | | | |
| | | | |--14.71%--page_collect_tuples
| | | | | |
| | | | | |--6.82%--HeapTupleSatisfiesVisibility
| | | | | | |
| | | | | | --4.85%--HeapTupleSatisfiesMVCC
| | | | | | |
| | | | | | --2.41%--XidInMVCCSnapshot
| | | | | | |
| | | | | | --1.10%--TransactionIdPrecedes
| | | | | |
| | | | | |--1.91%--ItemPointerSet
| | | | | | |
| | | | | | --0.81%--BlockIdSet
| | | | | |
| | | | | --0.80%--PageGetItemId
| | | | |
| | | | --1.11%--LockBuffer
| | | | |
| | | | --0.55%--LWLockAcquire
| | | |
| | | |--2.54%--ItemPointerSet
| | | | |
| | | | --0.81%--BlockIdSet
| | | |
| | | |--1.13%--BufferGetPage
| | | | |
| | | | --0.74%--BufferGetBlock
| | | |
| | | |--0.83%--PageGetItemId
| | | |
| | | --0.64%--PageGetItem
| | |
| | --9.51%--ExecStoreBufferHeapTuple
| | |
| | --7.65%--tts_buffer_heap_store_tuple
| | |
| | |--2.47%--IncrBufferRefCount
| | | |
| | | --2.11%--GetPrivateRefCountEntry
| | | |
| | | --1.54%--hash_search
| | | |
| | | |--0.87%--hash_search_with_hash_value
| | | |
| | | --0.57%--uint32_hash
| | | |
| | | --0.54%--hash_bytes_uint32
| | |
| | --2.04%--ReleaseBuffer
| | |
| | --1.95%--UnpinBuffer
| | |
| | |--1.25%--UnpinBufferNoOwner
| | |
| | --0.63%--ResourceOwnerForgetBuffer
| | |
| | --0.56%--ResourceOwnerForget
| |
| --1.83%--ExecFetchSlotHeapTuple
| |
| --0.83%--tts_buffer_heap_get_heap_tuple
|
|--2.20%--TransactionIdPrecedes
|
--1.18%--MultiXactIdPrecedes
91.13% 0.00% postgres [.] main
|
---main
PostmasterMain
ServerLoop
BackendStartup
postmaster_child_launch
BackendMain
PostgresMain
exec_simple_query
PortalRun
PortalRunMulti
PortalRunUtility
ProcessUtility
standard_ProcessUtility
ExecVacuum
vacuum
vac_update_datfrozenxid
|
|--81.42%--systable_getnext
| |
| |--76.61%--table_scan_getnextslot
| | |
| | --73.16%--heap_getnextslot
| | |
| | |--57.95%--heapgettup_pagemode
| | | |
| | | |--30.65%--heap_fetch_next_buffer
| | | | |
| | | | |--29.43%--read_stream_next_buffer
| | | | | |
| | | | | |--17.13%--WaitReadBuffers
| | | | | | |
| | | | | | |--13.62%--smgrreadv
| | | | | | | |
| | | | | | | --13.58%--mdreadv
| | | | | | | |
| | | | | | | --13.47%--FileReadV
| | | | | | | |
| | | | | | | --13.41%--pg_preadv
| | | | | | | |
| | | | | | | |--6.71%--__libc_pread64 (inlined)
| | | | | | | | |
| | | | | | | | --6.68%--entry_SYSCALL_64_after_hwframe
| | | | | | | | do_syscall_64
| | | | | | | | |
| | | | | | | | --6.66%--x64_sys_call
| | | | | | | | __x64_sys_pread64
| | | | | | | | |
| | | | | | | | --6.62%--vfs_read
| | | | | | | | |
| | | | | | | | --6.57%--ext4_file_read_iter
| | | | | | | | generic_file_read_iter
| | | | | | | | |
| | | | | | | | --6.53%--filemap_read
| | | | | | | | |
| | | | | | | | --5.57%--copy_page_to_iter
| | | | | | | | |
| | | | | | | | --5.45%--_copy_to_iter
| | | | | | | |
| | | | | | | --6.70%--__GI_preadv64 (inlined)
| | | | | | | |
| | | | | | | --6.64%--entry_SYSCALL_64_after_hwframe
| | | | | | | |
| | | | | | | --6.64%--do_syscall_64
| | | | | | | |
| | | | | | | --6.58%--x64_sys_call
| | | | | | | |
| | | | | | | --6.57%--__x64_sys_preadv
| | | | | | | |
| | | | | | | --6.55%--vfs_readv
| | | | | | | |
| | | | | | | --6.48%--do_iter_readv_writev
| | | | | | | |
| | | | | | | --6.47%--ext4_file_read_iter
| | | | | | | generic_file_read_iter
| | | | | | | |
| | | | | | | --6.46%--filemap_read
| | | | | | | |
| | | | | | | --5.72%--copy_page_to_iter
| | | | | | | |
| | | | | | | --5.63%--_copy_to_iter
| | | | | | |
| | | | | | |--1.58%--TerminateBufferIO
| | | | | | |
| | | | | | --1.30%--WaitReadBuffersCanStartIO
| | | | | | |
| | | | | | --1.24%--StartBufferIO
| | | | | | |
| | | | | | --0.55%--ResourceOwnerEnlarge
| | | | | |
| | | | | --11.90%--read_stream_look_ahead
| | | | | |
| | | | | --11.33%--read_stream_start_pending_read
| | | | | |
| | | | | --11.30%--StartReadBuffers
| | | | | StartReadBuffersImpl
| | | | | |
| | | | | --11.17%--PinBufferForBlock
| | | | | |
| | | | | --10.94%--BufferAlloc
| | | | | |
| | | | | |--5.08%--GetVictimBuffer
| | | | | | |
| | | | | | --3.45%--InvalidateVictimBuffer
| | | | | | |
| | | | | | |--0.95%--BufTableDelete
| | | | | | | |
| | | | | | | --0.91%--hash_search_with_hash_value
| | | | | | |
| | | | | | |--0.93%--BufTableHashCode
| | | | | | | |
| | | | | | | --0.90%--get_hash_value
| | | | | | | |
| | | | | | | --0.84%--tag_hash
| | | | | | | |
| | | | | | | --0.81%--hash_bytes
| | | | | | |
| | | | | | --0.56%--LWLockAcquire
| | | | | |
| | | | | |--0.96%--LWLockAcquire
| | | | | | |
| | | | | | --0.80%--LWLockAttemptLock
| | | | | |
| | | | | |--0.95%--BufTableHashCode
| | | | | | |
| | | | | | --0.93%--get_hash_value
| | | | | | |
| | | | | | --0.89%--tag_hash
| | | | | | |
| | | | | | --0.83%--hash_bytes
| | | | | |
| | | | | |--0.77%--BufTableLookup
| | | | | | |
| | | | | | --0.71%--hash_search_with_hash_value
| | | | | |
| | | | | |--0.74%--BufTableInsert
| | | | | | |
| | | | | | --0.67%--hash_search_with_hash_value
| | | | | |
| | | | | |--0.71%--LWLockRelease
| | | | | |
| | | | | --0.71%--ReservePrivateRefCountEntry
| | | | | |
| | | | | --0.55%--hash_search
| | | | |
| | | | --0.84%--ReleaseBuffer
| | | | |
| | | | --0.79%--UnpinBuffer
| | | | |
| | | | --0.58%--UnpinBufferNoOwner
| | | |
| | | |--16.44%--heap_prepare_pagescan
| | | | |
| | | | |--14.71%--page_collect_tuples
| | | | | |
| | | | | |--6.82%--HeapTupleSatisfiesVisibility
| | | | | | |
| | | | | | --4.85%--HeapTupleSatisfiesMVCC
| | | | | | |
| | | | | | --2.41%--XidInMVCCSnapshot
| | | | | | |
| | | | | | --1.10%--TransactionIdPrecedes
| | | | | |
| | | | | |--1.91%--ItemPointerSet
| | | | | | |
| | | | | | --0.81%--BlockIdSet
| | | | | |
| | | | | --0.80%--PageGetItemId
| | | | |
| | | | --1.11%--LockBuffer
| | | | |
| | | | --0.55%--LWLockAcquire
| | | |
| | | |--2.54%--ItemPointerSet
| | | | |
| | | | --0.81%--BlockIdSet
| | | |
| | | |--1.13%--BufferGetPage
| | | | |
| | | | --0.74%--BufferGetBlock
| | | |
| | | |--0.83%--PageGetItemId
| | | |
| | | --0.64%--PageGetItem
| | |
| | --9.51%--ExecStoreBufferHeapTuple
| | |
| | --7.65%--tts_buffer_heap_store_tuple
| | |
| | |--2.47%--IncrBufferRefCount
| | | |
| | | --2.11%--GetPrivateRefCountEntry
| | | |
| | | --1.54%--hash_search
| | | |
| | | |--0.87%--hash_search_with_hash_value
| | | |
| | | --0.57%--uint32_hash
| | | |
| | | --0.54%--hash_bytes_uint32
| | |
| | --2.04%--ReleaseBuffer
| | |
| | --1.95%--UnpinBuffer
| | |
| | |--1.25%--UnpinBufferNoOwner
| | |
| | --0.63%--ResourceOwnerForgetBuffer
| | |
| | --0.56%--ResourceOwnerForget
| |
| --1.83%--ExecFetchSlotHeapTuple
| |
| --0.83%--tts_buffer_heap_get_heap_tuple
|
|--2.20%--TransactionIdPrecedes
|
--1.18%--MultiXactIdPrecedes
91.13% 0.00% postgres [.] PostmasterMain
|
---PostmasterMain
ServerLoop
BackendStartup
postmaster_child_launch
BackendMain
PostgresMain
exec_simple_query
PortalRun
PortalRunMulti
PortalRunUtility
ProcessUtility
standard_ProcessUtility
ExecVacuum
vacuum
vac_update_datfrozenxid
|
|--81.42%--systable_getnext
| |
| |--76.61%--table_scan_getnextslot
| | |
| | --73.16%--heap_getnextslot
| | |
| | |--57.95%--heapgettup_pagemode
| | | |
| | | |--30.65%--heap_fetch_next_buffer
| | | | |
| | | | |--29.43%--read_stream_next_buffer
| | | | | |
| | | | | |--17.13%--WaitReadBuffers
| | | | | | |
| | | | | | |--13.62%--smgrreadv
| | | | | | | |
| | | | | | | --13.58%--mdreadv
| | | | | | | |
| | | | | | | --13.47%--FileReadV
| | | | | | | |
| | | | | | | --13.41%--pg_preadv
| | | | | | | |
| | | | | | | |--6.71%--__libc_pread64 (inlined)
| | | | | | | | |
| | | | | | | | --6.68%--entry_SYSCALL_64_after_hwframe
| | | | | | | | do_syscall_64
| | | | | | | | |
| | | | | | | | --6.66%--x64_sys_call
| | | | | | | | __x64_sys_pread64
| | | | | | | | |
| | | | | | | | --6.62%--vfs_read
| | | | | | | | |
| | | | | | | | --6.57%--ext4_file_read_iter
| | | | | | | | generic_file_read_iter
| | | | | | | | |
| | | | | | | | --6.53%--filemap_read
| | | | | | | | |
| | | | | | | | --5.57%--copy_page_to_iter
| | | | | | | | |
| | | | | | | | --5.45%--_copy_to_iter
| | | | | | | |
| | | | | | | --6.70%--__GI_preadv64 (inlined)
| | | | | | | |
| | | | | | | --6.64%--entry_SYSCALL_64_after_hwframe
| | | | | | | |
| | | | | | | --6.64%--do_syscall_64
| | | | | | | |
| | | | | | | --6.58%--x64_sys_call
| | | | | | | |
| | | | | | | --6.57%--__x64_sys_preadv
| | | | | | | |
| | | | | | | --6.55%--vfs_readv
| | | | | | | |
| | | | | | | --6.48%--do_iter_readv_writev
| | | | | | | |
| | | | | | | --6.47%--ext4_file_read_iter
| | | | | | | generic_file_read_iter
| | | | | | | |
| | | | | | | --6.46%--filemap_read
| | | | | | | |
| | | | | | | --5.72%--copy_page_to_iter
| | | | | | | |
| | | | | | | --5.63%--_copy_to_iter
| | | | | | |
| | | | | | |--1.58%--TerminateBufferIO
| | | | | | |
| | | | | | --1.30%--WaitReadBuffersCanStartIO
| | | | | | |
| | | | | | --1.24%--StartBufferIO
| | | | | | |
| | | | | | --0.55%--ResourceOwnerEnlarge
| | | | | |
| | | | | --11.90%--read_stream_look_ahead
| | | | | |
| | | | | --11.33%--read_stream_start_pending_read
| | | | | |
| | | | | --11.30%--StartReadBuffers
| | | | | StartReadBuffersImpl
| | | | | |
| | | | | --11.17%--PinBufferForBlock
| | | | | |
| | | | | --10.94%--BufferAlloc
| | | | | |
| | | | | |--5.08%--GetVictimBuffer
| | | | | | |
| | | | | | --3.45%--InvalidateVictimBuffer
| | | | | | |
| | | | | | |--0.95%--BufTableDelete
| | | | | | | |
| | | | | | | --0.91%--hash_search_with_hash_value
| | | | | | |
| | | | | | |--0.93%--BufTableHashCode
| | | | | | | |
| | | | | | | --0.90%--get_hash_value
| | | | | | | |
| | | | | | | --0.84%--tag_hash
| | | | | | | |
| | | | | | | --0.81%--hash_bytes
| | | | | | |
| | | | | | --0.56%--LWLockAcquire
| | | | | |
| | | | | |--0.96%--LWLockAcquire
| | | | | | |
| | | | | | --0.80%--LWLockAttemptLock
| | | | | |
| | | | | |--0.95%--BufTableHashCode
| | | | | | |
| | | | | | --0.93%--get_hash_value
| | | | | | |
| | | | | | --0.89%--tag_hash
| | | | | | |
| | | | | | --0.83%--hash_bytes
| | | | | |
| | | | | |--0.77%--BufTableLookup
| | | | | | |
| | | | | | --0.71%--hash_search_with_hash_value
| | | | | |
| | | | | |--0.74%--BufTableInsert
| | | | | | |
| | | | | | --0.67%--hash_search_with_hash_value
| | | | | |
| | | | | |--0.71%--LWLockRelease
| | | | | |
| | | | | --0.71%--ReservePrivateRefCountEntry
| | | | | |
| | | | | --0.55%--hash_search
| | | | |
| | | | --0.84%--ReleaseBuffer
| | | | |
| | | | --0.79%--UnpinBuffer
| | | | |
| | | | --0.58%--UnpinBufferNoOwner
| | | |
| | | |--16.44%--heap_prepare_pagescan
| | | | |
| | | | |--14.71%--page_collect_tuples
| | | | | |
| | | | | |--6.82%--HeapTupleSatisfiesVisibility
| | | | | | |
| | | | | | --4.85%--HeapTupleSatisfiesMVCC
| | | | | | |
| | | | | | --2.41%--XidInMVCCSnapshot
| | | | | | |
| | | | | | --1.10%--TransactionIdPrecedes
| | | | | |
| | | | | |--1.91%--ItemPointerSet
| | | | | | |
| | | | | | --0.81%--BlockIdSet
| | | | | |
| | | | | --0.80%--PageGetItemId
| | | | |
| | | | --1.11%--LockBuffer
| | | | |
| | | | --0.55%--LWLockAcquire
| | | |
| | | |--2.54%--ItemPointerSet
| | | | |
| | | | --0.81%--BlockIdSet
| | | |
| | | |--1.13%--BufferGetPage
| | | | |
| | | | --0.74%--BufferGetBlock
| | | |
| | | |--0.83%--PageGetItemId
| | | |
| | | --0.64%--PageGetItem
| | |
| | --9.51%--ExecStoreBufferHeapTuple
| | |
| | --7.65%--tts_buffer_heap_store_tuple
| | |
| | |--2.47%--IncrBufferRefCount
| | | |
| | | --2.11%--GetPrivateRefCountEntry
| | | |
| | | --1.54%--hash_search
| | | |
| | | |--0.87%--hash_search_with_hash_value
| | | |
| | | --0.57%--uint32_hash
| | | |
| | | --0.54%--hash_bytes_uint32
| | |
| | --2.04%--ReleaseBuffer
| | |
| | --1.95%--UnpinBuffer
| | |
| | |--1.25%--UnpinBufferNoOwner
| | |
| | --0.63%--ResourceOwnerForgetBuffer
| | |
| | --0.56%--ResourceOwnerForget
| |
| --1.83%--ExecFetchSlotHeapTuple
| |
| --0.83%--tts_buffer_heap_get_heap_tuple
|
|--2.20%--TransactionIdPrecedes
|
--1.18%--MultiXactIdPrecedes
91.13% 0.00% postgres [.] ServerLoop
|
---ServerLoop
BackendStartup
postmaster_child_launch
BackendMain
PostgresMain
exec_simple_query
PortalRun
PortalRunMulti
PortalRunUtility
ProcessUtility
standard_ProcessUtility
ExecVacuum
vacuum
vac_update_datfrozenxid
|
|--81.42%--systable_getnext
| |
| |--76.61%--table_scan_getnextslot
| | |
| | --73.16%--heap_getnextslot
| | |
| | |--57.95%--heapgettup_pagemode
| | | |
| | | |--30.65%--heap_fetch_next_buffer
| | | | |
| | | | |--29.43%--read_stream_next_buffer
| | | | | |
| | | | | |--17.13%--WaitReadBuffers
| | | | | | |
| | | | | | |--13.62%--smgrreadv
| | | | | | | |
| | | | | | | --13.58%--mdreadv
| | | | | | | |
| | | | | | | --13.47%--FileReadV
| | | | | | | |
| | | | | | | --13.41%--pg_preadv
| | | | | | | |
| | | | | | | |--6.71%--__libc_pread64 (inlined)
| | | | | | | | |
| | | | | | | | --6.68%--entry_SYSCALL_64_after_hwframe
| | | | | | | | do_syscall_64
| | | | | | | | |
| | | | | | | | --6.66%--x64_sys_call
| | | | | | | | __x64_sys_pread64
| | | | | | | | |
| | | | | | | | --6.62%--vfs_read
| | | | | | | | |
| | | | | | | | --6.57%--ext4_file_read_iter
| | | | | | | | generic_file_read_iter
| | | | | | | | |
| | | | | | | | --6.53%--filemap_read
| | | | | | | | |
| | | | | | | | --5.57%--copy_page_to_iter
| | | | | | | | |
| | | | | | | | --5.45%--_copy_to_iter
| | | | | | | |
| | | | | | | --6.70%--__GI_preadv64 (inlined)
| | | | | | | |
| | | | | | | --6.64%--entry_SYSCALL_64_after_hwframe
| | | | | | | |
| | | | | | | --6.64%--do_syscall_64
| | | | | | | |
| | | | | | | --6.58%--x64_sys_call
| | | | | | | |
| | | | | | | --6.57%--__x64_sys_preadv
| | | | | | | |
| | | | | | | --6.55%--vfs_readv
| | | | | | | |
| | | | | | | --6.48%--do_iter_readv_writev
| | | | | | | |
| | | | | | | --6.47%--ext4_file_read_iter
| | | | | | | generic_file_read_iter
| | | | | | | |
| | | | | | | --6.46%--filemap_read
| | | | | | | |
| | | | | | | --5.72%--copy_page_to_iter
| | | | | | | |
| | | | | | | --5.63%--_copy_to_iter
| | | | | | |
| | | | | | |--1.58%--TerminateBufferIO
| | | | | | |
| | | | | | --1.30%--WaitReadBuffersCanStartIO
| | | | | | |
| | | | | | --1.24%--StartBufferIO
| | | | | | |
| | | | | | --0.55%--ResourceOwnerEnlarge
| | | | | |
| | | | | --11.90%--read_stream_look_ahead
| | | | | |
| | | | | --11.33%--read_stream_start_pending_read
| | | | | |
| | | | | --11.30%--StartReadBuffers
| | | | | StartReadBuffersImpl
| | | | | |
| | | | | --11.17%--PinBufferForBlock
| | | | | |
| | | | | --10.94%--BufferAlloc
| | | | | |
| | | | | |--5.08%--GetVictimBuffer
| | | | | | |
| | | | | | --3.45%--InvalidateVictimBuffer
| | | | | | |
| | | | | | |--0.95%--BufTableDelete
| | | | | | | |
| | | | | | | --0.91%--hash_search_with_hash_value
| | | | | | |
| | | | | | |--0.93%--BufTableHashCode
| | | | | | | |
| | | | | | | --0.90%--get_hash_value
| | | | | | | |
| | | | | | | --0.84%--tag_hash
| | | | | | | |
| | | | | | | --0.81%--hash_bytes
| | | | | | |
| | | | | | --0.56%--LWLockAcquire
| | | | | |
| | | | | |--0.96%--LWLockAcquire
| | | | | | |
| | | | | | --0.80%--LWLockAttemptLock
| | | | | |
| | | | | |--0.95%--BufTableHashCode
| | | | | | |
| | | | | | --0.93%--get_hash_value
| | | | | | |
| | | | | | --0.89%--tag_hash
| | | | | | |
| | | | | | --0.83%--hash_bytes
| | | | | |
| | | | | |--0.77%--BufTableLookup
| | | | | | |
| | | | | | --0.71%--hash_search_with_hash_value
| | | | | |
| | | | | |--0.74%--BufTableInsert
| | | | | | |
| | | | | | --0.67%--hash_search_with_hash_value
| | | | | |
| | | | | |--0.71%--LWLockRelease
| | | | | |
| | | | | --0.71%--ReservePrivateRefCountEntry
| | | | | |
| | | | | --0.55%--hash_search
| | | | |
| | | | --0.84%--ReleaseBuffer
| | | | |
| | | | --0.79%--UnpinBuffer
| | | | |
| | | | --0.58%--UnpinBufferNoOwner
| | | |
| | | |--16.44%--heap_prepare_pagescan
| | | | |
| | | | |--14.71%--page_collect_tuples
| | | | | |
| | | | | |--6.82%--HeapTupleSatisfiesVisibility
| | | | | | |
| | | | | | --4.85%--HeapTupleSatisfiesMVCC
| | | | | | |
| | | | | | --2.41%--XidInMVCCSnapshot
| | | | | | |
| | | | | | --1.10%--TransactionIdPrecedes
| | | | | |
| | | | | |--1.91%--ItemPointerSet
| | | | | | |
| | | | | | --0.81%--BlockIdSet
| | | | | |
| | | | | --0.80%--PageGetItemId
| | | | |
| | | | --1.11%--LockBuffer
| | | | |
| | | | --0.55%--LWLockAcquire
| | | |
| | | |--2.54%--ItemPointerSet
| | | | |
| | | | --0.81%--BlockIdSet
| | | |
| | | |--1.13%--BufferGetPage
| | | | |
| | | | --0.74%--BufferGetBlock
| | | |
| | | |--0.83%--PageGetItemId
| | | |
| | | --0.64%--PageGetItem
| | |
| | --9.51%--ExecStoreBufferHeapTuple
| | |
| | --7.65%--tts_buffer_heap_store_tuple
| | |
| | |--2.47%--IncrBufferRefCount
| | | |
| | | --2.11%--GetPrivateRefCountEntry
| | | |
| | | --1.54%--hash_search
| | | |
| | | |--0.87%--hash_search_with_hash_value
| | | |
| | | --0.57%--uint32_hash
| | | |
| | | --0.54%--hash_bytes_uint32
| | |
| | --2.04%--ReleaseBuffer
| | |
| | --1.95%--UnpinBuffer
| | |
| | |--1.25%--UnpinBufferNoOwner
| | |
| | --0.63%--ResourceOwnerForgetBuffer
| | |
| | --0.56%--ResourceOwnerForget
| |
| --1.83%--ExecFetchSlotHeapTuple
| |
| --0.83%--tts_buffer_heap_get_heap_tuple
|
|--2.20%--TransactionIdPrecedes
|
--1.18%--MultiXactIdPrecedes
91.13% 0.00% postgres [.] BackendStartup
|
---BackendStartup
postmaster_child_launch
BackendMain
PostgresMain
exec_simple_query
PortalRun
PortalRunMulti
PortalRunUtility
ProcessUtility
standard_ProcessUtility
ExecVacuum
vacuum
vac_update_datfrozenxid
|
|--81.42%--systable_getnext
| |
| |--76.61%--table_scan_getnextslot
| | |
| | --73.16%--heap_getnextslot
| | |
| | |--57.95%--heapgettup_pagemode
| | | |
| | | |--30.65%--heap_fetch_next_buffer
| | | | |
| | | | |--29.43%--read_stream_next_buffer
| | | | | |
| | | | | |--17.13%--WaitReadBuffers
| | | | | | |
| | | | | | |--13.62%--smgrreadv
| | | | | | | |
| | | | | | | --13.58%--mdreadv
| | | | | | | |
| | | | | | | --13.47%--FileReadV
| | | | | | | |
| | | | | | | --13.41%--pg_preadv
| | | | | | | |
| | | | | | | |--6.71%--__libc_pread64 (inlined)
| | | | | | | | |
| | | | | | | | --6.68%--entry_SYSCALL_64_after_hwframe
| | | | | | | | do_syscall_64
| | | | | | | | |
| | | | | | | | --6.66%--x64_sys_call
| | | | | | | | __x64_sys_pread64
| | | | | | | | |
| | | | | | | | --6.62%--vfs_read
| | | | | | | | |
| | | | | | | | --6.57%--ext4_file_read_iter
| | | | | | | | generic_file_read_iter
| | | | | | | | |
| | | | | | | | --6.53%--filemap_read
| | | | | | | | |
| | | | | | | | --5.57%--copy_page_to_iter
| | | | | | | | |
| | | | | | | | --5.45%--_copy_to_iter
| | | | | | | |
| | | | | | | --6.70%--__GI_preadv64 (inlined)
| | | | | | | |
| | | | | | | --6.64%--entry_SYSCALL_64_after_hwframe
| | | | | | | |
| | | | | | | --6.64%--do_syscall_64
| | | | | | | |
| | | | | | | --6.58%--x64_sys_call
| | | | | | | |
| | | | | | | --6.57%--__x64_sys_preadv
| | | | | | | |
| | | | | | | --6.55%--vfs_readv
| | | | | | | |
| | | | | | | --6.48%--do_iter_readv_writev
| | | | | | | |
| | | | | | | --6.47%--ext4_file_read_iter
| | | | | | | generic_file_read_iter
| | | | | | | |
| | | | | | | --6.46%--filemap_read
| | | | | | | |
| | | | | | | --5.72%--copy_page_to_iter
| | | | | | | |
| | | | | | | --5.63%--_copy_to_iter
| | | | | | |
| | | | | | |--1.58%--TerminateBufferIO
| | | | | | |
| | | | | | --1.30%--WaitReadBuffersCanStartIO
| | | | | | |
| | | | | | --1.24%--StartBufferIO
| | | | | | |
| | | | | | --0.55%--ResourceOwnerEnlarge
| | | | | |
| | | | | --11.90%--read_stream_look_ahead
| | | | | |
| | | | | --11.33%--read_stream_start_pending_read
| | | | | |
| | | | | --11.30%--StartReadBuffers
| | | | | StartReadBuffersImpl
| | | | | |
| | | | | --11.17%--PinBufferForBlock
| | | | | |
| | | | | --10.94%--BufferAlloc
| | | | | |
| | | | | |--5.08%--GetVictimBuffer
| | | | | | |
| | | | | | --3.45%--InvalidateVictimBuffer
| | | | | | |
| | | | | | |--0.95%--BufTableDelete
| | | | | | | |
| | | | | | | --0.91%--hash_search_with_hash_value
| | | | | | |
| | | | | | |--0.93%--BufTableHashCode
| | | | | | | |
| | | | | | | --0.90%--get_hash_value
| | | | | | | |
| | | | | | | --0.84%--tag_hash
| | | | | | | |
| | | | | | | --0.81%--hash_bytes
| | | | | | |
| | | | | | --0.56%--LWLockAcquire
| | | | | |
| | | | | |--0.96%--LWLockAcquire
| | | | | | |
| | | | | | --0.80%--LWLockAttemptLock
| | | | | |
| | | | | |--0.95%--BufTableHashCode
| | | | | | |
| | | | | | --0.93%--get_hash_value
| | | | | | |
| | | | | | --0.89%--tag_hash
| | | | | | |
| | | | | | --0.83%--hash_bytes
| | | | | |
| | | | | |--0.77%--BufTableLookup
| | | | | | |
| | | | | | --0.71%--hash_search_with_hash_value
| | | | | |
| | | | | |--0.74%--BufTableInsert
| | | | | | |
| | | | | | --0.67%--hash_search_with_hash_value
| | | | | |
| | | | | |--0.71%--LWLockRelease
| | | | | |
| | | | | --0.71%--ReservePrivateRefCountEntry
| | | | | |
| | | | | --0.55%--hash_search
| | | | |
| | | | --0.84%--ReleaseBuffer
| | | | |
| | | | --0.79%--UnpinBuffer
| | | | |
| | | | --0.58%--UnpinBufferNoOwner
| | | |
| | | |--16.44%--heap_prepare_pagescan
| | | | |
| | | | |--14.71%--page_collect_tuples
| | | | | |
| | | | | |--6.82%--HeapTupleSatisfiesVisibility
| | | | | | |
| | | | | | --4.85%--HeapTupleSatisfiesMVCC
| | | | | | |
| | | | | | --2.41%--XidInMVCCSnapshot
| | | | | | |
| | | | | | --1.10%--TransactionIdPrecedes
| | | | | |
| | | | | |--1.91%--ItemPointerSet
| | | | | | |
| | | | | | --0.81%--BlockIdSet
| | | | | |
| | | | | --0.80%--PageGetItemId
| | | | |
| | | | --1.11%--LockBuffer
| | | | |
| | | | --0.55%--LWLockAcquire
| | | |
| | | |--2.54%--ItemPointerSet
| | | | |
| | | | --0.81%--BlockIdSet
| | | |
| | | |--1.13%--BufferGetPage
| | | | |
| | | | --0.74%--BufferGetBlock
| | | |
| | | |--0.83%--PageGetItemId
| | | |
| | | --0.64%--PageGetItem
| | |
| | --9.51%--ExecStoreBufferHeapTuple
| | |
| | --7.65%--tts_buffer_heap_store_tuple
| | |
| | |--2.47%--IncrBufferRefCount
| | | |
| | | --2.11%--GetPrivateRefCountEntry
| | | |
| | | --1.54%--hash_search
| | | |
| | | |--0.87%--hash_search_with_hash_value
| | | |
| | | --0.57%--uint32_hash
| | | |
| | | --0.54%--hash_bytes_uint32
| | |
| | --2.04%--ReleaseBuffer
| | |
| | --1.95%--UnpinBuffer
| | |
| | |--1.25%--UnpinBufferNoOwner
| | |
| | --0.63%--ResourceOwnerForgetBuffer
| | |
| | --0.56%--ResourceOwnerForget
| |
| --1.83%--ExecFetchSlotHeapTuple
| |
| --0.83%--tts_buffer_heap_get_heap_tuple
|
|--2.20%--TransactionIdPrecedes
|
--1.18%--MultiXactIdPrecedes
91.13% 0.00% postgres [.] postmaster_child_launch
|
---postmaster_child_launch
BackendMain
PostgresMain
exec_simple_query
PortalRun
PortalRunMulti
PortalRunUtility
ProcessUtility
standard_ProcessUtility
ExecVacuum
vacuum
vac_update_datfrozenxid
|
|--81.42%--systable_getnext
| |
| |--76.61%--table_scan_getnextslot
| | |
| | --73.16%--heap_getnextslot
| | |
| | |--57.95%--heapgettup_pagemode
| | | |
| | | |--30.65%--heap_fetch_next_buffer
| | | | |
| | | | |--29.43%--read_stream_next_buffer
| | | | | |
| | | | | |--17.13%--WaitReadBuffers
| | | | | | |
| | | | | | |--13.62%--smgrreadv
| | | | | | | |
| | | | | | | --13.58%--mdreadv
| | | | | | | |
| | | | | | | --13.47%--FileReadV
| | | | | | | |
| | | | | | | --13.41%--pg_preadv
| | | | | | | |
| | | | | | | |--6.71%--__libc_pread64 (inlined)
| | | | | | | | |
| | | | | | | | --6.68%--entry_SYSCALL_64_after_hwframe
| | | | | | | | do_syscall_64
| | | | | | | | |
| | | | | | | | --6.66%--x64_sys_call
| | | | | | | | __x64_sys_pread64
| | | | | | | | |
| | | | | | | | --6.62%--vfs_read
| | | | | | | | |
| | | | | | | | --6.57%--ext4_file_read_iter
| | | | | | | | generic_file_read_iter
| | | | | | | | |
| | | | | | | | --6.53%--filemap_read
| | | | | | | | |
| | | | | | | | --5.57%--copy_page_to_iter
| | | | | | | | |
| | | | | | | | --5.45%--_copy_to_iter
| | | | | | | |
| | | | | | | --6.70%--__GI_preadv64 (inlined)
| | | | | | | |
| | | | | | | --6.64%--entry_SYSCALL_64_after_hwframe
| | | | | | | |
| | | | | | | --6.64%--do_syscall_64
| | | | | | | |
| | | | | | | --6.58%--x64_sys_call
| | | | | | | |
| | | | | | | --6.57%--__x64_sys_preadv
| | | | | | | |
| | | | | | | --6.55%--vfs_readv
| | | | | | | |
| | | | | | | --6.48%--do_iter_readv_writev
| | | | | | | |
| | | | | | | --6.47%--ext4_file_read_iter
| | | | | | | generic_file_read_iter
| | | | | | | |
| | | | | | | --6.46%--filemap_read
| | | | | | | |
| | | | | | | --5.72%--copy_page_to_iter
| | | | | | | |
| | | | | | | --5.63%--_copy_to_iter
| | | | | | |
| | | | | | |--1.58%--TerminateBufferIO
| | | | | | |
| | | | | | --1.30%--WaitReadBuffersCanStartIO
| | | | | | |
| | | | | | --1.24%--StartBufferIO
| | | | | | |
| | | | | | --0.55%--ResourceOwnerEnlarge
| | | | | |
| | | | | --11.90%--read_stream_look_ahead
| | | | | |
| | | | | --11.33%--read_stream_start_pending_read
| | | | | |
| | | | | --11.30%--StartReadBuffers
| | | | | StartReadBuffersImpl
| | | | | |
| | | | | --11.17%--PinBufferForBlock
| | | | | |
| | | | | --10.94%--BufferAlloc
| | | | | |
| | | | | |--5.08%--GetVictimBuffer
| | | | | | |
| | | | | | --3.45%--InvalidateVictimBuffer
| | | | | | |
| | | | | | |--0.95%--BufTableDelete
| | | | | | | |
| | | | | | | --0.91%--hash_search_with_hash_value
| | | | | | |
| | | | | | |--0.93%--BufTableHashCode
| | | | | | | |
| | | | | | | --0.90%--get_hash_value
| | | | | | | |
| | | | | | | --0.84%--tag_hash
| | | | | | | |
| | | | | | | --0.81%--hash_bytes
| | | | | | |
| | | | | | --0.56%--LWLockAcquire
| | | | | |
| | | | | |--0.96%--LWLockAcquire
| | | | | | |
| | | | | | --0.80%--LWLockAttemptLock
| | | | | |
| | | | | |--0.95%--BufTableHashCode
| | | | | | |
| | | | | | --0.93%--get_hash_value
| | | | | | |
| | | | | | --0.89%--tag_hash
| | | | | | |
| | | | | | --0.83%--hash_bytes
| | | | | |
| | | | | |--0.77%--BufTableLookup
| | | | | | |
| | | | | | --0.71%--hash_search_with_hash_value
| | | | | |
| | | | | |--0.74%--BufTableInsert
| | | | | | |
| | | | | | --0.67%--hash_search_with_hash_value
| | | | | |
| | | | | |--0.71%--LWLockRelease
| | | | | |
| | | | | --0.71%--ReservePrivateRefCountEntry
| | | | | |
| | | | | --0.55%--hash_search
| | | | |
| | | | --0.84%--ReleaseBuffer
| | | | |
| | | | --0.79%--UnpinBuffer
| | | | |
| | | | --0.58%--UnpinBufferNoOwner
| | | |
| | | |--16.44%--heap_prepare_pagescan
| | | | |
| | | | |--14.71%--page_collect_tuples
| | | | | |
| | | | | |--6.82%--HeapTupleSatisfiesVisibility
| | | | | | |
| | | | | | --4.85%--HeapTupleSatisfiesMVCC
| | | | | | |
| | | | | | --2.41%--XidInMVCCSnapshot
| | | | | | |
| | | | | | --1.10%--TransactionIdPrecedes
| | | | | |
| | | | | |--1.91%--ItemPointerSet
| | | | | | |
| | | | | | --0.81%--BlockIdSet
| | | | | |
| | | | | --0.80%--PageGetItemId
| | | | |
| | | | --1.11%--LockBuffer
| | | | |
| | | | --0.55%--LWLockAcquire
| | | |
| | | |--2.54%--ItemPointerSet
| | | | |
| | | | --0.81%--BlockIdSet
| | | |
| | | |--1.13%--BufferGetPage
| | | | |
| | | | --0.74%--BufferGetBlock
| | | |
| | | |--0.83%--PageGetItemId
| | | |
| | | --0.64%--PageGetItem
| | |
| | --9.51%--ExecStoreBufferHeapTuple
| | |
| | --7.65%--tts_buffer_heap_store_tuple
| | |
| | |--2.47%--IncrBufferRefCount
| | | |
| | | --2.11%--GetPrivateRefCountEntry
| | | |
| | | --1.54%--hash_search
| | | |
| | | |--0.87%--hash_search_with_hash_value
| | | |
| | | --0.57%--uint32_hash
| | | |
| | | --0.54%--hash_bytes_uint32
| | |
| | --2.04%--ReleaseBuffer
| | |
| | --1.95%--UnpinBuffer
| | |
| | |--1.25%--UnpinBufferNoOwner
| | |
| | --0.63%--ResourceOwnerForgetBuffer
| | |
| | --0.56%--ResourceOwnerForget
| |
| --1.83%--ExecFetchSlotHeapTuple
| |
| --0.83%--tts_buffer_heap_get_heap_tuple
|
|--2.20%--TransactionIdPrecedes
|
--1.18%--MultiXactIdPrecedes
91.13% 0.00% postgres [.] BackendMain
|
---BackendMain
PostgresMain
exec_simple_query
PortalRun
PortalRunMulti
PortalRunUtility
ProcessUtility
standard_ProcessUtility
ExecVacuum
vacuum
vac_update_datfrozenxid
|
|--81.42%--systable_getnext
| |
| |--76.61%--table_scan_getnextslot
| | |
| | --73.16%--heap_getnextslot
| | |
| | |--57.95%--heapgettup_pagemode
| | | |
| | | |--30.65%--heap_fetch_next_buffer
| | | | |
| | | | |--29.43%--read_stream_next_buffer
| | | | | |
| | | | | |--17.13%--WaitReadBuffers
| | | | | | |
| | | | | | |--13.62%--smgrreadv
| | | | | | | |
| | | | | | | --13.58%--mdreadv
| | | | | | | |
| | | | | | | --13.47%--FileReadV
| | | | | | | |
| | | | | | | --13.41%--pg_preadv
| | | | | | | |
| | | | | | | |--6.71%--__libc_pread64 (inlined)
| | | | | | | | |
| | | | | | | | --6.68%--entry_SYSCALL_64_after_hwframe
| | | | | | | | do_syscall_64
| | | | | | | | |
| | | | | | | | --6.66%--x64_sys_call
| | | | | | | | __x64_sys_pread64
| | | | | | | | |
| | | | | | | | --6.62%--vfs_read
| | | | | | | | |
| | | | | | | | --6.57%--ext4_file_read_iter
| | | | | | | | generic_file_read_iter
| | | | | | | | |
| | | | | | | | --6.53%--filemap_read
| | | | | | | | |
| | | | | | | | --5.57%--copy_page_to_iter
| | | | | | | | |
| | | | | | | | --5.45%--_copy_to_iter
| | | | | | | |
| | | | | | | --6.70%--__GI_preadv64 (inlined)
| | | | | | | |
| | | | | | | --6.64%--entry_SYSCALL_64_after_hwframe
| | | | | | | |
| | | | | | | --6.64%--do_syscall_64
| | | | | | | |
| | | | | | | --6.58%--x64_sys_call
| | | | | | | |
| | | | | | | --6.57%--__x64_sys_preadv
| | | | | | | |
| | | | | | | --6.55%--vfs_readv
| | | | | | | |
| | | | | | | --6.48%--do_iter_readv_writev
| | | | | | | |
| | | | | | | --6.47%--ext4_file_read_iter
| | | | | | | generic_file_read_iter
| | | | | | | |
| | | | | | | --6.46%--filemap_read
| | | | | | | |
| | | | | | | --5.72%--copy_page_to_iter
| | | | | | | |
| | | | | | | --5.63%--_copy_to_iter
| | | | | | |
| | | | | | |--1.58%--TerminateBufferIO
| | | | | | |
| | | | | | --1.30%--WaitReadBuffersCanStartIO
| | | | | | |
| | | | | | --1.24%--StartBufferIO
| | | | | | |
| | | | | | --0.55%--ResourceOwnerEnlarge
| | | | | |
| | | | | --11.90%--read_stream_look_ahead
| | | | | |
| | | | | --11.33%--read_stream_start_pending_read
| | | | | |
| | | | | --11.30%--StartReadBuffers
| | | | | StartReadBuffersImpl
| | | | | |
| | | | | --11.17%--PinBufferForBlock
| | | | | |
| | | | | --10.94%--BufferAlloc
| | | | | |
| | | | | |--5.08%--GetVictimBuffer
| | | | | | |
| | | | | | --3.45%--InvalidateVictimBuffer
| | | | | | |
| | | | | | |--0.95%--BufTableDelete
| | | | | | | |
| | | | | | | --0.91%--hash_search_with_hash_value
| | | | | | |
| | | | | | |--0.93%--BufTableHashCode
| | | | | | | |
| | | | | | | --0.90%--get_hash_value
| | | | | | | |
| | | | | | | --0.84%--tag_hash
| | | | | | | |
| | | | | | | --0.81%--hash_bytes
| | | | | | |
| | | | | | --0.56%--LWLockAcquire
| | | | | |
| | | | | |--0.96%--LWLockAcquire
| | | | | | |
| | | | | | --0.80%--LWLockAttemptLock
| | | | | |
| | | | | |--0.95%--BufTableHashCode
| | | | | | |
| | | | | | --0.93%--get_hash_value
| | | | | | |
| | | | | | --0.89%--tag_hash
| | | | | | |
| | | | | | --0.83%--hash_bytes
| | | | | |
| | | | | |--0.77%--BufTableLookup
| | | | | | |
| | | | | | --0.71%--hash_search_with_hash_value
| | | | | |
| | | | | |--0.74%--BufTableInsert
| | | | | | |
| | | | | | --0.67%--hash_search_with_hash_value
| | | | | |
| | | | | |--0.71%--LWLockRelease
| | | | | |
| | | | | --0.71%--ReservePrivateRefCountEntry
| | | | | |
| | | | | --0.55%--hash_search
| | | | |
| | | | --0.84%--ReleaseBuffer
| | | | |
| | | | --0.79%--UnpinBuffer
| | | | |
| | | | --0.58%--UnpinBufferNoOwner
| | | |
| | | |--16.44%--heap_prepare_pagescan
| | | | |
| | | | |--14.71%--page_collect_tuples
| | | | | |
| | | | | |--6.82%--HeapTupleSatisfiesVisibility
| | | | | | |
| | | | | | --4.85%--HeapTupleSatisfiesMVCC
| | | | | | |
| | | | | | --2.41%--XidInMVCCSnapshot
| | | | | | |
| | | | | | --1.10%--TransactionIdPrecedes
| | | | | |
| | | | | |--1.91%--ItemPointerSet
| | | | | | |
| | | | | | --0.81%--BlockIdSet
| | | | | |
| | | | | --0.80%--PageGetItemId
| | | | |
| | | | --1.11%--LockBuffer
| | | | |
| | | | --0.55%--LWLockAcquire
| | | |
| | | |--2.54%--ItemPointerSet
| | | | |
| | | | --0.81%--BlockIdSet
| | | |
| | | |--1.13%--BufferGetPage
| | | | |
| | | | --0.74%--BufferGetBlock
| | | |
| | | |--0.83%--PageGetItemId
| | | |
| | | --0.64%--PageGetItem
| | |
| | --9.51%--ExecStoreBufferHeapTuple
| | |
| | --7.65%--tts_buffer_heap_store_tuple
| | |
| | |--2.47%--IncrBufferRefCount
| | | |
| | | --2.11%--GetPrivateRefCountEntry
| | | |
| | | --1.54%--hash_search
| | | |
| | | |--0.87%--hash_search_with_hash_value
| | | |
| | | --0.57%--uint32_hash
| | | |
| | | --0.54%--hash_bytes_uint32
| | |
| | --2.04%--ReleaseBuffer
| | |
| | --1.95%--UnpinBuffer
| | |
| | |--1.25%--UnpinBufferNoOwner
| | |
| | --0.63%--ResourceOwnerForgetBuffer
| | |
| | --0.56%--ResourceOwnerForget
| |
| --1.83%--ExecFetchSlotHeapTuple
| |
| --0.83%--tts_buffer_heap_get_heap_tuple
|
|--2.20%--TransactionIdPrecedes
|
--1.18%--MultiXactIdPrecedes
91.13% 0.00% postgres [.] PostgresMain
|
---PostgresMain
exec_simple_query
PortalRun
PortalRunMulti
PortalRunUtility
ProcessUtility
standard_ProcessUtility
ExecVacuum
vacuum
vac_update_datfrozenxid
|
|--81.42%--systable_getnext
| |
| |--76.61%--table_scan_getnextslot
| | |
| | --73.16%--heap_getnextslot
| | |
| | |--57.95%--heapgettup_pagemode
| | | |
| | | |--30.65%--heap_fetch_next_buffer
| | | | |
| | | | |--29.43%--read_stream_next_buffer
| | | | | |
| | | | | |--17.13%--WaitReadBuffers
| | | | | | |
| | | | | | |--13.62%--smgrreadv
| | | | | | | |
| | | | | | | --13.58%--mdreadv
| | | | | | | |
| | | | | | | --13.47%--FileReadV
| | | | | | | |
| | | | | | | --13.41%--pg_preadv
| | | | | | | |
| | | | | | | |--6.71%--__libc_pread64 (inlined)
| | | | | | | | |
| | | | | | | | --6.68%--entry_SYSCALL_64_after_hwframe
| | | | | | | | do_syscall_64
| | | | | | | | |
| | | | | | | | --6.66%--x64_sys_call
| | | | | | | | __x64_sys_pread64
| | | | | | | | |
| | | | | | | | --6.62%--vfs_read
| | | | | | | | |
| | | | | | | | --6.57%--ext4_file_read_iter
| | | | | | | | generic_file_read_iter
| | | | | | | | |
| | | | | | | | --6.53%--filemap_read
| | | | | | | | |
| | | | | | | | --5.57%--copy_page_to_iter
| | | | | | | | |
| | | | | | | | --5.45%--_copy_to_iter
| | | | | | | |
| | | | | | | --6.70%--__GI_preadv64 (inlined)
| | | | | | | |
| | | | | | | --6.64%--entry_SYSCALL_64_after_hwframe
| | | | | | | |
| | | | | | | --6.64%--do_syscall_64
| | | | | | | |
| | | | | | | --6.58%--x64_sys_call
| | | | | | | |
| | | | | | | --6.57%--__x64_sys_preadv
| | | | | | | |
| | | | | | | --6.55%--vfs_readv
| | | | | | | |
| | | | | | | --6.48%--do_iter_readv_writev
| | | | | | | |
| | | | | | | --6.47%--ext4_file_read_iter
| | | | | | | generic_file_read_iter
| | | | | | | |
| | | | | | | --6.46%--filemap_read
| | | | | | | |
| | | | | | | --5.72%--copy_page_to_iter
| | | | | | | |
| | | | | | | --5.63%--_copy_to_iter
| | | | | | |
| | | | | | |--1.58%--TerminateBufferIO
| | | | | | |
| | | | | | --1.30%--WaitReadBuffersCanStartIO
| | | | | | |
| | | | | | --1.24%--StartBufferIO
| | | | | | |
| | | | | | --0.55%--ResourceOwnerEnlarge
| | | | | |
| | | | | --11.90%--read_stream_look_ahead
| | | | | |
| | | | | --11.33%--read_stream_start_pending_read
| | | | | |
| | | | | --11.30%--StartReadBuffers
| | | | | StartReadBuffersImpl
| | | | | |
| | | | | --11.17%--PinBufferForBlock
| | | | | |
| | | | | --10.94%--BufferAlloc
| | | | | |
| | | | | |--5.08%--GetVictimBuffer
| | | | | | |
| | | | | | --3.45%--InvalidateVictimBuffer
| | | | | | |
| | | | | | |--0.95%--BufTableDelete
| | | | | | | |
| | | | | | | --0.91%--hash_search_with_hash_value
| | | | | | |
| | | | | | |--0.93%--BufTableHashCode
| | | | | | | |
| | | | | | | --0.90%--get_hash_value
| | | | | | | |
| | | | | | | --0.84%--tag_hash
| | | | | | | |
| | | | | | | --0.81%--hash_bytes
| | | | | | |
| | | | | | --0.56%--LWLockAcquire
| | | | | |
| | | | | |--0.96%--LWLockAcquire
| | | | | | |
| | | | | | --0.80%--LWLockAttemptLock
| | | | | |
| | | | | |--0.95%--BufTableHashCode
| | | | | | |
| | | | | | --0.93%--get_hash_value
| | | | | | |
| | | | | | --0.89%--tag_hash
| | | | | | |
| | | | | | --0.83%--hash_bytes
| | | | | |
| | | | | |--0.77%--BufTableLookup
| | | | | | |
| | | | | | --0.71%--hash_search_with_hash_value
| | | | | |
| | | | | |--0.74%--BufTableInsert
| | | | | | |
| | | | | | --0.67%--hash_search_with_hash_value
| | | | | |
| | | | | |--0.71%--LWLockRelease
| | | | | |
| | | | | --0.71%--ReservePrivateRefCountEntry
| | | | | |
| | | | | --0.55%--hash_search
| | | | |
| | | | --0.84%--ReleaseBuffer
| | | | |
| | | | --0.79%--UnpinBuffer
| | | | |
| | | | --0.58%--UnpinBufferNoOwner
| | | |
| | | |--16.44%--heap_prepare_pagescan
| | | | |
| | | | |--14.71%--page_collect_tuples
| | | | | |
| | | | | |--6.82%--HeapTupleSatisfiesVisibility
| | | | | | |
| | | | | | --4.85%--HeapTupleSatisfiesMVCC
| | | | | | |
| | | | | | --2.41%--XidInMVCCSnapshot
| | | | | | |
| | | | | | --1.10%--TransactionIdPrecedes
| | | | | |
| | | | | |--1.91%--ItemPointerSet
| | | | | | |
| | | | | | --0.81%--BlockIdSet
| | | | | |
| | | | | --0.80%--PageGetItemId
| | | | |
| | | | --1.11%--LockBuffer
| | | | |
| | | | --0.55%--LWLockAcquire
| | | |
| | | |--2.54%--ItemPointerSet
| | | | |
| | | | --0.81%--BlockIdSet
| | | |
| | | |--1.13%--BufferGetPage
| | | | |
| | | | --0.74%--BufferGetBlock
| | | |
| | | |--0.83%--PageGetItemId
| | | |
| | | --0.64%--PageGetItem
| | |
| | --9.51%--ExecStoreBufferHeapTuple
| | |
| | --7.65%--tts_buffer_heap_store_tuple
| | |
| | |--2.47%--IncrBufferRefCount
| | | |
| | | --2.11%--GetPrivateRefCountEntry
| | | |
| | | --1.54%--hash_search
| | | |
| | | |--0.87%--hash_search_with_hash_value
| | | |
| | | --0.57%--uint32_hash
| | | |
| | | --0.54%--hash_bytes_uint32
| | |
| | --2.04%--ReleaseBuffer
| | |
| | --1.95%--UnpinBuffer
| | |
| | |--1.25%--UnpinBufferNoOwner
| | |
| | --0.63%--ResourceOwnerForgetBuffer
| | |
| | --0.56%--ResourceOwnerForget
| |
| --1.83%--ExecFetchSlotHeapTuple
| |
| --0.83%--tts_buffer_heap_get_heap_tuple
|
|--2.20%--TransactionIdPrecedes
|
--1.18%--MultiXactIdPrecedes
91.13% 0.00% postgres [.] exec_simple_query
|
---exec_simple_query
PortalRun
PortalRunMulti
PortalRunUtility
ProcessUtility
standard_ProcessUtility
ExecVacuum
vacuum
vac_update_datfrozenxid
|
|--81.42%--systable_getnext
| |
| |--76.61%--table_scan_getnextslot
| | |
| | --73.16%--heap_getnextslot
| | |
| | |--57.95%--heapgettup_pagemode
| | | |
| | | |--30.65%--heap_fetch_next_buffer
| | | | |
| | | | |--29.43%--read_stream_next_buffer
| | | | | |
| | | | | |--17.13%--WaitReadBuffers
| | | | | | |
| | | | | | |--13.62%--smgrreadv
| | | | | | | |
| | | | | | | --13.58%--mdreadv
| | | | | | | |
| | | | | | | --13.47%--FileReadV
| | | | | | | |
| | | | | | | --13.41%--pg_preadv
| | | | | | | |
| | | | | | | |--6.71%--__libc_pread64 (inlined)
| | | | | | | | |
| | | | | | | | --6.68%--entry_SYSCALL_64_after_hwframe
| | | | | | | | do_syscall_64
| | | | | | | | |
| | | | | | | | --6.66%--x64_sys_call
| | | | | | | | __x64_sys_pread64
| | | | | | | | |
| | | | | | | | --6.62%--vfs_read
| | | | | | | | |
| | | | | | | | --6.57%--ext4_file_read_iter
| | | | | | | | generic_file_read_iter
| | | | | | | | |
| | | | | | | | --6.53%--filemap_read
| | | | | | | | |
| | | | | | | | --5.57%--copy_page_to_iter
| | | | | | | | |
| | | | | | | | --5.45%--_copy_to_iter
| | | | | | | |
| | | | | | | --6.70%--__GI_preadv64 (inlined)
| | | | | | | |
| | | | | | | --6.64%--entry_SYSCALL_64_after_hwframe
| | | | | | | |
| | | | | | | --6.64%--do_syscall_64
| | | | | | | |
| | | | | | | --6.58%--x64_sys_call
| | | | | | | |
| | | | | | | --6.57%--__x64_sys_preadv
| | | | | | | |
| | | | | | | --6.55%--vfs_readv
| | | | | | | |
| | | | | | | --6.48%--do_iter_readv_writev
| | | | | | | |
| | | | | | | --6.47%--ext4_file_read_iter
| | | | | | | generic_file_read_iter
| | | | | | | |
| | | | | | | --6.46%--filemap_read
| | | | | | | |
| | | | | | | --5.72%--copy_page_to_iter
| | | | | | | |
| | | | | | | --5.63%--_copy_to_iter
| | | | | | |
| | | | | | |--1.58%--TerminateBufferIO
| | | | | | |
| | | | | | --1.30%--WaitReadBuffersCanStartIO
| | | | | | |
| | | | | | --1.24%--StartBufferIO
| | | | | | |
| | | | | | --0.55%--ResourceOwnerEnlarge
| | | | | |
| | | | | --11.90%--read_stream_look_ahead
| | | | | |
| | | | | --11.33%--read_stream_start_pending_read
| | | | | |
| | | | | --11.30%--StartReadBuffers
| | | | | StartReadBuffersImpl
| | | | | |
| | | | | --11.17%--PinBufferForBlock
| | | | | |
| | | | | --10.94%--BufferAlloc
| | | | | |
| | | | | |--5.08%--GetVictimBuffer
| | | | | | |
| | | | | | --3.45%--InvalidateVictimBuffer
| | | | | | |
| | | | | | |--0.95%--BufTableDelete
| | | | | | | |
| | | | | | | --0.91%--hash_search_with_hash_value
| | | | | | |
| | | | | | |--0.93%--BufTableHashCode
| | | | | | | |
| | | | | | | --0.90%--get_hash_value
| | | | | | | |
| | | | | | | --0.84%--tag_hash
| | | | | | | |
| | | | | | | --0.81%--hash_bytes
| | | | | | |
| | | | | | --0.56%--LWLockAcquire
| | | | | |
| | | | | |--0.96%--LWLockAcquire
| | | | | | |
| | | | | | --0.80%--LWLockAttemptLock
| | | | | |
| | | | | |--0.95%--BufTableHashCode
| | | | | | |
| | | | | | --0.93%--get_hash_value
| | | | | | |
| | | | | | --0.89%--tag_hash
| | | | | | |
| | | | | | --0.83%--hash_bytes
| | | | | |
| | | | | |--0.77%--BufTableLookup
| | | | | | |
| | | | | | --0.71%--hash_search_with_hash_value
| | | | | |
| | | | | |--0.74%--BufTableInsert
| | | | | | |
| | | | | | --0.67%--hash_search_with_hash_value
| | | | | |
| | | | | |--0.71%--LWLockRelease
| | | | | |
| | | | | --0.71%--ReservePrivateRefCountEntry
| | | | | |
| | | | | --0.55%--hash_search
| | | | |
| | | | --0.84%--ReleaseBuffer
| | | | |
| | | | --0.79%--UnpinBuffer
| | | | |
| | | | --0.58%--UnpinBufferNoOwner
| | | |
| | | |--16.44%--heap_prepare_pagescan
| | | | |
| | | | |--14.71%--page_collect_tuples
| | | | | |
| | | | | |--6.82%--HeapTupleSatisfiesVisibility
| | | | | | |
| | | | | | --4.85%--HeapTupleSatisfiesMVCC
| | | | | | |
| | | | | | --2.41%--XidInMVCCSnapshot
| | | | | | |
| | | | | | --1.10%--TransactionIdPrecedes
| | | | | |
| | | | | |--1.91%--ItemPointerSet
| | | | | | |
| | | | | | --0.81%--BlockIdSet
| | | | | |
| | | | | --0.80%--PageGetItemId
| | | | |
| | | | --1.11%--LockBuffer
| | | | |
| | | | --0.55%--LWLockAcquire
| | | |
| | | |--2.54%--ItemPointerSet
| | | | |
| | | | --0.81%--BlockIdSet
| | | |
| | | |--1.13%--BufferGetPage
| | | | |
| | | | --0.74%--BufferGetBlock
| | | |
| | | |--0.83%--PageGetItemId
| | | |
| | | --0.64%--PageGetItem
| | |
| | --9.51%--ExecStoreBufferHeapTuple
| | |
| | --7.65%--tts_buffer_heap_store_tuple
| | |
| | |--2.47%--IncrBufferRefCount
| | | |
| | | --2.11%--GetPrivateRefCountEntry
| | | |
| | | --1.54%--hash_search
| | | |
| | | |--0.87%--hash_search_with_hash_value
| | | |
| | | --0.57%--uint32_hash
| | | |
| | | --0.54%--hash_bytes_uint32
| | |
| | --2.04%--ReleaseBuffer
| | |
| | --1.95%--UnpinBuffer
| | |
| | |--1.25%--UnpinBufferNoOwner
| | |
| | --0.63%--ResourceOwnerForgetBuffer
| | |
| | --0.56%--ResourceOwnerForget
| |
| --1.83%--ExecFetchSlotHeapTuple
| |
| --0.83%--tts_buffer_heap_get_heap_tuple
|
|--2.20%--TransactionIdPrecedes
|
--1.18%--MultiXactIdPrecedes
91.13% 0.00% postgres [.] PortalRun
|
---PortalRun
PortalRunMulti
PortalRunUtility
ProcessUtility
standard_ProcessUtility
ExecVacuum
vacuum
vac_update_datfrozenxid
|
|--81.42%--systable_getnext
| |
| |--76.61%--table_scan_getnextslot
| | |
| | --73.16%--heap_getnextslot
| | |
| | |--57.95%--heapgettup_pagemode
| | | |
| | | |--30.65%--heap_fetch_next_buffer
| | | | |
| | | | |--29.43%--read_stream_next_buffer
| | | | | |
| | | | | |--17.13%--WaitReadBuffers
| | | | | | |
| | | | | | |--13.62%--smgrreadv
| | | | | | | |
| | | | | | | --13.58%--mdreadv
| | | | | | | |
| | | | | | | --13.47%--FileReadV
| | | | | | | |
| | | | | | | --13.41%--pg_preadv
| | | | | | | |
| | | | | | | |--6.71%--__libc_pread64 (inlined)
| | | | | | | | |
| | | | | | | | --6.68%--entry_SYSCALL_64_after_hwframe
| | | | | | | | do_syscall_64
| | | | | | | | |
| | | | | | | | --6.66%--x64_sys_call
| | | | | | | | __x64_sys_pread64
| | | | | | | | |
| | | | | | | | --6.62%--vfs_read
| | | | | | | | |
| | | | | | | | --6.57%--ext4_file_read_iter
| | | | | | | | generic_file_read_iter
| | | | | | | | |
| | | | | | | | --6.53%--filemap_read
| | | | | | | | |
| | | | | | | | --5.57%--copy_page_to_iter
| | | | | | | | |
| | | | | | | | --5.45%--_copy_to_iter
| | | | | | | |
| | | | | | | --6.70%--__GI_preadv64 (inlined)
| | | | | | | |
| | | | | | | --6.64%--entry_SYSCALL_64_after_hwframe
| | | | | | | |
| | | | | | | --6.64%--do_syscall_64
| | | | | | | |
| | | | | | | --6.58%--x64_sys_call
| | | | | | | |
| | | | | | | --6.57%--__x64_sys_preadv
| | | | | | | |
| | | | | | | --6.55%--vfs_readv
| | | | | | | |
| | | | | | | --6.48%--do_iter_readv_writev
| | | | | | | |
| | | | | | | --6.47%--ext4_file_read_iter
| | | | | | | generic_file_read_iter
| | | | | | | |
| | | | | | | --6.46%--filemap_read
| | | | | | | |
| | | | | | | --5.72%--copy_page_to_iter
| | | | | | | |
| | | | | | | --5.63%--_copy_to_iter
| | | | | | |
| | | | | | |--1.58%--TerminateBufferIO
| | | | | | |
| | | | | | --1.30%--WaitReadBuffersCanStartIO
| | | | | | |
| | | | | | --1.24%--StartBufferIO
| | | | | | |
| | | | | | --0.55%--ResourceOwnerEnlarge
| | | | | |
| | | | | --11.90%--read_stream_look_ahead
| | | | | |
| | | | | --11.33%--read_stream_start_pending_read
| | | | | |
| | | | | --11.30%--StartReadBuffers
| | | | | StartReadBuffersImpl
| | | | | |
| | | | | --11.17%--PinBufferForBlock
| | | | | |
| | | | | --10.94%--BufferAlloc
| | | | | |
| | | | | |--5.08%--GetVictimBuffer
| | | | | | |
| | | | | | --3.45%--InvalidateVictimBuffer
| | | | | | |
| | | | | | |--0.95%--BufTableDelete
| | | | | | | |
| | | | | | | --0.91%--hash_search_with_hash_value
| | | | | | |
| | | | | | |--0.93%--BufTableHashCode
| | | | | | | |
| | | | | | | --0.90%--get_hash_value
| | | | | | | |
| | | | | | | --0.84%--tag_hash
| | | | | | | |
| | | | | | | --0.81%--hash_bytes
| | | | | | |
| | | | | | --0.56%--LWLockAcquire
| | | | | |
| | | | | |--0.96%--LWLockAcquire
| | | | | | |
| | | | | | --0.80%--LWLockAttemptLock
| | | | | |
| | | | | |--0.95%--BufTableHashCode
| | | | | | |
| | | | | | --0.93%--get_hash_value
| | | | | | |
| | | | | | --0.89%--tag_hash
| | | | | | |
| | | | | | --0.83%--hash_bytes
| | | | | |
| | | | | |--0.77%--BufTableLookup
| | | | | | |
| | | | | | --0.71%--hash_search_with_hash_value
| | | | | |
| | | | | |--0.74%--BufTableInsert
| | | | | | |
| | | | | | --0.67%--hash_search_with_hash_value
| | | | | |
| | | | | |--0.71%--LWLockRelease
| | | | | |
| | | | | --0.71%--ReservePrivateRefCountEntry
| | | | | |
| | | | | --0.55%--hash_search
| | | | |
| | | | --0.84%--ReleaseBuffer
| | | | |
| | | | --0.79%--UnpinBuffer
| | | | |
| | | | --0.58%--UnpinBufferNoOwner
| | | |
| | | |--16.44%--heap_prepare_pagescan
| | | | |
| | | | |--14.71%--page_collect_tuples
| | | | | |
| | | | | |--6.82%--HeapTupleSatisfiesVisibility
| | | | | | |
| | | | | | --4.85%--HeapTupleSatisfiesMVCC
| | | | | | |
| | | | | | --2.41%--XidInMVCCSnapshot
| | | | | | |
| | | | | | --1.10%--TransactionIdPrecedes
| | | | | |
| | | | | |--1.91%--ItemPointerSet
| | | | | | |
| | | | | | --0.81%--BlockIdSet
| | | | | |
| | | | | --0.80%--PageGetItemId
| | | | |
| | | | --1.11%--LockBuffer
| | | | |
| | | | --0.55%--LWLockAcquire
| | | |
| | | |--2.54%--ItemPointerSet
| | | | |
| | | | --0.81%--BlockIdSet
| | | |
| | | |--1.13%--BufferGetPage
| | | | |
| | | | --0.74%--BufferGetBlock
| | | |
| | | |--0.83%--PageGetItemId
| | | |
| | | --0.64%--PageGetItem
| | |
| | --9.51%--ExecStoreBufferHeapTuple
| | |
| | --7.65%--tts_buffer_heap_store_tuple
| | |
| | |--2.47%--IncrBufferRefCount
| | | |
| | | --2.11%--GetPrivateRefCountEntry
| | | |
| | | --1.54%--hash_search
| | | |
| | | |--0.87%--hash_search_with_hash_value
| | | |
| | | --0.57%--uint32_hash
| | | |
| | | --0.54%--hash_bytes_uint32
| | |
| | --2.04%--ReleaseBuffer
| | |
| | --1.95%--UnpinBuffer
| | |
| | |--1.25%--UnpinBufferNoOwner
| | |
| | --0.63%--ResourceOwnerForgetBuffer
| | |
| | --0.56%--ResourceOwnerForget
| |
| --1.83%--ExecFetchSlotHeapTuple
| |
| --0.83%--tts_buffer_heap_get_heap_tuple
|
|--2.20%--TransactionIdPrecedes
|
--1.18%--MultiXactIdPrecedes
91.13% 0.00% postgres [.] PortalRunMulti
|
---PortalRunMulti
PortalRunUtility
ProcessUtility
standard_ProcessUtility
ExecVacuum
vacuum
vac_update_datfrozenxid
|
|--81.42%--systable_getnext
| |
| |--76.61%--table_scan_getnextslot
| | |
| | --73.16%--heap_getnextslot
| | |
| | |--57.95%--heapgettup_pagemode
| | | |
| | | |--30.65%--heap_fetch_next_buffer
| | | | |
| | | | |--29.43%--read_stream_next_buffer
| | | | | |
| | | | | |--17.13%--WaitReadBuffers
| | | | | | |
| | | | | | |--13.62%--smgrreadv
| | | | | | | |
| | | | | | | --13.58%--mdreadv
| | | | | | | |
| | | | | | | --13.47%--FileReadV
| | | | | | | |
| | | | | | | --13.41%--pg_preadv
| | | | | | | |
| | | | | | | |--6.71%--__libc_pread64 (inlined)
| | | | | | | | |
| | | | | | | | --6.68%--entry_SYSCALL_64_after_hwframe
| | | | | | | | do_syscall_64
| | | | | | | | |
| | | | | | | | --6.66%--x64_sys_call
| | | | | | | | __x64_sys_pread64
| | | | | | | | |
| | | | | | | | --6.62%--vfs_read
| | | | | | | | |
| | | | | | | | --6.57%--ext4_file_read_iter
| | | | | | | | generic_file_read_iter
| | | | | | | | |
| | | | | | | | --6.53%--filemap_read
| | | | | | | | |
| | | | | | | | --5.57%--copy_page_to_iter
| | | | | | | | |
| | | | | | | | --5.45%--_copy_to_iter
| | | | | | | |
| | | | | | | --6.70%--__GI_preadv64 (inlined)
| | | | | | | |
| | | | | | | --6.64%--entry_SYSCALL_64_after_hwframe
| | | | | | | |
| | | | | | | --6.64%--do_syscall_64
| | | | | | | |
| | | | | | | --6.58%--x64_sys_call
| | | | | | | |
| | | | | | | --6.57%--__x64_sys_preadv
| | | | | | | |
| | | | | | | --6.55%--vfs_readv
| | | | | | | |
| | | | | | | --6.48%--do_iter_readv_writev
| | | | | | | |
| | | | | | | --6.47%--ext4_file_read_iter
| | | | | | | generic_file_read_iter
| | | | | | | |
| | | | | | | --6.46%--filemap_read
| | | | | | | |
| | | | | | | --5.72%--copy_page_to_iter
| | | | | | | |
| | | | | | | --5.63%--_copy_to_iter
| | | | | | |
| | | | | | |--1.58%--TerminateBufferIO
| | | | | | |
| | | | | | --1.30%--WaitReadBuffersCanStartIO
| | | | | | |
| | | | | | --1.24%--StartBufferIO
| | | | | | |
| | | | | | --0.55%--ResourceOwnerEnlarge
| | | | | |
| | | | | --11.90%--read_stream_look_ahead
| | | | | |
| | | | | --11.33%--read_stream_start_pending_read
| | | | | |
| | | | | --11.30%--StartReadBuffers
| | | | | StartReadBuffersImpl
| | | | | |
| | | | | --11.17%--PinBufferForBlock
| | | | | |
| | | | | --10.94%--BufferAlloc
| | | | | |
| | | | | |--5.08%--GetVictimBuffer
| | | | | | |
| | | | | | --3.45%--InvalidateVictimBuffer
| | | | | | |
| | | | | | |--0.95%--BufTableDelete
| | | | | | | |
| | | | | | | --0.91%--hash_search_with_hash_value
| | | | | | |
| | | | | | |--0.93%--BufTableHashCode
| | | | | | | |
| | | | | | | --0.90%--get_hash_value
| | | | | | | |
| | | | | | | --0.84%--tag_hash
| | | | | | | |
| | | | | | | --0.81%--hash_bytes
| | | | | | |
| | | | | | --0.56%--LWLockAcquire
| | | | | |
| | | | | |--0.96%--LWLockAcquire
| | | | | | |
| | | | | | --0.80%--LWLockAttemptLock
| | | | | |
| | | | | |--0.95%--BufTableHashCode
| | | | | | |
| | | | | | --0.93%--get_hash_value
| | | | | | |
| | | | | | --0.89%--tag_hash
| | | | | | |
| | | | | | --0.83%--hash_bytes
| | | | | |
| | | | | |--0.77%--BufTableLookup
| | | | | | |
| | | | | | --0.71%--hash_search_with_hash_value
| | | | | |
| | | | | |--0.74%--BufTableInsert
| | | | | | |
| | | | | | --0.67%--hash_search_with_hash_value
| | | | | |
| | | | | |--0.71%--LWLockRelease
| | | | | |
| | | | | --0.71%--ReservePrivateRefCountEntry
| | | | | |
| | | | | --0.55%--hash_search
| | | | |
| | | | --0.84%--ReleaseBuffer
| | | | |
| | | | --0.79%--UnpinBuffer
| | | | |
| | | | --0.58%--UnpinBufferNoOwner
| | | |
| | | |--16.44%--heap_prepare_pagescan
| | | | |
| | | | |--14.71%--page_collect_tuples
| | | | | |
| | | | | |--6.82%--HeapTupleSatisfiesVisibility
| | | | | | |
| | | | | | --4.85%--HeapTupleSatisfiesMVCC
| | | | | | |
| | | | | | --2.41%--XidInMVCCSnapshot
| | | | | | |
| | | | | | --1.10%--TransactionIdPrecedes
| | | | | |
| | | | | |--1.91%--ItemPointerSet
| | | | | | |
| | | | | | --0.81%--BlockIdSet
| | | | | |
| | | | | --0.80%--PageGetItemId
| | | | |
| | | | --1.11%--LockBuffer
| | | | |
| | | | --0.55%--LWLockAcquire
| | | |
| | | |--2.54%--ItemPointerSet
| | | | |
| | | | --0.81%--BlockIdSet
| | | |
| | | |--1.13%--BufferGetPage
| | | | |
| | | | --0.74%--BufferGetBlock
| | | |
| | | |--0.83%--PageGetItemId
| | | |
| | | --0.64%--PageGetItem
| | |
| | --9.51%--ExecStoreBufferHeapTuple
| | |
| | --7.65%--tts_buffer_heap_store_tuple
| | |
| | |--2.47%--IncrBufferRefCount
| | | |
| | | --2.11%--GetPrivateRefCountEntry
| | | |
| | | --1.54%--hash_search
| | | |
| | | |--0.87%--hash_search_with_hash_value
| | | |
| | | --0.57%--uint32_hash
| | | |
| | | --0.54%--hash_bytes_uint32
| | |
| | --2.04%--ReleaseBuffer
| | |
| | --1.95%--UnpinBuffer
| | |
| | |--1.25%--UnpinBufferNoOwner
| | |
| | --0.63%--ResourceOwnerForgetBuffer
| | |
| | --0.56%--ResourceOwnerForget
| |
| --1.83%--ExecFetchSlotHeapTuple
| |
| --0.83%--tts_buffer_heap_get_heap_tuple
|
|--2.20%--TransactionIdPrecedes
|
--1.18%--MultiXactIdPrecedes
91.13% 0.00% postgres [.] PortalRunUtility
|
---PortalRunUtility
ProcessUtility
standard_ProcessUtility
ExecVacuum
vacuum
vac_update_datfrozenxid
|
|--81.42%--systable_getnext
| |
| |--76.61%--table_scan_getnextslot
| | |
| | --73.16%--heap_getnextslot
| | |
| | |--57.95%--heapgettup_pagemode
| | | |
| | | |--30.65%--heap_fetch_next_buffer
| | | | |
| | | | |--29.43%--read_stream_next_buffer
| | | | | |
| | | | | |--17.13%--WaitReadBuffers
| | | | | | |
| | | | | | |--13.62%--smgrreadv
| | | | | | | |
| | | | | | | --13.58%--mdreadv
| | | | | | | |
| | | | | | | --13.47%--FileReadV
| | | | | | | |
| | | | | | | --13.41%--pg_preadv
| | | | | | | |
| | | | | | | |--6.71%--__libc_pread64 (inlined)
| | | | | | | | |
| | | | | | | | --6.68%--entry_SYSCALL_64_after_hwframe
| | | | | | | | do_syscall_64
| | | | | | | | |
| | | | | | | | --6.66%--x64_sys_call
| | | | | | | | __x64_sys_pread64
| | | | | | | | |
| | | | | | | | --6.62%--vfs_read
| | | | | | | | |
| | | | | | | | --6.57%--ext4_file_read_iter
| | | | | | | | generic_file_read_iter
| | | | | | | | |
| | | | | | | | --6.53%--filemap_read
| | | | | | | | |
| | | | | | | | --5.57%--copy_page_to_iter
| | | | | | | | |
| | | | | | | | --5.45%--_copy_to_iter
| | | | | | | |
| | | | | | | --6.70%--__GI_preadv64 (inlined)
| | | | | | | |
| | | | | | | --6.64%--entry_SYSCALL_64_after_hwframe
| | | | | | | |
| | | | | | | --6.64%--do_syscall_64
| | | | | | | |
| | | | | | | --6.58%--x64_sys_call
| | | | | | | |
| | | | | | | --6.57%--__x64_sys_preadv
| | | | | | | |
| | | | | | | --6.55%--vfs_readv
| | | | | | | |
| | | | | | | --6.48%--do_iter_readv_writev
| | | | | | | |
| | | | | | | --6.47%--ext4_file_read_iter
| | | | | | | generic_file_read_iter
| | | | | | | |
| | | | | | | --6.46%--filemap_read
| | | | | | | |
| | | | | | | --5.72%--copy_page_to_iter
| | | | | | | |
| | | | | | | --5.63%--_copy_to_iter
| | | | | | |
| | | | | | |--1.58%--TerminateBufferIO
| | | | | | |
| | | | | | --1.30%--WaitReadBuffersCanStartIO
| | | | | | |
| | | | | | --1.24%--StartBufferIO
| | | | | | |
| | | | | | --0.55%--ResourceOwnerEnlarge
| | | | | |
| | | | | --11.90%--read_stream_look_ahead
| | | | | |
| | | | | --11.33%--read_stream_start_pending_read
| | | | | |
| | | | | --11.30%--StartReadBuffers
| | | | | StartReadBuffersImpl
| | | | | |
| | | | | --11.17%--PinBufferForBlock
| | | | | |
| | | | | --10.94%--BufferAlloc
| | | | | |
| | | | | |--5.08%--GetVictimBuffer
| | | | | | |
| | | | | | --3.45%--InvalidateVictimBuffer
| | | | | | |
| | | | | | |--0.95%--BufTableDelete
| | | | | | | |
| | | | | | | --0.91%--hash_search_with_hash_value
| | | | | | |
| | | | | | |--0.93%--BufTableHashCode
| | | | | | | |
| | | | | | | --0.90%--get_hash_value
| | | | | | | |
| | | | | | | --0.84%--tag_hash
| | | | | | | |
| | | | | | | --0.81%--hash_bytes
| | | | | | |
| | | | | | --0.56%--LWLockAcquire
| | | | | |
| | | | | |--0.96%--LWLockAcquire
| | | | | | |
| | | | | | --0.80%--LWLockAttemptLock
| | | | | |
| | | | | |--0.95%--BufTableHashCode
| | | | | | |
| | | | | | --0.93%--get_hash_value
| | | | | | |
| | | | | | --0.89%--tag_hash
| | | | | | |
| | | | | | --0.83%--hash_bytes
| | | | | |
| | | | | |--0.77%--BufTableLookup
| | | | | | |
| | | | | | --0.71%--hash_search_with_hash_value
| | | | | |
| | | | | |--0.74%--BufTableInsert
| | | | | | |
| | | | | | --0.67%--hash_search_with_hash_value
| | | | | |
| | | | | |--0.71%--LWLockRelease
| | | | | |
| | | | | --0.71%--ReservePrivateRefCountEntry
| | | | | |
| | | | | --0.55%--hash_search
| | | | |
| | | | --0.84%--ReleaseBuffer
| | | | |
| | | | --0.79%--UnpinBuffer
| | | | |
| | | | --0.58%--UnpinBufferNoOwner
| | | |
| | | |--16.44%--heap_prepare_pagescan
| | | | |
| | | | |--14.71%--page_collect_tuples
| | | | | |
| | | | | |--6.82%--HeapTupleSatisfiesVisibility
| | | | | | |
| | | | | | --4.85%--HeapTupleSatisfiesMVCC
| | | | | | |
| | | | | | --2.41%--XidInMVCCSnapshot
| | | | | | |
| | | | | | --1.10%--TransactionIdPrecedes
| | | | | |
| | | | | |--1.91%--ItemPointerSet
| | | | | | |
| | | | | | --0.81%--BlockIdSet
| | | | | |
| | | | | --0.80%--PageGetItemId
| | | | |
| | | | --1.11%--LockBuffer
| | | | |
| | | | --0.55%--LWLockAcquire
| | | |
| | | |--2.54%--ItemPointerSet
| | | | |
| | | | --0.81%--BlockIdSet
| | | |
| | | |--1.13%--BufferGetPage
| | | | |
| | | | --0.74%--BufferGetBlock
| | | |
| | | |--0.83%--PageGetItemId
| | | |
| | | --0.64%--PageGetItem
| | |
| | --9.51%--ExecStoreBufferHeapTuple
| | |
| | --7.65%--tts_buffer_heap_store_tuple
| | |
| | |--2.47%--IncrBufferRefCount
| | | |
| | | --2.11%--GetPrivateRefCountEntry
| | | |
| | | --1.54%--hash_search
| | | |
| | | |--0.87%--hash_search_with_hash_value
| | | |
| | | --0.57%--uint32_hash
| | | |
| | | --0.54%--hash_bytes_uint32
| | |
| | --2.04%--ReleaseBuffer
| | |
| | --1.95%--UnpinBuffer
| | |
| | |--1.25%--UnpinBufferNoOwner
| | |
| | --0.63%--ResourceOwnerForgetBuffer
| | |
| | --0.56%--ResourceOwnerForget
| |
| --1.83%--ExecFetchSlotHeapTuple
| |
| --0.83%--tts_buffer_heap_get_heap_tuple
|
|--2.20%--TransactionIdPrecedes
|
--1.18%--MultiXactIdPrecedes
91.13% 0.00% postgres [.] ProcessUtility
|
---ProcessUtility
standard_ProcessUtility
ExecVacuum
vacuum
vac_update_datfrozenxid
|
|--81.42%--systable_getnext
| |
| |--76.61%--table_scan_getnextslot
| | |
| | --73.16%--heap_getnextslot
| | |
| | |--57.95%--heapgettup_pagemode
| | | |
| | | |--30.65%--heap_fetch_next_buffer
| | | | |
| | | | |--29.43%--read_stream_next_buffer
| | | | | |
| | | | | |--17.13%--WaitReadBuffers
| | | | | | |
| | | | | | |--13.62%--smgrreadv
| | | | | | | |
| | | | | | | --13.58%--mdreadv
| | | | | | | |
| | | | | | | --13.47%--FileReadV
| | | | | | | |
| | | | | | | --13.41%--pg_preadv
| | | | | | | |
| | | | | | | |--6.71%--__libc_pread64 (inlined)
| | | | | | | | |
| | | | | | | | --6.68%--entry_SYSCALL_64_after_hwframe
| | | | | | | | do_syscall_64
| | | | | | | | |
| | | | | | | | --6.66%--x64_sys_call
| | | | | | | | __x64_sys_pread64
| | | | | | | | |
| | | | | | | | --6.62%--vfs_read
| | | | | | | | |
| | | | | | | | --6.57%--ext4_file_read_iter
| | | | | | | | generic_file_read_iter
| | | | | | | | |
| | | | | | | | --6.53%--filemap_read
| | | | | | | | |
| | | | | | | | --5.57%--copy_page_to_iter
| | | | | | | | |
| | | | | | | | --5.45%--_copy_to_iter
| | | | | | | |
| | | | | | | --6.70%--__GI_preadv64 (inlined)
| | | | | | | |
| | | | | | | --6.64%--entry_SYSCALL_64_after_hwframe
| | | | | | | |
| | | | | | | --6.64%--do_syscall_64
| | | | | | | |
| | | | | | | --6.58%--x64_sys_call
| | | | | | | |
| | | | | | | --6.57%--__x64_sys_preadv
| | | | | | | |
| | | | | | | --6.55%--vfs_readv
| | | | | | | |
| | | | | | | --6.48%--do_iter_readv_writev
| | | | | | | |
| | | | | | | --6.47%--ext4_file_read_iter
| | | | | | | generic_file_read_iter
| | | | | | | |
| | | | | | | --6.46%--filemap_read
| | | | | | | |
| | | | | | | --5.72%--copy_page_to_iter
| | | | | | | |
| | | | | | | --5.63%--_copy_to_iter
| | | | | | |
| | | | | | |--1.58%--TerminateBufferIO
| | | | | | |
| | | | | | --1.30%--WaitReadBuffersCanStartIO
| | | | | | |
| | | | | | --1.24%--StartBufferIO
| | | | | | |
| | | | | | --0.55%--ResourceOwnerEnlarge
| | | | | |
| | | | | --11.90%--read_stream_look_ahead
| | | | | |
| | | | | --11.33%--read_stream_start_pending_read
| | | | | |
| | | | | --11.30%--StartReadBuffers
| | | | | StartReadBuffersImpl
| | | | | |
| | | | | --11.17%--PinBufferForBlock
| | | | | |
| | | | | --10.94%--BufferAlloc
| | | | | |
| | | | | |--5.08%--GetVictimBuffer
| | | | | | |
| | | | | | --3.45%--InvalidateVictimBuffer
| | | | | | |
| | | | | | |--0.95%--BufTableDelete
| | | | | | | |
| | | | | | | --0.91%--hash_search_with_hash_value
| | | | | | |
| | | | | | |--0.93%--BufTableHashCode
| | | | | | | |
| | | | | | | --0.90%--get_hash_value
| | | | | | | |
| | | | | | | --0.84%--tag_hash
| | | | | | | |
| | | | | | | --0.81%--hash_bytes
| | | | | | |
| | | | | | --0.56%--LWLockAcquire
| | | | | |
| | | | | |--0.96%--LWLockAcquire
| | | | | | |
| | | | | | --0.80%--LWLockAttemptLock
| | | | | |
| | | | | |--0.95%--BufTableHashCode
| | | | | | |
| | | | | | --0.93%--get_hash_value
| | | | | | |
| | | | | | --0.89%--tag_hash
| | | | | | |
| | | | | | --0.83%--hash_bytes
| | | | | |
| | | | | |--0.77%--BufTableLookup
| | | | | | |
| | | | | | --0.71%--hash_search_with_hash_value
| | | | | |
| | | | | |--0.74%--BufTableInsert
| | | | | | |
| | | | | | --0.67%--hash_search_with_hash_value
| | | | | |
| | | | | |--0.71%--LWLockRelease
| | | | | |
| | | | | --0.71%--ReservePrivateRefCountEntry
| | | | | |
| | | | | --0.55%--hash_search
| | | | |
| | | | --0.84%--ReleaseBuffer
| | | | |
| | | | --0.79%--UnpinBuffer
| | | | |
| | | | --0.58%--UnpinBufferNoOwner
| | | |
| | | |--16.44%--heap_prepare_pagescan
| | | | |
| | | | |--14.71%--page_collect_tuples
| | | | | |
| | | | | |--6.82%--HeapTupleSatisfiesVisibility
| | | | | | |
| | | | | | --4.85%--HeapTupleSatisfiesMVCC
| | | | | | |
| | | | | | --2.41%--XidInMVCCSnapshot
| | | | | | |
| | | | | | --1.10%--TransactionIdPrecedes
| | | | | |
| | | | | |--1.91%--ItemPointerSet
| | | | | | |
| | | | | | --0.81%--BlockIdSet
| | | | | |
| | | | | --0.80%--PageGetItemId
| | | | |
| | | | --1.11%--LockBuffer
| | | | |
| | | | --0.55%--LWLockAcquire
| | | |
| | | |--2.54%--ItemPointerSet
| | | | |
| | | | --0.81%--BlockIdSet
| | | |
| | | |--1.13%--BufferGetPage
| | | | |
| | | | --0.74%--BufferGetBlock
| | | |
| | | |--0.83%--PageGetItemId
| | | |
| | | --0.64%--PageGetItem
| | |
| | --9.51%--ExecStoreBufferHeapTuple
| | |
| | --7.65%--tts_buffer_heap_store_tuple
| | |
| | |--2.47%--IncrBufferRefCount
| | | |
| | | --2.11%--GetPrivateRefCountEntry
| | | |
| | | --1.54%--hash_search
| | | |
| | | |--0.87%--hash_search_with_hash_value
| | | |
| | | --0.57%--uint32_hash
| | | |
| | | --0.54%--hash_bytes_uint32
| | |
| | --2.04%--ReleaseBuffer
| | |
| | --1.95%--UnpinBuffer
| | |
| | |--1.25%--UnpinBufferNoOwner
| | |
| | --0.63%--ResourceOwnerForgetBuffer
| | |
| | --0.56%--ResourceOwnerForget
| |
| --1.83%--ExecFetchSlotHeapTuple
| |
| --0.83%--tts_buffer_heap_get_heap_tuple
|
|--2.20%--TransactionIdPrecedes
|
--1.18%--MultiXactIdPrecedes
91.13% 0.00% postgres [.] standard_ProcessUtility
|
---standard_ProcessUtility
ExecVacuum
vacuum
vac_update_datfrozenxid
|
|--81.42%--systable_getnext
| |
| |--76.61%--table_scan_getnextslot
| | |
| | --73.16%--heap_getnextslot
| | |
| | |--57.95%--heapgettup_pagemode
| | | |
| | | |--30.65%--heap_fetch_next_buffer
| | | | |
| | | | |--29.43%--read_stream_next_buffer
| | | | | |
| | | | | |--17.13%--WaitReadBuffers
| | | | | | |
| | | | | | |--13.62%--smgrreadv
| | | | | | | |
| | | | | | | --13.58%--mdreadv
| | | | | | | |
| | | | | | | --13.47%--FileReadV
| | | | | | | |
| | | | | | | --13.41%--pg_preadv
| | | | | | | |
| | | | | | | |--6.71%--__libc_pread64 (inlined)
| | | | | | | | |
| | | | | | | | --6.68%--entry_SYSCALL_64_after_hwframe
| | | | | | | | do_syscall_64
| | | | | | | | |
| | | | | | | | --6.66%--x64_sys_call
| | | | | | | | __x64_sys_pread64
| | | | | | | | |
| | | | | | | | --6.62%--vfs_read
| | | | | | | | |
| | | | | | | | --6.57%--ext4_file_read_iter
| | | | | | | | generic_file_read_iter
| | | | | | | | |
| | | | | | | | --6.53%--filemap_read
| | | | | | | | |
| | | | | | | | --5.57%--copy_page_to_iter
| | | | | | | | |
| | | | | | | | --5.45%--_copy_to_iter
| | | | | | | |
| | | | | | | --6.70%--__GI_preadv64 (inlined)
| | | | | | | |
| | | | | | | --6.64%--entry_SYSCALL_64_after_hwframe
| | | | | | | |
| | | | | | | --6.64%--do_syscall_64
| | | | | | | |
| | | | | | | --6.58%--x64_sys_call
| | | | | | | |
| | | | | | | --6.57%--__x64_sys_preadv
| | | | | | | |
| | | | | | | --6.55%--vfs_readv
| | | | | | | |
| | | | | | | --6.48%--do_iter_readv_writev
| | | | | | | |
| | | | | | | --6.47%--ext4_file_read_iter
| | | | | | | generic_file_read_iter
| | | | | | | |
| | | | | | | --6.46%--filemap_read
| | | | | | | |
| | | | | | | --5.72%--copy_page_to_iter
| | | | | | | |
| | | | | | | --5.63%--_copy_to_iter
| | | | | | |
| | | | | | |--1.58%--TerminateBufferIO
| | | | | | |
| | | | | | --1.30%--WaitReadBuffersCanStartIO
| | | | | | |
| | | | | | --1.24%--StartBufferIO
| | | | | | |
| | | | | | --0.55%--ResourceOwnerEnlarge
| | | | | |
| | | | | --11.90%--read_stream_look_ahead
| | | | | |
| | | | | --11.33%--read_stream_start_pending_read
| | | | | |
| | | | | --11.30%--StartReadBuffers
| | | | | StartReadBuffersImpl
| | | | | |
| | | | | --11.17%--PinBufferForBlock
| | | | | |
| | | | | --10.94%--BufferAlloc
| | | | | |
| | | | | |--5.08%--GetVictimBuffer
| | | | | | |
| | | | | | --3.45%--InvalidateVictimBuffer
| | | | | | |
| | | | | | |--0.95%--BufTableDelete
| | | | | | | |
| | | | | | | --0.91%--hash_search_with_hash_value
| | | | | | |
| | | | | | |--0.93%--BufTableHashCode
| | | | | | | |
| | | | | | | --0.90%--get_hash_value
| | | | | | | |
| | | | | | | --0.84%--tag_hash
| | | | | | | |
| | | | | | | --0.81%--hash_bytes
| | | | | | |
| | | | | | --0.56%--LWLockAcquire
| | | | | |
| | | | | |--0.96%--LWLockAcquire
| | | | | | |
| | | | | | --0.80%--LWLockAttemptLock
| | | | | |
| | | | | |--0.95%--BufTableHashCode
| | | | | | |
| | | | | | --0.93%--get_hash_value
| | | | | | |
| | | | | | --0.89%--tag_hash
| | | | | | |
| | | | | | --0.83%--hash_bytes
| | | | | |
| | | | | |--0.77%--BufTableLookup
| | | | | | |
| | | | | | --0.71%--hash_search_with_hash_value
| | | | | |
| | | | | |--0.74%--BufTableInsert
| | | | | | |
| | | | | | --0.67%--hash_search_with_hash_value
| | | | | |
| | | | | |--0.71%--LWLockRelease
| | | | | |
| | | | | --0.71%--ReservePrivateRefCountEntry
| | | | | |
| | | | | --0.55%--hash_search
| | | | |
| | | | --0.84%--ReleaseBuffer
| | | | |
| | | | --0.79%--UnpinBuffer
| | | | |
| | | | --0.58%--UnpinBufferNoOwner
| | | |
| | | |--16.44%--heap_prepare_pagescan
| | | | |
| | | | |--14.71%--page_collect_tuples
| | | | | |
| | | | | |--6.82%--HeapTupleSatisfiesVisibility
| | | | | | |
| | | | | | --4.85%--HeapTupleSatisfiesMVCC
| | | | | | |
| | | | | | --2.41%--XidInMVCCSnapshot
| | | | | | |
| | | | | | --1.10%--TransactionIdPrecedes
| | | | | |
| | | | | |--1.91%--ItemPointerSet
| | | | | | |
| | | | | | --0.81%--BlockIdSet
| | | | | |
| | | | | --0.80%--PageGetItemId
| | | | |
| | | | --1.11%--LockBuffer
| | | | |
| | | | --0.55%--LWLockAcquire
| | | |
| | | |--2.54%--ItemPointerSet
| | | | |
| | | | --0.81%--BlockIdSet
| | | |
| | | |--1.13%--BufferGetPage
| | | | |
| | | | --0.74%--BufferGetBlock
| | | |
| | | |--0.83%--PageGetItemId
| | | |
| | | --0.64%--PageGetItem
| | |
| | --9.51%--ExecStoreBufferHeapTuple
| | |
| | --7.65%--tts_buffer_heap_store_tuple
| | |
| | |--2.47%--IncrBufferRefCount
| | | |
| | | --2.11%--GetPrivateRefCountEntry
| | | |
| | | --1.54%--hash_search
| | | |
| | | |--0.87%--hash_search_with_hash_value
| | | |
| | | --0.57%--uint32_hash
| | | |
| | | --0.54%--hash_bytes_uint32
| | |
| | --2.04%--ReleaseBuffer
| | |
| | --1.95%--UnpinBuffer
| | |
| | |--1.25%--UnpinBufferNoOwner
| | |
| | --0.63%--ResourceOwnerForgetBuffer
| | |
| | --0.56%--ResourceOwnerForget
| |
| --1.83%--ExecFetchSlotHeapTuple
| |
| --0.83%--tts_buffer_heap_get_heap_tuple
|
|--2.20%--TransactionIdPrecedes
|
--1.18%--MultiXactIdPrecedes
91.13% 0.00% postgres [.] ExecVacuum
|
---ExecVacuum
vacuum
vac_update_datfrozenxid
|
|--81.42%--systable_getnext
| |
| |--76.61%--table_scan_getnextslot
| | |
| | --73.16%--heap_getnextslot
| | |
| | |--57.95%--heapgettup_pagemode
| | | |
| | | |--30.65%--heap_fetch_next_buffer
| | | | |
| | | | |--29.43%--read_stream_next_buffer
| | | | | |
| | | | | |--17.13%--WaitReadBuffers
| | | | | | |
| | | | | | |--13.62%--smgrreadv
| | | | | | | |
| | | | | | | --13.58%--mdreadv
| | | | | | | |
| | | | | | | --13.47%--FileReadV
| | | | | | | |
| | | | | | | --13.41%--pg_preadv
| | | | | | | |
| | | | | | | |--6.71%--__libc_pread64 (inlined)
| | | | | | | | |
| | | | | | | | --6.68%--entry_SYSCALL_64_after_hwframe
| | | | | | | | do_syscall_64
| | | | | | | | |
| | | | | | | | --6.66%--x64_sys_call
| | | | | | | | __x64_sys_pread64
| | | | | | | | |
| | | | | | | | --6.62%--vfs_read
| | | | | | | | |
| | | | | | | | --6.57%--ext4_file_read_iter
| | | | | | | | generic_file_read_iter
| | | | | | | | |
| | | | | | | | --6.53%--filemap_read
| | | | | | | | |
| | | | | | | | --5.57%--copy_page_to_iter
| | | | | | | | |
| | | | | | | | --5.45%--_copy_to_iter
| | | | | | | |
| | | | | | | --6.70%--__GI_preadv64 (inlined)
| | | | | | | |
| | | | | | | --6.64%--entry_SYSCALL_64_after_hwframe
| | | | | | | |
| | | | | | | --6.64%--do_syscall_64
| | | | | | | |
| | | | | | | --6.58%--x64_sys_call
| | | | | | | |
| | | | | | | --6.57%--__x64_sys_preadv
| | | | | | | |
| | | | | | | --6.55%--vfs_readv
| | | | | | | |
| | | | | | | --6.48%--do_iter_readv_writev
| | | | | | | |
| | | | | | | --6.47%--ext4_file_read_iter
| | | | | | | generic_file_read_iter
| | | | | | | |
| | | | | | | --6.46%--filemap_read
| | | | | | | |
| | | | | | | --5.72%--copy_page_to_iter
| | | | | | | |
| | | | | | | --5.63%--_copy_to_iter
| | | | | | |
| | | | | | |--1.58%--TerminateBufferIO
| | | | | | |
| | | | | | --1.30%--WaitReadBuffersCanStartIO
| | | | | | |
| | | | | | --1.24%--StartBufferIO
| | | | | | |
| | | | | | --0.55%--ResourceOwnerEnlarge
| | | | | |
| | | | | --11.90%--read_stream_look_ahead
| | | | | |
| | | | | --11.33%--read_stream_start_pending_read
| | | | | |
| | | | | --11.30%--StartReadBuffers
| | | | | StartReadBuffersImpl
| | | | | |
| | | | | --11.17%--PinBufferForBlock
| | | | | |
| | | | | --10.94%--BufferAlloc
| | | | | |
| | | | | |--5.08%--GetVictimBuffer
| | | | | | |
| | | | | | --3.45%--InvalidateVictimBuffer
| | | | | | |
| | | | | | |--0.95%--BufTableDelete
| | | | | | | |
| | | | | | | --0.91%--hash_search_with_hash_value
| | | | | | |
| | | | | | |--0.93%--BufTableHashCode
| | | | | | | |
| | | | | | | --0.90%--get_hash_value
| | | | | | | |
| | | | | | | --0.84%--tag_hash
| | | | | | | |
| | | | | | | --0.81%--hash_bytes
| | | | | | |
| | | | | | --0.56%--LWLockAcquire
| | | | | |
| | | | | |--0.96%--LWLockAcquire
| | | | | | |
| | | | | | --0.80%--LWLockAttemptLock
| | | | | |
| | | | | |--0.95%--BufTableHashCode
| | | | | | |
| | | | | | --0.93%--get_hash_value
| | | | | | |
| | | | | | --0.89%--tag_hash
| | | | | | |
| | | | | | --0.83%--hash_bytes
| | | | | |
| | | | | |--0.77%--BufTableLookup
| | | | | | |
| | | | | | --0.71%--hash_search_with_hash_value
| | | | | |
| | | | | |--0.74%--BufTableInsert
| | | | | | |
| | | | | | --0.67%--hash_search_with_hash_value
| | | | | |
| | | | | |--0.71%--LWLockRelease
| | | | | |
| | | | | --0.71%--ReservePrivateRefCountEntry
| | | | | |
| | | | | --0.55%--hash_search
| | | | |
| | | | --0.84%--ReleaseBuffer
| | | | |
| | | | --0.79%--UnpinBuffer
| | | | |
| | | | --0.58%--UnpinBufferNoOwner
| | | |
| | | |--16.44%--heap_prepare_pagescan
| | | | |
| | | | |--14.71%--page_collect_tuples
| | | | | |
| | | | | |--6.82%--HeapTupleSatisfiesVisibility
| | | | | | |
| | | | | | --4.85%--HeapTupleSatisfiesMVCC
| | | | | | |
| | | | | | --2.41%--XidInMVCCSnapshot
| | | | | | |
| | | | | | --1.10%--TransactionIdPrecedes
| | | | | |
| | | | | |--1.91%--ItemPointerSet
| | | | | | |
| | | | | | --0.81%--BlockIdSet
| | | | | |
| | | | | --0.80%--PageGetItemId
| | | | |
| | | | --1.11%--LockBuffer
| | | | |
| | | | --0.55%--LWLockAcquire
| | | |
| | | |--2.54%--ItemPointerSet
| | | | |
| | | | --0.81%--BlockIdSet
| | | |
| | | |--1.13%--BufferGetPage
| | | | |
| | | | --0.74%--BufferGetBlock
| | | |
| | | |--0.83%--PageGetItemId
| | | |
| | | --0.64%--PageGetItem
| | |
| | --9.51%--ExecStoreBufferHeapTuple
| | |
| | --7.65%--tts_buffer_heap_store_tuple
| | |
| | |--2.47%--IncrBufferRefCount
| | | |
| | | --2.11%--GetPrivateRefCountEntry
| | | |
| | | --1.54%--hash_search
| | | |
| | | |--0.87%--hash_search_with_hash_value
| | | |
| | | --0.57%--uint32_hash
| | | |
| | | --0.54%--hash_bytes_uint32
| | |
| | --2.04%--ReleaseBuffer
| | |
| | --1.95%--UnpinBuffer
| | |
| | |--1.25%--UnpinBufferNoOwner
| | |
| | --0.63%--ResourceOwnerForgetBuffer
| | |
| | --0.56%--ResourceOwnerForget
| |
| --1.83%--ExecFetchSlotHeapTuple
| |
| --0.83%--tts_buffer_heap_get_heap_tuple
|
|--2.20%--TransactionIdPrecedes
|
--1.18%--MultiXactIdPrecedes
91.13% 0.00% postgres [.] vacuum
|
---vacuum
vac_update_datfrozenxid
|
|--81.42%--systable_getnext
| |
| |--76.61%--table_scan_getnextslot
| | |
| | --73.16%--heap_getnextslot
| | |
| | |--57.95%--heapgettup_pagemode
| | | |
| | | |--30.65%--heap_fetch_next_buffer
| | | | |
| | | | |--29.43%--read_stream_next_buffer
| | | | | |
| | | | | |--17.13%--WaitReadBuffers
| | | | | | |
| | | | | | |--13.62%--smgrreadv
| | | | | | | |
| | | | | | | --13.58%--mdreadv
| | | | | | | |
| | | | | | | --13.47%--FileReadV
| | | | | | | |
| | | | | | | --13.41%--pg_preadv
| | | | | | | |
| | | | | | | |--6.71%--__libc_pread64 (inlined)
| | | | | | | | |
| | | | | | | | --6.68%--entry_SYSCALL_64_after_hwframe
| | | | | | | | do_syscall_64
| | | | | | | | |
| | | | | | | | --6.66%--x64_sys_call
| | | | | | | | __x64_sys_pread64
| | | | | | | | |
| | | | | | | | --6.62%--vfs_read
| | | | | | | | |
| | | | | | | | --6.57%--ext4_file_read_iter
| | | | | | | | generic_file_read_iter
| | | | | | | | |
| | | | | | | | --6.53%--filemap_read
| | | | | | | | |
| | | | | | | | --5.57%--copy_page_to_iter
| | | | | | | | |
| | | | | | | | --5.45%--_copy_to_iter
| | | | | | | |
| | | | | | | --6.70%--__GI_preadv64 (inlined)
| | | | | | | |
| | | | | | | --6.64%--entry_SYSCALL_64_after_hwframe
| | | | | | | |
| | | | | | | --6.64%--do_syscall_64
| | | | | | | |
| | | | | | | --6.58%--x64_sys_call
| | | | | | | |
| | | | | | | --6.57%--__x64_sys_preadv
| | | | | | | |
| | | | | | | --6.55%--vfs_readv
| | | | | | | |
| | | | | | | --6.48%--do_iter_readv_writev
| | | | | | | |
| | | | | | | --6.47%--ext4_file_read_iter
| | | | | | | generic_file_read_iter
| | | | | | | |
| | | | | | | --6.46%--filemap_read
| | | | | | | |
| | | | | | | --5.72%--copy_page_to_iter
| | | | | | | |
| | | | | | | --5.63%--_copy_to_iter
| | | | | | |
| | | | | | |--1.58%--TerminateBufferIO
| | | | | | |
| | | | | | --1.30%--WaitReadBuffersCanStartIO
| | | | | | |
| | | | | | --1.24%--StartBufferIO
| | | | | | |
| | | | | | --0.55%--ResourceOwnerEnlarge
| | | | | |
| | | | | --11.90%--read_stream_look_ahead
| | | | | |
| | | | | --11.33%--read_stream_start_pending_read
| | | | | |
| | | | | --11.30%--StartReadBuffers
| | | | | StartReadBuffersImpl
| | | | | |
| | | | | --11.17%--PinBufferForBlock
| | | | | |
| | | | | --10.94%--BufferAlloc
| | | | | |
| | | | | |--5.08%--GetVictimBuffer
| | | | | | |
| | | | | | --3.45%--InvalidateVictimBuffer
| | | | | | |
| | | | | | |--0.95%--BufTableDelete
| | | | | | | |
| | | | | | | --0.91%--hash_search_with_hash_value
| | | | | | |
| | | | | | |--0.93%--BufTableHashCode
| | | | | | | |
| | | | | | | --0.90%--get_hash_value
| | | | | | | |
| | | | | | | --0.84%--tag_hash
| | | | | | | |
| | | | | | | --0.81%--hash_bytes
| | | | | | |
| | | | | | --0.56%--LWLockAcquire
| | | | | |
| | | | | |--0.96%--LWLockAcquire
| | | | | | |
| | | | | | --0.80%--LWLockAttemptLock
| | | | | |
| | | | | |--0.95%--BufTableHashCode
| | | | | | |
| | | | | | --0.93%--get_hash_value
| | | | | | |
| | | | | | --0.89%--tag_hash
| | | | | | |
| | | | | | --0.83%--hash_bytes
| | | | | |
| | | | | |--0.77%--BufTableLookup
| | | | | | |
| | | | | | --0.71%--hash_search_with_hash_value
| | | | | |
| | | | | |--0.74%--BufTableInsert
| | | | | | |
| | | | | | --0.67%--hash_search_with_hash_value
| | | | | |
| | | | | |--0.71%--LWLockRelease
| | | | | |
| | | | | --0.71%--ReservePrivateRefCountEntry
| | | | | |
| | | | | --0.55%--hash_search
| | | | |
| | | | --0.84%--ReleaseBuffer
| | | | |
| | | | --0.79%--UnpinBuffer
| | | | |
| | | | --0.58%--UnpinBufferNoOwner
| | | |
| | | |--16.44%--heap_prepare_pagescan
| | | | |
| | | | |--14.71%--page_collect_tuples
| | | | | |
| | | | | |--6.82%--HeapTupleSatisfiesVisibility
| | | | | | |
| | | | | | --4.85%--HeapTupleSatisfiesMVCC
| | | | | | |
| | | | | | --2.41%--XidInMVCCSnapshot
| | | | | | |
| | | | | | --1.10%--TransactionIdPrecedes
| | | | | |
| | | | | |--1.91%--ItemPointerSet
| | | | | | |
| | | | | | --0.81%--BlockIdSet
| | | | | |
| | | | | --0.80%--PageGetItemId
| | | | |
| | | | --1.11%--LockBuffer
| | | | |
| | | | --0.55%--LWLockAcquire
| | | |
| | | |--2.54%--ItemPointerSet
| | | | |
| | | | --0.81%--BlockIdSet
| | | |
| | | |--1.13%--BufferGetPage
| | | | |
| | | | --0.74%--BufferGetBlock
| | | |
| | | |--0.83%--PageGetItemId
| | | |
| | | --0.64%--PageGetItem
| | |
| | --9.51%--ExecStoreBufferHeapTuple
| | |
| | --7.65%--tts_buffer_heap_store_tuple
| | |
| | |--2.47%--IncrBufferRefCount
| | | |
| | | --2.11%--GetPrivateRefCountEntry
| | | |
| | | --1.54%--hash_search
| | | |
| | | |--0.87%--hash_search_with_hash_value
| | | |
| | | --0.57%--uint32_hash
| | | |
| | | --0.54%--hash_bytes_uint32
| | |
| | --2.04%--ReleaseBuffer
| | |
| | --1.95%--UnpinBuffer
| | |
| | |--1.25%--UnpinBufferNoOwner
| | |
| | --0.63%--ResourceOwnerForgetBuffer
| | |
| | --0.56%--ResourceOwnerForget
| |
| --1.83%--ExecFetchSlotHeapTuple
| |
| --0.83%--tts_buffer_heap_get_heap_tuple
|
|--2.20%--TransactionIdPrecedes
|
--1.18%--MultiXactIdPrecedes
91.13% 6.28% postgres [.] vac_update_datfrozenxid
|
|--84.85%--vac_update_datfrozenxid
| |
| |--81.42%--systable_getnext
| | |
| | |--76.61%--table_scan_getnextslot
| | | |
| | | --73.16%--heap_getnextslot
| | | |
| | | |--57.95%--heapgettup_pagemode
| | | | |
| | | | |--30.65%--heap_fetch_next_buffer
| | | | | |
| | | | | |--29.43%--read_stream_next_buffer
| | | | | | |
| | | | | | |--17.13%--WaitReadBuffers
| | | | | | | |
| | | | | | | |--13.62%--smgrreadv
| | | | | | | | |
| | | | | | | | --13.58%--mdreadv
| | | | | | | | |
| | | | | | | | --13.47%--FileReadV
| | | | | | | | |
| | | | | | | | --13.41%--pg_preadv
| | | | | | | | |
| | | | | | | | |--6.71%--__libc_pread64 (inlined)
| | | | | | | | | |
| | | | | | | | | --6.68%--entry_SYSCALL_64_after_hwframe
| | | | | | | | | do_syscall_64
| | | | | | | | | |
| | | | | | | | | --6.66%--x64_sys_call
| | | | | | | | | __x64_sys_pread64
| | | | | | | | | |
| | | | | | | | | --6.62%--vfs_read
| | | | | | | | | |
| | | | | | | | | --6.57%--ext4_file_read_iter
| | | | | | | | | generic_file_read_iter
| | | | | | | | | |
| | | | | | | | | --6.53%--filemap_read
| | | | | | | | | |
| | | | | | | | | --5.57%--copy_page_to_iter
| | | | | | | | | |
| | | | | | | | | --5.45%--_copy_to_iter
| | | | | | | | |
| | | | | | | | --6.70%--__GI_preadv64 (inlined)
| | | | | | | | |
| | | | | | | | --6.64%--entry_SYSCALL_64_after_hwframe
| | | | | | | | |
| | | | | | | | --6.64%--do_syscall_64
| | | | | | | | |
| | | | | | | | --6.58%--x64_sys_call
| | | | | | | | |
| | | | | | | | --6.57%--__x64_sys_preadv
| | | | | | | | |
| | | | | | | | --6.55%--vfs_readv
| | | | | | | | |
| | | | | | | | --6.48%--do_iter_readv_writev
| | | | | | | | |
| | | | | | | | --6.47%--ext4_file_read_iter
| | | | | | | | generic_file_read_iter
| | | | | | | | |
| | | | | | | | --6.46%--filemap_read
| | | | | | | | |
| | | | | | | | --5.72%--copy_page_to_iter
| | | | | | | | |
| | | | | | | | --5.63%--_copy_to_iter
| | | | | | | |
| | | | | | | |--1.58%--TerminateBufferIO
| | | | | | | |
| | | | | | | --1.30%--WaitReadBuffersCanStartIO
| | | | | | | |
| | | | | | | --1.24%--StartBufferIO
| | | | | | | |
| | | | | | | --0.55%--ResourceOwnerEnlarge
| | | | | | |
| | | | | | --11.90%--read_stream_look_ahead
| | | | | | |
| | | | | | --11.33%--read_stream_start_pending_read
| | | | | | |
| | | | | | --11.30%--StartReadBuffers
| | | | | | StartReadBuffersImpl
| | | | | | |
| | | | | | --11.17%--PinBufferForBlock
| | | | | | |
| | | | | | --10.94%--BufferAlloc
| | | | | | |
| | | | | | |--5.08%--GetVictimBuffer
| | | | | | | |
| | | | | | | --3.45%--InvalidateVictimBuffer
| | | | | | | |
| | | | | | | |--0.95%--BufTableDelete
| | | | | | | | |
| | | | | | | | --0.91%--hash_search_with_hash_value
| | | | | | | |
| | | | | | | |--0.93%--BufTableHashCode
| | | | | | | | |
| | | | | | | | --0.90%--get_hash_value
| | | | | | | | |
| | | | | | | | --0.84%--tag_hash
| | | | | | | | |
| | | | | | | | --0.81%--hash_bytes
| | | | | | | |
| | | | | | | --0.56%--LWLockAcquire
| | | | | | |
| | | | | | |--0.96%--LWLockAcquire
| | | | | | | |
| | | | | | | --0.80%--LWLockAttemptLock
| | | | | | |
| | | | | | |--0.95%--BufTableHashCode
| | | | | | | |
| | | | | | | --0.93%--get_hash_value
| | | | | | | |
| | | | | | | --0.89%--tag_hash
| | | | | | | |
| | | | | | | --0.83%--hash_bytes
| | | | | | |
| | | | | | |--0.77%--BufTableLookup
| | | | | | | |
| | | | | | | --0.71%--hash_search_with_hash_value
| | | | | | |
| | | | | | |--0.74%--BufTableInsert
| | | | | | | |
| | | | | | | --0.67%--hash_search_with_hash_value
| | | | | | |
| | | | | | |--0.71%--LWLockRelease
| | | | | | |
| | | | | | --0.71%--ReservePrivateRefCountEntry
| | | | | | |
| | | | | | --0.55%--hash_search
| | | | | |
| | | | | --0.84%--ReleaseBuffer
| | | | | |
| | | | | --0.79%--UnpinBuffer
| | | | | |
| | | | | --0.58%--UnpinBufferNoOwner
| | | | |
| | | | |--16.44%--heap_prepare_pagescan
| | | | | |
| | | | | |--14.71%--page_collect_tuples
| | | | | | |
| | | | | | |--6.82%--HeapTupleSatisfiesVisibility
| | | | | | | |
| | | | | | | --4.85%--HeapTupleSatisfiesMVCC
| | | | | | | |
| | | | | | | --2.41%--XidInMVCCSnapshot
| | | | | | | |
| | | | | | | --1.10%--TransactionIdPrecedes
| | | | | | |
| | | | | | |--1.91%--ItemPointerSet
| | | | | | | |
| | | | | | | --0.81%--BlockIdSet
| | | | | | |
| | | | | | --0.80%--PageGetItemId
| | | | | |
| | | | | --1.11%--LockBuffer
| | | | | |
| | | | | --0.55%--LWLockAcquire
| | | | |
| | | | |--2.54%--ItemPointerSet
| | | | | |
| | | | | --0.81%--BlockIdSet
| | | | |
| | | | |--1.13%--BufferGetPage
| | | | | |
| | | | | --0.74%--BufferGetBlock
| | | | |
| | | | |--0.83%--PageGetItemId
| | | | |
| | | | --0.64%--PageGetItem
| | | |
| | | --9.51%--ExecStoreBufferHeapTuple
| | | |
| | | --7.65%--tts_buffer_heap_store_tuple
| | | |
| | | |--2.47%--IncrBufferRefCount
| | | | |
| | | | --2.11%--GetPrivateRefCountEntry
| | | | |
| | | | --1.54%--hash_search
| | | | |
| | | | |--0.87%--hash_search_with_hash_value
| | | | |
| | | | --0.57%--uint32_hash
| | | | |
| | | | --0.54%--hash_bytes_uint32
| | | |
| | | --2.04%--ReleaseBuffer
| | | |
| | | --1.95%--UnpinBuffer
| | | |
| | | |--1.25%--UnpinBufferNoOwner
| | | |
| | | --0.63%--ResourceOwnerForgetBuffer
| | | |
| | | --0.56%--ResourceOwnerForget
| | |
| | --1.83%--ExecFetchSlotHeapTuple
| | |
| | --0.83%--tts_buffer_heap_get_heap_tuple
| |
| |--2.20%--TransactionIdPrecedes
| |
| --1.18%--MultiXactIdPrecedes
|
--6.28%--_start
__libc_start_main_impl (inlined)
__libc_start_call_main
main
PostmasterMain
ServerLoop
BackendStartup
postmaster_child_launch
BackendMain
PostgresMain
exec_simple_query
PortalRun
PortalRunMulti
PortalRunUtility
ProcessUtility
standard_ProcessUtility
ExecVacuum
vacuum
vac_update_datfrozenxid
81.59% 2.65% postgres [.] systable_getnext
|
|--78.93%--systable_getnext
| |
| |--76.61%--table_scan_getnextslot
| | |
| | --73.16%--heap_getnextslot
| | |
| | |--57.95%--heapgettup_pagemode
| | | |
| | | |--30.65%--heap_fetch_next_buffer
| | | | |
| | | | |--29.43%--read_stream_next_buffer
| | | | | |
| | | | | |--17.13%--WaitReadBuffers
| | | | | | |
| | | | | | |--13.62%--smgrreadv
| | | | | | | |
| | | | | | | --13.58%--mdreadv
| | | | | | | |
| | | | | | | --13.47%--FileReadV
| | | | | | | |
| | | | | | | --13.41%--pg_preadv
| | | | | | | |
| | | | | | | |--6.71%--__libc_pread64 (inlined)
| | | | | | | | |
| | | | | | | | --6.68%--entry_SYSCALL_64_after_hwframe
| | | | | | | | do_syscall_64
| | | | | | | | |
| | | | | | | | --6.66%--x64_sys_call
| | | | | | | | __x64_sys_pread64
| | | | | | | | |
| | | | | | | | --6.62%--vfs_read
| | | | | | | | |
| | | | | | | | --6.57%--ext4_file_read_iter
| | | | | | | | generic_file_read_iter
| | | | | | | | |
| | | | | | | | --6.53%--filemap_read
| | | | | | | | |
| | | | | | | | --5.57%--copy_page_to_iter
| | | | | | | | |
| | | | | | | | --5.45%--_copy_to_iter
| | | | | | | |
| | | | | | | --6.70%--__GI_preadv64 (inlined)
| | | | | | | |
| | | | | | | --6.64%--entry_SYSCALL_64_after_hwframe
| | | | | | | |
| | | | | | | --6.64%--do_syscall_64
| | | | | | | |
| | | | | | | --6.58%--x64_sys_call
| | | | | | | |
| | | | | | | --6.57%--__x64_sys_preadv
| | | | | | | |
| | | | | | | --6.55%--vfs_readv
| | | | | | | |
| | | | | | | --6.48%--do_iter_readv_writev
| | | | | | | |
| | | | | | | --6.47%--ext4_file_read_iter
| | | | | | | generic_file_read_iter
| | | | | | | |
| | | | | | | --6.46%--filemap_read
| | | | | | | |
| | | | | | | --5.72%--copy_page_to_iter
| | | | | | | |
| | | | | | | --5.63%--_copy_to_iter
| | | | | | |
| | | | | | |--1.58%--TerminateBufferIO
| | | | | | |
| | | | | | --1.30%--WaitReadBuffersCanStartIO
| | | | | | |
| | | | | | --1.24%--StartBufferIO
| | | | | | |
| | | | | | --0.55%--ResourceOwnerEnlarge
| | | | | |
| | | | | --11.90%--read_stream_look_ahead
| | | | | |
| | | | | --11.33%--read_stream_start_pending_read
| | | | | |
| | | | | --11.30%--StartReadBuffers
| | | | | StartReadBuffersImpl
| | | | | |
| | | | | --11.17%--PinBufferForBlock
| | | | | |
| | | | | --10.94%--BufferAlloc
| | | | | |
| | | | | |--5.08%--GetVictimBuffer
| | | | | | |
| | | | | | --3.45%--InvalidateVictimBuffer
| | | | | | |
| | | | | | |--0.95%--BufTableDelete
| | | | | | | |
| | | | | | | --0.91%--hash_search_with_hash_value
| | | | | | |
| | | | | | |--0.93%--BufTableHashCode
| | | | | | | |
| | | | | | | --0.90%--get_hash_value
| | | | | | | |
| | | | | | | --0.84%--tag_hash
| | | | | | | |
| | | | | | | --0.81%--hash_bytes
| | | | | | |
| | | | | | --0.56%--LWLockAcquire
| | | | | |
| | | | | |--0.96%--LWLockAcquire
| | | | | | |
| | | | | | --0.80%--LWLockAttemptLock
| | | | | |
| | | | | |--0.95%--BufTableHashCode
| | | | | | |
| | | | | | --0.93%--get_hash_value
| | | | | | |
| | | | | | --0.89%--tag_hash
| | | | | | |
| | | | | | --0.83%--hash_bytes
| | | | | |
| | | | | |--0.77%--BufTableLookup
| | | | | | |
| | | | | | --0.71%--hash_search_with_hash_value
| | | | | |
| | | | | |--0.74%--BufTableInsert
| | | | | | |
| | | | | | --0.67%--hash_search_with_hash_value
| | | | | |
| | | | | |--0.71%--LWLockRelease
| | | | | |
| | | | | --0.71%--ReservePrivateRefCountEntry
| | | | | |
| | | | | --0.55%--hash_search
| | | | |
| | | | --0.84%--ReleaseBuffer
| | | | |
| | | | --0.79%--UnpinBuffer
| | | | |
| | | | --0.58%--UnpinBufferNoOwner
| | | |
| | | |--16.44%--heap_prepare_pagescan
| | | | |
| | | | |--14.71%--page_collect_tuples
| | | | | |
| | | | | |--6.82%--HeapTupleSatisfiesVisibility
| | | | | | |
| | | | | | --4.85%--HeapTupleSatisfiesMVCC
| | | | | | |
| | | | | | --2.41%--XidInMVCCSnapshot
| | | | | | |
| | | | | | --1.10%--TransactionIdPrecedes
| | | | | |
| | | | | |--1.91%--ItemPointerSet
| | | | | | |
| | | | | | --0.81%--BlockIdSet
| | | | | |
| | | | | --0.80%--PageGetItemId
| | | | |
| | | | --1.11%--LockBuffer
| | | | |
| | | | --0.55%--LWLockAcquire
| | | |
| | | |--2.54%--ItemPointerSet
| | | | |
| | | | --0.81%--BlockIdSet
| | | |
| | | |--1.13%--BufferGetPage
| | | | |
| | | | --0.74%--BufferGetBlock
| | | |
| | | |--0.83%--PageGetItemId
| | | |
| | | --0.64%--PageGetItem
| | |
| | --9.51%--ExecStoreBufferHeapTuple
| | |
| | --7.65%--tts_buffer_heap_store_tuple
| | |
| | |--2.47%--IncrBufferRefCount
| | | |
| | | --2.11%--GetPrivateRefCountEntry
| | | |
| | | --1.54%--hash_search
| | | |
| | | |--0.87%--hash_search_with_hash_value
| | | |
| | | --0.57%--uint32_hash
| | | |
| | | --0.54%--hash_bytes_uint32
| | |
| | --2.04%--ReleaseBuffer
| | |
| | --1.95%--UnpinBuffer
| | |
| | |--1.25%--UnpinBufferNoOwner
| | |
| | --0.63%--ResourceOwnerForgetBuffer
| | |
| | --0.56%--ResourceOwnerForget
| |
| --1.83%--ExecFetchSlotHeapTuple
| |
| --0.83%--tts_buffer_heap_get_heap_tuple
|
--2.48%--_start
__libc_start_main_impl (inlined)
__libc_start_call_main
main
PostmasterMain
ServerLoop
BackendStartup
postmaster_child_launch
BackendMain
PostgresMain
exec_simple_query
PortalRun
PortalRunMulti
PortalRunUtility
ProcessUtility
standard_ProcessUtility
ExecVacuum
vacuum
vac_update_datfrozenxid
systable_getnext
76.66% 3.26% postgres [.] table_scan_getnextslot
|
|--73.40%--table_scan_getnextslot
| |
| --73.16%--heap_getnextslot
| |
| |--57.95%--heapgettup_pagemode
| | |
| | |--30.65%--heap_fetch_next_buffer
| | | |
| | | |--29.43%--read_stream_next_buffer
| | | | |
| | | | |--17.13%--WaitReadBuffers
| | | | | |
| | | | | |--13.62%--smgrreadv
| | | | | | |
| | | | | | --13.58%--mdreadv
| | | | | | |
| | | | | | --13.47%--FileReadV
| | | | | | |
| | | | | | --13.41%--pg_preadv
| | | | | | |
| | | | | | |--6.71%--__libc_pread64 (inlined)
| | | | | | | |
| | | | | | | --6.68%--entry_SYSCALL_64_after_hwframe
| | | | | | | do_syscall_64
| | | | | | | |
| | | | | | | --6.66%--x64_sys_call
| | | | | | | __x64_sys_pread64
| | | | | | | |
| | | | | | | --6.62%--vfs_read
| | | | | | | |
| | | | | | | --6.57%--ext4_file_read_iter
| | | | | | | generic_file_read_iter
| | | | | | | |
| | | | | | | --6.53%--filemap_read
| | | | | | | |
| | | | | | | --5.57%--copy_page_to_iter
| | | | | | | |
| | | | | | | --5.45%--_copy_to_iter
| | | | | | |
| | | | | | --6.70%--__GI_preadv64 (inlined)
| | | | | | |
| | | | | | --6.64%--entry_SYSCALL_64_after_hwframe
| | | | | | |
| | | | | | --6.64%--do_syscall_64
| | | | | | |
| | | | | | --6.58%--x64_sys_call
| | | | | | |
| | | | | | --6.57%--__x64_sys_preadv
| | | | | | |
| | | | | | --6.55%--vfs_readv
| | | | | | |
| | | | | | --6.48%--do_iter_readv_writev
| | | | | | |
| | | | | | --6.47%--ext4_file_read_iter
| | | | | | generic_file_read_iter
| | | | | | |
| | | | | | --6.46%--filemap_read
| | | | | | |
| | | | | | --5.72%--copy_page_to_iter
| | | | | | |
| | | | | | --5.63%--_copy_to_iter
| | | | | |
| | | | | |--1.58%--TerminateBufferIO
| | | | | |
| | | | | --1.30%--WaitReadBuffersCanStartIO
| | | | | |
| | | | | --1.24%--StartBufferIO
| | | | | |
| | | | | --0.55%--ResourceOwnerEnlarge
| | | | |
| | | | --11.90%--read_stream_look_ahead
| | | | |
| | | | --11.33%--read_stream_start_pending_read
| | | | |
| | | | --11.30%--StartReadBuffers
| | | | StartReadBuffersImpl
| | | | |
| | | | --11.17%--PinBufferForBlock
| | | | |
| | | | --10.94%--BufferAlloc
| | | | |
| | | | |--5.08%--GetVictimBuffer
| | | | | |
| | | | | --3.45%--InvalidateVictimBuffer
| | | | | |
| | | | | |--0.95%--BufTableDelete
| | | | | | |
| | | | | | --0.91%--hash_search_with_hash_value
| | | | | |
| | | | | |--0.93%--BufTableHashCode
| | | | | | |
| | | | | | --0.90%--get_hash_value
| | | | | | |
| | | | | | --0.84%--tag_hash
| | | | | | |
| | | | | | --0.81%--hash_bytes
| | | | | |
| | | | | --0.56%--LWLockAcquire
| | | | |
| | | | |--0.96%--LWLockAcquire
| | | | | |
| | | | | --0.80%--LWLockAttemptLock
| | | | |
| | | | |--0.95%--BufTableHashCode
| | | | | |
| | | | | --0.93%--get_hash_value
| | | | | |
| | | | | --0.89%--tag_hash
| | | | | |
| | | | | --0.83%--hash_bytes
| | | | |
| | | | |--0.77%--BufTableLookup
| | | | | |
| | | | | --0.71%--hash_search_with_hash_value
| | | | |
| | | | |--0.74%--BufTableInsert
| | | | | |
| | | | | --0.67%--hash_search_with_hash_value
| | | | |
| | | | |--0.71%--LWLockRelease
| | | | |
| | | | --0.71%--ReservePrivateRefCountEntry
| | | | |
| | | | --0.55%--hash_search
| | | |
| | | --0.84%--ReleaseBuffer
| | | |
| | | --0.79%--UnpinBuffer
| | | |
| | | --0.58%--UnpinBufferNoOwner
| | |
| | |--16.44%--heap_prepare_pagescan
| | | |
| | | |--14.71%--page_collect_tuples
| | | | |
| | | | |--6.82%--HeapTupleSatisfiesVisibility
| | | | | |
| | | | | --4.85%--HeapTupleSatisfiesMVCC
| | | | | |
| | | | | --2.41%--XidInMVCCSnapshot
| | | | | |
| | | | | --1.10%--TransactionIdPrecedes
| | | | |
| | | | |--1.91%--ItemPointerSet
| | | | | |
| | | | | --0.81%--BlockIdSet
| | | | |
| | | | --0.80%--PageGetItemId
| | | |
| | | --1.11%--LockBuffer
| | | |
| | | --0.55%--LWLockAcquire
| | |
| | |--2.54%--ItemPointerSet
| | | |
| | | --0.81%--BlockIdSet
| | |
| | |--1.13%--BufferGetPage
| | | |
| | | --0.74%--BufferGetBlock
| | |
| | |--0.83%--PageGetItemId
| | |
| | --0.64%--PageGetItem
| |
| --9.51%--ExecStoreBufferHeapTuple
| |
| --7.65%--tts_buffer_heap_store_tuple
| |
| |--2.47%--IncrBufferRefCount
| | |
| | --2.11%--GetPrivateRefCountEntry
| | |
| | --1.54%--hash_search
| | |
| | |--0.87%--hash_search_with_hash_value
| | |
| | --0.57%--uint32_hash
| | |
| | --0.54%--hash_bytes_uint32
| |
| --2.04%--ReleaseBuffer
| |
| --1.95%--UnpinBuffer
| |
| |--1.25%--UnpinBufferNoOwner
| |
| --0.63%--ResourceOwnerForgetBuffer
| |
| --0.56%--ResourceOwnerForget
|
--3.22%--_start
__libc_start_main_impl (inlined)
__libc_start_call_main
main
PostmasterMain
ServerLoop
BackendStartup
postmaster_child_launch
BackendMain
PostgresMain
exec_simple_query
PortalRun
PortalRunMulti
PortalRunUtility
ProcessUtility
standard_ProcessUtility
ExecVacuum
vacuum
vac_update_datfrozenxid
|
--3.21%--systable_getnext
table_scan_getnextslot
73.58% 5.93% postgres [.] heap_getnextslot
|
|--67.65%--heap_getnextslot
| |
| |--57.95%--heapgettup_pagemode
| | |
| | |--30.65%--heap_fetch_next_buffer
| | | |
| | | |--29.43%--read_stream_next_buffer
| | | | |
| | | | |--17.13%--WaitReadBuffers
| | | | | |
| | | | | |--13.62%--smgrreadv
| | | | | | |
| | | | | | --13.58%--mdreadv
| | | | | | |
| | | | | | --13.47%--FileReadV
| | | | | | |
| | | | | | --13.41%--pg_preadv
| | | | | | |
| | | | | | |--6.71%--__libc_pread64 (inlined)
| | | | | | | |
| | | | | | | --6.68%--entry_SYSCALL_64_after_hwframe
| | | | | | | do_syscall_64
| | | | | | | |
| | | | | | | --6.66%--x64_sys_call
| | | | | | | __x64_sys_pread64
| | | | | | | |
| | | | | | | --6.62%--vfs_read
| | | | | | | |
| | | | | | | --6.57%--ext4_file_read_iter
| | | | | | | generic_file_read_iter
| | | | | | | |
| | | | | | | --6.53%--filemap_read
| | | | | | | |
| | | | | | | --5.57%--copy_page_to_iter
| | | | | | | |
| | | | | | | --5.45%--_copy_to_iter
| | | | | | |
| | | | | | --6.70%--__GI_preadv64 (inlined)
| | | | | | |
| | | | | | --6.64%--entry_SYSCALL_64_after_hwframe
| | | | | | |
| | | | | | --6.64%--do_syscall_64
| | | | | | |
| | | | | | --6.58%--x64_sys_call
| | | | | | |
| | | | | | --6.57%--__x64_sys_preadv
| | | | | | |
| | | | | | --6.55%--vfs_readv
| | | | | | |
| | | | | | --6.48%--do_iter_readv_writev
| | | | | | |
| | | | | | --6.47%--ext4_file_read_iter
| | | | | | generic_file_read_iter
| | | | | | |
| | | | | | --6.46%--filemap_read
| | | | | | |
| | | | | | --5.72%--copy_page_to_iter
| | | | | | |
| | | | | | --5.63%--_copy_to_iter
| | | | | |
| | | | | |--1.58%--TerminateBufferIO
| | | | | |
| | | | | --1.30%--WaitReadBuffersCanStartIO
| | | | | |
| | | | | --1.24%--StartBufferIO
| | | | | |
| | | | | --0.55%--ResourceOwnerEnlarge
| | | | |
| | | | --11.90%--read_stream_look_ahead
| | | | |
| | | | --11.33%--read_stream_start_pending_read
| | | | |
| | | | --11.30%--StartReadBuffers
| | | | StartReadBuffersImpl
| | | | |
| | | | --11.17%--PinBufferForBlock
| | | | |
| | | | --10.94%--BufferAlloc
| | | | |
| | | | |--5.08%--GetVictimBuffer
| | | | | |
| | | | | --3.45%--InvalidateVictimBuffer
| | | | | |
| | | | | |--0.95%--BufTableDelete
| | | | | | |
| | | | | | --0.91%--hash_search_with_hash_value
| | | | | |
| | | | | |--0.93%--BufTableHashCode
| | | | | | |
| | | | | | --0.90%--get_hash_value
| | | | | | |
| | | | | | --0.84%--tag_hash
| | | | | | |
| | | | | | --0.81%--hash_bytes
| | | | | |
| | | | | --0.56%--LWLockAcquire
| | | | |
| | | | |--0.96%--LWLockAcquire
| | | | | |
| | | | | --0.80%--LWLockAttemptLock
| | | | |
| | | | |--0.95%--BufTableHashCode
| | | | | |
| | | | | --0.93%--get_hash_value
| | | | | |
| | | | | --0.89%--tag_hash
| | | | | |
| | | | | --0.83%--hash_bytes
| | | | |
| | | | |--0.77%--BufTableLookup
| | | | | |
| | | | | --0.71%--hash_search_with_hash_value
| | | | |
| | | | |--0.74%--BufTableInsert
| | | | | |
| | | | | --0.67%--hash_search_with_hash_value
| | | | |
| | | | |--0.71%--LWLockRelease
| | | | |
| | | | --0.71%--ReservePrivateRefCountEntry
| | | | |
| | | | --0.55%--hash_search
| | | |
| | | --0.84%--ReleaseBuffer
| | | |
| | | --0.79%--UnpinBuffer
| | | |
| | | --0.58%--UnpinBufferNoOwner
| | |
| | |--16.44%--heap_prepare_pagescan
| | | |
| | | |--14.71%--page_collect_tuples
| | | | |
| | | | |--6.82%--HeapTupleSatisfiesVisibility
| | | | | |
| | | | | --4.85%--HeapTupleSatisfiesMVCC
| | | | | |
| | | | | --2.41%--XidInMVCCSnapshot
| | | | | |
| | | | | --1.10%--TransactionIdPrecedes
| | | | |
| | | | |--1.91%--ItemPointerSet
| | | | | |
| | | | | --0.81%--BlockIdSet
| | | | |
| | | | --0.80%--PageGetItemId
| | | |
| | | --1.11%--LockBuffer
| | | |
| | | --0.55%--LWLockAcquire
| | |
| | |--2.54%--ItemPointerSet
| | | |
| | | --0.81%--BlockIdSet
| | |
| | |--1.13%--BufferGetPage
| | | |
| | | --0.74%--BufferGetBlock
| | |
| | |--0.83%--PageGetItemId
| | |
| | --0.64%--PageGetItem
| |
| --9.51%--ExecStoreBufferHeapTuple
| |
| --7.65%--tts_buffer_heap_store_tuple
| |
| |--2.47%--IncrBufferRefCount
| | |
| | --2.11%--GetPrivateRefCountEntry
| | |
| | --1.54%--hash_search
| | |
| | |--0.87%--hash_search_with_hash_value
| | |
| | --0.57%--uint32_hash
| | |
| | --0.54%--hash_bytes_uint32
| |
| --2.04%--ReleaseBuffer
| |
| --1.95%--UnpinBuffer
| |
| |--1.25%--UnpinBufferNoOwner
| |
| --0.63%--ResourceOwnerForgetBuffer
| |
| --0.56%--ResourceOwnerForget
|
--5.54%--_start
__libc_start_main_impl (inlined)
__libc_start_call_main
main
PostmasterMain
ServerLoop
BackendStartup
postmaster_child_launch
BackendMain
PostgresMain
exec_simple_query
PortalRun
PortalRunMulti
PortalRunUtility
ProcessUtility
standard_ProcessUtility
ExecVacuum
vacuum
vac_update_datfrozenxid
systable_getnext
|
--5.51%--table_scan_getnextslot
heap_getnextslot
58.21% 5.86% postgres [.] heapgettup_pagemode
|
|--52.35%--heapgettup_pagemode
| |
| |--30.65%--heap_fetch_next_buffer
| | |
| | |--29.43%--read_stream_next_buffer
| | | |
| | | |--17.13%--WaitReadBuffers
| | | | |
| | | | |--13.62%--smgrreadv
| | | | | |
| | | | | --13.58%--mdreadv
| | | | | |
| | | | | --13.47%--FileReadV
| | | | | |
| | | | | --13.41%--pg_preadv
| | | | | |
| | | | | |--6.71%--__libc_pread64 (inlined)
| | | | | | |
| | | | | | --6.68%--entry_SYSCALL_64_after_hwframe
| | | | | | do_syscall_64
| | | | | | |
| | | | | | --6.66%--x64_sys_call
| | | | | | __x64_sys_pread64
| | | | | | |
| | | | | | --6.62%--vfs_read
| | | | | | |
| | | | | | --6.57%--ext4_file_read_iter
| | | | | | generic_file_read_iter
| | | | | | |
| | | | | | --6.53%--filemap_read
| | | | | | |
| | | | | | --5.57%--copy_page_to_iter
| | | | | | |
| | | | | | --5.45%--_copy_to_iter
| | | | | |
| | | | | --6.70%--__GI_preadv64 (inlined)
| | | | | |
| | | | | --6.64%--entry_SYSCALL_64_after_hwframe
| | | | | |
| | | | | --6.64%--do_syscall_64
| | | | | |
| | | | | --6.58%--x64_sys_call
| | | | | |
| | | | | --6.57%--__x64_sys_preadv
| | | | | |
| | | | | --6.55%--vfs_readv
| | | | | |
| | | | | --6.48%--do_iter_readv_writev
| | | | | |
| | | | | --6.47%--ext4_file_read_iter
| | | | | generic_file_read_iter
| | | | | |
| | | | | --6.46%--filemap_read
| | | | | |
| | | | | --5.72%--copy_page_to_iter
| | | | | |
| | | | | --5.63%--_copy_to_iter
| | | | |
| | | | |--1.58%--TerminateBufferIO
| | | | |
| | | | --1.30%--WaitReadBuffersCanStartIO
| | | | |
| | | | --1.24%--StartBufferIO
| | | | |
| | | | --0.55%--ResourceOwnerEnlarge
| | | |
| | | --11.90%--read_stream_look_ahead
| | | |
| | | --11.33%--read_stream_start_pending_read
| | | |
| | | --11.30%--StartReadBuffers
| | | StartReadBuffersImpl
| | | |
| | | --11.17%--PinBufferForBlock
| | | |
| | | --10.94%--BufferAlloc
| | | |
| | | |--5.08%--GetVictimBuffer
| | | | |
| | | | --3.45%--InvalidateVictimBuffer
| | | | |
| | | | |--0.95%--BufTableDelete
| | | | | |
| | | | | --0.91%--hash_search_with_hash_value
| | | | |
| | | | |--0.93%--BufTableHashCode
| | | | | |
| | | | | --0.90%--get_hash_value
| | | | | |
| | | | | --0.84%--tag_hash
| | | | | |
| | | | | --0.81%--hash_bytes
| | | | |
| | | | --0.56%--LWLockAcquire
| | | |
| | | |--0.96%--LWLockAcquire
| | | | |
| | | | --0.80%--LWLockAttemptLock
| | | |
| | | |--0.95%--BufTableHashCode
| | | | |
| | | | --0.93%--get_hash_value
| | | | |
| | | | --0.89%--tag_hash
| | | | |
| | | | --0.83%--hash_bytes
| | | |
| | | |--0.77%--BufTableLookup
| | | | |
| | | | --0.71%--hash_search_with_hash_value
| | | |
| | | |--0.74%--BufTableInsert
| | | | |
| | | | --0.67%--hash_search_with_hash_value
| | | |
| | | |--0.71%--LWLockRelease
| | | |
| | | --0.71%--ReservePrivateRefCountEntry
| | | |
| | | --0.55%--hash_search
| | |
| | --0.84%--ReleaseBuffer
| | |
| | --0.79%--UnpinBuffer
| | |
| | --0.58%--UnpinBufferNoOwner
| |
| |--16.44%--heap_prepare_pagescan
| | |
| | |--14.71%--page_collect_tuples
| | | |
| | | |--6.82%--HeapTupleSatisfiesVisibility
| | | | |
| | | | --4.85%--HeapTupleSatisfiesMVCC
| | | | |
| | | | --2.41%--XidInMVCCSnapshot
| | | | |
| | | | --1.10%--TransactionIdPrecedes
| | | |
| | | |--1.91%--ItemPointerSet
| | | | |
| | | | --0.81%--BlockIdSet
| | | |
| | | --0.80%--PageGetItemId
| | |
| | --1.11%--LockBuffer
| | |
| | --0.55%--LWLockAcquire
| |
| |--2.54%--ItemPointerSet
| | |
| | --0.81%--BlockIdSet
| |
| |--1.13%--BufferGetPage
| | |
| | --0.74%--BufferGetBlock
| |
| |--0.83%--PageGetItemId
| |
| --0.64%--PageGetItem
|
--5.60%--_start
__libc_start_main_impl (inlined)
__libc_start_call_main
main
PostmasterMain
ServerLoop
BackendStartup
postmaster_child_launch
BackendMain
PostgresMain
exec_simple_query
PortalRun
PortalRunMulti
PortalRunUtility
ProcessUtility
standard_ProcessUtility
ExecVacuum
vacuum
vac_update_datfrozenxid
systable_getnext
table_scan_getnextslot
heap_getnextslot
heapgettup_pagemode
30.66% 0.23% postgres [.] heap_fetch_next_buffer
|
--30.43%--heap_fetch_next_buffer
|
|--29.43%--read_stream_next_buffer
| |
| |--17.13%--WaitReadBuffers
| | |
| | |--13.62%--smgrreadv
| | | |
| | | --13.58%--mdreadv
| | | |
| | | --13.47%--FileReadV
| | | |
| | | --13.41%--pg_preadv
| | | |
| | | |--6.71%--__libc_pread64 (inlined)
| | | | |
| | | | --6.68%--entry_SYSCALL_64_after_hwframe
| | | | do_syscall_64
| | | | |
| | | | --6.66%--x64_sys_call
| | | | __x64_sys_pread64
| | | | |
| | | | --6.62%--vfs_read
| | | | |
| | | | --6.57%--ext4_file_read_iter
| | | | generic_file_read_iter
| | | | |
| | | | --6.53%--filemap_read
| | | | |
| | | | --5.57%--copy_page_to_iter
| | | | |
| | | | --5.45%--_copy_to_iter
| | | |
| | | --6.70%--__GI_preadv64 (inlined)
| | | |
| | | --6.64%--entry_SYSCALL_64_after_hwframe
| | | |
| | | --6.64%--do_syscall_64
| | | |
| | | --6.58%--x64_sys_call
| | | |
| | | --6.57%--__x64_sys_preadv
| | | |
| | | --6.55%--vfs_readv
| | | |
| | | --6.48%--do_iter_readv_writev
| | | |
| | | --6.47%--ext4_file_read_iter
| | | generic_file_read_iter
| | | |
| | | --6.46%--filemap_read
| | | |
| | | --5.72%--copy_page_to_iter
| | | |
| | | --5.63%--_copy_to_iter
| | |
| | |--1.58%--TerminateBufferIO
| | |
| | --1.30%--WaitReadBuffersCanStartIO
| | |
| | --1.24%--StartBufferIO
| | |
| | --0.55%--ResourceOwnerEnlarge
| |
| --11.90%--read_stream_look_ahead
| |
| --11.33%--read_stream_start_pending_read
| |
| --11.30%--StartReadBuffers
| StartReadBuffersImpl
| |
| --11.17%--PinBufferForBlock
| |
| --10.94%--BufferAlloc
| |
| |--5.08%--GetVictimBuffer
| | |
| | --3.45%--InvalidateVictimBuffer
| | |
| | |--0.95%--BufTableDelete
| | | |
| | | --0.91%--hash_search_with_hash_value
| | |
| | |--0.93%--BufTableHashCode
| | | |
| | | --0.90%--get_hash_value
| | | |
| | | --0.84%--tag_hash
| | | |
| | | --0.81%--hash_bytes
| | |
| | --0.56%--LWLockAcquire
| |
| |--0.96%--LWLockAcquire
| | |
| | --0.80%--LWLockAttemptLock
| |
| |--0.95%--BufTableHashCode
| | |
| | --0.93%--get_hash_value
| | |
| | --0.89%--tag_hash
| | |
| | --0.83%--hash_bytes
| |
| |--0.77%--BufTableLookup
| | |
| | --0.71%--hash_search_with_hash_value
| |
| |--0.74%--BufTableInsert
| | |
| | --0.67%--hash_search_with_hash_value
| |
| |--0.71%--LWLockRelease
| |
| --0.71%--ReservePrivateRefCountEntry
| |
| --0.55%--hash_search
|
--0.84%--ReleaseBuffer
|
--0.79%--UnpinBuffer
|
--0.58%--UnpinBufferNoOwner
29.44% 0.39% postgres [.] read_stream_next_buffer
|
--29.06%--read_stream_next_buffer
|
|--17.13%--WaitReadBuffers
| |
| |--13.62%--smgrreadv
| | |
| | --13.58%--mdreadv
| | |
| | --13.47%--FileReadV
| | |
| | --13.41%--pg_preadv
| | |
| | |--6.71%--__libc_pread64 (inlined)
| | | |
| | | --6.68%--entry_SYSCALL_64_after_hwframe
| | | do_syscall_64
| | | |
| | | --6.66%--x64_sys_call
| | | __x64_sys_pread64
| | | |
| | | --6.62%--vfs_read
| | | |
| | | --6.57%--ext4_file_read_iter
| | | generic_file_read_iter
| | | |
| | | --6.53%--filemap_read
| | | |
| | | --5.57%--copy_page_to_iter
| | | |
| | | --5.45%--_copy_to_iter
| | |
| | --6.70%--__GI_preadv64 (inlined)
| | |
| | --6.64%--entry_SYSCALL_64_after_hwframe
| | |
| | --6.64%--do_syscall_64
| | |
| | --6.58%--x64_sys_call
| | |
| | --6.57%--__x64_sys_preadv
| | |
| | --6.55%--vfs_readv
| | |
| | --6.48%--do_iter_readv_writev
| | |
| | --6.47%--ext4_file_read_iter
| | generic_file_read_iter
| | |
| | --6.46%--filemap_read
| | |
| | --5.72%--copy_page_to_iter
| | |
| | --5.63%--_copy_to_iter
| |
| |--1.58%--TerminateBufferIO
| |
| --1.30%--WaitReadBuffersCanStartIO
| |
| --1.24%--StartBufferIO
| |
| --0.55%--ResourceOwnerEnlarge
|
--11.90%--read_stream_look_ahead
|
--11.33%--read_stream_start_pending_read
|
--11.30%--StartReadBuffers
StartReadBuffersImpl
|
--11.17%--PinBufferForBlock
|
--10.94%--BufferAlloc
|
|--5.08%--GetVictimBuffer
| |
| --3.45%--InvalidateVictimBuffer
| |
| |--0.95%--BufTableDelete
| | |
| | --0.91%--hash_search_with_hash_value
| |
| |--0.93%--BufTableHashCode
| | |
| | --0.90%--get_hash_value
| | |
| | --0.84%--tag_hash
| | |
| | --0.81%--hash_bytes
| |
| --0.56%--LWLockAcquire
|
|--0.96%--LWLockAcquire
| |
| --0.80%--LWLockAttemptLock
|
|--0.95%--BufTableHashCode
| |
| --0.93%--get_hash_value
| |
| --0.89%--tag_hash
| |
| --0.83%--hash_bytes
|
|--0.77%--BufTableLookup
| |
| --0.71%--hash_search_with_hash_value
|
|--0.74%--BufTableInsert
| |
| --0.67%--hash_search_with_hash_value
|
|--0.71%--LWLockRelease
|
--0.71%--ReservePrivateRefCountEntry
|
--0.55%--hash_search
16.46% 0.21% postgres [.] heap_prepare_pagescan
|
--16.24%--heap_prepare_pagescan
|
|--14.71%--page_collect_tuples
| |
| |--6.82%--HeapTupleSatisfiesVisibility
| | |
| | --4.85%--HeapTupleSatisfiesMVCC
| | |
| | --2.41%--XidInMVCCSnapshot
| | |
| | --1.10%--TransactionIdPrecedes
| |
| |--1.91%--ItemPointerSet
| | |
| | --0.81%--BlockIdSet
| |
| --0.80%--PageGetItemId
|
--1.11%--LockBuffer
|
--0.55%--LWLockAcquire
14.73% 4.85% postgres [.] page_collect_tuples
|
|--9.88%--page_collect_tuples
| |
| |--6.82%--HeapTupleSatisfiesVisibility
| | |
| | --4.85%--HeapTupleSatisfiesMVCC
| | |
| | --2.41%--XidInMVCCSnapshot
| | |
| | --1.10%--TransactionIdPrecedes
| |
| |--1.91%--ItemPointerSet
| | |
| | --0.81%--BlockIdSet
| |
| --0.80%--PageGetItemId
|
--4.83%--_start
__libc_start_main_impl (inlined)
__libc_start_call_main
main
PostmasterMain
ServerLoop
BackendStartup
postmaster_child_launch
BackendMain
PostgresMain
exec_simple_query
PortalRun
PortalRunMulti
PortalRunUtility
ProcessUtility
standard_ProcessUtility
ExecVacuum
vacuum
vac_update_datfrozenxid
systable_getnext
table_scan_getnextslot
heap_getnextslot
heapgettup_pagemode
heap_prepare_pagescan
page_collect_tuples
11.91% 0.31% postgres [.] read_stream_look_ahead
|
--11.60%--read_stream_look_ahead
|
--11.33%--read_stream_start_pending_read
|
--11.30%--StartReadBuffers
StartReadBuffersImpl
|
--11.17%--PinBufferForBlock
|
--10.94%--BufferAlloc
|
|--5.08%--GetVictimBuffer
| |
| --3.45%--InvalidateVictimBuffer
| |
| |--0.95%--BufTableDelete
| | |
| | --0.91%--hash_search_with_hash_value
| |
| |--0.93%--BufTableHashCode
| | |
| | --0.90%--get_hash_value
| | |
| | --0.84%--tag_hash
| | |
| | --0.81%--hash_bytes
| |
| --0.56%--LWLockAcquire
|
|--0.96%--LWLockAcquire
| |
| --0.80%--LWLockAttemptLock
|
|--0.95%--BufTableHashCode
| |
| --0.93%--get_hash_value
| |
| --0.89%--tag_hash
| |
| --0.83%--hash_bytes
|
|--0.77%--BufTableLookup
| |
| --0.71%--hash_search_with_hash_value
|
|--0.74%--BufTableInsert
| |
| --0.67%--hash_search_with_hash_value
|
|--0.71%--LWLockRelease
|
--0.71%--ReservePrivateRefCountEntry
|
--0.55%--hash_search
11.33% 0.02% postgres [.] read_stream_start_pending_read
|
--11.30%--read_stream_start_pending_read
|
--11.30%--StartReadBuffers
StartReadBuffersImpl
|
--11.17%--PinBufferForBlock
|
--10.94%--BufferAlloc
|
|--5.08%--GetVictimBuffer
| |
| --3.45%--InvalidateVictimBuffer
| |
| |--0.95%--BufTableDelete
| | |
| | --0.91%--hash_search_with_hash_value
| |
| |--0.93%--BufTableHashCode
| | |
| | --0.90%--get_hash_value
| | |
| | --0.84%--tag_hash
| | |
| | --0.81%--hash_bytes
| |
| --0.56%--LWLockAcquire
|
|--0.96%--LWLockAcquire
| |
| --0.80%--LWLockAttemptLock
|
|--0.95%--BufTableHashCode
| |
| --0.93%--get_hash_value
| |
| --0.89%--tag_hash
| |
| --0.83%--hash_bytes
|
|--0.77%--BufTableLookup
| |
| --0.71%--hash_search_with_hash_value
|
|--0.74%--BufTableInsert
| |
| --0.67%--hash_search_with_hash_value
|
|--0.71%--LWLockRelease
|
--0.71%--ReservePrivateRefCountEntry
|
--0.55%--hash_search
11.30% 0.12% postgres [.] StartReadBuffersImpl
|
--11.18%--StartReadBuffersImpl
|
--11.17%--PinBufferForBlock
|
--10.95%--BufferAlloc
|
|--5.08%--GetVictimBuffer
| |
| --3.45%--InvalidateVictimBuffer
| |
| |--0.95%--BufTableDelete
| | |
| | --0.91%--hash_search_with_hash_value
| |
| |--0.93%--BufTableHashCode
| | |
| | --0.90%--get_hash_value
| | |
| | --0.84%--tag_hash
| | |
| | --0.81%--hash_bytes
| |
| --0.56%--LWLockAcquire
|
|--0.96%--LWLockAcquire
| |
| --0.80%--LWLockAttemptLock
|
|--0.95%--BufTableHashCode
| |
| --0.93%--get_hash_value
| |
| --0.89%--tag_hash
| |
| --0.83%--hash_bytes
|
|--0.77%--BufTableLookup
| |
| --0.71%--hash_search_with_hash_value
|
|--0.74%--BufTableInsert
| |
| --0.67%--hash_search_with_hash_value
|
|--0.71%--LWLockRelease
|
--0.71%--ReservePrivateRefCountEntry
|
--0.55%--hash_search
11.30% 0.00% postgres [.] StartReadBuffers
|
---StartReadBuffers
StartReadBuffersImpl
|
--11.17%--PinBufferForBlock
|
--10.94%--BufferAlloc
|
|--5.08%--GetVictimBuffer
| |
| --3.45%--InvalidateVictimBuffer
| |
| |--0.95%--BufTableDelete
| | |
| | --0.91%--hash_search_with_hash_value
| |
| |--0.93%--BufTableHashCode
| | |
| | --0.90%--get_hash_value
| | |
| | --0.84%--tag_hash
| | |
| | --0.81%--hash_bytes
| |
| --0.56%--LWLockAcquire
|
|--0.96%--LWLockAcquire
| |
| --0.80%--LWLockAttemptLock
|
|--0.95%--BufTableHashCode
| |
| --0.93%--get_hash_value
| |
| --0.89%--tag_hash
| |
| --0.83%--hash_bytes
|
|--0.77%--BufTableLookup
| |
| --0.71%--hash_search_with_hash_value
|
|--0.74%--BufTableInsert
| |
| --0.67%--hash_search_with_hash_value
|
|--0.71%--LWLockRelease
|
--0.71%--ReservePrivateRefCountEntry
|
--0.55%--hash_search
11.18% 0.10% postgres [.] PinBufferForBlock
|
--11.08%--PinBufferForBlock
|
--10.95%--BufferAlloc
|
|--5.08%--GetVictimBuffer
| |
| --3.45%--InvalidateVictimBuffer
| |
| |--0.95%--BufTableDelete
| | |
| | --0.91%--hash_search_with_hash_value
| |
| |--0.93%--BufTableHashCode
| | |
| | --0.90%--get_hash_value
| | |
| | --0.84%--tag_hash
| | |
| | --0.81%--hash_bytes
| |
| --0.56%--LWLockAcquire
|
|--0.96%--LWLockAcquire
| |
| --0.80%--LWLockAttemptLock
|
|--0.95%--BufTableHashCode
| |
| --0.93%--get_hash_value
| |
| --0.89%--tag_hash
| |
| --0.83%--hash_bytes
|
|--0.77%--BufTableLookup
| |
| --0.71%--hash_search_with_hash_value
|
|--0.74%--BufTableInsert
| |
| --0.67%--hash_search_with_hash_value
|
|--0.71%--LWLockRelease
|
--0.71%--ReservePrivateRefCountEntry
|
--0.55%--hash_search
10.96% 0.24% postgres [.] BufferAlloc
|
--10.72%--BufferAlloc
|
|--5.08%--GetVictimBuffer
| |
| --3.45%--InvalidateVictimBuffer
| |
| |--0.95%--BufTableDelete
| | |
| | --0.91%--hash_search_with_hash_value
| |
| |--0.93%--BufTableHashCode
| | |
| | --0.90%--get_hash_value
| | |
| | --0.84%--tag_hash
| | |
| | --0.81%--hash_bytes
| |
| --0.56%--LWLockAcquire
|
|--0.96%--LWLockAcquire
| |
| --0.80%--LWLockAttemptLock
|
|--0.95%--BufTableHashCode
| |
| --0.93%--get_hash_value
| |
| --0.89%--tag_hash
| |
| --0.83%--hash_bytes
|
|--0.77%--BufTableLookup
| |
| --0.71%--hash_search_with_hash_value
|
|--0.74%--BufTableInsert
| |
| --0.67%--hash_search_with_hash_value
|
|--0.71%--LWLockRelease
|
--0.71%--ReservePrivateRefCountEntry
|
--0.55%--hash_search
10.09% 2.42% postgres [.] ExecStoreBufferHeapTuple
|
|--7.67%--ExecStoreBufferHeapTuple
| |
| --7.65%--tts_buffer_heap_store_tuple
| |
| |--2.47%--IncrBufferRefCount
| | |
| | --2.11%--GetPrivateRefCountEntry
| | |
| | --1.54%--hash_search
| | |
| | |--0.87%--hash_search_with_hash_value
| | |
| | --0.57%--uint32_hash
| | |
| | --0.54%--hash_bytes_uint32
| |
| --2.04%--ReleaseBuffer
| |
| --1.95%--UnpinBuffer
| |
| |--1.25%--UnpinBufferNoOwner
| |
| --0.63%--ResourceOwnerForgetBuffer
| |
| --0.56%--ResourceOwnerForget
|
--2.04%--_start
__libc_start_main_impl (inlined)
__libc_start_call_main
main
PostmasterMain
ServerLoop
BackendStartup
postmaster_child_launch
BackendMain
PostgresMain
exec_simple_query
PortalRun
PortalRunMulti
PortalRunUtility
ProcessUtility
standard_ProcessUtility
ExecVacuum
vacuum
vac_update_datfrozenxid
systable_getnext
table_scan_getnextslot
|
--1.84%--heap_getnextslot
ExecStoreBufferHeapTuple
8.05% 3.48% postgres [.] tts_buffer_heap_store_tuple
|
|--4.57%--tts_buffer_heap_store_tuple
| |
| |--2.47%--IncrBufferRefCount
| | |
| | --2.11%--GetPrivateRefCountEntry
| | |
| | --1.54%--hash_search
| | |
| | |--0.87%--hash_search_with_hash_value
| | |
| | --0.57%--uint32_hash
| | |
| | --0.54%--hash_bytes_uint32
| |
| --2.04%--ReleaseBuffer
| |
| --1.95%--UnpinBuffer
| |
| |--1.25%--UnpinBufferNoOwner
| |
| --0.63%--ResourceOwnerForgetBuffer
| |
| --0.56%--ResourceOwnerForget
|
--3.23%--_start
__libc_start_main_impl (inlined)
__libc_start_call_main
main
PostmasterMain
ServerLoop
BackendStartup
postmaster_child_launch
BackendMain
PostgresMain
exec_simple_query
PortalRun
PortalRunMulti
PortalRunUtility
ProcessUtility
standard_ProcessUtility
ExecVacuum
vacuum
vac_update_datfrozenxid
systable_getnext
table_scan_getnextslot
heap_getnextslot
|
--3.08%--ExecStoreBufferHeapTuple
tts_buffer_heap_store_tuple
5.08% 0.16% postgres [.] GetVictimBuffer
|
--4.92%--GetVictimBuffer
|
--3.45%--InvalidateVictimBuffer
|
|--0.95%--BufTableDelete
| |
| --0.91%--hash_search_with_hash_value
|
|--0.93%--BufTableHashCode
| |
| --0.90%--get_hash_value
| |
| --0.84%--tag_hash
| |
| --0.81%--hash_bytes
|
--0.56%--LWLockAcquire
4.79% 3.14% postgres [.] ItemPointerSet
|
|--2.81%--_start
| __libc_start_main_impl (inlined)
| __libc_start_call_main
| main
| PostmasterMain
| ServerLoop
| BackendStartup
| postmaster_child_launch
| BackendMain
| PostgresMain
| exec_simple_query
| PortalRun
| PortalRunMulti
| PortalRunUtility
| ProcessUtility
| standard_ProcessUtility
| ExecVacuum
| vacuum
| vac_update_datfrozenxid
| systable_getnext
| table_scan_getnextslot
| heap_getnextslot
| heapgettup_pagemode
| |
| |--1.71%--ItemPointerSet
| |
| --1.10%--heap_prepare_pagescan
| page_collect_tuples
| ItemPointerSet
|
--1.64%--ItemPointerSet
|
--1.62%--BlockIdSet
4.03% 4.02% postgres [.] TransactionIdPrecedes
|
--3.28%--_start
__libc_start_main_impl (inlined)
__libc_start_call_main
main
PostmasterMain
ServerLoop
BackendStartup
postmaster_child_launch
BackendMain
PostgresMain
exec_simple_query
PortalRun
PortalRunMulti
PortalRunUtility
ProcessUtility
standard_ProcessUtility
ExecVacuum
vacuum
vac_update_datfrozenxid
|
|--2.19%--TransactionIdPrecedes
|
--1.09%--systable_getnext
table_scan_getnextslot
heap_getnextslot
heapgettup_pagemode
heap_prepare_pagescan
page_collect_tuples
HeapTupleSatisfiesVisibility
HeapTupleSatisfiesMVCC
XidInMVCCSnapshot
TransactionIdPrecedes
3.69% 1.97% postgres [.] hash_search_with_hash_value
|
|--1.94%--_start
| __libc_start_main_impl (inlined)
| __libc_start_call_main
| main
| PostmasterMain
| ServerLoop
| BackendStartup
| postmaster_child_launch
| BackendMain
| PostgresMain
| exec_simple_query
| PortalRun
| PortalRunMulti
| PortalRunUtility
| ProcessUtility
| standard_ProcessUtility
| ExecVacuum
| vacuum
| vac_update_datfrozenxid
| systable_getnext
| table_scan_getnextslot
| heap_getnextslot
| |
| --1.45%--heapgettup_pagemode
| heap_fetch_next_buffer
| read_stream_next_buffer
| read_stream_look_ahead
| read_stream_start_pending_read
| StartReadBuffers
| StartReadBuffersImpl
| PinBufferForBlock
| BufferAlloc
| |
| |--0.53%--BufTableLookup
| | hash_search_with_hash_value
| |
| --0.52%--GetVictimBuffer
| InvalidateVictimBuffer
| BufTableDelete
| hash_search_with_hash_value
|
--1.72%--hash_search_with_hash_value
|
--1.02%--hash_initial_lookup
3.46% 0.12% postgres [.] InvalidateVictimBuffer
|
--3.34%--InvalidateVictimBuffer
|
|--0.95%--BufTableDelete
| |
| --0.91%--hash_search_with_hash_value
|
|--0.93%--BufTableHashCode
| |
| --0.90%--get_hash_value
| |
| --0.84%--tag_hash
| |
| --0.81%--hash_bytes
|
--0.56%--LWLockAcquire
3.12% 1.39% postgres [.] GetPrivateRefCountEntry
|
|--1.73%--GetPrivateRefCountEntry
| |
| --1.58%--hash_search
| |
| |--0.89%--hash_search_with_hash_value
| |
| --0.59%--uint32_hash
| |
| --0.56%--hash_bytes_uint32
|
--1.38%--_start
__libc_start_main_impl (inlined)
__libc_start_call_main
main
PostmasterMain
ServerLoop
BackendStartup
postmaster_child_launch
BackendMain
PostgresMain
exec_simple_query
PortalRun
PortalRunMulti
PortalRunUtility
ProcessUtility
standard_ProcessUtility
ExecVacuum
vacuum
vac_update_datfrozenxid
systable_getnext
table_scan_getnextslot
heap_getnextslot
|
|--0.77%--ExecStoreBufferHeapTuple
| tts_buffer_heap_store_tuple
|
--0.61%--heapgettup_pagemode
heap_fetch_next_buffer
2.95% 0.18% postgres [.] ReleaseBuffer
|
--2.76%--ReleaseBuffer
|
--2.75%--UnpinBuffer
|
|--1.83%--UnpinBufferNoOwner
| |
| --0.74%--GetPrivateRefCountEntry
|
--0.82%--ResourceOwnerForgetBuffer
|
--0.72%--ResourceOwnerForget
2.79% 0.11% postgres [.] UnpinBuffer
|
--2.67%--UnpinBuffer
|
|--1.83%--UnpinBufferNoOwner
| |
| --0.74%--GetPrivateRefCountEntry
|
--0.82%--ResourceOwnerForgetBuffer
|
--0.72%--ResourceOwnerForget
2.74% 1.64% postgres [.] XidInMVCCSnapshot
|
|--1.31%--_start
| __libc_start_main_impl (inlined)
| __libc_start_call_main
| main
| PostmasterMain
| ServerLoop
| BackendStartup
| postmaster_child_launch
| BackendMain
| PostgresMain
| exec_simple_query
| PortalRun
| PortalRunMulti
| PortalRunUtility
| ProcessUtility
| standard_ProcessUtility
| ExecVacuum
| vacuum
| vac_update_datfrozenxid
| systable_getnext
| table_scan_getnextslot
| heap_getnextslot
| heapgettup_pagemode
| heap_prepare_pagescan
| page_collect_tuples
| HeapTupleSatisfiesVisibility
| HeapTupleSatisfiesMVCC
| XidInMVCCSnapshot
|
--1.10%--XidInMVCCSnapshot
TransactionIdPrecedes
2.48% 0.07% postgres [.] IncrBufferRefCount
|
--2.41%--IncrBufferRefCount
|
--2.11%--GetPrivateRefCountEntry
|
--1.54%--hash_search
|
|--0.87%--hash_search_with_hash_value
|
--0.57%--uint32_hash
|
--0.54%--hash_bytes_uint32
2.31% 0.12% postgres [.] hash_search
|
--2.18%--hash_search
|
|--1.37%--hash_search_with_hash_value
|
--0.79%--uint32_hash
|
--0.76%--hash_bytes_uint32
2.21% 1.37% postgres [.] ExecFetchSlotHeapTuple
|
|--0.99%--_start
| __libc_start_main_impl (inlined)
| __libc_start_call_main
| main
| PostmasterMain
| ServerLoop
| BackendStartup
| postmaster_child_launch
| BackendMain
| PostgresMain
| exec_simple_query
| PortalRun
| PortalRunMulti
| PortalRunUtility
| ProcessUtility
| standard_ProcessUtility
| ExecVacuum
| vacuum
| vac_update_datfrozenxid
| systable_getnext
| ExecFetchSlotHeapTuple
|
--0.84%--ExecFetchSlotHeapTuple
|
--0.83%--tts_buffer_heap_get_heap_tuple
2.19% 2.13% postgres [.] PageGetItemId
|
--1.58%--_start
__libc_start_main_impl (inlined)
__libc_start_call_main
main
PostmasterMain
ServerLoop
BackendStartup
postmaster_child_launch
BackendMain
PostgresMain
exec_simple_query
PortalRun
PortalRunMulti
PortalRunUtility
ProcessUtility
standard_ProcessUtility
ExecVacuum
vacuum
vac_update_datfrozenxid
systable_getnext
table_scan_getnextslot
heap_getnextslot
heapgettup_pagemode
|
|--0.81%--PageGetItemId
|
--0.77%--heap_prepare_pagescan
page_collect_tuples
PageGetItemId
2.11% 0.37% postgres [.] LWLockAcquire
|
--1.74%--LWLockAcquire
|
--1.73%--LWLockAttemptLock
|
--0.89%--pg_atomic_compare_exchange_u32
|
--0.76%--pg_atomic_compare_exchange_u32_impl
1.90% 1.89% postgres [.] BlockIdSet
|
--1.60%--_start
__libc_start_main_impl (inlined)
__libc_start_call_main
main
PostmasterMain
ServerLoop
BackendStartup
postmaster_child_launch
BackendMain
PostgresMain
exec_simple_query
PortalRun
PortalRunMulti
PortalRunUtility
ProcessUtility
standard_ProcessUtility
ExecVacuum
vacuum
vac_update_datfrozenxid
systable_getnext
table_scan_getnextslot
heap_getnextslot
heapgettup_pagemode
|
|--0.81%--heap_prepare_pagescan
| page_collect_tuples
| ItemPointerSet
| BlockIdSet
|
--0.79%--ItemPointerSet
BlockIdSet
1.89% 0.06% postgres [.] BufTableHashCode
|
--1.83%--BufTableHashCode
get_hash_value
|
--1.73%--tag_hash
|
--1.65%--hash_bytes
1.87% 0.34% postgres [.] LockBufHdr
|
--1.53%--LockBufHdr
|
--1.16%--pg_atomic_fetch_or_u32
|
--1.00%--pg_atomic_fetch_or_u32_impl
1.85% 0.52% postgres [.] UnpinBufferNoOwner
|
--1.33%--UnpinBufferNoOwner
|
--0.74%--GetPrivateRefCountEntry
1.84% 0.10% postgres [.] get_hash_value
|
--1.74%--get_hash_value
|
--1.73%--tag_hash
|
--1.65%--hash_bytes
1.78% 0.52% postgres [.] LWLockAttemptLock
|
--1.26%--LWLockAttemptLock
|
--0.89%--pg_atomic_compare_exchange_u32
|
--0.76%--pg_atomic_compare_exchange_u32_impl
1.75% 0.11% postgres [.] tag_hash
|
--1.65%--tag_hash
hash_bytes
1.69% 1.67% postgres [.] MultiXactIdPrecedes
|
|--1.15%--_start
| __libc_start_main_impl (inlined)
| __libc_start_call_main
| main
| PostmasterMain
| ServerLoop
| BackendStartup
| postmaster_child_launch
| BackendMain
| PostgresMain
| exec_simple_query
| PortalRun
| PortalRunMulti
| PortalRunUtility
| ProcessUtility
| standard_ProcessUtility
| ExecVacuum
| vacuum
| vac_update_datfrozenxid
| MultiXactIdPrecedes
|
--0.52%--0xa00000012
LocalExecuteInvalidationMessage
MultiXactIdPrecedes
1.67% 1.38% postgres [.] hash_bytes
|
--1.37%--_start
__libc_start_main_impl (inlined)
__libc_start_call_main
main
PostmasterMain
ServerLoop
BackendStartup
postmaster_child_launch
BackendMain
PostgresMain
exec_simple_query
PortalRun
PortalRunMulti
PortalRunUtility
ProcessUtility
standard_ProcessUtility
ExecVacuum
vacuum
vac_update_datfrozenxid
systable_getnext
table_scan_getnextslot
heap_getnextslot
heapgettup_pagemode
heap_fetch_next_buffer
read_stream_next_buffer
read_stream_look_ahead
read_stream_start_pending_read
StartReadBuffers
StartReadBuffersImpl
PinBufferForBlock
BufferAlloc
|
|--0.70%--GetVictimBuffer
| InvalidateVictimBuffer
| BufTableHashCode
| get_hash_value
| |
| --0.69%--tag_hash
| hash_bytes
|
--0.67%--BufTableHashCode
get_hash_value
tag_hash
hash_bytes
1.59% 0.18% postgres [.] TerminateBufferIO
|
--1.41%--TerminateBufferIO
1.50% 0.63% postgres [.] LWLockRelease
|
|--0.87%--LWLockRelease
| pg_atomic_sub_fetch_u32
| |
| --0.73%--pg_atomic_sub_fetch_u32_impl
| |
| --0.58%--pg_atomic_fetch_sub_u32_impl
|
--0.62%--_start
__libc_start_main_impl (inlined)
__libc_start_call_main
main
PostmasterMain
ServerLoop
BackendStartup
postmaster_child_launch
BackendMain
PostgresMain
exec_simple_query
PortalRun
PortalRunMulti
PortalRunUtility
ProcessUtility
standard_ProcessUtility
ExecVacuum
vacuum
vac_update_datfrozenxid
systable_getnext
table_scan_getnextslot
heap_getnextslot
heapgettup_pagemode
1.35% 1.29% postgres [.] PageGetItem
|
--0.90%--_start
__libc_start_main_impl (inlined)
__libc_start_call_main
main
PostmasterMain
ServerLoop
BackendStartup
postmaster_child_launch
BackendMain
PostgresMain
exec_simple_query
PortalRun
PortalRunMulti
PortalRunUtility
ProcessUtility
standard_ProcessUtility
ExecVacuum
vacuum
vac_update_datfrozenxid
systable_getnext
table_scan_getnextslot
heap_getnextslot
heapgettup_pagemode
|
--0.59%--PageGetItem
1.32% 0.06% postgres [.] WaitReadBuffersCanStartIO
|
--1.26%--WaitReadBuffersCanStartIO
|
--1.24%--StartBufferIO
|
--0.55%--ResourceOwnerEnlarge
1.28% 0.27% postgres [.] pg_atomic_fetch_or_u32
|
--1.01%--pg_atomic_fetch_or_u32
|
--1.00%--pg_atomic_fetch_or_u32_impl
1.24% 0.09% postgres [.] StartBufferIO
|
--1.15%--StartBufferIO
|
--0.55%--ResourceOwnerEnlarge
1.23% 1.23% postgres [.] tts_buffer_heap_get_heap_tuple
|
--1.14%--_start
__libc_start_main_impl (inlined)
__libc_start_call_main
main
PostmasterMain
ServerLoop
BackendStartup
postmaster_child_launch
BackendMain
PostgresMain
exec_simple_query
PortalRun
PortalRunMulti
PortalRunUtility
ProcessUtility
standard_ProcessUtility
ExecVacuum
vacuum
vac_update_datfrozenxid
systable_getnext
|
--0.83%--ExecFetchSlotHeapTuple
tts_buffer_heap_get_heap_tuple
1.20% 0.00% postgres [.] 0x0000651af1babc37
|
---0x651af1babc37
1.16% 0.99% postgres [.] ResourceOwnerForget
|
--0.97%--_start
__libc_start_main_impl (inlined)
__libc_start_call_main
main
PostmasterMain
ServerLoop
BackendStartup
postmaster_child_launch
BackendMain
PostgresMain
exec_simple_query
PortalRun
PortalRunMulti
PortalRunUtility
ProcessUtility
standard_ProcessUtility
ExecVacuum
vacuum
vac_update_datfrozenxid
systable_getnext
table_scan_getnextslot
heap_getnextslot
1.15% 0.15% postgres [.] LockBuffer
|
--1.00%--LockBuffer
|
--0.55%--LWLockAcquire
1.12% 0.00% postgres [.] 0x0000000a00000012
|
---0xa00000012
LocalExecuteInvalidationMessage
|
--0.52%--MultiXactIdPrecedes
1.12% 0.00% postgres [.] LocalExecuteInvalidationMessage
|
---LocalExecuteInvalidationMessage
|
--0.52%--MultiXactIdPrecedes
1.10% 0.83% postgres [.] hash_initial_lookup
|
--0.78%--_start
__libc_start_main_impl (inlined)
__libc_start_call_main
main
PostmasterMain
ServerLoop
BackendStartup
postmaster_child_launch
BackendMain
PostgresMain
exec_simple_query
PortalRun
PortalRunMulti
PortalRunUtility
ProcessUtility
standard_ProcessUtility
ExecVacuum
vacuum
vac_update_datfrozenxid
systable_getnext
table_scan_getnextslot
heap_getnextslot
|
--0.50%--heapgettup_pagemode
heap_fetch_next_buffer
read_stream_next_buffer
read_stream_look_ahead
read_stream_start_pending_read
StartReadBuffers
StartReadBuffersImpl
PinBufferForBlock
BufferAlloc
1.04% 1.04% postgres [.] pg_atomic_fetch_or_u32_impl
|
--1.00%--_start
__libc_start_main_impl (inlined)
__libc_start_call_main
main
PostmasterMain
ServerLoop
BackendStartup
postmaster_child_launch
BackendMain
PostgresMain
exec_simple_query
PortalRun
PortalRunMulti
PortalRunUtility
ProcessUtility
standard_ProcessUtility
ExecVacuum
vacuum
vac_update_datfrozenxid
systable_getnext
table_scan_getnextslot
heap_getnextslot
heapgettup_pagemode
heap_fetch_next_buffer
read_stream_next_buffer
|
--0.59%--read_stream_look_ahead
read_stream_start_pending_read
StartReadBuffers
StartReadBuffersImpl
PinBufferForBlock
BufferAlloc
0.96% 0.06% postgres [.] BufTableDelete
|
--0.91%--BufTableDelete
hash_search_with_hash_value
0.92% 0.17% postgres [.] pg_atomic_compare_exchange_u32
|
--0.76%--pg_atomic_compare_exchange_u32
pg_atomic_compare_exchange_u32_impl
0.91% 0.27% postgres [.] ReservePrivateRefCountEntry
|
--0.65%--ReservePrivateRefCountEntry
hash_search
0.88% 0.15% postgres [.] pg_atomic_sub_fetch_u32
|
--0.73%--pg_atomic_sub_fetch_u32
pg_atomic_sub_fetch_u32_impl
|
--0.58%--pg_atomic_fetch_sub_u32_impl
0.84% 0.83% postgres [.] pg_rotate_left32
|
--0.52%--_start
__libc_start_main_impl (inlined)
__libc_start_call_main
main
PostmasterMain
ServerLoop
BackendStartup
postmaster_child_launch
BackendMain
PostgresMain
exec_simple_query
PortalRun
PortalRunMulti
PortalRunUtility
ProcessUtility
standard_ProcessUtility
ExecVacuum
vacuum
vac_update_datfrozenxid
systable_getnext
table_scan_getnextslot
heap_getnextslot
0.84% 0.10% postgres [.] ResourceOwnerForgetBuffer
|
--0.74%--ResourceOwnerForgetBuffer
|
--0.72%--ResourceOwnerForget
0.79% 0.79% postgres [.] pg_atomic_compare_exchange_u32_impl
|
--0.76%--_start
__libc_start_main_impl (inlined)
__libc_start_call_main
main
PostmasterMain
ServerLoop
BackendStartup
postmaster_child_launch
BackendMain
PostgresMain
exec_simple_query
PortalRun
PortalRunMulti
PortalRunUtility
ProcessUtility
standard_ProcessUtility
ExecVacuum
vacuum
vac_update_datfrozenxid
systable_getnext
table_scan_getnextslot
heap_getnextslot
heapgettup_pagemode
|
--0.57%--heap_fetch_next_buffer
read_stream_next_buffer
read_stream_look_ahead
read_stream_start_pending_read
StartReadBuffers
StartReadBuffersImpl
PinBufferForBlock
BufferAlloc
0.79% 0.03% postgres [.] uint32_hash
|
--0.76%--uint32_hash
hash_bytes_uint32
0.79% 0.00% postgres [.] 0x00007ffe6151051f
|
---0x7ffe6151051f
0.77% 0.06% postgres [.] BufTableLookup
|
--0.72%--BufTableLookup
|
--0.71%--hash_search_with_hash_value
0.77% 0.50% postgres [.] hash_bytes_uint32
0.75% 0.17% postgres [.] pg_atomic_sub_fetch_u32_impl
|
--0.59%--pg_atomic_sub_fetch_u32_impl
|
--0.58%--pg_atomic_fetch_sub_u32_impl
0.75% 0.06% postgres [.] BufTableInsert
|
--0.69%--BufTableInsert
|
--0.67%--hash_search_with_hash_value
0.74% 0.00% postgres [.] 0xffffffffffffffff
|
---0xffffffffffffffff
0.73% 0.27% postgres [.] ResourceOwnerEnlarge
0.71% 0.00% postgres [.] 0x200000001fffffff
|
---0x200000001fffffff
0.62% 0.61% postgres [.] pg_atomic_fetch_sub_u32_impl
|
--0.56%--_start
__libc_start_main_impl (inlined)
__libc_start_call_main
main
PostmasterMain
ServerLoop
BackendStartup
postmaster_child_launch
BackendMain
PostgresMain
exec_simple_query
PortalRun
PortalRunMulti
PortalRunUtility
ProcessUtility
standard_ProcessUtility
ExecVacuum
vacuum
vac_update_datfrozenxid
systable_getnext
table_scan_getnextslot
heap_getnextslot
heapgettup_pagemode
0.52% 0.51% postgres [.] HandleConcurrentAbort
0.52% 0.13% postgres [.] hash_resource_elem
0.49% 0.05% postgres [.] ResourceOwnerForgetBufferIO
0.48% 0.00% postgres [.] 0x00007ffe615104ef
0.46% 0.04% postgres [.] StrategyGetBuffer
0.44% 0.12% postgres [.] PinBuffer_Locked
0.44% 0.15% postgres [.] ResourceOwnerAddToHash
0.42% 0.41% postgres [.] ResourceOwnerRemember
0.42% 0.15% postgres [.] GetBufferFromRing
0.39% 0.14% postgres [.] pg_atomic_read_u32
0.36% 0.09% postgres [.] ResourceOwnerRememberBuffer
0.36% 0.06% postgres [.] pg_atomic_compare_exchange_u32
0.35% 0.17% postgres [.] UnlockBufHdr
0.33% 0.00% postgres [.] 0x0000651af1babb57
0.32% 0.00% postgres [.] 0x00007ffe6151033f
0.32% 0.07% postgres [.] ConditionVariableBroadcast
0.32% 0.32% postgres [.] calc_bucket
0.32% 0.31% postgres [.] murmurhash64
0.31% 0.31% postgres [.] pg_atomic_compare_exchange_u32_impl
0.31% 0.03% postgres [.] CheckBufferIsPinnedOnce
0.29% 0.03% postgres [.] GetPrivateRefCount
0.29% 0.21% postgres [.] get_hash_entry
0.29% 0.16% postgres [.] heap_page_prune_opt
0.28% 0.27% postgres [.] BufferDescriptorGetBuffer
0.27% 0.27% postgres [.] pg_atomic_read_u32_impl
0.27% 0.27% postgres [.] init_spin_delay
0.25% 0.00% postgres [.] 0x20000001f1b6b64f
0.25% 0.25% postgres [.] tas
0.24% 0.24% postgres [.] tas
0.24% 0.19% postgres [.] pg_atomic_write_u32
0.21% 0.21% postgres [.] GetBufferDescriptor
0.21% 0.06% postgres [.] read_stream_get_block
0.19% 0.15% postgres [.] InitBufferTag
0.18% 0.00% postgres [.] 0x00007ffe615101df
0.18% 0.08% postgres [.] BufferGetBlockNumber
0.17% 0.07% postgres [.] pgstat_count_io_op
0.16% 0.16% postgres [.] finish_spin_delay
0.15% 0.07% postgres [.] heap_scan_stream_read_next_serial
0.15% 0.08% postgres [.] PageIsVerifiedExtended
0.15% 0.00% postgres [.] 0x0000000000000013
0.14% 0.07% postgres [.] ForgetPrivateRefCountEntry
0.13% 0.03% postgres [.] ResourceOwnerRememberBufferIO
0.12% 0.11% postgres [.] BufMappingPartitionLock
0.12% 0.10% postgres [.] pg_atomic_read_u32
0.12% 0.12% postgres [.] hash_combine64
0.12% 0.12% postgres [.] Int32GetDatum
0.12% 0.11% postgres [.] pgstat_count_io_op_n
0.11% 0.11% postgres [.] pg_atomic_write_u32_impl
0.11% 0.11% postgres [.] BufTagSetRelForkDetails
0.10% 0.00% postgres [.] 0x00000014615100df
0.09% 0.09% postgres [.] IOContextForStrategy
0.09% 0.06% postgres [.] BufferGetPage
0.08% 0.08% postgres [.] get_per_buffer_data
0.08% 0.07% postgres [.] buffers_to_iovec
0.08% 0.08% postgres [.] BufferGetBlock
0.07% 0.07% postgres [.] heapgettup_advance_block
0.07% 0.07% postgres [.] PageIsNew
0.07% 0.00% postgres [.] 0x00007ffe6151040f
0.06% 0.00% postgres [.] 0x20000000002e019f
0.06% 0.02% postgres [.] ClearBufferTag
0.06% 0.06% postgres [.] RecoveryInProgress
0.05% 0.05% postgres [.] BufferDescriptorGetIOCV
0.05% 0.05% postgres [.] SerializationNeededForRead
0.05% 0.05% postgres [.] NewPrivateRefCountEntry
0.05% 0.05% postgres [.] pg_atomic_read_u32_impl
0.05% 0.05% postgres [.] DataChecksumsEnabled
0.05% 0.00% postgres [.] SlotInvalidationCauses+0x1f
0.05% 0.02% postgres [.] CheckForSerializableConflictOutNeeded
0.04% 0.00% postgres [.] 0x00007ffe6151046f
0.04% 0.00% postgres [.] 0x00007f00615103cf
0.04% 0.00% postgres [.] 0x200000016151037f
0.04% 0.04% postgres [.] PageIsAllVisible
0.04% 0.04% postgres [.] BufferIsValid
0.04% 0.00% postgres [.] 0x00400000f1193cc8
0.03% 0.03% postgres [.] PageGetMaxOffsetNumber
0.03% 0.00% postgres [.] AllocSetFreeIndex
0.03% 0.03% postgres [.] BufferIsValid
0.03% 0.00% postgres [.] 0x00007ffe615103b2
0.03% 0.03% postgres [.] proclist_is_empty
0.03% 0.00% postgres [.] 0x86040000ffffffff
0.02% 0.00% postgres [.] 0x00000001f08baafc
0.02% 0.02% postgres [.] GetBufferDescriptor
0.02% 0.02% postgres [.] BufTableHashPartition
0.02% 0.00% postgres [.] 0x000001036151038f
0.02% 0.00% postgres [.] 0x0000010bf1babc3b
0.02% 0.00% postgres [.] 0x0000001e0000000e
0.02% 0.00% postgres [.] 0x0000002cffffffff
0.02% 0.00% postgres [.] 0x000000fa6151038f
0.02% 0.00% postgres [.] 0x000000146151022f
0.02% 0.00% postgres [.] 0x82440001f11940c7
0.02% 0.00% postgres [.] 0x00007ffe615103ff
0.02% 0.00% postgres [.] 0x00007ffe6151015f
0.02% 0.00% postgres [.] 0x0000000e0000001e
0.02% 0.02% postgres [.] FileAccess
0.02% 0.00% postgres [.] 0x0100000161510100
0.02% 0.00% postgres [.] 0x00007ffe6151022f
0.02% 0.00% postgres [.] 0x00000109f11940c7
0.02% 0.00% postgres [.] 0x0000000c00000020
0.02% 0.00% postgres [.] 0x0000000b00000021
0.02% 0.00% postgres [.] 0x0000010900000000
0.02% 0.02% postgres [.] pgstat_report_wait_end
0.02% 0.00% postgres [.] 0x00007ffe615101af
0.02% 0.00% postgres [.] 0x00000014f1b6c537
0.02% 0.00% postgres [.] 0x00007ffe6151016f
0.02% 0.00% postgres [.] 0x000000110000001b
0.02% 0.00% postgres [.] 0x000000010000002b
0.02% 0.00% postgres [.] 0x00007ffe6151013f
0.02% 0.00% postgres [.] 0x00000114f0d7624e
0.02% 0.00% postgres [.] 0x00007ffe61510192
0.02% 0.00% postgres [.] 0x000001046151038f
0.02% 0.00% postgres [.] 0x210000006151009f
0.02% 0.00% postgres [.] 0x20000001e697dfff
0.02% 0.01% postgres [.] pgstat_count_io_op_time
0.02% 0.00% postgres [.] 0x010000006151013f
0.02% 0.00% postgres [.] 0x00000102f1babc3b
0.02% 0.00% postgres [.] 0x20000001e699dfff
0.02% 0.00% postgres [.] 0x00000001615101af
0.02% 0.00% postgres [.] 0x00007ffe6151019e
0.02% 0.00% postgres [.] 0x000000f9f1babc3b
0.01% 0.00% postgres [.] 0x27b053e96151013f
0.01% 0.00% postgres [.] 0x0000000600000026
0.01% 0.00% postgres [.] 0x00007630e669157f
0.01% 0.00% postgres [.] 0x00000001f1b6c407
0.01% 0.00% postgres [.] 0x0005c450e6980007
0.01% 0.00% postgres [.] 0x0002f14f00000002
0.01% 0.00% postgres [.] 0x0004ebf0e6980001
0.01% 0.00% postgres [.] 0x00000001f1b6c287
0.01% 0.00% postgres [.] 0x000598dfe6990001
0.01% 0.00% postgres [.] 0x00007630e611c003
0.01% 0.00% postgres [.] 0x79f63c24f1bbfecf
0.01% 0.00% postgres [.] 0x00000014f1b6c3ff
0.01% 0.00% postgres [.] 0x83440001f0d7624e
0.01% 0.00% postgres [.] 0x0003c432e698002a
0.01% 0.00% postgres [.] 0x83040001000000fb
0.01% 0.00% postgres [.] 0x00000000000649b8
0.01% 0.00% postgres [.] 0x0002c701e69a0027
0.01% 0.00% postgres [.] 0x0000000000000113
0.01% 0.00% postgres [.] 0x82040000ffffffff
0.01% 0.00% postgres [.] 0x000000006151010f
0.01% 0.00% postgres [.] 0x00000014f1b6c287
0.01% 0.00% postgres [.] 0x0000001600000013
0.01% 0.00% postgres [.] 0x830400006151036f
0.01% 0.00% postgres [.] 0x00053d1900000002
0.01% 0.00% postgres [.] buffer_io_resowner_desc+0x1f
0.01% 0.00% postgres [.] 0x0004715be6990001
0.01% 0.00% postgres [.] 0x00000001e6691657
0.01% 0.00% postgres [.] 0x0100000000000013
0.01% 0.00% postgres [.] 0xf4eb2cec6151010f
0.01% 0.00% postgres [.] 0x0000010e83440000
0.01% 0.00% postgres [.] 0x0004c1a3e69a0001
0.01% 0.00% postgres [.] 0x00036bc6e69a0013
0.01% 0.00% postgres [.] 0x000000f800000000
0.01% 0.00% postgres [.] 0x000001056151016f
0.01% 0.00% postgres [.] 0x00000109f1babc3b
0.01% 0.01% postgres [.] pgstat_report_wait_start
0.01% 0.00% postgres [.] 0x0a0000116151029f
0.01% 0.00% postgres [.] 0x0000010df1babc3b
0.01% 0.00% postgres [.] 0x0000001a00000012
0.01% 0.01% postgres [.] BufferIsValid
0.01% 0.00% postgres [.] 0x00000107f0d7624e
0.01% 0.00% postgres [.] 0x000000faf0d7624e
0.01% 0.00% postgres [.] 0x01000000ee826e9f
0.01% 0.00% postgres [.] 0x00000014f1b6c4d7
0.01% 0.00% postgres [.] 0x000001116151016f
0.01% 0.00% postgres [.] 0x0000002500000007
0.01% 0.00% postgres [.] 0x0000001300000019
0.01% 0.00% postgres [.] 0x0005d16a00000002
0.01% 0.00% postgres [.] 0x0000000900000023
0.01% 0.00% postgres [.] 0x00000000e66918bf
0.01% 0.00% postgres [.] 0x00007ffe615103cf
0.01% 0.00% postgres [.] 0x0000000400000028
0.01% 0.00% postgres [.] 0x00037824e69a0026
0.01% 0.00% postgres [.] 0xc9bc65fd615101af
0.01% 0.00% postgres [.] 0x0000001b00000011
0.01% 0.00% postgres [.] 0x0005fe7be699000d
0.01% 0.00% postgres [.] 0x00059ed1615103ff
0.01% 0.00% postgres [.] 0x000000fcf1bac0ef
0.01% 0.00% postgres [.] 0x00065566e69a0012
0.01% 0.00% postgres [.] 0x0003a9fb00000002
0.01% 0.00% postgres [.] 0x0006c22ae69b0013
0.01% 0.00% postgres [.] 0x0000000800000024
0.01% 0.00% postgres [.] 0x86440001f11940c7
0.01% 0.00% postgres [.] 0x00007630e66918d7
0.01% 0.00% postgres [.] 0x0000010fe69ac10f
0.01% 0.00% postgres [.] 0x00035b3be6990010
0.01% 0.00% postgres [.] 0x00007ffe61510187
0.01% 0.00% postgres [.] 0x01000000615101af
0.01% 0.00% postgres [.] 0x000610dae6990003
0.01% 0.00% postgres [.] 0x0000010cf0d7624e
0.01% 0.00% postgres [.] 0x00000110f0d7624e
0.01% 0.00% postgres [.] 0x0000000000000003
0.01% 0.00% postgres [.] 0x0005b5b900000002
0.01% 0.00% postgres [.] 0x000000fc6151016f
0.01% 0.00% postgres [.] 0x000000fcf1babc3b
0.01% 0.00% postgres [.] 0xb03852016151010f
0.01% 0.00% postgres [.] StartReadBuffer
0.01% 0.00% postgres [.] 0x0006334de6970003
0.01% 0.00% postgres [.] 0x00000001f1babb57
0.01% 0.00% postgres [.] 0x00007630e6691397
0.01% 0.00% postgres [.] 0x83040001000000fa
0.01% 0.00% postgres [.] 0x0000002600000006
0.01% 0.00% postgres [.] 0x0000010cf0b3f2cc
0.01% 0.00% postgres [.] 0x00000111f1b6cdaf
0.01% 0.00% postgres [.] 0x000000016151016f
0.01% 0.00% postgres [.] 0x71f7df1f6151013f
0.01% 0.00% postgres [.] 0x00007ffe615103bf
0.01% 0.00% postgres [.] 0x000000000002e8d7
0.01% 0.00% postgres [.] 0x00007630e66912d7
0.01% 0.00% postgres [.] 0x00000105f0d7624e
0.01% 0.00% postgres [.] 0x200000016151031f
0.01% 0.00% postgres [.] 0x00000112ee8874bf
0.01% 0.00% postgres [.] 0x00000000ffffffff
0.01% 0.00% postgres [.] 0x000245a5e69a0012
0.01% 0.00% postgres [.] 0x000000fe6151016f
0.01% 0.01% postgres [.] BufferGetBlock
0.01% 0.00% postgres [.] 0x0003f870e698001a
0.01% 0.00% postgres [.] 0x0000000a00000022
0.01% 0.00% postgres [.] 0x0000002400000008
0.01% 0.00% postgres [.] 0x0000010ce69a610f
0.01% 0.00% postgres [.] 0x00000014f1b6c387
0.01% 0.00% postgres [.] 0x00007630e66911a7
0.01% 0.00% postgres [.] 0x000000fbf0fc188a
0.01% 0.00% postgres [.] 0x83440001f11940c7
0.01% 0.00% postgres [.] 0x000000fff1babc3b
0.01% 0.00% postgres [.] 0x000536b2e6980010
0.01% 0.00% postgres [.] 0x000000fcf0d7624e
0.01% 0.00% postgres [.] 0x000001016151040f
0.01% 0.00% postgres [.] 0x0000010bf1bac0ef
0.01% 0.00% postgres [.] 0x000000fb6151016f
0.01% 0.00% postgres [.] 0x01000000ee8319ff
0.01% 0.00% postgres [.] 0x0004e16be69b000f
0.01% 0.00% postgres [.] 0x00007ffe615102fa
0.01% 0.00% postgres [.] 0x0000010a00000000
0.01% 0.00% postgres [.] 0x00000108f13974d7
0.01% 0.00% postgres [.] 0x00007ffe615103af
0.01% 0.00% postgres [.] 0x00000112ee8a59f7
0.01% 0.00% postgres [.] 0x00030616e6980002
0.01% 0.00% postgres [.] 0x0000000100000013
0.01% 0.00% postgres [.] 0x00000001ee834047
0.01% 0.00% postgres [.] 0x0002d9dbe6990009
0.01% 0.00% postgres [.] 0x00000014f1b6c4cf
0.01% 0.00% postgres [.] 0x00000100f11940c7
0.01% 0.00% postgres [.] 0x000000f7f139749f
0.01% 0.00% postgres [.] 0x00000113f1babc3b
0.01% 0.00% postgres [.] 0x00000109f0d7624e
0.01% 0.00% postgres [.] 0x8304000100000103
0.01% 0.00% postgres [.] 0x0003838fe6970001
0.01% 0.00% postgres [.] 0x00036879e699002b
0.01% 0.00% postgres [.] 0x00000106f1babc3b
0.01% 0.00% postgres [.] 0x000367fae6990007
0.01% 0.00% postgres [.] 0x83040000ffffffff
0.01% 0.00% postgres [.] 0x0000010c6151040f
0.01% 0.00% postgres [.] 0x0000651af1bbfecf
0.01% 0.00% postgres [.] 0x00000001ee83a0df
0.01% 0.00% postgres [.] 0x0004d26c00000002
0.01% 0.00% postgres [.] 0x0000000700000025
0.01% 0.00% postgres [.] 0x0004a8a1e69a0000
0.01% 0.00% postgres [.] 0x0004f655e6980000
0.01% 0.00% postgres [.] 0x0003e182e69a000e
0.01% 0.00% postgres [.] 0x000284e400000002
0.01% 0.00% postgres [.] 0x0003fabbe6990004
0.01% 0.00% postgres [.] 0x00069033e6980018
0.01% 0.00% postgres [.] 0x200000016151013f
0.01% 0.00% postgres [.] 0x0003455de6990022
0.01% 0.00% postgres [.] 0x000582bae6990003
0.01% 0.00% postgres [.] 0x00052cdce6990001
0.01% 0.00% postgres [.] 0x00007630e611f183
0.01% 0.00% postgres [.] 0x0000010cf1bac0ef
0.01% 0.00% postgres [.] 0x00007630e611c703
0.01% 0.00% postgres [.] 0x0002e5af00000002
0.01% 0.00% postgres [.] 0x00043ba1e69a0017
0.01% 0.00% postgres [.] 0x0002e3fce6990002
0.01% 0.00% postgres [.] 0x0000001400000111
0.01% 0.00% postgres [.] 0x00000111f1b6ce27
0.01% 0.00% postgres [.] 0x00000112ee8dd6d7
0.01% 0.00% postgres [.] 0x00000115f1babc3b
0.01% 0.00% postgres [.] 0x0000000300000029
0.01% 0.00% postgres [.] 0x00000001f1b6c29f
0.01% 0.00% postgres [.] 0x00000000e669187f
0.01% 0.00% postgres [.] 0x000485a3e69a002b
0.01% 0.00% postgres [.] 0x000482d6615103ff
0.01% 0.00% postgres [.] 0x00000115f11940c7
#
# (Cannot load tips.txt file, please install perf!)
#