# Events: 1K cycles # # Overhead Samples Command Shared Object Symbol # ........ .......... ............... ................. ............................... # 12.70% 185 postgres [kernel.kallsyms] [k] copy_user_generic_string | --- copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 6.85% 100 postgres postgres [.] CHashBucketScan | --- CHashBucketScan | |--55.00%-- CHashSearch | BufTableLookup | | | |--72.73%-- ReadBuffer_common | | ReadBufferExtended | | | | | |--55.00%-- _bt_relandgetbuf | | | _bt_search | | | _bt_first | | | btgettuple | | | FunctionCall2Coll | | | index_getnext_tid | | | index_getnext | | | IndexNext | | | ExecScan | | | ExecProcNode | | | ExecNestLoop | | | ExecProcNode | | | ExecAgg | | | ExecProcNode | | | ExecSort | | | ExecProcNode | | | standard_ExecutorRun | | | ExplainOnePlan | | | ExplainOneQuery | | | ExplainQuery | | | standard_ProcessUtility | | | PortalRunUtility | | | FillPortalStore | | | PortalRun | | | exec_simple_query | | | PostgresMain | | | ServerLoop | | | PostmasterMain | | | main | | | __libc_start_main | | | | | |--29.99%-- index_fetch_heap | | | index_getnext | | | IndexNext | | | ExecScan | | | ExecProcNode | | | ExecNestLoop | | | ExecProcNode | | | ExecAgg | | | ExecProcNode | | | ExecSort | | | ExecProcNode | | | standard_ExecutorRun | | | ExplainOnePlan | | | ExplainOneQuery | | | ExplainQuery | | | standard_ProcessUtility | | | PortalRunUtility | | | FillPortalStore | | | PortalRun | | | exec_simple_query | | | PostgresMain | | | ServerLoop | | | PostmasterMain | | | main | | | __libc_start_main | | | | | |--12.51%-- _bt_getbuf | | | _bt_getroot | | | _bt_search | | | _bt_first | | | btgettuple | | | FunctionCall2Coll | | | index_getnext_tid | | | index_getnext | | | IndexNext | | | ExecScan | | | ExecProcNode | | | ExecNestLoop | | | ExecProcNode | | | ExecAgg | | | ExecProcNode | | | ExecSort | | | ExecProcNode | | | standard_ExecutorRun | | | ExplainOnePlan | | | ExplainOneQuery | | | ExplainQuery | | | standard_ProcessUtility | | | PortalRunUtility | | | FillPortalStore | | | PortalRun | | | exec_simple_query | | | PostgresMain | | | ServerLoop | | | PostmasterMain | | | main | | | __libc_start_main | | | | | --2.50%-- BitmapHeapNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --27.27%-- PrefetchBuffer | BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --45.00%-- CHashDelete BufTableDelete ReadBuffer_common ReadBufferExtended | |--64.45%-- index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --35.55%-- _bt_relandgetbuf _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 6.11% 89 postgres postgres [.] HeapTupleSatisfiesMVCC | --- HeapTupleSatisfiesMVCC | |--97.75%-- BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --2.25%-- ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 5.62% 82 postgres [mmfs26] [k] 0xaa691 | --- 0xffffffffa05e1d4d __GI___read | --- 0xffffffffa05e1d6a __GI___read | --- 0xffffffffa0571542 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05ba684 0xffffffffa05341d7 0xffffffffa0551537 0xffffffffa0553de1 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0551e04 0xffffffffa04c006c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05c31b4 0xffffffffa0553f55 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0534192 0xffffffffa0551537 0xffffffffa0553de1 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa056f37e 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0551743 0xffffffffa0553de1 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa056f2bf 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05516f9 0xffffffffa0553de1 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0553af6 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa053b072 0xffffffffa0541341 0xffffffffa0570c42 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05718be 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05514f8 0xffffffffa0553de1 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa056f364 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0541323 0xffffffffa0570c42 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0551df0 0xffffffffa04bffd4 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05d75c1 0xffff881fa3ebbad8 __GI___read | --- 0xffffffffa05540e3 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0571539 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0553a92 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05516e9 0xffffffffa0553de1 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0547147 0xffffffffa05540de 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0546edd 0xffffffffa05540de 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa056f143 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa053b0bd 0xffffffffa0541341 0xffffffffa0560b7f 0xffffffffa04aeb14 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa056f23d 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa053acc2 0xffffffffa051f34a 0xffffffffa0560b17 0xffffffffa04aeb14 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05d6af0 0xffffffffa05540c2 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05ba691 0xffffffffa05341d7 0xffffffffa0551537 0xffffffffa0553de1 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0551e00 0xffffffffa04c006c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05d84b7 0xffffffffa05f5a49 0xffffffffa056f3f6 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0513871 0xffffffffa0514a55 0xffffffffa05701ef 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05cab85 0xffffffffa052e9a9 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa053b0d8 0xffffffffa0541341 0xffffffffa0570c42 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0551502 0xffffffffa0553de1 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa053b0c7 0xffffffffa0541341 0xffffffffa0570c42 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05414db 0xffffffffa0541939 0xffffffffa05718be 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa053673c 0xffffffffa055411b 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa051f2c1 0xffffffffa0560b17 0xffffffffa04aeb14 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0541904 0xffffffffa05718be 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0551670 0xffffffffa0553de1 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa056f39f 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05540eb 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05d6b3a 0xffffffffa05540c2 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa056f042 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05419be 0xffffffffa05718be 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05e096b 0xffffffffa0551724 0xffffffffa0553de1 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0537370 0xffffffffa0553de1 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0551e07 0xffffffffa04c006c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05d75aa 0xffffffffa05540c2 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05d84c1 0xffffffffa05f5a49 0xffffffffa056f3f6 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05418f0 0xffffffffa05718be 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05701e7 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0553d36 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa056f3ae 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0537377 0xffff880300000001 __GI___read | --- 0xffffffffa0603375 0xffffffffa056f3d9 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05341f8 0xffffffffa0551537 0xffffffffa0553de1 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa053424f 0xffffffffa0551537 0xffffffffa0553de1 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 4.86% 71 postgres [mmfslinux] [k] 0x1fee7 | --- 0xffffffffa04c0066 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04c0001 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04aa75c 0xffffffffa04c01d0 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04aa6dc 0xffffffffa04c01d0 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04a3277 0xffffffffa0554103 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04c0006 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04a0844 0xffffffffa0553cfb 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04aa676 0xffffffffa04c01d0 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04c000e 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04b3eb5 0xffffffffa0546edd 0xffffffffa05540de 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04a0b53 0xffffffffa0551757 0xffffffffa0553de1 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04bff72 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04bfee7 0xffffffffa04c021c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04a5403 0xffffffffa0546e9d 0xffffffffa05540de 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04a5400 0xffffffffa0546e9d 0xffffffffa05540de 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04c6048 vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04aeaf4 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04b3edc 0xffffffffa0546edd 0xffffffffa05540de 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04c60b9 vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04a0579 0xffffffffa051f536 0xffffffffa053ac4a 0xffffffffa051f34a 0xffffffffa0560b17 0xffffffffa04aeb14 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04c5ef2 vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04c0018 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04bff7e 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04a057f 0xffffffffa051f536 0xffffffffa054182c 0xffffffffa05718be 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04bfff1 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04a2c31 0xffffffffa05470e2 0xffffffffa05540de 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04aa740 0xffffffffa04c01d0 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04bff77 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04a89d8 0xffffffffa051f54e 0xffffffffa0541346 0xffffffffa0570c42 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04aeabb 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04aea0b 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04a2c21 0xffffffffa05470e2 0xffffffffa05540de 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04b3d34 0xffffffffa0546edd 0xffffffffa05540de 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 4.04% 59 postgres postgres [.] slot_deform_tuple | --- slot_deform_tuple | |--91.52%-- slot_getattr | ExecMakeFunctionResultNoSets | ExecQual | | | |--94.46%-- BitmapHeapNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --5.54%-- ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--6.78%-- ExecMakeFunctionResultNoSets | ExecQual | | | |--74.99%-- BitmapHeapNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --25.01%-- ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --1.70%-- slot_getsomeattrs ExecProject ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 3.91% 57 postgres postgres [.] BitmapHeapNext | --- BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 2.89% 42 postgres [kernel.kallsyms] [k] page_fault | --- page_fault | |--81.04%-- copy_user_generic_string | 0xffffffffa04bfedc | 0xffffffffa04c021c | 0xffffffffa0553f90 | 0xffffffffa05715f4 | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --18.96%-- 0x7a5772 HeapTupleSatisfiesMVCC | --100.00%-- BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 2.29% 33 postgres postgres [.] CHashInsert | --- CHashInsert BufTableInsert ReadBuffer_common ReadBufferExtended | |--73.07%-- index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --26.93%-- _bt_relandgetbuf _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 2.12% 31 postgres postgres [.] slot_getattr | --- slot_getattr | |--90.34%-- ExecMakeFunctionResultNoSets | ExecQual | | | |--92.82%-- BitmapHeapNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --7.18%-- ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--6.44%-- execTuplesMatch | TupleHashTableMatch | hash_search_with_hash_value | LookupTupleHashEntry | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --3.22%-- ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.85% 27 postgres postgres [.] _bt_compare | --- _bt_compare | |--77.81%-- _bt_binsrch | | | |--66.66%-- _bt_search | | _bt_first | | btgettuple | | FunctionCall2Coll | | index_getnext_tid | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --33.34%-- _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--11.10%-- _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --11.09%-- _bt_moveright _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.71% 25 postgres postgres [.] GetPrivateRefCountEntry | --- GetPrivateRefCountEntry | |--28.00%-- ReleaseBuffer | ExecClearTuple | BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--28.00%-- IncrBufferRefCount | ExecStoreTuple | BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--20.00%-- PinBuffer | ReadBuffer_common | ReadBufferExtended | | | |--60.02%-- _bt_relandgetbuf | | _bt_search | | _bt_first | | btgettuple | | FunctionCall2Coll | | index_getnext_tid | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --39.98%-- _bt_getbuf | _bt_getroot | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--20.00%-- UnpinBuffer | | | |--59.96%-- ReleaseAndReadBuffer | | | | | |--66.57%-- _bt_relandgetbuf | | | _bt_search | | | _bt_first | | | btgettuple | | | FunctionCall2Coll | | | index_getnext_tid | | | index_getnext | | | IndexNext | | | ExecScan | | | ExecProcNode | | | ExecNestLoop | | | ExecProcNode | | | ExecAgg | | | ExecProcNode | | | ExecSort | | | ExecProcNode | | | standard_ExecutorRun | | | ExplainOnePlan | | | ExplainOneQuery | | | ExplainQuery | | | standard_ProcessUtility | | | PortalRunUtility | | | FillPortalStore | | | PortalRun | | | exec_simple_query | | | PostgresMain | | | ServerLoop | | | PostmasterMain | | | main | | | __libc_start_main | | | | | --33.43%-- BitmapHeapNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | |--20.05%-- btrescan | | FunctionCall5Coll | | index_rescan | | ExecReScanIndexScan | | ExecReScan | | ExecNestLoop | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --19.99%-- ExecStoreTuple | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --4.00%-- PinBuffer_Locked ReadBuffer_common ReadBufferExtended index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.71% 25 postgres [kernel.kallsyms] [k] find_get_page | --- find_get_page find_lock_page shmem_getpage_gfp shmem_fault __do_fault handle_pte_fault do_page_fault page_fault | |--60.02%-- copy_user_generic_string | 0xffffffffa04bfedc | 0xffffffffa04c021c | 0xffffffffa0553f90 | 0xffffffffa05715f4 | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | |--27.98%-- 0x7a5772 | HeapTupleSatisfiesMVCC | BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--8.00%-- 0x49f6c7 | heap_page_prune_opt | BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --3.99%-- 0x674c50 PinBuffer ReadBuffer_common ReadBufferExtended BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.51% 22 postgres postgres [.] StrategyGetBuffer | --- StrategyGetBuffer | |--95.40%-- ReadBuffer_common | ReadBufferExtended | | | |--57.13%-- index_fetch_heap | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --42.87%-- _bt_relandgetbuf | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --4.60%-- ReadBufferExtended _bt_relandgetbuf _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.51% 22 postgres postgres [.] ExecMakeFunctionResultNoSets | --- ExecMakeFunctionResultNoSets | |--90.91%-- ExecQual | BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --9.09%-- BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.44% 21 postgres postgres [.] LWLockAttemptLock | --- LWLockAttemptLock LWLockAcquire | |--33.36%-- index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--33.28%-- _bt_relandgetbuf | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--14.30%-- BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--14.30%-- StartBufferIO | ReadBuffer_common | ReadBufferExtended | _bt_relandgetbuf | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --4.76%-- _bt_getbuf _bt_getroot _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.16% 17 postgres [kernel.kallsyms] [k] radix_tree_lookup_slot | --- radix_tree_lookup_slot find_get_page find_lock_page shmem_getpage_gfp shmem_fault __do_fault handle_pte_fault do_page_fault page_fault | |--52.95%-- 0x7a5772 | HeapTupleSatisfiesMVCC | BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--35.30%-- copy_user_generic_string | 0xffffffffa04bfedc | 0xffffffffa04c021c | 0xffffffffa0553f90 | 0xffffffffa05715f4 | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --11.75%-- 0x49f6c7 heap_page_prune_opt BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.10% 16 postgres postgres [.] PinBuffer | --- PinBuffer ReadBuffer_common ReadBufferExtended | |--68.75%-- BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --31.25%-- _bt_relandgetbuf _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.03% 15 postgres [kernel.kallsyms] [k] mem_cgroup_update_page_stat | --- mem_cgroup_update_page_stat | |--93.33%-- __do_fault | handle_pte_fault | do_page_fault | page_fault | | | |--85.70%-- copy_user_generic_string | | 0xffffffffa04bfedc | | 0xffffffffa04c021c | | 0xffffffffa0553f90 | | 0xffffffffa05715f4 | | 0xffffffffa04c61ab | | vfs_read | | sys_read | | system_call_fastpath | | 0x7fb873db55d0 | | __GI___read | | | |--7.16%-- 0x7a5772 | | HeapTupleSatisfiesMVCC | | BitmapHeapNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --7.14%-- 0x49f6c7 | heap_page_prune_opt | BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --6.67%-- 0xffff883fb7fa98b0 heap_page_prune_opt BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.03% 15 postgres postgres [.] CHashSearch | --- CHashSearch | |--86.68%-- BufTableLookup | ReadBuffer_common | ReadBufferExtended | | | |--38.45%-- _bt_relandgetbuf | | _bt_search | | _bt_first | | btgettuple | | FunctionCall2Coll | | index_getnext_tid | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | |--23.08%-- BitmapHeapNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | |--23.08%-- index_fetch_heap | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --15.40%-- _bt_getbuf | _bt_getroot | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --13.32%-- ReadBuffer_common ReadBufferExtended | |--50.07%-- _bt_getbuf | _bt_getroot | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.93%-- _bt_relandgetbuf _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.96% 14 postgres postgres [.] FunctionCall2Coll | --- FunctionCall2Coll | |--57.16%-- _bt_compare | | | |--87.49%-- _bt_binsrch | | | | | |--57.16%-- _bt_first | | | btgettuple | | | FunctionCall2Coll | | | index_getnext_tid | | | index_getnext | | | IndexNext | | | ExecScan | | | ExecProcNode | | | ExecNestLoop | | | ExecProcNode | | | ExecAgg | | | ExecProcNode | | | ExecSort | | | ExecProcNode | | | standard_ExecutorRun | | | ExplainOnePlan | | | ExplainOneQuery | | | ExplainQuery | | | standard_ProcessUtility | | | PortalRunUtility | | | FillPortalStore | | | PortalRun | | | exec_simple_query | | | PostgresMain | | | ServerLoop | | | PostmasterMain | | | main | | | __libc_start_main | | | | | --42.84%-- _bt_search | | _bt_first | | btgettuple | | FunctionCall2Coll | | index_getnext_tid | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --12.51%-- _bt_moveright | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--21.41%-- _bt_binsrch | | | |--66.71%-- _bt_first | | btgettuple | | FunctionCall2Coll | | index_getnext_tid | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --33.29%-- _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--14.27%-- _bt_checkkeys | _bt_readpage | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --7.16%-- execTuplesMatch TupleHashTableMatch hash_search_with_hash_value LookupTupleHashEntry ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.96% 14 postgres postgres [.] ExecQual | --- ExecQual | |--92.84%-- BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --7.16%-- ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.82% 12 postgres postgres [.] heap_page_prune_opt | --- heap_page_prune_opt BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.82% 12 postgres postgres [.] ExecEvalScalarVarFast | --- ExecEvalScalarVarFast | |--50.03%-- ExecMakeFunctionResultNoSets | ExecQual | | | |--83.34%-- BitmapHeapNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --16.66%-- ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.97%-- ExecQual | |--83.30%-- BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --16.70%-- ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.72% 27 swapper [kernel.kallsyms] [k] intel_idle | --- intel_idle cpuidle_idle_call cpu_idle | --100.00%-- start_kernel x86_64_start_kernel 0.69% 10 postgres postgres [.] ExecStoreTuple | --- ExecStoreTuple | |--90.03%-- BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --9.97%-- IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.69% 10 postgres postgres [.] ResourceOwnerForgetBuffer | --- ResourceOwnerForgetBuffer | |--79.99%-- ReleaseBuffer | | | |--50.03%-- ExecStoreTuple | | IndexNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | |--25.02%-- ExecClearTuple | | BitmapHeapNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --24.95%-- index_rescan | ExecReScanIndexScan | ExecReScan | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--10.03%-- UnpinBuffer | ReleaseAndReadBuffer | _bt_relandgetbuf | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --9.99%-- ExecClearTuple BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.69% 10 postgres postgres [.] ResourceOwnerRememberBuffer | --- ResourceOwnerRememberBuffer | |--59.99%-- IncrBufferRefCount | ExecStoreTuple | | | |--83.29%-- BitmapHeapNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --16.71%-- IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --40.01%-- ExecStoreTuple BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.68% 10 postgres postgres [.] ReadBuffer_common | --- ReadBuffer_common ReadBufferExtended | |--40.01%-- _bt_getbuf | _bt_getroot | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--39.99%-- index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --20.00%-- _bt_relandgetbuf _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.68% 10 postgres postgres [.] _bt_binsrch | --- _bt_binsrch | |--60.00%-- _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --40.00%-- _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.62% 9 postgres [ipt_REJECT] [.] 0x5ef30188 | --- 0xffffffffff600188 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode | |--71.39%-- ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --28.61%-- ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0xffffffffff600186 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0xffffffffff600183 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.62% 9 postgres [vdso] [.] 0x7fffe8fff619 | --- 0x7fffe8fff8b1 ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort 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 ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff600 __gettimeofday_internal ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff8d8 __gettimeofday_internal ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff662 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff619 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.55% 8 postgres postgres [.] ExecClearTuple | --- ExecClearTuple | |--50.04%-- ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--37.51%-- BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --12.45%-- ExecProject ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.55% 8 postgres postgres [.] hash_any | --- hash_any | |--74.97%-- CHashSearch | BufTableLookup | ReadBuffer_common | ReadBufferExtended | | | |--49.97%-- _bt_relandgetbuf | | _bt_search | | _bt_first | | btgettuple | | FunctionCall2Coll | | index_getnext_tid | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | |--33.40%-- index_fetch_heap | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --16.62%-- BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--12.52%-- FunctionCall1Coll | TupleHashTableHash | hash_search | LookupTupleHashEntry | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --12.51%-- CHashInsert BufTableInsert ReadBuffer_common ReadBufferExtended _bt_relandgetbuf _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.55% 8 postgres [kernel.kallsyms] [k] _raw_spin_lock_irqsave | --- _raw_spin_lock_irqsave | |--62.46%-- down | 0xffffffffa04a89cf | | | |--60.01%-- 0xffffffffa054b712 | | 0xffffffffa056f34a | | 0xffffffffa04c61ab | | vfs_read | | sys_read | | system_call_fastpath | | 0x7fb873db55d0 | | __GI___read | | | --39.99%-- 0xffffffffa051f54e | | | |--50.05%-- 0xffffffffa0541346 | | 0xffffffffa0560b7f | | 0xffffffffa04aeb14 | | 0xffffffffa04c602f | | vfs_read | | sys_read | | system_call_fastpath | | 0x7fb873db55d0 | | __GI___read | | | --49.95%-- 0xffffffffa053ac4a | 0xffffffffa051f34a | 0xffffffffa0560b17 | 0xffffffffa04aeb14 | 0xffffffffa04c602f | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | |--25.04%-- up | | | |--50.04%-- 0xffffffffa0570c42 | | 0xffffffffa04c61ab | | vfs_read | | sys_read | | system_call_fastpath | | 0x7fb873db55d0 | | __GI___read | | | --49.96%-- 0xffffffffa0541942 | 0xffffffffa05718be | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --12.50%-- 0x292 __GI___read 0.55% 8 postgres postgres [.] CHashAddToGarbage | --- CHashAddToGarbage CHashDelete BufTableDelete ReadBuffer_common ReadBufferExtended | |--50.07%-- _bt_relandgetbuf | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.93%-- index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.55% 8 postgres [kernel.kallsyms] [k] fget_light | --- fget_light | |--74.98%-- sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --25.02%-- sys_lseek system_call_fastpath 0x7fb873dc30d0 __lseek64 0.48% 7 postgres postgres [.] _bt_checkkeys | --- _bt_checkkeys _bt_readpage _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.48% 7 postgres postgres [.] IncrBufferRefCount | --- IncrBufferRefCount | |--42.87%-- BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--42.86%-- ExecStoreTuple | BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --14.27%-- IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.48% 7 postgres postgres [.] ExecProcNode | --- ExecProcNode | |--57.14%-- ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--28.58%-- ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --14.28%-- ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.48% 7 postgres postgres [.] ReleaseBuffer | --- ReleaseBuffer | |--57.13%-- ExecClearTuple | BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--28.55%-- BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --14.32%-- btrescan FunctionCall5Coll index_rescan ExecReScanIndexScan ExecReScan ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.45% 1 postgres [kernel.kallsyms] [k] 0xffffffff81152f94 | --- mem_cgroup_update_page_stat zap_pte_range unmap_page_range unmap_vmas exit_mmap mmput exit_mm do_exit do_group_exit sys_exit_group system_call_fastpath 0x7fb873d90a38 0.41% 6 postgres postgres [.] InstrStartNode | --- InstrStartNode | |--49.96%-- ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--33.37%-- ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --16.66%-- ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.41% 6 postgres postgres [.] LWLockRelease | --- LWLockRelease | |--50.03%-- ReadBuffer_common | ReadBufferExtended | | | |--66.66%-- index_fetch_heap | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --33.34%-- _bt_relandgetbuf | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--16.69%-- index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--16.67%-- _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --16.61%-- _bt_relandgetbuf _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.37% 1 swapper [kernel.kallsyms] [k] tick_nohz_restart_sched_tick | --- tick_nohz_restart_sched_tick cpu_idle 0.37% 1 mmfsd [kernel.kallsyms] [k] __task_pid_nr_ns | --- __task_pid_nr_ns 0xffffffffa04c2645 0xffffffffa0605ae4 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0xffffc900341c3998 0.34% 5 postgres postgres [.] index_fetch_heap | --- index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.34% 5 postgres postgres [.] btint4cmp | --- btint4cmp | |--80.02%-- _bt_compare | | | |--74.84%-- _bt_binsrch | | | | | |--66.62%-- _bt_search | | | _bt_first | | | btgettuple | | | FunctionCall2Coll | | | index_getnext_tid | | | index_getnext | | | IndexNext | | | ExecScan | | | ExecProcNode | | | ExecNestLoop | | | ExecProcNode | | | ExecAgg | | | ExecProcNode | | | ExecSort | | | ExecProcNode | | | standard_ExecutorRun | | | ExplainOnePlan | | | ExplainOneQuery | | | ExplainQuery | | | standard_ProcessUtility | | | PortalRunUtility | | | FillPortalStore | | | PortalRun | | | exec_simple_query | | | PostgresMain | | | ServerLoop | | | PostmasterMain | | | main | | | __libc_start_main | | | | | --33.38%-- _bt_first | | btgettuple | | FunctionCall2Coll | | index_getnext_tid | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --25.16%-- _bt_moveright | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --19.98%-- FunctionCall2Coll _bt_compare _bt_binsrch _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.34% 5 postgres postgres [.] ExecScan | --- ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.34% 5 postgres postgres [.] check_stack_depth | --- check_stack_depth | |--59.95%-- ExecMakeFunctionResultNoSets | ExecQual | | | |--66.62%-- ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --33.38%-- BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --40.05%-- ExecQual BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.34% 5 postgres [kernel.kallsyms] [k] _raw_spin_unlock_irqrestore | --- _raw_spin_unlock_irqrestore | |--59.96%-- 0xffffffffa04a89cf | 0xffffffffa051f54e | | | |--66.66%-- 0xffffffffa0541346 | | | | | |--50.03%-- 0xffffffffa0560b7f | | | 0xffffffffa04aeb14 | | | 0xffffffffa04c602f | | | vfs_read | | | sys_read | | | system_call_fastpath | | | 0x7fb873db55d0 | | | __GI___read | | | | | --49.97%-- 0xffffffffa0570c42 | | 0xffffffffa04c61ab | | vfs_read | | sys_read | | system_call_fastpath | | 0x7fb873db55d0 | | __GI___read | | | --33.34%-- 0xffffffffa053ac4a | 0xffffffffa051f34a | 0xffffffffa0560b17 | 0xffffffffa04aeb14 | 0xffffffffa04c602f | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | |--20.05%-- 0xffffffffa0541942 | 0xffffffffa05718be | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --19.99%-- 0xffffffffa053ac7c 0xffffffffa051f34a 0xffffffffa0560b17 0xffffffffa04aeb14 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.34% 5 postgres postgres [.] ReadBufferExtended | --- ReadBufferExtended | |--40.04%-- _bt_getbuf | _bt_getroot | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--20.05%-- _bt_relandgetbuf | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--19.99%-- index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --19.92%-- BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.34% 5 postgres postgres [.] MemoryContextReset | --- MemoryContextReset | |--59.96%-- ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--20.06%-- ExecReScanIndexScan | ExecReScan | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --19.98%-- ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.34% 5 postgres postgres [.] ExecEvalConst | --- ExecEvalConst | |--59.97%-- ExecMakeFunctionResultNoSets | ExecQual | BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --40.03%-- ExecQual BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.34% 5 postgres postgres [.] CheckForSerializableConflictOut | --- CheckForSerializableConflictOut | |--60.03%-- BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --39.97%-- ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.32% 5 postgres postgres [.] SyncOneBuffer | --- SyncOneBuffer BgBufferSync BackgroundWriterMain AuxiliaryProcessMain StartChildProcess reaper __restore_rt PostmasterMain main __libc_start_main 0.27% 4 postgres postgres [.] fmgr_info_copy | --- fmgr_info_copy | |--75.02%-- btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --24.98%-- _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.27% 4 postgres postgres [.] PredicateLockTuple | --- PredicateLockTuple | |--49.97%-- index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--25.02%-- BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --25.01%-- ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.27% 4 postgres postgres [.] BufTableLookup | --- BufTableLookup | |--50.03%-- ReadBuffer_common | ReadBufferExtended | _bt_relandgetbuf | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.97%-- ReadBufferExtended BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.27% 4 postgres postgres [.] date_ge | --- date_ge ExecQual BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.27% 4 postgres postgres [.] _bt_first | --- _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.27% 4 postgres postgres [.] ExecProject | --- ExecProject | |--50.00%-- ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --50.00%-- ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.27% 4 postgres postgres [.] _bt_checkpage | --- _bt_checkpage | |--50.06%-- _bt_getbuf | _bt_getroot | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.94%-- _bt_relandgetbuf _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.27% 4 postgres postgres [.] pgstat_init_function_usage | --- pgstat_init_function_usage | |--75.04%-- ExecQual | | | |--66.70%-- ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --33.30%-- BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --24.96%-- ExecMakeFunctionResultNoSets ExecQual BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.27% 4 postgres postgres [.] InstrEndLoop | --- InstrEndLoop ExecReScan ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.27% 4 postgres postgres [.] TransactionIdPrecedes | --- TransactionIdPrecedes | |--75.05%-- HeapTupleSatisfiesMVCC | | | |--66.66%-- BitmapHeapNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --33.34%-- heap_hot_search_buffer | index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --24.95%-- XidInMVCCSnapshot HeapTupleSatisfiesMVCC BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.27% 4 postgres postgres [.] LockBuffer | --- LockBuffer | |--49.95%-- index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--25.07%-- _bt_relandgetbuf | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --24.98%-- btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.27% 4 postgres postgres [.] ExecAgg | --- ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.27% 4 postgres postgres [.] _bt_readpage | --- _bt_readpage _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.27% 4 postgres postgres [.] FileRead | --- FileRead mdread ReadBuffer_common ReadBufferExtended | |--75.00%-- _bt_relandgetbuf | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --25.00%-- index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.27% 4 postgres postgres [.] PageIsVerified | --- PageIsVerified | |--74.99%-- ReadBuffer_common | ReadBufferExtended | | | |--66.72%-- index_fetch_heap | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --33.28%-- _bt_relandgetbuf | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --25.01%-- ReadBufferExtended index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.22% 1 perf [kernel.kallsyms] [k] __lookup_mnt | --- __lookup_mnt do_lookup link_path_walk path_openat do_filp_open do_sys_open system_call_fastpath 0x7f310718a1e0 __GI___open64 0.21% 3 postgres postgres [.] slot_getsomeattrs | --- slot_getsomeattrs ExecProject ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.21% 3 postgres libc-2.11.3.so [.] __gettimeofday_internal | --- __gettimeofday_internal ExecProcNode | |--66.69%-- ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --33.31%-- ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.21% 3 postgres [kernel.kallsyms] [k] page_add_file_rmap | --- page_add_file_rmap __do_fault handle_pte_fault do_page_fault page_fault | |--66.71%-- copy_user_generic_string | 0xffffffffa04bfedc | 0xffffffffa04c021c | 0xffffffffa0553f90 | 0xffffffffa05715f4 | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --33.29%-- 0x7a5772 HeapTupleSatisfiesMVCC BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.21% 3 postgres postgres [.] DataChecksumsEnabled | --- DataChecksumsEnabled | |--66.66%-- ReadBuffer_common | ReadBufferExtended | index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --33.34%-- PageIsVerified ReadBuffer_common ReadBufferExtended _bt_relandgetbuf _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.21% 3 postgres postgres [.] pgstat_end_function_usage | --- pgstat_end_function_usage | |--66.67%-- ExecMakeFunctionResultNoSets | ExecQual | BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --33.33%-- ExecQual BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.21% 3 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.21% 3 postgres [kernel.kallsyms] [k] __do_fault | --- __do_fault handle_pte_fault do_page_fault page_fault copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.21% 3 postgres [kernel.kallsyms] [k] down_read_trylock | --- down_read_trylock do_page_fault page_fault | |--66.79%-- 0x7a5772 | HeapTupleSatisfiesMVCC | BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --33.21%-- copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.21% 3 postgres postgres [.] AllocSetAlloc | --- AllocSetAlloc | |--66.67%-- _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --33.33%-- palloc0 bms_make_singleton ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.21% 3 postgres postgres [.] date_lt | --- date_lt ExecQual | |--66.57%-- BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --33.43%-- ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.21% 3 postgres postgres [.] CHashDelete | --- CHashDelete BufTableDelete ReadBuffer_common ReadBufferExtended index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.21% 3 postgres [kernel.kallsyms] [k] handle_pte_fault | --- handle_pte_fault do_page_fault page_fault | |--66.65%-- copy_user_generic_string | 0xffffffffa04bfedc | 0xffffffffa04c021c | 0xffffffffa0553f90 | 0xffffffffa05715f4 | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --33.35%-- 0x49f6c7 heap_page_prune_opt BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.21% 3 postgres postgres [.] btgettuple | --- btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.21% 3 postgres [kernel.kallsyms] [k] rw_verify_area | --- rw_verify_area vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.21% 3 postgres libc-2.11.3.so [.] __memmove_ssse3 | --- __memmove_ssse3 FunctionCall5Coll index_rescan ExecReScanIndexScan ExecReScan ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.21% 3 postgres postgres [.] advance_aggregates | --- advance_aggregates ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.21% 3 postgres postgres [.] index_getnext_tid | --- index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.18% 2 postgres postgres [.] hash_search_with_hash_value | --- hash_search_with_hash_value | |--62.85%-- tbm_mark_page_lossy | tbm_add_page | bringetbitmap | FunctionCall2Coll | index_getbitmap | MultiExecBitmapIndexScan | BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --37.15%-- LookupTupleHashEntry ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.14% 2 postgres postgres [.] TerminateBufferIO | --- TerminateBufferIO ReadBuffer_common ReadBufferExtended index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.14% 2 postgres [kernel.kallsyms] [k] native_read_tsc | --- native_read_tsc read_tsc getnstimeofday 0xffffffffa04a8d10 0xffffffffa0554088 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.14% 2 postgres [kernel.kallsyms] [k] mem_cgroup_count_vm_event | --- mem_cgroup_count_vm_event handle_mm_fault do_page_fault page_fault | |--50.00%-- copy_user_generic_string | 0xffffffffa04bfedc | 0xffffffffa04c021c | 0xffffffffa0553f90 | 0xffffffffa05715f4 | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --50.00%-- 0x7a5772 HeapTupleSatisfiesMVCC BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.14% 2 postgres [kernel.kallsyms] [k] handle_mm_fault | --- handle_mm_fault do_page_fault page_fault | |--50.06%-- 0x7a5772 | HeapTupleSatisfiesMVCC | BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.94%-- copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.14% 2 postgres [kernel.kallsyms] [k] lookup_page_cgroup | --- lookup_page_cgroup mem_cgroup_update_page_stat __do_fault handle_pte_fault do_page_fault page_fault 0x7a5772 HeapTupleSatisfiesMVCC BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.14% 2 postgres postgres [.] ExecReScan | --- ExecReScan | |--50.05%-- ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.95%-- ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.14% 2 postgres [kernel.kallsyms] [k] shmem_fault | --- shmem_fault __do_fault handle_pte_fault do_page_fault page_fault copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.14% 2 postgres postgres [.] _bt_search | --- _bt_search | |--50.05%-- _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.95%-- btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.14% 2 postgres [kernel.kallsyms] [k] error_entry | --- error_entry copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.14% 2 postgres postgres [.] ReleaseAndReadBuffer | --- ReleaseAndReadBuffer BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.14% 2 postgres postgres [.] int8inc | --- int8inc advance_aggregates ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.14% 2 postgres postgres [.] XidInMVCCSnapshot | --- XidInMVCCSnapshot | |--50.04%-- BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.96%-- HeapTupleSatisfiesMVCC BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.14% 2 postgres postgres [.] ShutdownExprContext | --- ShutdownExprContext ExecReScan ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.14% 2 postgres [kernel.kallsyms] [k] do_page_fault | --- do_page_fault page_fault copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.14% 2 postgres [kernel.kallsyms] [k] up_read | --- up_read do_page_fault page_fault | |--50.02%-- 0x7a5772 | HeapTupleSatisfiesMVCC | BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.98%-- 0x49f6c7 heap_page_prune_opt BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.14% 2 postgres postgres [.] ExecNestLoop | --- ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.14% 2 postgres postgres [.] UnpinBuffer | --- UnpinBuffer ReleaseAndReadBuffer BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.14% 2 postgres postgres [.] PredicateLockPage | --- PredicateLockPage | |--50.04%-- _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.96%-- btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.14% 2 postgres postgres [.] _bt_preprocess_array_keys | --- _bt_preprocess_array_keys | |--50.06%-- btrescan | FunctionCall5Coll | index_rescan | ExecReScanIndexScan | ExecReScan | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.94%-- FunctionCall5Coll index_rescan ExecReScanIndexScan ExecReScan ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.14% 2 postgres postgres [.] bms_make_singleton | --- bms_make_singleton ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.14% 2 postgres postgres [.] InstrStopNode | --- InstrStopNode | |--50.06%-- ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.94%-- ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.14% 2 postgres [kernel.kallsyms] [k] __memcpy | --- __memcpy 0xffffffffa04aeab2 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.14% 2 postgres [kernel.kallsyms] [k] _raw_spin_lock | --- _raw_spin_lock __do_fault handle_pte_fault do_page_fault page_fault copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.14% 2 postgres postgres [.] execTuplesMatch | --- execTuplesMatch TupleHashTableMatch hash_search_with_hash_value LookupTupleHashEntry ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.14% 2 postgres postgres [.] _bt_preprocess_keys | --- _bt_preprocess_keys _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.14% 2 postgres libc-2.11.3.so [.] __lseek64 | --- __lseek64 mdread ReadBuffer_common ReadBufferExtended index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.14% 2 postgres [kernel.kallsyms] [k] system_call_after_swapgs | --- system_call_after_swapgs | |--50.10%-- 0x7fb873db55d0 | __GI___read | --49.90%-- 0x7fb873dc30d0 __GI___read 0.14% 2 postgres postgres [.] ExecEvalParamExec | --- ExecEvalParamExec | |--50.01%-- ExecReScanIndexScan | ExecReScan | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.99%-- ExecIndexEvalRuntimeKeys ExecReScanIndexScan ExecReScan ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.14% 2 postgres postgres [.] ResourceOwnerEnlargeBuffers | --- ResourceOwnerEnlargeBuffers | |--50.05%-- ReadBuffer_common | ReadBufferExtended | index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.95%-- IncrBufferRefCount ExecStoreTuple BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.14% 2 postgres [kernel.kallsyms] [k] set_page_dirty | --- set_page_dirty __do_fault handle_pte_fault do_page_fault page_fault copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.12% 1 ksoftirqd/0 [kernel.kallsyms] [k] __free_pages | --- __free_pages rb_free rcu_do_batch rcu_process_callbacks __do_softirq run_ksoftirqd kthread kernel_thread_helper 0.08% 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.07% 1 postgres libc-2.11.3.so [.] __GI___read | --- __GI___read | |--99.15%-- mdread | ReadBuffer_common | ReadBufferExtended | index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --0.85%-- PgstatCollectorMain pgstat_start reaper __restore_rt PostmasterMain main __libc_start_main 0.07% 1 postgres postgres [.] FunctionCall1Coll | --- FunctionCall1Coll TupleHashTableHash hash_search LookupTupleHashEntry ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres postgres [.] ExecBitmapHeapScan | --- ExecBitmapHeapScan ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres postgres [.] IsCatalogRelation | --- IsCatalogRelation index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres postgres [.] ExecStoreVirtualTuple | --- ExecStoreVirtualTuple ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres [kernel.kallsyms] [k] error_kernelspace | --- error_kernelspace copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.07% 1 postgres [kernel.kallsyms] [k] __remove_hrtimer | --- __remove_hrtimer __run_hrtimer hrtimer_interrupt smp_apic_timer_interrupt apic_timer_interrupt 0xffffffffa04adcf4 0xffffffffa04c6050 vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.07% 1 postgres [kernel.kallsyms] [k] __set_page_dirty_no_writeback | --- __set_page_dirty_no_writeback __do_fault handle_pte_fault do_page_fault page_fault copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.07% 1 postgres postgres [.] _bt_next | --- _bt_next btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres postgres [.] gettimeofday@plt | --- gettimeofday@plt ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres postgres [.] LWLockAcquire | --- LWLockAcquire _bt_relandgetbuf _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres [kernel.kallsyms] [k] fsnotify | --- fsnotify vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.07% 1 postgres [kernel.kallsyms] [k] cap_capable | --- cap_capable apparmor_capable ns_capable 0xffffffffa04aeaeb 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.07% 1 postgres postgres [.] _bt_mark_scankey_required | --- _bt_mark_scankey_required _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres postgres [.] StartBufferIO | --- StartBufferIO ReadBuffer_common ReadBufferExtended index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres postgres [.] palloc | --- palloc _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres postgres [.] palloc0 | --- palloc0 ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres postgres [.] hash_search | --- hash_search LookupTupleHashEntry ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres postgres [.] bms_free | --- bms_free ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres postgres [.] ScanKeyEntryInitializeWithInfo | --- ScanKeyEntryInitializeWithInfo btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres postgres [.] _bt_getroot | --- _bt_getroot _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres postgres [.] heap_hot_search_buffer | --- heap_hot_search_buffer index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres [kernel.kallsyms] [k] find_lock_page | --- find_lock_page shmem_getpage_gfp shmem_fault __do_fault handle_pte_fault do_page_fault page_fault copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.07% 1 postgres [kernel.kallsyms] [k] down | --- down 0xffffffffa04a89cf 0xffffffffa054b712 0xffffffffa056f34a 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.07% 1 postgres [kernel.kallsyms] [k] shmem_getpage_gfp | --- shmem_getpage_gfp shmem_fault __do_fault handle_pte_fault do_page_fault page_fault copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.07% 1 postgres [kernel.kallsyms] [k] system_call_fastpath | --- system_call_fastpath 0x7fb873db55d0 __GI___read BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres [kernel.kallsyms] [k] security_capable | --- security_capable ns_capable 0xffffffffa04aeaeb 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.07% 1 postgres [kernel.kallsyms] [k] fsnotify_access | --- fsnotify_access vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.07% 1 kworker/9:2 [kernel.kallsyms] [k] do_dbs_timer | --- do_dbs_timer process_one_work worker_thread kthread kernel_thread_helper 0.07% 1 postgres postgres [.] isTempToastNamespace | --- isTempToastNamespace IsCatalogClass heap_page_prune_opt index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres postgres [.] hashbpchar | --- hashbpchar TupleHashTableHash hash_search LookupTupleHashEntry ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres postgres [.] IndexNext | --- IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres postgres [.] tbm_iterate | --- tbm_iterate BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres postgres [.] bpchareq | --- bpchareq execTuplesMatch TupleHashTableMatch hash_search_with_hash_value LookupTupleHashEntry ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres [kernel.kallsyms] [k] system_call | --- system_call __GI___read 0.07% 1 postgres postgres [.] TupleHashTableMatch | --- TupleHashTableMatch LookupTupleHashEntry ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 kworker/9:2 [kernel.kallsyms] [k] wq_worker_sleeping | --- wq_worker_sleeping thread_return worker_thread kthread kernel_thread_helper 0.07% 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 copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.07% 1 postgres [kernel.kallsyms] [k] error_exit | --- error_exit copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.07% 1 postgres [kernel.kallsyms] [k] unlock_page | --- unlock_page __do_fault handle_pte_fault do_page_fault page_fault copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.07% 1 postgres postgres [.] _bt_fix_scankey_strategy | --- _bt_fix_scankey_strategy _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres libc-2.11.3.so [.] __GI_memcpy | --- __GI_memcpy BufTableLookup ReadBuffer_common ReadBufferExtended _bt_getbuf _bt_getroot _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.07% 1 postgres postgres [.] pfree | --- pfree _bt_freestack _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.06% 9 mmfsd [unknown] [.] 0x7ffb7c0c4e22 | --- 0x1133cc9 0xffffc900341c3998 | --- 0x5e1cc0 0x3600000000 0x1 0xffffc900308ce328 | --- 0x5c3c00 0x184aba | --- 0x5d4367 | --- 0x5af150 0xffffc900341c3998 | --- 0x7ffb7c0c4e22 0x4000000000 | --- 0x5d433c | --- 0x7ffb7c11f3d7 0xffffc900341c3998 0.05% 1 swapper [kernel.kallsyms] [k] hrtimer_interrupt | --- hrtimer_interrupt smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.03% 1 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.02% 1 swapper [kernel.kallsyms] [k] notifier_call_chain | --- notifier_call_chain __atomic_notifier_call_chain smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.01% 1 postgres [kernel.kallsyms] [k] poll_freewait | --- poll_freewait do_sys_poll sys_poll system_call_fastpath 0x7fb873db9b8f __libc_poll 0.01% 1 sadc [kernel.kallsyms] [k] vsnprintf | --- vsnprintf seq_printf show_stat seq_read proc_reg_read vfs_read sys_read system_call_fastpath 0x7fc5013625d0 __GI___read 0.01% 1 swapper [kernel.kallsyms] [k] menu_reflect | --- menu_reflect cpu_idle 0.01% 1 mmfsd [kernel.kallsyms] [k] __memcpy | --- __memcpy load_balance idle_balance thread_return 0xffffffffa04a8b7d 0xffffffffa05bf0f1 0xffffffffa05c0478 0xffffffffa0605afe 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0xffffc900341c3998 0.01% 1 swapper [kernel.kallsyms] [k] select_task_rq_fair | --- select_task_rq_fair try_to_wake_up hrtimer_wakeup __run_hrtimer hrtimer_interrupt smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.01% 1 postgres [kernel.kallsyms] [k] do_sync_read | --- do_sync_read vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.00% 1 mmfsd [kernel.kallsyms] [k] up | --- up 0xffffffffa05bf4b1 0xffffffffa0605aa3 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0.00% 2 swapper [kernel.kallsyms] [k] ktime_get_real | --- ktime_get_real intel_idle cpuidle_idle_call cpu_idle 0.00% 1 mmfsd [mmfslinux] [k] 0x1e299 | --- 0xffffffffa04be299 0xffffffffa05c064a 0xffffffffa0605a42 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0x1bfffffffff 0.00% 1 mmfsd [kernel.kallsyms] [k] cpumask_next_and | --- cpumask_next_and find_busiest_group load_balance idle_balance thread_return 0xffffffffa04a8b7d 0xffffffffa05c07e5 0xffffffffa05c0bbf 0xffffffffa0605bc1 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0.00% 1 postgres [kernel.kallsyms] [k] recalc_sigpending | --- recalc_sigpending dequeue_signal get_signal_to_deliver do_signal do_notify_resume int_signal 0x7fb873dbc373 __GI___select PostmasterMain main __libc_start_main 0.00% 1 kworker/0:0 [ixgbe] [k] ixgbe_update_stats | --- ixgbe_update_stats ixgbe_watchdog_subtask ixgbe_service_task process_one_work worker_thread kthread kernel_thread_helper 0.00% 1 mmfsd [kernel.kallsyms] [k] find_busiest_group | --- find_busiest_group load_balance idle_balance thread_return 0xffffffffa04a8b7d 0xffffffffa05c07e5 0xffffffffa05c0bbf 0xffffffffa0605bc1 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0.00% 1 mmfsd [kernel.kallsyms] [k] pick_next_task_rt | --- pick_next_task_rt thread_return 0xffffffffa04a8b7d 0xffffffffa05bf0f1 0xffffffffa05c0478 0xffffffffa0605afe 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0xffffc900341c3998 0.00% 1 swapper [kernel.kallsyms] [k] 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] enqueue_sleeper | --- enqueue_sleeper enqueue_entity enqueue_task_fair ttwu_activate 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 start_kernel x86_64_start_kernel 0.00% 1 mmfsd [kernel.kallsyms] [k] finish_task_switch | --- finish_task_switch thread_return do_nanosleep hrtimer_nanosleep sys_nanosleep system_call_fastpath 0x7ffb7c0f466d 0x7ffb7c0f466d 0.00% 2 swapper [kernel.kallsyms] [k] rcu_needs_cpu | --- rcu_needs_cpu tick_nohz_stop_sched_tick cpu_idle | --100.00%-- start_kernel x86_64_start_kernel 0.00% 2 fail2ban-server [unknown] [.] 0x7f4657d5f8d5 | --- 0x7f4657d83a48 | --- 0x7f4657d5f8d5 0.00% 1 swapper [kernel.kallsyms] [k] native_set_ldt | --- native_set_ldt thread_return cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] timerqueue_del | --- timerqueue_del __remove_hrtimer __hrtimer_start_range_ns tick_nohz_stop_sched_tick irq_exit do_IRQ ret_from_intr intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] irq_entries_start | --- irq_entries_start intel_idle cpuidle_idle_call cpu_idle 0.00% 2 mmfsd [kernel.kallsyms] [k] try_to_wake_up | --- try_to_wake_up __wake_up_common __wake_up | |--76.97%-- 0xffffffffa04a7ff0 | 0xffffffffa05c042a | 0xffffffffa0605afe | 0xffffffffa04c3c65 | do_vfs_ioctl | sys_ioctl | system_call_fastpath | 0x7ffb7c11f3d7 | 0x7ffb7c11f3d7 | 0xffffc900341c3998 | --23.03%-- 0xffffffffa04be300 0xffffffffa05c064a 0xffffffffa0605a42 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0x1bfffffffff 0.00% 1 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 swapper [kernel.kallsyms] [k] pm_qos_request | --- pm_qos_request menu_select cpuidle_idle_call cpu_idle 0.00% 2 postgres postgres [.] PgstatCollectorMain | --- PgstatCollectorMain pgstat_start reaper __restore_rt PostmasterMain main __libc_start_main 0.00% 1 hald [unknown] [.] 0x7f998455f5fc | --- 0x7f998455f5fc 0x2 (nil) 0xe0001000 0.00% 1 kworker/2:1 [kernel.kallsyms] [k] free_block | --- free_block drain_array cache_reap process_one_work worker_thread kthread kernel_thread_helper 0.00% 1 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% 1 swapper [kernel.kallsyms] [k] rcu_bh_qs | --- rcu_bh_qs __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] kill_fasync | --- kill_fasync add_interrupt_randomness handle_irq_event_percpu handle_irq_event handle_edge_irq handle_irq do_IRQ ret_from_intr intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] add_interrupt_randomness | --- add_interrupt_randomness handle_irq_event_percpu handle_irq_event handle_edge_irq handle_irq do_IRQ ret_from_intr intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] net_rx_action | --- 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] __schedule | --- __schedule cpu_idle 0.00% 1 postgres postgres [.] WaitLatchOrSocket | --- WaitLatchOrSocket PgstatCollectorMain pgstat_start reaper __restore_rt PostmasterMain main __libc_start_main 0.00% 1 postgres [kernel.kallsyms] [k] __switch_to | --- __switch_to thread_return 0xffff881fc284e000 __libc_poll 0.00% 1 postgres [kernel.kallsyms] [k] update_curr | --- update_curr dequeue_entity dequeue_task_fair __schedule 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] find_busiest_group | --- find_busiest_group load_balance idle_balance thread_return schedule_hrtimeout_range_clock poll_schedule_timeout do_poll do_sys_poll sys_poll system_call_fastpath 0x7fb873db9b8f __libc_poll 0.00% 1 postgres [kernel.kallsyms] [k] poll_schedule_timeout | --- poll_schedule_timeout do_poll do_sys_poll sys_poll system_call_fastpath 0x7fb873db9b8f __libc_poll 0.00% 1 postgres [kernel.kallsyms] [k] do_sys_poll | --- do_sys_poll sys_poll system_call_fastpath 0x7fb873db9b8f __libc_poll 0.00% 1 postgres [kernel.kallsyms] [k] memcpy_toiovec | --- memcpy_toiovec skb_copy_datagram_iovec udp_recvmsg inet_recvmsg sock_recvmsg sys_recvfrom system_call_fastpath 0x7fb873dc3eb5 __libc_recv 0.00% 1 kworker/8:1 [kernel.kallsyms] [k] cpufreq_cpu_get | --- cpufreq_cpu_get __cpufreq_driver_getavg dbs_check_cpu do_dbs_timer process_one_work worker_thread kthread kernel_thread_helper 0.00% 1 swapper [kernel.kallsyms] [k] cpuidle_idle_call | --- cpuidle_idle_call cpu_idle 0.00% 1 fail2ban-server [kernel.kallsyms] [k] sys_select | --- sys_select system_call_fastpath 0x7f465715f393 0x7f465715f393 0x602010 0x602010 0.00% 1 swapper [kernel.kallsyms] [k] rcu_exit_nohz | --- rcu_exit_nohz irq_enter smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 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 smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] sched_clock_tick | --- sched_clock_tick sched_clock_idle_wakeup_event tick_check_idle irq_enter smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] rebalance_domains | --- 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 # # (For a higher level overview, try: perf report --sort comm,dso) #