perf_results.txt
text/plain
Filename: perf_results.txt
Type: text/plain
Part: 0
# commit case
## 128 clients
- 97.77% 0.00% postgres postgres [.] pg_logical_slot_get_changes_guts
- 97.77% pg_logical_slot_get_changes_guts
- 97.77% LogicalDecodingProcessRecord
- 97.71% xact_decode
- 54.95% ReorderBufferProcessTXN
- 32.64% ReorderBufferRestoreChanges
+ 23.37% FileRead
4.58% __memcpy_ssse3_back
+ 4.14% MemoryContextAllocZero
+ 7.73% ReorderBufferCopySnap.isra.21
+ 5.94% ReorderBufferSerializeTXN
+ 5.78% ReorderBufferCleanupTXN
+ 2.04% RelationIdGetRelation
- 42.75% SnapBuildCommitTxn
- 34.56% ReorderBufferQueueChange
- 34.36% ReorderBufferSerializeTXN
27.64% __write_nocancel
4.42% __memcpy_ssse3_back
+ 1.52% OpenTransientFilePerm
+ 7.97% SnapBuildBuildSnapshot
0.04% 0.00% postgres postgres [.] ReorderBufferSequenceIsTransactional
## 64 clients
- 86.49% 0.04% postgres postgres [.] pg_logical_slot_get_changes_guts
- 86.45% pg_logical_slot_get_changes_guts
- 86.37% LogicalDecodingProcessRecord
- 84.79% xact_decode
- 51.05% SnapBuildCommitTxn
+ 49.77% SnapBuildBuildSnapshot
0.53% ReorderBufferXidHasBaseSnapshot
- 33.45% ReorderBufferProcessTXN
+ 21.37% ReorderBufferCopySnap.isra.21
+ 4.86% RelationIdGetRelation
+ 2.31% RelidByRelfilenumber
+ 0.84% AbortCurrentTransaction
0.81% ReorderBufferCleanupTXN
- 1.10% seq_decode
0.65% ReorderBufferSequenceIsTransactional
- 1.04% 0.09% postgres postgres [.] ReorderBufferSequenceIsTransactional
## 32 clients
- 82.20% 0.13% postgres postgres [.] pg_logical_slot_get_changes_guts
- 82.09% pg_logical_slot_get_changes_guts
- 81.86% LogicalDecodingProcessRecord
- 80.01% xact_decode
- 49.38% SnapBuildCommitTxn
+ 48.10% SnapBuildBuildSnapshot
0.50% ReorderBufferXidHasBaseSnapshot
- 29.98% ReorderBufferProcessTXN
+ 10.52% ReorderBufferCopySnap.isra.21
+ 7.64% RelationIdGetRelation
+ 4.11% RelidByRelfilenumber
+ 1.70% AbortCurrentTransaction
1.01% ReorderBufferCleanupTXN
0.92% LocalExecuteInvalidationMessage
0.87% commit_cb_wrapper
- 1.01% seq_decode
0.56% ReorderBufferSequenceIsTransactional
+ 0.85% 0.08% postgres postgres [.] ReorderBufferSequenceIsTransactional
## 16 clients
- 78.30% 0.10% postgres postgres [.] pg_logical_slot_get_changes_guts
- 78.24% pg_logical_slot_get_changes_guts
- 77.89% LogicalDecodingProcessRecord
- 75.11% xact_decode
- 38.84% SnapBuildCommitTxn
- 37.54% SnapBuildBuildSnapshot
+ 37.09% pg_qsort
0.56% ReorderBufferXidHasBaseSnapshot
- 35.34% ReorderBufferProcessTXN
+ 11.17% RelationIdGetRelation
+ 7.05% RelidByRelfilenumber
+ 6.33% ReorderBufferCopySnap.isra.21
+ 2.78% AbortCurrentTransaction
+ 1.27% commit_cb_wrapper
+ 1.22% LocalExecuteInvalidationMessage
0.93% ReorderBufferCleanupTXN
0.79% begin_cb_wrapper
0.74% hash_create
0.57% UpdateDecodingStats
+ 0.99% seq_decode
+ 0.74% ReorderBufferAddRelFileLocator
0.77% 0.08% postgres postgres [.] ReorderBufferSequenceIsTransactional
## 8 clients
- 75.95% 0.16% postgres postgres [.] pg_logical_slot_get_changes_guts
- 75.78% pg_logical_slot_get_changes_guts
- 75.06% LogicalDecodingProcessRecord
- 71.67% xact_decode
- 40.29% ReorderBufferProcessTXN
+ 14.88% RelationIdGetRelation
+ 8.87% RelidByRelfilenumber
+ 3.36% AbortCurrentTransaction
+ 2.05% ReorderBufferCopySnap.isra.21
+ 1.71% LocalExecuteInvalidationMessage
+ 1.70% begin_cb_wrapper
+ 1.52% ReorderBufferCleanupTXN
+ 1.46% commit_cb_wrapper
1.10% hash_create
0.54% BeginInternalSubTransaction
+ 29.97% SnapBuildCommitTxn
1.07% seq_decode
+ 0.82% ReorderBufferAddRelFileLocator
0.71% 0.11% postgres postgres [.] ReorderBufferSequenceIsTransactional
# abort case
## 128 clients
- 64.15% 0.62% postgres postgres [.] pg_logical_slot_get_changes_guts
- 63.71% pg_logical_slot_get_changes_guts
- 62.17% LogicalDecodingProcessRecord
- 46.95% seq_decode
- 23.71% ReorderBufferSequenceIsTransactional
+ 13.63% hash_search
8.64% hash_search_with_hash_value
- 22.34% ReorderBufferQueueSequence
+ 20.95% ReorderBufferSequenceIsTransactional
+ 0.53% AbortCurrentTransaction
+ 6.23% xact_decode
+ 3.06% ReorderBufferAddRelFileLocator
+ 2.25% heap2_decode
+ 1.65% heap_decode
+ 0.76% smgr_decode
1.27% XLogReadRecord
- 46.27% 4.60% postgres postgres [.] ReorderBufferSequenceIsTransactional
- 42.57% ReorderBufferSequenceIsTransactional
+ 25.68% hash_search
15.98% hash_search_with_hash_value
+ 1.86% _start
+ 1.13% ServerLoop
+ 0.71% 0x34
## 64 clients
- 38.08% 1.45% postgres postgres [.] pg_logical_slot_get_changes_guts
- 36.89% pg_logical_slot_get_changes_guts
- 34.41% LogicalDecodingProcessRecord
+ 9.88% xact_decode
- 6.35% seq_decode
+ 2.47% ReorderBufferQueueSequence
- 1.73% ReorderBufferSequenceIsTransactional
+ 0.91% hash_search
0.72% hash_search_with_hash_value
+ 0.85% ReorderBufferGetTupleBuf
0.62% ReorderBufferTXNByXid
- 5.39% ReorderBufferAddRelFileLocator
+ 5.14% hash_create
+ 4.91% heap2_decode
+ 3.26% heap_decode
+ 1.76% smgr_decode
1.09% ReorderBufferTXNByXid
+ 1.97% XLogReadRecord
+ 1.19% _start
- 29.14% 3.89% postgres postgres [.] ReorderBufferSequenceIsTransactional
- 25.60% ReorderBufferSequenceIsTransactional
+ 14.29% hash_search
10.94% hash_search_with_hash_value
+ 2.89% _start
+ 0.60% 0x34
## 32 clients
- 51.65% 1.37% postgres postgres [.] pg_logical_slot_get_changes_guts
- 50.81% pg_logical_slot_get_changes_guts
- 47.23% LogicalDecodingProcessRecord
- 19.72% seq_decode
+ 9.36% ReorderBufferSequenceIsTransactional
- 8.73% ReorderBufferQueueSequence
+ 6.20% ReorderBufferSequenceIsTransactional
+ 1.49% AbortCurrentTransaction
0.50% ReorderBufferGetTupleBuf
+ 10.70% xact_decode
+ 6.26% heap2_decode
+ 4.65% ReorderBufferAddRelFileLocator
2.05% heap_decode
+ 1.19% smgr_decode
+ 0.98% standby_decode
+ 2.54% XLogReadRecord
+ 0.84% _start
- 15.82% 1.76% postgres postgres [.] ReorderBufferSequenceIsTransactional
- 14.05% ReorderBufferSequenceIsTransactional
+ 8.10% hash_search
5.95% hash_search_with_hash_value
+ 1.51% _start
## 16 clients
- 47.89% 0.62% postgres postgres [.] pg_logical_slot_get_changes_guts
- 47.51% pg_logical_slot_get_changes_guts
- 44.85% LogicalDecodingProcessRecord
- 13.51% seq_decode
- 5.84% ReorderBufferQueueSequence
+ 3.84% ReorderBufferSequenceIsTransactional
+ 0.71% AbortCurrentTransaction
+ 2.88% ReorderBufferSequenceIsTransactional
+ 1.83% ReorderBufferGetTupleBuf
1.22% __memcpy_ssse3_back
+ 0.52% ReorderBufferTXNByXid
+ 11.06% xact_decode
+ 6.94% ReorderBufferAddRelFileLocator
+ 5.00% heap2_decode
+ 2.73% heap_decode
+ 2.58% standby_decode
+ 1.82% smgr_decode
+ 1.66% XLogReadRecord
- 7.26% 1.04% postgres postgres [.] ReorderBufferSequenceIsTransactional
- 6.49% ReorderBufferSequenceIsTransactional
+ 3.95% hash_search
2.27% hash_search_with_hash_value
+ 0.50% _start
## 8 clients
- 36.33% 1.49% postgres postgres [.] pg_logical_slot_get_changes_guts
- 35.35% pg_logical_slot_get_changes_guts
- 32.91% LogicalDecodingProcessRecord
- 8.31% seq_decode
- 4.54% ReorderBufferQueueSequence
+ 2.35% ReorderBufferSequenceIsTransactional
+ 0.99% AbortCurrentTransaction
+ 1.38% ReorderBufferSequenceIsTransactional
0.97% __memcpy_ssse3_back
0.95% ReorderBufferGetTupleBuf
+ 8.02% xact_decode
+ 5.63% heap2_decode
+ 3.66% ReorderBufferAddRelFileLocator
+ 3.53% standby_decode
+ 2.25% heap_decode
0.99% ReorderBufferTXNByXid
+ 1.22% CreateDecodingContext
+ 0.51% InvalidateSystemCachesExtended
+ 0.98% _start
- 3.73% 0.00% postgres postgres [.] ReorderBufferSequenceIsTransactional
- ReorderBufferSequenceIsTransactional
2.37% hash_search_with_hash_value
+ 1.36% hash_search