# Events: 3K cycles # # Overhead Samples Command Shared Object Symbol # ........ .......... ............... ................. ..................................... # 11.13% 335 postgres postgres [.] slot_deform_tuple | --- slot_deform_tuple | |--99.10%-- slot_getattr | ExecMakeFunctionResultNoSets | ExecQual | BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --0.90%-- ExecMakeFunctionResultNoSets ExecQual BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 8.12% 1 postgres [mmfs26] [k] 0x50a91 | --- 0xffffffffa05e1d4d | |--75.77%-- posix_fadvise | --24.23%-- __GI___read | --- 0xffffffffa05e1d6a | |--80.01%-- posix_fadvise | --19.99%-- __GI___read | --- 0xffffffffa05341e3 | |--54.81%-- 0xffffffffa052b762 | 0xffffffffa059ef64 | 0xffffffffa05a18a9 | 0xffffffffa05a1a2d | 0xffffffffa04b565a | read_pages | __do_page_cache_readahead | force_page_cache_readahead | sys_fadvise64_64 | system_call_fastpath | 0x7fb873db9e5d | posix_fadvise | |--22.62%-- 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 | |--11.31%-- 0xffffffffa052b1ff | 0xffffffffa05a186d | 0xffffffffa05a1a2d | 0xffffffffa04b565a | read_pages | __do_page_cache_readahead | force_page_cache_readahead | sys_fadvise64_64 | system_call_fastpath | 0x7fb873db9e5d | posix_fadvise | --11.26%-- 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 | --- 0xffffffffa05ba684 0xffffffffa05341d7 | |--37.43%-- 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 | |--25.02%-- 0xffffffffa052b1ff | 0xffffffffa05a186d | 0xffffffffa05a1a2d | 0xffffffffa04b565a | read_pages | __do_page_cache_readahead | force_page_cache_readahead | sys_fadvise64_64 | system_call_fastpath | 0x7fb873db9e5d | posix_fadvise | |--12.54%-- 0xffffffffa052b762 | 0xffffffffa059ef64 | 0xffffffffa05a18a9 | 0xffffffffa05a1a2d | 0xffffffffa04b565a | read_pages | __do_page_cache_readahead | force_page_cache_readahead | sys_fadvise64_64 | system_call_fastpath | 0x7fb873db9e5d | posix_fadvise | |--12.52%-- 0xffffffffa0551537 | 0xffffffffa0554cba | 0xffffffffa056facb | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --12.49%-- 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 | --- 0xffffffffa0551e04 | |--66.59%-- 0xffffffffa04aad43 | 0xffffffffa052df93 | 0xffffffffa059f09d | 0xffffffffa05a18a9 | 0xffffffffa05a1a2d | 0xffffffffa04b565a | read_pages | __do_page_cache_readahead | force_page_cache_readahead | sys_fadvise64_64 | system_call_fastpath | 0x7fb873db9e5d | posix_fadvise | --33.41%-- 0xffffffffa04aacbc 0xffffffffa052df93 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa052dd4a 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa0514a41 0xffffffffa05701ef 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa052aa56 0xffffffffa052b575 0xffffffffa059ef64 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa053b0bd 0xffffffffa0541341 | |--50.06%-- 0xffffffffa0560b7f | 0xffffffffa04aeb14 | 0xffffffffa04c602f | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --49.94%-- 0xffffffffa051f3b9 0xffffffffa05a17f1 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa052d288 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa052d113 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa0551df9 | |--50.08%-- 0xffffffffa04aad43 | 0xffffffffa052df93 | 0xffffffffa059f09d | 0xffffffffa05a18a9 | 0xffffffffa05a1a2d | 0xffffffffa04b565a | read_pages | __do_page_cache_readahead | force_page_cache_readahead | sys_fadvise64_64 | system_call_fastpath | 0x7fb873db9e5d | posix_fadvise | --49.92%-- 0xffffffffa04c006c 0xffffffffa0554e96 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa053b5e2 0xffffffffa05419a3 0xffffffffa051f20f 0xffffffffa05a170c 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa05e1d5b posix_fadvise | --- 0xffffffffa054196e 0xffffffffa05718be 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0551e00 | |--50.01%-- 0xffffffffa04aad43 | 0xffffffffa052df93 | 0xffffffffa059f09d | 0xffffffffa05a18a9 | 0xffffffffa05a1a2d | 0xffffffffa04b565a | read_pages | __do_page_cache_readahead | force_page_cache_readahead | sys_fadvise64_64 | system_call_fastpath | 0x7fb873db9e5d | posix_fadvise | --49.99%-- 0xffffffffa04aacbc 0xffffffffa052df93 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa052b58c 0xffffffffa059ef64 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa05ba680 0xffffffffa05341d7 | |--50.05%-- 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 | --49.95%-- 0xffffffffa052b762 0xffffffffa059ef64 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa052cf0f 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa052e863 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa05a184a 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa052e21b 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa05cc648 0xffffffffa052eb68 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa051f0f0 0xffffffffa05a170c 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa052b1b8 0xffffffffa05a186d 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa0571542 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 7.01% 213 postgres postgres [.] HeapTupleSatisfiesMVCC | --- HeapTupleSatisfiesMVCC | |--98.58%-- BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --1.42%-- ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 5.93% 179 postgres postgres [.] BitmapHeapNext | --- BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 5.13% 155 postgres postgres [.] ExecMakeFunctionResultNoSets | --- ExecMakeFunctionResultNoSets | |--85.74%-- ExecQual | | | |--94.71%-- BitmapHeapNext | | ExecScan | | ExecProcNode | | ExecAgg | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --5.29%-- ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--9.08%-- BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--3.24%-- ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --1.94%-- ExecProject advance_aggregates ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 3.98% 2 postgres [mmfslinux] [k] 0x20001 | --- 0xffffffffa04aad3d 0xffffffffa052df93 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa04c0066 | |--99.57%-- 0xffffffffa0554e96 | 0xffffffffa056facb | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read --0.43%-- [...] | --- 0xffffffffa04aacf7 0xffffffffa052df93 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa04bfff1 | |--75.00%-- 0xffffffffa0554e96 | 0xffffffffa056facb | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --25.00%-- 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04aa6dc | |--74.94%-- 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 | --25.06%-- 0xffffffffa04c01d0 0xffffffffa0554e96 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04a89cf | |--49.97%-- 0xffffffffa051f54e | | | |--50.14%-- 0xffffffffa054182c | | 0xffffffffa051f20f | | 0xffffffffa05a170c | | 0xffffffffa05a1a2d | | 0xffffffffa04b565a | | read_pages | | __do_page_cache_readahead | | force_page_cache_readahead | | sys_fadvise64_64 | | system_call_fastpath | | 0x7fb873db9e5d | | posix_fadvise | | | --49.86%-- 0xffffffffa053ac4a | 0xffffffffa051f34a | 0xffffffffa0560b17 | 0xffffffffa04aeb14 | 0xffffffffa04c602f | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | |--25.02%-- 0xffffffffa0513b5f | 0xffffffffa059eb1e | 0xffffffffa05a18a9 | 0xffffffffa05a1a2d | 0xffffffffa04b565a | read_pages | __do_page_cache_readahead | force_page_cache_readahead | sys_fadvise64_64 | system_call_fastpath | 0x7fb873db9e5d | posix_fadvise | --25.01%-- 0xffffffffa0513be7 0xffffffffa052e859 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa04a4d91 | |--50.06%-- 0xffffffffa04b551b | read_pages | __do_page_cache_readahead | force_page_cache_readahead | sys_fadvise64_64 | system_call_fastpath | 0x7fb873db9e5d | posix_fadvise | --49.94%-- 0xffffffffa04b572a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa04a0844 | |--33.37%-- 0xffffffffa053690c | 0xffffffffa05a6822 | 0xffffffffa052eb10 | 0xffffffffa059f09d | 0xffffffffa05a18a9 | 0xffffffffa05a1a2d | 0xffffffffa04b565a | read_pages | __do_page_cache_readahead | force_page_cache_readahead | sys_fadvise64_64 | system_call_fastpath | 0x7fb873db9e5d | posix_fadvise | |--33.32%-- 0xffffffffa052c923 | 0xffffffffa059f09d | 0xffffffffa05a18a9 | 0xffffffffa05a1a2d | 0xffffffffa04b565a | read_pages | __do_page_cache_readahead | force_page_cache_readahead | sys_fadvise64_64 | system_call_fastpath | 0x7fb873db9e5d | posix_fadvise | --33.31%-- 0xffffffffa05549ca 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04a89d8 | |--66.51%-- 0xffffffffa054b712 | 0xffffffffa059eede | 0xffffffffa05a18a9 | 0xffffffffa05a1a2d | 0xffffffffa04b565a | read_pages | __do_page_cache_readahead | force_page_cache_readahead | sys_fadvise64_64 | system_call_fastpath | 0x7fb873db9e5d | posix_fadvise | --33.49%-- 0xffffffffa0513b5f 0xffffffffa059eb1e 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa04b3d04 0xffffffffa0546edd | |--50.01%-- 0xffffffffa055508c | 0xffffffffa056facb | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --49.99%-- 0xffffffffa052e8b1 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa04a4db1 | |--50.01%-- 0xffffffffa04b572a | read_pages | __do_page_cache_readahead | force_page_cache_readahead | sys_fadvise64_64 | system_call_fastpath | 0x7fb873db9e5d | posix_fadvise | --49.99%-- 0xffffffffa04b551b read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa04a057f | |--50.04%-- 0xffffffffa051f536 | 0xffffffffa054182c | 0xffffffffa051f20f | 0xffffffffa05a170c | 0xffffffffa05a1a2d | 0xffffffffa04b565a | read_pages | __do_page_cache_readahead | force_page_cache_readahead | sys_fadvise64_64 | system_call_fastpath | 0x7fb873db9e5d | posix_fadvise | --49.96%-- 0xffffffffa052a918 0xffffffffa059e9e4 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa04a098f 0xffffffffa05a19e0 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa04bff72 0xffffffffa0554e96 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04aad0e 0xffffffffa052df93 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa04a87f2 | |--50.02%-- 0xffffffffa059eb1e | 0xffffffffa05a18a9 | 0xffffffffa05a1a2d | 0xffffffffa04b565a | read_pages | __do_page_cache_readahead | force_page_cache_readahead | sys_fadvise64_64 | system_call_fastpath | 0x7fb873db9e5d | posix_fadvise | --49.98%-- 0xffffffffa059eb0c 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa04c0001 | |--65.15%-- 0xffffffffa0554e96 | 0xffffffffa056facb | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --34.85%-- 0xffffffffa0550363 0xffffffffa056db9c 0xffffffffa04c5dcb vfs_write sys_write system_call_fastpath 0x7fb873db5630 __GI___libc_write | --- 0xffffffffa04b5723 read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa04aacfc 0xffffffffa052df93 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa04a01d7 0xffffffffa05a16e5 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa04aaf10 0xffffffffa052df93 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa04aac62 0xffffffffa052df93 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa04c0075 0xffffffffa0554e96 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04a0579 0xffffffffa051f536 0xffffffffa054182c 0xffffffffa051f20f 0xffffffffa05a170c 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa04bfea1 0xffffffffa04c021c 0xffffffffa0554e96 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04a0998 0xffffffffa05a19e0 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa04c5e93 vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04bfeaf 0xffffffffa04c021c 0xffffffffa0554e96 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04c01bc 0xffffffffa0554e96 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04aa746 0xffffffffa04c01d0 0xffffffffa0554e96 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04aeaad 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04b5902 0xffffffffa052d479 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa04aac82 0xffffffffa052df93 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa04a882c posix_fadvise | --- 0xffffffffa04aacd8 0xffffffffa052df93 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa04b549e read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa04c0196 0xffffffffa0554e96 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04b551b read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa04b5592 read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa04bfbc5 0xffffffffa04c021c 0xffffffffa0554e96 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04b3eb0 0xffffffffa0546edd 0xffffffffa055508c 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04aa640 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 | --- 0xffffffffa04b55e0 read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa04a5403 0xffffffffa0546e9d 0xffffffffa052e8b1 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 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 | --- 0xffffffffa04c5f05 vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04a2d39 posix_fadvise | --- 0xffffffffa04a87f6 0xffffffffa0554d92 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04a01ce 0xffffffffa05a16e5 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa04a09a0 0xffffffffa05a1b3a 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa04aacf0 0xffffffffa052df93 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa04aeb0c 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04a89b0 0xffffffffa054b712 0xffffffffa056f54e 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 | --- 0xffffffffa04aa740 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 | --- 0xffffffffa04aac60 0xffffffffa052df93 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa04a87d0 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 | --- 0xffffffffa04a2090 0x1c4c45 posix_fadvise | --- 0xffffffffa04aad31 0xffffffffa052df93 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa04c0116 0xffffffffa0554e96 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04c60c1 vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04bfbd6 0xffffffffa04c021c 0xffffffffa0554e96 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04a87d8 0xffffffffa0541942 0xffffffffa051f20f 0xffffffffa05a170c 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa04bfbd5 0xffffffffa04c021c 0xffffffffa0554e96 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04c6091 vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04b5447 read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa04c5ffc vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04bff80 0xffffffffa0554e96 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04bfea6 0xffffffffa04c021c 0xffffffffa0554e96 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 3.96% 119 postgres postgres [.] slot_getattr | --- slot_getattr | |--96.64%-- ExecMakeFunctionResultNoSets | ExecQual | | | |--97.39%-- BitmapHeapNext | | ExecScan | | ExecProcNode | | ExecAgg | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --2.61%-- ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --3.36%-- ExecQual | |--75.03%-- BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --24.97%-- ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 3.19% 96 postgres [kernel.kallsyms] [k] copy_user_generic_string | --- copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c | |--96.87%-- 0xffffffffa0554e96 | 0xffffffffa056facb | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --3.13%-- 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 3.01% 91 postgres [kernel.kallsyms] [k] __memcpy | --- __memcpy | |--98.89%-- 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 | --1.11%-- 0xffffffffa04aeab2 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 2.91% 89 postgres postgres [.] CHashBucketScan | --- CHashBucketScan | |--64.60%-- CHashSearch | BufTableLookup | | | |--89.39%-- PrefetchBuffer | | BitmapHeapNext | | ExecScan | | ExecProcNode | | ExecAgg | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --10.61%-- ReadBuffer_common | ReadBufferExtended | BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--33.12%-- CHashDelete | BufTableDelete | ReadBuffer_common | ReadBufferExtended | BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--1.14%-- BufTableLookup | ReadBuffer_common | ReadBufferExtended | BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --1.14%-- CHashInsert BufTableInsert ReadBuffer_common ReadBufferExtended BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 2.40% 72 postgres postgres [.] ExecQual | --- ExecQual | |--80.58%-- BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--18.04%-- ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --1.39%-- ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 2.20% 66 postgres postgres [.] GetPrivateRefCountEntry | --- GetPrivateRefCountEntry | |--46.98%-- ReleaseBuffer | ExecClearTuple | BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--42.43%-- IncrBufferRefCount | ExecStoreTuple | BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--4.54%-- ExecClearTuple | BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--3.02%-- ExecStoreTuple | BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--1.52%-- UnpinBuffer | ReleaseAndReadBuffer | BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --1.51%-- PinBuffer ReadBuffer_common ReadBufferExtended BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.91% 59 postgres postgres [.] ExecEvalScalarVarFast | --- ExecEvalScalarVarFast | |--59.79%-- ExecMakeFunctionResultNoSets | | | |--97.10%-- ExecQual | | | | | |--87.16%-- BitmapHeapNext | | | ExecScan | | | ExecProcNode | | | ExecAgg | | | ExecProcNode | | | standard_ExecutorRun | | | ExplainOnePlan | | | ExplainOneQuery | | | ExplainQuery | | | standard_ProcessUtility | | | PortalRunUtility | | | FillPortalStore | | | PortalRun | | | exec_simple_query | | | PostgresMain | | | ServerLoop | | | PostmasterMain | | | main | | | __libc_start_main | | | | | --12.84%-- ExecScan | | ExecProcNode | | ExecAgg | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --2.90%-- ExecProject | advance_aggregates | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --40.21%-- ExecQual | |--86.96%-- BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --13.04%-- ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.81% 55 postgres [kernel.kallsyms] [k] page_fault | --- page_fault | |--32.74%-- copy_user_generic_string | 0xffffffffa04bfedc | 0xffffffffa04c021c | | | |--94.36%-- 0xffffffffa0554e96 | | 0xffffffffa056facb | | 0xffffffffa04c61ab | | vfs_read | | sys_read | | system_call_fastpath | | 0x7fb873db55d0 | | __GI___read | | | --5.64%-- 0xffffffffa0553f90 | 0xffffffffa05715f4 | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | |--32.41%-- 0x7a5772 | HeapTupleSatisfiesMVCC | | | --100.00%-- BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--27.49%-- 0x49f6c7 | heap_page_prune_opt | | | |--87.48%-- BitmapHeapNext | | ExecScan | | ExecProcNode | | ExecAgg | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --12.52%-- ReadBuffer_common | heap_page_prune_opt | BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--5.53%-- 0x7a5888 | HeapTupleSatisfiesMVCC | BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --1.84%-- 0x674c50 PinBuffer BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.73% 52 postgres postgres [.] date_lt | --- date_lt ExecQual BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.63% 49 postgres postgres [.] date_ge | --- date_ge ExecQual BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.56% 47 postgres [kernel.kallsyms] [k] radix_tree_lookup_slot | --- radix_tree_lookup_slot find_get_page find_lock_page | |--91.49%-- shmem_getpage_gfp | shmem_fault | __do_fault | handle_pte_fault | do_page_fault | page_fault | | | |--46.61%-- 0x49f6c7 | | heap_page_prune_opt | | BitmapHeapNext | | ExecScan | | ExecProcNode | | ExecAgg | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | |--32.61%-- copy_user_generic_string | | 0xffffffffa04bfedc | | 0xffffffffa04c021c | | 0xffffffffa0554e96 | | 0xffffffffa056facb | | 0xffffffffa04c61ab | | vfs_read | | sys_read | | system_call_fastpath | | 0x7fb873db55d0 | | __GI___read | | | |--16.11%-- 0x7a5772 | | HeapTupleSatisfiesMVCC | | BitmapHeapNext | | ExecScan | | ExecProcNode | | ExecAgg | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | |--2.34%-- 0x7a5888 | | HeapTupleSatisfiesMVCC | | BitmapHeapNext | | ExecScan | | ExecProcNode | | ExecAgg | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --2.34%-- 0x674c50 | PinBuffer | ReadBuffer_common | ReadBufferExtended | BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --8.51%-- 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.40% 42 postgres postgres [.] heap_page_prune_opt | --- heap_page_prune_opt | |--97.61%-- BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --2.39%-- ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.29% 39 postgres [kernel.kallsyms] [k] find_get_page | --- find_get_page find_lock_page | |--97.42%-- shmem_getpage_gfp | shmem_fault | __do_fault | handle_pte_fault | do_page_fault | page_fault | | | |--42.35%-- 0x7a5772 | | HeapTupleSatisfiesMVCC | | BitmapHeapNext | | ExecScan | | ExecProcNode | | ExecAgg | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | |--31.73%-- copy_user_generic_string | | 0xffffffffa04bfedc | | 0xffffffffa04c021c | | | | | |--91.66%-- 0xffffffffa0554e96 | | | 0xffffffffa056facb | | | 0xffffffffa04c61ab | | | vfs_read | | | sys_read | | | system_call_fastpath | | | 0x7fb873db55d0 | | | __GI___read | | | | | --8.34%-- 0xffffffffa0553f90 | | 0xffffffffa05715f4 | | 0xffffffffa04c61ab | | vfs_read | | sys_read | | system_call_fastpath | | 0x7fb873db55d0 | | __GI___read | | | |--20.63%-- 0x49f6c7 | | heap_page_prune_opt | | BitmapHeapNext | | ExecScan | | ExecProcNode | | ExecAgg | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --5.29%-- 0x7a5888 | HeapTupleSatisfiesMVCC | BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --2.58%-- 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.16% 25 postgres [kernel.kallsyms] [k] mem_cgroup_update_page_stat | --- mem_cgroup_update_page_stat | |--68.58%-- __do_fault | handle_pte_fault | do_page_fault | page_fault | | | |--41.67%-- 0x7a5772 | | HeapTupleSatisfiesMVCC | | BitmapHeapNext | | ExecScan | | ExecProcNode | | ExecAgg | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | |--41.62%-- copy_user_generic_string | | 0xffffffffa04bfedc | | 0xffffffffa04c021c | | 0xffffffffa0554e96 | | 0xffffffffa056facb | | 0xffffffffa04c61ab | | vfs_read | | sys_read | | system_call_fastpath | | 0x7fb873db55d0 | | __GI___read | | | --16.71%-- 0x49f6c7 | heap_page_prune_opt | BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--28.56%-- 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 | --2.86%-- 0xffff88270e4c9370 HeapTupleSatisfiesMVCC BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.08% 33 postgres postgres [.] ExecStoreTuple | --- ExecStoreTuple | |--72.40%-- BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --27.60%-- ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.00% 30 postgres postgres [.] ExecClearTuple | --- ExecClearTuple | |--56.59%-- BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --43.41%-- ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.93% 28 postgres postgres [.] StrategyGetBuffer | --- StrategyGetBuffer | |--96.42%-- ReadBuffer_common | ReadBufferExtended | BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --3.58%-- ReadBufferExtended BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.90% 27 postgres postgres [.] ExecEvalConst | --- ExecEvalConst | |--59.26%-- ExecMakeFunctionResultNoSets | ExecQual | | | |--87.53%-- BitmapHeapNext | | ExecScan | | ExecProcNode | | ExecAgg | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --12.47%-- ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --40.74%-- ExecQual BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.83% 25 postgres postgres [.] CHashInsert | --- CHashInsert | |--96.00%-- BufTableInsert | ReadBuffer_common | ReadBufferExtended | BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --4.00%-- ReadBuffer_common ReadBufferExtended BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.80% 24 postgres postgres [.] ResourceOwnerRememberBuffer | --- ResourceOwnerRememberBuffer | |--54.16%-- ExecStoreTuple | BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --45.84%-- IncrBufferRefCount ExecStoreTuple BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.80% 24 postgres postgres [.] pgstat_end_function_usage | --- pgstat_end_function_usage | |--79.13%-- ExecMakeFunctionResultNoSets | ExecQual | | | |--84.21%-- BitmapHeapNext | | ExecScan | | ExecProcNode | | ExecAgg | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --15.79%-- ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --20.87%-- ExecQual BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.79% 24 postgres postgres [.] ResourceOwnerForgetBuffer | --- ResourceOwnerForgetBuffer | |--70.51%-- ReleaseBuffer | ExecClearTuple | BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--25.29%-- ExecClearTuple | BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --4.20%-- UnpinBuffer ReleaseAndReadBuffer BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.77% 23 postgres postgres [.] IncrBufferRefCount | --- IncrBufferRefCount | |--60.90%-- ExecStoreTuple | BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --39.10%-- BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.70% 21 postgres postgres [.] ReleaseBuffer | --- ReleaseBuffer | |--71.45%-- ExecClearTuple | BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --28.55%-- BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.70% 21 postgres postgres [.] pgstat_init_function_usage | --- pgstat_init_function_usage | |--85.72%-- ExecMakeFunctionResultNoSets | ExecQual | | | |--94.43%-- BitmapHeapNext | | ExecScan | | ExecProcNode | | ExecAgg | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --5.57%-- ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --14.28%-- ExecQual BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.70% 21 postgres [kernel.kallsyms] [k] _raw_spin_unlock_irqrestore | --- _raw_spin_unlock_irqrestore | |--47.71%-- 0xffffffffa04a89cf | | | |--40.01%-- 0xffffffffa051f54e | | | | | |--50.02%-- 0xffffffffa0541346 | | | 0xffffffffa051f3b9 | | | 0xffffffffa05a17f1 | | | 0xffffffffa05a1a2d | | | 0xffffffffa04b565a | | | read_pages | | | __do_page_cache_readahead | | | force_page_cache_readahead | | | sys_fadvise64_64 | | | system_call_fastpath | | | 0x7fb873db9e5d | | | posix_fadvise | | | | | --49.98%-- 0xffffffffa054182c | | | | | |--50.05%-- 0xffffffffa05718be | | | 0xffffffffa04c61ab | | | vfs_read | | | sys_read | | | system_call_fastpath | | | 0x7fb873db55d0 | | | __GI___read | | | | | --49.95%-- 0xffffffffa051f20f | | 0xffffffffa05a170c | | 0xffffffffa05a1a2d | | 0xffffffffa04b565a | | read_pages | | __do_page_cache_readahead | | force_page_cache_readahead | | sys_fadvise64_64 | | system_call_fastpath | | 0x7fb873db9e5d | | posix_fadvise | | | |--30.00%-- 0xffffffffa054b712 | | | | | |--66.70%-- 0xffffffffa059eede | | | 0xffffffffa05a18a9 | | | 0xffffffffa05a1a2d | | | 0xffffffffa04b565a | | | read_pages | | | __do_page_cache_readahead | | | force_page_cache_readahead | | | sys_fadvise64_64 | | | system_call_fastpath | | | 0x7fb873db9e5d | | | posix_fadvise | | | | | --33.30%-- 0xffffffffa056f34a | | 0xffffffffa04c61ab | | vfs_read | | sys_read | | system_call_fastpath | | 0x7fb873db55d0 | | __GI___read | | | |--10.02%-- 0xffffffffa0513b5f | | 0xffffffffa04b5723 | | read_pages | | __do_page_cache_readahead | | force_page_cache_readahead | | sys_fadvise64_64 | | system_call_fastpath | | 0x7fb873db9e5d | | posix_fadvise | | | |--10.00%-- 0xffffffffa05a1736 | | 0xffffffffa05a1a2d | | 0xffffffffa04b565a | | read_pages | | __do_page_cache_readahead | | force_page_cache_readahead | | sys_fadvise64_64 | | system_call_fastpath | | 0x7fb873db9e5d | | posix_fadvise | | | --9.97%-- 0xffffffffa0513be7 | 0xffffffffa059eaa9 | 0xffffffffa05a18a9 | 0xffffffffa05a1a2d | 0xffffffffa04b565a | read_pages | __do_page_cache_readahead | force_page_cache_readahead | sys_fadvise64_64 | system_call_fastpath | 0x7fb873db9e5d | posix_fadvise | |--14.31%-- 0xffffffffa0513c8d | | | |--66.68%-- 0xffffffffa052e859 | | 0xffffffffa059f09d | | 0xffffffffa05a18a9 | | 0xffffffffa05a1a2d | | 0xffffffffa04b565a | | read_pages | | __do_page_cache_readahead | | force_page_cache_readahead | | sys_fadvise64_64 | | system_call_fastpath | | 0x7fb873db9e5d | | posix_fadvise | | | --33.32%-- 0xffffffffa059eaa9 | 0xffffffffa05a18a9 | 0xffffffffa05a1a2d | 0xffffffffa04b565a | read_pages | __do_page_cache_readahead | force_page_cache_readahead | sys_fadvise64_64 | system_call_fastpath | 0x7fb873db9e5d | posix_fadvise | |--9.53%-- 0xffffffffa056f364 | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | |--9.40%-- 0xffffffffa05a1795 | 0xffffffffa05a1a2d | 0xffffffffa04b565a | read_pages | __do_page_cache_readahead | force_page_cache_readahead | sys_fadvise64_64 | system_call_fastpath | 0x7fb873db9e5d | posix_fadvise | |--4.77%-- 0xffffffffa0541942 | 0xffffffffa051f20f | 0xffffffffa05a170c | 0xffffffffa05a1a2d | 0xffffffffa04b565a | read_pages | __do_page_cache_readahead | force_page_cache_readahead | sys_fadvise64_64 | system_call_fastpath | 0x7fb873db9e5d | posix_fadvise | |--4.77%-- 0xffffffffa05a17a1 | 0xffffffffa05a1a2d | 0xffffffffa04b565a | read_pages | __do_page_cache_readahead | force_page_cache_readahead | sys_fadvise64_64 | system_call_fastpath | 0x7fb873db9e5d | posix_fadvise | |--4.76%-- 0xffffffffa059eb1e | 0xffffffffa05a18a9 | 0xffffffffa05a1a2d | 0xffffffffa04b565a | read_pages | __do_page_cache_readahead | force_page_cache_readahead | sys_fadvise64_64 | system_call_fastpath | 0x7fb873db9e5d | posix_fadvise | --4.74%-- 0xffffffffa04b5723 read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise 0.67% 20 postgres postgres [.] check_stack_depth | --- check_stack_depth | |--80.00%-- ExecMakeFunctionResultNoSets | ExecQual | | | |--93.76%-- BitmapHeapNext | | ExecScan | | ExecProcNode | | ExecAgg | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --6.24%-- ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --20.00%-- ExecQual BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.63% 19 postgres postgres [.] LWLockAttemptLock | --- LWLockAttemptLock LWLockAcquire | |--84.22%-- BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --15.78%-- StartBufferIO ReadBuffer_common ReadBufferExtended BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.60% 18 postgres postgres [.] PredicateLockTuple | --- PredicateLockTuple BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.57% 17 postgres [kernel.kallsyms] [k] _raw_spin_lock_irqsave | --- _raw_spin_lock_irqsave | |--47.10%-- up | | | |--25.02%-- 0xffffffffa053ac7c | | 0xffffffffa051f34a | | 0xffffffffa0560b17 | | 0xffffffffa04aeb14 | | 0xffffffffa04c602f | | vfs_read | | sys_read | | system_call_fastpath | | 0x7fb873db55d0 | | __GI___read | | | |--12.52%-- 0xffffffffa056f364 | | 0xffffffffa04c61ab | | vfs_read | | sys_read | | system_call_fastpath | | 0x7fb873db55d0 | | __GI___read | | | |--12.52%-- 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 | | | |--12.52%-- 0xffffffffa04b5723 | | read_pages | | __do_page_cache_readahead | | force_page_cache_readahead | | sys_fadvise64_64 | | system_call_fastpath | | 0x7fb873db9e5d | | posix_fadvise | | | |--12.49%-- 0xffffffffa0541942 | | 0xffffffffa05718be | | 0xffffffffa04c61ab | | vfs_read | | sys_read | | system_call_fastpath | | 0x7fb873db55d0 | | __GI___read | | | |--12.47%-- 0xffffffffa059eb0c | | 0xffffffffa05a18a9 | | 0xffffffffa05a1a2d | | 0xffffffffa04b565a | | read_pages | | __do_page_cache_readahead | | force_page_cache_readahead | | sys_fadvise64_64 | | system_call_fastpath | | 0x7fb873db9e5d | | posix_fadvise | | | --12.46%-- 0xffffffffa051f3b9 | 0xffffffffa05a17f1 | 0xffffffffa05a1a2d | 0xffffffffa04b565a | read_pages | __do_page_cache_readahead | force_page_cache_readahead | sys_fadvise64_64 | system_call_fastpath | 0x7fb873db9e5d | posix_fadvise | |--47.04%-- down | 0xffffffffa04a89cf | | | |--37.50%-- 0xffffffffa0513be7 | | | | | |--66.71%-- 0xffffffffa052e859 | | | 0xffffffffa059f09d | | | 0xffffffffa05a18a9 | | | 0xffffffffa05a1a2d | | | 0xffffffffa04b565a | | | read_pages | | | __do_page_cache_readahead | | | force_page_cache_readahead | | | sys_fadvise64_64 | | | system_call_fastpath | | | 0x7fb873db9e5d | | | posix_fadvise | | | | | --33.29%-- 0xffffffffa059eaa9 | | 0xffffffffa05a18a9 | | 0xffffffffa05a1a2d | | 0xffffffffa04b565a | | read_pages | | __do_page_cache_readahead | | force_page_cache_readahead | | sys_fadvise64_64 | | system_call_fastpath | | 0x7fb873db9e5d | | posix_fadvise | | | |--25.02%-- 0xffffffffa051f54e | | | | | |--50.01%-- 0xffffffffa054182c | | | 0xffffffffa05718be | | | 0xffffffffa04c61ab | | | vfs_read | | | sys_read | | | system_call_fastpath | | | 0x7fb873db55d0 | | | __GI___read | | | | | --49.99%-- 0xffffffffa0541346 | | 0xffffffffa0570c42 | | 0xffffffffa04c61ab | | vfs_read | | sys_read | | system_call_fastpath | | 0x7fb873db55d0 | | __GI___read | | | |--24.96%-- 0xffffffffa054b712 | | 0xffffffffa059eede | | 0xffffffffa05a18a9 | | 0xffffffffa05a1a2d | | 0xffffffffa04b565a | | read_pages | | __do_page_cache_readahead | | force_page_cache_readahead | | sys_fadvise64_64 | | system_call_fastpath | | 0x7fb873db9e5d | | posix_fadvise | | | --12.52%-- 0xffffffffa0513b5f | 0xffffffffa059eb1e | 0xffffffffa05a18a9 | 0xffffffffa05a1a2d | 0xffffffffa04b565a | read_pages | __do_page_cache_readahead | force_page_cache_readahead | sys_fadvise64_64 | system_call_fastpath | 0x7fb873db9e5d | posix_fadvise | --5.86%-- pagevec_lru_move_fn __lru_cache_add add_to_page_cache_lru read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise 0.52% 111 swapper [kernel.kallsyms] [k] intel_idle | --- intel_idle cpuidle_idle_call cpu_idle | --100.00%-- start_kernel x86_64_start_kernel 0.50% 15 postgres postgres [.] ResourceOwnerEnlargeBuffers | --- ResourceOwnerEnlargeBuffers | |--86.71%-- IncrBufferRefCount | ExecStoreTuple | BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --13.29%-- ExecStoreTuple BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.50% 15 postgres postgres [.] MemoryContextReset | --- MemoryContextReset | |--80.04%-- BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --19.96%-- ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.50% 15 postgres postgres [.] PinBuffer | --- PinBuffer ReadBuffer_common ReadBufferExtended BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.47% 14 postgres postgres [.] CheckForSerializableConflictOut | --- CheckForSerializableConflictOut | |--64.26%-- BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --35.74%-- ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.45% 14 postgres postgres [.] float48ge | --- float48ge | |--51.19%-- ExecQual | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --48.81%-- ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.43% 13 postgres [kernel.kallsyms] [k] _raw_spin_lock | --- _raw_spin_lock | |--92.25%-- __do_fault | handle_pte_fault | do_page_fault | page_fault | | | |--49.50%-- 0x49f6c7 | | heap_page_prune_opt | | BitmapHeapNext | | ExecScan | | ExecProcNode | | ExecAgg | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | |--33.68%-- 0x7a5772 | | HeapTupleSatisfiesMVCC | | BitmapHeapNext | | ExecScan | | ExecProcNode | | ExecAgg | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --16.82%-- copy_user_generic_string | 0xffffffffa04bfedc | 0xffffffffa04c021c | 0xffffffffa0554e96 | 0xffffffffa056facb | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --7.75%-- try_to_wake_up __wake_up_common __wake_up 0xffffffffa04be300 0xffffffffa05beb72 0xffffffffa052de66 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise 0.37% 11 postgres postgres [.] TransactionIdPrecedes | --- TransactionIdPrecedes | |--72.72%-- HeapTupleSatisfiesMVCC | BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --27.28%-- XidInMVCCSnapshot HeapTupleSatisfiesMVCC BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.37% 11 postgres postgres [.] XidInMVCCSnapshot | --- XidInMVCCSnapshot | |--63.63%-- HeapTupleSatisfiesMVCC | BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --36.37%-- BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.33% 10 postgres [kernel.kallsyms] [k] get_page_from_freelist | --- get_page_from_freelist __alloc_pages_nodemask alloc_pages_current __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise 0.33% 10 postgres [kernel.kallsyms] [k] __cache_free | --- __cache_free kfree | |--70.00%-- 0xffffffffa05a17f1 | 0xffffffffa05a1a2d | 0xffffffffa04b565a | read_pages | __do_page_cache_readahead | force_page_cache_readahead | sys_fadvise64_64 | system_call_fastpath | 0x7fb873db9e5d | posix_fadvise | --30.00%-- 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise 0.32% 1 postgres [kernel.kallsyms] [k] __kmalloc | --- __kmalloc | |--92.69%-- 0xffffffffa04ade30 | | | |--66.68%-- 0xffffffffa05a19ed | | 0xffffffffa04b565a | | read_pages | | __do_page_cache_readahead | | force_page_cache_readahead | | sys_fadvise64_64 | | system_call_fastpath | | 0x7fb873db9e5d | | posix_fadvise | | | --33.32%-- 0xffffffffa05a1638 | 0xffffffffa05a1a2d | 0xffffffffa04b565a | read_pages | __do_page_cache_readahead | force_page_cache_readahead | sys_fadvise64_64 | system_call_fastpath | 0x7fb873db9e5d | posix_fadvise | --7.31%-- ext3_htree_store_dirent htree_dirblock_to_tree ext3_htree_fill_tree ext3_dx_readdir ext3_readdir vfs_readdir sys_getdents64 system_call_fastpath 0x7fb873d8c7fa __getdents 0.30% 9 postgres postgres [.] ExecScan | --- ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.28% 10 postgres postgres [.] hash_search_with_hash_value | --- hash_search_with_hash_value tbm_mark_page_lossy tbm_add_page bringetbitmap FunctionCall2Coll index_getbitmap MultiExecBitmapIndexScan BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.28% 9 postgres postgres [.] hash_any | --- hash_any | |--40.86%-- CHashSearch | BufTableLookup | | | |--57.93%-- ReadBuffer_common | | ReadBufferExtended | | BitmapHeapNext | | ExecScan | | ExecProcNode | | ExecAgg | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --42.07%-- PrefetchBuffer | BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--23.70%-- CHashInsert | BufTableInsert | ReadBuffer_common | ReadBufferExtended | BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--11.83%-- tag_hash | hash_search | tbm_mark_page_lossy | tbm_add_page | bringetbitmap | FunctionCall2Coll | index_getbitmap | MultiExecBitmapIndexScan | BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--11.81%-- hash_search | tbm_mark_page_lossy | tbm_add_page | bringetbitmap | FunctionCall2Coll | index_getbitmap | MultiExecBitmapIndexScan | BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --11.80%-- CHashDelete BufTableDelete ReadBuffer_common ReadBufferExtended BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.27% 8 postgres [kernel.kallsyms] [k] __do_fault | --- __do_fault handle_pte_fault do_page_fault page_fault | |--49.98%-- 0x49f6c7 | heap_page_prune_opt | BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--25.04%-- copy_user_generic_string | 0xffffffffa04bfedc | 0xffffffffa04c021c | 0xffffffffa0554e96 | 0xffffffffa056facb | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --24.97%-- 0x7a5772 HeapTupleSatisfiesMVCC BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.27% 8 postgres libc-2.11.3.so [.] __GI___isnan | --- __GI___isnan | |--87.45%-- float48ge | ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --12.55%-- float48le ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.23% 7 postgres [kernel.kallsyms] [k] handle_mm_fault | --- handle_mm_fault do_page_fault page_fault | |--28.61%-- 0x7a5772 | HeapTupleSatisfiesMVCC | BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--28.56%-- 0x7a5888 | HeapTupleSatisfiesMVCC | BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--28.55%-- copy_user_generic_string | 0xffffffffa04bfedc | 0xffffffffa04c021c | 0xffffffffa0554e96 | 0xffffffffa056facb | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --14.28%-- 0x674c50 PinBuffer ReadBuffer_common ReadBufferExtended BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.22% 32 postgres postgres [.] SyncOneBuffer | --- SyncOneBuffer | |--98.14%-- BgBufferSync | BackgroundWriterMain | AuxiliaryProcessMain | StartChildProcess | reaper | __restore_rt | PostmasterMain | main | __libc_start_main | --1.86%-- BackgroundWriterMain AuxiliaryProcessMain StartChildProcess reaper __restore_rt PostmasterMain main __libc_start_main 0.22% 4 swapper [kernel.kallsyms] [k] rcu_exit_nohz | --- rcu_exit_nohz tick_nohz_restart_sched_tick cpu_idle | --100.00%-- start_kernel x86_64_start_kernel 0.22% 61 mmfsd [unknown] [.] 0x5af0be | --- 0x7ffb7c11f3d5 0xffffc900341c3998 | --- 0x5b6859 | |--48.32%-- 0x1c4c51 | |--46.49%-- 0x900000002 | --5.19%-- 0xffffc900341c3998 | --- 0x5bf5ab 0x894a5c96d0 0x1804a5c97c0 0x184aba | --- 0x7ffb7c0f3e53 (nil) | --- 0x7ffb7c0c76f2 (nil) | --- 0x68971e 0x900000000 | --- 0x64282b 0x908f7d02000000 | --- 0x7ffb7c69ac40 0x250158f730 0x15aa1e8 0xb10ff0d089ff4a8d | --- 0x5c2209 0x900000000370000 | --- 0x5af219 0xffffc900341c3998 | --- 0x5af150 0xffffc900341c3998 | --- 0x6d7b7f (nil) | --- 0x74a3a2 0x9bcbbbb12 | --- 0x5bc08e | --- 0x68a3e5 0x184aaa | --- 0x7ffb7c0c76f5 0x3f47660f00000008 | --- 0x5b6876 | |--94.26%-- 0x322779fb00000012 | --5.74%-- 0x1849aa | --- 0x5bcd0f 0x1849a5 | --- 0x6d807b | |--92.28%-- 0x1c4c59 | --7.72%-- 0x184a4c | --- 0x89a3e4 0xffffc900439604a8 | --- 0x5af26f 0xffffc900341c3998 | --- 0x91033b 0x3f47516e00000008 | --- 0x5c306b | --- 0x5c9124 (nil) | --- 0x5e3685 | |--93.78%-- 0xffffc9003662a000 | --6.22%-- 0xffffc9004670db58 | --- 0x5e1756 0xffffc90043997920 | --- 0x5c3b91 0x184a4c | --- 0x5c5145 | --- 0x92b038 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 0x7ffb67d416e0 0x7ffb6c004a48 | --- 0x5d4347 | --- 0x72b91a | --- 0x7ffb7c6a1180 0x564bc14300000009 | --- 0x763904 0x184a4c | --- 0x6c50bf 0x9bcbbbb12 | --- 0x921189 | --- 0x68be59 0xe00000000 | --- 0x641459 0xa0515519000000 0.20% 6 postgres postgres [.] CHashSearch | --- CHashSearch | |--83.31%-- BufTableLookup | | | |--60.00%-- PrefetchBuffer | | BitmapHeapNext | | ExecScan | | ExecProcNode | | ExecAgg | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --40.00%-- ReadBuffer_common | ReadBufferExtended | BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --16.69%-- PrefetchBuffer BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.20% 6 postgres [kernel.kallsyms] [k] shmem_getpage_gfp | --- shmem_getpage_gfp | |--83.37%-- shmem_fault | __do_fault | handle_pte_fault | do_page_fault | page_fault | | | |--79.95%-- 0x7a5772 | | HeapTupleSatisfiesMVCC | | BitmapHeapNext | | ExecScan | | ExecProcNode | | ExecAgg | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --20.05%-- copy_user_generic_string | 0xffffffffa04bfedc | 0xffffffffa04c021c | 0xffffffffa0553f90 | 0xffffffffa05715f4 | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --16.63%-- __GI___read 0.19% 2 mmfsd [kernel.kallsyms] [k] _raw_spin_unlock_irqrestore | --- _raw_spin_unlock_irqrestore | |--99.54%-- 0x296 | 0x7ffb7c11f3d7 | 0xffffc900341c3998 --0.46%-- [...] 0.17% 5 postgres postgres [.] CHashDelete | --- CHashDelete BufTableDelete ReadBuffer_common ReadBufferExtended BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.17% 5 postgres [kernel.kallsyms] [k] __mem_cgroup_commit_charge | --- __mem_cgroup_commit_charge __mem_cgroup_commit_charge_lrucare mem_cgroup_cache_charge add_to_page_cache_locked add_to_page_cache add_to_page_cache_lru read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise 0.17% 5 postgres [kernel.kallsyms] [k] down_read_trylock | --- down_read_trylock do_page_fault page_fault | |--40.02%-- 0x7a5772 | HeapTupleSatisfiesMVCC | BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--40.02%-- 0x49f6c7 | heap_page_prune_opt | BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --19.96%-- copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0554e96 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.17% 5 postgres [kernel.kallsyms] [k] mem_cgroup_count_vm_event | --- mem_cgroup_count_vm_event handle_mm_fault do_page_fault page_fault | |--40.02%-- copy_user_generic_string | 0xffffffffa04bfedc | 0xffffffffa04c021c | | | |--50.12%-- 0xffffffffa0553f90 | | 0xffffffffa05715f4 | | 0xffffffffa04c61ab | | vfs_read | | sys_read | | system_call_fastpath | | 0x7fb873db55d0 | | __GI___read | | | --49.88%-- 0xffffffffa0554e96 | 0xffffffffa056facb | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | |--20.01%-- 0x7a5772 | HeapTupleSatisfiesMVCC | BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--20.00%-- 0x49f6c7 | heap_page_prune_opt | BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --19.97%-- 0x7a5888 HeapTupleSatisfiesMVCC BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.17% 5 postgres postgres [.] BufTableLookup | --- BufTableLookup | |--40.07%-- ReadBufferExtended | BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--39.95%-- BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --19.98%-- PrefetchBuffer BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.17% 5 postgres [kernel.kallsyms] [k] __rmqueue | --- __rmqueue get_page_from_freelist __alloc_pages_nodemask alloc_pages_current __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise 0.17% 5 postgres postgres [.] tbm_iterate | --- tbm_iterate | |--59.85%-- BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --40.15%-- ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.13% 4 postgres [kernel.kallsyms] [k] fget | --- fget sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise 0.13% 4 postgres [kernel.kallsyms] [k] unlock_page | --- unlock_page | |--49.96%-- 0xffffffffa04b5b78 | 0xffffffffa059e9af | 0xffffffffa05a18a9 | 0xffffffffa05a1a2d | 0xffffffffa04b565a | read_pages | __do_page_cache_readahead | force_page_cache_readahead | sys_fadvise64_64 | system_call_fastpath | 0x7fb873db9e5d | posix_fadvise | |--25.03%-- 0xffffffffa04b5514 | read_pages | __do_page_cache_readahead | force_page_cache_readahead | sys_fadvise64_64 | system_call_fastpath | 0x7fb873db9e5d | posix_fadvise | --25.01%-- __do_fault handle_pte_fault do_page_fault page_fault 0x7a5772 HeapTupleSatisfiesMVCC BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.13% 4 postgres postgres [.] UnpinBuffer | --- UnpinBuffer ReleaseAndReadBuffer BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.13% 4 postgres [kernel.kallsyms] [k] radix_tree_lookup | --- radix_tree_lookup __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise 0.13% 4 postgres postgres [.] PrefetchBuffer | --- PrefetchBuffer BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.13% 4 postgres postgres [.] LWLockRelease | --- LWLockRelease | |--50.02%-- BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.98%-- ReadBuffer_common ReadBufferExtended BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.13% 4 postgres [kernel.kallsyms] [k] lookup_page_cgroup | --- lookup_page_cgroup | |--49.96%-- mem_cgroup_update_page_stat | __do_fault | handle_pte_fault | do_page_fault | page_fault | | | |--50.01%-- copy_user_generic_string | | 0xffffffffa04bfedc | | 0xffffffffa04c021c | | 0xffffffffa0554e96 | | 0xffffffffa056facb | | 0xffffffffa04c61ab | | vfs_read | | sys_read | | system_call_fastpath | | 0x7fb873db55d0 | | __GI___read | | | --49.99%-- 0x7a5772 | HeapTupleSatisfiesMVCC | BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--25.09%-- mem_cgroup_add_lru_list | pagevec_lru_move_fn | __lru_cache_add | add_to_page_cache_lru | read_pages | __do_page_cache_readahead | force_page_cache_readahead | sys_fadvise64_64 | system_call_fastpath | 0x7fb873db9e5d | posix_fadvise | --24.96%-- __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.13% 4 postgres postgres [.] InstrStopNode | --- InstrStopNode ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.13% 3 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.12% 4 postgres postgres [.] CHashAddToGarbage | --- CHashAddToGarbage CHashDelete BufTableDelete ReadBuffer_common ReadBufferExtended BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.11% 4 postgres libc-2.11.3.so [.] __GI_memcpy | --- __GI_memcpy | |--62.21%-- BufTableLookup | | | |--50.03%-- ReadBuffer_common | | ReadBufferExtended | | BitmapHeapNext | | ExecScan | | ExecProcNode | | ExecAgg | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --49.97%-- PrefetchBuffer | BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--31.11%-- BufTableInsert | ReadBuffer_common | ReadBufferExtended | BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --6.69%-- SearchCatCacheList OpernameGetCandidates oper make_op transformExprRecurse transformBoolExpr transformExprRecurse transformBoolExpr transformExprRecurse transformExpr transformWhereClause transformStmt transformStmt parse_analyze pg_analyze_and_rewrite exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.10% 2 postgres [kernel.kallsyms] [k] release_pages | --- release_pages | |--64.34%-- pagevec_lru_move_fn | __lru_cache_add | add_to_page_cache_lru | read_pages | __do_page_cache_readahead | force_page_cache_readahead | sys_fadvise64_64 | system_call_fastpath | 0x7fb873db9e5d | posix_fadvise | --35.66%-- free_pages_and_swap_cache tlb_flush_mmu zap_pte_range unmap_page_range unmap_vmas exit_mmap mmput exit_mm do_exit do_group_exit sys_exit_group system_call_fastpath 0x7fb873d90a38 0.10% 3 postgres [kernel.kallsyms] [k] vfs_read | --- vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.10% 3 postgres [kernel.kallsyms] [k] __do_page_cache_readahead | --- __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise 0.10% 3 postgres [kernel.kallsyms] [k] mem_cgroup_add_lru_list | --- mem_cgroup_add_lru_list pagevec_lru_move_fn __lru_cache_add add_to_page_cache_lru read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise 0.10% 3 postgres [kernel.kallsyms] [k] find_or_create_page | --- 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 0.10% 3 postgres [kernel.kallsyms] [k] kfree | --- kfree | |--33.38%-- 0xffffffffa05a17f1 | 0xffffffffa05a1a2d | 0xffffffffa04b565a | read_pages | __do_page_cache_readahead | force_page_cache_readahead | sys_fadvise64_64 | system_call_fastpath | 0x7fb873db9e5d | posix_fadvise | |--33.36%-- 0x1 | posix_fadvise | --33.25%-- 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise 0.10% 3 postgres [kernel.kallsyms] [k] fsnotify | --- fsnotify | |--66.73%-- rw_verify_area | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --33.27%-- vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.10% 3 postgres libc-2.11.3.so [.] posix_fadvise | --- posix_fadvise BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.10% 3 postgres [kernel.kallsyms] [k] find_lock_page | --- find_lock_page | |--33.34%-- posix_fadvise | |--33.34%-- 0xd0c0b50a98 | __GI___read | --33.32%-- shmem_getpage_gfp shmem_fault __do_fault handle_pte_fault do_page_fault page_fault copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0554e96 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.10% 3 postgres postgres [.] FileSeek | --- FileSeek mdread ReadBuffer_common ReadBufferExtended BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.10% 3 postgres postgres [.] _mdfd_getseg | --- _mdfd_getseg | |--66.74%-- mdread | ReadBuffer_common | ReadBufferExtended | BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --33.26%-- mdprefetch PrefetchBuffer BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.10% 1 perf [kernel.kallsyms] [k] vsnprintf | --- vsnprintf seq_printf proc_pid_status proc_single_show seq_read vfs_read sys_read system_call_fastpath 0x7f59d68a95d0 __GI___read 0.08% 3 postgres [kernel.kallsyms] [k] __task_pid_nr_ns | --- __task_pid_nr_ns 0xffffffffa04bfec2 0xffffffffa04c021c 0xffffffffa0554e96 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.07% 1 postgres [kernel.kallsyms] [k] do_page_fault | --- do_page_fault page_fault | |--44.84%-- 0x49f6c7 | heap_page_prune_opt | BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--44.30%-- copy_user_generic_string | 0xffffffffa04bfedc | 0xffffffffa04c021c | 0xffffffffa0554e96 | 0xffffffffa056facb | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --10.86%-- 0x68faf0 LWLockAcquire InitProcessPhase2 InitPostgres PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 ksoftirqd/0 [kernel.kallsyms] [k] get_pageblock_flags_group | --- get_pageblock_flags_group free_hot_cold_page rb_free rcu_do_batch rcu_process_callbacks __do_softirq run_ksoftirqd kthread kernel_thread_helper 0.07% 2 postgres [kernel.kallsyms] [k] error_kernelspace | --- error_kernelspace copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0554e96 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.07% 2 postgres [kernel.kallsyms] [k] prep_new_page | --- prep_new_page get_page_from_freelist __alloc_pages_nodemask alloc_pages_current __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise 0.07% 2 postgres postgres [.] mdread | --- mdread | |--50.04%-- ReadBufferExtended | BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.96%-- ReadBuffer_common ReadBufferExtended BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 2 postgres [kernel.kallsyms] [k] error_entry | --- error_entry | |--50.03%-- copy_user_generic_string | 0xffffffffa04bfedc | 0xffffffffa04c021c | 0xffffffffa0554e96 | 0xffffffffa056facb | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --49.97%-- 0x7a5772 HeapTupleSatisfiesMVCC BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 2 postgres [kernel.kallsyms] [k] put_page | --- put_page __do_fault handle_pte_fault do_page_fault page_fault copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0554e96 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.07% 2 postgres postgres [.] FileAccess | --- FileAccess | |--50.00%-- FilePrefetch | PrefetchBuffer | BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --50.00%-- FileRead mdread ReadBuffer_common ReadBufferExtended BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 2 postgres [vdso] [.] 0x7fffe8fff8c1 | --- 0x7fffe8fff8b6 __gettimeofday_internal ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff8c1 __gettimeofday_internal ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 2 postgres [kernel.kallsyms] [k] down | --- down 0xffffffffa04a89cf | |--50.03%-- 0xffffffffa051f54e | 0xffffffffa0541346 | 0xffffffffa051f3b9 | 0xffffffffa05a17f1 | 0xffffffffa05a1a2d | 0xffffffffa04b565a | read_pages | __do_page_cache_readahead | force_page_cache_readahead | sys_fadvise64_64 | system_call_fastpath | 0x7fb873db9e5d | posix_fadvise | --49.97%-- 0xffffffffa054b712 0xffffffffa056f34a 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.07% 2 postgres [kernel.kallsyms] [k] __lru_cache_add | --- __lru_cache_add add_to_page_cache_lru read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise 0.07% 2 postgres postgres [.] FileRead | --- FileRead mdread ReadBuffer_common ReadBufferExtended BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 2 postgres [kernel.kallsyms] [k] __alloc_pages_nodemask | --- __alloc_pages_nodemask alloc_pages_current __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise 0.07% 2 postgres [kernel.kallsyms] [k] handle_pte_fault | --- handle_pte_fault do_page_fault page_fault 0x7a5772 HeapTupleSatisfiesMVCC BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 2 postgres [kernel.kallsyms] [k] getnstimeofday | --- getnstimeofday 0xffffffffa04a8d10 0xffffffffa0554b33 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.07% 2 postgres postgres [.] float48le | --- float48le | |--50.06%-- ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.94%-- ExecQual ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 2 postgres [kernel.kallsyms] [k] pagevec_lru_move_fn | --- pagevec_lru_move_fn __lru_cache_add add_to_page_cache_lru read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise 0.07% 2 postgres postgres [.] ExecAgg | --- ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 2 postgres postgres [.] PageIsVerified | --- PageIsVerified ReadBufferExtended BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 2 postgres postgres [.] float8_cmp_internal | --- float8_cmp_internal float48ge ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 2 postgres [kernel.kallsyms] [k] sysret_check | --- sysret_check | |--50.04%-- 0x7fb873db55d0 | __GI___read | --49.96%-- posix_fadvise 0.07% 2 postgres [kernel.kallsyms] [k] shmem_fault | --- shmem_fault __do_fault handle_pte_fault do_page_fault page_fault | |--50.14%-- copy_user_generic_string | 0xffffffffa04bfedc | 0xffffffffa04c021c | 0xffffffffa0554e96 | 0xffffffffa056facb | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --49.86%-- 0x7a5772 HeapTupleSatisfiesMVCC BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 2 postgres postgres [.] ReadBufferExtended | --- ReadBufferExtended | |--50.02%-- ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.98%-- BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 2 postgres [kernel.kallsyms] [k] page_add_file_rmap | --- page_add_file_rmap __do_fault handle_pte_fault do_page_fault page_fault | |--50.10%-- 0x49f6c7 | heap_page_prune_opt | BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.90%-- copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0554e96 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.07% 2 postgres [kernel.kallsyms] [k] system_call_after_swapgs | --- system_call_after_swapgs | |--50.27%-- 0x7fb873db55d0 | posix_fadvise | --49.73%-- 0x7fb873db9e5d HeapTupleSatisfiesMVCC BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.06% 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.04% 2 postgres postgres [.] hash_search | --- hash_search tbm_mark_page_lossy tbm_add_page bringetbitmap FunctionCall2Coll index_getbitmap MultiExecBitmapIndexScan BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.04% 1 postgres [kernel.kallsyms] [k] free_pages_and_swap_cache | --- free_pages_and_swap_cache tlb_flush_mmu zap_pte_range unmap_page_range unmap_vmas exit_mmap mmput exit_mm do_exit do_group_exit sys_exit_group system_call_fastpath 0x7fb873d90a38 0.03% 1 postgres [kernel.kallsyms] [k] __mem_cgroup_uncharge_common | --- __mem_cgroup_uncharge_common 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.03% 1 postgres postgres [.] DataChecksumsEnabled | --- DataChecksumsEnabled ReadBuffer_common ReadBufferExtended BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.03% 1 postgres [ipt_REJECT] [.] 0x5ef30188 | --- 0xffffffffff600188 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.03% 1 postgres postgres [.] __isnan@plt | --- __isnan@plt float48le ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.03% 1 postgres postgres [.] PinBuffer_Locked | --- PinBuffer_Locked ReadBuffer_common ReadBufferExtended BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.03% 1 postgres [kernel.kallsyms] [k] max_sane_readahead | --- max_sane_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise 0.03% 1 postgres postgres [.] StartBufferIO | --- StartBufferIO ReadBuffer_common ReadBufferExtended BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.03% 1 postgres [kernel.kallsyms] [k] _raw_spin_lock_irq | --- _raw_spin_lock_irq 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.03% 1 postgres postgres [.] LockBuffer | --- LockBuffer BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.03% 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.03% 1 postgres [kernel.kallsyms] [k] radix_tree_insert | --- radix_tree_insert 0x3b676 posix_fadvise 0.03% 1 postgres postgres [.] IsCatalogRelation | --- IsCatalogRelation BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.03% 1 postgres [kernel.kallsyms] [k] cache_alloc_refill | --- cache_alloc_refill kmem_cache_alloc __radix_tree_preload 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.03% 1 postgres [kernel.kallsyms] [k] sys_read | --- sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.03% 1 postgres [kernel.kallsyms] [k] perf_rotate_context | --- perf_rotate_context perf_event_task_tick scheduler_tick update_process_times tick_sched_timer __run_hrtimer hrtimer_interrupt smp_apic_timer_interrupt apic_timer_interrupt 0x46f010 slot_deform_tuple slot_getattr ExecMakeFunctionResultNoSets ExecQual BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.03% 1 postgres [kernel.kallsyms] [k] sys_fadvise64_64 | --- sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise 0.03% 1 postgres postgres [.] Float4GetDatum | --- Float4GetDatum ExecProject advance_aggregates ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.03% 1 postgres postgres [.] float48lt | --- float48lt ExecQual ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.03% 1 postgres libc-2.11.3.so [.] __gettimeofday_internal | --- __gettimeofday_internal ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.03% 1 postgres postgres [.] DatumGetFloat4 | --- DatumGetFloat4 float48ge ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.03% 1 postgres postgres [.] IsToastNamespace | --- IsToastNamespace heap_page_prune_opt BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.03% 1 postgres [kernel.kallsyms] [k] fget_light | --- fget_light sys_lseek system_call_fastpath 0x7fb873dc30d0 __lseek64 0.03% 1 postgres postgres [.] TerminateBufferIO | --- TerminateBufferIO ReadBuffer_common ReadBufferExtended BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.03% 1 postgres postgres [.] smgrread | --- smgrread ReadBufferExtended BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.03% 1 postgres [kernel.kallsyms] [k] try_to_wake_up | --- try_to_wake_up up 0xffffffffa04a8b20 0xffffffffa05c07e5 0xffffffffa05c0acd 0xffffffffa052e26f 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise 0.03% 1 postgres [kernel.kallsyms] [k] radix_tree_node_alloc | --- radix_tree_node_alloc radix_tree_insert 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.03% 1 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 0x49f6c7 heap_page_prune_opt BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.03% 1 postgres libc-2.11.3.so [.] __GI___read | --- __GI___read mdread ReadBuffer_common ReadBufferExtended BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.03% 1 postgres postgres [.] advance_transition_function | --- advance_transition_function ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.03% 1 postgres postgres [.] mdopen | --- mdopen mdread ReadBuffer_common ReadBufferExtended BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.03% 1 postgres [kernel.kallsyms] [k] error_swapgs | --- error_swapgs 0x7a5772 HeapTupleSatisfiesMVCC BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.03% 1 postgres [kernel.kallsyms] [k] __radix_tree_preload | --- __radix_tree_preload 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.03% 1 postgres [kernel.kallsyms] [k] memcg_check_events | --- memcg_check_events __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.03% 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 0xffffffffa0554e96 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.03% 1 postgres [kernel.kallsyms] [k] update_rq_clock | --- update_rq_clock scheduler_tick update_process_times tick_sched_timer __run_hrtimer hrtimer_interrupt smp_apic_timer_interrupt apic_timer_interrupt copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0554e96 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.03% 1 postgres postgres [.] IsCatalogClass | --- IsCatalogClass BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.03% 1 postgres [kernel.kallsyms] [k] ttwu_stat | --- ttwu_stat try_to_wake_up up 0xffffffffa04a8b20 0xffffffffa05c07e5 0xffffffffa05c0acd 0xffffffffa052e26f 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise 0.03% 1 postgres [kernel.kallsyms] [k] up | --- up 0xffffffffa05a17a1 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise 0.03% 1 postgres [kernel.kallsyms] [k] apparmor_file_permission | --- apparmor_file_permission security_file_permission rw_verify_area vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.03% 1 postgres [kernel.kallsyms] [k] clear_page_c | --- clear_page_c prep_new_page get_page_from_freelist __alloc_pages_nodemask alloc_pages_current pte_alloc_one __pte_alloc handle_mm_fault do_page_fault page_fault 0x49f6c7 heap_page_prune_opt BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.03% 1 postgres [kernel.kallsyms] [k] mem_cgroup_get_reclaim_stat_from_page | --- mem_cgroup_get_reclaim_stat_from_page update_page_reclaim_stat ____pagevec_lru_add_fn pagevec_lru_move_fn __lru_cache_add add_to_page_cache_lru read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise 0.03% 1 postgres postgres [.] advance_aggregates | --- advance_aggregates ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.03% 1 postgres postgres [.] ReadBuffer_common | --- ReadBuffer_common ReadBufferExtended BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.03% 1 postgres libc-2.11.3.so [.] __lseek64 | --- __lseek64 mdread ReadBuffer_common ReadBufferExtended BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.03% 1 postgres postgres [.] ExecProcNode | --- ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.03% 1 postgres [kernel.kallsyms] [k] add_to_page_cache_locked | --- 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.03% 1 postgres postgres [.] isTempToastNamespace | --- isTempToastNamespace IsCatalogClass heap_page_prune_opt BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.03% 1 postgres postgres [.] ExecProject | --- ExecProject advance_aggregates ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.03% 1 postgres [kernel.kallsyms] [k] read_pages | --- read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise 0.03% 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.03% 1 postgres [kernel.kallsyms] [k] blk_finish_plug | --- blk_finish_plug read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise 0.03% 1 postgres postgres [.] tbm_mark_page_lossy | --- tbm_mark_page_lossy bringetbitmap FunctionCall2Coll index_getbitmap MultiExecBitmapIndexScan BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.03% 12 mmfsd [mmfs26] [k] 0xaf160 | --- 0xffffffffa0605afe 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0xffffc900341c3998 | --- 0xffffffffa05bf0f5 0xffffffffa05c0478 0xffffffffa0605afe 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0xffffc900341c3998 | --- 0xffffffffa053ac7c 0xffffffffa05c0bae 0xffffffffa0605bc1 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 | --- 0xffffffffa05c047a 0xffffffffa0605afe 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0xffffc900341c3998 | --- 0xffffffffa0605b00 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0xffffc900341c3998 | --- 0xffffffffa05c047e 0xffffffffa0605afe 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0xffffc900341c3998 | --- 0xffffffffa051f549 0xffffffffa053ad3b 0xffffffffa05c0487 0xffffffffa0605afe 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0xffffc900341c3998 | --- 0xffffffffa0605a78 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0x17200000 | --- 0xffffffffa0605a42 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 (nil) | --- 0xffffffffa05bf160 0xffffffffa05c0478 0xffffffffa0605afe 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0xffffc900341c3998 0.02% 12 mmfsd [kernel.kallsyms] [k] find_busiest_group | --- find_busiest_group load_balance idle_balance thread_return | |--51.91%-- 0xffffffffa04a8b7d | 0xffffffffa05bf0f1 | 0xffffffffa05c0478 | 0xffffffffa0605afe | 0xffffffffa04c3c65 | do_vfs_ioctl | sys_ioctl | system_call_fastpath | 0x7ffb7c11f3d7 | 0x7ffb7c11f3d7 | | | |--95.95%-- 0xffffc900341c3998 | | | --4.05%-- 0x7ffb741661c0 | --48.09%-- schedule_timeout __down down 0xffffffffa04a89cf | |--56.89%-- 0xffffffffa05c06e1 | 0xffffffffa05c0bbf | 0xffffffffa0605bc1 | 0xffffffffa04c3c65 | do_vfs_ioctl | sys_ioctl | system_call_fastpath | 0x7ffb7c11f3d7 | 0x7ffb7c11f3d7 | |--31.15%-- 0xffffffffa05c03ea | 0xffffffffa0605afe | 0xffffffffa04c3c65 | do_vfs_ioctl | sys_ioctl | system_call_fastpath | 0x7ffb7c11f3d7 | 0x7ffb7c11f3d7 | 0xffffc900341c3998 | --11.97%-- 0xffffffffa04a8ba5 | |--51.68%-- 0xffffffffa05bf0f1 | 0xffffffffa05c0478 | 0xffffffffa0605afe | 0xffffffffa04c3c65 | do_vfs_ioctl | sys_ioctl | system_call_fastpath | 0x7ffb7c11f3d7 | 0x7ffb7c11f3d7 | 0xffffc900341c3998 | --48.32%-- 0xffffffffa05c07e5 0xffffffffa05c0bbf 0xffffffffa0605bc1 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0.02% 3 mmfsd [kernel.kallsyms] [k] fput | --- fput sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 | |--98.12%-- 0xffffc900341c3998 | --1.88%-- 0x7ffb6432bda0 0.02% 2 mmfsd [kernel.kallsyms] [k] __switch_to | --- __switch_to thread_return 0xffff881fc2828000 0x7ffb7c11f3d7 | |--95.22%-- 0xffffc900341c3998 | --4.78%-- 0x7ffb6801d160 0.02% 1 postgres postgres [.] pg_strtok | --- pg_strtok _readVar parseNodeString nodeRead nodeRead _readRangeTblEntry parseNodeString nodeRead nodeRead parseNodeString nodeRead nodeRead stringToNode RelationBuildRuleLock RelationBuildDesc RelationIdGetRelation relation_open heap_openrv_extended parserOpenTable addRangeTableEntry transformFromClauseItem transformFromClause transformStmt parse_analyze pg_analyze_and_rewrite BeginCopy DoCopy standard_ProcessUtility PortalRunUtility PortalRunMulti PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.02% 10 fail2ban-server [unknown] [.] 0x7f4657d6a4d0 | --- 0x7f4657d83b83 0x8c20f0 0x7f465801d200 | --- 0x7f4657cde080 0x5f6378655f660065 | --- 0x7f4657d80ce7 | --- 0x7f4657da1219 (nil) | --- 0x7f4657d5f58e | --- 0x7f4657d80da8 | --- 0x7f4657d90f3e 0x746174736c3a74 | --- 0x7f4657d4887c 0x7f4657fff300 | --- 0x7f4657d6a4d0 0x602010 0x602010 0x602010 0x602010 0x602010 0x602010 0x602010 0.02% 1 psql ld-2.11.3.so [.] _dl_lookup_symbol_x | --- _dl_lookup_symbol_x _dl_relocate_object dl_main _dl_sysdep_start 0x40 0.01% 1 watchdog/9 [kernel.kallsyms] [k] find_busiest_group | --- find_busiest_group load_balance idle_balance thread_return watchdog kthread kernel_thread_helper 0.01% 4 swapper [kernel.kallsyms] [k] cpuidle_idle_call | --- cpuidle_idle_call cpu_idle 0.01% 2 swapper [kernel.kallsyms] [k] thread_return | --- thread_return cpu_idle 0.01% 8 mmfsd [kernel.kallsyms] [k] _raw_spin_lock_irqsave | --- _raw_spin_lock_irqsave | |--40.25%-- try_to_wake_up | __wake_up_common | __wake_up | 0xffffffffa04a7ff0 | 0xffffffffa05c042a | 0xffffffffa0605afe | 0xffffffffa04c3c65 | do_vfs_ioctl | sys_ioctl | system_call_fastpath | 0x7ffb7c11f3d7 | 0x7ffb7c11f3d7 | 0xffffc900341c3998 | |--20.81%-- __wake_up | | | |--89.29%-- 0xffffffffa04be300 | | 0xffffffffa05c064a | | 0xffffffffa0605a42 | | 0xffffffffa04c3c65 | | do_vfs_ioctl | | sys_ioctl | | system_call_fastpath | | 0x7ffb7c11f3d7 | | 0x7ffb7c11f3d7 | | 0x1bfffffffff | | | --10.71%-- 0xffffffffa04a7ff0 | 0xffffffffa05c05fb | 0xffffffffa0605a42 | 0xffffffffa04c3c65 | do_vfs_ioctl | sys_ioctl | system_call_fastpath | 0x7ffb7c11f3d7 | 0x7ffb7c11f3d7 | 0x1bfffffffff | |--19.88%-- down | 0xffffffffa04a89cf | | | |--71.52%-- 0xffffffffa051f54e | | 0xffffffffa053ad3b | | 0xffffffffa05c0487 | | 0xffffffffa0605afe | | 0xffffffffa04c3c65 | | do_vfs_ioctl | | sys_ioctl | | system_call_fastpath | | 0x7ffb7c11f3d7 | | 0x7ffb7c11f3d7 | | 0xffffc900341c3998 | | | --28.48%-- 0xffffffffa05c05bd | 0xffffffffa0605a42 | 0xffffffffa04c3c65 | do_vfs_ioctl | sys_ioctl | system_call_fastpath | 0x7ffb7c11f3d7 | 0x7ffb7c11f3d7 | 0x1bfffffffff | --19.06%-- 0xffffffffa04a8b85 0xffffffffa05bf0f1 0xffffffffa05c0478 0xffffffffa0605afe 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0xffffc900341c3998 0.01% 1 swapper [kernel.kallsyms] [k] lock_hrtimer_base | --- lock_hrtimer_base hrtimer_try_to_cancel hrtimer_cancel tick_nohz_restart tick_nohz_restart_sched_tick cpu_idle 0.01% 1 swapper [kernel.kallsyms] [k] pick_next_task_fair | --- pick_next_task_fair __schedule cpu_idle 0.01% 3 mmfsd [kernel.kallsyms] [k] __task_pid_nr_ns | --- __task_pid_nr_ns 0xffffffffa04c2645 0xffffffffa0605ae4 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 | |--64.44%-- 0x15aa1c0 | --35.56%-- 0xffffc900341c3998 0.01% 4 swapper [kernel.kallsyms] [k] __schedule | --- __schedule cpu_idle | --100.00%-- start_kernel x86_64_start_kernel 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.01% 4 swapper [kernel.kallsyms] [k] rcu_needs_cpu | --- rcu_needs_cpu tick_nohz_stop_sched_tick cpu_idle 0.01% 2 mmfsd [kernel.kallsyms] [k] select_task_rq_fair | --- select_task_rq_fair try_to_wake_up __wake_up_common __wake_up | |--56.30%-- 0xffffffffa04be300 | 0xffffffffa05c064a | 0xffffffffa0605a42 | 0xffffffffa04c3c65 | do_vfs_ioctl | sys_ioctl | system_call_fastpath | 0x7ffb7c11f3d7 | 0x7ffb7c11f3d7 | 0x1bfffffffff | --43.70%-- 0xffffffffa04a7ff0 0xffffffffa05c05fb 0xffffffffa0605a42 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0x1bfffffffff 0.01% 2 swapper [kernel.kallsyms] [k] place_entity | --- place_entity enqueue_entity enqueue_task_fair ttwu_activate ttwu_do_activate | |--67.35%-- try_to_wake_up | hrtimer_wakeup | __run_hrtimer | hrtimer_interrupt | smp_apic_timer_interrupt | apic_timer_interrupt | intel_idle | cpuidle_idle_call | cpu_idle | --32.65%-- sched_ttwu_do_pending scheduler_ipi reschedule_interrupt intel_idle cpuidle_idle_call cpu_idle start_kernel x86_64_start_kernel 0.01% 2 swapper [kernel.kallsyms] [k] apic_timer_interrupt | --- apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.01% 4 mmfsd [mmfslinux] [k] 0x5c0 | --- 0xffffffffa04a8820 0xffffffffa05c0487 0xffffffffa0605afe 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0x7ffb6c4f61e0 | --- 0xffffffffa04be2d3 0xffffffffa05c064a 0xffffffffa0605a42 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0x1bfffffffff | --- 0xffffffffa04a05c0 0xffffffffa05bf45a 0xffffffffa0605aa3 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0x6800000 | --- 0xffffffffa04c3bf8 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0xffffc900341c3998 0.01% 1 swapper [kernel.kallsyms] [k] idle_cpu | --- idle_cpu irq_enter smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.01% 1 swapper [kernel.kallsyms] [k] ktime_get_real | --- ktime_get_real intel_idle cpuidle_idle_call cpu_idle 0.01% 1 postgres [kernel.kallsyms] [k] nf_iterate | --- nf_iterate nf_hook_slow ip_output ip_send_skb udp_send_skb udp_sendmsg sock_sendmsg sys_sendto system_call_fastpath 0x7fb873dc4075 __GI___send 0.01% 1 swapper [kernel.kallsyms] [k] native_apic_msr_write | --- native_apic_msr_write lapic_next_event tick_dev_program_event __remove_hrtimer hrtimer_try_to_cancel hrtimer_cancel tick_nohz_restart tick_nohz_restart_sched_tick cpu_idle 0.01% 1 swapper [kernel.kallsyms] [k] tcp_clean_rtx_queue | --- tcp_clean_rtx_queue tcp_ack tcp_rcv_established tcp_v4_do_rcv tcp_v4_rcv ip_local_deliver_finish __netif_receive_skb netif_receive_skb napi_skb_finish ixgbe_clean_rx_irq ixgbe_poll net_rx_action __do_softirq call_softirq do_softirq irq_exit do_IRQ ret_from_intr intel_idle cpuidle_idle_call cpu_idle 0.01% 1 swapper [kernel.kallsyms] [k] enqueue_hrtimer | --- enqueue_hrtimer __run_hrtimer hrtimer_interrupt smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.01% 2 postgres postgres [.] BgBufferSync | --- BgBufferSync BackgroundWriterMain AuxiliaryProcessMain StartChildProcess reaper __restore_rt PostmasterMain main __libc_start_main 0.01% 2 swapper [kernel.kallsyms] [k] ktime_get | --- ktime_get | |--97.30%-- tick_nohz_stop_sched_tick | cpu_idle | --2.70%-- tick_check_idle irq_enter smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.01% 1 swapper [kernel.kallsyms] [k] 0xffffffff81070877 | --- run_timer_softirq __do_softirq call_softirq do_softirq irq_exit smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.01% 1 postgres postgres [.] ScanKeyEntryInitializeWithInfo | --- ScanKeyEntryInitializeWithInfo btgettuple FunctionCall2Coll index_getnext_tid index_getnext systable_getnext SearchCatCache get_opfamily_member btcostestimate OidFunctionCall7Coll cost_index create_index_path build_index_paths get_index_paths create_index_paths set_rel_pathlist make_one_rel query_planner grouping_planner subquery_planner standard_planner pg_plan_query ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.01% 2 swapper [kernel.kallsyms] [k] clockevents_program_event | --- clockevents_program_event tick_dev_program_event | |--72.48%-- __hrtimer_start_range_ns | tick_nohz_restart | tick_nohz_restart_sched_tick | cpu_idle | --27.52%-- __remove_hrtimer hrtimer_try_to_cancel hrtimer_cancel tick_nohz_restart tick_nohz_restart_sched_tick cpu_idle 0.01% 1 postgres libc-2.11.3.so [.] fputc | --- fputc PgstatCollectorMain pgstat_start reaper __restore_rt PostmasterMain main __libc_start_main 0.01% 1 swapper [kernel.kallsyms] [k] security_sock_rcv_skb | --- security_sock_rcv_skb sk_filter tcp_v4_rcv ip_local_deliver_finish __netif_receive_skb netif_receive_skb napi_skb_finish ixgbe_clean_rx_irq ixgbe_poll net_rx_action __do_softirq call_softirq do_softirq irq_exit do_IRQ ret_from_intr intel_idle cpuidle_idle_call cpu_idle 0.01% 1 kworker/13:1 [kernel.kallsyms] [k] cache_reap | --- cache_reap process_one_work worker_thread kthread kernel_thread_helper 0.01% 1 perf [kernel.kallsyms] [k] generic_exec_single | --- generic_exec_single smp_call_function_single perf_event_disable perf_event_for_each_child perf_ioctl do_vfs_ioctl sys_ioctl system_call_fastpath 0x7f59d68af3d7 __ioctl 0.01% 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 0xffffc900341c3998 0.01% 1 swapper [kernel.kallsyms] [k] __rb_erase_color | --- __rb_erase_color set_next_entity pick_next_task_fair __schedule cpu_idle 0.01% 1 mmfsd [kernel.kallsyms] [k] net_rx_action | --- net_rx_action __do_softirq call_softirq do_softirq irq_exit do_IRQ ret_from_intr 0x9209b5 0x9209b5 0x250158f730 0x15aa1e8 0xb10ff0d089ff4a8d 0.01% 1 postgres libc-2.11.3.so [.] __strncmp_sse2 | --- __strncmp_sse2 putenv pg_perm_setlocale InitPostgres PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.01% 1 mmfsd [kernel.kallsyms] [k] native_sched_clock | --- native_sched_clock sched_clock idle_balance thread_return 0xffffffffa04a8b7d 0xffffffffa05bf0f1 0xffffffffa05c0478 0xffffffffa0605afe 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0xffffc900341c3998 0.01% 1 psql [kernel.kallsyms] [k] copy_page_c | --- copy_page_c do_wp_page handle_pte_fault do_page_fault page_fault 0x7f21fad90866 _dl_relocate_object dl_main _dl_sysdep_start 0x40 0.01% 4 swapper [kernel.kallsyms] [k] run_timer_softirq | --- run_timer_softirq __do_softirq call_softirq do_softirq irq_exit smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.01% 1 mmfsd [kernel.kallsyms] [k] sock_update_classid | --- sock_update_classid sock_recvmsg sys_recvfrom system_call_fastpath 0x7ffb7cb55bb1 0x7ffb7cb55bb1 0x552eee78 0.01% 1 postgres [kernel.kallsyms] [k] __memset | --- __memset kmem_cache_alloc_trace apparmor_file_alloc_security get_empty_filp path_openat do_filp_open do_sys_open system_call_fastpath 0x7fb873db51e0 __GI___open64 0x6e7265746e695f67 0.01% 1 mmfsd [kernel.kallsyms] [k] native_read_tsc | --- native_read_tsc native_sched_clock sched_clock update_rq_clock dequeue_task __schedule 0xffffffffa04a8b7d 0xffffffffa05bf0f1 0xffffffffa05c0478 0xffffffffa0605afe 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0xffffc900341c3998 0.01% 1 mmfsd [kernel.kallsyms] [k] aa_revalidate_sk | --- aa_revalidate_sk sock_sendmsg ___sys_sendmsg __sys_sendmsg system_call_fastpath 0x7ffb7cb55dfd 0x7ffb7cb55dfd 0.01% 1 mmfsd [nf_conntrack] [k] ____nf_conntrack_find | --- ____nf_conntrack_find __nf_conntrack_find_get 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.01% 1 swapper [kernel.kallsyms] [k] native_load_tls | --- native_load_tls __switch_to thread_return 0xffff882084dc0000 0.01% 1 postgres postgres [.] heapgetpage | --- heapgetpage heapgettup_pagemode heap_getnext pgstat_collect_oids pgstat_vacuum_stat do_autovacuum AutoVacWorkerMain StartAutoVacWorker sigusr1_handler __restore_rt PostmasterMain main __libc_start_main 0.01% 1 sadc [kernel.kallsyms] [k] disk_part_iter_next | --- disk_part_iter_next diskstats_show seq_read proc_reg_read vfs_read sys_read system_call_fastpath 0x7fc5013625d0 __GI___read 0.01% 3 swapper [kernel.kallsyms] [k] find_next_bit | --- find_next_bit rcu_needs_cpu tick_nohz_stop_sched_tick cpu_idle | --100.00%-- start_kernel x86_64_start_kernel 0.01% 2 mmfsd [kernel.kallsyms] [k] security_file_ioctl | --- security_file_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 | |--52.81%-- 0xffffc900341c3998 | --47.19%-- 0x1fc00000 0.01% 1 mmfsd [kernel.kallsyms] [k] enqueue_sleeper | --- enqueue_sleeper enqueue_entity enqueue_task_fair ttwu_activate ttwu_do_activate try_to_wake_up __wake_up_common __wake_up 0xffffffffa04be300 0xffffffffa05c064a 0xffffffffa0605a42 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0x1bfffffffff 0.01% 1 mmfsd [kernel.kallsyms] [k] __init_waitqueue_head | --- __init_waitqueue_head 0xffffffffa04a8a78 0xffffffffa05bf0f1 0xffffffffa05c0478 0xffffffffa0605afe 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0xffffc900341c3998 0.00% 1 psql [kernel.kallsyms] [k] clear_page_c | --- clear_page_c prep_new_page get_page_from_freelist __alloc_pages_nodemask alloc_pages_current pte_alloc_one __pte_alloc handle_mm_fault do_page_fault page_fault 0x7f6bd69ca147 _dl_start _dl_start_user 0.00% 2 swapper [kernel.kallsyms] [k] native_sched_clock | --- native_sched_clock sched_clock | |--92.46%-- update_rq_clock | enqueue_task | ttwu_activate | ttwu_do_activate | try_to_wake_up | hrtimer_wakeup | __run_hrtimer | hrtimer_interrupt | smp_apic_timer_interrupt | apic_timer_interrupt | intel_idle | cpuidle_idle_call | cpu_idle | --7.54%-- idle_balance thread_return cpu_idle 0.00% 2 mmfsd [kernel.kallsyms] [k] wake_affine | --- wake_affine select_task_rq_fair try_to_wake_up __wake_up_common __wake_up 0xffffffffa04be300 0xffffffffa05c064a 0xffffffffa0605a42 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0x1bfffffffff 0.00% 1 mmfsd [kernel.kallsyms] [k] sys_times | --- sys_times system_call_fastpath 0x7ffb7c0f3e5a 0x7ffb7c0f3e5a 0x1bfffffffff 0.00% 1 mmfsd [kernel.kallsyms] [k] update_curr | --- update_curr dequeue_entity dequeue_task_fair __schedule 0xffffffffa04a8b7d 0xffffffffa05bf0f1 0xffffffffa05c0478 0xffffffffa0605afe 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0xffffc900341c3998 0.00% 4 mmfsd [kernel.kallsyms] [k] cpumask_next_and | --- cpumask_next_and find_busiest_group load_balance idle_balance thread_return 0xffffffffa04a8b7d 0xffffffffa05bf0f1 0xffffffffa05c0478 0xffffffffa0605afe 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0xffffc900341c3998 0.00% 1 swapper [kernel.kallsyms] [k] update_wall_time | --- update_wall_time do_timer tick_do_update_jiffies64 tick_check_idle irq_enter do_IRQ ret_from_intr intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] nf_hook_slow | --- nf_hook_slow ip_rcv __netif_receive_skb netif_receive_skb napi_skb_finish ixgbe_clean_rx_irq ixgbe_poll net_rx_action __do_softirq call_softirq do_softirq irq_exit do_IRQ ret_from_intr intel_idle cpuidle_idle_call cpu_idle 0.00% 1 haveged [kernel.kallsyms] [k] thread_return | --- thread_return 0xffff883fbf60a000 0x7fbf388b4373 0.00% 1 swapper [kernel.kallsyms] [k] _raw_spin_lock | --- _raw_spin_lock sched_ttwu_do_pending scheduler_ipi reschedule_interrupt intel_idle cpuidle_idle_call cpu_idle start_kernel x86_64_start_kernel 0.00% 1 kworker/0:0 [kernel.kallsyms] [k] free_pcppages_bulk | --- free_pcppages_bulk drain_zone_pages refresh_cpu_vm_stats vmstat_update process_one_work worker_thread kthread kernel_thread_helper 0.00% 1 swapper [kernel.kallsyms] [k] native_set_ldt | --- native_set_ldt thread_return cpu_idle start_kernel x86_64_start_kernel 0.00% 1 postgres [kernel.kallsyms] [k] load_balance | --- 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.00% 1 postgres [kernel.kallsyms] [k] ktime_get_ts | --- ktime_get_ts poll_select_set_timeout sys_poll system_call_fastpath 0x7fb873db9b8f __libc_poll 0.00% 1 psql [kernel.kallsyms] [k] page_fault | --- page_fault | |--67.97%-- 0x7fbeb9d21bb8 | _dl_lookup_symbol_x | dl_main | _dl_sysdep_start | 0x40 | |--24.81%-- 0x7ffa11f7f660 | strcmp | --7.22%-- 0x7ffa118537fa __libc_fork make_child 0x6aaa30 0x6aaa70 0x6aab00 0.00% 2 swapper [kernel.kallsyms] [k] rb_insert_color | --- rb_insert_color timerqueue_add enqueue_hrtimer __hrtimer_start_range_ns tick_nohz_restart tick_nohz_restart_sched_tick cpu_idle | --100.00%-- start_kernel x86_64_start_kernel 0.00% 1 mmfsd [kernel.kallsyms] [k] update_cfs_load | --- update_cfs_load dequeue_entity dequeue_task_fair __schedule 0xffffffffa04a8b7d 0xffffffffa05bf0f1 0xffffffffa05c0478 0xffffffffa0605afe 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0xffffc900341c3998 0.00% 5 kworker/2:1 [igb] [k] igb_update_stats | --- igb_update_stats igb_watchdog_task process_one_work worker_thread kthread kernel_thread_helper 0.00% 2 kworker/3:1 [kernel.kallsyms] [k] free_block | --- free_block drain_array cache_reap process_one_work worker_thread kthread kernel_thread_helper 0.00% 1 swapper [kernel.kallsyms] [k] __rcu_pending | --- __rcu_pending rcu_check_callbacks update_process_times tick_sched_timer __run_hrtimer hrtimer_interrupt smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] __local_bh_enable | --- __local_bh_enable irq_enter smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 mmfsd [kernel.kallsyms] [k] ___sys_sendmsg | --- ___sys_sendmsg __sys_sendmsg system_call_fastpath 0x7ffb7cb55dfd 0x7ffb7cb55dfd 0.00% 2 swapper [kernel.kallsyms] [k] find_busiest_group | --- find_busiest_group load_balance rebalance_domains run_rebalance_domains __do_softirq call_softirq do_softirq irq_exit smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 2 mmfsd [kernel.kallsyms] [k] try_to_wake_up | --- try_to_wake_up | |--74.83%-- up | 0xffffffffa05c0613 | 0xffffffffa0605a42 | 0xffffffffa04c3c65 | do_vfs_ioctl | sys_ioctl | system_call_fastpath | 0x7ffb7c11f3d7 | 0x7ffb7c11f3d7 | 0x1bfffffffff | --25.17%-- __wake_up_common __wake_up 0xffffffffa04a7ff0 0xffffffffa05c05fb 0xffffffffa0605a42 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0x1bfffffffff 0.00% 1 mmfsd [kernel.kallsyms] [k] __x2apic_send_IPI_mask | --- __x2apic_send_IPI_mask try_to_wake_up __wake_up_common __wake_up 0xffffffffa04a7ff0 0xffffffffa05c042a 0xffffffffa0605afe 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0xffffc900341c3998 0.00% 2 mmfsd [kernel.kallsyms] [k] do_vfs_ioctl | --- do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0xffffc900341c3998 0.00% 1 swapper [nf_conntrack] [k] __nf_conntrack_find_get | --- __nf_conntrack_find_get nf_conntrack_in nf_iterate nf_hook_slow ip_rcv __netif_receive_skb netif_receive_skb napi_skb_finish ixgbe_clean_rx_irq ixgbe_poll net_rx_action __do_softirq call_softirq do_softirq irq_exit do_IRQ ret_from_intr intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] set_next_entity | --- set_next_entity pick_next_task_fair __schedule cpu_idle 0.00% 1 swapper [3w_sas] [k] twl_interrupt | --- twl_interrupt handle_irq_event_percpu handle_irq_event handle_fasteoi_irq handle_irq do_IRQ ret_from_intr intel_idle cpuidle_idle_call cpu_idle 0.00% 1 mmfsd [kernel.kallsyms] [k] ip_finish_output | --- ip_finish_output 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.00% 1 mmfsd [kernel.kallsyms] [k] _raw_spin_lock | --- _raw_spin_lock dev_queue_xmit ip_finish_output 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.00% 1 postgres [kernel.kallsyms] [k] udp_send_skb | --- udp_send_skb udp_sendmsg sock_sendmsg sys_sendto system_call_fastpath 0x7fb873dc4075 __GI___send 0.00% 2 swapper [kernel.kallsyms] [k] scale_rt_power | --- scale_rt_power update_group_power find_busiest_group load_balance rebalance_domains run_rebalance_domains __do_softirq call_softirq do_softirq irq_exit smp_apic_timer_interrupt apic_timer_interrupt | |--90.13%-- finish_task_switch | thread_return | cpu_idle | --9.87%-- intel_idle cpuidle_idle_call cpu_idle 0.00% 1 psql [kernel.kallsyms] [k] __do_fault | --- __do_fault handle_pte_fault do_page_fault page_fault 0x7ffa11877750 _xstat 0x6f6974617475706d 0.00% 1 swapper [kernel.kallsyms] [k] pskb_may_pull | --- pskb_may_pull tcp_v4_rcv ip_local_deliver_finish __netif_receive_skb netif_receive_skb napi_skb_finish ixgbe_clean_rx_irq ixgbe_poll net_rx_action __do_softirq call_softirq do_softirq irq_exit do_IRQ ret_from_intr intel_idle cpuidle_idle_call cpu_idle 0.00% 2 kworker/2:1 [kernel.kallsyms] [k] native_read_tsc | --- native_read_tsc delay_tsc igb_read_phy_reg_mdic igb_read_phy_reg_82580 igb_update_stats igb_watchdog_task process_one_work worker_thread kthread kernel_thread_helper 0.00% 1 mmfsd [kernel.kallsyms] [k] getnstimeofday | --- getnstimeofday 0xffffffffa04a8d10 0xffffffffa05c0b78 0xffffffffa0605bc1 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0.00% 1 mmfsd [kernel.kallsyms] [k] security_socket_sendmsg | --- security_socket_sendmsg sock_sendmsg ___sys_sendmsg __sys_sendmsg system_call_fastpath 0x7ffb7cb55dfd 0x7ffb7cb55dfd 0.00% 1 swapper [kernel.kallsyms] [k] handle_irq_event_percpu | --- handle_irq_event_percpu handle_irq_event handle_edge_irq handle_irq do_IRQ ret_from_intr intel_idle cpuidle_idle_call cpu_idle 0.00% 1 mmfsd [kernel.kallsyms] [k] update_shares | --- update_shares idle_balance thread_return 0xffffffffa04a8b7d 0xffffffffa05bf0f1 0xffffffffa05c0478 0xffffffffa0605afe 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0xffffc900341c3998 0.00% 1 postgres postgres [.] oid_compare | --- oid_compare pg_qsort pg_qsort InitCatalogCache InitPostgres PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.00% 1 postgres libc-2.11.3.so [.] __fscanf | --- __fscanf InitPostgres PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.00% 1 postgres [kernel.kallsyms] [k] idle_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.00% 1 mmfsd [kernel.kallsyms] [k] up | --- up 0xffffffffa05bf4b1 0xffffffffa0605aa3 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0x1aa00000 0.00% 1 postgres [kernel.kallsyms] [k] find_vma | --- find_vma do_page_fault page_fault 0x7fb873d5e010 ptmalloc_unlock_all2 fork_process ServerLoop PostmasterMain main __libc_start_main 0.00% 2 swapper [kernel.kallsyms] [k] native_write_msr_safe | --- native_write_msr_safe | |--65.85%-- native_apic_msr_write | smp_apic_timer_interrupt | apic_timer_interrupt | intel_idle | cpuidle_idle_call | cpu_idle | --34.15%-- __switch_to thread_return 0xffff883f629d4000 0.00% 3 swapper [kernel.kallsyms] [k] menu_select | --- menu_select cpuidle_idle_call cpu_idle 0.00% 2 swapper [kernel.kallsyms] [k] hrtimer_force_reprogram | --- hrtimer_force_reprogram __remove_hrtimer | |--84.87%-- __hrtimer_start_range_ns | tick_nohz_stop_sched_tick | cpu_idle | start_kernel | x86_64_start_kernel | --15.13%-- hrtimer_try_to_cancel hrtimer_cancel tick_nohz_restart tick_nohz_restart_sched_tick cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] timerqueue_add | --- timerqueue_add enqueue_hrtimer __hrtimer_start_range_ns tick_nohz_restart tick_nohz_restart_sched_tick cpu_idle 0.00% 2 swapper [kernel.kallsyms] [k] rcu_enter_nohz | --- rcu_enter_nohz tick_nohz_stop_sched_tick cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] do_softirq | --- do_softirq irq_exit smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle start_kernel x86_64_start_kernel 0.00% 1 swapper [kernel.kallsyms] [k] reschedule_interrupt | --- reschedule_interrupt tick_nohz_stop_sched_tick cpu_idle start_kernel x86_64_start_kernel 0.00% 1 mmfsd [kernel.kallsyms] [k] find_next_bit | --- find_next_bit cpumask_next_and find_busiest_group load_balance idle_balance thread_return 0xffffffffa04a8b7d 0xffffffffa05bf0f1 0xffffffffa05c0478 0xffffffffa0605afe 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0xffffc900341c3998 0.00% 1 swapper [kernel.kallsyms] [k] local_bh_disable | --- local_bh_disable irq_enter scheduler_ipi reschedule_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 kworker/2:1 [igb] [k] igb_get_hw_semaphore | --- igb_get_hw_semaphore igb_release_swfw_sync_82575 igb_read_phy_reg_82580 igb_update_stats igb_watchdog_task process_one_work worker_thread kthread kernel_thread_helper 0.00% 1 psql libc-2.11.3.so [.] __strcmp_sse42 | --- __strcmp_sse42 PQconnectStartParams PQconnectdbParams main __libc_start_main 0.00% 1 psql [kernel.kallsyms] [k] strncpy_from_user | --- strncpy_from_user getname_flags do_sys_open system_call_fastpath 0x7fbeb9d2df57 __open 0x66c0 0.00% 1 swapper [kernel.kallsyms] [k] pm_qos_request | --- pm_qos_request menu_select cpuidle_idle_call cpu_idle 0.00% 1 postgres libc-2.11.3.so [.] __GI___errno_location | --- __GI___errno_location PostmasterMain main __libc_start_main 0.00% 1 postgres [kernel.kallsyms] [k] __percpu_counter_add | --- __percpu_counter_add __vm_enough_memory mmap_region sys_mmap_pgoff system_call_fastpath 0x7fb873dbfc5a __GI_mmap64 0xbe794000000000 0.00% 1 kworker/5:1 [kernel.kallsyms] [k] dequeue_task_fair | --- dequeue_task_fair __schedule worker_thread kthread kernel_thread_helper 0.00% 2 swapper [kernel.kallsyms] [k] tick_nohz_stop_sched_tick | --- tick_nohz_stop_sched_tick cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] select_nohz_load_balancer | --- select_nohz_load_balancer tick_nohz_restart_sched_tick cpu_idle 0.00% 1 postgres [kernel.kallsyms] [k] kmem_cache_free | --- kmem_cache_free udp_recvmsg inet_recvmsg sock_recvmsg sys_recvfrom system_call_fastpath 0x7fb873dc3eb5 __libc_recv 0.00% 1 swapper [kernel.kallsyms] [k] nr_iowait_cpu | --- nr_iowait_cpu update_ts_time_stats tick_nohz_stop_idle tick_check_idle irq_enter scheduler_ipi reschedule_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 sync_supers [mmfs26] [k] 0x5713f | --- 0xffffffffa056713f 0xffffffffa04ad2d0 sync_supers bdi_sync_supers kthread kernel_thread_helper 0.00% 1 swapper [kernel.kallsyms] [k] enqueue_entity | --- enqueue_entity enqueue_task_fair ttwu_activate ttwu_do_activate sched_ttwu_do_pending scheduler_ipi reschedule_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 2 swapper [kernel.kallsyms] [k] rb_next | --- rb_next | |--53.01%-- timerqueue_del | __remove_hrtimer | __run_hrtimer | hrtimer_interrupt | smp_apic_timer_interrupt | apic_timer_interrupt | intel_idle | cpuidle_idle_call | cpu_idle | --46.99%-- set_next_entity pick_next_task_fair __schedule cpu_idle 0.00% 2 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 intel_idle cpuidle_idle_call cpu_idle 0.00% 1 watchdog/1 [kernel.kallsyms] [k] cpumask_next_and | --- cpumask_next_and find_busiest_group load_balance idle_balance thread_return watchdog kthread kernel_thread_helper 0.00% 2 swapper [kernel.kallsyms] [k] leave_mm | --- leave_mm intel_idle cpuidle_idle_call cpu_idle 0.00% 2 swapper [kernel.kallsyms] [k] __phys_addr | --- __phys_addr leave_mm intel_idle cpuidle_idle_call cpu_idle 0.00% 2 swapper [kernel.kallsyms] [k] rb_erase | --- rb_erase timerqueue_del __remove_hrtimer | |--57.72%-- __run_hrtimer | hrtimer_interrupt | smp_apic_timer_interrupt | apic_timer_interrupt | intel_idle | cpuidle_idle_call | cpu_idle | --42.28%-- hrtimer_try_to_cancel hrtimer_cancel tick_nohz_restart tick_nohz_restart_sched_tick cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] kthread_data | --- kthread_data wq_worker_waking_up ttwu_do_activate try_to_wake_up __queue_work call_timer_fn run_timer_softirq __do_softirq call_softirq do_softirq irq_exit smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 kworker/8:1 [kernel.kallsyms] [k] get_work_gcwq | --- get_work_gcwq queue_delayed_work_on do_dbs_timer process_one_work worker_thread kthread kernel_thread_helper 0.00% 1 swapper [kernel.kallsyms] [k] __run_hrtimer | --- __run_hrtimer hrtimer_interrupt smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] read_tsc | --- read_tsc getnstimeofday ktime_get_real intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] scheduler_tick | --- scheduler_tick update_process_times tick_sched_timer __run_hrtimer hrtimer_interrupt smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] smp_apic_timer_interrupt | --- smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] enqueue_task_fair | --- enqueue_task_fair ttwu_activate ttwu_do_activate sched_ttwu_do_pending scheduler_ipi reschedule_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 psql bash [.] find_variable_internal | --- find_variable_internal 0x4c5f454c504d4153 0.00% 1 swapper [kernel.kallsyms] [k] rcu_check_callbacks | --- rcu_check_callbacks update_process_times tick_sched_timer __run_hrtimer hrtimer_interrupt smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] task_of | --- task_of enqueue_sleeper enqueue_entity enqueue_task_fair ttwu_activate ttwu_do_activate sched_ttwu_do_pending scheduler_ipi reschedule_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] lapic_next_event | --- lapic_next_event tick_dev_program_event hrtimer_interrupt smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 kworker/13:1 [kernel.kallsyms] [k] dbs_check_cpu | --- dbs_check_cpu do_dbs_timer process_one_work worker_thread kthread kernel_thread_helper 0.00% 1 swapper [kernel.kallsyms] [k] task_tick_idle | --- task_tick_idle scheduler_tick update_process_times tick_sched_timer __run_hrtimer hrtimer_interrupt smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] __switch_to | --- __switch_to thread_return 0xffff8801aad50000 0.00% 1 swapper [kernel.kallsyms] [k] tick_program_event | --- tick_program_event __remove_hrtimer __hrtimer_start_range_ns tick_nohz_stop_sched_tick cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] notifier_call_chain | --- notifier_call_chain __atomic_notifier_call_chain cpu_idle 0.00% 1 mmfsd [kernel.kallsyms] [k] task_waking_fair | --- task_waking_fair try_to_wake_up __wake_up_common __wake_up 0xffffffffa04be300 0xffffffffa05c064a 0xffffffffa0605a42 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0x1bfffffffff 0.00% 1 swapper [kernel.kallsyms] [k] tick_dev_program_event | --- tick_dev_program_event __remove_hrtimer __hrtimer_start_range_ns tick_nohz_stop_sched_tick cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] tcp_rcv_established | --- tcp_rcv_established tcp_v4_do_rcv tcp_v4_rcv ip_local_deliver_finish __netif_receive_skb netif_receive_skb napi_skb_finish ixgbe_clean_rx_irq ixgbe_poll net_rx_action __do_softirq call_softirq do_softirq irq_exit do_IRQ ret_from_intr intel_idle cpuidle_idle_call cpu_idle 0.00% 1 mmfsd [kernel.kallsyms] [k] double_rq_lock | --- double_rq_lock load_balance idle_balance thread_return schedule_hrtimeout_range_clock ep_poll sys_epoll_wait system_call_fastpath 0x7ffb7c127723 0x7ffb7c127723 0x800000000 0.00% 1 swapper [kernel.kallsyms] [k] _raw_spin_lock_irqsave | --- _raw_spin_lock_irqsave lock_hrtimer_base hrtimer_try_to_cancel hrtimer_cancel tick_nohz_restart tick_nohz_restart_sched_tick cpu_idle 0.00% 1 mmfsd [kernel.kallsyms] [k] dequeue_task_fair | --- dequeue_task_fair __schedule 0xffffffffa04a8b7d 0xffffffffa05bf0f1 0xffffffffa05c0478 0xffffffffa0605afe 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0xffffc900341c3998 0.00% 1 mmfsd [kernel.kallsyms] [k] system_call_fastpath | --- system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0xffffc900341c3998 0.00% 1 swapper [kernel.kallsyms] [k] hrtimer_interrupt | --- hrtimer_interrupt 0.00% 1 swapper [kernel.kallsyms] [k] clear_buddies | --- clear_buddies pick_next_task_fair __schedule cpu_idle 0.00% 1 kworker/3:1 [kernel.kallsyms] [k] __switch_to | --- __switch_to thread_return 0xffff881fc0f18000 0.00% 1 kworker/2:1 [kernel.kallsyms] [k] ktime_get | --- ktime_get get_cpu_idle_time_us dbs_check_cpu do_dbs_timer process_one_work worker_thread kthread kernel_thread_helper 0.00% 1 swapper [kernel.kallsyms] [k] ns_to_timespec | --- ns_to_timespec ns_to_timeval intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] put_cred_rcu | --- put_cred_rcu rcu_do_batch rcu_process_callbacks __do_softirq call_softirq do_softirq irq_exit smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] native_read_tsc | --- native_read_tsc read_tsc getnstimeofday ktime_get_real intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] update_cpu_load | --- update_cpu_load scheduler_tick update_process_times tick_sched_timer __run_hrtimer hrtimer_interrupt smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] try_to_wake_up | --- try_to_wake_up __queue_work call_timer_fn run_timer_softirq __do_softirq call_softirq do_softirq irq_exit smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] save_args | --- save_args intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] __remove_hrtimer | --- __remove_hrtimer __hrtimer_start_range_ns tick_nohz_stop_sched_tick cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] __hrtimer_start_range_ns | --- __hrtimer_start_range_ns tick_nohz_restart tick_nohz_restart_sched_tick cpu_idle 0.00% 1 postgres libc-2.11.3.so [.] __libc_recv | --- __libc_recv 0.00% 1 swapper [kernel.kallsyms] [k] ttwu_stat | --- ttwu_stat try_to_wake_up __queue_work call_timer_fn run_timer_softirq __do_softirq call_softirq do_softirq irq_exit smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] tick_check_oneshot_broadcast | --- tick_check_oneshot_broadcast tick_check_idle irq_enter smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle # # (For a higher level overview, try: perf report --sort comm,dso) #