# Events: 2K cycles # # Overhead Samples Command Shared Object Symbol # ........ .......... ............... ................. ............................... # 11.77% 285 postgres postgres [.] ExecScanHashBucket | --- ExecScanHashBucket ExecHashJoin ExecProcNode | |--90.88%-- ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | 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.12%-- 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.80% 213 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 5.91% 143 postgres postgres [.] _bt_compare | --- _bt_compare | |--95.81%-- _bt_binsrch | | | |--74.46%-- _bt_first | | btgettuple | | FunctionCall2Coll | | index_getnext_tid | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --25.54%-- _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--2.10%-- _bt_moveright | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --2.09%-- _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 4.21% 102 postgres [mmfs26] [k] 0x5f2bf | --- 0xffffffffa05e1d4d __GI___read | --- 0xffffffffa0513864 0xffffffffa0514a55 0xffffffffa05701ef 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0551e00 | |--66.75%-- 0xffffffffa04c006c | 0xffffffffa0553f90 | 0xffffffffa05715f4 | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --33.25%-- 0xffffffffa04bffd4 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 | --- 0xffffffffa05351b4 0xffffffffa055170e 0xffffffffa0553de1 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa055152c 0xffffffffa0553de1 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05e0937 0xffffffffa0551724 0xffffffffa0553de1 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa053677e 0xffffffffa055411b 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0560b28 0xffffffffa04aeb14 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05d7594 0xffffffffa05540c2 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 | --- 0xffffffffa053424f 0xffffffffa0551537 0xffffffffa0553de1 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 | --- 0xffffffffa056f40d 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 | --- 0xffffffffa0546ebb 0xffffffffa05540de 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0553b6e 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05e1d5e __GI___read | --- 0xffffffffa0553b0b 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05515d1 0xffffffffa0553de1 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0603245 0xffffffffa056f3d9 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05ba66a 0xffffffffa05341d7 0xffffffffa0551537 0xffffffffa0553de1 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0553ae0 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0546cd0 0xffffffffa05540de 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0541074 0xffffffffa0541356 0xffffffffa0570c42 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa051386b 0xffffffffa0514a55 0xffffffffa05701ef 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 | --- 0xffffffffa056f975 0x2000 __GI___read | --- 0xffffffffa05d84b7 0xffffffffa05f5a49 0xffffffffa056f3f6 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0553cc3 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0560a91 0xffffffffa04aeb14 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0514a41 0xffffffffa05701ef 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa056f39f 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa054191f 0xffffffffa05718be 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0560a90 0xffffffffa04aeb14 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0551df9 0xffffffffa04c006c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0603224 0xffffffffa056f3d9 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0560ad9 0xffffffffa04aeb14 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa051f310 0xffffffffa0560b17 0xffffffffa04aeb14 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05515e8 0xffffffffa0553de1 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05d6bbf 0xffffffffa05540c2 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 | --- 0xffffffffa056f040 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa055177a 0xffffffffa0553de1 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0554116 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa056f187 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 | --- 0xffffffffa0560aa8 0xffffffffa04aeb14 0xffffffffa04c602f 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 | --- 0xffffffffa05373ca 0xffffffffa0551586 0xffffffffa0553de1 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0514acf 0x100000002 __GI___read | --- 0xffffffffa0571884 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa051f538 0xffffffffa0541346 0xffffffffa0570c42 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa053b4b2 0xffffffffa05419a3 0xffffffffa05718be 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05d6be0 0xffffffffa05540c2 0xffffffffa05715f4 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 | --- 0xffffffffa0537282 0xffffffffa0551586 0xffffffffa0553de1 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05540fa 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 | --- 0xffffffffa0553dba 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05e1d6a __GI___read | --- 0xffffffffa0541885 0xffffffffa05718be 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0553cbe 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa056f2bf 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa056f042 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0551df3 0xffffffffa04c006c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0571539 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05515c5 0xffffffffa0553de1 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05d6d75 0xffffffffa05540c2 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0551525 0xffffffffa0553de1 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0551772 0xffffffffa0553de1 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0553b48 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0537327 0xffffffffa0551586 0xffffffffa0553de1 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05413de 0xffffffffa0541939 0xffffffffa05718be 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05f5a34 0xffffffffa056f3f6 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05540eb 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 3.76% 91 postgres [mmfslinux] [k] 0x8d08 | --- 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 | --- 0xffffffffa04aa6dc 0xffffffffa04c01d0 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 | --- 0xffffffffa04bfff1 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04afb41 sys_lseek system_call_fastpath 0x7fb873dc30d0 __lseek64 | --- 0xffffffffa04a0b53 0xffffffffa0551757 0xffffffffa0553de1 0xffffffffa05715f4 0xffffffffa04c61ab 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 | --- 0xffffffffa04aa75c 0xffffffffa04c01d0 0xffffffffa0553f90 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 | --- 0xffffffffa04c5e67 vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04aa640 0xffffffffa04c01d0 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04c0105 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04aea62 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04c005e 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04bfea6 0xffffffffa04c021c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04afacb sys_lseek system_call_fastpath 0x7fb873dc30d0 __lseek64 | --- 0xffffffffa04aa642 0xffffffffa04c01d0 0xffffffffa0553f90 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 | --- 0xffffffffa04a8d08 0xffffffffa0554088 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 | --- 0xffffffffa04b3d09 0xffffffffa0546edd 0xffffffffa05540de 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04afac4 sys_lseek system_call_fastpath 0x7fb873dc30d0 __lseek64 | --- 0xffffffffa04a8d14 0xffffffffa0554088 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04aeaf4 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04bff90 0xffffffffa0553f90 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 | --- 0xffffffffa04c611d vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04a8d20 0xffffffffa0554088 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04bffcb 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04bfbd5 0xffffffffa04c021c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04c0201 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 | --- 0xffffffffa04c5e93 vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04c6103 vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04aa698 0xffffffffa04c01d0 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04c0075 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04c5ec2 vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04c0100 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 3.56% 86 postgres postgres [.] CHashBucketScan | --- CHashBucketScan | |--69.85%-- CHashSearch | BufTableLookup | ReadBuffer_common | ReadBufferExtended | | | |--36.52%-- index_fetch_heap | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | |--29.87%-- _bt_relandgetbuf | | _bt_search | | _bt_first | | btgettuple | | FunctionCall2Coll | | index_getnext_tid | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | |--21.99%-- heapgetpage | | heapgettup_pagemode | | heap_getnext | | SeqNext | | ExecScan | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | | | | |--67.99%-- ExecNestLoop | | | ExecProcNode | | | ExecHashJoin | | | ExecProcNode | | | ExecAgg | | | ExecProcNode | | | ExecSort | | | ExecProcNode | | | standard_ExecutorRun | | | ExplainOnePlan | | | ExplainOneQuery | | | ExplainQuery | | | standard_ProcessUtility | | | PortalRunUtility | | | FillPortalStore | | | PortalRun | | | exec_simple_query | | | PostgresMain | | | ServerLoop | | | PostmasterMain | | | main | | | __libc_start_main | | | | | --32.01%-- MultiExecHash | | ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --11.62%-- _bt_getbuf | _bt_getroot | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--27.83%-- CHashDelete | BufTableDelete | ReadBuffer_common | ReadBufferExtended | | | |--87.51%-- index_fetch_heap | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | |--8.32%-- heapgetpage | | heapgettup_pagemode | | heap_getnext | | SeqNext | | ExecScan | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --4.17%-- _bt_relandgetbuf | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --2.32%-- BufTableLookup ReadBuffer_common ReadBufferExtended _bt_getbuf _bt_getroot _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode 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.14% 76 postgres postgres [.] slot_deform_tuple | --- slot_deform_tuple | |--88.17%-- slot_getattr | | | |--59.70%-- ExecMakeFunctionResultNoSets | | ExecQual | | | | | |--97.50%-- ExecScan | | | ExecProcNode | | | ExecNestLoop | | | ExecProcNode | | | ExecHashJoin | | | ExecProcNode | | | ExecAgg | | | ExecProcNode | | | ExecSort | | | ExecProcNode | | | standard_ExecutorRun | | | ExplainOnePlan | | | ExplainOneQuery | | | ExplainQuery | | | standard_ProcessUtility | | | PortalRunUtility | | | FillPortalStore | | | PortalRun | | | exec_simple_query | | | PostgresMain | | | ServerLoop | | | PostmasterMain | | | main | | | __libc_start_main | | | | | --2.50%-- ExecScanHashBucket | | ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --40.30%-- ExecHashGetHashValue | ExecHashJoin | ExecProcNode | | | |--81.44%-- ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --18.56%-- MultiExecHash | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--7.89%-- slot_getsomeattrs | ExecProject | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | 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.62%-- ExecHashGetHashValue | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --1.31%-- ExecProject ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode 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.66% 64 postgres [ipt_REJECT] [.] 0x5ef30188 | --- 0xffffffffff600188 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode | |--91.18%-- ExecHashJoin | ExecProcNode | | | |--91.88%-- ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | 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.70%-- MultiExecHash | | ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --2.42%-- 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.82%-- ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode 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 | |--75.04%-- ExecHashJoin | ExecProcNode | | | |--83.31%-- ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | 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%-- 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%-- ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0xffffffffff60018e 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecHashJoin ExecProcNode | |--66.72%-- ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | 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%-- 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 | |--50.00%-- ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --50.00%-- ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0xffffffffff60019e 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecHashJoin ExecProcNode | |--50.05%-- MultiExecHash | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.95%-- ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0xffffffffff600180 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecHashJoin ExecProcNode | |--50.12%-- MultiExecHash | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.88%-- ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0xffffffffff60018c 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0xffffffffff600191 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 2.03% 49 postgres [kernel.kallsyms] [k] page_fault | --- page_fault | |--58.89%-- copy_user_generic_string | 0xffffffffa04bfedc | 0xffffffffa04c021c | 0xffffffffa0553f90 | 0xffffffffa05715f4 | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | |--14.70%-- 0x7a5772 | HeapTupleSatisfiesMVCC | | | |--65.65%-- heapgetpage | | heapgettup_pagemode | | heap_getnext | | SeqNext | | ExecScan | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | | | | |--75.56%-- MultiExecHash | | | ExecHashJoin | | | ExecProcNode | | | ExecNestLoop | | | ExecProcNode | | | ExecHashJoin | | | ExecProcNode | | | ExecAgg | | | ExecProcNode | | | ExecSort | | | ExecProcNode | | | standard_ExecutorRun | | | ExplainOnePlan | | | ExplainOneQuery | | | ExplainQuery | | | standard_ProcessUtility | | | PortalRunUtility | | | FillPortalStore | | | PortalRun | | | exec_simple_query | | | PostgresMain | | | ServerLoop | | | PostmasterMain | | | main | | | __libc_start_main | | | | | --24.44%-- ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | |--18.30%-- CHashSearch | | | --16.05%-- SeqNext | 0x441f0fc3c9e5 | |--8.13%-- 0x4accae | _bt_compare | | | |--74.97%-- 0x2 | | | --25.03%-- 0x7fb75b941498 | |--8.12%-- 0x49d348 | heap_hot_search_buffer | | | |--74.98%-- index_fetch_heap | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --25.02%-- _bt_binsrch | |--6.10%-- 0x49f6c7 | heap_page_prune_opt | | | --100.00%-- index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--2.03%-- 0x7a5888 | HeapTupleSatisfiesMVCC | heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --2.03%-- 0x4a8afe _bt_checkpage heapgetpage slot_getattr ExecMakeFunctionResultNoSets (nil) 0xcfa188 1.98% 48 postgres [vdso] [.] 0x7fffe8fff8f5 | --- 0x7fffe8fff8f5 __gettimeofday_internal ExecProcNode | |--60.04%-- ExecHashJoin | ExecProcNode | | | |--50.02%-- MultiExecHash | | ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | |--33.32%-- ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --16.66%-- ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --39.96%-- ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode 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 | |--77.80%-- ExecHashJoin | ExecProcNode | | | |--85.71%-- ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | 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.29%-- ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --22.20%-- ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff8fc __gettimeofday_internal ExecProcNode | |--60.01%-- ExecHashJoin | ExecProcNode | | | |--66.61%-- ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --33.39%-- MultiExecHash | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --39.99%-- ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff665 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode | |--79.96%-- ExecHashJoin | ExecProcNode | | | |--74.95%-- ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --25.05%-- ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --20.04%-- ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode | |--66.68%-- ExecHashJoin | ExecProcNode | | | |--50.03%-- ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | 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%-- ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --33.32%-- ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode 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 | |--50.03%-- ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | 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%-- ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff6ae 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode 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 ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff640 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff8f9 __gettimeofday_internal ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff8e1 __gettimeofday_internal ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff8d8 __gettimeofday_internal ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff648 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff8ee __gettimeofday_internal ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff604 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff60a 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff8b1 ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff6a5 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff8b0 ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode 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.95% 47 postgres postgres [.] HeapTupleSatisfiesMVCC | --- HeapTupleSatisfiesMVCC | |--78.78%-- heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | | | |--83.52%-- ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | 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.48%-- MultiExecHash | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--8.49%-- heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--6.37%-- heap_hot_search_buffer | index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --6.36%-- index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.90% 46 postgres postgres [.] InstrStopNode | --- InstrStopNode | |--91.31%-- ExecProcNode | | | |--73.82%-- ExecHashJoin | | ExecProcNode | | | | | |--77.40%-- ExecNestLoop | | | ExecProcNode | | | ExecHashJoin | | | ExecProcNode | | | 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.93%-- MultiExecHash | | | ExecHashJoin | | | ExecProcNode | | | ExecNestLoop | | | ExecProcNode | | | ExecHashJoin | | | ExecProcNode | | | ExecAgg | | | ExecProcNode | | | ExecSort | | | ExecProcNode | | | standard_ExecutorRun | | | ExplainOnePlan | | | ExplainOneQuery | | | ExplainQuery | | | standard_ProcessUtility | | | PortalRunUtility | | | FillPortalStore | | | PortalRun | | | exec_simple_query | | | PostgresMain | | | ServerLoop | | | PostmasterMain | | | main | | | __libc_start_main | | | | | --9.67%-- 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.18%-- ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | 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.52%-- ExecHashJoin | ExecProcNode | | | |--66.73%-- ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --33.27%-- 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.17%-- ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode 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.53% 37 postgres postgres [.] ExecHashJoin | --- ExecHashJoin ExecProcNode | |--75.65%-- ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | 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.24%-- MultiExecHash | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --8.11%-- 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.45% 35 postgres postgres [.] heap_hot_search_buffer | --- heap_hot_search_buffer index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.45% 35 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 | |--48.56%-- copy_user_generic_string | 0xffffffffa04bfedc | 0xffffffffa04c021c | 0xffffffffa0553f90 | 0xffffffffa05715f4 | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | |--17.15%-- 0x7a5772 | HeapTupleSatisfiesMVCC | heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | | | |--83.30%-- ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | 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%-- MultiExecHash | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--17.14%-- 0x49f6c7 | heap_page_prune_opt | index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--8.57%-- 0x4a8afe | _bt_checkpage | _bt_relandgetbuf | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--2.86%-- 0x4acac0 | _bt_steppage | _bt_next | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--2.86%-- 0x4acfc0 | _bt_moveright | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --2.85%-- 0x49d348 heap_hot_search_buffer index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.24% 30 postgres postgres [.] ExecProcNode | --- ExecProcNode | |--60.00%-- ExecHashJoin | ExecProcNode | | | |--88.87%-- ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | 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.57%-- MultiExecHash | | ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --5.56%-- ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--26.66%-- ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | 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.00%-- ExecProcNode | | | |--66.62%-- ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --33.38%-- MultiExecHash | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --3.34%-- MultiExecHash ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.24% 30 postgres postgres [.] slot_getattr | --- slot_getattr | |--60.01%-- ExecHashGetHashValue | ExecHashJoin | ExecProcNode | | | |--88.89%-- ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | 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.57%-- MultiExecHash | | ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --5.54%-- 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%-- ExecMakeFunctionResultNoSets | ExecQual | | | |--90.01%-- ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --9.99%-- ExecScanHashBucket | ExecHashJoin | ExecProcNode | 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.33%-- ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | 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.33%-- ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode 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% 28 postgres postgres [.] CHashInsert | --- CHashInsert BufTableInsert ReadBuffer_common ReadBufferExtended | |--75.01%-- index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--21.42%-- heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --3.57%-- _bt_relandgetbuf _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.12% 27 postgres postgres [.] heapgettup_pagemode | --- heapgettup_pagemode | |--92.60%-- heap_getnext | SeqNext | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --7.40%-- SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.95% 23 postgres postgres [.] heap_page_prune_opt | --- heap_page_prune_opt | |--47.85%-- heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | | | |--63.61%-- ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --36.39%-- MultiExecHash | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--39.11%-- index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --13.05%-- index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.91% 22 postgres postgres [.] ExecScan | --- ExecScan | |--90.94%-- ExecProcNode | | | |--60.13%-- ExecHashJoin | | ExecProcNode | | | | | |--91.11%-- ExecNestLoop | | | ExecProcNode | | | ExecHashJoin | | | ExecProcNode | | | 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.89%-- MultiExecHash | | ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --39.87%-- ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | 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.06%-- ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode 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.91% 22 postgres [kernel.kallsyms] [k] mem_cgroup_update_page_stat | --- mem_cgroup_update_page_stat __do_fault handle_pte_fault do_page_fault page_fault | |--50.02%-- copy_user_generic_string | 0xffffffffa04bfedc | 0xffffffffa04c021c | 0xffffffffa0553f90 | 0xffffffffa05715f4 | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | |--13.62%-- 0x4acfc0 | _bt_moveright | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--9.10%-- 0x7a5772 | HeapTupleSatisfiesMVCC | heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | | | |--50.01%-- MultiExecHash | | ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --49.99%-- ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | 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%-- 0x49d348 | heap_hot_search_buffer | index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--9.09%-- 0x4a8afe | _bt_checkpage | _bt_relandgetbuf | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --9.08%-- 0x4accae _bt_compare _bt_binsrch _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.91% 22 postgres postgres [.] StrategyGetBuffer | --- StrategyGetBuffer | |--95.45%-- ReadBuffer_common | ReadBufferExtended | | | |--76.18%-- index_fetch_heap | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | |--14.28%-- heapgetpage | | heapgettup_pagemode | | heap_getnext | | SeqNext | | ExecScan | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --9.54%-- _bt_relandgetbuf | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --4.55%-- ReadBufferExtended index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.87% 21 postgres postgres [.] LWLockAttemptLock | --- LWLockAttemptLock | |--95.23%-- LWLockAcquire | | | |--44.99%-- index_fetch_heap | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | |--35.01%-- _bt_relandgetbuf | | _bt_search | | _bt_first | | btgettuple | | FunctionCall2Coll | | index_getnext_tid | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | |--9.99%-- _bt_getbuf | | _bt_getroot | | _bt_search | | _bt_first | | btgettuple | | FunctionCall2Coll | | index_getnext_tid | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | |--5.00%-- heapgetpage | | heapgettup_pagemode | | heap_getnext | | SeqNext | | ExecScan | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --4.99%-- _bt_next | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --4.77%-- index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.83% 20 postgres postgres [.] ExecHashGetHashValue | --- ExecHashGetHashValue ExecHashJoin ExecProcNode | |--74.99%-- ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | 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%-- ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.83% 20 postgres postgres [.] _bt_checkkeys | --- _bt_checkkeys _bt_readpage _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.83% 20 postgres postgres [.] _bt_binsrch | --- _bt_binsrch | |--65.01%-- _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--29.98%-- _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --5.01%-- btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.83% 20 postgres postgres [.] LWLockRelease | --- LWLockRelease | |--35.01%-- index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--30.00%-- _bt_relandgetbuf | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--15.02%-- _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--9.99%-- UnlockReleaseBuffer | _bt_steppage | _bt_next | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --9.98%-- ReadBuffer_common ReadBufferExtended | |--50.02%-- heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.98%-- index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.79% 19 postgres postgres [.] MemoryContextReset | --- MemoryContextReset | |--31.57%-- ExecHashJoin | ExecProcNode | | | |--66.60%-- ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | 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%-- MultiExecHash | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--21.11%-- ExecProcNode | | | |--50.21%-- ExecHashJoin | | ExecProcNode | | MultiExecHash | | ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --49.79%-- ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | 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.03%-- ExecHashGetHashValue | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--15.75%-- ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--5.27%-- ExecReScan | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | 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.26%-- ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode 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.74% 18 postgres postgres [.] PinBuffer | --- PinBuffer ReadBuffer_common ReadBufferExtended | |--49.96%-- _bt_relandgetbuf | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--22.25%-- heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | | | |--75.05%-- MultiExecHash | | ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --24.95%-- ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--16.68%-- index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --11.12%-- _bt_getbuf _bt_getroot _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.62% 15 postgres postgres [.] GetPrivateRefCountEntry | --- GetPrivateRefCountEntry | |--46.66%-- PinBuffer | ReadBuffer_common | ReadBufferExtended | | | |--57.11%-- _bt_relandgetbuf | | _bt_search | | _bt_first | | btgettuple | | FunctionCall2Coll | | index_getnext_tid | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --42.89%-- _bt_getbuf | _bt_getroot | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--20.00%-- PinBuffer_Locked | ReadBuffer_common | ReadBufferExtended | | | |--66.73%-- index_fetch_heap | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --33.27%-- heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--13.34%-- UnpinBuffer | ReleaseAndReadBuffer | | | |--50.03%-- _bt_relandgetbuf | | _bt_search | | _bt_first | | btgettuple | | FunctionCall2Coll | | index_getnext_tid | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --49.97%-- index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--13.34%-- ReleaseBuffer | | | |--50.05%-- index_getnext_tid | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --49.95%-- _bt_steppage | _bt_next | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --6.66%-- IncrBufferRefCount ExecStoreTuple IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.58% 14 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 | |--78.55%-- copy_user_generic_string | 0xffffffffa04bfedc | 0xffffffffa04c021c | 0xffffffffa0553f90 | 0xffffffffa05715f4 | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | |--14.29%-- 0x4acfc0 | _bt_moveright | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --7.16%-- 0x49f6c7 heap_page_prune_opt index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.58% 14 postgres postgres [.] ExecEvalScalarVarFast | --- ExecEvalScalarVarFast | |--35.74%-- ExecMakeFunctionResultNoSets | | | |--60.00%-- ExecQual | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --40.00%-- ExecEvalAnd | ExecEvalOr | ExecQual | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--35.69%-- ExecQual | | | |--80.03%-- ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --19.97%-- ExecScanHashBucket | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--14.31%-- ExecHashJoin | ExecProcNode | | | |--50.02%-- MultiExecHash | | ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --49.98%-- ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --14.26%-- ExecHashGetHashValue ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.58% 14 postgres postgres [.] hash_any | --- hash_any | |--78.56%-- CHashSearch | BufTableLookup | ReadBuffer_common | ReadBufferExtended | | | |--54.58%-- _bt_relandgetbuf | | _bt_search | | _bt_first | | btgettuple | | FunctionCall2Coll | | index_getnext_tid | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | |--27.27%-- _bt_getbuf | | _bt_getroot | | _bt_search | | _bt_first | | btgettuple | | FunctionCall2Coll | | index_getnext_tid | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --18.15%-- index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--14.29%-- CHashInsert | BufTableInsert | ReadBuffer_common | ReadBufferExtended | | | |--50.07%-- index_fetch_heap | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --49.93%-- heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --7.16%-- BufTableInsert ReadBuffer_common ReadBufferExtended index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.58% 14 postgres postgres [.] _bt_first | --- _bt_first | |--92.85%-- btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --7.15%-- FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.54% 13 postgres postgres [.] ExecStoreMinimalTuple | --- ExecStoreMinimalTuple | |--69.22%-- ExecScanHashBucket | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --30.78%-- ExecHashJoin ExecProcNode | |--75.02%-- ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | 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%-- ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.54% 13 postgres postgres [.] ExecStoreTuple | --- ExecStoreTuple | |--69.21%-- SeqNext | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--15.40%-- IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --15.39%-- ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.50% 12 postgres postgres [.] CHashSearch | --- CHashSearch | |--91.67%-- BufTableLookup | ReadBuffer_common | ReadBufferExtended | | | |--36.38%-- _bt_relandgetbuf | | _bt_search | | _bt_first | | btgettuple | | FunctionCall2Coll | | index_getnext_tid | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | |--36.36%-- index_fetch_heap | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --27.27%-- _bt_getbuf | _bt_getroot | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --8.33%-- ReadBuffer_common ReadBufferExtended _bt_getbuf _bt_getroot _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode 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.50% 12 postgres postgres [.] ExecProject | --- ExecProject | |--50.00%-- ExecHashJoin | ExecProcNode | | | |--83.32%-- ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --16.68%-- ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--25.01%-- ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --24.99%-- ExecProcNode | |--66.73%-- ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --33.27%-- ExecHashJoin ExecProcNode 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.50% 12 postgres postgres [.] _bt_moveright | --- _bt_moveright _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.45% 11 postgres postgres [.] LockBuffer | --- LockBuffer | |--36.40%-- _bt_relandgetbuf | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--18.17%-- index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--9.10%-- _bt_steppage | _bt_next | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--9.09%-- _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--9.09%-- UnlockReleaseBuffer | _bt_steppage | _bt_next | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--9.08%-- _bt_next | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --9.08%-- _bt_getbuf _bt_getroot _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.45% 11 postgres postgres [.] ExecMakeFunctionResultNoSets | --- ExecMakeFunctionResultNoSets | |--72.74%-- ExecQual | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--9.10%-- ExecMakeFunctionResultNoSets | ExecProject | advance_aggregates | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--9.09%-- ExecEvalAnd | ExecEvalOr | ExecQual | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --9.07%-- ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.45% 11 postgres postgres [.] UnpinBuffer | --- UnpinBuffer | |--45.44%-- ReleaseAndReadBuffer | _bt_relandgetbuf | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--18.21%-- ExecClearTuple | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--9.11%-- _bt_relandgetbuf | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--9.09%-- ExecStoreTuple | SeqNext | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--9.08%-- _bt_next | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --9.08%-- _bt_steppage _bt_next btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.45% 11 postgres postgres [.] btint4cmp | --- btint4cmp | |--63.62%-- _bt_compare | _bt_binsrch | | | |--85.73%-- _bt_search | | _bt_first | | btgettuple | | FunctionCall2Coll | | index_getnext_tid | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --14.27%-- _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --36.38%-- FunctionCall2Coll _bt_compare _bt_binsrch | |--75.00%-- _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --25.00%-- _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.41% 1 postgres [kernel.kallsyms] [k] _raw_spin_lock_irqsave | --- _raw_spin_lock_irqsave | |--59.86%-- up | | | |--50.02%-- 0xffffffffa053ac7c | | 0xffffffffa051f34a | | 0xffffffffa0560b17 | | 0xffffffffa04aeb14 | | 0xffffffffa04c602f | | vfs_read | | sys_read | | system_call_fastpath | | 0x7fb873db55d0 | | __GI___read | | | |--33.28%-- 0xffffffffa0570c42 | | 0xffffffffa04c61ab | | vfs_read | | sys_read | | system_call_fastpath | | 0x7fb873db55d0 | | __GI___read | | | --16.70%-- 0xffffffffa0541942 | 0xffffffffa05718be | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | |--39.89%-- down | 0xffffffffa04a89cf | | | |--74.98%-- 0xffffffffa051f54e | | | | | |--66.58%-- 0xffffffffa053ac4a | | | 0xffffffffa051f34a | | | 0xffffffffa0560b17 | | | 0xffffffffa04aeb14 | | | 0xffffffffa04c602f | | | vfs_read | | | sys_read | | | system_call_fastpath | | | 0x7fb873db55d0 | | | __GI___read | | | | | --33.42%-- 0xffffffffa0541346 | | 0xffffffffa0560b7f | | 0xffffffffa04aeb14 | | 0xffffffffa04c602f | | vfs_read | | sys_read | | system_call_fastpath | | 0x7fb873db55d0 | | __GI___read | | | --25.02%-- 0xffffffffa054b712 | 0xffffffffa056f34a | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read --0.24%-- [...] 0.41% 10 postgres libc-2.11.3.so [.] __gettimeofday_internal | --- __gettimeofday_internal ExecProcNode | |--50.01%-- ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | 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%-- ExecHashJoin ExecProcNode | |--59.98%-- ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --40.02%-- ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode 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% 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 | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--30.01%-- index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--19.99%-- _bt_relandgetbuf | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --10.00%-- heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.39% 9 postgres postgres [.] ExecHashGetSkewBucket | --- ExecHashGetSkewBucket | |--89.48%-- ExecProcNode | | | |--82.05%-- ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --17.95%-- MultiExecHash | ExecHashJoin | ExecProcNode | 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.52%-- ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode 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% 9 postgres postgres [.] _bt_search | --- _bt_search | |--88.89%-- _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --11.11%-- btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.37% 9 postgres postgres [.] FunctionCall2Coll | --- FunctionCall2Coll | |--44.44%-- _bt_compare | _bt_binsrch | | | |--75.03%-- _bt_first | | btgettuple | | FunctionCall2Coll | | index_getnext_tid | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --24.97%-- _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--33.31%-- _bt_binsrch | | | |--66.73%-- _bt_first | | btgettuple | | FunctionCall2Coll | | index_getnext_tid | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --33.27%-- _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--11.13%-- index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --11.13%-- _bt_checkkeys _bt_readpage _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.37% 9 postgres postgres [.] InstrStartNode | --- InstrStartNode ExecProcNode | |--77.73%-- ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --22.27%-- ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode 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% 9 postgres [kernel.kallsyms] [k] _raw_spin_unlock_irqrestore | --- _raw_spin_unlock_irqrestore | |--55.57%-- 0xffffffffa04a89cf | | | |--79.99%-- 0xffffffffa051f54e | | | | | |--74.95%-- 0xffffffffa0541346 | | | | | | | |--66.64%-- 0xffffffffa0570c42 | | | | 0xffffffffa04c61ab | | | | vfs_read | | | | sys_read | | | | system_call_fastpath | | | | 0x7fb873db55d0 | | | | __GI___read | | | | | | | --33.36%-- 0xffffffffa0560b7f | | | 0xffffffffa04aeb14 | | | 0xffffffffa04c602f | | | vfs_read | | | sys_read | | | system_call_fastpath | | | 0x7fb873db55d0 | | | __GI___read | | | | | --25.05%-- 0xffffffffa054182c | | 0xffffffffa05718be | | 0xffffffffa04c61ab | | vfs_read | | sys_read | | system_call_fastpath | | 0x7fb873db55d0 | | __GI___read | | | --20.01%-- 0xffffffffa054b712 | 0xffffffffa056f34a | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | |--33.31%-- 0xffffffffa056f364 | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --11.12%-- 0xffffffffa053ac7c 0xffffffffa051f34a 0xffffffffa0560b17 0xffffffffa04aeb14 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.33% 7 postgres [kernel.kallsyms] [k] zap_pte_range | --- zap_pte_range unmap_page_range unmap_vmas exit_mmap mmput exit_mm do_exit do_group_exit sys_exit_group system_call_fastpath 0x7fb873d90a38 0.33% 8 postgres postgres [.] btgettuple | --- btgettuple | |--75.02%-- FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --24.98%-- index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.33% 8 postgres postgres [.] AllocSetAlloc | --- AllocSetAlloc _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.33% 8 postgres postgres [.] index_fetch_heap | --- index_fetch_heap | |--87.49%-- index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --12.51%-- IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.33% 8 postgres postgres [.] ExecQual | --- ExecQual | |--75.05%-- ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --24.95%-- ExecScanHashBucket ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.33% 8 postgres postgres [.] _bt_checkpage | --- _bt_checkpage | |--49.95%-- _bt_relandgetbuf | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--37.53%-- _bt_getbuf | _bt_getroot | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --12.52%-- _bt_getroot _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.29% 7 postgres postgres [.] heap_getnext | --- heap_getnext SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode | |--85.48%-- ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | 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.52%-- MultiExecHash ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.29% 7 postgres postgres [.] XidInMVCCSnapshot | --- XidInMVCCSnapshot | |--57.19%-- HeapTupleSatisfiesMVCC | | | |--75.02%-- heapgetpage | | heapgettup_pagemode | | heap_getnext | | SeqNext | | ExecScan | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --24.98%-- heap_hot_search_buffer | index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--28.57%-- heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --14.25%-- heap_hot_search_buffer index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.29% 7 postgres postgres [.] SeqNext | --- SeqNext | |--57.14%-- ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --42.86%-- ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.29% 7 postgres postgres [.] pgstat_init_function_usage | --- pgstat_init_function_usage | |--71.43%-- ExecMakeFunctionResultNoSets | | | |--80.04%-- ExecQual | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --19.96%-- ExecEvalAnd | ExecEvalOr | ExecQual | ExecHashJoin | ExecProcNode | 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.57%-- ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.27% 1 swapper [kernel.kallsyms] [k] lock_hrtimer_base | --- lock_hrtimer_base __hrtimer_start_range_ns tick_nohz_restart tick_nohz_restart_sched_tick cpu_idle 0.27% 1 postgres [kernel.kallsyms] [k] 0xffffffff8111de7a | --- zap_pte_range unmap_page_range unmap_vmas exit_mmap mmput exit_mm do_exit do_group_exit sys_exit_group system_call_fastpath 0x7fb873d90a38 0.25% 6 postgres postgres [.] FunctionCall1Coll | --- FunctionCall1Coll | |--83.32%-- ExecHashGetHashValue | ExecHashJoin | ExecProcNode | | | |--40.05%-- MultiExecHash | | ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | |--39.95%-- ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | 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%-- ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --16.68%-- ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode 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.25% 6 postgres postgres [.] index_getnext | --- index_getnext | |--83.32%-- IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --16.68%-- ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.25% 6 postgres libc-2.11.3.so [.] __GI_memcpy | --- __GI_memcpy | |--83.33%-- BufTableLookup | ReadBuffer_common | ReadBufferExtended | _bt_getbuf | _bt_getroot | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | 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%-- BufTableInsert ReadBuffer_common ReadBufferExtended index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.25% 6 postgres postgres [.] _bt_preprocess_array_keys | --- _bt_preprocess_array_keys | |--83.32%-- btrescan | FunctionCall5Coll | index_rescan | ExecReScanIndexScan | ExecReScan | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --16.68%-- FunctionCall5Coll index_rescan ExecReScanIndexScan ExecReScan ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode 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.25% 6 postgres postgres [.] heapgetpage | --- heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.25% 6 postgres postgres [.] _bt_next | --- _bt_next | |--50.00%-- btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --50.00%-- FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.25% 6 postgres postgres [.] _bt_getroot | --- _bt_getroot | |--83.31%-- _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --16.69%-- _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.25% 6 postgres postgres [.] ReleaseAndReadBuffer | --- ReleaseAndReadBuffer | |--66.62%-- index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --33.38%-- _bt_relandgetbuf _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.25% 6 postgres postgres [.] TerminateBufferIO | --- TerminateBufferIO | |--50.07%-- ReadBufferExtended | index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.93%-- ReadBuffer_common ReadBufferExtended | |--66.63%-- index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --33.37%-- heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.24% 54 swapper [kernel.kallsyms] [k] intel_idle | --- intel_idle cpuidle_idle_call cpu_idle | --100.00%-- start_kernel x86_64_start_kernel 0.24% 1 mmfsd [mmfs26] [k] 0xae390 | --- 0xffffffffa05be390 0xffffffffa05c05d0 0xffffffffa0605a42 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0x1bfffffffff 0.24% 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.21% 1 swapper [kernel.kallsyms] [k] __rb_erase_color | --- __rb_erase_color set_next_entity pick_next_task_fair __schedule cpu_idle 0.21% 5 postgres postgres [.] LWLockAcquire | --- LWLockAcquire | |--60.01%-- _bt_next | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--20.02%-- _bt_getbuf | _bt_getroot | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --19.97%-- index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.21% 5 postgres postgres [.] ExecEvalConst | --- ExecEvalConst | |--79.97%-- ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --20.03%-- ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.21% 5 postgres postgres [.] hash_uint32 | --- hash_uint32 | |--80.03%-- ExecHashGetHashValue | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --19.97%-- FunctionCall1Coll ExecHashGetHashValue ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.21% 5 postgres postgres [.] ExecHashGetBucketAndBatch | --- ExecHashGetBucketAndBatch | |--60.02%-- ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | 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%-- ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode 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% 5 postgres postgres [.] IndexNext | --- IndexNext | |--79.97%-- ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --20.03%-- ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode 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% 5 postgres postgres [.] CHashDelete | --- CHashDelete | |--80.00%-- BufTableDelete | ReadBuffer_common | ReadBufferExtended | | | |--49.92%-- index_fetch_heap | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | |--25.05%-- _bt_relandgetbuf | | _bt_search | | _bt_first | | btgettuple | | FunctionCall2Coll | | index_getnext_tid | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --25.03%-- heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --20.00%-- ReadBuffer_common ReadBufferExtended index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.21% 5 postgres postgres [.] pgstat_end_function_usage | --- pgstat_end_function_usage | |--60.03%-- ExecQual | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --39.97%-- ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.21% 5 postgres [kernel.kallsyms] [k] __memcpy | --- __memcpy 0xffffffffa04aeab2 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.21% 5 postgres postgres [.] _bt_readpage | --- _bt_readpage | |--80.05%-- _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --19.95%-- btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.19% 2 postgres [kernel.kallsyms] [k] handle_mm_fault | --- handle_mm_fault do_page_fault page_fault | |--78.29%-- 0x7840e1 | hash_search_with_hash_value | SetupLockInTable | LockAcquireExtended | LockRelationOid | relation_open | heap_open | CatalogCacheInitializeCache | SearchCatCache | GetSysCacheOid | get_role_oid | hba_getauthmethod | ClientAuthentication | InitPostgres | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --21.71%-- copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.18% 14 postgres postgres [.] SyncOneBuffer | --- SyncOneBuffer | |--99.88%-- BgBufferSync | BackgroundWriterMain | AuxiliaryProcessMain | StartChildProcess | reaper | __restore_rt | PostmasterMain | main | __libc_start_main --0.12%-- [...] 0.17% 9 fail2ban-server [unknown] [.] 0x7f4657cdd8b0 | --- 0x7f4657d8e36b 0x7f4658009680 | --- 0x7f4657cdc520 0x7f4658009680 | --- 0x7f4657d42e24 0x602010 0x602010 0x602010 0x602010 0x602010 | --- 0x7f4657cdca90 0x7f4658009680 | --- 0x7f465712439b 0x602010 0x602010 0x602010 | --- 0x7f4657cdd8b0 0.17% 4 postgres postgres [.] TransactionIdPrecedes | --- TransactionIdPrecedes | |--74.99%-- HeapTupleSatisfiesMVCC | | | |--66.69%-- heap_hot_search_buffer | | index_fetch_heap | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --33.31%-- heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --25.01%-- XidInMVCCSnapshot HeapTupleSatisfiesMVCC heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.17% 4 postgres [kernel.kallsyms] [k] handle_pte_fault | --- handle_pte_fault do_page_fault page_fault | |--25.02%-- 0x49d348 | heap_hot_search_buffer | index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--25.01%-- 0x4accae | _bt_compare | _bt_binsrch | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--25.00%-- copy_user_generic_string | 0xffffffffa04bfedc | 0xffffffffa04c021c | 0xffffffffa0553f90 | 0xffffffffa05715f4 | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --24.97%-- 0x4acfc0 _bt_moveright _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.17% 4 postgres [kernel.kallsyms] [k] do_page_fault | --- do_page_fault page_fault | |--25.03%-- 0x4a8afe | _bt_checkpage | _bt_relandgetbuf | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--25.02%-- 0x49f6c7 | heap_page_prune_opt | index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--24.98%-- copy_user_generic_string | 0xffffffffa04bfedc | 0xffffffffa04c021c | 0xffffffffa0553f90 | 0xffffffffa05715f4 | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --24.97%-- 0x7a5888 HeapTupleSatisfiesMVCC heap_hot_search_buffer index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.17% 4 postgres postgres [.] DataChecksumsEnabled | --- DataChecksumsEnabled | |--75.02%-- ReadBuffer_common | ReadBufferExtended | index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --24.98%-- PageIsVerified ReadBuffer_common ReadBufferExtended index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.17% 4 postgres postgres [.] ReadBufferExtended | --- ReadBufferExtended | |--25.01%-- index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--25.01%-- _bt_relandgetbuf | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--25.01%-- _bt_getbuf | _bt_getroot | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --24.97%-- heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.17% 4 postgres postgres [.] pfree | --- pfree | |--75.01%-- _bt_freestack | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --24.99%-- ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode 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.17% 4 postgres postgres [.] ExecClearTuple | --- ExecClearTuple | |--50.06%-- ExecProject | | | |--50.02%-- ExecHashJoin | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --49.98%-- ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | 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%-- ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode 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.17% 4 postgres postgres [.] FileRead | --- FileRead mdread ReadBuffer_common ReadBufferExtended index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.17% 4 postgres [kernel.kallsyms] [k] fsnotify | --- fsnotify | |--50.03%-- vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | |--25.00%-- 0x246 | __GI___read | --24.97%-- rw_verify_area vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.17% 4 postgres postgres [.] int4eq | --- int4eq | |--74.95%-- ExecQual | ExecScanHashBucket | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --25.05%-- _bt_checkkeys _bt_readpage _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.17% 4 postgres postgres [.] IsCatalogRelation | --- IsCatalogRelation index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.17% 4 postgres [kernel.kallsyms] [k] unlock_page | --- unlock_page __do_fault handle_pte_fault do_page_fault page_fault | |--25.02%-- copy_user_generic_string | 0xffffffffa04bfedc | 0xffffffffa04c021c | 0xffffffffa0553f90 | 0xffffffffa05715f4 | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | |--25.01%-- 0x4accae | _bt_compare | _bt_binsrch | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--24.98%-- 0x49d348 | heap_hot_search_buffer | index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --24.98%-- 0x4acfc0 _bt_moveright _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.17% 4 postgres [kernel.kallsyms] [k] shmem_fault | --- shmem_fault __do_fault handle_pte_fault do_page_fault page_fault | |--25.04%-- 0x49d348 | heap_hot_search_buffer | index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--25.02%-- 0x49f6c7 | heap_page_prune_opt | index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--24.98%-- copy_user_generic_string | 0xffffffffa04bfedc | 0xffffffffa04c021c | 0xffffffffa0553f90 | 0xffffffffa05715f4 | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --24.95%-- 0x4accae _bt_compare _bt_binsrch _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.17% 4 postgres [kernel.kallsyms] [k] __do_fault | --- __do_fault | |--75.04%-- handle_pte_fault | do_page_fault | page_fault | | | |--33.39%-- 0x49f6c7 | | heap_page_prune_opt | | index_fetch_heap | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | |--33.32%-- copy_user_generic_string | | 0xffffffffa04bfedc | | 0xffffffffa04c021c | | 0xffffffffa0553f90 | | 0xffffffffa05715f4 | | 0xffffffffa04c61ab | | vfs_read | | sys_read | | system_call_fastpath | | 0x7fb873db55d0 | | __GI___read | | | --33.29%-- 0x49d348 | heap_hot_search_buffer | index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --24.96%-- 0x800 __GI___read 0.17% 4 postgres postgres [.] BufTableLookup | --- BufTableLookup ReadBuffer_common ReadBufferExtended | |--74.98%-- index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --25.02%-- _bt_relandgetbuf _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.17% 4 postgres postgres [.] CheckForSerializableConflictOut | --- CheckForSerializableConflictOut | |--74.99%-- heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --25.01%-- heap_hot_search_buffer index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.16% 1 kworker/7:1 [kernel.kallsyms] [k] drain_array | --- drain_array cache_reap process_one_work worker_thread kthread kernel_thread_helper 0.15% 3 postgres [kernel.kallsyms] [k] free_pages_and_swap_cache | --- free_pages_and_swap_cache tlb_flush_mmu zap_pte_range unmap_page_range unmap_vmas exit_mmap mmput exit_mm do_exit do_group_exit sys_exit_group system_call_fastpath 0x7fb873d90a38 0.12% 3 postgres postgres [.] _bt_preprocess_keys | --- _bt_preprocess_keys _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.12% 3 postgres postgres [.] ExecSeqScan | --- ExecSeqScan | |--66.63%-- ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | 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%-- ExecProcNode ExecHashJoin ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.12% 3 postgres libc-2.11.3.so [.] __memmove_ssse3 | --- __memmove_ssse3 FunctionCall5Coll index_rescan ExecReScanIndexScan ExecReScan ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode 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.12% 3 postgres postgres [.] index_getnext_tid | --- index_getnext_tid | |--66.67%-- index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --33.33%-- IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.12% 3 postgres postgres [.] _bt_steppage | --- _bt_steppage _bt_next btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.12% 3 postgres [kernel.kallsyms] [k] _raw_spin_lock | --- _raw_spin_lock __do_fault handle_pte_fault do_page_fault page_fault | |--66.67%-- copy_user_generic_string | 0xffffffffa04bfedc | 0xffffffffa04c021c | 0xffffffffa0553f90 | 0xffffffffa05715f4 | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --33.33%-- 0x49f6c7 heap_page_prune_opt index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.12% 3 postgres [kernel.kallsyms] [k] shmem_getpage_gfp | --- shmem_getpage_gfp | |--66.73%-- shmem_fault | __do_fault | handle_pte_fault | do_page_fault | page_fault | | | |--50.01%-- 0x4accae | | _bt_compare | | _bt_binsrch | | _bt_first | | btgettuple | | FunctionCall2Coll | | index_getnext_tid | | index_getnext | | IndexNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --49.99%-- copy_user_generic_string | 0xffffffffa04bfedc | 0xffffffffa04c021c | 0xffffffffa0553f90 | 0xffffffffa05715f4 | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --33.27%-- 0x1 _bt_compare _bt_binsrch _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.12% 3 postgres postgres [.] gettimeofday@plt | --- gettimeofday@plt ExecProcNode | |--66.66%-- ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --33.34%-- ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode 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.12% 3 postgres postgres [.] index_rescan | --- index_rescan ExecReScanIndexScan ExecReScan ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode 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.12% 3 postgres [kernel.kallsyms] [k] system_call | --- system_call | |--66.61%-- __GI___read | --33.39%-- _bt_compare _bt_binsrch 0.12% 3 postgres postgres [.] ScanKeyEntryInitializeWithInfo | --- ScanKeyEntryInitializeWithInfo btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.12% 3 postgres [kernel.kallsyms] [k] vfs_read | --- vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.12% 3 postgres [kernel.kallsyms] [k] cap_capable | --- cap_capable apparmor_capable ns_capable 0xffffffffa04aeaeb 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.12% 3 postgres [kernel.kallsyms] [k] fsnotify_access | --- fsnotify_access vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.12% 3 postgres postgres [.] date_ge | --- date_ge ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.12% 3 postgres postgres [.] _mdfd_getseg | --- _mdfd_getseg mdread ReadBuffer_common ReadBufferExtended index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.09% 1 postgres [kernel.kallsyms] [k] __set_page_dirty_no_writeback | --- __set_page_dirty_no_writeback | |--55.43%-- 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 | --44.57%-- __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.08% 2 postgres postgres [.] ExecEvalAnd | --- ExecEvalAnd ExecEvalOr ExecQual ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.08% 2 postgres postgres [.] InstrEndLoop | --- InstrEndLoop ExecReScan ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.08% 2 postgres postgres [.] _bt_getbuf | --- _bt_getbuf _bt_getroot _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.08% 2 postgres [kernel.kallsyms] [k] mem_cgroup_count_vm_event | --- mem_cgroup_count_vm_event handle_mm_fault do_page_fault page_fault | |--50.05%-- 0x49f6c7 | heap_page_prune_opt | heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.95%-- copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.08% 2 postgres libc-2.11.3.so [.] __GI___read | --- __GI___read mdread ReadBuffer_common ReadBufferExtended | |--50.03%-- index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.97%-- heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.08% 2 postgres postgres [.] FunctionCall5Coll | --- FunctionCall5Coll index_rescan ExecReScanIndexScan ExecReScan ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.08% 2 postgres postgres [.] mdopen | --- mdopen mdread ReadBuffer_common ReadBufferExtended index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.08% 2 postgres [kernel.kallsyms] [k] rw_verify_area | --- rw_verify_area vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.08% 2 postgres postgres [.] ResourceOwnerForgetBuffer | --- ResourceOwnerForgetBuffer | |--50.00%-- UnpinBuffer | ReleaseAndReadBuffer | _bt_relandgetbuf | _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --50.00%-- ReleaseBuffer ExecStoreTuple SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.08% 2 postgres postgres [.] BufferGetBlockNumber | --- BufferGetBlockNumber heap_hot_search_buffer index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.08% 2 postgres postgres [.] FileSeek | --- FileSeek mdread ReadBuffer_common ReadBufferExtended | |--50.06%-- heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.94%-- index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.08% 2 postgres postgres [.] bcTruelen | --- bcTruelen | |--50.02%-- ExecMakeFunctionResultNoSets | ExecEvalAnd | ExecEvalOr | ExecQual | ExecHashJoin | ExecProcNode | 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%-- FunctionCall2Coll 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.08% 2 postgres [kernel.kallsyms] [k] page_add_file_rmap | --- page_add_file_rmap __do_fault handle_pte_fault do_page_fault page_fault 0x4acfc0 _bt_moveright _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.08% 2 postgres postgres [.] AllocSetFree | --- AllocSetFree | |--50.06%-- _bt_freestack | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.94%-- _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.08% 2 postgres postgres [.] PageIsVerified | --- PageIsVerified | |--50.06%-- ReadBufferExtended | index_fetch_heap | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.94%-- ReadBuffer_common ReadBufferExtended index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.08% 2 postgres postgres [.] ReadBuffer | --- ReadBuffer | |--50.03%-- _bt_search | _bt_first | btgettuple | FunctionCall2Coll | index_getnext_tid | index_getnext | IndexNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.97%-- _bt_getroot _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.08% 2 postgres postgres [.] bms_add_member | --- bms_add_member ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.08% 2 postgres [kernel.kallsyms] [k] down_read_trylock | --- down_read_trylock do_page_fault page_fault copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.08% 2 postgres [kernel.kallsyms] [k] getnstimeofday | --- getnstimeofday 0xffffffffa04a8d10 0xffffffffa0554088 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.08% 2 postgres postgres [.] CHashAddToGarbage | --- CHashAddToGarbage CHashDelete BufTableDelete ReadBuffer_common ReadBufferExtended index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.08% 2 postgres [kernel.kallsyms] [k] current_kernel_time | --- current_kernel_time current_fs_time file_update_time __do_fault handle_pte_fault do_page_fault page_fault copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.08% 2 postgres postgres [.] ExecStoreVirtualTuple | --- ExecStoreVirtualTuple ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.08% 2 postgres [kernel.kallsyms] [k] fget_light | --- fget_light sys_lseek system_call_fastpath 0x7fb873dc30d0 __lseek64 0.08% 2 postgres postgres [.] timestamp_part | --- timestamp_part | |--50.02%-- ExecMakeFunctionResultNoSets | ExecProject | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.98%-- ExecProject ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.08% 2 postgres postgres [.] ExecIndexScan | --- ExecIndexScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.08% 2 postgres postgres [.] ExecNestLoop | --- ExecNestLoop | |--50.01%-- ExecHashJoin | ExecProcNode | 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%-- ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.08% 2 postgres [kernel.kallsyms] [k] system_call_after_swapgs | --- system_call_after_swapgs | |--50.07%-- _bt_compare | _bt_binsrch | --49.93%-- 0x7fb873db55d0 __GI___read 0.08% 2 postgres postgres [.] ExecReScan | --- ExecReScan | |--50.01%-- ExecProcNode | ExecHashJoin | ExecProcNode | 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%-- ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.08% 2 postgres postgres [.] PredicateLockPage | --- PredicateLockPage btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.08% 2 postgres postgres [.] fmgr_info_copy | --- fmgr_info_copy btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.04% 1 postgres [kernel.kallsyms] [k] __tlb_remove_page | --- __tlb_remove_page zap_pte_range unmap_page_range unmap_vmas exit_mmap mmput exit_mm do_exit do_group_exit sys_exit_group system_call_fastpath 0x7fb873d90a38 0.04% 1 postgres [kernel.kallsyms] [k] mark_page_accessed | --- mark_page_accessed zap_pte_range unmap_page_range unmap_vmas exit_mmap mmput exit_mm do_exit do_group_exit sys_exit_group system_call_fastpath 0x7fb873d90a38 0.04% 1 postgres postgres [.] ExecHashTableInsert | --- ExecHashTableInsert MultiExecHash ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.04% 1 postgres postgres [.] slot_getsomeattrs | --- slot_getsomeattrs ExecProject ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode 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.04% 1 postgres [kernel.kallsyms] [k] clear_page_c | --- clear_page_c prep_new_page get_page_from_freelist __alloc_pages_nodemask alloc_pages_vma do_anonymous_page do_page_fault page_fault 0x7fb873d6c771 __GI_memcpy MultiExecHash ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.04% 1 postgres [kernel.kallsyms] [k] security_capable | --- security_capable ns_capable 0xffffffffa04aeafb 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.04% 1 postgres postgres [.] hashfloat8 | --- hashfloat8 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.04% 1 postgres postgres [.] ExecEvalParamExec | --- ExecEvalParamExec ExecIndexEvalRuntimeKeys ExecReScanIndexScan ExecReScan ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode 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.04% 1 postgres postgres [.] hash_search_with_hash_value | --- 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.04% 1 postgres postgres [.] hashint4 | --- hashint4 ExecHashGetHashValue ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.04% 1 postgres [kernel.kallsyms] [k] down | --- down 0xffffffffa04a89cf 0xffffffffa051f54e 0xffffffffa0541346 0xffffffffa0560b7f 0xffffffffa04aeb14 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.04% 1 postgres [kernel.kallsyms] [k] retint_restore_args | --- retint_restore_args copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.04% 1 postgres postgres [.] ShutdownExprContext | --- ShutdownExprContext ExecReScan ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode 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.04% 1 postgres postgres [.] ExecEvalOr | --- ExecEvalOr ExecQual ExecHashJoin ExecProcNode 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.04% 1 postgres [kernel.kallsyms] [k] file_update_time | --- file_update_time __do_fault handle_pte_fault do_page_fault page_fault copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.04% 1 postgres [kernel.kallsyms] [k] calc_global_load | --- calc_global_load tick_do_update_jiffies64 tick_sched_timer __run_hrtimer hrtimer_interrupt smp_apic_timer_interrupt apic_timer_interrupt 0x783363 CHashSearch BufTableLookup ReadBuffer_common ReadBufferExtended _bt_getbuf _bt_getroot _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode 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.04% 1 postgres postgres [.] isTempToastNamespace | --- isTempToastNamespace IsCatalogClass heap_page_prune_opt index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.04% 1 postgres [kernel.kallsyms] [k] apparmor_capable | --- apparmor_capable 0xffffffffa04aeaeb 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.04% 1 postgres [kernel.kallsyms] [k] policy_zonelist | --- policy_zonelist alloc_pages_current pte_alloc_one __pte_alloc handle_mm_fault do_page_fault page_fault 0x49f6c7 heap_page_prune_opt index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.04% 1 postgres postgres [.] ReScanExprContext | --- ReScanExprContext ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode 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.04% 1 postgres [kernel.kallsyms] [k] clockevents_program_event | --- clockevents_program_event tick_dev_program_event hrtimer_interrupt smp_apic_timer_interrupt apic_timer_interrupt 0x674c53 PinBuffer ReadBuffer_common ReadBufferExtended _bt_relandgetbuf _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.04% 1 postgres postgres [.] _bt_mark_scankey_required | --- _bt_mark_scankey_required _bt_preprocess_keys _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.04% 1 postgres postgres [.] _bt_freestack | --- _bt_freestack _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.04% 1 postgres postgres [.] ReleaseBuffer | --- ReleaseBuffer _bt_steppage _bt_next btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.04% 1 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.04% 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.04% 1 postgres [kernel.kallsyms] [k] restore_args | --- restore_args copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.04% 1 postgres postgres [.] LookupTupleHashEntry | --- 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.04% 1 postgres postgres [.] ExecScanReScan | --- ExecScanReScan ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode 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.04% 1 postgres [kernel.kallsyms] [k] apparmor_file_permission | --- apparmor_file_permission security_file_permission rw_verify_area vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.04% 1 postgres postgres [.] check_stack_depth | --- check_stack_depth ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.04% 1 postgres postgres [.] date_le | --- date_le ExecQual ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.04% 1 postgres postgres [.] bms_make_singleton | --- bms_make_singleton ExecProcNode ExecHashJoin ExecProcNode 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.04% 1 postgres postgres [.] palloc0 | --- palloc0 ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode 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.04% 1 postgres [kernel.kallsyms] [k] update_vsyscall | --- update_vsyscall do_timer tick_do_update_jiffies64 tick_sched_timer __run_hrtimer hrtimer_interrupt smp_apic_timer_interrupt apic_timer_interrupt 0x5bbe7e ExecScanHashBucket ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.04% 1 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.04% 1 postgres [kernel.kallsyms] [k] update_curr | --- update_curr entity_tick task_tick_fair scheduler_tick update_process_times tick_sched_timer __run_hrtimer hrtimer_interrupt smp_apic_timer_interrupt apic_timer_interrupt copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.04% 1 postgres postgres [.] _bt_relandgetbuf | --- _bt_relandgetbuf _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode 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.04% 1 postgres postgres [.] StartBufferIO | --- StartBufferIO ReadBuffer_common ReadBufferExtended index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.04% 1 postgres [kernel.kallsyms] [k] __task_pid_nr_ns | --- __task_pid_nr_ns 0xffffffffa04bfec2 0xffffffffa04c021c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.04% 1 postgres [kernel.kallsyms] [k] insert_work | --- insert_work __queue_work call_timer_fn run_timer_softirq __do_softirq call_softirq do_softirq irq_exit smp_apic_timer_interrupt apic_timer_interrupt 0x5b16b7 ExecEvalScalarVarFast ExecMakeFunctionResultNoSets ExecEvalAnd ExecEvalOr ExecQual ExecHashJoin ExecProcNode 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.04% 1 postgres postgres [.] IncrBufferRefCount | --- IncrBufferRefCount IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.04% 1 postgres postgres [.] BufTableInsert | --- BufTableInsert ReadBuffer_common ReadBufferExtended index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.04% 1 postgres [kernel.kallsyms] [k] error_exit | --- error_exit 0x7a5772 HeapTupleSatisfiesMVCC heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.04% 1 postgres postgres [.] index_getprocinfo | --- index_getprocinfo _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.04% 1 postgres [kernel.kallsyms] [k] find_vma | --- find_vma 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.04% 1 postgres libc-2.11.3.so [.] __lseek64 | --- __lseek64 mdread ReadBuffer_common ReadBufferExtended index_fetch_heap index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.04% 1 postgres postgres [.] _bt_relbuf | --- _bt_relbuf _bt_next btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.04% 1 postgres [kernel.kallsyms] [k] current_fs_time | --- current_fs_time file_update_time __do_fault handle_pte_fault do_page_fault page_fault copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.04% 1 postgres [kernel.kallsyms] [k] sys_lseek | --- sys_lseek system_call_fastpath 0x7fb873dc30d0 __lseek64 0.04% 1 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 0x4a8afe _bt_checkpage _bt_relandgetbuf _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.04% 1 postgres [kernel.kallsyms] [k] vfs_llseek | --- vfs_llseek sys_lseek system_call_fastpath 0x7fb873dc30d0 __lseek64 0.04% 1 postgres postgres [.] PinBuffer_Locked | --- PinBuffer_Locked ReadBuffer_common ReadBufferExtended heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.04% 1 postgres postgres [.] palloc | --- palloc _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext IndexNext ExecScan ExecProcNode ExecNestLoop ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.03% 1 swapper [kernel.kallsyms] [k] irq_enter | --- irq_enter smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.03% 2 kworker/2:1 [kernel.kallsyms] [k] free_block | --- free_block drain_array cache_reap process_one_work worker_thread kthread kernel_thread_helper 0.02% 1 swapper [kernel.kallsyms] [k] leave_mm | --- leave_mm intel_idle cpuidle_idle_call cpu_idle 0.02% 4 swapper [kernel.kallsyms] [k] getnstimeofday | --- getnstimeofday | |--96.29%-- 0x33d35295 | --3.71%-- ktime_get_real intel_idle cpuidle_idle_call cpu_idle 0.02% 1 dbus-daemon [unknown] [.] 0x7f7c02398030 | --- 0x7f7c02398030 (nil) 0.02% 1 irqbalance [kernel.kallsyms] [k] tlb_gather_mmu | --- tlb_gather_mmu unmap_vmas unmap_region do_munmap sys_munmap system_call_fastpath 0x7f398a1a0c87 0x7f398a1a0c87 (nil) 0.01% 1 irqbalance [kernel.kallsyms] [k] mntget | --- mntget path_get unlazy_walk do_lookup link_path_walk path_openat do_filp_open do_sys_open system_call_fastpath 0x7f398a1961e0 0x7f398a1961e0 0xffffd374ffffd374 0.01% 1 find [kernel.kallsyms] [k] filesystems_proc_show | --- filesystems_proc_show seq_read proc_reg_read vfs_read sys_read system_call_fastpath 0x7fea574fa5d0 __GI___read 0x7fff5339ff57 0x414d0068732f6e69 0.01% 8 mmfsd [unknown] [.] 0x5bc10e | --- 0x5bc10e 0x1043e2 | --- 0x7206b6 | --- 0x5800d9 | --- 0x910685 (nil) (nil) (nil) | --- 0x917360 0x7ffb4d278e60 | --- 0x94a5fd 0x7ffb789a5710 | --- 0x10e4f77 | --- 0x7ffb7cb536a3 0.01% 1 hal-find-by-cap ld-2.11.3.so [.] do_lookup_x | --- do_lookup_x 0.01% 1 run-crons libc-2.11.3.so [.] __GI_mbrtowc | --- __GI_mbrtowc 0x656874000a222929 0.01% 1 sh bash [.] strvec_resize | --- strvec_resize 0.01% 1 on_ac_power [kernel.kallsyms] [k] page_fault | --- page_fault | |--64.91%-- 0x7f14cc070660 | strcmp | --35.09%-- 0x43e580 0x43e580 0.01% 1 date [kernel.kallsyms] [k] page_fault | --- page_fault 0x7feb83a9eb6a _dl_load_cache_lookup 0.00% 1 postgres [kernel.kallsyms] [k] free_hot_cold_page | --- free_hot_cold_page __pagevec_free release_pages free_pages_and_swap_cache tlb_flush_mmu tlb_finish_mmu exit_mmap mmput exit_mm do_exit do_group_exit sys_exit_group system_call_fastpath 0x7fb873d90a38 0.00% 1 run-crons [kernel.kallsyms] [k] page_fault | --- page_fault 0x41d000 0x41d000 0.00% 2 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 haveged [kernel.kallsyms] [k] poll_schedule_timeout | --- poll_schedule_timeout do_select core_sys_select sys_select system_call_fastpath 0x7fbf388b4373 0x7fbf388b4373 0.00% 1 fail2ban-server [kernel.kallsyms] [k] cp_new_stat | --- cp_new_stat sys_newstat system_call_fastpath 0x7f4657157765 0x7f4657157765 0x602010 0x602010 0.00% 1 psql libpq.so.5.8 [.] pg_encoding_dsplen | --- pg_encoding_dsplen pg_wcsformat print_aligned_text printTable printQuery SendQuery MainLoop process_file main __libc_start_main 0.00% 1 swapper [kernel.kallsyms] [k] do_softirq | --- do_softirq 0.00% 1 swapper [nf_conntrack] [k] tcp_in_window | --- tcp_in_window tcp_packet nf_conntrack_in nf_iterate nf_hook_slow ip_rcv __netif_receive_skb netif_receive_skb napi_skb_finish ixgbe_clean_rx_irq ixgbe_poll net_rx_action __do_softirq call_softirq do_softirq irq_exit do_IRQ ret_from_intr intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] delayed_work_timer_fn | --- delayed_work_timer_fn 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 run-crons libc-2.11.3.so [.] __GI__dl_addr | --- __GI__dl_addr 0x4ce02464894cd824 0.00% 1 rm [kernel.kallsyms] [k] page_fault | --- page_fault 0x7f4a4ba5a3f5 do_lookup_x 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% 2 kworker/2:1 [kernel.kallsyms] [k] delay_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% 2 swapper [kernel.kallsyms] [k] select_nohz_load_balancer | --- select_nohz_load_balancer tick_nohz_restart_sched_tick cpu_idle | --100.00%-- start_kernel x86_64_start_kernel 0.00% 1 perf [kernel.kallsyms] [k] fget_light | --- fget_light sys_write system_call_fastpath 0x7ff026361730 __write_nocancel 0.00% 1 perf [kernel.kallsyms] [k] current_kernel_time | --- current_kernel_time current_fs_time file_update_time __generic_file_aio_write generic_file_aio_write do_sync_write vfs_write sys_write system_call_fastpath 0x7ff026361730 __write_nocancel 0.00% 1 hal-find-by-cap ld-2.11.3.so [.] _dl_relocate_object | --- _dl_relocate_object dl_main _dl_sysdep_start 0x40 0.00% 1 nscd [kernel.kallsyms] [k] show_map_vma | --- show_map_vma show_map seq_read vfs_read sys_read system_call_fastpath 0x7f532a38d5d0 0x7f532a38d5d0 0.00% 1 cron [unknown] [.] 0x7f6779240e21 | --- 0x7f6779240e21 0x7f6779cf14aa 0.00% 1 irqbalance [kernel.kallsyms] [k] format_decode | --- format_decode vsnprintf seq_printf show_stat seq_read proc_reg_read vfs_read sys_read system_call_fastpath 0x7f398a1965d0 0x7f398a1965d0 0x7f398ad0a730 0.00% 1 mmfsd [kernel.kallsyms] [k] sys_epoll_wait | --- sys_epoll_wait system_call_fastpath 0x7ffb7c127723 0x7ffb7c127723 0x800000000 0.00% 1 irqbalance [kernel.kallsyms] [k] proc_lookup_de | --- proc_lookup_de d_alloc_and_lookup do_lookup do_last path_openat do_filp_open do_sys_open system_call_fastpath 0x7f398a1961e0 0x7f398a1961e0 0xffffd374ffffd374 0.00% 2 irqbalance [unknown] [.] 0x7f398a100189 | --- 0x7f398a100189 | --- 0x7f398aae6e62 0x841f0f 0.00% 3 swapper [kernel.kallsyms] [k] cpuidle_idle_call | --- cpuidle_idle_call cpu_idle 0.00% 3 swapper [kernel.kallsyms] [k] rb_erase | --- rb_erase timerqueue_del __remove_hrtimer | |--90.96%-- hrtimer_try_to_cancel | hrtimer_cancel | tick_nohz_restart | tick_nohz_restart_sched_tick | cpu_idle | --9.04%-- __run_hrtimer hrtimer_interrupt smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 kworker/0:0 [kernel.kallsyms] [k] find_next_bit | --- find_next_bit dbs_check_cpu do_dbs_timer process_one_work worker_thread kthread kernel_thread_helper 0.00% 1 mmfsd [ip_tables] [k] ipt_do_table | --- ipt_do_table nf_iterate nf_hook_slow ip_output ip_queue_xmit tcp_transmit_skb tcp_write_xmit __tcp_push_pending_frames tcp_sendmsg sock_sendmsg ___sys_sendmsg __sys_sendmsg system_call_fastpath 0x7ffb7cb55dfd 0x7ffb7cb55dfd 0.00% 1 swapper [kernel.kallsyms] [k] __cache_free | --- __cache_free kfree __kfree_skb arp_process __netif_receive_skb netif_receive_skb napi_skb_finish ixgbe_clean_rx_irq ixgbe_poll net_rx_action __do_softirq call_softirq do_softirq irq_exit do_IRQ ret_from_intr intel_idle cpuidle_idle_call cpu_idle start_kernel x86_64_start_kernel 0.00% 1 swapper [kernel.kallsyms] [k] __perf_event_disable | --- __perf_event_disable remote_function generic_smp_call_function_single_interrupt smp_call_function_single_interrupt call_function_single_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 nfsWatchKproc [mmfs26] [k] 0x19983 | --- 0xffffffffa0529983 0xffffffffa04ad990 kernel_thread_helper 0.00% 2 swapper [kernel.kallsyms] [k] read_tsc | --- read_tsc getnstimeofday ktime_get_real intel_idle cpuidle_idle_call cpu_idle 0.00% 2 swapper [kernel.kallsyms] [k] tick_nohz_stop_sched_tick | --- tick_nohz_stop_sched_tick | |--84.99%-- cpu_idle | start_kernel | x86_64_start_kernel | --15.01%-- irq_exit smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 sh ld-2.11.3.so [.] do_lookup_x | --- do_lookup_x 0.00% 1 sh [kernel.kallsyms] [k] page_fault | --- page_fault 0x7f1807887400 _dl_sysdep_read_whole_file dl_main _dl_sysdep_start 0x40 0.00% 1 run-crons [kernel.kallsyms] [k] reuse_swap_page | --- reuse_swap_page do_wp_page handle_pte_fault do_page_fault page_fault 0x7f18071627ca __libc_fork make_child 0x69c3c0 0.00% 1 mmfsd [kernel.kallsyms] [k] find_next_bit | --- find_next_bit cpumask_next_and find_busiest_group load_balance idle_balance thread_return 0xffffffffa04a8b7d 0xffffffffa05bf0f1 0xffffffffa05c0478 0xffffffffa0605afe 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0x7ffb741674f0 0.00% 1 run-crons [kernel.kallsyms] [k] _copy_to_user | --- _copy_to_user sys_rt_sigaction system_call_fastpath 0x7f4a4b2c5cf4 __GI___libc_sigaction 0.00% 1 kworker/0:0 [kernel.kallsyms] [k] free_block | --- free_block drain_array cache_reap process_one_work worker_thread kthread kernel_thread_helper 0.00% 1 kworker/0:0 [mperf] [k] cpufreq_get_measured_perf | --- cpufreq_get_measured_perf __cpufreq_driver_getavg dbs_check_cpu do_dbs_timer process_one_work worker_thread kthread kernel_thread_helper 0.00% 1 kworker/3:1 [kernel.kallsyms] [k] update_curr | --- update_curr dequeue_entity dequeue_task_fair __schedule worker_thread kthread kernel_thread_helper 0.00% 1 sh [kernel.kallsyms] [k] page_remove_rmap | --- page_remove_rmap zap_pte_range unmap_page_range unmap_vmas exit_mmap mmput exit_mm do_exit do_group_exit sys_exit_group system_call_fastpath 0x7f1807162a38 0.00% 1 rm ld-2.11.3.so [.] __libc_close | --- __libc_close _dl_map_object 0x6873756c66660036 0.00% 1 swapper [kernel.kallsyms] [k] ktime_add_safe | --- ktime_add_safe hrtimer_forward tick_nohz_restart tick_nohz_restart_sched_tick cpu_idle 0.00% 2 swapper [kernel.kallsyms] [k] timerqueue_del | --- timerqueue_del __remove_hrtimer hrtimer_try_to_cancel hrtimer_cancel tick_nohz_restart tick_nohz_restart_sched_tick cpu_idle 0.00% 1 auditd [kernel.kallsyms] [k] thread_return | --- thread_return 0x7f5700d0b723 0x2 0.00% 1 mmfsd [kernel.kallsyms] [k] lock_hrtimer_base | --- lock_hrtimer_base __hrtimer_start_range_ns schedule_hrtimeout_range_clock ep_poll sys_epoll_wait system_call_fastpath 0x7ffb7c127723 0x7ffb7c127723 0x800000000 0.00% 2 mmfsd [kernel.kallsyms] [k] kmem_cache_alloc_node_trace | --- kmem_cache_alloc_node_trace __kmalloc_reserve __alloc_skb sk_stream_alloc_skb tcp_sendmsg sock_sendmsg ___sys_sendmsg __sys_sendmsg system_call_fastpath 0x7ffb7cb55dfd 0x7ffb7cb55dfd 0.00% 1 hal-find-by-cap [kernel.kallsyms] [k] __memcpy | --- __memcpy prepend prepend_path d_path perf_event_mmap_event perf_event_mmap mprotect_fixup sys_mprotect system_call_fastpath 0x7fa021af9237 __mprotect 0x4000 0.00% 1 hal-find-by-cap [kernel.kallsyms] [k] md5_transform | --- md5_transform get_random_int mmap_rnd mmap_base arch_pick_mmap_layout exec_mmap flush_old_exec load_elf_binary search_binary_handler do_execve_common sys_execve stub_execve 0x7f14cb944a57 __execve 0.00% 1 mmfsd [kernel.kallsyms] [k] ttwu_do_wakeup | --- ttwu_do_wakeup try_to_wake_up __wake_up_common __wake_up 0xffffffffa04be300 0xffffffffa05c064a 0xffffffffa0605a42 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0x1bfffffffff 0.00% 1 kworker/8:1 [kernel.kallsyms] [k] free_block | --- free_block drain_array cache_reap process_one_work worker_thread kthread kernel_thread_helper 0.00% 3 swapper [kernel.kallsyms] [k] menu_select | --- menu_select cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] enqueue_task | --- enqueue_task ttwu_activate ttwu_do_activate try_to_wake_up pollwake __wake_up_common __wake_up credit_entropy_bits add_interrupt_randomness handle_irq_event_percpu handle_irq_event handle_edge_irq handle_irq do_IRQ ret_from_intr intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] find_next_bit | --- find_next_bit cpumask_next_and 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] 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 postgres postgres [.] PgstatCollectorMain | --- PgstatCollectorMain pgstat_start reaper __restore_rt PostmasterMain main __libc_start_main 0.00% 1 postgres [kernel.kallsyms] [k] sock_poll | --- sock_poll do_poll do_sys_poll sys_poll system_call_fastpath 0x7fb873db9b8f __libc_poll 0.00% 1 irqbalance [kernel.kallsyms] [k] seq_printf | --- seq_printf 0xffff88242e0e3180 0x7f398a1965d0 0.00% 1 mmfsd [nf_conntrack] [k] tcp_in_window | --- tcp_in_window tcp_packet nf_conntrack_in nf_iterate nf_hook_slow __ip_local_out ip_local_out ip_queue_xmit tcp_transmit_skb tcp_write_xmit __tcp_push_pending_frames tcp_sendmsg sock_sendmsg ___sys_sendmsg __sys_sendmsg system_call_fastpath 0x7ffb7cb55dfd 0x7ffb7cb55dfd 0.00% 1 mmfsd [kernel.kallsyms] [k] sys_ioctl | --- sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0x14a0a48 0.00% 2 swapper [kernel.kallsyms] [k] run_posix_cpu_timers | --- run_posix_cpu_timers tick_sched_timer __run_hrtimer hrtimer_interrupt smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 mmfsd [kernel.kallsyms] [k] find_busiest_group | --- find_busiest_group load_balance idle_balance thread_return 0xffffffffa04a8b7d 0xffffffffa05bf0f1 0xffffffffa05c0478 0xffffffffa0605afe 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0x7ffb509d7cf0 0.00% 2 swapper [kernel.kallsyms] [k] scheduler_tick | --- scheduler_tick update_process_times tick_sched_timer __run_hrtimer hrtimer_interrupt smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 2 postgres [kernel.kallsyms] [k] pipe_read | --- pipe_read do_sync_read vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.00% 1 kworker/2:1 [igb] [k] igb_update_stats | --- igb_update_stats igb_watchdog_task process_one_work worker_thread kthread kernel_thread_helper 0.00% 2 swapper [kernel.kallsyms] [k] __schedule | --- __schedule cpu_idle 0.00% 1 kworker/9:2 [kernel.kallsyms] [k] drain_array | --- drain_array cache_reap process_one_work worker_thread kthread kernel_thread_helper 0.00% 1 swapper [kernel.kallsyms] [k] tick_sched_timer | --- tick_sched_timer __run_hrtimer hrtimer_interrupt smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] radix_tree_lookup | --- radix_tree_lookup handle_irq do_IRQ ret_from_intr intel_idle cpuidle_idle_call cpu_idle 0.00% 1 mmfsd [kernel.kallsyms] [k] thread_return | --- thread_return 0xffffffffa04a8b7d 0xffffffffa05bf0f1 0xffffffffa05c0478 0xffffffffa0605afe 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0xffffc900346c64b0 0x6bee989492434 0.00% 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.00% 1 swapper [kernel.kallsyms] [k] skb_set_owner_r | --- skb_set_owner_r tcp_rcv_established tcp_v4_do_rcv tcp_v4_rcv ip_local_deliver_finish __netif_receive_skb netif_receive_skb napi_skb_finish ixgbe_clean_rx_irq ixgbe_poll net_rx_action __do_softirq call_softirq do_softirq irq_exit do_IRQ ret_from_intr intel_idle cpuidle_idle_call cpu_idle 0.00% 1 kworker/8:1 [kernel.kallsyms] [k] cache_reap | --- cache_reap process_one_work worker_thread kthread kernel_thread_helper 0.00% 1 swapper [kernel.kallsyms] [k] update_rq_clock | --- update_rq_clock scheduler_tick update_process_times tick_sched_timer __run_hrtimer hrtimer_interrupt smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] native_read_tsc | --- native_read_tsc read_tsc getnstimeofday ktime_get_real intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] run_timer_softirq | --- run_timer_softirq __do_softirq call_softirq do_softirq irq_exit smp_apic_timer_interrupt apic_timer_interrupt finish_task_switch thread_return cpu_idle 0.00% 1 irqbalance [kernel.kallsyms] [k] kstat_irqs_cpu | --- kstat_irqs_cpu 0xffff883fc0a712fc 0x7f398a1965d0 0.00% 1 irqbalance [kernel.kallsyms] [k] radix_tree_lookup | --- radix_tree_lookup kstat_irqs_cpu show_interrupts seq_read proc_reg_read vfs_read sys_read system_call_fastpath 0x7f398a1965d0 0x7f398a1965d0 (nil) 0.00% 1 mmfsd [kernel.kallsyms] [k] __switch_to | --- __switch_to thread_return 0xffff881fc288a000 0x7ffb7c127723 0x800000000 0.00% 1 postgres [kernel.kallsyms] [k] pick_next_task_stop | --- pick_next_task_stop thread_return schedule_hrtimeout_range_clock poll_schedule_timeout do_poll do_sys_poll sys_poll system_call_fastpath 0x7fb873db9b8f __libc_poll 0.00% 1 mmfsd [kernel.kallsyms] [k] update_curr | --- update_curr dequeue_entity dequeue_task_fair __schedule 0xffffffffa04a8b7d 0xffffffffa05bf0f1 0xffffffffa05c0478 0xffffffffa0605afe 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0xffffc900341c0f10 0.00% 1 mmfsd [kernel.kallsyms] [k] __local_bh_enable | --- __local_bh_enable __do_softirq call_softirq do_softirq irq_exit do_IRQ ret_from_intr 0xffffffffa0605a78 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0x2300000000 0x11c2227 0x85786b8bfffffec9 0.00% 1 kworker/9:2 [kernel.kallsyms] [k] find_busiest_group | --- find_busiest_group load_balance idle_balance thread_return worker_thread kthread kernel_thread_helper 0.00% 1 swapper [kernel.kallsyms] [k] resched_task | --- resched_task check_preempt_curr ttwu_do_wakeup 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.00% 1 swapper [kernel.kallsyms] [k] _raw_spin_lock | --- _raw_spin_lock perf_adjust_freq_unthr_context perf_event_task_tick scheduler_tick update_process_times tick_sched_timer __run_hrtimer hrtimer_interrupt smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] tick_do_update_jiffies64 | --- tick_do_update_jiffies64 tick_sched_timer __run_hrtimer hrtimer_interrupt smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] perf_rotate_context | --- perf_rotate_context perf_event_task_tick scheduler_tick update_process_times tick_sched_timer __run_hrtimer hrtimer_interrupt smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] __napi_schedule | --- __napi_schedule ixgbe_msix_clean_rings 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 postgres [kernel.kallsyms] [k] native_sched_clock | --- native_sched_clock sched_clock update_rq_clock dequeue_task __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] deactivate_task | --- deactivate_task 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] dequeue_task_fair | --- 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 swapper [kernel.kallsyms] [k] update_ts_time_stats | --- update_ts_time_stats tick_nohz_stop_idle tick_check_idle irq_enter do_IRQ ret_from_intr intel_idle cpuidle_idle_call cpu_idle 0.00% 1 fail2ban-server [kernel.kallsyms] [k] find_next_bit | --- find_next_bit cpumask_next_and find_busiest_group load_balance idle_balance thread_return schedule_hrtimeout_range_clock poll_schedule_timeout do_select core_sys_select sys_select system_call_fastpath 0x7f465715f393 0x7f465715f393 0x645c5b5c203a6c65 0x7f4658007d80 0.00% 1 kworker/11:1 [kernel.kallsyms] [k] process_one_work | --- process_one_work worker_thread kthread kernel_thread_helper 0.00% 1 swapper [kernel.kallsyms] [k] ns_to_timespec | --- ns_to_timespec ns_to_timeval intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] __phys_addr | --- __phys_addr leave_mm intel_idle cpuidle_idle_call cpu_idle 0.00% 1 kworker/11:1 [kernel.kallsyms] [k] find_busiest_group | --- find_busiest_group load_balance idle_balance thread_return worker_thread kthread kernel_thread_helper 0.00% 1 swapper [kernel.kallsyms] [k] rcu_check_callbacks | --- rcu_check_callbacks update_process_times tick_sched_timer __run_hrtimer hrtimer_interrupt smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] tick_check_oneshot_broadcast | --- tick_check_oneshot_broadcast tick_check_idle irq_enter smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] __run_hrtimer | --- __run_hrtimer hrtimer_interrupt smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 fail2ban-server [kernel.kallsyms] [k] thread_return | --- thread_return schedule_hrtimeout_range_clock poll_schedule_timeout do_select core_sys_select sys_select system_call_fastpath 0x7f465715f393 0x7f465715f393 0x7f4657ff0b30 0x7f4658007d80 0.00% 1 swapper [kernel.kallsyms] [k] native_write_msr_safe | --- native_write_msr_safe native_apic_msr_write 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) #