# Events: 1K cycles # # Overhead Samples Command Shared Object Symbol # ........ .......... ............... ................. ............................... # 10.69% 143 postgres [mmfslinux] [k] 0x20001 | --- 0xffffffffa04c0066 | |--58.66%-- 0xffffffffa0554e96 | 0xffffffffa056facb | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --41.34%-- 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04aad3d 0xffffffffa052df93 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa04aa75c | |--83.35%-- 0xffffffffa04c01d0 | | | |--80.03%-- 0xffffffffa0553f90 | | 0xffffffffa05715f4 | | 0xffffffffa04c61ab | | vfs_read | | sys_read | | system_call_fastpath | | 0x7fb873db55d0 | | __GI___read | | | --19.97%-- 0xffffffffa0554e96 | 0xffffffffa056facb | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --16.65%-- 0xffffffffa04aaf15 0xffffffffa052df93 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa04c005e | |--74.99%-- 0xffffffffa0553f90 | 0xffffffffa05715f4 | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --25.01%-- 0xffffffffa0554e96 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04aa6dc 0xffffffffa04c01d0 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04a3277 | |--50.12%-- 0xffffffffa0554103 | 0xffffffffa05715f4 | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --49.88%-- 0xffffffffa0554ecf 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04a057f 0xffffffffa051f536 | |--50.11%-- 0xffffffffa053ac4a | 0xffffffffa051f34a | 0xffffffffa0560b17 | 0xffffffffa04aeb14 | 0xffffffffa04c602f | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --49.89%-- 0xffffffffa0541346 0xffffffffa0570c42 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04a89b0 0xffffffffa051f54e 0xffffffffa053ac4a 0xffffffffa051f34a 0xffffffffa0560b17 0xffffffffa04aeb14 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04bff72 0xffffffffa0554e96 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04c0001 0xffffffffa0554e96 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04a2d32 0xffffffffa05470e2 0xffffffffa05540de 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04a89b6 0xffffffffa051f54e 0xffffffffa053ac4a 0xffffffffa051f34a 0xffffffffa0560b17 0xffffffffa04aeb14 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04aa676 0xffffffffa04c01d0 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04c6103 vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04a0b53 0xffffffffa0551757 0xffffffffa0554cba 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04bfea1 0xffffffffa04c021c 0xffffffffa0554e96 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04c5faa vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04a0579 0xffffffffa051f536 0xffffffffa054182c 0xffffffffa051f20f 0xffffffffa05a170c 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa04b58e1 0xffffffffa052d479 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa04aea04 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04a2c21 0xffffffffa05470e2 0xffffffffa055508c 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04afb41 sys_lseek system_call_fastpath 0x7fb873dc30d0 __lseek64 | --- 0xffffffffa04c5f93 vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04bff87 0xffffffffa0554e96 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 10.32% 138 postgres [mmfs26] [k] 0x31986 | --- 0xffffffffa05cab72 0xffffffffa052e9a9 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa05e1d4d | |--59.97%-- __GI___read | --40.03%-- posix_fadvise | --- 0xffffffffa053424f | |--83.35%-- 0xffffffffa0551537 | | | |--59.95%-- 0xffffffffa0554cba | | 0xffffffffa056facb | | 0xffffffffa04c61ab | | vfs_read | | sys_read | | system_call_fastpath | | 0x7fb873db55d0 | | __GI___read | | | --40.05%-- 0xffffffffa0553de1 | 0xffffffffa05715f4 | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --16.65%-- 0xffffffffa05a67dc 0xffffffffa052eb10 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa05cab85 0xffffffffa052e9a9 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa052bd2a 0xffffffffa052d695 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa05516f9 | |--66.68%-- 0xffffffffa0553de1 | 0xffffffffa05715f4 | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --33.32%-- 0xffffffffa0554cba 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0514a41 0xffffffffa05701ef 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05e1d6a posix_fadvise | --- 0xffffffffa053669c 0xffffffffa052a8e7 | |--50.08%-- 0xffffffffa056faff | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --49.92%-- 0xffffffffa059e9e4 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa05ba684 0xffffffffa05341d7 | |--50.06%-- 0xffffffffa052b1ff | 0xffffffffa05a186d | 0xffffffffa05a1a2d | 0xffffffffa04b565a | read_pages | __do_page_cache_readahead | force_page_cache_readahead | sys_fadvise64_64 | system_call_fastpath | 0x7fb873db9e5d | posix_fadvise | --49.94%-- 0xffffffffa052b96c 0xffffffffa052d695 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa0551e00 0xffffffffa04c006c | |--50.01%-- 0xffffffffa0553f90 | 0xffffffffa05715f4 | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --49.99%-- 0xffffffffa0554e96 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0541986 0xffffffffa05718be 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa053678f 0xffffffffa0554ee7 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa052a838 0xffffffffa052ddba 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa051f3b9 0xffffffffa05a17f1 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa056f595 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0546e90 0xffffffffa055508c 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05e01b8 0xffffffffa05e131d 0xffffffffa05e1553 0xffffffffa05cb686 0xffffffffa052dad1 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa0541834 0xffffffffa051f20f 0xffffffffa05a170c 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa05d6b36 0xffffffffa05540c2 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa052ea98 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa0534220 0xffffffffa051b41c 0xffffffffa0543301 0xffffffffa054c68e 0xffffffffa056bd61 0xffffffffa04ac333 0xffffffffa04afb35 sys_lseek system_call_fastpath 0x7fb873dc30d0 __lseek64 | --- 0xffffffffa05cc921 0xffffffffa052eb68 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa0541310 0xffffffffa051f3b9 0xffffffffa05a17f1 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa05516e9 0xffffffffa0554cba 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa052c9c6 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa05cbb05 0xffffffffa052d8df 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa0551df9 0xffffffffa04c006c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa056f497 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05c9fa5 0xffffffffa052e9da 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa0541979 0xffffffffa05718be 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa052d22b 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa05cab79 0xffffffffa052e9a9 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa052cce0 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa051f4ce 0xffffffffa0541942 0xffffffffa05718be 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0534192 0xffffffffa05d2f17 0xffffffffa05d30c2 0xffffffffa05d3c79 0xffffffffa056bddb 0xffffffffa04ac333 0xffffffffa04afb35 sys_lseek system_call_fastpath 0x7fb873dc30d0 __lseek64 | --- 0xffffffffa0554bc3 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0547147 0xffffffffa052e8b1 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa055173c 0xffffffffa0554cba 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa052dfbd 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa05a68b6 0xffffffffa052eb10 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa05e12e4 0xffffffffa05e15e0 0xffffffffa05c2f84 0xffffffffa05cab91 0xffffffffa052e9a9 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa05e0937 0xffffffffa0551724 0xffffffffa0554cba 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05a67d7 0xffffffffa052eb10 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa052c930 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa051f2c1 0xffffffffa0560b17 0xffffffffa04aeb14 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa059ea69 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa0537287 0xffffffffa052aa2b 0xffffffffa052b575 0xffffffffa059ef64 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa05e095f 0xffffffffa052bd0b 0xffffffffa052d695 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa056f39f 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0551963 0xffffffffa0554cba 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05417f7 0xffffffffa051f20f 0xffffffffa05a170c 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa05d6b3d 0xffffffffa0555063 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05351b4 0xffffffffa055170e 0xffffffffa0553de1 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0571542 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0551e04 0xffffffffa04c006c 0xffffffffa0554e96 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05f5a41 0xffffffffa059ed4d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa053ac68 0xffffffffa051f34a 0xffffffffa0560b17 0xffffffffa04aeb14 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05a19c0 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa059d740 0xffffffffa05a17a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa052b8b7 0xffffffffa052d695 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa0541382 0xffffffffa0570c42 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa053b47c 0xffffffffa05419a3 0xffffffffa051f20f 0xffffffffa05a170c 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa059e8c4 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa0560b22 0xffffffffa04aeb14 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa056f2bf 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05cab7e 0xffffffffa052e9a9 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa05cab87 0xffffffffa052e9a9 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa0551df0 0xffffffffa04bffd4 0xffffffffa0554e96 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0541401 0xffffffffa0541939 0xffffffffa05718be 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa056f28a 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa056f4bf 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa053b4b2 0xffffffffa051ef0c 0xffffffffa059ecc9 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa056f193 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa054ba60 0xffffffffa04aea2b 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa052b1b4 0xffffffffa05a186d 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa052b003 0xffffffffa05a186d 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa05cc50c 0xffffffffa052eb68 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa05515d1 0xffffffffa0553de1 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa054199e 0xffffffffa056bdb4 0xffffffffa04ac333 0xffffffffa04afb35 sys_lseek system_call_fastpath 0x7fb873dc30d0 __lseek64 | --- 0xffffffffa056f0e3 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0534194 0xffffffffa0551537 0xffffffffa0553de1 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 6.95% 93 postgres postgres [.] CHashBucketScan | --- CHashBucketScan | |--84.96%-- CHashSearch | BufTableLookup | | | |--73.37%-- ReadBuffer_common | | ReadBufferExtended | | | | | |--51.69%-- _bt_relandgetbuf | | | _bt_search | | | _bt_first | | | | | | | |--90.01%-- btgettuple | | | | FunctionCall2Coll | | | | index_getnext_tid | | | | index_getnext | | | | IndexNext | | | | ExecScan | | | | ExecProcNode | | | | ExecNestLoop | | | | ExecProcNode | | | | ExecHashJoin | | | | ExecProcNode | | | | ExecNestLoop | | | | ExecProcNode | | | | ExecHashJoin | | | | ExecProcNode | | | | ExecAgg | | | | ExecProcNode | | | | ExecSort | | | | ExecProcNode | | | | standard_ExecutorRun | | | | ExplainOnePlan | | | | ExplainOneQuery | | | | ExplainQuery | | | | standard_ProcessUtility | | | | PortalRunUtility | | | | FillPortalStore | | | | PortalRun | | | | exec_simple_query | | | | PostgresMain | | | | ServerLoop | | | | PostmasterMain | | | | main | | | | __libc_start_main | | | | | | | --9.99%-- btgetbitmap | | | FunctionCall2Coll | | | index_getbitmap | | | MultiExecBitmapIndexScan | | | BitmapHeapNext | | | ExecScan | | | ExecProcNode | | | ExecNestLoop | | | ExecProcNode | | | ExecNestLoop | | | ExecProcNode | | | ExecHashJoin | | | ExecProcNode | | | ExecNestLoop | | | ExecProcNode | | | ExecHashJoin | | | ExecProcNode | | | ExecAgg | | | ExecProcNode | | | ExecSort | | | ExecProcNode | | | standard_ExecutorRun | | | ExplainOnePlan | | | ExplainOneQuery | | | ExplainQuery | | | standard_ProcessUtility | | | PortalRunUtility | | | FillPortalStore | | | PortalRun | | | exec_simple_query | | | PostgresMain | | | ServerLoop | | | PostmasterMain | | | main | | | __libc_start_main | | | | | |--34.50%-- index_fetch_heap | | | index_getnext | | | IndexNext | | | ExecScan | | | ExecProcNode | | | ExecNestLoop | | | ExecProcNode | | | ExecHashJoin | | | ExecProcNode | | | ExecNestLoop | | | ExecProcNode | | | ExecHashJoin | | | ExecProcNode | | | ExecAgg | | | ExecProcNode | | | ExecSort | | | ExecProcNode | | | standard_ExecutorRun | | | ExplainOnePlan | | | ExplainOneQuery | | | ExplainQuery | | | standard_ProcessUtility | | | PortalRunUtility | | | FillPortalStore | | | PortalRun | | | exec_simple_query | | | PostgresMain | | | ServerLoop | | | PostmasterMain | | | main | | | __libc_start_main | | | | | |--8.63%-- BitmapHeapNext | | | ExecScan | | | ExecProcNode | | | ExecNestLoop | | | ExecProcNode | | | | | | | |--79.94%-- ExecNestLoop | | | | ExecProcNode | | | | ExecHashJoin | | | | ExecProcNode | | | | ExecNestLoop | | | | ExecProcNode | | | | ExecHashJoin | | | | ExecProcNode | | | | ExecAgg | | | | ExecProcNode | | | | ExecSort | | | | ExecProcNode | | | | standard_ExecutorRun | | | | ExplainOnePlan | | | | ExplainOneQuery | | | | ExplainQuery | | | | standard_ProcessUtility | | | | PortalRunUtility | | | | FillPortalStore | | | | PortalRun | | | | exec_simple_query | | | | PostgresMain | | | | ServerLoop | | | | PostmasterMain | | | | main | | | | __libc_start_main | | | | | | | --20.06%-- MultiExecHash | | | ExecHashJoin | | | ExecProcNode | | | ExecNestLoop | | | ExecProcNode | | | ExecHashJoin | | | ExecProcNode | | | ExecAgg | | | ExecProcNode | | | ExecSort | | | ExecProcNode | | | standard_ExecutorRun | | | ExplainOnePlan | | | ExplainOneQuery | | | ExplainQuery | | | standard_ProcessUtility | | | PortalRunUtility | | | FillPortalStore | | | PortalRun | | | exec_simple_query | | | PostgresMain | | | ServerLoop | | | PostmasterMain | | | main | | | __libc_start_main | | | | | --5.18%-- _bt_getbuf | | _bt_getroot | | _bt_search | | _bt_first | | btgettuple | | FunctionCall2Coll | | index_getnext_tid | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --26.63%-- PrefetchBuffer | BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | | | |--61.76%-- ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --38.24%-- MultiExecHash | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --15.04%-- CHashDelete BufTableDelete ReadBuffer_common ReadBufferExtended | |--35.77%-- index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | | | |--80.08%-- ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --19.92%-- ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--35.69%-- BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --28.54%-- _bt_relandgetbuf _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 4.56% 1 postgres [kernel.kallsyms] [k] copy_user_generic_string | --- copy_user_generic_string | |--99.91%-- 0xffffffffa04bfedc | 0xffffffffa04c021c | | | |--62.29%-- 0xffffffffa0554e96 | | 0xffffffffa056facb | | 0xffffffffa04c61ab | | vfs_read | | sys_read | | system_call_fastpath | | 0x7fb873db55d0 | | __GI___read | | | --37.71%-- 0xffffffffa0553f90 | 0xffffffffa05715f4 | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read --0.09%-- [...] 4.34% 58 postgres postgres [.] _bt_compare | --- _bt_compare _bt_binsrch | |--63.81%-- _bt_first | | | |--97.30%-- btgettuple | | FunctionCall2Coll | | index_getnext_tid | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | | | | |--94.44%-- ExecNestLoop | | | ExecProcNode | | | ExecHashJoin | | | ExecProcNode | | | ExecAgg | | | ExecProcNode | | | ExecSort | | | ExecProcNode | | | standard_ExecutorRun | | | ExplainOnePlan | | | ExplainOneQuery | | | ExplainQuery | | | standard_ProcessUtility | | | PortalRunUtility | | | FillPortalStore | | | PortalRun | | | exec_simple_query | | | PostgresMain | | | ServerLoop | | | PostmasterMain | | | main | | | __libc_start_main | | | | | --5.56%-- ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --2.70%-- btgetbitmap | FunctionCall2Coll | index_getbitmap | MultiExecBitmapIndexScan | BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --36.19%-- _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 3.69% 49 postgres postgres [.] HeapTupleSatisfiesMVCC | --- HeapTupleSatisfiesMVCC | |--93.91%-- BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--4.05%-- heap_hot_search_buffer | | | |--50.10%-- BitmapHeapNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --49.90%-- index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --2.03%-- ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 2.41% 32 postgres postgres [.] slot_deform_tuple | --- slot_deform_tuple | |--87.57%-- slot_getattr | ExecMakeFunctionResultNoSets | ExecQual | | | |--85.82%-- BitmapHeapNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | MultiExecHash | | ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --14.18%-- ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --12.43%-- slot_getsomeattrs ExecProject ExecNestLoop ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 2.02% 27 postgres postgres [.] PinBuffer | --- PinBuffer ReadBuffer_common ReadBufferExtended | |--40.71%-- _bt_relandgetbuf | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--29.65%-- BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | | | |--50.13%-- MultiExecHash | | ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --49.87%-- ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--25.93%-- index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --3.71%-- _bt_getbuf _bt_getroot _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.88% 25 postgres [kernel.kallsyms] [k] page_fault | --- page_fault | |--39.66%-- 0x49f6c7 | heap_page_prune_opt | | | |--66.60%-- ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | |--16.72%-- _bt_binsrch | | | --16.68%-- 0x7fb66cbf68c0 | 0x4134 | |--31.73%-- copy_user_generic_string | 0xffffffffa04bfedc | 0xffffffffa04c021c | | | |--75.01%-- 0xffffffffa0553f90 | | 0xffffffffa05715f4 | | 0xffffffffa04c61ab | | vfs_read | | sys_read | | system_call_fastpath | | 0x7fb873db55d0 | | __GI___read | | | --24.99%-- 0xffffffffa0554e96 | 0xffffffffa056facb | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | |--11.90%-- 0x49d348 | heap_hot_search_buffer | | | |--66.71%-- BitmapHeapNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --33.29%-- ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--8.76%-- 0x7a5772 | HeapTupleSatisfiesMVCC | BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--3.98%-- 0x6777d7 | StrategyGetBuffer | BitmapHeapNext | ExecProject | 0xd2a7c8 | 0xd141e0 | --3.97%-- 0x68eed0 LWLockAttemptLock ReadBuffer_common ReadBufferExtended _bt_relandgetbuf _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.72% 23 postgres postgres [.] LWLockAttemptLock | --- LWLockAttemptLock LWLockAcquire | |--65.26%-- _bt_relandgetbuf | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--17.37%-- BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--4.36%-- StartBufferIO | ReadBuffer_common | ReadBufferExtended | BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--4.35%-- index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--4.34%-- _bt_next | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --4.32%-- _bt_getbuf _bt_getroot _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.50% 20 postgres postgres [.] heap_page_prune_opt | --- heap_page_prune_opt | |--65.04%-- BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | | | |--53.75%-- ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --46.25%-- MultiExecHash | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --34.96%-- index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.50% 20 postgres postgres [.] heap_hot_search_buffer | --- heap_hot_search_buffer | |--59.98%-- index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | | | |--83.32%-- ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --16.68%-- ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --40.02%-- BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.42% 19 postgres postgres [.] CHashInsert | --- CHashInsert BufTableInsert ReadBuffer_common ReadBufferExtended | |--57.88%-- BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--31.58%-- _bt_relandgetbuf | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --10.54%-- index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.28% 17 postgres postgres [.] BitmapHeapNext | --- BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode | |--82.39%-- MultiExecHash | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --17.61%-- ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.14% 12 postgres [kernel.kallsyms] [k] mem_cgroup_update_page_stat | --- mem_cgroup_update_page_stat | |--78.65%-- __do_fault | handle_pte_fault | do_page_fault | page_fault | | | |--33.35%-- 0x49d348 | | heap_hot_search_buffer | | | | | |--74.98%-- index_fetch_heap | | | index_getnext | | | IndexNext | | | ExecScan | | | ExecProcNode | | | ExecNestLoop | | | ExecProcNode | | | ExecHashJoin | | | ExecProcNode | | | ExecNestLoop | | | ExecProcNode | | | ExecHashJoin | | | ExecProcNode | | | ExecAgg | | | ExecProcNode | | | ExecSort | | | ExecProcNode | | | standard_ExecutorRun | | | ExplainOnePlan | | | ExplainOneQuery | | | ExplainQuery | | | standard_ProcessUtility | | | PortalRunUtility | | | FillPortalStore | | | PortalRun | | | exec_simple_query | | | PostgresMain | | | ServerLoop | | | PostmasterMain | | | main | | | __libc_start_main | | | | | --25.02%-- BitmapHeapNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | |--33.33%-- 0x49f6c7 | | heap_page_prune_opt | | | | | |--50.03%-- index_fetch_heap | | | index_getnext | | | IndexNext | | | ExecScan | | | ExecProcNode | | | ExecNestLoop | | | ExecProcNode | | | ExecHashJoin | | | ExecProcNode | | | ExecNestLoop | | | ExecProcNode | | | ExecHashJoin | | | ExecProcNode | | | ExecAgg | | | ExecProcNode | | | ExecSort | | | ExecProcNode | | | standard_ExecutorRun | | | ExplainOnePlan | | | ExplainOneQuery | | | ExplainQuery | | | standard_ProcessUtility | | | PortalRunUtility | | | FillPortalStore | | | PortalRun | | | exec_simple_query | | | PostgresMain | | | ServerLoop | | | PostmasterMain | | | main | | | __libc_start_main | | | | | --49.97%-- BitmapHeapNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --33.32%-- copy_user_generic_string | 0xffffffffa04bfedc | 0xffffffffa04c021c | | | |--50.14%-- 0xffffffffa0553f90 | | 0xffffffffa05715f4 | | 0xffffffffa04c61ab | | vfs_read | | sys_read | | system_call_fastpath | | 0x7fb873db55d0 | | __GI___read | | | --49.86%-- 0xffffffffa0554e96 | 0xffffffffa056facb | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --21.35%-- zap_pte_range unmap_page_range unmap_vmas exit_mmap mmput exit_mm do_exit do_group_exit sys_exit_group system_call_fastpath 0x7fb873d90a38 1.05% 14 postgres [kernel.kallsyms] [k] find_get_page | --- find_get_page find_lock_page shmem_getpage_gfp shmem_fault __do_fault handle_pte_fault do_page_fault page_fault | |--50.05%-- copy_user_generic_string | 0xffffffffa04bfedc | 0xffffffffa04c021c | | | |--85.73%-- 0xffffffffa0554e96 | | 0xffffffffa056facb | | 0xffffffffa04c61ab | | vfs_read | | sys_read | | system_call_fastpath | | 0x7fb873db55d0 | | __GI___read | | | --14.27%-- 0xffffffffa0553f90 | 0xffffffffa05715f4 | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | |--35.67%-- 0x49f6c7 | heap_page_prune_opt | | | |--79.98%-- BitmapHeapNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --20.02%-- index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--7.17%-- 0x7a5772 | HeapTupleSatisfiesMVCC | BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --7.12%-- 0x49d348 heap_hot_search_buffer BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.97% 13 postgres postgres [.] ExecMakeFunctionResultNoSets | --- ExecMakeFunctionResultNoSets | |--84.69%-- ExecQual | BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--7.66%-- ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --7.65%-- ExecMakeFunctionResultNoSets ExecProject advance_aggregates ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.97% 13 postgres [kernel.kallsyms] [k] radix_tree_lookup_slot | --- radix_tree_lookup_slot find_get_page | |--92.28%-- find_lock_page | shmem_getpage_gfp | shmem_fault | __do_fault | handle_pte_fault | do_page_fault | page_fault | | | |--49.94%-- 0x49f6c7 | | heap_page_prune_opt | | | | | |--50.04%-- BitmapHeapNext | | | ExecScan | | | ExecProcNode | | | ExecNestLoop | | | ExecProcNode | | | ExecNestLoop | | | ExecProcNode | | | ExecHashJoin | | | ExecProcNode | | | ExecNestLoop | | | ExecProcNode | | | ExecHashJoin | | | ExecProcNode | | | ExecAgg | | | ExecProcNode | | | ExecSort | | | ExecProcNode | | | standard_ExecutorRun | | | ExplainOnePlan | | | ExplainOneQuery | | | ExplainQuery | | | standard_ProcessUtility | | | PortalRunUtility | | | FillPortalStore | | | PortalRun | | | exec_simple_query | | | PostgresMain | | | ServerLoop | | | PostmasterMain | | | main | | | __libc_start_main | | | | | --49.96%-- index_fetch_heap | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | |--33.40%-- copy_user_generic_string | | 0xffffffffa04bfedc | | 0xffffffffa04c021c | | | | | |--75.01%-- 0xffffffffa0554e96 | | | 0xffffffffa056facb | | | 0xffffffffa04c61ab | | | vfs_read | | | sys_read | | | system_call_fastpath | | | 0x7fb873db55d0 | | | __GI___read | | | | | --24.99%-- 0xffffffffa0553f90 | | 0xffffffffa05715f4 | | 0xffffffffa04c61ab | | vfs_read | | sys_read | | system_call_fastpath | | 0x7fb873db55d0 | | __GI___read | | | |--8.35%-- 0x49d348 | | heap_hot_search_buffer | | BitmapHeapNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --8.31%-- 0x6777d7 | StrategyGetBuffer | ReadBuffer_common | ReadBufferExtended | _bt_relandgetbuf | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --7.72%-- filemap_fault __do_fault handle_pte_fault do_page_fault page_fault 0x72d8d0 get_rule_expr show_sort_group_keys ExplainNode ExplainPrintPlan ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.90% 12 postgres postgres [.] GetPrivateRefCountEntry | --- GetPrivateRefCountEntry | |--33.44%-- ReleaseBuffer | | | |--75.03%-- ExecClearTuple | | BitmapHeapNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | MultiExecHash | | ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --24.97%-- _bt_steppage | _bt_next | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--24.96%-- PinBuffer | ReadBuffer_common | ReadBufferExtended | _bt_relandgetbuf | _bt_search | _bt_first | | | |--66.73%-- btgettuple | | FunctionCall2Coll | | index_getnext_tid | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --33.27%-- btgetbitmap | FunctionCall2Coll | index_getbitmap | MultiExecBitmapIndexScan | BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--16.67%-- UnpinBuffer | | | |--50.03%-- ExecClearTuple | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --49.97%-- ReleaseAndReadBuffer | _bt_relandgetbuf | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--16.64%-- IncrBufferRefCount | ExecStoreTuple | | | |--50.28%-- BitmapHeapNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | MultiExecHash | | ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --49.72%-- IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --8.29%-- ReleaseAndReadBuffer _bt_relandgetbuf _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.90% 12 postgres [kernel.kallsyms] [k] __memcpy | --- __memcpy 0xffffffffa04aaf69 0xffffffffa052df93 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise 0.83% 48 swapper [kernel.kallsyms] [k] intel_idle | --- intel_idle cpuidle_idle_call cpu_idle | --100.00%-- start_kernel x86_64_start_kernel 0.83% 11 postgres postgres [.] slot_getattr | --- slot_getattr ExecMakeFunctionResultNoSets ExecQual | |--82.03%-- BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --17.97%-- ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.83% 11 postgres postgres [.] ExecClearTuple | --- ExecClearTuple | |--63.65%-- BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--27.28%-- ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --9.07%-- ExecProject ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.82% 11 postgres [kernel.kallsyms] [k] __do_fault | --- __do_fault handle_pte_fault do_page_fault page_fault | |--54.58%-- copy_user_generic_string | 0xffffffffa04bfedc | 0xffffffffa04c021c | | | |--66.68%-- 0xffffffffa0554e96 | | 0xffffffffa056facb | | 0xffffffffa04c61ab | | vfs_read | | sys_read | | system_call_fastpath | | 0x7fb873db55d0 | | __GI___read | | | --33.32%-- 0xffffffffa0553f90 | 0xffffffffa05715f4 | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | |--27.24%-- 0x49f6c7 | heap_page_prune_opt | index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --18.18%-- 0x49d348 heap_hot_search_buffer | |--50.10%-- BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.90%-- index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.82% 11 postgres postgres [.] btint4cmp | --- btint4cmp | |--54.55%-- FunctionCall2Coll | _bt_compare | _bt_binsrch | | | |--83.34%-- _bt_search | | _bt_first | | btgettuple | | FunctionCall2Coll | | index_getnext_tid | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --16.66%-- _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --45.45%-- _bt_compare | |--79.99%-- _bt_binsrch | | | |--50.05%-- _bt_first | | btgettuple | | FunctionCall2Coll | | index_getnext_tid | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --49.95%-- _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --20.01%-- _bt_moveright _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.75% 10 postgres postgres [.] CHashSearch | --- CHashSearch | |--90.02%-- BufTableLookup | | | |--66.58%-- ReadBuffer_common | | ReadBufferExtended | | | | | |--50.06%-- _bt_getbuf | | | _bt_getroot | | | _bt_search | | | _bt_first | | | btgettuple | | | FunctionCall2Coll | | | index_getnext_tid | | | index_getnext | | | IndexNext | | | ExecScan | | | ExecProcNode | | | ExecNestLoop | | | ExecProcNode | | | ExecHashJoin | | | ExecProcNode | | | ExecNestLoop | | | ExecProcNode | | | ExecHashJoin | | | ExecProcNode | | | ExecAgg | | | ExecProcNode | | | ExecSort | | | ExecProcNode | | | standard_ExecutorRun | | | ExplainOnePlan | | | ExplainOneQuery | | | ExplainQuery | | | standard_ProcessUtility | | | PortalRunUtility | | | FillPortalStore | | | PortalRun | | | exec_simple_query | | | PostgresMain | | | ServerLoop | | | PostmasterMain | | | main | | | __libc_start_main | | | | | |--33.29%-- _bt_relandgetbuf | | | _bt_search | | | _bt_first | | | btgettuple | | | FunctionCall2Coll | | | index_getnext_tid | | | index_getnext | | | IndexNext | | | ExecScan | | | ExecProcNode | | | ExecNestLoop | | | ExecProcNode | | | ExecHashJoin | | | ExecProcNode | | | ExecNestLoop | | | ExecProcNode | | | ExecHashJoin | | | ExecProcNode | | | ExecAgg | | | ExecProcNode | | | ExecSort | | | ExecProcNode | | | standard_ExecutorRun | | | ExplainOnePlan | | | ExplainOneQuery | | | ExplainQuery | | | standard_ProcessUtility | | | PortalRunUtility | | | FillPortalStore | | | PortalRun | | | exec_simple_query | | | PostgresMain | | | ServerLoop | | | PostmasterMain | | | main | | | __libc_start_main | | | | | --16.66%-- BitmapHeapNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --33.42%-- PrefetchBuffer | BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | | | |--66.62%-- ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --33.38%-- MultiExecHash | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --9.98%-- PrefetchBuffer BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.75% 10 postgres [kernel.kallsyms] [k] _raw_spin_lock | --- _raw_spin_lock __do_fault handle_pte_fault do_page_fault page_fault | |--59.88%-- 0x49f6c7 | heap_page_prune_opt | | | |--67.01%-- index_fetch_heap | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --32.99%-- BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--30.06%-- 0x49d348 | heap_hot_search_buffer | | | |--66.62%-- index_fetch_heap | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --33.38%-- BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --10.06%-- 0x7a5772 HeapTupleSatisfiesMVCC BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.71% 11 mmfsd [kernel.kallsyms] [k] find_busiest_group | --- find_busiest_group load_balance idle_balance thread_return | |--99.68%-- 0xffffffffa04a8b7d | 0xffffffffa05bf0f1 | 0xffffffffa05c0478 | 0xffffffffa0605afe | 0xffffffffa04c3c65 | do_vfs_ioctl | sys_ioctl | system_call_fastpath | 0x7ffb7c11f3d7 | 0x7ffb7c11f3d7 | 0xffffc900341c3998 --0.32%-- [...] 0.67% 9 postgres postgres [.] _bt_moveright | --- _bt_moveright | |--88.89%-- _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --11.11%-- _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.67% 9 postgres [vdso] [.] 0x7fffe8fff60a | --- 0x7fffe8fff8b1 ExecProcNode ExecNestLoop ExecProcNode | |--50.00%-- ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --50.00%-- ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff60a 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff8f5 __gettimeofday_internal ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff662 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff6ae 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecNestLoop ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff8d8 __gettimeofday_internal ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff665 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff8f9 __gettimeofday_internal ExecProcNode ExecNestLoop ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.67% 9 postgres postgres [.] ExecScanHashBucket | --- ExecScanHashBucket ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.60% 8 postgres postgres [.] ExecQual | --- ExecQual | |--50.15%-- BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--24.94%-- ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--12.46%-- ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --12.45%-- ExecNestLoop ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.60% 8 postgres [ipt_REJECT] [.] 0x5ef30188 | --- 0xffffffffff600188 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode | |--66.62%-- ExecNestLoop | ExecProcNode | | | |--75.02%-- ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --24.98%-- ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --33.38%-- MultiExecHash ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0xffffffffff600186 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.60% 8 postgres postgres [.] hash_search_with_hash_value | --- hash_search_with_hash_value | |--62.57%-- GetPrivateRefCountEntry | PinBuffer | ReadBuffer_common | ReadBufferExtended | | | |--40.07%-- BitmapHeapNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | MultiExecHash | | ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | |--39.96%-- _bt_relandgetbuf | | _bt_search | | _bt_first | | btgettuple | | FunctionCall2Coll | | index_getnext_tid | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --19.97%-- _bt_getbuf | _bt_getroot | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --37.43%-- tbm_get_pageentry tbm_add_tuples btgetbitmap FunctionCall2Coll index_getbitmap MultiExecBitmapIndexScan BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.54% 1 postgres [kernel.kallsyms] [k] 0xffffffff81152f94 | --- mem_cgroup_update_page_stat zap_pte_range unmap_page_range unmap_vmas exit_mmap mmput exit_mm do_exit do_group_exit sys_exit_group system_call_fastpath 0x7fb873d90a38 0.52% 7 postgres postgres [.] tbm_iterate | --- tbm_iterate | |--85.74%-- BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --14.26%-- ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.52% 7 postgres postgres [.] ExecNestLoop | --- ExecNestLoop ExecProcNode | |--57.21%-- ExecHashJoin | ExecProcNode | | | |--50.10%-- ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --49.90%-- ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --42.79%-- ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.47% 1 swapper [kernel.kallsyms] [k] update_group_power | --- update_group_power find_busiest_group load_balance rebalance_domains run_rebalance_domains __do_softirq call_softirq do_softirq irq_exit reschedule_interrupt intel_idle cpuidle_idle_call cpu_idle 0.45% 6 postgres postgres [.] pgstat_end_function_usage | --- pgstat_end_function_usage ExecMakeFunctionResultNoSets ExecQual BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.45% 6 postgres postgres [.] ExecEvalParamExec | --- ExecEvalParamExec | |--50.10%-- ExecMakeFunctionResultNoSets | ExecQual | BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--33.33%-- ExecQual | BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --16.57%-- ExecIndexEvalRuntimeKeys ExecReScanIndexScan ExecReScan ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.45% 6 postgres postgres [.] ExecEvalScalarVarFast | --- ExecEvalScalarVarFast | |--50.04%-- ExecMakeFunctionResultNoSets | ExecQual | | | |--66.61%-- ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --33.39%-- BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--16.67%-- ExecQual | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--16.65%-- ExecHashGetHashValue | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --16.64%-- ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.45% 6 postgres postgres [.] ExecProject | --- ExecProject | |--50.06%-- ExecProcNode | | | |--66.72%-- ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --33.28%-- ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.94%-- ExecNestLoop ExecProcNode | |--66.66%-- ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --33.34%-- ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.45% 6 postgres postgres [.] StrategyGetBuffer | --- StrategyGetBuffer | |--83.33%-- ReadBuffer_common | ReadBufferExtended | | | |--40.02%-- _bt_relandgetbuf | | _bt_search | | _bt_first | | btgettuple | | FunctionCall2Coll | | index_getnext_tid | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | |--40.02%-- index_fetch_heap | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --19.96%-- BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --16.67%-- ReadBufferExtended _bt_relandgetbuf _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.45% 6 postgres postgres [.] _bt_checkpage | --- _bt_checkpage | |--66.63%-- _bt_relandgetbuf | _bt_search | _bt_first | | | |--74.99%-- btgettuple | | FunctionCall2Coll | | index_getnext_tid | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --25.01%-- btgetbitmap | FunctionCall2Coll | index_getbitmap | MultiExecBitmapIndexScan | BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--16.69%-- _bt_getbuf | _bt_getroot | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --16.68%-- _bt_getroot _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.45% 2 fail2ban-server [unknown] [.] 0x7f4657d5edf4 | --- 0x7f4657173298 0x602010 0x602010 0x602010 0.44% 1 mmfsd [kernel.kallsyms] [k] pick_next_task_rt | --- pick_next_task_rt thread_return 0xffffffffa04a8b7d 0xffffffffa05bf0f1 0xffffffffa05c0478 0xffffffffa0605afe 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0xffffc900341c3998 0.40% 5 postgres [kernel.kallsyms] [k] zap_pte_range | --- zap_pte_range unmap_page_range unmap_vmas exit_mmap mmput exit_mm do_exit do_group_exit sys_exit_group system_call_fastpath 0x7fb873d90a38 0.40% 5 postgres [kernel.kallsyms] [k] do_page_fault | --- do_page_fault page_fault | |--37.77%-- 0x49d348 | heap_hot_search_buffer | index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--24.60%-- 0x674c50 | PinBuffer | ReadBuffer_common | ReadBufferExtended | BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--18.94%-- 0x7a5772 | HeapTupleSatisfiesMVCC | BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --18.68%-- copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0554e96 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.37% 5 postgres postgres [.] ExecStoreTuple | --- ExecStoreTuple | |--59.98%-- BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | | | |--66.76%-- MultiExecHash | | ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --33.24%-- ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--20.02%-- ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --20.00%-- IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.37% 5 postgres postgres [.] CheckForSerializableConflictOut | --- CheckForSerializableConflictOut | |--59.95%-- heap_hot_search_buffer | index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--20.03%-- ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --20.02%-- BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.37% 5 postgres postgres [.] ResourceOwnerForgetBuffer | --- ResourceOwnerForgetBuffer | |--40.05%-- ExecClearTuple | BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--39.92%-- ReleaseBuffer | | | |--50.02%-- ExecStoreTuple | | BitmapHeapNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --49.98%-- _bt_steppage | _bt_next | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --20.02%-- UnpinBuffer ReleaseAndReadBuffer BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.37% 5 postgres postgres [.] ResourceOwnerRememberBuffer | --- ResourceOwnerRememberBuffer | |--40.00%-- IncrBufferRefCount | ExecStoreTuple | BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | | | |--50.08%-- MultiExecHash | | ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --49.92%-- ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--39.96%-- ReadBuffer_common | ReadBufferExtended | | | |--50.05%-- _bt_getbuf | | _bt_getroot | | _bt_search | | _bt_first | | btgettuple | | FunctionCall2Coll | | index_getnext_tid | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --49.95%-- _bt_relandgetbuf | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --20.03%-- ExecStoreTuple BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.37% 5 postgres postgres [.] LWLockAcquire | --- LWLockAcquire | |--40.02%-- _bt_getbuf | _bt_getroot | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--20.04%-- BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--20.00%-- ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --19.94%-- index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.37% 5 postgres postgres [.] InstrStopNode | --- InstrStopNode | |--80.02%-- ExecProcNode | ExecNestLoop | ExecProcNode | | | |--50.01%-- ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | |--25.08%-- MultiExecHash | | ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --24.91%-- ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --19.98%-- ExecNestLoop ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.37% 5 postgres postgres [.] UnpinBuffer | --- UnpinBuffer | |--39.95%-- _bt_steppage | _bt_next | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--20.03%-- ReleaseAndReadBuffer | BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--20.03%-- ExecClearTuple | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --19.99%-- ExecStoreTuple BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.37% 5 postgres postgres [.] ReadBuffer_common | --- ReadBuffer_common ReadBufferExtended | |--60.05%-- _bt_relandgetbuf | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--20.00%-- _bt_getbuf | _bt_getroot | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --19.95%-- BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.37% 5 postgres [kernel.kallsyms] [k] handle_mm_fault | --- handle_mm_fault do_page_fault page_fault | |--60.01%-- 0x49f6c7 | heap_page_prune_opt | BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --39.99%-- copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.37% 5 postgres postgres [.] _bt_checkkeys | --- _bt_checkkeys | |--80.02%-- _bt_readpage | _bt_first | | | |--50.06%-- btgettuple | | FunctionCall2Coll | | index_getnext_tid | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --49.94%-- btgetbitmap | FunctionCall2Coll | index_getbitmap | MultiExecBitmapIndexScan | BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --19.98%-- _bt_first btgetbitmap FunctionCall2Coll index_getbitmap MultiExecBitmapIndexScan BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.37% 5 postgres postgres [.] ReadBufferExtended | --- ReadBufferExtended | |--40.00%-- index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | | | |--50.07%-- ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --49.93%-- ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--20.08%-- BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--20.00%-- _bt_getroot | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --19.92%-- _bt_relandgetbuf _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.37% 5 postgres postgres [.] _bt_first | --- _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode | |--79.96%-- ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --20.04%-- ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.35% 4 postgres [kernel.kallsyms] [k] page_remove_rmap | --- page_remove_rmap zap_pte_range unmap_page_range unmap_vmas exit_mmap mmput exit_mm do_exit do_group_exit sys_exit_group system_call_fastpath 0x7fb873d90a38 0.34% 1 postgres [kernel.kallsyms] [k] _raw_spin_unlock_irqrestore | --- _raw_spin_unlock_irqrestore | |--44.64%-- 0xffffffffa0560b7f | 0xffffffffa04aeb14 | 0xffffffffa04c602f | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | |--22.35%-- 0xffffffffa0541942 | 0xffffffffa05718be | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | |--22.31%-- 0xffffffffa059eb0c | 0xffffffffa05a18a9 | 0xffffffffa05a1a2d | 0xffffffffa04b565a | read_pages | __do_page_cache_readahead | force_page_cache_readahead | sys_fadvise64_64 | system_call_fastpath | 0x7fb873db9e5d | posix_fadvise | --10.69%-- poll_freewait do_sys_poll sys_poll system_call_fastpath 0x7fb873db9b8f __libc_poll 0.31% 1 swapper [kernel.kallsyms] [k] _raw_spin_lock_irqsave | --- _raw_spin_lock_irqsave __wake_up credit_entropy_bits add_interrupt_randomness handle_irq_event_percpu handle_irq_event handle_edge_irq handle_irq do_IRQ ret_from_intr intel_idle cpuidle_idle_call cpu_idle 0.30% 4 postgres postgres [.] MemoryContextReset | --- MemoryContextReset | |--50.05%-- BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--25.02%-- ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --24.93%-- ExecReScan ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.30% 4 postgres postgres [.] isTempToastNamespace | --- isTempToastNamespace IsCatalogClass heap_page_prune_opt | |--75.08%-- BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | | | |--66.78%-- MultiExecHash | | ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --33.22%-- ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --24.92%-- index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.30% 4 postgres postgres [.] ExecScan | --- ExecScan ExecProcNode ExecNestLoop ExecProcNode | |--75.01%-- ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --24.99%-- ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.30% 4 postgres postgres [.] hash_any | --- hash_any | |--75.09%-- CHashSearch | BufTableLookup | ReadBuffer_common | ReadBufferExtended | | | |--33.35%-- _bt_relandgetbuf | | _bt_search | | _bt_first | | btgettuple | | FunctionCall2Coll | | index_getnext_tid | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | |--33.33%-- index_fetch_heap | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --33.32%-- BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --24.91%-- CHashInsert BufTableInsert ReadBuffer_common ReadBufferExtended _bt_relandgetbuf _bt_search _bt_first btgetbitmap FunctionCall2Coll index_getbitmap MultiExecBitmapIndexScan BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.30% 4 postgres postgres [.] InstrEndLoop | --- InstrEndLoop | |--74.95%-- ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --25.05%-- ExecReScan ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.30% 4 postgres [kernel.kallsyms] [k] _raw_spin_lock_irqsave | --- _raw_spin_lock_irqsave | |--50.03%-- up | | | |--50.03%-- 0xffffffffa0513c8d | | 0xffffffffa059eaa9 | | 0xffffffffa05a18a9 | | 0xffffffffa05a1a2d | | 0xffffffffa04b565a | | read_pages | | __do_page_cache_readahead | | force_page_cache_readahead | | sys_fadvise64_64 | | system_call_fastpath | | 0x7fb873db9e5d | | posix_fadvise | | | --49.97%-- 0xffffffffa0570c42 | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --49.97%-- down 0xffffffffa04a89cf | |--50.12%-- 0xffffffffa0513b5f | 0xffffffffa059eb1e | 0xffffffffa05a18a9 | 0xffffffffa05a1a2d | 0xffffffffa04b565a | read_pages | __do_page_cache_readahead | force_page_cache_readahead | sys_fadvise64_64 | system_call_fastpath | 0x7fb873db9e5d | posix_fadvise | --49.88%-- 0xffffffffa051f54e 0xffffffffa0541346 0xffffffffa0570c42 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.30% 4 postgres postgres [.] FunctionCall2Coll | --- FunctionCall2Coll | |--50.07%-- _bt_compare | _bt_binsrch | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--25.00%-- _bt_binsrch | _bt_search | _bt_first | btgetbitmap | FunctionCall2Coll | index_getbitmap | MultiExecBitmapIndexScan | BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --24.93%-- index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.27% 1 postgres postgres [.] relation_open | --- relation_open heap_open CatalogCacheInitializeCache SearchCatCache GetSysCacheOid get_role_oid hba_getauthmethod ClientAuthentication InitPostgres PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.23% 3 postgres postgres [.] TransactionIdPrecedes | --- TransactionIdPrecedes XidInMVCCSnapshot HeapTupleSatisfiesMVCC BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.23% 3 postgres postgres [.] IncrBufferRefCount | --- IncrBufferRefCount ExecStoreTuple BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.23% 3 postgres postgres [.] ExecHashTableInsert | --- ExecHashTableInsert MultiExecHash ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.22% 3 postgres postgres [.] ResourceOwnerEnlargeBuffers | --- ResourceOwnerEnlargeBuffers | |--66.74%-- IncrBufferRefCount | ExecStoreTuple | BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --33.26%-- ReadBuffer_common ReadBufferExtended _bt_relandgetbuf _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.22% 3 postgres postgres [.] FunctionCall5Coll | --- FunctionCall5Coll | |--66.68%-- ExecReScanIndexScan | ExecReScan | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --33.32%-- index_rescan ExecReScanIndexScan ExecReScan ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.22% 3 postgres postgres [.] ExecProcNode | --- ExecProcNode | |--66.69%-- ExecNestLoop | ExecProcNode | | | |--50.05%-- ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --49.95%-- ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --33.31%-- ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.22% 3 postgres postgres [.] LWLockRelease | --- LWLockRelease | |--33.37%-- ReadBufferExtended | BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--33.35%-- index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --33.28%-- ReadBuffer_common ReadBufferExtended BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.22% 3 postgres libc-2.11.3.so [.] __GI_memcpy | --- __GI_memcpy | |--66.54%-- BufTableLookup | ReadBuffer_common | ReadBufferExtended | | | |--50.08%-- _bt_getbuf | | _bt_getroot | | _bt_search | | _bt_first | | btgettuple | | FunctionCall2Coll | | index_getnext_tid | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --49.92%-- BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --33.46%-- MultiExecHash ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.22% 3 postgres [kernel.kallsyms] [k] shmem_fault | --- shmem_fault __do_fault handle_pte_fault do_page_fault page_fault | |--66.52%-- copy_user_generic_string | 0xffffffffa04bfedc | 0xffffffffa04c021c | 0xffffffffa0554e96 | 0xffffffffa056facb | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --33.48%-- 0x7a5772 HeapTupleSatisfiesMVCC BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.22% 3 postgres libc-2.11.3.so [.] __malloc | --- __malloc hash_create tbm_create_pagetable tbm_get_pageentry tbm_add_tuples btgetbitmap FunctionCall2Coll index_getbitmap MultiExecBitmapIndexScan BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.22% 3 postgres [kernel.kallsyms] [k] lookup_page_cgroup | --- lookup_page_cgroup mem_cgroup_update_page_stat __do_fault handle_pte_fault do_page_fault page_fault | |--66.74%-- 0x49d348 | heap_hot_search_buffer | index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --33.26%-- copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.22% 3 postgres postgres [.] index_getprocinfo | --- index_getprocinfo _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.22% 3 postgres postgres [.] _bt_binsrch | --- _bt_binsrch | |--66.67%-- _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --33.33%-- _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.22% 3 postgres postgres [.] BufTableLookup | --- BufTableLookup ReadBuffer_common ReadBufferExtended | |--66.74%-- index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --33.26%-- _bt_relandgetbuf _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.22% 3 postgres [kernel.kallsyms] [k] page_add_file_rmap | --- page_add_file_rmap __do_fault handle_pte_fault do_page_fault page_fault | |--66.57%-- 0x49f6c7 | heap_page_prune_opt | | | |--50.01%-- BitmapHeapNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --49.99%-- index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --33.43%-- copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.22% 3 postgres [kernel.kallsyms] [k] getnstimeofday | --- getnstimeofday 0xffffffffa04a8d10 | |--66.68%-- 0xffffffffa052cab3 | 0xffffffffa059f09d | 0xffffffffa05a18a9 | 0xffffffffa05a1a2d | 0xffffffffa04b565a | read_pages | __do_page_cache_readahead | force_page_cache_readahead | sys_fadvise64_64 | system_call_fastpath | 0x7fb873db9e5d | posix_fadvise | --33.32%-- 0xffffffffa0554b33 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.22% 3 postgres postgres [.] hash_seq_search | --- hash_seq_search tbm_begin_iterate BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.22% 3 postgres postgres [.] DataChecksumsEnabled | --- DataChecksumsEnabled ReadBuffer_common ReadBufferExtended | |--33.44%-- index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--33.31%-- _bt_relandgetbuf | _bt_search | _bt_first | btgetbitmap | FunctionCall2Coll | index_getbitmap | MultiExecBitmapIndexScan | BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --33.25%-- BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.22% 3 postgres [kernel.kallsyms] [k] mem_cgroup_count_vm_event | --- mem_cgroup_count_vm_event handle_mm_fault do_page_fault page_fault | |--33.60%-- 0x49f6c7 | heap_page_prune_opt | BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--33.51%-- copy_user_generic_string | 0xffffffffa04bfedc | 0xffffffffa04c021c | 0xffffffffa0553f90 | 0xffffffffa05715f4 | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --32.89%-- 0x49d348 heap_hot_search_buffer index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.15% 1 postgres libc-2.11.3.so [.] __GI___read | --- __GI___read | |--96.35%-- mdread | ReadBuffer_common | ReadBufferExtended | BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --3.65%-- BackgroundWriterMain AuxiliaryProcessMain StartChildProcess reaper __restore_rt PostmasterMain main __libc_start_main 0.15% 2 postgres postgres [.] pgstat_init_function_usage | --- pgstat_init_function_usage | |--50.89%-- ExecMakeFunctionResultNoSets | ExecQual | BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.11%-- ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.15% 2 postgres [kernel.kallsyms] [k] mark_page_accessed | --- mark_page_accessed zap_pte_range unmap_page_range unmap_vmas exit_mmap mmput exit_mm do_exit do_group_exit sys_exit_group system_call_fastpath 0x7fb873d90a38 0.15% 2 postgres postgres [.] check_stack_depth | --- check_stack_depth ExecMakeFunctionResultNoSets ExecQual BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.15% 2 postgres postgres [.] heap_form_minimal_tuple | --- heap_form_minimal_tuple ExecFetchSlotMinimalTuple ExecHashTableInsert MultiExecHash ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.15% 2 postgres [kernel.kallsyms] [k] find_vma | --- find_vma do_page_fault page_fault copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c | |--50.00%-- 0xffffffffa0553f90 | 0xffffffffa05715f4 | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --50.00%-- 0xffffffffa0554e96 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.15% 2 postgres [kernel.kallsyms] [k] vfs_read | --- vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.15% 2 postgres postgres [.] advance_aggregates | --- advance_aggregates | |--50.02%-- ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.98%-- ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.15% 2 postgres postgres [.] InstrStartNode | --- InstrStartNode | |--50.02%-- ExecNestLoop | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.98%-- ExecProcNode ExecNestLoop ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.15% 2 postgres libc-2.11.3.so [.] __lseek64 | --- __lseek64 mdread ReadBuffer_common ReadBufferExtended BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.15% 2 postgres postgres [.] ShutdownExprContext | --- ShutdownExprContext ExecReScan ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.15% 2 postgres postgres [.] TerminateBufferIO | --- TerminateBufferIO | |--50.03%-- ReadBufferExtended | BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.97%-- ReadBuffer_common ReadBufferExtended BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.15% 2 postgres [kernel.kallsyms] [k] __kmalloc | --- __kmalloc 0xffffffffa04ade30 | |--50.00%-- 0xffffffffa05a19ed | 0xffffffffa04b565a | read_pages | __do_page_cache_readahead | force_page_cache_readahead | sys_fadvise64_64 | system_call_fastpath | 0x7fb873db9e5d | posix_fadvise | --50.00%-- 0xffffffffa05a1638 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise 0.15% 2 postgres postgres [.] IndexNext | --- IndexNext | |--50.07%-- ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.93%-- ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.15% 2 postgres postgres [.] timestamp_part | --- timestamp_part ExecMakeFunctionResultNoSets ExecProject ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.15% 2 postgres postgres [.] ReleaseBuffer | --- ReleaseBuffer ExecClearTuple | |--50.18%-- BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.82%-- ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.15% 2 postgres postgres [.] _bt_preprocess_keys | --- _bt_preprocess_keys _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.15% 2 postgres [kernel.kallsyms] [k] up_read | --- up_read do_page_fault page_fault | |--50.09%-- 0x49d348 | heap_hot_search_buffer | BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.91%-- copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.15% 2 postgres [kernel.kallsyms] [k] get_page_from_freelist | --- get_page_from_freelist __alloc_pages_nodemask alloc_pages_current __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise 0.15% 2 postgres postgres [.] ReleaseAndReadBuffer | --- ReleaseAndReadBuffer | |--50.01%-- BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.99%-- index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.15% 2 postgres postgres [.] CHashAddToGarbage | --- CHashAddToGarbage CHashDelete BufTableDelete ReadBuffer_common ReadBufferExtended BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.15% 2 postgres postgres [.] ExecHashJoin | --- ExecHashJoin ExecProcNode | |--50.15%-- ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.85%-- ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.15% 2 postgres [kernel.kallsyms] [k] radix_tree_lookup | --- radix_tree_lookup __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise 0.15% 2 postgres [kernel.kallsyms] [k] down | --- down 0xffffffffa04a89cf 0xffffffffa051f54e | |--50.04%-- 0xffffffffa053ac4a | 0xffffffffa051f34a | 0xffffffffa0560b17 | 0xffffffffa04aeb14 | 0xffffffffa04c602f | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --49.96%-- 0xffffffffa0541346 0xffffffffa0560b7f 0xffffffffa04aeb14 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.15% 2 postgres postgres [.] AllocSetAlloc | --- AllocSetAlloc _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.15% 2 postgres postgres [.] _bt_preprocess_array_keys | --- _bt_preprocess_array_keys btrescan FunctionCall5Coll index_rescan ExecReScanIndexScan ExecReScan ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.15% 2 postgres [kernel.kallsyms] [k] common_file_perm | --- common_file_perm security_file_permission rw_verify_area vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.15% 2 postgres postgres [.] btrescan | --- btrescan FunctionCall5Coll index_rescan ExecReScanIndexScan ExecReScan ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.15% 2 postgres [kernel.kallsyms] [k] blk_flush_plug_list | --- blk_flush_plug_list blk_finish_plug read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise 0.15% 2 postgres postgres [.] _bt_getroot | --- _bt_getroot | |--50.02%-- _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.98%-- _bt_first btgetbitmap FunctionCall2Coll index_getbitmap MultiExecBitmapIndexScan BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.15% 2 postgres [kernel.kallsyms] [k] system_call_after_swapgs | --- system_call_after_swapgs | |--50.31%-- 0x7fb873dc30d0 | __lseek64 | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.69%-- heap_hot_search_buffer BitmapHeapNext ExecProject 0xd2a7c8 0xd141e0 0.15% 2 postgres [kernel.kallsyms] [k] __rmqueue | --- __rmqueue get_page_from_freelist __alloc_pages_nodemask alloc_pages_current __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise 0.14% 10 postgres postgres [.] SyncOneBuffer | --- SyncOneBuffer BgBufferSync BackgroundWriterMain AuxiliaryProcessMain StartChildProcess reaper __restore_rt PostmasterMain main __libc_start_main 0.14% 1 ksoftirqd/0 [kernel.kallsyms] [k] perf_mmap_free_page | --- perf_mmap_free_page rb_free rcu_do_batch rcu_process_callbacks __do_softirq run_ksoftirqd kthread kernel_thread_helper 0.11% 1 postgres [kernel.kallsyms] [k] find_lock_page | --- find_lock_page shmem_getpage_gfp shmem_fault __do_fault handle_pte_fault do_page_fault page_fault 0x7a5772 HeapTupleSatisfiesMVCC BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.10% 1 postgres [kernel.kallsyms] [k] __dec_zone_page_state | --- __dec_zone_page_state page_remove_rmap zap_pte_range unmap_page_range unmap_vmas exit_mmap mmput exit_mm do_exit do_group_exit sys_exit_group system_call_fastpath 0x7fb873d90a38 0.08% 1 postgres [kernel.kallsyms] [k] release_pages | --- release_pages free_pages_and_swap_cache tlb_flush_mmu zap_pte_range unmap_page_range unmap_vmas exit_mmap mmput exit_mm do_exit do_group_exit sys_exit_group system_call_fastpath 0x7fb873d90a38 0.08% 1 postgres [kernel.kallsyms] [k] get_pageblock_flags_group | --- get_pageblock_flags_group free_hot_cold_page __pagevec_free release_pages free_pages_and_swap_cache tlb_flush_mmu tlb_finish_mmu exit_mmap mmput exit_mm do_exit do_group_exit sys_exit_group system_call_fastpath 0x7fb873d90a38 0.08% 1 postgres postgres [.] ExecFetchSlotMinimalTuple | --- ExecFetchSlotMinimalTuple ExecHashTableInsert MultiExecHash ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.08% 1 postgres postgres [.] dense_alloc | --- dense_alloc ExecHashTableInsert MultiExecHash ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.08% 1 postgres postgres [.] AllocSetFree | --- AllocSetFree ExecClearTuple ExecProject ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.08% 1 postgres libc-2.11.3.so [.] __GI_memset | --- __GI_memset heap_form_minimal_tuple ExecFetchSlotMinimalTuple ExecHashTableInsert MultiExecHash ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.08% 1 postgres postgres [.] int4eq | --- int4eq ExecQual BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.08% 1 postgres [kernel.kallsyms] [k] sched_avg_update | --- sched_avg_update update_cpu_load scheduler_tick update_process_times tick_sched_timer __run_hrtimer hrtimer_interrupt smp_apic_timer_interrupt apic_timer_interrupt 0x4acf13 _bt_binsrch _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres [kernel.kallsyms] [k] __task_pid_nr_ns | --- __task_pid_nr_ns 0xffffffffa04bfec2 0xffffffffa04c021c 0xffffffffa0554e96 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.07% 1 postgres [kernel.kallsyms] [k] security_file_permission | --- security_file_permission vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.07% 1 postgres [kernel.kallsyms] [k] handle_pte_fault | --- handle_pte_fault do_page_fault page_fault 0x49d348 heap_hot_search_buffer BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres postgres [.] fmgr_info_copy | --- fmgr_info_copy _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres [kernel.kallsyms] [k] mem_cgroup_cache_charge | --- mem_cgroup_cache_charge add_to_page_cache_locked add_to_page_cache add_to_page_cache_lru read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise 0.07% 1 postgres [kernel.kallsyms] [k] mem_cgroup_add_lru_list | --- mem_cgroup_add_lru_list pagevec_lru_move_fn __lru_cache_add add_to_page_cache_lru read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise 0.07% 1 postgres [kernel.kallsyms] [k] fget | --- fget sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise 0.07% 1 postgres [kernel.kallsyms] [k] file_update_time | --- file_update_time __do_fault handle_pte_fault do_page_fault page_fault copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0554e96 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.07% 1 postgres [kernel.kallsyms] [k] __cache_free | --- __cache_free kfree 0xffffffffa05a17f1 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise 0.07% 1 postgres postgres [.] TupleHashTableHash | --- TupleHashTableHash hash_search LookupTupleHashEntry ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres postgres [.] hash_uint32 | --- hash_uint32 hash_search GetPrivateRefCountEntry PinBuffer ReadBuffer_common ReadBufferExtended _bt_relandgetbuf _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres [kernel.kallsyms] [k] sys_lseek | --- sys_lseek system_call_fastpath 0x7fb873dc30d0 __lseek64 ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres postgres [.] _bt_relandgetbuf | --- _bt_relandgetbuf _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres postgres [.] pg_qsort | --- pg_qsort pg_qsort tbm_begin_iterate BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres postgres [.] btgettuple | --- btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres [kernel.kallsyms] [k] fget_light | --- fget_light sys_lseek system_call_fastpath 0x7fb873dc30d0 __lseek64 0.07% 1 postgres [kernel.kallsyms] [k] read_pages | --- read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise 0.07% 1 postgres [kernel.kallsyms] [k] __phys_addr | --- __phys_addr kfree 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise 0.07% 1 postgres postgres [.] CHashDelete | --- CHashDelete BufTableDelete ReadBuffer_common ReadBufferExtended index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres [kernel.kallsyms] [k] sys_fadvise64 | --- sys_fadvise64 system_call_fastpath 0x7fb873db9e5d posix_fadvise 0.07% 1 postgres postgres [.] bms_free | --- bms_free ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres [kernel.kallsyms] [k] fsnotify | --- fsnotify rw_verify_area vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.07% 1 postgres [kernel.kallsyms] [k] sys_fadvise64_64 | --- sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise 0.07% 1 postgres postgres [.] RecoveryInProgress | --- RecoveryInProgress BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres postgres [.] date_ge | --- date_ge ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres [kernel.kallsyms] [k] down_read_trylock | --- down_read_trylock do_page_fault page_fault copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.07% 1 postgres postgres [.] tbm_add_tuples | --- tbm_add_tuples btgetbitmap FunctionCall2Coll index_getbitmap MultiExecBitmapIndexScan BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres postgres [.] hash_search | --- hash_search GetPrivateRefCountEntry PinBuffer ReadBuffer_common ReadBufferExtended _bt_getbuf _bt_getroot _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres postgres [.] IsCatalogClass | --- IsCatalogClass index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres [kernel.kallsyms] [k] set_page_dirty | --- set_page_dirty __do_fault handle_pte_fault do_page_fault page_fault copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0554e96 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.07% 1 postgres postgres [.] tbm_comparator | --- tbm_comparator pg_qsort pg_qsort pg_qsort pg_qsort pg_qsort tbm_begin_iterate BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres postgres [.] ExecReScanIndexScan | --- ExecReScanIndexScan ExecReScan ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres [kernel.kallsyms] [k] __mem_cgroup_commit_charge | --- __mem_cgroup_commit_charge __mem_cgroup_commit_charge_lrucare mem_cgroup_cache_charge add_to_page_cache_locked add_to_page_cache add_to_page_cache_lru read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise 0.07% 1 postgres postgres [.] FileSeek | --- FileSeek mdread ReadBuffer_common ReadBufferExtended _bt_relandgetbuf _bt_search _bt_first btgetbitmap FunctionCall2Coll index_getbitmap MultiExecBitmapIndexScan BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres postgres [.] AllocSetContextCreate | --- AllocSetContextCreate tbm_create_pagetable tbm_get_pageentry tbm_add_tuples btgetbitmap FunctionCall2Coll index_getbitmap MultiExecBitmapIndexScan BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres postgres [.] index_rescan | --- index_rescan ExecReScanIndexScan ExecReScan ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres postgres [.] PinBuffer_Locked | --- PinBuffer_Locked ReadBuffer_common ReadBufferExtended BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres postgres [.] LockBuffer | --- LockBuffer _bt_relandgetbuf _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres postgres [.] tbm_get_pageentry | --- tbm_get_pageentry tbm_add_tuples btgetbitmap FunctionCall2Coll index_getbitmap MultiExecBitmapIndexScan BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres postgres [.] lseek@plt | --- lseek@plt _mdnblocks mdnblocks initscan ExecReScanBitmapHeapScan ExecReScan ExecNestLoop ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres postgres [.] ExecIndexEvalRuntimeKeys | --- ExecIndexEvalRuntimeKeys ExecReScanIndexScan ExecReScan ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres [kernel.kallsyms] [k] read_tsc | --- read_tsc getnstimeofday 0xffffffffa04a8d10 0xffffffffa0554b33 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.07% 1 postgres [kernel.kallsyms] [k] __mem_cgroup_try_charge | --- __mem_cgroup_try_charge mem_cgroup_cache_charge add_to_page_cache_locked add_to_page_cache add_to_page_cache_lru read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise 0.07% 1 postgres postgres [.] _bt_readpage | --- _bt_readpage _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres postgres [.] oid_hash | --- oid_hash GetPrivateRefCountEntry PinBuffer_Locked ReadBuffer_common ReadBufferExtended _bt_getbuf _bt_steppage _bt_next btgetbitmap FunctionCall2Coll index_getbitmap MultiExecBitmapIndexScan BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres postgres [.] mdread | --- mdread ReadBuffer_common ReadBufferExtended BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres postgres [.] PredicateLockTuple | --- PredicateLockTuple heap_hot_search_buffer BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres postgres [.] bms_add_member | --- bms_add_member ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres [kernel.kallsyms] [k] __set_page_dirty_no_writeback | --- __set_page_dirty_no_writeback __do_fault handle_pte_fault do_page_fault page_fault copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0554e96 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.07% 1 postgres postgres [.] advance_transition_function | --- advance_transition_function advance_aggregates ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres libc-2.11.3.so [.] __memmove_ssse3 | --- __memmove_ssse3 FunctionCall5Coll index_rescan ExecReScanIndexScan ExecReScan ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres [kernel.kallsyms] [k] max_sane_readahead | --- max_sane_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise 0.07% 1 postgres postgres [.] bms_make_singleton | --- bms_make_singleton ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres [kernel.kallsyms] [k] apparmor_capable | --- apparmor_capable ns_capable 0xffffffffa04aeafb 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.07% 1 postgres [kernel.kallsyms] [k] native_sched_clock | --- native_sched_clock sched_clock try_to_wake_up __wake_up_common __wake_up 0xffffffffa04be300 0xffffffffa05beb72 0xffffffffa052d8f9 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise 0.07% 1 postgres [kernel.kallsyms] [k] system_call | --- system_call __lseek64 0.07% 1 postgres [kernel.kallsyms] [k] scheduler_tick | --- scheduler_tick update_process_times tick_sched_timer __run_hrtimer hrtimer_interrupt smp_apic_timer_interrupt apic_timer_interrupt 0xffffffffa04c0066 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.07% 1 postgres [kernel.kallsyms] [k] __percpu_counter_add | --- __percpu_counter_add account_user_time update_process_times tick_sched_timer __run_hrtimer hrtimer_interrupt smp_apic_timer_interrupt apic_timer_interrupt 0x79ae8b ResourceOwnerEnlargeBuffers IncrBufferRefCount ExecStoreTuple IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres postgres [.] PrefetchBuffer | --- PrefetchBuffer BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres [kernel.kallsyms] [k] ____pagevec_lru_add_fn | --- ____pagevec_lru_add_fn pagevec_lru_move_fn __lru_cache_add add_to_page_cache_lru read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise 0.07% 1 postgres postgres [.] slot_getsomeattrs | --- slot_getsomeattrs ExecProject ExecNestLoop ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres [kernel.kallsyms] [k] error_entry | --- error_entry 0x49d348 heap_hot_search_buffer ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.05% 11 mmfsd [unknown] [.] 0x5aef72 | --- 0x68bcfa 0xe00000000 | --- 0x5af03a 0xffffc900341c3998 | --- 0x5b6859 0xffffc900341c3998 | --- 0x7ffb7c0e5390 (nil) | --- 0x7ffb7cb536c1 0xffffc900341c3998 | --- 0x1133ccd 0xffffc900341c3998 | --- 0x72a7ec 0x1c4c42 | --- 0x5c1ebd (nil) | --- 0x5c9090 0xffffc90033221a70 | --- 0x5aef72 0xe00000000 | --- 0x7ffb7c11f3d0 0xffffc900341c3998 0.05% 2 swapper [kernel.kallsyms] [k] update_ts_time_stats | --- update_ts_time_stats tick_nohz_stop_idle | |--57.91%-- tick_nohz_restart_sched_tick | cpu_idle | --42.09%-- tick_check_idle irq_enter scheduler_ipi reschedule_interrupt intel_idle cpuidle_idle_call cpu_idle 0.05% 1 kworker/11:1 [kernel.kallsyms] [k] __schedule | --- __schedule worker_thread kthread kernel_thread_helper 0.04% 6 mmfsd [mmfslinux] [k] 0x22614 | --- 0xffffffffa04c3c27 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0xffffc900341c3998 | --- 0xffffffffa04a05c3 0xffffffffa05c0332 0xffffffffa0605afe 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0xffffc900341c3998 | --- 0xffffffffa04c2614 0xffffffffa0605ae4 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0xffffc900341c3998 | --- 0xffffffffa04a8bc2 0x6 0x7ffb7c11f3d7 0xffffc900341c3998 | --- 0xffffffffa04a8b80 0xffffffffa05bf0f1 0xffffffffa05c0478 0xffffffffa0605afe 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0xffffc900341c3998 | --- 0xffffffffa04c3c57 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0xffffc900341c3998 0.03% 2 mmfsd [kernel.kallsyms] [k] __task_pid_nr_ns | --- __task_pid_nr_ns 0xffffffffa04c2645 0xffffffffa0605ae4 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0xffffc900341c3998 0.02% 4 mmfsd [kernel.kallsyms] [k] cpumask_next_and | --- cpumask_next_and find_busiest_group load_balance idle_balance thread_return 0xffffffffa04a8b7d 0xffffffffa05bf0f1 0xffffffffa05c0478 0xffffffffa0605afe 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0xffffc900341c3998 0.02% 3 mmfsd [kernel.kallsyms] [k] __schedule | --- __schedule 0xffffffffa04a8b7d 0xffffffffa05bf0f1 0xffffffffa05c0478 0xffffffffa0605afe 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0xffffc900341c3998 0.02% 1 kworker/0:0 [ixgbe] [k] ixgbe_update_stats | --- ixgbe_update_stats ixgbe_watchdog_subtask ixgbe_service_task process_one_work worker_thread kthread kernel_thread_helper 0.02% 1 swapper [kernel.kallsyms] [k] pm_qos_request | --- pm_qos_request menu_select cpuidle_idle_call cpu_idle 0.02% 5 swapper [kernel.kallsyms] [k] rcu_needs_cpu | --- rcu_needs_cpu tick_nohz_stop_sched_tick | |--93.95%-- cpu_idle | | | --100.00%-- start_kernel | x86_64_start_kernel | --6.05%-- irq_exit do_IRQ ret_from_intr tick_nohz_stop_sched_tick cpu_idle start_kernel x86_64_start_kernel 0.01% 5 swapper [kernel.kallsyms] [k] thread_return | --- thread_return cpu_idle | --100.00%-- start_kernel x86_64_start_kernel 0.01% 2 mmfsd [kernel.kallsyms] [k] _raw_spin_lock_irqsave | --- _raw_spin_lock_irqsave | |--94.55%-- try_to_wake_up | __wake_up_common | __wake_up | 0xffffffffa04a7ff0 | 0xffffffffa05c042a | 0xffffffffa0605afe | 0xffffffffa04c3c65 | do_vfs_ioctl | sys_ioctl | system_call_fastpath | 0x7ffb7c11f3d7 | 0x7ffb7c11f3d7 | 0xffffc900341c3998 | --5.45%-- 0xffffffffa04a8b85 0xffffffffa05bf0f1 0xffffffffa05c0478 0xffffffffa0605afe 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0xffffc900341c3998 0.01% 1 mmfsd [kernel.kallsyms] [k] sched_clock | --- sched_clock idle_balance thread_return schedule_timeout __down down 0xffffffffa04a89cf 0xffffffffa05c03ea 0xffffffffa0605afe 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0xffffc900341c3998 0.01% 1 swapper [kernel.kallsyms] [k] intel_pmu_disable_all | --- intel_pmu_disable_all perf_adjust_freq_unthr_context perf_event_task_tick scheduler_tick update_process_times tick_sched_timer __run_hrtimer hrtimer_interrupt smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.01% 2 swapper [kernel.kallsyms] [k] get_next_timer_interrupt | --- get_next_timer_interrupt tick_nohz_stop_sched_tick | |--52.26%-- cpu_idle | --47.74%-- irq_exit do_IRQ ret_from_intr intel_idle cpuidle_idle_call cpu_idle 0.01% 1 postgres postgres [.] AtEOXact_MultiXact | --- AtEOXact_MultiXact CommitTransactionCommand InitPostgres AutoVacWorkerMain StartAutoVacWorker sigusr1_handler __restore_rt PostmasterMain main __libc_start_main 0.01% 2 mmfsd [kernel.kallsyms] [k] idle_balance | --- idle_balance thread_return 0xffffffffa04a8b7d | |--56.83%-- 0xffffffffa05c07e5 | 0xffffffffa05c0bbf | 0xffffffffa0605bc1 | 0xffffffffa04c3c65 | do_vfs_ioctl | sys_ioctl | system_call_fastpath | 0x7ffb7c11f3d7 | 0x7ffb7c11f3d7 | --43.17%-- 0xffffffffa05bf0f1 0xffffffffa05c0478 0xffffffffa0605afe 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0xffffc900341c3998 0.01% 1 swapper [kernel.kallsyms] [k] cpuidle_idle_call | --- cpuidle_idle_call cpu_idle start_kernel x86_64_start_kernel 0.01% 3 mmfsd [kernel.kallsyms] [k] update_curr | --- update_curr dequeue_entity dequeue_task_fair __schedule 0xffffffffa04a8b7d 0xffffffffa05bf0f1 0xffffffffa05c0478 0xffffffffa0605afe 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0xffffc900341c3998 0.01% 2 swapper [kernel.kallsyms] [k] __schedule | --- __schedule | |--61.67%-- 0xffff8805b67fe000 | --38.33%-- cpu_idle 0.01% 1 mmfsd [kernel.kallsyms] [k] security_file_ioctl | --- security_file_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0xffffc900341c3998 0.01% 2 swapper [kernel.kallsyms] [k] enqueue_sleeper | --- enqueue_sleeper enqueue_entity enqueue_task_fair ttwu_activate ttwu_do_activate sched_ttwu_do_pending scheduler_ipi reschedule_interrupt intel_idle cpuidle_idle_call cpu_idle | --100.00%-- start_kernel x86_64_start_kernel 0.01% 1 postgres libc-2.11.3.so [.] __gettimeofday_internal | --- __gettimeofday_internal BackgroundWriterMain AuxiliaryProcessMain StartChildProcess reaper __restore_rt PostmasterMain main __libc_start_main 0.01% 1 postgres [kernel.kallsyms] [k] get_rps_cpu | --- get_rps_cpu netif_rx loopback_xmit dev_hard_start_xmit dev_queue_xmit ip_finish_output ip_send_skb udp_send_skb udp_sendmsg sock_sendmsg sys_sendto system_call_fastpath 0x7fb873dc4075 __GI___send 0.01% 1 mmfsd [kernel.kallsyms] [k] deactivate_task | --- deactivate_task 0xffffffffa04a8b7d 0xffffffffa05bf0f1 0xffffffffa05c0478 0xffffffffa0605afe 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0xffffc900341c3998 0.01% 3 swapper [kernel.kallsyms] [k] __hrtimer_start_range_ns | --- __hrtimer_start_range_ns | |--88.41%-- tick_nohz_stop_sched_tick | | | |--76.81%-- cpu_idle | | | --23.19%-- irq_exit | do_IRQ | ret_from_intr | intel_idle | cpuidle_idle_call | cpu_idle | start_kernel | x86_64_start_kernel | --11.59%-- tick_nohz_restart tick_nohz_restart_sched_tick cpu_idle 0.00% 1 kworker/2:1 [kernel.kallsyms] [k] queue_delayed_work_on | --- queue_delayed_work_on do_dbs_timer process_one_work worker_thread kthread kernel_thread_helper 0.00% 1 swapper [kernel.kallsyms] [k] native_read_tsc | --- native_read_tsc read_tsc ktime_get tick_dev_program_event __remove_hrtimer __hrtimer_start_range_ns tick_nohz_stop_sched_tick cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] put_prev_task_idle | --- put_prev_task_idle __schedule cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] resched_task | --- resched_task check_preempt_curr ttwu_do_wakeup sched_ttwu_do_pending scheduler_ipi reschedule_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] tick_program_event | --- tick_program_event __remove_hrtimer hrtimer_try_to_cancel hrtimer_cancel tick_nohz_restart tick_nohz_restart_sched_tick cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] rb_erase | --- rb_erase timerqueue_del __remove_hrtimer hrtimer_try_to_cancel hrtimer_cancel tick_nohz_restart tick_nohz_restart_sched_tick cpu_idle 0.00% 1 mmfsd [kernel.kallsyms] [k] sys_ioctl | --- sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0xffffc900341c3998 0.00% 1 swapper [kernel.kallsyms] [k] ktime_get | --- ktime_get tick_nohz_stop_sched_tick cpu_idle start_kernel x86_64_start_kernel 0.00% 1 swapper [kernel.kallsyms] [k] native_apic_msr_write | --- native_apic_msr_write lapic_next_event tick_dev_program_event __hrtimer_start_range_ns tick_nohz_restart tick_nohz_restart_sched_tick cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] select_nohz_load_balancer | --- select_nohz_load_balancer tick_nohz_restart_sched_tick cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] do_timer | --- do_timer tick_do_update_jiffies64 tick_nohz_restart_sched_tick cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] menu_select | --- menu_select cpuidle_idle_call cpu_idle 0.00% 1 mmfsd [kernel.kallsyms] [k] fget_light | --- fget_light sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0xffffc900341c3998 0.00% 1 mmfsd [kernel.kallsyms] [k] thread_return | --- thread_return 0xffffffffa04a8b7d 0xffffffffa05bf0f1 0xffffffffa05c0478 0xffffffffa0605afe 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0xffffc900341c3998 0.00% 1 fail2ban-server [kernel.kallsyms] [k] find_first_bit | --- find_first_bit find_busiest_group load_balance idle_balance thread_return schedule_hrtimeout_range_clock poll_schedule_timeout do_select core_sys_select sys_select system_call_fastpath 0x7f465715f393 0x7f465715f393 0x7f4657ff0b30 0x7f4658007d80 0.00% 1 kworker/2:1 [kernel.kallsyms] [k] free_block | --- free_block drain_array cache_reap process_one_work worker_thread kthread kernel_thread_helper 0.00% 1 mmfsd [kernel.kallsyms] [k] native_sched_clock | --- native_sched_clock sched_clock idle_balance thread_return 0xffffffffa04a8b7d 0xffffffffa05bf0f1 0xffffffffa05c0478 0xffffffffa0605afe 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0xffffc900341c3998 0.00% 2 swapper [kernel.kallsyms] [k] ktime_get_real | --- ktime_get_real intel_idle cpuidle_idle_call cpu_idle | --100.00%-- start_kernel x86_64_start_kernel 0.00% 2 swapper [kernel.kallsyms] [k] enqueue_entity | --- enqueue_entity enqueue_task_fair ttwu_activate ttwu_do_activate sched_ttwu_do_pending scheduler_ipi reschedule_interrupt | |--72.40%-- tick_nohz_stop_sched_tick | cpu_idle | start_kernel | x86_64_start_kernel | --27.60%-- intel_idle cpuidle_idle_call cpu_idle 0.00% 1 mmfsd [kernel.kallsyms] [k] up | --- up 0xffffffffa05bf269 0xffffffffa05c0478 0xffffffffa0605afe 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0xffffc900341c3998 0.00% 1 mmfsd [mmfs26] [k] 0xaf160 | --- 0xffffffffa05bf160 0xffffffffa05c0478 0xffffffffa0605afe 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0xffffc900341c3998 0.00% 1 mmfsd [kernel.kallsyms] [k] do_vfs_ioctl | --- do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0xffffc900341c3998 0.00% 1 swapper [kernel.kallsyms] [k] netif_receive_skb | --- netif_receive_skb napi_skb_finish ixgbe_clean_rx_irq ixgbe_poll net_rx_action __do_softirq call_softirq do_softirq irq_exit do_IRQ ret_from_intr intel_idle cpuidle_idle_call cpu_idle start_kernel x86_64_start_kernel 0.00% 1 swapper [kernel.kallsyms] [k] task_of | --- task_of enqueue_sleeper enqueue_entity enqueue_task_fair ttwu_activate ttwu_do_activate sched_ttwu_do_pending scheduler_ipi reschedule_interrupt intel_idle cpuidle_idle_call cpu_idle start_kernel x86_64_start_kernel 0.00% 1 swapper [kernel.kallsyms] [k] update_stats_wait_end | --- update_stats_wait_end set_next_entity pick_next_task_fair __schedule cpu_idle start_kernel x86_64_start_kernel 0.00% 1 swapper [kernel.kallsyms] [k] ttwu_do_wakeup | --- ttwu_do_wakeup sched_ttwu_do_pending scheduler_ipi reschedule_interrupt intel_idle cpuidle_idle_call cpu_idle start_kernel x86_64_start_kernel 0.00% 1 swapper [kernel.kallsyms] [k] enqueue_task | --- enqueue_task ttwu_activate ttwu_do_activate sched_ttwu_do_pending scheduler_ipi reschedule_interrupt intel_idle cpuidle_idle_call cpu_idle start_kernel x86_64_start_kernel 0.00% 1 swapper [kernel.kallsyms] [k] rcu_irq_enter | --- rcu_irq_enter irq_enter scheduler_ipi reschedule_interrupt intel_idle cpuidle_idle_call cpu_idle start_kernel x86_64_start_kernel 0.00% 1 swapper [kernel.kallsyms] [k] timerqueue_add | --- timerqueue_add enqueue_hrtimer __hrtimer_start_range_ns tick_nohz_restart tick_nohz_restart_sched_tick cpu_idle start_kernel x86_64_start_kernel 0.00% 1 swapper [kernel.kallsyms] [k] _raw_spin_unlock_irqrestore | --- _raw_spin_unlock_irqrestore __hrtimer_start_range_ns tick_nohz_restart tick_nohz_restart_sched_tick cpu_idle start_kernel x86_64_start_kernel 0.00% 1 swapper [kernel.kallsyms] [k] scheduler_ipi | --- scheduler_ipi reschedule_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] leave_mm | --- leave_mm intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] scale_rt_power | --- scale_rt_power update_group_power find_busiest_group load_balance rebalance_domains run_rebalance_domains __do_softirq call_softirq do_softirq irq_exit smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle start_kernel x86_64_start_kernel 0.00% 1 swapper [kernel.kallsyms] [k] check_cpu_stall | --- check_cpu_stall __rcu_pending rcu_check_callbacks update_process_times tick_sched_timer __run_hrtimer hrtimer_interrupt smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] lock_hrtimer_base | --- lock_hrtimer_base __hrtimer_start_range_ns tick_nohz_restart tick_nohz_restart_sched_tick cpu_idle 0.00% 1 mmfsd [kernel.kallsyms] [k] system_call_fastpath | --- system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0xffffc900341c3998 # # (For a higher level overview, try: perf report --sort comm,dso) #