perf_diff_v2.out

application/octet-stream

Filename: perf_diff_v2.out
Type: application/octet-stream
Part: 1
Message: Re: brininsert optimization opportunity
# Event 'cycles'
#
# Baseline  Delta Abs  Symbol                                 
# ........  .........  .......................................
#
     2.88%     -2.76%  [.] hash_bytes
     2.49%     -2.39%  [.] pg_atomic_compare_exchange_u32_impl
     2.69%     +2.27%  [.] NextCopyFrom
     2.73%     +1.62%  [.] pg_strtoint32_safe
     2.20%     -1.52%  [.] GetPrivateRefCountEntry
     2.34%     +1.36%  [.] CopyReadLineText
     1.55%     -1.29%  [.] hash_search_with_hash_value
     2.61%     +1.25%  [.] AllocSetReset
     1.10%     -1.08%  [.] ReadBufferExtended
     2.35%     +1.08%  [.] CopyReadAttributesText
     1.12%     -1.08%  [.] LWLockAttemptLock
     1.08%     -1.04%  [.] pg_atomic_fetch_sub_u32_impl
     1.34%     +1.02%  [.] brininsert
     1.02%     -0.98%  [.] pg_rotate_left32
     0.96%     -0.92%  [.] UnpinBuffer
     0.94%     -0.89%  [.] LWLockRelease
     1.39%     +0.89%  [.] CopyFrom
     1.78%     +0.88%  [.] heap_multi_insert
     0.84%     -0.83%  [.] PinBuffer
     0.82%     -0.82%  [.] palloc
     0.75%     -0.74%  [.] ReadBuffer_common
     0.73%     -0.70%  [.] LWLockAcquire
     0.72%     -0.69%  [.] pg_atomic_compare_exchange_u32
     1.34%     +0.67%  [.] slot_deform_heap_tuple
     1.91%     -0.67%  [.] BufferIsValid
     1.28%     +0.65%  [.] PageAddItemExtended
     0.70%     -0.65%  [.] ResourceArrayRemove
     0.64%     -0.62%  [.] LockBuffer
     1.13%     +0.59%  [.] heap_form_tuple
     0.93%     +0.57%  [.] AllocSetCheck
     0.82%     +0.55%  [.] CopyMultiInsertInfoNextFreeSlot
     0.82%     +0.51%  [.] vector8_broadcast
     0.53%     -0.51%  [.] pg_atomic_read_u32
     0.52%     -0.51%  [.] BufferAlloc
     0.47%     -0.45%  [.] InitBufferTag
     0.50%     -0.45%  [.] pg_atomic_read_u32_impl
     0.79%     +0.43%  [.] revmap_get_blkno
     0.81%     +0.42%  [.] heap_prepare_insert
     0.78%     +0.40%  [.] RelationPutHeapTuple
     0.77%     +0.38%  [.] brinGetTupleForHeapBlock
     1.05%     +0.37%  [.] tts_buffer_heap_clear
     0.39%     -0.37%  [.] pgstat_count_io_op_n
     0.86%     +0.36%  [.] BlockIdSet
     0.60%     +0.36%  [.] heap_fill_tuple
     0.99%     +0.34%  [.] palloc0
     0.35%     -0.34%  [.] get_hash_value
     0.35%     -0.33%  [.] ResourceArrayAdd
     0.64%     +0.32%  [.] index_insert
     0.63%     +0.32%  [.] CopyReadLine
     0.33%     -0.32%  [.] pgstat_tracks_io_op
     0.67%     +0.30%  [.] InputFunctionCall
     0.31%     -0.29%  [.] pgstat_tracks_io_object
     0.47%     +0.29%  [.] resetStringInfo
     0.61%     +0.29%  [.] tts_buffer_heap_materialize
     0.30%     -0.29%  [.] pg_atomic_sub_fetch_u32
     0.56%     +0.28%  [.] heap_compute_data_size
     0.57%     +0.28%  [.] fill_val
     0.53%     +0.28%  [.] ExecFetchSlotHeapTuple
     2.17%     +0.28%  [.] AllocSetAlloc
     0.53%     +0.27%  [.] MemoryChunkIsExternal
     0.71%     +0.26%  [.] ItemPointerSetInvalid
     0.55%     +0.26%  [.] NextCopyFromRawFields
     0.49%     +0.26%  [.] heap_multi_insert_pages
     0.30%     -0.26%  [.] BufferDescriptorGetBuffer
     1.43%     +0.25%  [.] ExecInsertIndexTuples
     0.50%     -0.24%  [.] GetPrivateRefCount
     0.47%     +0.24%  [.] appendBinaryStringInfo
     0.42%     +0.24%  [.] ExecStoreVirtualTuple
     0.24%     -0.23%  [.] BufMappingPartitionLock
     0.24%     -0.23%  [.] BufTagSetRelForkDetails
     0.24%     +0.23%  [.] MemoryContextReset
     0.40%     +0.22%  [.] 0x00000000000ce280
     0.23%     +0.22%  [.] list_length
     0.19%     -0.18%  [.] BufferDescriptorGetContentLock
     0.19%     -0.18%  [.] pg_atomic_sub_fetch_u32_impl
     0.19%     -0.18%  [.] calc_bucket
     0.38%     +0.18%  [.] pg_comp_crc32c_sse42
     0.18%     -0.18%  [.] pgstat_tracks_io_bktype
     0.18%     -0.18%  [.] pgstat_count_io_op
     0.28%     +0.18%  [.] BufferGetBlockNumber
     0.24%     -0.17%  [.] GetBufferDescriptor
     0.17%     -0.16%  [.] ResourceOwnerForgetBuffer
     0.23%     +0.16%  [.] PageGetMaxOffsetNumber
     0.34%     +0.16%  [.] slot_getsomeattrs_int
     0.30%     +0.16%  [.] store_att_byval
     0.16%     -0.16%  [.] BufTableLookup
     0.28%     +0.15%  [.] vector8_or
     0.16%     -0.15%  [.] ForgetPrivateRefCountEntry
     0.16%     -0.15%  [.] ReleaseBuffer
     0.26%     +0.15%  [.] MemoryChunkSetHdrMask
     0.16%     -0.15%  [.] ResourceOwnerRememberBuffer
     0.30%     +0.15%  [.] PageGetItem
     0.19%     +0.14%  [.] list_member_oid
     0.15%     -0.14%  [.] NewPrivateRefCountEntry
     1.00%     +0.14%  [.] MemoryChunkGetValue
     0.71%     +0.13%  [.] GetMemoryChunkMethodID
     0.24%     +0.13%  [.] MemoryContextResetOnly
     0.12%     +0.13%  [.] MemoryContextCallResetCallbacks
     2.03%     +0.13%  [.] AllocSetFree
     0.14%     -0.12%  [.] ResourceArrayEnlarge
     0.13%     -0.12%  [.] tag_hash
     0.52%     +0.12%  [.] slot_getattr
     1.14%     +0.12%  [.] CopyMultiInsertInfoStore
     0.22%     +0.12%  [.] int4in
     0.87%     +0.11%  [.] CopyMultiInsertBufferFlush
     0.17%     +0.11%  [.] tts_buffer_heap_getsomeattrs
     0.22%     +0.10%  [.] PageGetItemId
     0.11%     -0.10%  [.] ResourceOwnerEnlargeBuffers
     0.10%     -0.10%  [.] BufTableHashCode
     0.37%     +0.10%  [.] MemoryContextSwitchTo
     0.47%     +0.09%  [.] MemoryChunkGetBlock
     0.09%     -0.09%  [.] BufTableHashPartition
     0.19%     +0.09%  [.] PageGetHeapFreeSpace
     0.16%     +0.09%  [.] is_valid_ascii
     0.30%     -0.09%  [.] BufferGetBlock
     0.20%     +0.09%  [.] fetch_att
     0.10%     -0.09%  [.] RelationGetSmgr
     0.09%     -0.08%  [.] ReservePrivateRefCountEntry
     0.15%     +0.07%  [.] PageGetFreeSpace
     0.12%     +0.07%  [.] ReindexIsProcessingIndex
     0.08%     -0.07%  [.] IOContextForStrategy
     0.26%     +0.07%  [.] enlargeStringInfo
     0.14%     +0.06%  [.] vector8_eq
     0.27%     -0.06%  [.] ExecARInsertTriggers
     0.11%     +0.06%  [.] ItemPointerGetBlockNumber
     0.13%     +0.06%  [.] slot_getsomeattrs
     0.84%     -0.06%  [.] pfree
     0.47%     +0.06%  [.] set_sentinel
     0.06%     -0.06%  [.] PageGetContents
     0.16%     +0.06%  [.] CheckForSerializableConflictIn
     0.11%     +0.06%  [.] ExecMaterializeSlot
     0.30%     -0.06%  [.] Int32GetDatum
     0.06%     -0.06%  [.] LWLockHeldByMe
     0.11%     +0.05%  [.] list_free
     0.07%     +0.05%  [.] PointerGetDatum
     0.10%     +0.05%  [.] DatumGetCString
     0.21%     +0.05%  [.] ItemPointerSet
     0.35%     +0.05%  [.] AllocSetFreeIndex
     0.07%     +0.05%  [.] check_list_invariants
     0.13%     +0.05%  [.] tts_buffer_heap_get_heap_tuple
     0.14%     +0.05%  [.] CopyMultiInsertInfoIsFull
     0.09%     +0.05%  [.] vector8_is_highbit_set
     0.07%     +0.04%  [.] DatumGetPointer
     0.07%     +0.04%  [.] SerializationNeededForWrite
     0.08%     +0.04%  [.] PageHasFreeLinePointers
     0.10%     +0.04%  [.] CStringGetDatum
     0.07%     +0.04%  [.] list_head
     0.04%     +0.04%  [.] ObjectIdGetDatum
     0.07%     +0.03%  [.] list_free_private
     0.10%     +0.03%  [.] heap_freetuple
     0.15%     -0.03%  [.] BufferGetPage
     0.74%     -0.03%  [.] FormIndexDatum
     0.38%     +0.03%  [.] wipe_mem
     0.05%     +0.03%  [.] vector8_load
     0.07%     +0.03%  [.] ItemPointerGetBlockNumberNoCheck
     0.21%     -0.02%  [.] pg_leftmost_one_pos32
     0.16%     +0.02%  [.] BlockIdGetBlockNumber
     0.02%     +0.02%  [.] tas
     0.05%     +0.02%  [.] DatumGetInt32
     0.02%     +0.02%  [.] pg_utf8_verifystr
     0.44%     +0.02%  [.] sentinel_ok
     0.02%     +0.02%  [.] XLogRecordAssemble
     0.56%     +0.01%  [.] ItemPointerIsValid
     0.05%     +0.01%  [.] pg_atomic_fetch_or_u32_impl
     0.05%     +0.01%  [.] PageGetLSN
     0.01%     +0.01%  [.] XLogRecPtrToBytePos
     0.01%     +0.01%  [.] CopyXLogRecordToWAL
     0.01%     +0.01%  [.] XLogInsertRecord
     0.02%     +0.01%  [.] XLogBytePosToRecPtr
     0.02%     +0.01%  [.] ExtendBufferedRelShared
     0.01%     +0.01%  [.] XLogBytePosToEndRecPtr
     0.01%     +0.01%  [.] init_spin_delay
     0.01%     +0.01%  [.] PageIsAllVisible
     0.99%     -0.01%  [.] ExecClearTuple
     0.01%     +0.01%  [.] MarkBufferDirty
     0.01%     +0.01%  [.] ItemPointerGetOffsetNumber
     0.01%     +0.01%  [.] FileWrite
     0.01%     +0.01%  [.] ReadBufferBI
     0.00%     +0.01%  [.] TerminateBufferIO
     0.01%     +0.01%  [.] get_hash_entry
     0.01%     +0.01%  [.] BufTagGetRelFileLocator
     0.00%     +0.01%  [.] table_multi_insert
     0.00%     +0.01%  [.] PinBuffer_Locked
     0.00%     +0.00%  [.] ScheduleBufferTagForWriteback
     0.01%     +0.00%  [.] ReserveXLogInsertLocation
     0.00%     +0.00%  [.] IsSubxactTopXidLogPending
     0.00%     +0.00%  [.] pgstat_count_io_op_time
     0.01%     +0.00%  [.] PageIsNew
     0.01%     +0.00%  [.] IncrBufferRefCount
     0.00%     +0.00%  [.] smgrwrite
     0.00%     +0.00%  [.] WALInsertLockRelease
     0.01%     +0.00%  [.] GetBufferFromRing
     0.00%     +0.00%  [.] pg_atomic_write_u32_impl
     0.01%     +0.00%  [.] XLogRegisterBuffer
     0.01%     +0.00%  [.] pg_atomic_write_u32
     0.01%     +0.00%  [.] GetVisibilityMapPins
     0.00%     +0.00%  [.] FileSize
     0.01%     +0.00%  [.] XLogRegisterData
     0.00%     +0.00%  [.] hash_search
     0.01%     -0.00%  [.] XLogBeginInsert
     0.01%     +0.00%  [.] fsm_set_avail
     0.01%     +0.00%  [.] ConditionVariableBroadcast
     0.02%     +0.00%  [.] LockBufHdr
     0.00%     +0.00%  [.] SetupLockInTable
     0.01%     +0.00%  [.] XLogRegisterBufData
     0.00%     +0.00%  [.] PageSetChecksumCopy
     0.03%     +0.00%  [.] GetXLogBuffer
     0.01%     -0.00%  [.] mdzeroextend
     0.00%     +0.00%  [.] pgstat_progress_update_param
     0.01%     +0.00%  [.] fsm_readbuf
     0.00%     +0.00%  [.] LWLockConditionalAcquire
     0.01%     +0.00%  [.] GetVictimBuffer
     0.00%     +0.00%  [.] fsm_get_location
     0.00%     +0.00%  [.] proclist_contains_offset
     0.00%     +0.00%  [.] IssuePendingWritebacks
     0.01%     -0.00%  [.] LockRelease
     0.00%     +0.00%  [.] pgstat_count_heap_insert
     0.00%     +0.00%  [.] GrantLockLocal
     0.01%     +0.00%  [.] XLogInsert
     0.01%     +0.00%  [.] PageInit
     0.00%     +0.00%  [.] FileZero
     0.00%     +0.00%  [.] CheckBufferIsPinnedOnce
     0.00%     +0.00%  [.] finish_spin_delay
     0.00%     +0.00%  [.] pg_atomic_fetch_and_u32_impl
     0.01%     +0.00%  [.] LockAcquireExtended
     0.00%     +0.00%  [.] pg_pwrite_zeros
     0.01%     +0.00%  [.] UnlockBufHdr
     0.00%     +0.00%  [.] XLogWrite
     0.00%     +0.00%  [.] AdvanceXLInsertBuffer
     0.00%     +0.00%  [.] pgstat_report_wait_start
     0.00%     +0.00%  [.] GetCurrentTransactionIdIfAny
     0.00%     +0.00%  [.] BufferDescriptorGetIOCV
     0.00%     -0.00%  [.] ProcLockHashCode
     0.00%     +0.00%  [.] ClearBufferTag
     0.00%     +0.00%  [.] ExtendBufferedRelBy
     0.01%     -0.00%  [.] MemoryContextAlloc
     0.00%     +0.00%  [.] ExtendBufferedRelCommon
     0.01%     +0.00%  [.] RelationAddBlocks
     0.01%     +0.00%  [.] pg_atomic_fetch_or_u32
     0.00%     -0.00%  [.] XLogInsertAllowed
     0.00%     +0.00%  [.] XLogResetInsertion
     0.00%     +0.00%  [.] WALInsertLockAcquire
     0.00%     +0.00%  [.] IsCatalogRelation
     0.00%     +0.00%  [.] XLogNeedsFlush
     0.01%     +0.00%  [.] fsm_logical_to_physical
     0.00%     -0.00%  [.] smgrnblocks_cached
     0.00%     -0.00%  [.] ResourceOwnerRememberLock
     0.03%     +0.00%  [.] RelationGetBufferForTuple
     0.00%     +0.00%  [.] register_dirty_segment
     0.00%     +0.00%  [.] StartBufferIO
     0.00%     +0.00%  [.] smgrzeroextend
     0.00%     +0.00%  [.] CopyMultiInsertInfoFlush
     0.01%     +0.00%  [.] FlushBuffer
     0.00%     +0.00%  [.] UnlockRelationForExtension
     0.00%     +0.00%  [.] GetCurrentTransactionId
     0.00%     +0.00%  [.] smgrnblocks
     0.01%     +0.00%  [.] InvalidateVictimBuffer
     0.00%     -0.00%  [.] GetFullPageWriteInfo
     0.00%     +0.00%  [.] StrategyGetBuffer
     0.00%     +0.00%  [.] pg_atomic_fetch_and_u32
     0.00%     +0.00%  [.] PageSetLSN
     0.00%     -0.00%  [.] CopyLoadRawBuf
     0.00%     +0.00%  [.] RelationExtensionLockWaiterCount
     0.00%     +0.00%  [.] UnlockReleaseBuffer
     0.01%     +0.00%  [.] ItemPointerGetOffsetNumberNoCheck
     0.00%     +0.00%  [.] GrantLock
     0.00%     -0.00%  [.] pgstat_report_wait_end
     0.00%     -0.00%  [.] dlist_delete
     0.00%     +0.00%  [.] fsm_space_needed_to_cat
     0.00%     +0.00%  [.] ResourceOwnerEnlargeBufferIOs
     0.00%     +0.00%  [.] DataChecksumsEnabled
     0.01%     +0.00%  [.] pg_pwritev_with_retry
     0.01%     -0.00%  [.] ForwardSyncRequest
     0.00%     +0.00%  [.] RecordPageWithFreeSpace
     0.00%     +0.00%  [.] MarkCurrentTransactionIdLoggedIfAny
     0.00%     -0.00%  [.] mdnblocks
     0.00%     +0.00%  [.] RegisterSyncRequest
               +0.00%  [.] LWLockConflictsWithVar
               +0.00%  [.] WaitXLogInsertionsToFinish
     0.01%     +0.00%  [.] BufferGetTag
     0.00%     -0.00%  [.] BufferGetPageSize
     0.00%     -0.00%  [.] LimitAdditionalPins
     0.00%     +0.00%  [.] BufTableDelete
     0.00%     +0.00%  [.] fsm_search_avail
     0.00%     +0.00%  [.] fsm_search
     0.00%     +0.00%  [.] RecordAndGetPageWithFreeSpace
     0.00%     +0.00%  [.] proclist_node_get
     0.00%     +0.00%  [.] GetCurrentTransactionNestLevel
     0.00%     +0.00%  [.] dopr
     0.00%     +0.00%  [.] FinishStrongLockAcquire
     0.00%     +0.00%  [.] BufTableInsert
     0.00%     +0.00%  [.] ResourceOwnerForgetBufferIO
     0.00%     +0.00%  [.] LWLockWaitForVar
     0.00%     +0.00%  [.] CopyGetData
     0.00%     +0.00%  [.] proclist_is_empty
     0.00%     +0.00%  [.] fsm_set_and_search
     0.00%     +0.00%  [.] dlist_init
     0.00%     +0.00%  [.] UnGrantLock
     0.00%     +0.00%  [.] dclist_init
     0.00%     +0.00%  [.] BlockNumberIsValid
     0.00%     +0.00%  [.] CopyLoadInputBuf
     0.00%     +0.00%  [.] XLogSetRecordFlags
     0.00%     +0.00%  [.] _mdfd_getseg
               +0.00%  [.] pg_fsync_no_writethrough
     0.00%     -0.00%  [.] LWLockHeldByMeInMode
     0.00%     -0.00%  [.] PageXLogRecPtrGet
     0.00%     +0.00%  [.] XLogFlush
     0.00%     +0.00%  [.] LWLockWaitListLock
     0.01%     -0.00%  [.] mdwrite
     0.00%     +0.00%  [.] fsm_space_avail_to_cat
     0.00%     +0.00%  [.] RecoveryInProgress
     0.00%     +0.00%  [.] ResourceOwnerForgetLock
     0.00%     +0.00%  [.] PageSetPageSizeAndVersion
     0.00%     +0.00%  [.] LockCheckConflicts
     0.00%     +0.00%  [.] CleanUpLock
     0.00%     +0.00%  [.] LWLockUpdateVar
               +0.00%  [.] LWLockWakeup
               +0.00%  [.] pg_atomic_fetch_add_u32
               +0.00%  [.] pg_snprintf
               +0.00%  [.] proclist_init
               +0.00%  [.] fsm_extend
               +0.00%  [.] PGSemaphoreLock
               +0.00%  [.] LWLockReportWaitStart
               +0.00%  [.] WALInsertLockUpdateInsertingAt
     0.00%     +0.00%  [.] CopyConvertBuf
     0.00%     -0.00%  [.] pgstat_prepare_io_time
     0.00%     -0.00%  [.] BufTagGetRelNumber
     0.00%     -0.00%  [.] pg_encoding_verifymbstr
     0.00%     -0.00%  [.] LockRelationForExtension
     0.00%     -0.00%  [.] FileAccess
     0.00%     -0.00%  [.] mdopenfork
     0.00%     +0.00%  [.] LWLockReleaseClearVar
     0.00%     +0.00%  [.] ensure_tabstat_xact_level
     0.00%     +0.00%  [.] ResourceOwnerRememberBufferIO
     0.00%     +0.00%  [.] LWLockWaitListUnlock
     0.00%     -0.00%  [.] LockAcquire
     0.00%     +0.00%  [.] fsm_get_max_avail
     0.00%     +0.00%  [.] _mdnblocks
     0.00%     +0.00%  [.] RemoveLocalLock
     0.00%     +0.00%  [.] dlist_push_tail
     0.00%     -0.00%  [.] smgropen
     0.00%     +0.00%  [.] LockTagHashCode
     0.00%     +0.00%  [.] BufferTagsEqual
     0.00%     +0.00%  [.] dlist_is_empty
     0.00%     -0.00%  [.] LockWaiterCount
     0.97%             [.] brinRevmapInitialize
     0.16%             [.] brinRevmapTerminate
     0.10%             [.] ReadBuffer
     0.09%             [.] TestForOldSnapshot
     0.00%             [.] BufTagGetForkNum
     0.00%             [.] CheckAndSetLockHeld
     0.00%             [.] IsCatalogRelationOid