Skip to content

Instantly share code, notes, and snippets.

@mfenniak

mfenniak/osx-pg-walsender-samples-2.txt

Created May 10, 2017 15:41
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mfenniak/cef36699deb426efd8e433027553a37e to your computer and use it in GitHub Desktop.
Save mfenniak/cef36699deb426efd8e433027553a37e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
osx-pg-walsender-samples-2.txt
Analysis of sampling postgres (pid 94571) every 1 millisecond
Process: postgres [94571]
Path: /Users/mathieu.fenniak/Development/pgsql-9.5.4-avoid-search/bin/postgres
Load Address: 0x1061db000
Identifier: postgres
Version: 0
Code Type: X86-64
Parent Process: postgres [94365]
Date/Time: 2017-05-10 09:40:17.180 -0600
Launch Time: 2017-05-10 08:47:47.752 -0600
OS Version: Mac OS X 10.11.6 (15G1421)
Report Version: 7
Analysis Tool: /usr/bin/sample
----
Call graph:
27524 Thread_1049301 DispatchQueue_1: com.apple.main-thread (serial)
27524 start (in libdyld.dylib) + 1 [0x7fff8b7575ad]
27524 main (in postgres) + 1562 [0x10636495a]
27524 PostmasterMain (in postgres) + 7864 [0x1063d2ec8]
27524 PostgresMain (in postgres) + 8073 [0x106433e89]
27524 exec_replication_command (in postgres) + 914 [0x1063f3642]
27523 WalSndLoop (in postgres) + 258 [0x1063f60d2]
+ 25019 XLogSendLogical (in postgres) + 79 [0x1063f67df]
+ ! 25019 LogicalDecodingProcessRecord (in postgres) + 3560 [0x1063e9258]
+ ! 24461 ReorderBufferCommit (in postgres) + 4055 [0x1063eca57]
+ ! : 15668 LocalExecuteInvalidationMessage (in postgres) + 407 [0x106516f47]
+ ! : | 13725 RelfilenodeMapInvalidateCallback (in postgres) + 114 [0x106521f62]
+ ! : | + 13725 hash_seq_search (in postgres) + 169,160,... [0x1065370f9,0x1065370f0,...]
+ ! : | 1645 RelfilenodeMapInvalidateCallback (in postgres) + 40 [0x106521f18]
+ ! : | + 1645 hash_seq_search (in postgres) + 160,169,... [0x1065370f0,0x1065370f9,...]
+ ! : | 152 RelfilenodeMapInvalidateCallback (in postgres) + 106,64,... [0x106521f5a,0x106521f30,...]
+ ! : | 103 RelfilenodeMapInvalidateCallback (in postgres) + 32 [0x106521f10]
+ ! : | + 80 hash_seq_init (in postgres) + 79,57,... [0x10653700f,0x106536ff9,...]
+ ! : | + 23 hash_seq_init (in postgres) + 62 [0x106536ffe]
+ ! : | + 23 GetCurrentTransactionNestLevel (in postgres) + 0,11,... [0x10623d590,0x10623d59b,...]
+ ! : | 43 PlanCacheRelCallback (in postgres) + 228,6,... [0x1065181e4,0x106518106,...]
+ ! : 4748 LocalExecuteInvalidationMessage (in postgres) + 151,112,... [0x106516e47,0x106516e20,...]
+ ! : 3161 LocalExecuteInvalidationMessage (in postgres) + 72 [0x106516df8]
+ ! : | 2458 CatCacheInvalidate (in postgres) + 110,117,... [0x1065145ee,0x1065145f5,...]
+ ! : | 703 SysCacheInvalidate (in postgres) + 1,6,... [0x106522a31,0x106522a36,...]
+ ! : 491 LocalExecuteInvalidationMessage (in postgres) + 366 [0x106516f1e]
+ ! : | 422 RelationCacheInvalidateEntry (in postgres) + 33 [0x10651c1f1]
+ ! : | + 280 hash_search_with_hash_value (in postgres) + 822,770,... [0x106536ab6,0x106536a82,...]
+ ! : | + 74 hash_search (in postgres) + 33 [0x106536761]
+ ! : | + ! 66 hash_uint32 (in postgres) + 49,4,... [0x106202ce1,0x106202cb4,...]
+ ! : | + ! 8 uint32_hash (in postgres) + 1,4,... [0x106537481,0x106537484,...]
+ ! : | + 59 hash_search (in postgres) + 30,17,... [0x10653675e,0x106536751,...]
+ ! : | + 9 uint32_hash (in postgres) + 7 [0x106537487]
+ ! : | 66 RelationCacheInvalidateEntry (in postgres) + 168,0,... [0x10651c278,0x10651c1d0,...]
+ ! : | 3 hash_search (in postgres) + 55 [0x106536777]
+ ! : 315 LocalExecuteInvalidationMessage (in postgres) + 59 [0x106516deb]
+ ! : | 315 InvalidateCatalogSnapshot (in postgres) + 11,0,... [0x10655ee6b,0x10655ee60,...]
+ ! : 46 InvalidateCatalogSnapshot (in postgres) + 4,11,... [0x10655ee64,0x10655ee6b,...]
+ ! : 32 SysCacheInvalidate (in postgres) + 38 [0x106522a56]
+ ! 465 ReorderBufferCommit (in postgres) + 4032,4050,... [0x1063eca40,0x1063eca52,...]
+ ! 76 ReorderBufferCommit (in postgres) + 3675 [0x1063ec8db]
+ ! : 49 ReorderBufferRestoreChanges (in postgres) + 451 [0x1063eedb3]
+ ! : | 49 read (in libsystem_kernel.dylib) + 10 [0x7fff917df362]
+ ! : 20 ReorderBufferRestoreChanges (in postgres) + 610 [0x1063eee52]
+ ! : | 20 read (in libsystem_kernel.dylib) + 10 [0x7fff917df362]
+ ! : 6 ReorderBufferRestoreChanges (in postgres) + 87,695,... [0x1063eec47,0x1063eeea7,...]
+ ! : 1 ReorderBufferRestoreChanges (in postgres) + 113 [0x1063eec61]
+ ! : 1 ReorderBufferReturnChange (in postgres) + 16 [0x1063eb330]
+ ! 5 LocalExecuteInvalidationMessage (in postgres) + 227 [0x106516e93]
+ ! 4 ReorderBufferCommit (in postgres) + 5011 [0x1063ece13]
+ ! : 3 ReorderBufferCleanupTXN (in postgres) + 180 [0x1063ed6a4]
+ ! : 1 ReorderBufferCleanupTXN (in postgres) + 419 [0x1063ed793]
+ ! : 1 unlink (in libsystem_kernel.dylib) + 11 [0x7fff917dbd28]
+ ! : 1 __unlink (in libsystem_kernel.dylib) + 10 [0x7fff917de4fa]
+ ! 3 ReorderBufferCommit (in postgres) + 4168 [0x1063ecac8]
+ ! : 2 RelidByRelfilenode (in postgres) + 33,37 [0x106521ba1,0x106521ba5]
+ ! : 1 RelidByRelfilenode (in postgres) + 446 [0x106521d3e]
+ ! : 1 hash_search (in postgres) + 33 [0x106536761]
+ ! : 1 tag_hash (in postgres) + 0 [0x106537470]
+ ! 3 ReorderBufferCommit (in postgres) + 4919 [0x1063ecdb7]
+ ! : 3 LocalExecuteInvalidationMessage (in postgres) + 407 [0x106516f47]
+ ! : 2 RelfilenodeMapInvalidateCallback (in postgres) + 114 [0x106521f62]
+ ! : | 2 hash_seq_search (in postgres) + 183,160 [0x106537107,0x1065370f0]
+ ! : 1 PlanCacheRelCallback (in postgres) + 0 [0x106518100]
+ ! 2 ReorderBufferCommit (in postgres) + 4188 [0x1063ecadc]
+ ! 1 RelationIdGetRelation (in postgres) + 34 [0x10651aba2]
+ ! | 1 hash_search (in postgres) + 33 [0x106536761]
+ ! | 1 hash_uint32 (in postgres) + 4 [0x106202cb4]
+ ! 1 RelationIdGetRelation (in postgres) + 48 [0x10651abb0]
+ 2504 XLogSendLogical (in postgres) + 40 [0x1063f67b8]
+ 2504 XLogReadRecord (in postgres) + 202 [0x1062547da]
+ 2504 ReadPageInternal (in postgres) + 255 [0x106254dbf]
+ 2504 logical_read_xlog_page (in postgres) + 637 [0x1063f51ed]
+ 2504 WaitLatchOrSocket (in postgres) + 499 [0x1063c3bd3]
+ 2504 poll (in libsystem_kernel.dylib) + 10 [0x7fff917df2a2]
1 WalSndLoop (in postgres) + 265 [0x1063f60d9]
1 socket_flush_if_writable (in postgres) + 65 [0x106362be1]
1 internal_flush (in postgres) + 79 [0x10636306f]
1 secure_write (in postgres) + 34 [0x1063599f2]
1 __sendto (in libsystem_kernel.dylib) + 10 [0x7fff917de16a]
Total number in stack (recursive counted multiple, when >=5):
Sort by top of stack, same collapsed (when >= 5):
hash_seq_search (in postgres) 15372
LocalExecuteInvalidationMessage (in postgres) 4753
poll (in libsystem_kernel.dylib) 2504
CatCacheInvalidate (in postgres) 2458
SysCacheInvalidate (in postgres) 735
ReorderBufferCommit (in postgres) 465
InvalidateCatalogSnapshot (in postgres) 361
hash_search_with_hash_value (in postgres) 280
RelfilenodeMapInvalidateCallback (in postgres) 152
hash_seq_init (in postgres) 80
read (in libsystem_kernel.dylib) 69
hash_uint32 (in postgres) 67
RelationCacheInvalidateEntry (in postgres) 66
hash_search (in postgres) 62
PlanCacheRelCallback (in postgres) 44
GetCurrentTransactionNestLevel (in postgres) 23
uint32_hash (in postgres) 17
ReorderBufferRestoreChanges (in postgres) 6
Binary Images:
0x1061db000 - 0x106698ff3 +postgres (0) <A1F37FB4-E52D-3FCD-8616-D6C65EB4AC6D> /Users/mathieu.fenniak/Development/pgsql-9.5.4-avoid-search/bin/postgres
0x106830000 - 0x106831ff7 +test_decoding.so (0) <5ABF6E31-0C08-37BE-BEC5-FA4838713B01> /Users/mathieu.fenniak/Development/pgsql-9.5.4-avoid-search/lib/test_decoding.so
0x7fff622df000 - 0x7fff62316a47 dyld (0.0 - ???) <884763FC-CC0F-31CC-ACC4-75A805CE401D> /usr/lib/dyld
0x7fff867a3000 - 0x7fff867cdff7 libc++abi.dylib (307.2) <922EFB36-0E9E-315B-8270-E81AC43472C0> /usr/lib/libc++abi.dylib
0x7fff872dc000 - 0x7fff872edff7 libsystem_trace.dylib (201.10.3) <E9311C03-9E61-3B13-AF3F-A64956FFF269> /usr/lib/system/libsystem_trace.dylib
0x7fff88758000 - 0x7fff88760ffb libsystem_dnssd.dylib (625.60.4) <80189998-32B0-316C-B5C5-53857486713D> /usr/lib/system/libsystem_dnssd.dylib
0x7fff8930f000 - 0x7fff89310fff libDiagnosticMessagesClient.dylib (100) <4243B6B4-21E9-355B-9C5A-95A216233B96> /usr/lib/libDiagnosticMessagesClient.dylib
0x7fff899b9000 - 0x7fff899bbff7 libquarantine.dylib (80) <0F4169F0-0C84-3A25-B3AE-E47B3586D908> /usr/lib/system/libquarantine.dylib
0x7fff8a2b9000 - 0x7fff8a2e2ff7 libxpc.dylib (765.50.8) <54D1328E-054E-3DAA-89E2-375722F9D18F> /usr/lib/system/libxpc.dylib
0x7fff8a2e3000 - 0x7fff8a2ebfef libsystem_platform.dylib (74.40.2) <29A905EF-6777-3C33-82B0-6C3A88C4BA15> /usr/lib/system/libsystem_platform.dylib
0x7fff8a42c000 - 0x7fff8a492ff7 libsystem_network.dylib (583.50.1) <B52DAB73-92DC-3DA7-B9F4-B899D66445C1> /usr/lib/system/libsystem_network.dylib
0x7fff8a4ed000 - 0x7fff8a516fff libsystem_info.dylib (477.50.4) <FAA9226D-64DE-3769-A6D8-6CABA4B7FF4D> /usr/lib/system/libsystem_info.dylib
0x7fff8ad6f000 - 0x7fff8ad86ff7 libsystem_coretls.dylib (83.40.5) <C90DAE38-4082-381C-A185-2A6A8B677628> /usr/lib/system/libsystem_coretls.dylib
0x7fff8b6a6000 - 0x7fff8b733fef libsystem_c.dylib (1082.60.1) <28733D22-553E-3CBC-8D2C-EDCEB46E46AF> /usr/lib/system/libsystem_c.dylib
0x7fff8b754000 - 0x7fff8b757ffb libdyld.dylib (360.22) <F103B2FB-D383-38CB-992A-E16BDCB00A03> /usr/lib/system/libdyld.dylib
0x7fff8bf62000 - 0x7fff8bf65fff libsystem_sandbox.dylib (460.60.2) <2A68B39C-B786-3A05-87A2-56E688469FB8> /usr/lib/system/libsystem_sandbox.dylib
0x7fff8c1cc000 - 0x7fff8c1cdfff libsystem_secinit.dylib (20) <32B1A8C6-DC84-3F4F-B8CE-9A52B47C3E6B> /usr/lib/system/libsystem_secinit.dylib
0x7fff8c2db000 - 0x7fff8c308fff libdispatch.dylib (501.40.12) <C7499857-61A5-3D7D-A5EA-65DCC8C3DF92> /usr/lib/system/libdispatch.dylib
0x7fff8c309000 - 0x7fff8c314ff7 libcommonCrypto.dylib (60075.50.1) <93732261-34B4-3914-B7A2-90A81A182DBA> /usr/lib/system/libcommonCrypto.dylib
0x7fff8cf73000 - 0x7fff8cf7bfff libcopyfile.dylib (127) <A48637BC-F3F2-34F2-BB68-4C65FD012832> /usr/lib/system/libcopyfile.dylib
0x7fff8cfc5000 - 0x7fff8cfc6ffb libremovefile.dylib (41) <552EF39E-14D7-363E-9059-4565AC2F894E> /usr/lib/system/libremovefile.dylib
0x7fff8faaa000 - 0x7fff8faacff7 libsystem_configuration.dylib (802.40.13) <3DEB7DF9-6804-37E1-BC83-0166882FF0FF> /usr/lib/system/libsystem_configuration.dylib
0x7fff8ff5e000 - 0x7fff8ffb1ff7 libc++.1.dylib (120.1) <8FC3D139-8055-3498-9AC5-6467CB7F4D14> /usr/lib/libc++.1.dylib
0x7fff900bb000 - 0x7fff900d7ff7 libsystem_malloc.dylib (67.40.1) <5748E8B2-F81C-34C6-8B13-456213127678> /usr/lib/system/libsystem_malloc.dylib
0x7fff9013d000 - 0x7fff90146ff3 libsystem_notify.dylib (150.40.1) <D48BDE34-0F7E-34CA-A0FF-C578E39987CC> /usr/lib/system/libsystem_notify.dylib
0x7fff90b00000 - 0x7fff90b00ff7 libkeymgr.dylib (28) <8371CE54-5FDD-3CE9-B3DF-E98C761B6FE0> /usr/lib/system/libkeymgr.dylib
0x7fff917c7000 - 0x7fff917e5ff7 libsystem_kernel.dylib (3248.60.11.4.1) <8448646C-0017-3F77-BB84-75188CC0AC7F> /usr/lib/system/libsystem_kernel.dylib
0x7fff9187c000 - 0x7fff9187cff7 libunc.dylib (29) <DDB1E947-C775-33B8-B461-63E5EB698F0E> /usr/lib/system/libunc.dylib
0x7fff92b3f000 - 0x7fff92b56ff7 libsystem_asl.dylib (323.50.1) <41F8E11F-1BD0-3F1D-BA3A-AA1577ED98A9> /usr/lib/system/libsystem_asl.dylib
0x7fff92fb7000 - 0x7fff92fbcff7 libmacho.dylib (875.1) <318264FA-58F1-39D8-8285-1F6254EE410E> /usr/lib/system/libmacho.dylib
0x7fff92fce000 - 0x7fff93014ff7 libauto.dylib (186) <999E610F-41FC-32A3-ADCA-5EC049B65DFB> /usr/lib/libauto.dylib
0x7fff93015000 - 0x7fff93377f3f libobjc.A.dylib (680) <7489D2D6-1EFD-3414-B18D-2AECCCC90286> /usr/lib/libobjc.A.dylib
0x7fff934e9000 - 0x7fff93518ffb libsystem_m.dylib (3105) <08E1A4B2-6448-3DFE-A58C-ACC7335BE7E4> /usr/lib/system/libsystem_m.dylib
0x7fff93b14000 - 0x7fff93b8bfeb libcorecrypto.dylib (335.50.1) <B5C05FD7-A540-345A-87BF-8E41848A3C17> /usr/lib/system/libcorecrypto.dylib
0x7fff947f8000 - 0x7fff947ffff7 libcompiler_rt.dylib (62) <A13ECF69-F59F-38AE-8609-7B731450FBCD> /usr/lib/system/libcompiler_rt.dylib
0x7fff953ea000 - 0x7fff953efff3 libunwind.dylib (35.3) <F6EB48E5-4D12-359A-AB54-C937FBBE9043> /usr/lib/system/libunwind.dylib
0x7fff96483000 - 0x7fff96484fff libsystem_blocks.dylib (65) <1244D9D5-F6AA-35BB-B307-86851C24B8E5> /usr/lib/system/libsystem_blocks.dylib
0x7fff97752000 - 0x7fff97754fff libsystem_coreservices.dylib (19.2) <1B3F5AFC-FFCD-3ECB-8B9A-5538366FB20D> /usr/lib/system/libsystem_coreservices.dylib
0x7fff97a66000 - 0x7fff97a67ffb libSystem.B.dylib (1226.10.1) <012548CD-614D-3AF0-B3B1-676F427D2CD6> /usr/lib/libSystem.B.dylib
0x7fff97db1000 - 0x7fff97db5fff libcache.dylib (75) <9548AAE9-2AB7-3525-9ECE-A2A7C4688447> /usr/lib/system/libcache.dylib
0x7fff9b94a000 - 0x7fff9b953ff7 libsystem_pthread.dylib (138.10.4) <3DD1EF4C-1D1B-3ABF-8CC6-B3B1CEEE9559> /usr/lib/system/libsystem_pthread.dylib
0x7fff9bd63000 - 0x7fff9bd6bfff libsystem_networkextension.dylib (385.40.36) <66095DC7-6539-38F2-95EE-458F15F6D014> /usr/lib/system/libsystem_networkextension.dylib
0x7fff9bd9a000 - 0x7fff9bd9aff7 liblaunch.dylib (765.50.8) <834ED605-5114-3641-AA4D-ECF31B801C50> /usr/lib/system/liblaunch.dylib
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment