# Events: 939 cycles # # Overhead Samples Command Shared Object Symbol # ........ .......... ............... ................. ............................... # 15.47% 1 postgres [mmfslinux] [k] 0x20066 | --- 0xffffffffa04c0066 | |--95.98%-- 0xffffffffa0553f90 | 0xffffffffa05715f4 | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | |--3.96%-- 0xffffffffa0554e96 | 0xffffffffa056facb | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read --0.07%-- [...] | --- 0xffffffffa04aa6dc 0xffffffffa04c01d0 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04c005e 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04c0001 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04aa75c 0xffffffffa04c01d0 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04a057f 0xffffffffa051f536 | |--50.06%-- 0xffffffffa053ac4a | 0xffffffffa051f34a | 0xffffffffa0560b17 | 0xffffffffa04aeb14 | 0xffffffffa04c602f | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --49.94%-- 0xffffffffa0541346 0xffffffffa0570c42 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04b3d04 0xffffffffa0546edd 0xffffffffa05540de 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04bfff1 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04c01bc 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04a0190 0xffffffffa052df5a 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa04adcfe 0xffffffffa04c6050 vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04b590e 0xffffffffa052d479 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa04a0b53 0xffffffffa0551757 0xffffffffa0554cba 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04c0105 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04c600c vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04a87f2 0xffffffffa0513c8d 0xffffffffa052e859 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa04a0844 0xffffffffa0553cfb 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04bff80 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04aae42 0xffffffffa052df93 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa04bffc1 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04aae15 0xffffffffa052df93 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa04aa774 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 | --- 0xffffffffa04c005a 0xffffffffa0554e96 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 8.88% 81 postgres [kernel.kallsyms] [k] copy_user_generic_string | --- copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c | |--87.65%-- 0xffffffffa0553f90 | 0xffffffffa05715f4 | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --12.35%-- 0xffffffffa0554e96 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 7.24% 66 postgres postgres [.] CHashBucketScan | --- CHashBucketScan | |--81.83%-- CHashSearch | BufTableLookup | | | |--98.15%-- ReadBuffer_common | | ReadBufferExtended | | | | | |--94.35%-- index_fetch_heap | | | index_getnext | | | IndexNext | | | ExecScan | | | ExecProcNode | | | | | | | |--98.00%-- ExecAgg | | | | ExecProcNode | | | | ExecSubPlan | | | | ExecMakeFunctionResultNoSets | | | | ExecQual | | | | ExecScan | | | | ExecProcNode | | | | ExecNestLoop | | | | ExecProcNode | | | | MultiExecHash | | | | ExecHashJoin | | | | ExecProcNode | | | | ExecSort | | | | ExecProcNode | | | | standard_ExecutorRun | | | | ExplainOnePlan | | | | ExplainOneQuery | | | | ExplainQuery | | | | standard_ProcessUtility | | | | PortalRunUtility | | | | FillPortalStore | | | | PortalRun | | | | exec_simple_query | | | | PostgresMain | | | | ServerLoop | | | | PostmasterMain | | | | main | | | | __libc_start_main | | | | | | | --2.00%-- ExecNestLoop | | | ExecProcNode | | | MultiExecHash | | | ExecHashJoin | | | ExecProcNode | | | ExecSort | | | ExecProcNode | | | standard_ExecutorRun | | | ExplainOnePlan | | | ExplainOneQuery | | | ExplainQuery | | | standard_ProcessUtility | | | PortalRunUtility | | | FillPortalStore | | | PortalRun | | | exec_simple_query | | | PostgresMain | | | ServerLoop | | | PostmasterMain | | | main | | | __libc_start_main | | | | | --5.65%-- _bt_relandgetbuf | | _bt_search | | _bt_first | | btgettuple | | FunctionCall2Coll | | index_getnext_tid | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | | | | |--66.62%-- ExecNestLoop | | | ExecProcNode | | | MultiExecHash | | | ExecHashJoin | | | 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%-- ExecAgg | | ExecProcNode | | ExecSubPlan | | ExecMakeFunctionResultNoSets | | ExecQual | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | MultiExecHash | | ExecHashJoin | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --1.85%-- PrefetchBuffer | BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --18.17%-- CHashDelete BufTableDelete ReadBuffer_common ReadBufferExtended | |--49.99%-- index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | | | |--83.37%-- ExecAgg | | ExecProcNode | | ExecSubPlan | | ExecMakeFunctionResultNoSets | | ExecQual | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | MultiExecHash | | ExecHashJoin | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --16.63%-- ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | 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%-- _bt_relandgetbuf | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | | | |--66.60%-- ExecAgg | | ExecProcNode | | ExecSubPlan | | ExecMakeFunctionResultNoSets | | ExecQual | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | MultiExecHash | | ExecHashJoin | | 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%-- ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | 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%-- BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 6.48% 1 postgres [mmfs26] [k] 0x41101 | --- 0xffffffffa05e1d4d | |--71.44%-- __GI___read | --28.56%-- posix_fadvise | --- 0xffffffffa0551743 | |--80.04%-- 0xffffffffa0553de1 | 0xffffffffa05715f4 | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --19.96%-- 0xffffffffa0554cba 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa053424f 0xffffffffa0551537 0xffffffffa0553de1 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0534220 0xffffffffa0551537 0xffffffffa0553de1 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05516f9 0xffffffffa0553de1 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05341e3 | |--50.12%-- 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 | --49.88%-- 0xffffffffa052b1ff 0xffffffffa05a186d 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa05341db | |--50.03%-- 0xffffffffa0551537 | 0xffffffffa0553de1 | 0xffffffffa05715f4 | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --49.97%-- 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 | --- 0xffffffffa05515d1 0xffffffffa0553de1 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05515ef 0xffffffffa0553de1 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0534192 0xffffffffa052b762 0xffffffffa059ef64 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa053490e 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 | --- 0xffffffffa0553cf3 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0513864 0xffffffffa0514a55 0xffffffffa05701ef 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa056f91d 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa056f39f 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05a1670 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa05413d4 0xffffffffa0541939 0xffffffffa05718be 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa060322e 0xffffffffa056f3d9 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05351f0 0xffffffffa052a8c7 0xffffffffa05a172a 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa0541501 0xffffffffa0541939 0xffffffffa05718be 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05540eb 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0551e04 0xffffffffa04c006c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa053b0bd 0xffffffffa0541341 0xffffffffa0560b7f 0xffffffffa04aeb14 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05c31b4 0xffffffffa0553f55 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa055174e 0xffffffffa0553de1 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0603245 0xffffffffa056f3d9 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0536819 0xffffffffa055411b 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0536720 0xffffffffa055411b 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa053b0ef __GI___read | --- 0xffffffffa056f047 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05ba684 0xffffffffa05341d7 0xffffffffa0551537 0xffffffffa0553de1 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05ba66a 0xffffffffa05341d7 0xffffffffa0551537 0xffffffffa0553de1 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05718d4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05549bb 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05beab0 0xffffffffa052de66 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa05e1d6a __GI___read | --- 0xffffffffa051f317 0xffffffffa0560b17 0xffffffffa04aeb14 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0603224 0xffffffffa056f3d9 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0553d0a 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 2.63% 24 postgres postgres [.] heap_page_prune_opt | --- heap_page_prune_opt index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode | |--95.83%-- ExecAgg | ExecProcNode | ExecSubPlan | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --4.17%-- ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 2.52% 23 postgres [kernel.kallsyms] [k] page_fault | --- page_fault | |--52.19%-- copy_user_generic_string | 0xffffffffa04bfedc | 0xffffffffa04c021c | | | |--91.65%-- 0xffffffffa0553f90 | | 0xffffffffa05715f4 | | 0xffffffffa04c61ab | | vfs_read | | sys_read | | system_call_fastpath | | 0x7fb873db55d0 | | __GI___read | | | --8.35%-- 0xffffffffa0554e96 | 0xffffffffa056facb | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | |--26.09%-- 0x49d348 | heap_hot_search_buffer | index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSubPlan | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--17.38%-- 0x49f6c7 | heap_page_prune_opt | | | --100.00%-- index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSubPlan | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | 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%-- 0x68ef14 LWLockAttemptLock index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 2.04% 18 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 | |--59.23%-- copy_user_generic_string | 0xffffffffa04bfedc | 0xffffffffa04c021c | | | |--90.91%-- 0xffffffffa0553f90 | | 0xffffffffa05715f4 | | 0xffffffffa04c61ab | | vfs_read | | sys_read | | system_call_fastpath | | 0x7fb873db55d0 | | __GI___read | | | --9.09%-- 0xffffffffa0554e96 | 0xffffffffa056facb | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | |--17.38%-- 0x49f6c7 | heap_page_prune_opt | index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSubPlan | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--16.16%-- 0x49d348 | heap_hot_search_buffer | index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSubPlan | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --7.23%-- 0x68ef14 LWLockAttemptLock LWLockAcquire index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.87% 17 postgres postgres [.] StrategyGetBuffer | --- StrategyGetBuffer ReadBuffer_common ReadBufferExtended | |--76.51%-- index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | | | |--92.26%-- ExecAgg | | ExecProcNode | | ExecSubPlan | | ExecMakeFunctionResultNoSets | | ExecQual | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | MultiExecHash | | ExecHashJoin | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --7.74%-- ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | 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%-- _bt_relandgetbuf | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | | | |--66.64%-- ExecAgg | | ExecProcNode | | ExecSubPlan | | ExecMakeFunctionResultNoSets | | ExecQual | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | MultiExecHash | | ExecHashJoin | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --33.36%-- ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --5.88%-- BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.76% 16 postgres postgres [.] heap_hot_search_buffer | --- heap_hot_search_buffer | |--81.09%-- index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSubPlan | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--12.50%-- BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --6.41%-- index_getnext IndexNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.76% 16 postgres postgres [.] PinBuffer | --- PinBuffer | |--93.73%-- ReadBuffer_common | ReadBufferExtended | | | |--86.65%-- index_fetch_heap | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSubPlan | | ExecMakeFunctionResultNoSets | | ExecQual | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | MultiExecHash | | ExecHashJoin | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | |--6.68%-- BitmapHeapNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --6.67%-- _bt_getbuf | _bt_getroot | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSubPlan | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --6.27%-- ReadBufferExtended _bt_relandgetbuf _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.75% 16 postgres postgres [.] slot_deform_tuple | --- slot_deform_tuple slot_getattr ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode | |--93.75%-- ExecAgg | ExecProcNode | ExecSubPlan | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --6.25%-- ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.65% 15 postgres postgres [.] UnpinBuffer | --- UnpinBuffer | |--39.98%-- ExecStoreTuple | IndexNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSubPlan | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | 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%-- ReleaseAndReadBuffer | | | |--59.97%-- index_fetch_heap | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSubPlan | | ExecMakeFunctionResultNoSets | | ExecQual | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | MultiExecHash | | ExecHashJoin | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --40.03%-- _bt_relandgetbuf | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSubPlan | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--13.33%-- IndexNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSubPlan | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--6.68%-- index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSubPlan | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --6.66%-- _bt_relandgetbuf _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.54% 14 postgres postgres [.] GetPrivateRefCountEntry | --- GetPrivateRefCountEntry | |--50.04%-- UnpinBuffer | | | |--57.21%-- ReleaseAndReadBuffer | | index_fetch_heap | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSubPlan | | ExecMakeFunctionResultNoSets | | ExecQual | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | MultiExecHash | | ExecHashJoin | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | |--28.57%-- ExecStoreTuple | | IndexNext | | ExecScan | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSubPlan | | ExecMakeFunctionResultNoSets | | ExecQual | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | MultiExecHash | | ExecHashJoin | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --14.22%-- ExecClearTuple | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSubPlan | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--21.40%-- IncrBufferRefCount | ExecStoreTuple | IndexNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSubPlan | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--21.40%-- ReleaseBuffer | ExecStoreTuple | IndexNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSubPlan | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --7.16%-- ReadBuffer_common ReadBufferExtended index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.32% 12 postgres [kernel.kallsyms] [k] radix_tree_lookup_slot | --- radix_tree_lookup_slot find_get_page find_lock_page | |--91.67%-- shmem_getpage_gfp | shmem_fault | __do_fault | handle_pte_fault | do_page_fault | page_fault | | | |--45.47%-- copy_user_generic_string | | 0xffffffffa04bfedc | | 0xffffffffa04c021c | | 0xffffffffa0553f90 | | 0xffffffffa05715f4 | | 0xffffffffa04c61ab | | vfs_read | | sys_read | | system_call_fastpath | | 0x7fb873db55d0 | | __GI___read | | | |--45.45%-- 0x49f6c7 | | heap_page_prune_opt | | index_fetch_heap | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSubPlan | | ExecMakeFunctionResultNoSets | | ExecQual | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | MultiExecHash | | ExecHashJoin | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --9.08%-- 0x49d348 | heap_hot_search_buffer | index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSubPlan | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --8.33%-- find_or_create_page 0xffffffffa04b58f7 0xffffffffa052d479 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise 1.32% 12 postgres postgres [.] LWLockAttemptLock | --- LWLockAttemptLock | |--91.67%-- LWLockAcquire | | | |--54.55%-- index_fetch_heap | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSubPlan | | ExecMakeFunctionResultNoSets | | ExecQual | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | MultiExecHash | | ExecHashJoin | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | |--36.37%-- StartBufferIO | | ReadBuffer_common | | ReadBufferExtended | | | | | |--74.99%-- index_fetch_heap | | | index_getnext | | | IndexNext | | | ExecScan | | | ExecProcNode | | | ExecAgg | | | ExecProcNode | | | ExecSubPlan | | | ExecMakeFunctionResultNoSets | | | ExecQual | | | ExecScan | | | ExecProcNode | | | ExecNestLoop | | | ExecProcNode | | | MultiExecHash | | | ExecHashJoin | | | 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%-- BitmapHeapNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | MultiExecHash | | ExecHashJoin | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --9.08%-- _bt_relandgetbuf | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSubPlan | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --8.33%-- index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.16% 12 swapper [kernel.kallsyms] [k] intel_idle | --- intel_idle cpuidle_idle_call cpu_idle | --100.00%-- start_kernel x86_64_start_kernel 1.10% 8 postgres [kernel.kallsyms] [k] mem_cgroup_update_page_stat | --- mem_cgroup_update_page_stat | |--79.93%-- __do_fault | handle_pte_fault | do_page_fault | page_fault | | | |--37.52%-- 0x49f6c7 | | heap_page_prune_opt | | index_fetch_heap | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSubPlan | | ExecMakeFunctionResultNoSets | | ExecQual | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | MultiExecHash | | ExecHashJoin | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | |--37.48%-- copy_user_generic_string | | 0xffffffffa04bfedc | | 0xffffffffa04c021c | | 0xffffffffa0553f90 | | 0xffffffffa05715f4 | | 0xffffffffa04c61ab | | vfs_read | | sys_read | | system_call_fastpath | | 0x7fb873db55d0 | | __GI___read | | | |--12.52%-- 0x7a5772 | | HeapTupleSatisfiesMVCC | | BitmapHeapNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --12.48%-- 0x49d348 | heap_hot_search_buffer | index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSubPlan | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --20.07%-- 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.10% 10 postgres postgres [.] ReadBuffer_common | --- ReadBuffer_common ReadBufferExtended | |--89.99%-- index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | | | |--88.90%-- ExecAgg | | ExecProcNode | | ExecSubPlan | | ExecMakeFunctionResultNoSets | | ExecQual | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | MultiExecHash | | ExecHashJoin | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --11.10%-- ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --10.01%-- _bt_getbuf _bt_getroot _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.10% 10 postgres postgres [.] CHashInsert | --- CHashInsert BufTableInsert ReadBuffer_common ReadBufferExtended | |--79.95%-- index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | | | |--75.04%-- ExecAgg | | ExecProcNode | | ExecSubPlan | | ExecMakeFunctionResultNoSets | | ExecQual | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | MultiExecHash | | ExecHashJoin | | 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%-- ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--10.03%-- _bt_getbuf | _bt_steppage | _bt_next | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSubPlan | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --10.02%-- _bt_relandgetbuf _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.10% 10 postgres postgres [.] ExecMakeFunctionResultNoSets | --- ExecMakeFunctionResultNoSets | |--80.03%-- ExecQual | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSubPlan | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | 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%-- ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin 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 mmfsd [unknown] [.] 0x5d4367 | --- 0x687eca 0xe00000000 | --- 0x5d4367 0x45088b4400da1014 | --- 0x757057 0x18046bc3520 0x757050 0x2f0001c6bc 0x18048228420 0x1c4c45 | --- 0x7ffb7c0c3b26 | --- 0x7ffb7c6a1184 0x3f47475000000008 | --- 0x7fffe2dff601 0x7ffb7c0e53aa | --- 0x1133cc9 0xffffc900341c3998 | --- 0x6d7bf7 (nil) | --- 0x68a0fb 0x1c4c42 0.88% 8 postgres [kernel.kallsyms] [k] __memcpy | --- __memcpy | |--62.45%-- 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 | --37.55%-- 0xffffffffa04aeab2 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.87% 1 postgres [kernel.kallsyms] [k] 0xffffffff8111de7a | --- 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.77% 7 postgres postgres [.] index_getnext_tid | --- index_getnext_tid | |--85.68%-- index_getnext | IndexNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSubPlan | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --14.32%-- IndexNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.77% 7 postgres postgres [.] IndexNext | --- IndexNext ExecScan ExecProcNode | |--85.71%-- ExecAgg | ExecProcNode | ExecSubPlan | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --14.29%-- ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.77% 7 postgres postgres [.] ExecScan | --- ExecScan ExecProcNode | |--85.73%-- ExecAgg | ExecProcNode | ExecSubPlan | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --14.27%-- ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin 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% 4 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 | |--53.86%-- 0x7840e1 | hash_search_with_hash_value | SetupLockInTable | LockAcquireExtended | LockRelationOid | relation_open | heap_open | CatalogCacheInitializeCache | SearchCatCache | GetSysCacheOid | get_role_oid | hba_getauthmethod | ClientAuthentication | InitPostgres | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--30.78%-- copy_user_generic_string | 0xffffffffa04bfedc | 0xffffffffa04c021c | 0xffffffffa0553f90 | 0xffffffffa05715f4 | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --15.36%-- 0x49f6c7 heap_page_prune_opt index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.69% 1 mmfsd [kernel.kallsyms] [k] dequeue_entity | --- dequeue_entity dequeue_task_fair __schedule 0xffffffffa04a8b7d 0xffffffffa05bf0f1 0xffffffffa05c0478 0xffffffffa0605afe 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0x15aa1c0 0.66% 6 postgres postgres [.] hash_search_with_hash_value | --- hash_search_with_hash_value GetPrivateRefCountEntry PinBuffer ReadBuffer_common ReadBufferExtended index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.66% 6 postgres postgres [.] BufTableLookup | --- BufTableLookup | |--66.70%-- ReadBuffer_common | ReadBufferExtended | | | |--75.03%-- index_fetch_heap | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSubPlan | | ExecMakeFunctionResultNoSets | | ExecQual | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | MultiExecHash | | ExecHashJoin | | 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_relandgetbuf | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSubPlan | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --33.30%-- ReadBufferExtended | |--50.05%-- index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSubPlan | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | 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 MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.66% 6 postgres postgres [.] _bt_compare | --- _bt_compare | |--83.36%-- _bt_binsrch | | | |--59.98%-- _bt_first | | btgettuple | | FunctionCall2Coll | | index_getnext_tid | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | | | | |--66.68%-- ExecNestLoop | | | ExecProcNode | | | MultiExecHash | | | ExecHashJoin | | | 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%-- ExecAgg | | ExecProcNode | | ExecSubPlan | | ExecMakeFunctionResultNoSets | | ExecQual | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | MultiExecHash | | ExecHashJoin | | 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%-- _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSubPlan | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | 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%-- _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.66% 6 postgres postgres [.] _bt_readpage | --- _bt_readpage _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode | |--66.70%-- ExecAgg | ExecProcNode | ExecSubPlan | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --33.30%-- ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.62% 1 swapper [kernel.kallsyms] [k] __hrtimer_start_range_ns | --- __hrtimer_start_range_ns tick_nohz_stop_sched_tick cpu_idle 0.57% 5 postgres [kernel.kallsyms] [k] __activate_page | --- __activate_page pagevec_lru_move_fn activate_page 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.55% 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.55% 5 postgres postgres [.] ExecEvalScalarVarFast | --- ExecEvalScalarVarFast | |--60.00%-- ExecMakeFunctionResultNoSets | | | |--66.68%-- ExecQual | | ExecScan | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSubPlan | | ExecMakeFunctionResultNoSets | | ExecQual | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | MultiExecHash | | ExecHashJoin | | 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%-- ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | 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%-- ExecHashGetHashValue | MultiExecHash | ExecHashJoin | 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%-- ExecEvalExprSwitchContext ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.51% 1 postgres [kernel.kallsyms] [k] __rmqueue | --- __rmqueue get_page_from_freelist __alloc_pages_nodemask alloc_pages_current pte_alloc_one __pte_alloc copy_pte_range copy_page_range dup_mmap dup_mm copy_process do_fork stub_clone 0x7fb873d9075f __libc_fork fork_process ServerLoop PostmasterMain main __libc_start_main 0.50% 4 postgres postgres [.] InstrStopNode | --- InstrStopNode ExecProcNode | |--56.41%-- ExecAgg | ExecProcNode | ExecSubPlan | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --43.59%-- MultiExecHash ExecHashJoin 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% 4 postgres [kernel.kallsyms] [k] fget_light | --- fget_light | |--50.85%-- sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --49.15%-- sys_lseek system_call_fastpath 0x7fb873dc30d0 __lseek64 0.44% 4 postgres [kernel.kallsyms] [k] __tlb_remove_page | --- __tlb_remove_page 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.44% 4 postgres [kernel.kallsyms] [k] error_entry | --- error_entry | |--74.91%-- copy_user_generic_string | 0xffffffffa04bfedc | 0xffffffffa04c021c | 0xffffffffa0553f90 | 0xffffffffa05715f4 | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --25.09%-- 0x68ef14 LWLockAttemptLock LWLockAcquire index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.44% 4 postgres postgres [.] TransactionIdPrecedes | --- TransactionIdPrecedes | |--75.01%-- HeapTupleSatisfiesMVCC | heap_hot_search_buffer | | | |--66.67%-- BitmapHeapNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | MultiExecHash | | ExecHashJoin | | 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 | ExecAgg | ExecProcNode | ExecSubPlan | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | 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%-- XidInMVCCSnapshot HeapTupleSatisfiesMVCC heap_hot_search_buffer index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.44% 4 postgres [kernel.kallsyms] [k] do_page_fault | --- do_page_fault page_fault | |--50.02%-- copy_user_generic_string | 0xffffffffa04bfedc | 0xffffffffa04c021c | 0xffffffffa0553f90 | 0xffffffffa05715f4 | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | |--25.02%-- 0x49d348 | heap_hot_search_buffer | index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSubPlan | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | 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%-- 0x49f6c7 heap_page_prune_opt index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.44% 4 postgres postgres [.] check_stack_depth | --- check_stack_depth | |--74.99%-- ExecMakeFunctionResultNoSets | | | |--66.63%-- ExecQual | | ExecScan | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSubPlan | | ExecMakeFunctionResultNoSets | | ExecQual | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | MultiExecHash | | ExecHashJoin | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --33.37%-- ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | 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%-- ExecQual ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.44% 4 postgres postgres [.] ExecEvalConst | --- ExecEvalConst | |--50.00%-- ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSubPlan | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | 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%-- ExecQual ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.44% 4 postgres [kernel.kallsyms] [k] handle_mm_fault | --- handle_mm_fault do_page_fault page_fault | |--50.03%-- 0x49f6c7 | heap_page_prune_opt | index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSubPlan | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | 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%-- copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.44% 4 postgres postgres [.] hash_search | --- hash_search | |--50.04%-- GetPrivateRefCountEntry | PinBuffer | ReadBuffer_common | ReadBufferExtended | | | |--50.10%-- _bt_relandgetbuf | | _bt_search | | _bt_first | | btgettuple | | FunctionCall2Coll | | index_getnext_tid | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSubPlan | | ExecMakeFunctionResultNoSets | | ExecQual | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | MultiExecHash | | ExecHashJoin | | 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 | ExecAgg | ExecProcNode | ExecSubPlan | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | 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%-- PinBuffer ReadBuffer_common ReadBufferExtended | |--50.10%-- _bt_relandgetbuf | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSubPlan | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | 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 ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.44% 4 postgres postgres [.] ResourceOwnerForgetBuffer | --- ResourceOwnerForgetBuffer | |--49.98%-- ReleaseBuffer | ExecStoreTuple | IndexNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSubPlan | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--25.06%-- UnpinBuffer | ReleaseAndReadBuffer | _bt_relandgetbuf | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSubPlan | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | 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%-- ReleaseAndReadBuffer index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.44% 4 postgres postgres [.] date_ge | --- date_ge ExecQual ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.39% 3 postgres [kernel.kallsyms] [k] activate_page | --- activate_page 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.35% 3 postgres [kernel.kallsyms] [k] mem_cgroup_del_lru_list | --- mem_cgroup_del_lru_list __activate_page pagevec_lru_move_fn activate_page 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.34% 3 postgres [kernel.kallsyms] [k] mem_cgroup_add_lru_list | --- mem_cgroup_add_lru_list __activate_page pagevec_lru_move_fn activate_page 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.33% 3 postgres [kernel.kallsyms] [k] shmem_getpage_gfp | --- shmem_getpage_gfp shmem_fault __do_fault handle_pte_fault do_page_fault page_fault | |--33.36%-- copy_user_generic_string | 0xffffffffa04bfedc | 0xffffffffa04c021c | 0xffffffffa0553f90 | 0xffffffffa05715f4 | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | |--33.32%-- 0x49d348 | heap_hot_search_buffer | index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSubPlan | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | 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%-- 0x49f6c7 heap_page_prune_opt index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.33% 3 postgres postgres [.] index_fetch_heap | --- index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.33% 3 postgres [kernel.kallsyms] [k] __do_fault | --- __do_fault handle_pte_fault do_page_fault page_fault | |--33.39%-- copy_user_generic_string | 0xffffffffa04bfedc | 0xffffffffa04c021c | 0xffffffffa0553f90 | 0xffffffffa05715f4 | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | |--33.33%-- 0x7a5888 | HeapTupleSatisfiesMVCC | heap_hot_search_buffer | index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSubPlan | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | 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%-- 0x49f6c7 heap_page_prune_opt index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.33% 3 postgres postgres [.] _bt_search | --- _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode | |--66.68%-- ExecAgg | ExecProcNode | ExecSubPlan | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | 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%-- ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.33% 3 postgres postgres [.] _bt_first | --- _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode | |--66.61%-- ExecAgg | ExecProcNode | ExecSubPlan | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | 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%-- ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.33% 3 postgres postgres [.] DataChecksumsEnabled | --- DataChecksumsEnabled | |--66.61%-- ReadBuffer_common | ReadBufferExtended | index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | | | |--50.07%-- ExecNestLoop | | ExecProcNode | | MultiExecHash | | ExecHashJoin | | 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%-- ExecAgg | ExecProcNode | ExecSubPlan | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | 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%-- PageIsVerified ReadBuffer_common ReadBufferExtended index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.33% 3 postgres postgres [.] hash_any | --- hash_any | |--66.73%-- CHashSearch | BufTableLookup | ReadBuffer_common | ReadBufferExtended | index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSubPlan | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | 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%-- CHashDelete BufTableDelete ReadBuffer_common ReadBufferExtended index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.33% 3 postgres postgres [.] pgstat_end_function_usage | --- pgstat_end_function_usage | |--66.62%-- ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSubPlan | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | 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%-- ExecQual ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.33% 3 postgres postgres [.] ReleaseAndReadBuffer | --- ReleaseAndReadBuffer index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.33% 3 postgres postgres [.] btgettuple | --- btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.33% 3 postgres [ipt_REJECT] [.] 0x5ef30188 | --- 0xffffffffff600188 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode | |--50.11%-- ExecSubPlan | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.89%-- ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0xffffffffff60018e 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.33% 3 postgres postgres [.] _bt_checkkeys | --- _bt_checkkeys _bt_readpage _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.33% 3 postgres postgres [.] hash_uint32 | --- hash_uint32 | |--66.75%-- hash_search | GetPrivateRefCountEntry | PinBuffer | ReadBuffer_common | ReadBufferExtended | index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSubPlan | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | 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%-- oid_hash hash_search GetPrivateRefCountEntry PinBuffer ReadBuffer_common ReadBufferExtended index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.33% 3 postgres postgres [.] CHashAddToGarbage | --- CHashAddToGarbage CHashDelete BufTableDelete ReadBuffer_common ReadBufferExtended index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode | |--66.67%-- ExecAgg | ExecProcNode | ExecSubPlan | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | 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%-- ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.29% 16 postgres postgres [.] SyncOneBuffer | --- SyncOneBuffer BgBufferSync BackgroundWriterMain AuxiliaryProcessMain StartChildProcess reaper __restore_rt PostmasterMain main __libc_start_main 0.23% 2 postgres [kernel.kallsyms] [k] rw_verify_area | --- rw_verify_area vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.22% 2 postgres postgres [.] ResourceOwnerRememberBuffer | --- ResourceOwnerRememberBuffer | |--50.00%-- ExecStoreTuple | IndexNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSubPlan | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | 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%-- IncrBufferRefCount ExecStoreTuple IndexNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin 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% 2 postgres postgres [.] ExecProject | --- ExecProject | |--50.05%-- ExecAgg | ExecProcNode | ExecSubPlan | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | 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%-- ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin 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% 2 postgres postgres [.] ResourceOwnerEnlargeBuffers | --- ResourceOwnerEnlargeBuffers ReadBuffer_common ReadBufferExtended index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin 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% 2 postgres postgres [.] date_lt | --- date_lt ExecQual ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin 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% 2 postgres libc-2.11.3.so [.] __GI___isinf | --- __GI___isinf ExecMakeFunctionResultNoSets ExecProject ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin 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% 2 postgres [kernel.kallsyms] [k] handle_pte_fault | --- handle_pte_fault do_page_fault page_fault | |--50.13%-- 0x674c50 | PinBuffer | ReadBuffer_common | ReadBufferExtended | index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSubPlan | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | 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%-- 0x49f6c7 heap_page_prune_opt index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin 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% 2 postgres [kernel.kallsyms] [k] page_add_file_rmap | --- page_add_file_rmap __do_fault handle_pte_fault 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.22% 2 postgres postgres [.] IncrBufferRefCount | --- IncrBufferRefCount | |--50.10%-- IndexNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSubPlan | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | 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%-- ExecStoreTuple IndexNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin 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% 2 postgres postgres [.] _bt_preprocess_array_keys | --- _bt_preprocess_array_keys btrescan FunctionCall5Coll index_rescan ExecReScanIndexScan ExecReScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin 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% 2 postgres postgres [.] ReadBufferExtended | --- ReadBufferExtended index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin 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% 2 postgres postgres [.] ExecQual | --- ExecQual ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin 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% 2 postgres postgres [.] tbm_iterate | --- tbm_iterate BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin 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% 2 postgres postgres [.] ExecStoreTuple | --- ExecStoreTuple | |--50.10%-- IndexNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSubPlan | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | 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%-- ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin 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% 2 postgres [kernel.kallsyms] [k] _raw_spin_lock | --- _raw_spin_lock __do_fault handle_pte_fault do_page_fault page_fault 0x49f6c7 heap_page_prune_opt index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin 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% 2 postgres postgres [.] ExecHashTableInsert | --- ExecHashTableInsert MultiExecHash ExecHashJoin 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% 2 postgres postgres [.] fmgr_info_copy | --- fmgr_info_copy _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin 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% 2 postgres [kernel.kallsyms] [k] mem_cgroup_count_vm_event | --- mem_cgroup_count_vm_event handle_mm_fault 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.22% 2 postgres postgres [.] LWLockRelease | --- LWLockRelease index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin 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% 2 postgres postgres [.] LWLockAcquire | --- LWLockAcquire | |--50.05%-- index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSubPlan | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | 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%-- index_getnext IndexNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin 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% 2 postgres postgres [.] btint4cmp | --- btint4cmp | |--50.01%-- FunctionCall2Coll | _bt_compare | _bt_binsrch | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | 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%-- _bt_compare _bt_binsrch _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin 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% 2 postgres postgres [.] ExecNestLoop | --- ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin 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% 2 postgres [kernel.kallsyms] [k] __inc_zone_page_state | --- __inc_zone_page_state page_add_file_rmap __do_fault handle_pte_fault 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.22% 2 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.22% 2 postgres postgres [.] slot_getattr | --- slot_getattr ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.14% 1 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.13% 1 postgres [kernel.kallsyms] [k] cap_capable | --- cap_capable apparmor_capable ns_capable 0xffffffffa04aeaeb 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.12% 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.11% 1 postgres [kernel.kallsyms] [k] set_page_dirty | --- set_page_dirty 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.11% 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.11% 1 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.11% 1 postgres [kernel.kallsyms] [k] PageHuge | --- PageHuge 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.11% 1 postgres [kernel.kallsyms] [k] update_page_reclaim_stat | --- update_page_reclaim_stat pagevec_lru_move_fn activate_page 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.11% 1 postgres [kernel.kallsyms] [k] __mod_zone_page_state | --- __mod_zone_page_state __activate_page pagevec_lru_move_fn activate_page 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.11% 1 postgres libc-2.11.3.so [.] __GI_memcpy | --- __GI_memcpy BufTableInsert ReadBuffer_common ReadBufferExtended index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.11% 1 postgres [kernel.kallsyms] [k] __set_page_dirty_no_writeback | --- __set_page_dirty_no_writeback 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.11% 1 postgres postgres [.] AllocSetAlloc | --- AllocSetAlloc _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.11% 1 postgres postgres [.] BitmapHeapNext | --- BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.11% 1 postgres postgres [.] datumCopy | --- datumCopy advance_aggregates ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.11% 1 postgres [kernel.kallsyms] [k] _raw_spin_lock_irqsave | --- _raw_spin_lock_irqsave up 0xffffffffa0570c42 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.11% 1 postgres postgres [.] TerminateBufferIO | --- TerminateBufferIO ReadBufferExtended index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.11% 1 postgres postgres [.] _bt_next | --- _bt_next FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.11% 1 postgres [kernel.kallsyms] [k] unlock_page | --- unlock_page __do_fault handle_pte_fault 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.11% 1 postgres postgres [.] dense_alloc | --- dense_alloc ExecHashTableInsert MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.11% 1 postgres postgres [.] ExecEvalParamExec | --- ExecEvalParamExec ExecQual ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.11% 1 postgres postgres [.] BufferGetBlockNumber | --- BufferGetBlockNumber index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.11% 1 postgres postgres [.] palloc | --- palloc heap_copytuple ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.11% 1 postgres postgres [.] index_getnext | --- index_getnext IndexNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.11% 1 postgres [kernel.kallsyms] [k] current_kernel_time | --- current_kernel_time current_fs_time file_update_time __do_fault handle_pte_fault 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.11% 1 postgres [kernel.kallsyms] [k] kfree | --- kfree 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise 0.11% 1 postgres postgres [.] ExecClearTuple | --- ExecClearTuple ExecProject ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.11% 1 postgres [kernel.kallsyms] [k] getnstimeofday | --- getnstimeofday 0xffffffffa04a8d10 0xffffffffa0554088 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.11% 1 postgres postgres [.] advance_aggregates | --- advance_aggregates ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.11% 1 postgres postgres [.] ExecProcNode | --- ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.11% 1 postgres postgres [.] CheckForSerializableConflictOut | --- CheckForSerializableConflictOut heap_hot_search_buffer index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.11% 1 postgres postgres [.] StartBufferIO | --- StartBufferIO ReadBuffer_common ReadBufferExtended index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.11% 1 postgres libc-2.11.3.so [.] __lseek64 | --- __lseek64 mdread ReadBuffer_common ReadBufferExtended index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.11% 1 postgres [kernel.kallsyms] [k] lookup_page_cgroup | --- lookup_page_cgroup __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.11% 1 postgres postgres [.] HeapTupleSatisfiesMVCC | --- HeapTupleSatisfiesMVCC index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.11% 1 postgres postgres [.] ReadBuffer | --- ReadBuffer index_getnext IndexNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.11% 1 postgres [kernel.kallsyms] [k] error_kernelspace | --- error_kernelspace copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.11% 1 postgres postgres [.] _bt_getroot | --- _bt_getroot _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.11% 1 postgres postgres [.] pgstat_init_function_usage | --- pgstat_init_function_usage ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.11% 1 postgres [kernel.kallsyms] [k] apparmor_capable | --- apparmor_capable ns_capable 0xffffffffa04aeaeb 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.11% 1 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.11% 1 postgres postgres [.] ExecSubPlan | --- ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.11% 1 postgres [kernel.kallsyms] [k] retint_restore_args | --- retint_restore_args copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.11% 1 postgres libc-2.11.3.so [.] __GI___read | --- __GI___read mdread ReadBuffer_common ReadBufferExtended index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.11% 1 postgres postgres [.] MemoryContextReset | --- MemoryContextReset ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.11% 1 postgres postgres [.] LockBuffer | --- LockBuffer index_getnext IndexNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.11% 1 postgres postgres [.] FunctionCall2Coll | --- FunctionCall2Coll _bt_compare _bt_moveright _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.11% 1 postgres [kernel.kallsyms] [k] up | --- up 0xffffffffa0513c8d 0xffffffffa059eaa9 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise 0.11% 1 postgres postgres [.] CHashSearch | --- CHashSearch BufTableLookup ReadBuffer_common ReadBufferExtended index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.11% 1 postgres postgres [.] _bt_binsrch | --- _bt_binsrch _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.11% 1 postgres postgres [.] PageIsVerified | --- PageIsVerified ReadBufferExtended index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.11% 1 postgres postgres [.] InstrEndLoop | --- InstrEndLoop ExecReScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.11% 1 postgres postgres [.] float84mul | --- float84mul ExecProject ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.11% 1 postgres postgres [.] MemoryContextDeleteChildren | --- MemoryContextDeleteChildren MemoryContextResetAndDeleteChildren ExecReScanAgg ExecReScan ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.11% 1 postgres postgres [.] XidInMVCCSnapshot | --- XidInMVCCSnapshot HeapTupleSatisfiesMVCC heap_hot_search_buffer index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.11% 1 postgres postgres [.] ReScanExprContext | --- ReScanExprContext ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.11% 1 postgres postgres [.] ExecHashGetHashValue | --- ExecHashGetHashValue MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.11% 1 postgres [kernel.kallsyms] [k] _raw_spin_unlock_irqrestore | --- _raw_spin_unlock_irqrestore 0xffffffffa04a89cf 0xffffffffa054b712 0xffffffffa056f34a 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.11% 1 postgres postgres [.] ExecScanReScan | --- ExecScanReScan ExecReScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.11% 1 postgres libc-2.11.3.so [.] __GI_memset | --- __GI_memset heap_form_minimal_tuple ExecFetchSlotMinimalTuple ExecHashTableInsert MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.11% 1 postgres [kernel.kallsyms] [k] timespec_trunc | --- timespec_trunc current_fs_time file_update_time __do_fault handle_pte_fault 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.11% 1 postgres postgres [.] ExecAgg | --- ExecAgg ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.11% 1 postgres postgres [.] FileRead | --- FileRead mdread ReadBuffer_common ReadBufferExtended index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.11% 1 postgres postgres [.] ExecEvalAggref | --- ExecEvalAggref ExecMakeFunctionResultNoSets ExecProject ExecAgg ExecProcNode ExecSubPlan ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.11% 1 postgres libc-2.11.3.so [.] __GI___isnan | --- __GI___isnan float8gt ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.11% 1 postgres [kernel.kallsyms] [k] sys_fadvise64_64 | --- sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise 0.06% 1 kworker/2:1 [igb] [k] igb_update_stats | --- igb_update_stats igb_watchdog_task process_one_work worker_thread kthread kernel_thread_helper 0.05% 2 swapper [kernel.kallsyms] [k] find_busiest_group | --- find_busiest_group load_balance rebalance_domains | |--83.82%-- nohz_idle_balance | __do_softirq | call_softirq | do_softirq | irq_exit | reschedule_interrupt | intel_idle | cpuidle_idle_call | cpu_idle | --16.18%-- 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 0.04% 2 postgres postgres [.] BgBufferSync | --- BgBufferSync BackgroundWriterMain AuxiliaryProcessMain StartChildProcess reaper __restore_rt PostmasterMain main __libc_start_main 0.03% 2 irqbalance [unknown] [.] 0x7f398a130c01 | --- 0x7f398a130bc6 0x200000002 | --- 0x7f398a130c01 (nil) 0.02% 1 swapper [kernel.kallsyms] [k] ktime_add_safe | --- ktime_add_safe __hrtimer_start_range_ns tick_nohz_restart tick_nohz_restart_sched_tick cpu_idle start_kernel x86_64_start_kernel 0.02% 2 mmfsd [nf_conntrack] [k] tcp_in_window | --- tcp_in_window tcp_packet nf_conntrack_in nf_iterate nf_hook_slow __ip_local_out ip_local_out ip_queue_xmit tcp_transmit_skb tcp_write_xmit __tcp_push_pending_frames tcp_sendmsg sock_sendmsg ___sys_sendmsg __sys_sendmsg system_call_fastpath 0x7ffb7cb55dfd 0x7ffb7cb55dfd 0.02% 1 kworker/10:1 [kernel.kallsyms] [k] find_busiest_group | --- find_busiest_group load_balance idle_balance thread_return worker_thread kthread kernel_thread_helper 0.02% 3 mmfsd [kernel.kallsyms] [k] find_busiest_group | --- find_busiest_group load_balance idle_balance thread_return | |--56.74%-- schedule_hrtimeout_range_clock | ep_poll | sys_epoll_wait | system_call_fastpath | 0x7ffb7c127723 | 0x7ffb7c127723 | 0x800000000 | --43.26%-- 0xffffffffa04a8b7d 0xffffffffa05bf0f1 0xffffffffa05c0478 0xffffffffa0605afe 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0xffffc900341c3998 0.02% 2 fail2ban-server [unknown] [.] 0x7f4657d7ff50 | --- 0x7f4657d552e0 | --- 0x7f4657d7ff50 0x602010 0x602010 0x602010 0x602010 0x602010 0.01% 1 swapper [kernel.kallsyms] [k] timerqueue_del | --- timerqueue_del __remove_hrtimer hrtimer_try_to_cancel hrtimer_cancel tick_nohz_restart tick_nohz_restart_sched_tick cpu_idle start_kernel x86_64_start_kernel 0.01% 2 mmfsd [kernel.kallsyms] [k] idle_balance | --- idle_balance thread_return 0xffffffffa04a8b7d 0xffffffffa05bf0f1 0xffffffffa05c0478 0xffffffffa0605afe 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 | |--66.87%-- 0x7ffb509d7cf0 | --33.13%-- 0xffffc900341c3998 0.01% 1 swapper [kernel.kallsyms] [k] tick_nohz_stop_sched_tick | --- tick_nohz_stop_sched_tick cpu_idle start_kernel x86_64_start_kernel 0.01% 2 swapper [kernel.kallsyms] [k] cpuidle_idle_call | --- cpuidle_idle_call cpu_idle 0.01% 1 swapper [kernel.kallsyms] [k] native_write_msr_safe | --- native_write_msr_safe native_apic_msr_write lapic_next_event tick_dev_program_event __remove_hrtimer __hrtimer_start_range_ns tick_nohz_stop_sched_tick cpu_idle start_kernel x86_64_start_kernel 0.01% 1 postgres [kernel.kallsyms] [k] find_busiest_group | --- find_busiest_group load_balance idle_balance thread_return schedule_hrtimeout_range_clock poll_schedule_timeout do_poll do_sys_poll sys_poll system_call_fastpath 0x7fb873db9b8f __libc_poll 0.01% 1 swapper [kernel.kallsyms] [k] __schedule | --- __schedule cpu_idle 0.01% 1 swapper [kernel.kallsyms] [k] tick_check_idle | --- tick_check_idle irq_enter do_IRQ ret_from_intr intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] rcu_needs_cpu | --- rcu_needs_cpu tick_nohz_stop_sched_tick cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] hrtimer_try_to_cancel | --- hrtimer_try_to_cancel hrtimer_cancel tick_nohz_restart tick_nohz_restart_sched_tick cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] dev_gro_receive | --- dev_gro_receive napi_gro_receive 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 0.00% 1 swapper [kernel.kallsyms] [k] ns_to_timespec | --- ns_to_timespec menu_select cpuidle_idle_call cpu_idle 0.00% 1 mmfsd [kernel.kallsyms] [k] ep_poll | --- ep_poll sys_epoll_wait system_call_fastpath 0x7ffb7c127723 0x7ffb7c127723 0x800000000 0.00% 1 mmfsd [kernel.kallsyms] [k] try_to_wake_up | --- try_to_wake_up __wake_up_common __wake_up 0xffffffffa04a7ff0 0xffffffffa05c05fb 0xffffffffa0605a42 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0x1bfffffffff 0.00% 1 swapper [kernel.kallsyms] [k] run_posix_cpu_timers | --- run_posix_cpu_timers tick_sched_timer __run_hrtimer hrtimer_interrupt smp_apic_timer_interrupt apic_timer_interrupt cpuidle_idle_call cpu_idle 0.00% 1 mmfsd [mmfslinux] [k] 0x6534 | --- 0xffffffffa04a6534 0xffffffffa05bf331 0xffffffffa05bf4b1 0xffffffffa0605aa3 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0x2e00000 0.00% 1 mmfsd [kernel.kallsyms] [k] fput | --- fput __sys_sendmsg system_call_fastpath 0x7ffb7cb55dfd 0x7ffb7cb55dfd 0.00% 1 mmfsd [kernel.kallsyms] [k] nf_iterate | --- nf_iterate nf_hook_slow __ip_local_out ip_local_out ip_queue_xmit tcp_transmit_skb tcp_write_xmit __tcp_push_pending_frames tcp_sendmsg sock_sendmsg ___sys_sendmsg __sys_sendmsg system_call_fastpath 0x7ffb7cb55dfd 0x7ffb7cb55dfd # # (For a higher level overview, try: perf report --sort comm,dso) #