perf_diff.out
application/octet-stream
Filename: perf_diff.out
Type: application/octet-stream
Part: 0
Message:
brininsert optimization opportunity
# Event 'cycles'
#
# Baseline Delta Abs Symbol
# ........ ......... .......................................
#
2.97% -1.12% [.] hash_bytes
2.90% +0.89% [.] GetPrivateRefCountEntry
3.15% -0.72% [.] pg_atomic_compare_exchange_u32_impl
1.96% +0.55% [.] pg_comp_crc32c_sse42
1.96% -0.55% [.] hash_search_with_hash_value
1.05% -0.51% [.] palloc
1.58% +0.48% [.] XLogRecordAssemble
1.05% -0.40% [.] UnpinBuffer
1.30% +0.38% [.] XLogBytePosToRecPtr
0.91% -0.36% [.] PinBuffer
1.00% -0.36% [.] pg_rotate_left32
1.24% -0.35% [.] LWLockAttemptLock
1.37% -0.31% [.] pg_atomic_fetch_sub_u32_impl
1.44% -0.31% [.] LWLockRelease
1.19% +0.29% [.] heap_insert
0.94% +0.29% [.] XLogRegisterBufData
0.88% +0.28% [.] BlockIdSet
0.59% -0.28% [.] get_hash_value
0.71% +0.27% [.] brininsert
1.01% +0.27% [.] heap_prepare_insert
0.68% -0.26% [.] ResourceArrayRemove
0.34% -0.26% [.] tag_hash
0.93% +0.26% [.] CopyXLogRecordToWAL
0.61% +0.25% [.] tts_minimal_store_tuple
0.58% -0.25% [.] BufferDescriptorGetBuffer
0.70% -0.24% [.] LockBuffer
0.58% +0.24% [.] tts_minimal_clear
0.51% -0.24% [.] InitBufferTag
0.70% -0.23% [.] ReadBuffer_common
0.58% +0.23% [.] XLogBytePosToEndRecPtr
1.13% +0.22% [.] XLogRecPtrToBytePos
0.48% +0.22% [.] XLogRegisterData
0.57% +0.21% [.] BufFileReadCommon
0.33% -0.21% [.] calc_bucket
0.59% -0.21% [.] BufferAlloc
0.35% -0.20% [.] getlen
0.79% +0.19% [.] ItemPointerSetInvalid
0.83% +0.19% [.] PageAddItemExtended
0.44% +0.19% [.] XLogRegisterBuffer
0.71% -0.18% [.] ReadBufferExtended
1.59% -0.18% [.] AllocSetFree
0.84% +0.18% [.] XLogInsertRecord
0.71% -0.17% [.] pg_atomic_read_u32
0.44% -0.17% [.] ResourceArrayAdd
0.78% -0.17% [.] pg_atomic_compare_exchange_u32
0.31% +0.17% [.] XLogInsert
0.65% +0.17% [.] RelationGetBufferForTuple
0.43% -0.17% [.] BufFileFlush
2.63% -0.17% [.] BufferIsValid
0.36% +0.17% [.] brinGetTupleForHeapBlock
0.99% -0.16% [.] LWLockAcquire
0.51% +0.16% [.] ExecModifyTable
0.53% +0.16% [.] slot_deform_heap_tuple
0.44% -0.15% [.] tuplestore_gettuple
0.09% +0.15% [.] list_member_oid
1.11% +0.15% [.] ExecInsertIndexTuples
1.02% +0.14% [.] heap_form_tuple
0.21% +0.14% [.] heapam_tuple_insert
0.45% +0.13% [.] tts_buffer_heap_copyslot
0.63% +0.13% [.] RelationPutHeapTuple
0.26% -0.12% [.] ExecFunctionScan
0.15% +0.12% [.] XLogInsertAllowed
0.29% +0.11% [.] readtup_heap
0.66% -0.11% [.] pg_atomic_read_u32_impl
0.34% +0.11% [.] PageIsAllVisible
0.37% -0.11% [.] pgstat_count_io_op_n
0.26% -0.11% [.] BufTagSetRelForkDetails
0.37% +0.11% [.] FormIndexDatum
0.35% -0.11% [.] GetBufferDescriptor
0.12% +0.10% [.] table_tuple_insert
0.93% +0.10% [.] GetMemoryChunkMethodID
0.74% +0.10% [.] heap_fill_tuple
0.33% +0.10% [.] ReserveXLogInsertLocation
0.27% +0.10% [.] GetVisibilityMapPins
0.10% +0.10% [.] IsCatalogRelation
0.82% -0.10% [.] MemoryChunkGetValue
0.29% -0.10% [.] pgstat_tracks_io_object
0.34% -0.09% [.] pgstat_tracks_io_op
0.28% +0.09% [.] tas
0.54% +0.09% [.] tts_buffer_heap_clear
0.37% -0.09% [.] slot_getsomeattrs_int
0.12% +0.08% [.] tts_virtual_clear
0.69% -0.08% [.] pfree
0.32% +0.08% [.] pg_atomic_fetch_or_u32_impl
0.31% +0.08% [.] BufferGetPage
0.20% -0.08% [.] ResourceOwnerForgetBuffer
0.34% -0.08% [.] pg_atomic_sub_fetch_u32
0.56% +0.08% [.] palloc0
0.24% +0.08% [.] sentinel_ok
0.11% +0.07% [.] ItemPointerCopy
0.27% +0.07% [.] slot_getattr
0.19% -0.07% [.] pgstat_tracks_io_bktype
0.18% +0.07% [.] ItemPointerSet
0.17% -0.07% [.] ReleaseBuffer
0.20% -0.07% [.] ResourceOwnerRememberBuffer
0.28% +0.07% [.] BufTagGetRelFileLocator
0.25% +0.07% [.] pg_atomic_fetch_and_u32_impl
0.19% +0.07% [.] FunctionNext
0.15% -0.06% [.] NewPrivateRefCountEntry
0.30% -0.06% [.] writetup_heap
0.22% -0.06% [.] BufMappingPartitionLock
0.15% -0.06% [.] BufTableLookup
1.51% -0.06% [.] AllocSetAlloc
0.59% +0.06% [.] heap_compute_data_size
0.35% +0.06% [.] ExecProject
0.14% +0.05% [.] XLogResetInsertion
0.13% +0.05% [.] ExecFetchSlotHeapTuple
0.39% -0.05% [.] MemoryChunkIsExternal
0.14% +0.05% [.] PageSetLSN
0.08% +0.05% [.] WALInsertLockRelease
0.15% -0.05% [.] ForgetPrivateRefCountEntry
0.15% -0.05% [.] BufTableHashCode
0.36% +0.05% [.] BufferGetBlockNumber
0.15% +0.05% [.] PageGetItem
0.49% -0.05% [.] generate_series_step_int4
0.27% +0.05% [.] index_insert
0.19% +0.05% [.] ExecStoreMinimalTuple
0.21% +0.05% [.] tuplestore_gettupleslot
0.18% +0.05% [.] ExecCopySlotHeapTuple
0.18% -0.05% [.] Int32GetDatum
0.14% +0.04% [.] ExecGetInsertNewTuple
0.11% -0.04% [.] castNodeImpl
0.17% -0.04% [.] ResourceArrayEnlarge
0.03% +0.04% [.] PageXLogRecPtrGet
0.22% -0.04% [.] MemoryChunkGetBlock
0.08% +0.04% [.] ExecCopySlot
0.16% +0.04% [.] ExecEvalExprSwitchContext
0.16% -0.04% [.] fetch_att
0.22% -0.04% [.] pg_atomic_sub_fetch_u32_impl
0.14% +0.04% [.] BlockIdGetBlockNumber
0.09% +0.04% [.] WALInsertLockAcquire
0.20% +0.04% [.] BufferGetTag
0.71% -0.04% [.] GetPrivateRefCount
0.47% +0.04% [.] ExecScan
0.14% +0.04% [.] heap_free_minimal_tuple
0.13% +0.04% [.] PageIsNew
0.13% +0.04% [.] PageGetMaxOffsetNumber
0.09% -0.04% [.] ReservePrivateRefCountEntry
0.33% -0.03% [.] AllocSetFreeIndex
0.12% +0.03% [.] ItemPointerGetBlockNumber
0.42% -0.03% [.] heap_form_minimal_tuple
0.10% +0.03% [.] GetXLogBuffer
0.66% -0.03% [.] MemoryContextReset
0.16% +0.03% [.] CheckForSerializableConflictIn
0.08% +0.03% [.] IsCatalogRelationOid
1.17% -0.03% [.] ExecInsert
0.17% -0.03% [.] RelationGetSmgr
0.11% -0.03% [.] ResourceOwnerEnlargeBuffers
0.12% +0.03% [.] tts_buffer_heap_materialize
0.09% +0.03% [.] ExecProcNode
0.15% +0.03% [.] XLogBeginInsert
0.07% +0.03% [.] pg_atomic_fetch_and_u32
0.13% +0.03% [.] ExecScanFetch
0.12% +0.03% [.] PageGetHeapFreeSpace
0.45% -0.03% [.] ExecClearTuple
0.03% +0.03% [.] check_list_invariants
0.10% +0.03% [.] tts_virtual_copy_heap_tuple
0.08% +0.03% [.] heap_freetuple
0.07% -0.02% [.] IOContextForStrategy
0.12% +0.02% [.] PageGetItemId
0.20% -0.02% [.] pg_leftmost_one_pos32
0.10% -0.02% [.] BufTableHashPartition
0.24% -0.02% [.] BufferDescriptorGetContentLock
0.14% +0.02% [.] PageGetFreeSpace
0.09% +0.02% [.] LWLockReleaseClearVar
0.12% +0.02% [.] ItemPointerGetOffsetNumber
0.32% -0.02% [.] ExecMakeTableFunctionResult
0.63% +0.02% [.] BufferGetBlock
0.03% +0.02% [.] PageHasFreeLinePointers
0.02% -0.02% [.] PageGetContents
0.42% -0.02% [.] GetMemoryChunkSpace
0.05% +0.02% [.] PageGetLSN
0.24% -0.02% [.] store_att_byval
0.19% -0.02% [.] wipe_mem
0.08% +0.02% [.] CacheInvalidateHeapTuple
0.07% +0.02% [.] LWLockWaitListUnlock
0.07% -0.02% [.] list_head
0.11% +0.02% [.] ReadBufferBI
0.54% -0.02% [.] BufFileWrite
0.08% +0.02% [.] pg_atomic_fetch_or_u32
0.32% -0.02% [.] tuplestore_puttuple_common
0.06% +0.02% [.] list_free
0.06% -0.02% [.] LWLockHeldByMe
0.18% +0.02% [.] 0x00000000000ce280
0.09% +0.02% [.] LWLockWaitListLock
0.07% +0.02% [.] UnlockReleaseBuffer
0.02% +0.02% [.] BufTagGetForkNum
0.04% +0.01% [.] XLogSetRecordFlags
0.06% +0.01% [.] ReindexIsProcessingIndex
0.06% +0.01% [.] ItemPointerGetBlockNumberNoCheck
0.06% +0.01% [.] tts_buffer_heap_get_heap_tuple
0.06% +0.01% [.] BufFileReadExact
0.31% +0.01% [.] AllocSetGetChunkSpace
0.03% +0.01% [.] GetCurrentTransactionNestLevel
0.31% -0.01% [.] tuplestore_putvalues
0.20% -0.01% [.] set_sentinel
0.09% +0.01% [.] GetCurrentTransactionId
0.04% +0.01% [.] ExecMaterializeSlot
0.06% +0.01% [.] slot_getsomeattrs
0.07% +0.01% [.] SerializationNeededForWrite
0.03% +0.01% [.] GetFullPageWriteInfo
0.09% -0.01% [.] pgstat_init_function_usage
0.02% +0.01% [.] BufTagGetRelNumber
0.57% +0.01% [.] MarkBufferDirty
0.01% +0.01% [.] AdvanceXLInsertBuffer
0.11% -0.01% [.] pgstat_end_function_usage
0.04% -0.01% [.] DatumGetInt32
0.09% +0.01% [.] ExecARInsertTriggers
0.03% +0.01% [.] list_free_private
0.04% +0.01% [.] ItemPointerGetOffsetNumberNoCheck
0.22% +0.01% [.] pgstat_count_io_op
0.12% -0.01% [.] BufFileReadMaybeEOF
0.02% +0.01% [.] XLogWrite
0.11% +0.01% [.] LWLockHeldByMeInMode
0.52% -0.01% [.] ItemPointerIsValid
0.00% +0.01% [.] GetVictimBuffer
0.39% -0.01% [.] MemoryContextSwitchTo
0.02% +0.01% [.] GetCurrentTransactionIdIfAny
0.01% +0.01% [.] LockRelease
0.01% +0.01% [.] LWLockConflictsWithVar
0.71% -0.00% [.] fill_val
0.01% +0.00% [.] SetupLockInTable
0.04% +0.00% [.] MarkCurrentTransactionIdLoggedIfAny
0.00% +0.00% [.] FileSize
0.00% +0.00% [.] ConditionVariableBroadcast
0.01% -0.00% [.] RelationAddBlocks
0.00% +0.00% [.] fsm_logical_to_physical
0.04% -0.00% [.] generate_series_int4
0.01% +0.00% [.] pg_pwrite_zeros
0.01% +0.00% [.] pg_atomic_fetch_add_u32_impl
0.14% +0.00% [.] tts_buffer_heap_getsomeattrs
0.00% +0.00% [.] pgstat_report_wait_end
0.00% +0.00% [.] ExtendBufferedRelBy
0.24% -0.00% [.] ensure_tabstat_xact_level
0.00% +0.00% [.] _mdfd_getseg
0.00% +0.00% [.] pgstat_report_wait_start
0.01% +0.00% [.] WaitXLogInsertionsToFinish
0.00% +0.00% [.] mdzeroextend
0.00% +0.00% [.] register_dirty_segment
0.05% +0.00% [.] IsSubxactTopXidLogPending
0.00% +0.00% [.] ProcLockHashCode
0.00% +0.00% [.] fsm_set_and_search
0.02% +0.00% [.] LockAcquireExtended
0.02% +0.00% [.] ExtendBufferedRelShared
0.01% -0.00% [.] fsm_search_avail
0.00% +0.00% [.] dlist_push_tail
0.00% +0.00% [.] smgrwrite
0.00% +0.00% [.] CleanUpLock
0.00% +0.00% [.] BufFileLoadBuffer
0.00% +0.00% [.] proclist_node_get
0.01% -0.00% [.] pg_pwritev_with_retry
0.00% +0.00% [.] Delete
0.00% +0.00% [.] PageInit
0.00% +0.00% [.] LockWaiterCount
0.64% -0.00% [.] revmap_get_blkno
0.00% +0.00% [.] fsm_set_avail
0.05% +0.00% [.] per_MultiFuncCall
0.01% +0.00% [.] LockBufHdr
0.00% -0.00% [.] mdnblocks
0.00% +0.00% [.] GrantLockLocal
0.00% +0.00% [.] ExtendBufferedRelCommon
0.00% +0.00% [.] dlist_init
0.00% -0.00% [.] smgropen
0.01% +0.00% [.] LWLockWaitForVar
0.00% +0.00% [.] RelationExtensionLockWaiterCount
0.00% +0.00% [.] _mdnblocks
0.01% -0.00% [.] hash_search
0.00% +0.00% [.] pg_atomic_fetch_add_u32
0.20% +0.00% [.] pgstat_count_heap_insert
0.00% +0.00% [.] finish_spin_delay
0.00% +0.00% [.] LockRelationForExtension
0.01% -0.00% [.] StrategyGetBuffer
0.00% +0.00% [.] InvalidateVictimBuffer
0.00% +0.00% [.] StartBufferIO
0.00% +0.00% [.] PinBuffer_Locked
0.00% +0.00% [.] IssuePendingWritebacks
0.00% +0.00% [.] LimitAdditionalPins
0.00% +0.00% [.] FlushBuffer
0.01% -0.00% [.] ClockSweepTick
0.00% +0.00% [.] fsm_get_max_avail
0.00% -0.00% [.] LWLockUpdateVar
0.00% -0.00% [.] mdopenfork
0.00% +0.00% [.] UnGrantLock
0.00% -0.00% [.] proclist_init
0.00% +0.00% [.] mdwrite
0.00% +0.00% [.] fsm_get_location
0.00% +0.00% [.] smgrnblocks
0.01% +0.00% [.] FileZero
0.00% +0.00% [.] WALInsertLockUpdateInsertingAt
0.01% +0.00% [.] init_spin_delay
0.00% +0.00% [.] BufFileDumpBuffer
0.01% -0.00% [.] UnlockBufHdr
0.00% +0.00% [.] BufferTagsEqual
0.00% +0.00% [.] ResourceOwnerForgetBufferIO
0.01% +0.00% [.] FileWrite
0.00% -0.00% [.] CheckBufferIsPinnedOnce
0.01% +0.00% [.] FileAccess
0.00% -0.00% [.] RecordAndGetPageWithFreeSpace
0.00% +0.00% [.] pgstat_count_io_op_time
0.00% +0.00% [.] proclist_is_empty
0.00% -0.00% [.] LockCheckConflicts
0.00% +0.00% [.] fsm_space_avail_to_cat
0.00% +0.00% [.] CheckAndSetLockHeld
0.00% +0.00% [.] PageSetPageSizeAndVersion
0.00% +0.00% [.] ResourceOwnerRememberBufferIO
0.00% +0.00% [.] pgstat_prepare_io_time
0.00% -0.00% [.] dclist_init
+0.00% [.] dlist_is_empty
0.00% +0.00% [.] DataChecksumsEnabled
0.00% +0.00% [.] BufTableDelete
0.00% -0.00% [.] RemoveLocalLock
0.00% -0.00% [.] LockTagHashCode
0.00% -0.00% [.] dlist_delete
+0.00% [.] FinishStrongLockAcquire
0.00% +0.00% [.] smgrnblocks_cached
0.00% +0.00% [.] pg_atomic_write_u32_impl
0.00% +0.00% [.] fsm_space_needed_to_cat
+0.00% [.] CloseTransientFile
+0.00% [.] AllocSetCheck
0.00% -0.00% [.] BufferDescriptorGetIOCV
+0.00% [.] fmtint
+0.00% [.] XLogFlush
0.01% +0.00% [.] MemoryContextAlloc
0.00% +0.00% [.] FileRead
0.00% -0.00% [.] ResourceOwnerEnlargeBufferIOs
0.00% +0.00% [.] UnlockRelationForExtension
0.01% +0.00% [.] pg_atomic_write_u32
0.00% +0.00% [.] ResourceOwnerRememberLock
0.00% +0.00% [.] proclist_contains_offset
0.00% +0.00% [.] smgrzeroextend
0.00% -0.00% [.] ScheduleBufferTagForWriteback
0.00% +0.00% [.] TerminateBufferIO
+0.00% [.] proclist_push_tail_offset
+0.00% [.] XLogFileInitInternal
+0.00% [.] ExtendBufferedRelTo
0.00% +0.00% [.] RecoveryInProgress
+0.00% [.] mdexists
0.00% +0.00% [.] fsm_readbuf
0.00% +0.00% [.] BufTableInsert
0.00% -0.00% [.] LWLockConditionalAcquire
0.00% +0.00% [.] PageSetChecksumCopy
+0.00% [.] GetCurrentSubTransactionId
0.00% +0.00% [.] ClearBufferTag
0.06% -0.00% [.] pg_add_s32_overflow
0.01% -0.00% [.] get_hash_entry
0.00% -0.00% [.] Insert
0.00% +0.00% [.] ResourceOwnerForgetLock
0.00% -0.00% [.] RegisterSyncRequest
0.01% -0.00% [.] ForwardSyncRequest
0.00% +0.00% [.] fsm_search
0.00% -0.00% [.] GrantLock
0.00% +0.00% [.] LockAcquire
0.00% +0.00% [.] PointerGetDatum
0.00% +0.00% [.] PGSemaphoreLock
0.00% +0.00% [.] dopr
0.87% [.] brinRevmapInitialize
0.17% [.] brinRevmapTerminate
0.09% [.] ReadBuffer
0.05% [.] TestForOldSnapshot
0.00% [.] BufferGetPageSize
0.00% [.] MemoryContextCreate
0.00% [.] FunctionCall4Coll