# Events: 3K cycles # # Overhead Samples Command Shared Object Symbol # ........ .......... ............... ................. ..................................... # 16.42% 600 postgres postgres [.] slot_deform_tuple | --- slot_deform_tuple | |--90.33%-- slot_getattr | ExecEvalFuncArgs | ExecEvalScalarArrayOp | ExecQual | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | 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.50%-- slot_getsomeattrs | ExecProject | ExecScan | ExecProcNode | 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 --0.17%-- [...] 7.83% 286 postgres postgres [.] ExecHashTableInsert | --- ExecHashTableInsert | |--99.65%-- 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 --0.35%-- [...] 7.55% 276 postgres postgres [.] slot_getattr | --- slot_getattr | |--89.85%-- ExecEvalFuncArgs | ExecEvalScalarArrayOp | ExecQual | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | 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.89%-- ExecMakeFunctionResultNoSets | | | |--94.74%-- ExecQual | | ExecScan | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | 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%-- ExecEvalOr | ExecEvalCase | 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 | |--1.45%-- ExecHashGetHashValue | 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 | |--1.09%-- ExecQual | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main --0.72%-- [...] 5.97% 218 postgres postgres [.] bcTruelen | --- bcTruelen | |--78.44%-- bpchareq | | | |--98.83%-- ExecEvalScalarArrayOp | | ExecQual | | ExecScan | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | 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.17%-- ExecMakeFunctionResultNoSets | ExecEvalOr | ExecEvalCase | 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 | |--20.64%-- ExecEvalScalarArrayOp | ExecQual | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main --0.92%-- [...] 4.49% 164 postgres postgres [.] ExecEvalScalarArrayOp | --- ExecEvalScalarArrayOp | |--96.34%-- ExecQual | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | 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.66%-- ExecScan ExecProcNode ExecHashJoin ExecProcNode 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.89% 142 postgres postgres [.] bpchareq | --- bpchareq | |--93.66%-- ExecEvalScalarArrayOp | ExecQual | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | 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.34%-- ExecQual ExecScan ExecProcNode ExecHashJoin ExecProcNode 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.20% 117 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 2.66% 97 postgres postgres [.] heapgettup_pagemode | --- heapgettup_pagemode | |--93.81%-- heap_getnext | SeqNext | ExecScan | ExecProcNode | | | |--84.61%-- ExecHashJoin | | ExecProcNode | | 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%-- 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 | --6.19%-- SeqNext ExecScan ExecProcNode | |--66.67%-- ExecHashJoin | ExecProcNode | 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%-- 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 2.33% 85 postgres postgres [.] CHashBucketScan | --- CHashBucketScan | |--88.24%-- CHashSearch | BufTableLookup | ReadBuffer_common | ReadBufferExtended | heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | | | |--90.66%-- ExecHashJoin | | ExecProcNode | | 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.34%-- 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 | --11.76%-- CHashDelete BufTableDelete ReadBuffer_common ReadBufferExtended heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode | |--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%-- 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 1.89% 69 postgres postgres [.] ExecQual | --- ExecQual | |--98.55%-- ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | 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%-- ExecProcNode ExecHashJoin ExecProcNode 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.75% 64 postgres postgres [.] ExecEvalScalarVarFast | --- ExecEvalScalarVarFast | |--39.06%-- ExecMakeFunctionResultNoSets | | | |--92.01%-- ExecQual | | ExecScan | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | |--4.00%-- ExecEvalAnd | | ExecEvalCase | | 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 | | | --3.99%-- ExecEvalOr | ExecEvalCase | 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 | |--25.00%-- ExecQual | | | |--93.74%-- ExecScan | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | 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.26%-- 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 | |--14.07%-- ExecEvalFuncArgs | ExecEvalScalarArrayOp | ExecQual | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | 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.93%-- ExecEvalScalarArrayOp | ExecQual | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | 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.69%-- 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 | |--3.13%-- ExecHashGetHashValue | 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 | |--1.56%-- ExecEvalOr | ExecEvalCase | 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 | --1.56%-- ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.70% 62 postgres [mmfslinux] [k] 0x2d39 | --- 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 | --- 0xffffffffa04bfff1 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04a057f 0xffffffffa051f536 0xffffffffa053ac4a 0xffffffffa051f34a 0xffffffffa0560b17 0xffffffffa04aeb14 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04aea62 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04c5ea0 vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04a8d14 0xffffffffa0554088 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 | --- 0xffffffffa04c000e 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04c60fb vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04bfffa 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04aa75c 0xffffffffa04c01d0 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04bfeef 0xffffffffa04c021c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04a2d39 0xffff882400ab6000 __GI___read | --- 0xffffffffa04a0579 0xffffffffa051f536 0xffffffffa053ac4a 0xffffffffa051f34a 0xffffffffa0560b17 0xffffffffa04aeb14 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04aa6e3 0xffffffffa04c01d0 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 | --- 0xffffffffa04c01cb 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04c0018 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04b3d04 0xffffffffa0546edd 0xffffffffa05540de 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04c0006 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04c005e 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04a5400 0xffffffffa0546e9d 0xffffffffa05540de 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 1.67% 61 postgres postgres [.] heapgetpage | --- heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode | |--83.61%-- ExecHashJoin | ExecProcNode | 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.39%-- 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 1.64% 60 postgres postgres [.] ExecMakeFunctionResultNoSets | --- ExecMakeFunctionResultNoSets | |--68.33%-- ExecQual | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | 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%-- ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | 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%-- ExecEvalAnd | ExecEvalCase | 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 | |--1.67%-- ExecEvalCase | 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 | --1.66%-- ExecEvalOr ExecEvalCase 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 1.62% 1 postgres [mmfs26] [k] 0x7635 | --- 0xffffffffa05e1d4d __GI___read | --- 0xffffffffa05e1d6a __GI___read | --- 0xffffffffa0546f05 0xffffffffa05540de 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa056f91d 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05540fa 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0513864 0xffffffffa0514a55 0xffffffffa05701ef 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05373a5 0xffffffffa0551586 0xffffffffa0553de1 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05e1d5e __GI___read | --- 0xffffffffa0551e00 0xffffffffa04c006c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0541095 0xffffffffa0541356 0xffffffffa0570c42 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 | --- 0xffffffffa0553cf6 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 | --- 0xffffffffa05f5a34 0xffffffffa056f3f6 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05341e8 0xffffffffa0551537 0xffffffffa0553de1 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa053b0a9 0xffffffffa0541341 0xffffffffa0560b7f 0xffffffffa04aeb14 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0546d10 0xffffffffa05540de 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 | --- 0xffffffffa0546cd0 0xffffffffa05540de 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0513871 0xffffffffa0514a55 0xffffffffa05701ef 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0551e07 0xffffffffa04c006c 0xffffffffa0553f90 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 | --- 0xffffffffa05367ec 0xffffffffa055411b 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0571542 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0553d0a 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05d7594 0xffffffffa05540c2 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa054b6cc 0xffffffffa056f364 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa053b072 0xffffffffa0541341 0xffffffffa0570c42 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0534192 0xffffffffa0551537 0xffffffffa0553de1 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05e1d62 __GI___read | --- 0xffffffffa053b44f 0xffffffffa05419a3 0xffffffffa05718be 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0571539 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa056f939 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 | --- 0xffffffffa0553c50 0x296 __GI___read | --- 0xffffffffa053740c 0xffffffffa0551586 0xffffffffa0553de1 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05ba700 0xffffffffa05341d7 0xffffffffa0551537 0xffffffffa0553de1 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0560b43 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 | --- 0xffffffffa05701ea 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa054131e 0xffffffffa0570c42 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0551656 0xffffffffa0553de1 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 | --- 0xffffffffa05414e3 0xffffffffa0541939 0xffffffffa05718be 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0551df0 0xffffffffa04bffd4 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0553d83 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05351bb 0xffffffffa055170e 0xffffffffa0553de1 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa06046a0 0xffffffffa054711e 0xffffffffa05540de 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 1.42% 52 postgres postgres [.] ExecScan | --- ExecScan ExecProcNode | |--76.91%-- ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --23.09%-- 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 1.40% 51 postgres [vdso] [.] 0x7fffe8fff662 | --- 0x7fffe8fff8f5 __gettimeofday_internal ExecProcNode 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 | --- 0x7fffe8fff662 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode 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 | --- 0x7fffe8fff6ae 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode 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 | --- 0x7fffe8fff8ee __gettimeofday_internal ExecProcNode 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 | --- 0x7fffe8fff8b6 __gettimeofday_internal ExecProcNode | |--75.01%-- 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 | --24.99%-- ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff626 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode 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 | --- 0x7fffe8fff6a5 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode 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 | --- 0x7fffe8fff665 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode 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 | --- 0x7fffe8fff60a 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode 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 | --- 0x7fffe8fff8b0 ExecProcNode 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 | --- 0x7fffe8fff648 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode 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 | --- 0x7fffe8fff8f9 __gettimeofday_internal ExecProcNode 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 | --- 0x7fffe8fff8c4 __gettimeofday_internal ExecProcNode 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 | --- 0x7fffe8fff8c1 __gettimeofday_internal ExecProcNode 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 | --- 0x7fffe8fff640 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode 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 | --- 0x7fffe8fff90a __gettimeofday_internal ExecProcNode 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 | --- 0x7fffe8fff619 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff657 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode 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 | --- 0x7fffe8fff604 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode 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 | --- 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode 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 | --- 0x7fffe8fff8b1 ExecProcNode 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 | --- 0x7fffe8fff8e1 __gettimeofday_internal ExecProcNode 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 1.29% 47 postgres postgres [.] HeapTupleSatisfiesMVCC | --- HeapTupleSatisfiesMVCC | |--95.76%-- heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | 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 | --4.24%-- heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode 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 1.29% 47 postgres postgres [.] heap_getnext | --- heap_getnext | |--89.36%-- SeqNext | ExecScan | ExecProcNode | | | |--88.09%-- ExecHashJoin | | ExecProcNode | | 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.91%-- 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.64%-- ExecScan ExecProcNode ExecHashJoin ExecProcNode 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.20% 44 postgres [ipt_REJECT] [.] 0x5ef30188 | --- 0xffffffffff600188 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode 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 | --- 0xffffffffff600186 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode 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 | --- 0xffffffffff600191 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode 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 | --- 0xffffffffff60019e 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode 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 | --- 0xffffffffff600180 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode 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 1.07% 39 postgres postgres [.] pg_detoast_datum_packed | --- pg_detoast_datum_packed | |--51.28%-- ExecEvalScalarArrayOp | ExecQual | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --48.72%-- bpchareq ExecEvalScalarArrayOp ExecQual ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.99% 36 postgres postgres [.] ExecEvalFuncArgs | --- ExecEvalFuncArgs | |--97.22%-- ExecEvalScalarArrayOp | ExecQual | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | 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.78%-- ExecQual ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.90% 33 postgres [kernel.kallsyms] [k] page_fault | --- page_fault | |--39.39%-- 0x46f444 | slot_getattr | | | --100.00%-- ExecEvalFuncArgs | ExecEvalScalarArrayOp | ExecQual | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | 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.16%-- copy_user_generic_string | 0xffffffffa04bfedc | 0xffffffffa04c021c | 0xffffffffa0553f90 | 0xffffffffa05715f4 | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | |--15.17%-- 0x7a5772 | HeapTupleSatisfiesMVCC | heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | 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 | |--15.16%-- 0x49f6c7 | heap_page_prune_opt | | | |--33.35%-- 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 | | | |--33.35%-- heapgetpage | | heapgettup_pagemode | | heap_getnext | | SeqNext | | ExecScan | | ExecProcNode | | 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 | | | --33.30%-- ExecEvalFuncArgs | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | 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%-- 0x5bc4c5 | ExecHashTableInsert | | | |--50.02%-- 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 | | | --49.98%-- heapgetpage | heap_fill_tuple | 0xca1af0 | --3.03%-- 0x7fb873d6c83c __GI_memcpy 0.82% 30 postgres postgres [.] InstrStopNode | --- InstrStopNode | |--93.35%-- ExecProcNode | | | |--82.15%-- 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.71%-- ExecHashJoin | | ExecProcNode | | 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.13%-- 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.65%-- 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 0.79% 29 postgres postgres [.] heap_fill_tuple | --- heap_fill_tuple | |--93.10%-- heap_form_minimal_tuple | ExecFetchSlotMinimalTuple | ExecHashTableInsert | 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 | --6.90%-- ExecFetchSlotMinimalTuple ExecHashTableInsert 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 0.77% 28 postgres postgres [.] CHashInsert | --- CHashInsert BufTableInsert ReadBuffer_common ReadBufferExtended heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode | |--71.44%-- ExecHashJoin | ExecProcNode | 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.56%-- 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 0.74% 27 postgres postgres [.] ExecProject | --- ExecProject | |--92.59%-- ExecScan | ExecProcNode | 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 | |--3.71%-- ExecProcNode | 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 | --3.70%-- advance_aggregates ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.71% 26 postgres postgres [.] PinBuffer | --- PinBuffer ReadBuffer_common ReadBufferExtended heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode | |--92.30%-- ExecHashJoin | ExecProcNode | 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.70%-- 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 0.68% 25 postgres postgres [.] ExecStoreTuple | --- ExecStoreTuple | |--76.01%-- SeqNext | ExecScan | ExecProcNode | | | |--84.21%-- ExecHashJoin | | ExecProcNode | | 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.79%-- 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 | --23.99%-- ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.66% 24 postgres postgres [.] LWLockAttemptLock | --- LWLockAttemptLock | |--95.84%-- LWLockAcquire | | | |--86.99%-- heapgetpage | | heapgettup_pagemode | | heap_getnext | | SeqNext | | ExecScan | | ExecProcNode | | | | | |--74.81%-- ExecHashJoin | | | ExecProcNode | | | 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.19%-- 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 | | | --13.01%-- StartBufferIO | ReadBuffer_common | ReadBufferExtended | heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | | | |--66.62%-- 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 | | | --33.38%-- ExecHashJoin | ExecProcNode | 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.16%-- heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode 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 0.66% 24 postgres postgres [.] MemoryContextReset | --- MemoryContextReset | |--70.75%-- ExecScan | ExecProcNode | | | |--82.35%-- ExecHashJoin | | ExecProcNode | | 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.65%-- 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 | |--25.09%-- ExecProcNode | | | |--82.85%-- ExecHashJoin | | ExecProcNode | | 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.15%-- 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 | --4.15%-- ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.66% 24 postgres postgres [.] heap_page_prune_opt | --- heap_page_prune_opt | |--95.83%-- heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | | | |--91.30%-- ExecHashJoin | | ExecProcNode | | 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.70%-- 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 | --4.17%-- heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.63% 23 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 | |--56.53%-- 0x46f444 | slot_getattr | ExecEvalFuncArgs | ExecEvalScalarArrayOp | ExecQual | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | 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.09%-- 0x49f6c7 | heap_page_prune_opt | heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | 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.03%-- copy_user_generic_string | 0xffffffffa04bfedc | 0xffffffffa04c021c | 0xffffffffa0553f90 | 0xffffffffa05715f4 | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --4.35%-- 0x782d0f CHashBucketScan CHashSearch BufTableLookup ReadBuffer_common ReadBufferExtended heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode 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 0.63% 23 postgres postgres [.] ExecEvalConst | --- ExecEvalConst | |--43.47%-- ExecEvalScalarArrayOp | ExecQual | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--34.79%-- ExecEvalFuncArgs | ExecEvalScalarArrayOp | ExecQual | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | 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.69%-- 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 | |--8.69%-- ExecMakeFunctionResultNoSets | | | |--50.02%-- ExecQual | | ExecScan | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | 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%-- ExecEvalAnd | ExecEvalCase | 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 | --4.35%-- ExecEvalAnd ExecEvalCase ExecProject advance_aggregates ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.60% 22 postgres postgres [.] CheckForSerializableConflictOut | --- CheckForSerializableConflictOut | |--59.08%-- heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | | | |--84.65%-- ExecHashJoin | | ExecProcNode | | 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.35%-- 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 | --40.92%-- heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode | |--77.77%-- ExecHashJoin | ExecProcNode | 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.23%-- 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 0.57% 21 postgres postgres [.] SeqNext | --- SeqNext | |--85.71%-- ExecScan | ExecProcNode | | | |--83.33%-- ExecHashJoin | | ExecProcNode | | 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%-- 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 | --14.29%-- ExecProcNode | |--66.65%-- 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 | --33.35%-- ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.54% 1 postgres [kernel.kallsyms] [k] find_get_page | --- find_get_page | |--99.85%-- find_lock_page | shmem_getpage_gfp | shmem_fault | __do_fault | handle_pte_fault | do_page_fault | page_fault | | | |--51.05%-- 0x46f444 | | slot_getattr | | ExecEvalFuncArgs | | ExecEvalScalarArrayOp | | ExecQual | | ExecScan | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | 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.42%-- 0x49f6c7 | | heap_page_prune_opt | | heapgetpage | | heapgettup_pagemode | | heap_getnext | | SeqNext | | ExecScan | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | 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.39%-- copy_user_generic_string | | 0xffffffffa04bfedc | | 0xffffffffa04c021c | | 0xffffffffa0553f90 | | 0xffffffffa05715f4 | | 0xffffffffa04c61ab | | vfs_read | | sys_read | | system_call_fastpath | | 0x7fb873db55d0 | | __GI___read | | | |--5.11%-- 0x68ef14 | | LWLockAttemptLock | | LWLockAcquire | | heapgetpage | | heapgettup_pagemode | | heap_getnext | | SeqNext | | ExecScan | | ExecProcNode | | 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 | | | --3.03%-- 0x49d348 | heap_hot_search_buffer | index_fetch_heap | index_getnext | systable_getnext | RelationBuildDesc | RelationIdGetRelation | relation_open | heap_open | toast_fetch_datum | toast_flatten_tuple | CatalogCacheCreateEntry | SearchCatCache | get_attavgwidth | set_rel_width | set_rel_size | make_one_rel | query_planner | grouping_planner | subquery_planner | standard_planner | BeginCopy | DoCopy | standard_ProcessUtility | PortalRunUtility | PortalRunMulti | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main --0.15%-- [...] 0.52% 19 postgres postgres [.] heap_compute_data_size | --- heap_compute_data_size | |--94.74%-- heap_form_minimal_tuple | ExecFetchSlotMinimalTuple | ExecHashTableInsert | 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 | --5.26%-- ExecFetchSlotMinimalTuple ExecHashTableInsert 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 0.49% 18 postgres postgres [.] heap_form_minimal_tuple | --- heap_form_minimal_tuple | |--94.44%-- ExecFetchSlotMinimalTuple | ExecHashTableInsert | 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 | --5.56%-- ExecHashTableInsert 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 0.49% 18 postgres postgres [.] InstrStartNode | --- InstrStartNode | |--94.45%-- ExecProcNode | | | |--94.11%-- 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 | | | --5.89%-- ExecHashJoin | ExecProcNode | 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.55%-- 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 0.49% 18 postgres postgres [.] ExecScanHashBucket | --- 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 0.44% 16 postgres postgres [.] ExecProcNode | --- ExecProcNode | |--75.00%-- 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 | --25.00%-- ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.43% 15 postgres [kernel.kallsyms] [k] clear_page_c | --- clear_page_c | |--82.31%-- prep_new_page | get_page_from_freelist | __alloc_pages_nodemask | alloc_pages_vma | do_anonymous_page | do_page_fault | page_fault | | | |--30.78%-- 0x5bc4c5 | | ExecHashTableInsert | | 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 | | | |--23.07%-- 0x7fb873d6c83c | | __GI_memcpy | | 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 | | | |--15.39%-- 0x7fb873d6c838 | | __GI_memcpy | | 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 | | | |--15.37%-- 0x7fb873d6c834 | | __GI_memcpy | | 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 | | | |--7.69%-- 0x7fb873d619d3 | | _int_malloc | | (nil) | | | --7.69%-- 0x7fb873d6c831 | __GI_memcpy | 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 | --17.69%-- clear_huge_page __do_huge_pmd_anonymous_page do_page_fault page_fault 0x7fb873d6bdbe __GI_memset ExecHashTableCreate ExecHashJoin ExecProcNode ExecAgg 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% 15 postgres postgres [.] AllocSetFree | --- AllocSetFree | |--93.33%-- ExecClearTuple | ExecProject | ExecScan | ExecProcNode | 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 | --6.67%-- ExecProject ExecScan ExecProcNode 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 0.38% 13 postgres [kernel.kallsyms] [k] mem_cgroup_update_page_stat | --- mem_cgroup_update_page_stat | |--92.83%-- __do_fault | handle_pte_fault | do_page_fault | page_fault | | | |--38.48%-- 0x49f6c7 | | heap_page_prune_opt | | heapgetpage | | heapgettup_pagemode | | heap_getnext | | SeqNext | | ExecScan | | ExecProcNode | | | | | |--80.00%-- ExecHashJoin | | | ExecProcNode | | | 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%-- 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 | | | |--23.09%-- 0x7a5772 | | HeapTupleSatisfiesMVCC | | heapgetpage | | heapgettup_pagemode | | heap_getnext | | SeqNext | | ExecScan | | ExecProcNode | | 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 | | | |--23.07%-- 0x46f444 | | slot_getattr | | ExecEvalFuncArgs | | ExecEvalScalarArrayOp | | ExecQual | | ExecScan | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | 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.36%-- copy_user_generic_string | 0xffffffffa04bfedc | 0xffffffffa04c021c | 0xffffffffa0553f90 | 0xffffffffa05715f4 | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --7.17%-- 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.38% 14 postgres postgres [.] check_stack_depth | --- check_stack_depth | |--71.44%-- ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | 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.56%-- ExecQual ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.36% 13 postgres libc-2.11.3.so [.] __GI_memcpy | --- __GI_memcpy | |--54.07%-- 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 | --45.93%-- heap_form_minimal_tuple ExecFetchSlotMinimalTuple ExecHashTableInsert 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 0.36% 13 postgres postgres [.] ArrayGetNItems | --- ArrayGetNItems | |--76.93%-- ExecEvalScalarArrayOp | ExecQual | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --23.07%-- ExecQual ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.36% 13 postgres postgres [.] date_lt | --- date_lt | |--76.92%-- ExecQual | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --23.08%-- ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.36% 2 postgres [kernel.kallsyms] [k] zap_pte_range | --- zap_pte_range unmap_page_range unmap_vmas | |--84.62%-- exit_mmap | mmput | exit_mm | do_exit | do_group_exit | sys_exit_group | system_call_fastpath | 0x7fb873d90a38 | --15.38%-- unmap_region do_munmap sys_brk system_call_fastpath 0x7fb873dbb2aa __brk 0x7fb874057aa0 0x834800000000ba00 0.33% 12 postgres postgres [.] dense_alloc | --- dense_alloc | |--91.69%-- ExecHashTableInsert | 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 | --8.31%-- 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 0.33% 12 postgres postgres [.] ExecHashGetHashValue | --- ExecHashGetHashValue 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 0.27% 10 postgres postgres [.] pgstat_init_function_usage | --- pgstat_init_function_usage | |--90.00%-- ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | 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%-- ExecQual ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg 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% 10 postgres postgres [.] MultiExecHash | --- 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 0.25% 9 postgres postgres [.] AllocSetAlloc | --- AllocSetAlloc palloc0 heap_form_minimal_tuple ExecFetchSlotMinimalTuple ExecHashTableInsert 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 0.25% 9 postgres postgres [.] pgstat_end_function_usage | --- pgstat_end_function_usage | |--88.89%-- ExecMakeFunctionResultNoSets | ExecQual | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | 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%-- ExecQual ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.22% 1 postgres [kernel.kallsyms] [k] _raw_spin_lock_irqsave | --- _raw_spin_lock_irqsave | |--73.01%-- down | 0xffffffffa04a89cf | 0xffffffffa051f54e | | | |--49.96%-- 0xffffffffa053ac4a | | 0xffffffffa051f34a | | 0xffffffffa0560b17 | | 0xffffffffa04aeb14 | | 0xffffffffa04c602f | | vfs_read | | sys_read | | system_call_fastpath | | 0x7fb873db55d0 | | __GI___read | | | |--33.36%-- 0xffffffffa0541346 | | 0xffffffffa0560b7f | | 0xffffffffa04aeb14 | | 0xffffffffa04c602f | | vfs_read | | sys_read | | system_call_fastpath | | 0x7fb873db55d0 | | __GI___read | | | --16.68%-- 0xffffffffa054182c | 0xffffffffa05718be | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --26.99%-- up | |--45.14%-- 0xffffffffa0541942 | 0xffffffffa05718be | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | |--45.13%-- 0xffffffffa056f364 | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --9.73%-- 0xffffffffa0560b7f 0xffffffffa04b3068 link_path_walk path_openat do_filp_open do_sys_open system_call_fastpath 0x7fb873db51e0 __GI___open64 0.22% 8 postgres postgres [.] StrategyGetBuffer | --- StrategyGetBuffer | |--87.49%-- ReadBuffer_common | ReadBufferExtended | heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | | | |--85.69%-- 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 | | | --14.31%-- ExecHashJoin | ExecProcNode | 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%-- ReadBufferExtended heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg 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% 1 postgres [kernel.kallsyms] [k] handle_mm_fault | --- handle_mm_fault do_page_fault page_fault | |--38.84%-- 0x49f6c7 | heap_page_prune_opt | heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | | | |--66.72%-- 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 | | | --33.28%-- ExecHashJoin | ExecProcNode | 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.89%-- 0x46f444 | slot_getattr | ExecEvalFuncArgs | ExecEvalScalarArrayOp | ExecQual | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | 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.96%-- copy_user_generic_string | 0xffffffffa04bfedc | 0xffffffffa04c021c | 0xffffffffa0553f90 | 0xffffffffa05715f4 | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | |--12.96%-- 0x7fb873d6c787 | __GI_memcpy | 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 | --9.36%-- 0x7fb873d619d3 _int_malloc (nil) 0.19% 1 postgres [kernel.kallsyms] [k] 0xffffffff81152f94 | --- mem_cgroup_update_page_stat zap_pte_range unmap_page_range unmap_vmas exit_mmap mmput exit_mm do_exit do_group_exit sys_exit_group system_call_fastpath 0x7fb873d90a38 0.19% 7 postgres postgres [.] TransactionIdPrecedes | --- TransactionIdPrecedes | |--57.13%-- HeapTupleSatisfiesMVCC | heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | 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 | --42.87%-- XidInMVCCSnapshot HeapTupleSatisfiesMVCC heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode 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 0.19% 7 postgres postgres [.] CHashAddToGarbage | --- CHashAddToGarbage CHashDelete BufTableDelete ReadBuffer_common ReadBufferExtended heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg 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% 7 postgres [kernel.kallsyms] [k] mem_cgroup_charge_common | --- mem_cgroup_charge_common do_anonymous_page do_page_fault page_fault | |--42.89%-- 0x7fb873d6c834 | __GI_memcpy | 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 | |--14.30%-- 0x7fb873d619d3 | _int_malloc | (nil) | |--14.30%-- 0x7fb873d6c831 | __GI_memcpy | 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 | |--14.26%-- 0x5bc4c5 | ExecHashTableInsert | 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 | --14.25%-- 0x7fb873d6c83c __GI_memcpy 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 0.19% 7 postgres postgres [.] pg_detoast_datum | --- pg_detoast_datum | |--71.44%-- ExecQual | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | 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.56%-- ExecEvalScalarArrayOp ExecQual ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.18% 6 postgres libc-2.11.3.so [.] __GI_memset | --- __GI_memset | |--61.02%-- heap_form_minimal_tuple | ExecFetchSlotMinimalTuple | ExecHashTableInsert | 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 | --38.98%-- ExecHashTableCreate ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.18% 40 swapper [kernel.kallsyms] [k] intel_idle | --- intel_idle cpuidle_idle_call cpu_idle | --100.00%-- start_kernel x86_64_start_kernel 0.16% 6 postgres postgres [.] CHashSearch | --- CHashSearch BufTableLookup ReadBuffer_common ReadBufferExtended heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg 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% 6 postgres postgres [.] ExecHashJoin | --- ExecHashJoin | |--83.33%-- ExecProcNode | 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%-- ExecAgg 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% 6 postgres postgres [.] slot_getsomeattrs | --- slot_getsomeattrs ExecProject ExecScan ExecProcNode 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 0.16% 6 postgres libc-2.11.3.so [.] __gettimeofday_internal | --- __gettimeofday_internal ExecProcNode 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 0.16% 6 postgres [kernel.kallsyms] [k] _raw_spin_unlock_irqrestore | --- _raw_spin_unlock_irqrestore | |--66.68%-- 0xffffffffa04a89cf | | | |--74.97%-- 0xffffffffa051f54e | | | | | |--66.64%-- 0xffffffffa053ac4a | | | 0xffffffffa051f34a | | | 0xffffffffa0560b17 | | | 0xffffffffa04aeb14 | | | 0xffffffffa04c602f | | | vfs_read | | | sys_read | | | system_call_fastpath | | | 0x7fb873db55d0 | | | __GI___read | | | | | --33.36%-- 0xffffffffa0541346 | | 0xffffffffa0570c42 | | 0xffffffffa04c61ab | | vfs_read | | sys_read | | system_call_fastpath | | 0x7fb873db55d0 | | __GI___read | | | --25.03%-- 0xffffffffa054b712 | 0xffffffffa056f34a | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | |--16.68%-- 0xffffffffa053ac7c | 0xffffffffa051f34a | 0xffffffffa0560b17 | 0xffffffffa04aeb14 | 0xffffffffa04c602f | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --16.64%-- 0xffffffffa056f364 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.14% 5 postgres [kernel.kallsyms] [k] __inc_zone_page_state | --- __inc_zone_page_state | |--80.00%-- page_add_file_rmap | __do_fault | handle_pte_fault | do_page_fault | page_fault | | | |--50.00%-- 0x46f444 | | slot_getattr | | ExecEvalFuncArgs | | ExecEvalScalarArrayOp | | ExecQual | | ExecScan | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | 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%-- 0x7a5772 | HeapTupleSatisfiesMVCC | heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | | | |--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%-- 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 | --20.00%-- page_add_new_anon_rmap do_anonymous_page do_page_fault page_fault 0x7fb873d6c83c __GI_memcpy 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 0.14% 5 postgres [kernel.kallsyms] [k] shmem_getpage_gfp | --- shmem_getpage_gfp shmem_fault __do_fault handle_pte_fault do_page_fault page_fault | |--59.97%-- 0x46f444 | slot_getattr | ExecEvalFuncArgs | ExecEvalScalarArrayOp | ExecQual | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --40.03%-- 0x7a5772 HeapTupleSatisfiesMVCC heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode 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 0.14% 5 postgres [kernel.kallsyms] [k] _raw_spin_lock | --- _raw_spin_lock __do_fault handle_pte_fault do_page_fault page_fault | |--79.99%-- 0x46f444 | slot_getattr | ExecEvalFuncArgs | ExecEvalScalarArrayOp | ExecQual | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --20.01%-- 0x49f6c7 heap_page_prune_opt heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.14% 5 postgres postgres [.] pfree | --- pfree | |--79.99%-- ExecClearTuple | ExecProject | ExecScan | ExecProcNode | 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 | --20.01%-- ExecProject ExecScan ExecProcNode 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 0.13% 1 sleep [kernel.kallsyms] [k] _raw_spin_lock | --- _raw_spin_lock dput path_put path_openat do_filp_open open_exec load_elf_binary search_binary_handler do_execve_common sys_execve stub_execve 0x7ffa11853a57 __execve 0x6a46f0 0x6a9960 0.12% 2 fail2ban-server [kernel.kallsyms] [k] copy_user_generic_string | --- copy_user_generic_string poll_select_copy_remaining sys_select system_call_fastpath 0x7f465715f393 0x7f465715f393 | |--98.21%-- 0x7f4657ff0b30 | 0x7f4658007d80 | --1.79%-- (nil) 0.11% 4 postgres [kernel.kallsyms] [k] do_page_fault | --- do_page_fault page_fault | |--50.00%-- 0x49f6c7 | heap_page_prune_opt | heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | 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%-- 0x46f444 | slot_getattr | ExecEvalFuncArgs | ExecEvalScalarArrayOp | ExecQual | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | 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 0.11% 4 postgres postgres [.] hash_uint32 | --- hash_uint32 ExecHashGetHashValue 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 0.11% 4 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.11% 4 postgres postgres [.] ExecClearTuple | --- ExecClearTuple | |--50.01%-- ExecProject | ExecScan | ExecProcNode | 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 | --49.99%-- ExecScan ExecProcNode 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 0.11% 4 postgres postgres [.] ReadBufferExtended | --- ReadBufferExtended | |--75.02%-- heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | | | |--66.66%-- ExecHashJoin | | ExecProcNode | | 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%-- 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 | --24.98%-- heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.11% 4 postgres postgres [.] ReleaseBuffer | --- ReleaseBuffer | |--50.00%-- heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | 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%-- heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.11% 4 postgres postgres [.] GetPrivateRefCountEntry | --- GetPrivateRefCountEntry | |--74.99%-- IncrBufferRefCount | ExecStoreTuple | SeqNext | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | 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%-- ReleaseBuffer ExecStoreTuple SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.11% 4 postgres [kernel.kallsyms] [k] __do_fault | --- __do_fault handle_pte_fault do_page_fault page_fault | |--75.01%-- 0x49f6c7 | heap_page_prune_opt | heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | | | |--66.65%-- ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --33.35%-- 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 | --24.99%-- copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.11% 4 postgres postgres [.] XidInMVCCSnapshot | --- XidInMVCCSnapshot | |--75.00%-- HeapTupleSatisfiesMVCC | heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | 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 | --25.00%-- heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode 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 0.11% 4 postgres postgres [.] FunctionCall1Coll | --- FunctionCall1Coll | |--74.98%-- ExecHashGetHashValue | 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 | --25.02%-- 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 0.11% 4 postgres postgres [.] ExecAgg | --- ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.11% 4 postgres [kernel.kallsyms] [k] get_page_from_freelist | --- get_page_from_freelist __alloc_pages_nodemask alloc_pages_vma do_anonymous_page do_page_fault page_fault | |--50.01%-- 0x7fb873d6c787 | __GI_memcpy | 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 | |--25.03%-- 0x5bc4c5 | ExecHashTableInsert | 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 | --24.96%-- 0x7fb873d619d3 _int_malloc (nil) 0.11% 4 postgres postgres [.] ExecEvalOr | --- ExecEvalOr | |--75.02%-- ExecEvalCase | 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 | --24.98%-- ExecProject advance_aggregates ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.09% 2 postgres [kernel.kallsyms] [k] fget_light | --- fget_light | |--70.14%-- sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | |--29.14%-- sys_lseek | system_call_fastpath | 0x7fb873dc30d0 | __lseek64 | --0.72%-- do_poll do_sys_poll sys_poll system_call_fastpath 0x7fb873db9b8f __libc_poll 0.08% 3 postgres postgres [.] mdread | --- mdread ReadBuffer_common ReadBufferExtended heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode | |--66.67%-- ExecHashJoin | ExecProcNode | 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%-- 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 0.08% 3 postgres [kernel.kallsyms] [k] __alloc_pages_nodemask | --- __alloc_pages_nodemask alloc_pages_vma do_anonymous_page do_page_fault page_fault | |--33.34%-- 0x7fb873d6c831 | __GI_memcpy | 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 | |--33.33%-- 0x7fb873d6c83c | __GI_memcpy | 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 | --33.33%-- 0x7fb873d6c787 __GI_memcpy 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 0.08% 3 postgres postgres [.] bpcharne | --- bpcharne ExecMakeFunctionResultNoSets ExecEvalAnd ExecEvalCase ExecProject advance_aggregates ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.08% 3 postgres postgres [.] palloc0 | --- palloc0 heap_form_minimal_tuple ExecFetchSlotMinimalTuple ExecHashTableInsert 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 0.08% 3 postgres postgres [.] ExecFetchSlotMinimalTuple | --- ExecFetchSlotMinimalTuple ExecHashTableInsert 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 0.08% 3 postgres postgres [.] ExecCopySlotMinimalTuple | --- ExecCopySlotMinimalTuple | |--66.67%-- ExecHashTableInsert | 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 | --33.33%-- ExecFetchSlotMinimalTuple ExecHashTableInsert 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 0.08% 3 postgres [kernel.kallsyms] [k] __mem_cgroup_commit_charge | --- __mem_cgroup_commit_charge mem_cgroup_charge_common do_anonymous_page do_page_fault page_fault | |--33.34%-- 0x7fb873d6c831 | __GI_memcpy | 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 | |--33.34%-- 0x5bc4c5 | ExecHashTableInsert | 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 | --33.32%-- 0x7fb873d6c834 __GI_memcpy 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 0.08% 3 postgres postgres [.] mdopen | --- mdopen | |--66.67%-- mdread | ReadBuffer_common | ReadBufferExtended | heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | 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%-- _mdfd_getseg mdread ReadBuffer_common ReadBufferExtended heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg 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% 3 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 | |--66.65%-- 0x46f444 | slot_getattr | ExecEvalFuncArgs | ExecEvalScalarArrayOp | ExecQual | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --33.35%-- 0x49f6c7 heap_page_prune_opt heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode 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 0.08% 3 postgres postgres [.] ReadBuffer_common | --- ReadBuffer_common ReadBufferExtended heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode | |--66.69%-- ExecHashJoin | ExecProcNode | 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%-- 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 0.08% 3 postgres [kernel.kallsyms] [k] handle_pte_fault | --- handle_pte_fault do_page_fault page_fault | |--66.65%-- 0x46f444 | slot_getattr | ExecEvalFuncArgs | ExecEvalScalarArrayOp | ExecQual | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --33.35%-- copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.08% 3 postgres postgres [.] ResourceOwnerForgetBuffer | --- ResourceOwnerForgetBuffer ReleaseBuffer ExecStoreTuple SeqNext ExecScan ExecProcNode | |--66.72%-- ExecHashJoin | ExecProcNode | 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%-- 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 0.08% 3 postgres [kernel.kallsyms] [k] mem_cgroup_count_vm_event | --- mem_cgroup_count_vm_event handle_mm_fault do_page_fault page_fault | |--66.72%-- 0x49f6c7 | heap_page_prune_opt | heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | | | |--50.02%-- 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 | | | --49.98%-- ExecHashJoin | ExecProcNode | 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%-- 0x46f444 slot_getattr ExecEvalFuncArgs ExecEvalScalarArrayOp ExecQual ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg 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% 3 postgres postgres [.] LWLockRelease | --- LWLockRelease | |--66.63%-- heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | 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%-- ReadBuffer_common ReadBufferExtended heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.08% 1 perf [kernel.kallsyms] [k] number | --- number vsnprintf seq_printf proc_pid_status proc_single_show seq_read vfs_read sys_read system_call_fastpath 0x7f8ba33d75d0 __GI___read 0.07% 1 postgres postgres [.] hash_search_with_hash_value | --- hash_search_with_hash_value | |--77.31%-- 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 | --22.69%-- pgstat_fetch_stat_tabentry pg_stat_get_blocks_hit ExecMakeFunctionResultNoSets ExecProject advance_aggregates ExecAgg ExecProcNode ExecHashJoin ExecProcNode standard_ExecutorRun DoCopyTo DoCopy standard_ProcessUtility PortalRunUtility PortalRunMulti PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.06% 1 swapper [kernel.kallsyms] [k] nohz_idle_balance | --- nohz_idle_balance __do_softirq call_softirq do_softirq irq_exit smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.06% 1 postgres [kernel.kallsyms] [k] down_read_trylock | --- down_read_trylock do_page_fault page_fault | |--93.26%-- 0x49f6c7 | heap_page_prune_opt | heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | 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.74%-- 0x7840e1 hash_search_with_hash_value SetupLockInTable LockAcquireExtended LockSharedObject InitPostgres PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.06% 1 postgres [kernel.kallsyms] [k] unlock_page | --- unlock_page __do_fault handle_pte_fault do_page_fault page_fault | |--96.25%-- 0x46f444 | slot_getattr | ExecEvalFuncArgs | ExecEvalScalarArrayOp | ExecQual | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | 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.75%-- 0x7fb873d4b1e0 __fscanf InitPostgres PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.06% 1 postgres [kernel.kallsyms] [k] release_pages | --- release_pages free_pages_and_swap_cache tlb_flush_mmu zap_pte_range unmap_page_range unmap_vmas | |--50.83%-- exit_mmap | mmput | exit_mm | do_exit | do_group_exit | sys_exit_group | system_call_fastpath | 0x7fb873d90a38 | --49.17%-- unmap_region do_munmap sys_brk system_call_fastpath 0x7fb873dbb2aa __brk 0x7fb874057aa0 0x834800000000ba00 0.05% 1 postgres [kernel.kallsyms] [k] lookup_page_cgroup | --- lookup_page_cgroup mem_cgroup_update_page_stat | |--50.28%-- 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 | --49.72%-- __do_fault handle_pte_fault do_page_fault page_fault 0x49f6c7 heap_page_prune_opt heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.05% 2 postgres postgres [.] BufTableLookup | --- BufTableLookup ReadBufferExtended heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.05% 2 postgres [kernel.kallsyms] [k] error_entry | --- error_entry | |--50.00%-- 0x5bc4c5 | ExecHashTableInsert | heapgetpage | heap_fill_tuple | 0xca1af0 | --50.00%-- 0x49f6c7 heap_page_prune_opt ExecEvalFuncArgs heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.05% 2 postgres postgres [.] RecoveryInProgress | --- RecoveryInProgress heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.05% 2 postgres postgres [.] gettimeofday@plt | --- gettimeofday@plt ExecProcNode 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 0.05% 2 postgres [kernel.kallsyms] [k] __memcpy | --- __memcpy 0xffffffffa04aeab2 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.05% 2 postgres [kernel.kallsyms] [k] error_exit | --- error_exit | |--50.02%-- 0x5bc4c5 | ExecHashTableInsert | 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 | --49.98%-- copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.05% 2 postgres postgres [.] LWLockAcquire | --- LWLockAcquire | |--50.04%-- heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.96%-- heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.05% 2 postgres [kernel.kallsyms] [k] fsnotify | --- fsnotify vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.05% 2 postgres postgres [.] ResourceOwnerEnlargeBuffers | --- ResourceOwnerEnlargeBuffers | |--50.01%-- ExecStoreTuple | SeqNext | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | 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%-- IncrBufferRefCount ExecStoreTuple SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.05% 2 postgres [kernel.kallsyms] [k] page_add_file_rmap | --- page_add_file_rmap __do_fault handle_pte_fault do_page_fault page_fault | |--50.05%-- 0x49f6c7 | heap_page_prune_opt | heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | 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%-- 0x46f444 slot_getattr ExecEvalFuncArgs ExecEvalScalarArrayOp ExecQual ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.05% 2 postgres postgres [.] date_lt_timestamp | --- date_lt_timestamp | |--50.07%-- ExecQual | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | 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%-- ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.05% 2 postgres [kernel.kallsyms] [k] __rmqueue | --- __rmqueue get_page_from_freelist __alloc_pages_nodemask alloc_pages_vma do_anonymous_page do_page_fault page_fault | |--50.09%-- 0x7fb873d6c787 | __GI_memcpy | 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 | --49.91%-- 0x7fb873d6c831 __GI_memcpy 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 0.05% 2 postgres [kernel.kallsyms] [k] next_zones_zonelist | --- next_zones_zonelist __alloc_pages_nodemask | |--50.08%-- alloc_pages_current | pte_alloc_one | __pte_alloc | handle_mm_fault | do_page_fault | page_fault | 0x6777d7 | StrategyGetBuffer | ReadBuffer_common | ReadBufferExtended | heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | 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 | --49.92%-- alloc_pages_vma do_anonymous_page do_page_fault page_fault 0x7fb873d6c834 __GI_memcpy 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 0.05% 2 postgres libc-2.11.3.so [.] _int_malloc | --- _int_malloc (nil) 0.05% 1 irqbalance [kernel.kallsyms] [k] number | --- number vsnprintf seq_printf show_stat seq_read proc_reg_read vfs_read sys_read system_call_fastpath 0x7f398a1965d0 0x7f398a1965d0 0x7f398ad0a730 0.04% 1 postgres [kernel.kallsyms] [k] page_remove_rmap | --- page_remove_rmap zap_pte_range unmap_page_range unmap_vmas exit_mmap mmput exit_mm do_exit do_group_exit sys_exit_group system_call_fastpath 0x7fb873d90a38 0.04% 7 postgres postgres [.] SyncOneBuffer | --- SyncOneBuffer BgBufferSync BackgroundWriterMain AuxiliaryProcessMain StartChildProcess reaper __restore_rt PostmasterMain main __libc_start_main 0.04% 1 swapper [kernel.kallsyms] [k] free_pcppages_bulk | --- free_pcppages_bulk free_hot_cold_page rb_free rcu_do_batch rcu_process_callbacks __do_softirq call_softirq do_softirq irq_exit smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle start_kernel x86_64_start_kernel 0.03% 1 postgres [kernel.kallsyms] [k] set_page_dirty | --- set_page_dirty zap_pte_range unmap_page_range unmap_vmas exit_mmap mmput exit_mm do_exit do_group_exit sys_exit_group system_call_fastpath 0x7fb873d90a38 0.03% 1 postgres [kernel.kallsyms] [k] rw_verify_area | --- rw_verify_area vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.03% 1 postgres [kernel.kallsyms] [k] find_vma | --- find_vma do_page_fault page_fault 0x7fb873d619d3 _int_malloc (nil) 0.03% 1 postgres [kernel.kallsyms] [k] __set_page_dirty_no_writeback | --- __set_page_dirty_no_writeback zap_pte_range unmap_page_range unmap_vmas exit_mmap mmput exit_mm do_exit do_group_exit sys_exit_group system_call_fastpath 0x7fb873d90a38 0.03% 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.03% 1 postgres [kernel.kallsyms] [k] mem_cgroup_newpage_charge | --- mem_cgroup_newpage_charge do_anonymous_page do_page_fault page_fault 0x7fb873d61c12 _int_malloc 0.03% 1 postgres [kernel.kallsyms] [k] restore_args | --- restore_args 0x7fb873d619d3 _int_malloc (nil) 0.03% 1 postgres [kernel.kallsyms] [k] mem_cgroup_add_lru_list | --- mem_cgroup_add_lru_list pagevec_lru_move_fn __lru_cache_add do_anonymous_page do_page_fault page_fault 0x7fb873d6c834 __GI_memcpy 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 0.03% 1 postgres [kernel.kallsyms] [k] common_file_perm | --- common_file_perm security_file_permission rw_verify_area vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.03% 1 postgres postgres [.] ExecSeqScan | --- ExecSeqScan ExecProcNode 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 0.03% 1 postgres postgres [.] int4eq | --- int4eq ExecQual 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 0.03% 1 postgres postgres [.] memcpy@plt | --- memcpy@plt heap_form_minimal_tuple ExecFetchSlotMinimalTuple ExecHashTableInsert 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 0.03% 1 postgres postgres [.] DataChecksumsEnabled | --- DataChecksumsEnabled PageIsVerified ReadBuffer_common ReadBufferExtended heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode 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 0.03% 1 postgres postgres [.] isTempToastNamespace | --- isTempToastNamespace IsCatalogClass heap_page_prune_opt heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg 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 postgres [kernel.kallsyms] [k] fsnotify_access | --- fsnotify_access vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.03% 1 postgres [kernel.kallsyms] [k] ns_capable | --- ns_capable 0xffffffffa04aeafb 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.03% 1 postgres postgres [.] IsToastNamespace | --- IsToastNamespace heap_page_prune_opt heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg 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 postgres postgres [.] FileRead | --- FileRead mdread ReadBuffer_common ReadBufferExtended heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg 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 postgres [kernel.kallsyms] [k] system_call_fastpath | --- system_call_fastpath 0x7fb873db55d0 __GI___read 0.03% 1 postgres [kernel.kallsyms] [k] system_call | --- system_call slot_getattr ExecEvalFuncArgs heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg 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 postgres postgres [.] MemoryContextAlloc | --- MemoryContextAlloc dense_alloc ExecHashTableInsert 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 0.03% 1 postgres postgres [.] int4_sum | --- int4_sum advance_aggregates ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.03% 1 postgres postgres [.] hashint4 | --- hashint4 ExecHashGetHashValue 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 0.03% 1 postgres [kernel.kallsyms] [k] apparmor_capable | --- apparmor_capable ns_capable 0xffffffffa04aeaeb 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.03% 1 postgres [kernel.kallsyms] [k] cap_capable | --- cap_capable apparmor_capable ns_capable 0xffffffffa04aeaeb 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.03% 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.03% 1 postgres postgres [.] ss_report_location | --- ss_report_location heap_getnext SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg 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 postgres [kernel.kallsyms] [k] timespec_trunc | --- timespec_trunc current_fs_time file_update_time __do_fault handle_pte_fault do_page_fault page_fault 0x68ef14 LWLockAttemptLock LWLockAcquire heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode 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 0.03% 1 postgres [kernel.kallsyms] [k] __fsnotify_parent | --- __fsnotify_parent fsnotify_access vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.03% 1 postgres postgres [.] IsCatalogClass | --- IsCatalogClass heap_page_prune_opt heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg 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 postgres libc-2.11.3.so [.] __lseek64 | --- __lseek64 mdread ReadBuffer_common ReadBufferExtended heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg 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 postgres postgres [.] TupleHashTableMatch | --- 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.03% 1 psql [kernel.kallsyms] [k] free_pcppages_bulk | --- free_pcppages_bulk 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 0x7f7cbacd1a38 0.03% 1 postgres [kernel.kallsyms] [k] bit_spin_lock | --- bit_spin_lock __mem_cgroup_uncharge_common page_remove_rmap zap_pte_range unmap_page_range unmap_vmas unmap_region do_munmap sys_brk system_call_fastpath 0x7fb873dbb2aa __brk 0x7fb874057aa0 0x834800000000ba00 0.03% 1 postgres [kernel.kallsyms] [k] mem_cgroup_del_lru_list | --- mem_cgroup_del_lru_list release_pages free_pages_and_swap_cache tlb_flush_mmu zap_pte_range unmap_page_range unmap_vmas unmap_region do_munmap sys_brk system_call_fastpath 0x7fb873dbb2aa __brk 0x7fb874057aa0 0x834800000000ba00 0.03% 1 postgres postgres [.] FileSeek | --- FileSeek mdread ReadBuffer_common ReadBufferExtended heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg 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 postgres postgres [.] memset@plt | --- memset@plt heap_form_minimal_tuple ExecFetchSlotMinimalTuple ExecHashTableInsert 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 0.03% 1 postgres libc-2.11.3.so [.] __GI___read | --- __GI___read mdread ReadBuffer_common ReadBufferExtended heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode 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 0.03% 1 postgres [kernel.kallsyms] [k] free_pcppages_bulk | --- free_pcppages_bulk free_hot_cold_page __pagevec_free release_pages free_pages_and_swap_cache tlb_flush_mmu zap_pte_range unmap_page_range unmap_vmas unmap_region do_munmap sys_brk system_call_fastpath 0x7fb873dbb2aa __brk 0x7fb874057aa0 0x834800000000ba00 0.03% 1 postgres postgres [.] ExecStoreVirtualTuple | --- ExecStoreVirtualTuple ExecProcNode 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 0.03% 1 postgres postgres [.] CHashDelete | --- CHashDelete BufTableDelete ReadBuffer_common ReadBufferExtended heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode 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 0.03% 1 postgres postgres [.] hash_any | --- hash_any CHashSearch BufTableLookup ReadBuffer_common ReadBufferExtended heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode 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 0.03% 1 postgres [kernel.kallsyms] [k] mem_cgroup_get_reclaim_stat_from_page | --- mem_cgroup_get_reclaim_stat_from_page 0x2 __GI_memcpy 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 0.03% 1 postgres [kernel.kallsyms] [k] vfs_read | --- vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.03% 1 postgres postgres [.] date_ge | --- date_ge ExecQual ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg 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 postgres [kernel.kallsyms] [k] perf_event_mmap_event | --- perf_event_mmap_event perf_event_mmap do_brk sys_brk system_call_fastpath 0x7fb873dbb2aa __brk 0.02% 19 fail2ban-server [unknown] [.] 0x7f4657d5be85 | --- 0x7f4657d5ca2f 0x6da450 | --- 0x7f4657d5d485 0x602010 0x602010 | --- 0x7f4657d5f906 0x745e70 | --- 0x7f4657d5edf4 | --- 0x7f465710e474 0x7f4658009680 | --- 0x7f4657d5f935 0x7f4657ff3be0 | --- 0x7f4657d5d500 0x7f4658008ee0 | --- 0x7f4657d90fca 0x6500746174736c3a | --- 0x7f4657d487ed | --- 0x7f4657d80da8 | --- 0x7f4657d808a1 | --- 0x7f4657d5c96c | --- 0x7f4657d5f5c0 | --- 0x7f4657d83c19 0x7f4657ff0980 | --- 0x7f4657d80803 0x602010 0x602010 | --- 0x7f4657d52640 0x602010 0x602010 0x602010 | --- 0x7f4657d808d2 | --- 0x7f4657d5be85 | --- 0x7f4657cdbe70 0x7f4657ff3be0 0.02% 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 finish_task_switch thread_return cpu_idle 0.02% 4 swapper [kernel.kallsyms] [k] find_busiest_group | --- find_busiest_group load_balance | |--98.59%-- 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 | --1.41%-- idle_balance thread_return cpu_idle 0.02% 9 mmfsd [unknown] [.] 0x92088e | --- 0x92088e 0x2550249200 0x7ffb509d7d18 0xb10ff0d089ff4a8d | --- 0x5aec0d 0x56 | --- 0x5b6859 | --- 0x5b6851 | --- 0x5af137 0x14cd8d8 | --- 0x5d40d4 0x3600000000 0x1622b1 0x760a58b4400e936 | --- 0x113eca2 | --- 0x7ffb7c0c5098 | --- 0x5d04a8 0.01% 1 postgres [kernel.kallsyms] [k] find_busiest_group | --- find_busiest_group load_balance idle_balance thread_return schedule_hrtimeout_range_clock poll_schedule_timeout do_poll do_sys_poll sys_poll system_call_fastpath 0x7fb873db9b8f __libc_poll 0.01% 1 sadc [kernel.kallsyms] [k] __memcpy | --- __memcpy vsnprintf seq_printf show_stat seq_read proc_reg_read vfs_read sys_read system_call_fastpath 0x7fc5013625d0 __GI___read 0.01% 1 postgres postgres [.] BgBufferSync | --- BgBufferSync BackgroundWriterMain AuxiliaryProcessMain StartChildProcess reaper __restore_rt PostmasterMain main __libc_start_main 0.01% 1 postgres [kernel.kallsyms] [k] arch_get_unmapped_area_topdown | --- arch_get_unmapped_area_topdown get_unmapped_area do_mmap_pgoff sys_mmap_pgoff system_call_fastpath 0x7fb873dbfc5a __GI_mmap64 0.01% 1 mmfsd [kernel.kallsyms] [k] sys_epoll_wait | --- sys_epoll_wait system_call_fastpath 0x7ffb7c127723 0x7ffb7c127723 0.01% 3 swapper [kernel.kallsyms] [k] rb_erase | --- rb_erase | |--88.93%-- timerqueue_del | __remove_hrtimer | | | |--97.20%-- __run_hrtimer | | hrtimer_interrupt | | smp_apic_timer_interrupt | | apic_timer_interrupt | | intel_idle | | cpuidle_idle_call | | cpu_idle | | | --2.80%-- hrtimer_try_to_cancel | hrtimer_cancel | tick_nohz_restart | tick_nohz_restart_sched_tick | cpu_idle | --11.07%-- set_next_entity pick_next_task_fair __schedule cpu_idle start_kernel x86_64_start_kernel 0.01% 1 postgres [kernel.kallsyms] [k] copy_page_c | --- copy_page_c do_wp_page handle_pte_fault do_page_fault page_fault | |--76.06%-- 0x7fb873d5dfa5 | ptmalloc_unlock_all | fork_process | ServerLoop | PostmasterMain | main | __libc_start_main | --23.94%-- 0x7fb873d90793 __libc_fork fork_process ServerLoop PostmasterMain main __libc_start_main 0.01% 1 kworker/11:1 [kernel.kallsyms] [k] worker_enter_idle | --- worker_enter_idle worker_thread kthread kernel_thread_helper 0.01% 1 kworker/10:1 [kernel.kallsyms] [k] worker_thread | --- worker_thread kthread kernel_thread_helper 0.01% 1 postgres [iptable_filter] [k] iptable_filter_hook | --- iptable_filter_hook nf_iterate nf_hook_slow __ip_local_out ip_local_out ip_send_skb udp_send_skb udp_sendmsg sock_sendmsg sys_sendto system_call_fastpath 0x7fb873dc4075 __GI___send 0.01% 1 kworker/12: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.01% 1 swapper [kernel.kallsyms] [k] touch_softlockup_watchdog | --- touch_softlockup_watchdog tick_check_idle irq_enter smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.01% 1 postgres [kernel.kallsyms] [k] __netif_receive_skb | --- __netif_receive_skb process_backlog net_rx_action __do_softirq call_softirq do_softirq local_bh_enable dev_queue_xmit ip_finish_output ip_send_skb udp_send_skb udp_sendmsg sock_sendmsg sys_sendto system_call_fastpath 0x7fb873dc4075 __GI___send 0.01% 1 irqbalance [kernel.kallsyms] [k] _raw_spin_lock | --- _raw_spin_lock rcu_start_gp __rcu_process_callbacks rcu_process_callbacks __do_softirq call_softirq do_softirq irq_exit smp_apic_timer_interrupt apic_timer_interrupt __call_rcu d_kill dput __fput filp_close sys_close system_call_fastpath 0x7f398a196570 0x7f398a196570 0.00% 1 perf [kernel.kallsyms] [k] generic_exec_single | --- generic_exec_single smp_call_function_single perf_event_disable perf_event_for_each_child perf_ioctl do_vfs_ioctl sys_ioctl system_call_fastpath 0x7f8ba33dd3d7 __ioctl 0.00% 1 perf [jbd] [k] do_get_write_access | --- do_get_write_access journal_get_write_access __ext3_journal_get_write_access ext3_reserve_inode_write ext3_mark_inode_dirty ext3_dirty_inode __mark_inode_dirty ext3_new_blocks ext3_alloc_branch ext3_get_blocks_handle ext3_get_block __block_write_begin ext3_write_begin generic_perform_write generic_file_buffered_write __generic_file_aio_write generic_file_aio_write do_sync_write vfs_write sys_write system_call_fastpath 0x7f8ba5218730 __write_nocancel 0.00% 1 dbt3-pgsql-dbst [kernel.kallsyms] [k] unlock_page | --- unlock_page do_wp_page handle_pte_fault do_page_fault page_fault 0x7ffa118c2fc3 __strcpy_ssse3 0xdfdfdfdf00000000 0.00% 1 swapper [kernel.kallsyms] [k] hrtimer_interrupt | --- hrtimer_interrupt smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 postgres libc-2.11.3.so [.] __strcmp_sse42 | --- __strcmp_sse42 ClientAuthentication InitPostgres PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.00% 1 postgres postgres [.] _bt_moveright | --- _bt_moveright _bt_search _bt_first btgettuple FunctionCall2Coll index_getnext_tid index_getnext systable_getnext SearchCatCache getBaseTypeAndTypmod getBaseType find_coercion_pathway can_coerce_type func_match_argtypes func_get_detail ParseFuncOrColumn transformExprRecurse transformExpr transformTargetEntry transformTargetList transformStmt parse_analyze pg_analyze_and_rewrite BeginCopy DoCopy standard_ProcessUtility PortalRunUtility PortalRunMulti PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.00% 1 postgres postgres [.] client_read_ended | --- client_read_ended pq_recvbuf pq_getbyte PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.00% 1 swapper [kernel.kallsyms] [k] watchdog_timer_fn | --- watchdog_timer_fn __run_hrtimer hrtimer_interrupt smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 4 swapper [kernel.kallsyms] [k] tick_nohz_stop_sched_tick | --- tick_nohz_stop_sched_tick | |--95.36%-- cpu_idle | --4.64%-- irq_exit smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] native_read_tsc | --- native_read_tsc native_sched_clock sched_clock tick_nohz_stop_sched_tick irq_exit do_IRQ ret_from_intr intel_idle cpuidle_idle_call cpu_idle 0.00% 3 swapper [kernel.kallsyms] [k] _raw_spin_lock_irqsave | --- _raw_spin_lock_irqsave | |--95.74%-- __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 | --4.26%-- hrtimer_get_next_event get_next_timer_interrupt tick_nohz_stop_sched_tick cpu_idle 0.00% 1 psql [kernel.kallsyms] [k] page_fault | --- page_fault | |--54.66%-- 0x7fcbe787f3ad | _dl_relocate_object | dl_main | _dl_sysdep_start | 0x40 | --45.34%-- 0x7f77e5f0a000 __nscd_getpwuid_r pg_fe_getauthname conninfo_add_defaults PQconnectStartParams PQconnectdbParams main __libc_start_main 0.00% 1 watchdog/8 [kernel.kallsyms] [k] find_busiest_group | --- find_busiest_group load_balance idle_balance thread_return watchdog kthread kernel_thread_helper 0.00% 1 perf [jbd] [k] journal_put_journal_head | --- journal_put_journal_head journal_dirty_data ext3_journal_dirty_data walk_page_buffers ext3_ordered_write_end generic_perform_write generic_file_buffered_write __generic_file_aio_write generic_file_aio_write do_sync_write vfs_write sys_write system_call_fastpath 0x7f8ba5218730 __write_nocancel 0.00% 2 swapper [kernel.kallsyms] [k] getnstimeofday | --- getnstimeofday ktime_get_real intel_idle cpuidle_idle_call cpu_idle 0.00% 1 mmfsd [kernel.kallsyms] [k] cpumask_next_and | --- cpumask_next_and find_busiest_group load_balance idle_balance thread_return schedule_hrtimeout_range_clock ep_poll sys_epoll_wait system_call_fastpath 0x7ffb7c127723 0x7ffb7c127723 0x800000000 0.00% 3 swapper [kernel.kallsyms] [k] run_timer_softirq | --- run_timer_softirq __do_softirq call_softirq do_softirq irq_exit smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 kworker/13:1 [kernel.kallsyms] [k] dbs_check_cpu | --- dbs_check_cpu do_dbs_timer process_one_work worker_thread kthread kernel_thread_helper 0.00% 1 kworker/15:1 [kernel.kallsyms] [k] free_block | --- free_block drain_array cache_reap process_one_work worker_thread kthread kernel_thread_helper 0.00% 1 fail2ban-server [kernel.kallsyms] [k] __d_lookup_rcu | --- __d_lookup_rcu do_lookup path_lookupat do_path_lookup user_path_at_empty vfs_fstatat sys_newstat system_call_fastpath 0x7f4657157765 0x7f4657157765 0x602010 0x602010 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 0.00% 1 swapper [kernel.kallsyms] [k] do_timer | --- do_timer tick_do_update_jiffies64 tick_check_idle irq_enter smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 irqbalance [kernel.kallsyms] [k] kstat_irqs | --- kstat_irqs show_stat seq_read proc_reg_read vfs_read sys_read system_call_fastpath 0x7f398a1965d0 0x7f398a1965d0 0x7f398ad0a730 0.00% 1 irqbalance [kernel.kallsyms] [k] proc_lookup_de | --- proc_lookup_de d_alloc_and_lookup do_lookup link_path_walk path_openat do_filp_open do_sys_open system_call_fastpath 0x7f398a1961e0 0x7f398a1961e0 0xffffd374ffffd374 0.00% 1 psql [kernel.kallsyms] [k] __memset | --- __memset kmem_cache_alloc_trace perf_event_mmap_event perf_event_mmap mmap_region sys_mmap_pgoff system_call_fastpath 0x7f77d35e4c5a __GI_mmap64 0.00% 1 haveged [kernel.kallsyms] [k] idle_balance | --- idle_balance thread_return schedule_hrtimeout_range_clock poll_schedule_timeout do_select core_sys_select sys_select system_call_fastpath 0x7fbf388b4373 0x7fbf388b4373 0.00% 1 swapper [kernel.kallsyms] [k] napi_complete | --- napi_complete 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 psql ld-2.11.3.so [.] _dl_map_object_from_fd | --- _dl_map_object_from_fd _dl_map_object 0x352e6f732e656e69 0.00% 1 psql [kernel.kallsyms] [k] do_sys_open | --- do_sys_open system_call_fastpath 0x7fa2f437d1e0 __GI___open64 0.00% 1 psql [kernel.kallsyms] [k] _raw_spin_lock | --- _raw_spin_lock __do_fault handle_pte_fault do_page_fault page_fault 0x7f77e68643b8 _dl_relocate_object dl_main _dl_sysdep_start 0x40 0.00% 1 swapper [iptable_nat] [k] nf_nat_local_fn | --- nf_nat_local_fn nf_iterate nf_hook_slow __ip_local_out ip_local_out ip_queue_xmit tcp_transmit_skb 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 irqbalance [kernel.kallsyms] [k] show_interrupts | --- show_interrupts seq_read proc_reg_read vfs_read sys_read system_call_fastpath 0x7f398a1965d0 0x7f398a1965d0 0.00% 1 irqbalance [kernel.kallsyms] [k] _raw_spin_lock_irq | --- _raw_spin_lock_irq end_writeback proc_evict_inode evict d_kill dput __fput filp_close sys_close system_call_fastpath 0x7f398a196570 0x7f398a196570 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 haveged [kernel.kallsyms] [k] pick_next_task_fair | --- pick_next_task_fair __schedule schedule_hrtimeout_range_clock poll_schedule_timeout do_select core_sys_select sys_select system_call_fastpath 0x7fbf388b4373 0x7fbf388b4373 0.00% 2 swapper [kernel.kallsyms] [k] __schedule | --- __schedule cpu_idle | --100.00%-- start_kernel x86_64_start_kernel 0.00% 1 sadc [kernel.kallsyms] [k] format_decode | --- format_decode vsnprintf seq_printf show_stat seq_read proc_reg_read vfs_read sys_read system_call_fastpath 0x7fc5013625d0 __GI___read 0.00% 2 swapper [kernel.kallsyms] [k] thread_return | --- thread_return cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] lock_hrtimer_base | --- lock_hrtimer_base __hrtimer_start_range_ns tick_nohz_restart tick_nohz_restart_sched_tick cpu_idle start_kernel x86_64_start_kernel 0.00% 1 swapper [kernel.kallsyms] [k] __switch_to | --- __switch_to thread_return 0xffff881f90a1a000 0.00% 1 swapper [kernel.kallsyms] [k] _raw_spin_lock | --- _raw_spin_lock do_sched_rt_period_timer sched_rt_period_timer __run_hrtimer hrtimer_interrupt smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle start_kernel x86_64_start_kernel 0.00% 1 swapper [kernel.kallsyms] [k] irq_exit | --- irq_exit do_IRQ ret_from_intr __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] 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] menu_select | --- menu_select cpuidle_idle_call cpu_idle start_kernel x86_64_start_kernel 0.00% 1 fail2ban-server [kernel.kallsyms] [k] finish_task_switch | --- finish_task_switch thread_return schedule_hrtimeout_range_clock poll_schedule_timeout do_select core_sys_select sys_select system_call_fastpath 0x7f465715f393 0x7f465715f393 0x310000002e 0.00% 3 swapper [kernel.kallsyms] [k] rcu_needs_cpu | --- rcu_needs_cpu tick_nohz_stop_sched_tick | |--84.10%-- irq_exit | smp_apic_timer_interrupt | apic_timer_interrupt | intel_idle | cpuidle_idle_call | cpu_idle | --15.90%-- cpu_idle start_kernel x86_64_start_kernel 0.00% 1 swapper [kernel.kallsyms] [k] tick_do_update_jiffies64 | --- tick_do_update_jiffies64 tick_check_idle irq_enter do_IRQ ret_from_intr intel_idle cpuidle_idle_call cpu_idle 0.00% 1 hald [kernel.kallsyms] [k] update_cfs_shares | --- update_cfs_shares dequeue_task_fair __schedule schedule_hrtimeout_range_clock poll_schedule_timeout do_poll do_sys_poll sys_poll system_call_fastpath 0x7f9983bbbb8f 0x7f9983bbbb8f 0x100000009 0.00% 1 swapper [nf_conntrack] [k] tcp_packet | --- 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 kworker/0:0 [ixgbe] [k] ixgbe_service_task | --- ixgbe_service_task process_one_work worker_thread kthread kernel_thread_helper 0.00% 2 fail2ban-server [kernel.kallsyms] [k] system_call_after_swapgs | --- system_call_after_swapgs | |--76.61%-- 0x7f4657157765 | 0x7f465715f393 | 0x7f4657ff0b30 | 0x7f4658007d80 | --23.39%-- 0x7f465715f393 0x7f465715f393 0x602010 0x602010 0.00% 1 postgres [kernel.kallsyms] [k] kmem_cache_alloc | --- kmem_cache_alloc __d_alloc d_alloc_pseudo create_write_pipe do_pipe_flags sys_pipe2 system_call_fastpath 0x7fb873db5f07 __GI_pipe InitProcess PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.00% 1 swapper [kernel.kallsyms] [k] read_tsc | --- read_tsc getnstimeofday ktime_get_real intel_idle cpuidle_idle_call cpu_idle 0.00% 1 psql [kernel.kallsyms] [k] perf_event_mmap_output | --- perf_event_mmap_output perf_event_mmap_ctx perf_event_mmap_event perf_event_mmap mmap_region sys_mmap_pgoff system_call_fastpath 0x7f77d3f7f1da mmap 0x39000 0.00% 1 psql [kernel.kallsyms] [k] __rmqueue | --- __rmqueue get_page_from_freelist __alloc_pages_nodemask alloc_pages_vma do_wp_page handle_pte_fault do_page_fault page_fault 0x7f77d3f74866 _dl_relocate_object dl_main _dl_sysdep_start 0x40 0.00% 1 kworker/2:1 [kernel.kallsyms] [k] native_read_tsc | --- native_read_tsc delay_tsc igb_read_phy_reg_mdic igb_read_phy_reg_82580 igb_update_stats igb_watchdog_task process_one_work worker_thread kthread kernel_thread_helper 0.00% 1 swapper [kernel.kallsyms] [k] rb_next | --- rb_next timerqueue_del __remove_hrtimer __hrtimer_start_range_ns tick_nohz_stop_sched_tick cpu_idle start_kernel x86_64_start_kernel 0.00% 1 haveged [kernel.kallsyms] [k] do_select | --- do_select core_sys_select sys_select system_call_fastpath 0x7fbf388b4373 0x7fbf388b4373 0.00% 1 swapper [kernel.kallsyms] [k] __remove_hrtimer | --- __remove_hrtimer hrtimer_try_to_cancel hrtimer_cancel tick_nohz_restart tick_nohz_restart_sched_tick cpu_idle 0.00% 1 mmfsd [kernel.kallsyms] [k] tcp_transmit_skb | --- 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 kjournald [kernel.kallsyms] [k] blk_rq_merge_ok | --- blk_rq_merge_ok __make_request generic_make_request submit_bio _submit_bh journal_commit_transaction kjournald kthread kernel_thread_helper 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 kworker/2:1 [kernel.kallsyms] [k] free_block | --- free_block drain_array cache_reap process_one_work worker_thread kthread kernel_thread_helper 0.00% 1 psql [kernel.kallsyms] [k] prio_tree_insert | --- prio_tree_insert vma_prio_tree_insert vma_adjust __split_vma mprotect_fixup sys_mprotect system_call_fastpath 0x7fcbe788a237 __mprotect 0x17000 0.00% 1 psql [kernel.kallsyms] [k] clear_page_c | --- clear_page_c prep_new_page get_page_from_freelist __alloc_pages_nodemask alloc_pages_current pte_alloc_one __pte_alloc handle_mm_fault do_page_fault page_fault 0x7fcbe7875147 _dl_start _dl_start_user 0.00% 1 swapper [kernel.kallsyms] [k] call_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 0.00% 1 kworker/13:1 [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_nohz_get_sleep_length | --- tick_nohz_get_sleep_length menu_select cpuidle_idle_call cpu_idle 0.00% 1 mmfsd [kernel.kallsyms] [k] __schedule | --- __schedule 0xffffffffa04a8b7d 0xffffffffa05bf0f1 0xffffffffa05c0478 0xffffffffa0605afe 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0x7ffb64ac6c10 0.00% 2 swapper [kernel.kallsyms] [k] ktime_get | --- ktime_get | |--56.43%-- tick_check_idle | irq_enter | smp_apic_timer_interrupt | apic_timer_interrupt | intel_idle | cpuidle_idle_call | cpu_idle | --43.57%-- tick_dev_program_event hrtimer_interrupt smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle start_kernel x86_64_start_kernel 0.00% 1 swapper [kernel.kallsyms] [k] update_stats_wait_end | --- update_stats_wait_end set_next_entity pick_next_task_fair __schedule cpu_idle 0.00% 2 swapper [kernel.kallsyms] [k] __atomic_notifier_call_chain | --- __atomic_notifier_call_chain | |--53.55%-- do_IRQ | ret_from_intr | intel_idle | cpuidle_idle_call | cpu_idle | --46.45%-- cpu_idle 0.00% 1 kjournald [ext3] [k] ext3_get_branch | --- ext3_get_branch ext3_get_blocks_handle ext3_get_block generic_block_bmap journal_bmap journal_commit_transaction kjournald kthread kernel_thread_helper 0.00% 1 mmfsd [kernel.kallsyms] [k] rb_insert_color | --- rb_insert_color enqueue_entity enqueue_task_fair ttwu_activate ttwu_do_activate try_to_wake_up __wake_up_common __wake_up 0xffffffffa04be300 0xffffffffa05c064a 0xffffffffa0605a42 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0x1bfffffffff 0.00% 1 mmfsd [kernel.kallsyms] [k] select_task_rq_fair | --- select_task_rq_fair try_to_wake_up __wake_up_common __wake_up 0xffffffffa04be269 0xffffffffa05c062c 0xffffffffa0605a42 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0x1bfffffffff 0.00% 1 postgres libc-2.11.3.so [.] __GI___errno_location | --- __GI___errno_location | |--58.03%-- pgstat_start | reaper | __restore_rt | PostmasterMain | main | __libc_start_main | --41.97%-- __restore_rt PostmasterMain main __libc_start_main 0.00% 1 watchdog/1 [kernel.kallsyms] [k] __dequeue_rt_entity | --- __dequeue_rt_entity dequeue_rt_entity dequeue_task_rt __schedule watchdog kthread kernel_thread_helper 0.00% 1 swapper [kernel.kallsyms] [k] cpuidle_idle_call | --- cpuidle_idle_call cpu_idle start_kernel x86_64_start_kernel 0.00% 1 swapper [kernel.kallsyms] [k] ns_to_timeval | --- ns_to_timeval intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] tick_program_event | --- tick_program_event __hrtimer_start_range_ns tick_nohz_restart tick_nohz_restart_sched_tick cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] dma_issue_pending_all | --- dma_issue_pending_all __do_softirq call_softirq do_softirq irq_exit do_IRQ ret_from_intr intel_idle cpuidle_idle_call cpu_idle 0.00% 1 postgres [kernel.kallsyms] [k] kfree | --- kfree __kfree_skb udp_recvmsg inet_recvmsg sock_recvmsg sys_recvfrom system_call_fastpath 0x7fb873dc3eb5 __libc_recv 0.00% 1 postgres [kernel.kallsyms] [k] lock_sock_fast | --- lock_sock_fast skb_free_datagram_locked udp_recvmsg inet_recvmsg sock_recvmsg sys_recvfrom system_call_fastpath 0x7fb873dc3eb5 __libc_recv 0.00% 1 postgres [kernel.kallsyms] [k] thread_return | --- thread_return __libc_poll 0.00% 1 hald [unknown] [.] 0x7f998455f5e8 | --- 0x7f998455f5e8 0x2 (nil) 0xe0001000 0.00% 1 kjournald [kernel.kallsyms] [k] cfq_rq_enqueued | --- cfq_rq_enqueued 0.00% 1 kworker/12: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 mmfsd [kernel.kallsyms] [k] find_pid_ns | --- find_pid_ns 0xffffffffa04a772a 0xffffffffa0607efc 0xffffffffa0605a42 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 (nil) 0.00% 1 swapper [kernel.kallsyms] [k] irq_entries_start | --- irq_entries_start intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] task_tick_idle | --- task_tick_idle scheduler_tick update_process_times tick_sched_timer __run_hrtimer hrtimer_interrupt smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] native_load_tls | --- native_load_tls __switch_to thread_return 0xffff881fc0efa000 0.00% 1 swapper [kernel.kallsyms] [k] __do_softirq | --- __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] native_sched_clock | --- native_sched_clock sched_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] save_args | --- save_args intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] apic_timer_interrupt | --- apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 kworker/0:0 [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] __local_bh_enable | --- __local_bh_enable irq_enter smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle start_kernel x86_64_start_kernel 0.00% 1 rpcbind [kernel.kallsyms] [k] update_curr | --- update_curr dequeue_entity dequeue_task_fair __schedule schedule_hrtimeout_range_clock poll_schedule_timeout do_poll do_sys_poll sys_poll system_call_fastpath 0x7fb534765b8f 0x7fb534765b8f (nil) 0x4f4300646e696263 0.00% 1 swapper [kernel.kallsyms] [k] sched_needs_cpu | --- sched_needs_cpu tick_nohz_stop_sched_tick cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] cpumask_next_and | --- 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] __rcu_pending | --- __rcu_pending rcu_check_callbacks update_process_times tick_sched_timer __run_hrtimer hrtimer_interrupt smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 sadc [kernel.kallsyms] [k] perf_event_mmap_ctx | --- perf_event_mmap_ctx perf_event_mmap_event perf_event_mmap mmap_region sys_mmap_pgoff system_call_fastpath 0x7fc50136cc5a __GI_mmap64 0x7fc501607560 0.00% 1 sadc [kernel.kallsyms] [k] vsnprintf | --- vsnprintf seq_printf show_stat seq_read proc_reg_read vfs_read sys_read system_call_fastpath 0x7fc5013625d0 __GI___read 0.00% 1 kworker/0:0 [kernel.kallsyms] [k] worker_thread | --- worker_thread kthread kernel_thread_helper # # (For a higher level overview, try: perf report --sort comm,dso) #