Created
May 10, 2017 15:41
-
-
Save mfenniak/cef36699deb426efd8e433027553a37e to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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