# Events: 830 cycles # # Overhead Samples Command Shared Object Symbol # ........ .......... ............... ................. ............................... # 7.43% 59 postgres postgres [.] HeapTupleSatisfiesMVCC | --- HeapTupleSatisfiesMVCC | |--98.31%-- heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | | | |--94.85%-- ExecSetParamPlan | | ExecEvalParamExec | | ExecMakeFunctionResultNoSets | | ExecQual | | 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.15%-- ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --1.69%-- BitmapHeapNext ExecScan ExecProcNode ExecNestLoop ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSetParamPlan ExecEvalParamExec ExecMakeFunctionResultNoSets ExecQual 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.80% 54 postgres [vdso] [.] 0x7fffe8fff8f5 | --- 0x7fffe8fff8f5 __gettimeofday_internal ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode | |--66.74%-- ExecSetParamPlan | ExecEvalParamExec | ExecMakeFunctionResultNoSets | ExecQual | 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.26%-- 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 | |--75.01%-- ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSetParamPlan | ExecEvalParamExec | ExecMakeFunctionResultNoSets | ExecQual | 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 | --- 0x7fffe8fff662 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode | |--75.03%-- ExecSetParamPlan | ExecEvalParamExec | ExecMakeFunctionResultNoSets | ExecQual | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --24.97%-- ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff8f9 __gettimeofday_internal ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode | |--50.10%-- ExecSetParamPlan | ExecEvalParamExec | ExecMakeFunctionResultNoSets | ExecQual | 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.90%-- ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff8d3 __gettimeofday_internal ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSetParamPlan ExecEvalParamExec ExecMakeFunctionResultNoSets ExecQual ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff8e1 __gettimeofday_internal ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode | |--66.75%-- ExecSetParamPlan | ExecEvalParamExec | ExecMakeFunctionResultNoSets | ExecQual | 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.25%-- 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 ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSetParamPlan ExecEvalParamExec ExecMakeFunctionResultNoSets ExecQual 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 ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSetParamPlan ExecEvalParamExec ExecMakeFunctionResultNoSets ExecQual 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 ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSetParamPlan ExecEvalParamExec ExecMakeFunctionResultNoSets ExecQual ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff648 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode | |--50.03%-- ExecSetParamPlan | ExecEvalParamExec | ExecMakeFunctionResultNoSets | ExecQual | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.97%-- 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 ExecHashJoin ExecProcNode ExecAgg ExecProcNode | |--50.05%-- ExecSetParamPlan | ExecEvalParamExec | ExecMakeFunctionResultNoSets | ExecQual | 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%-- 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 ExecHashJoin ExecProcNode ExecAgg ExecProcNode | |--50.07%-- ExecSetParamPlan | ExecEvalParamExec | ExecMakeFunctionResultNoSets | ExecQual | 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%-- 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 ExecHashJoin ExecProcNode ExecAgg ExecProcNode | |--50.08%-- ExecSetParamPlan | ExecEvalParamExec | ExecMakeFunctionResultNoSets | ExecQual | 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%-- ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff6ae 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecHashJoin ExecProcNode 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 ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff640 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSetParamPlan ExecEvalParamExec ExecMakeFunctionResultNoSets ExecQual ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff8ee __gettimeofday_internal ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSetParamPlan ExecEvalParamExec ExecMakeFunctionResultNoSets ExecQual ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff601 __gettimeofday_internal ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSetParamPlan ExecEvalParamExec ExecMakeFunctionResultNoSets ExecQual ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff606 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSetParamPlan ExecEvalParamExec ExecMakeFunctionResultNoSets ExecQual ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff8d8 __gettimeofday_internal ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSetParamPlan ExecEvalParamExec ExecMakeFunctionResultNoSets ExecQual ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff8fc __gettimeofday_internal ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSetParamPlan ExecEvalParamExec ExecMakeFunctionResultNoSets ExecQual ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff631 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSetParamPlan ExecEvalParamExec ExecMakeFunctionResultNoSets ExecQual ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff900 __gettimeofday_internal ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSetParamPlan ExecEvalParamExec ExecMakeFunctionResultNoSets ExecQual ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff609 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSetParamPlan ExecEvalParamExec ExecMakeFunctionResultNoSets ExecQual 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 ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSetParamPlan ExecEvalParamExec ExecMakeFunctionResultNoSets ExecQual 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 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 ExecHashJoin ExecProcNode 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.42% 51 postgres [ipt_REJECT] [.] 0x5ef30188 | --- 0xffffffffff600188 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode | |--95.01%-- ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | | | |--55.33%-- ExecSetParamPlan | | ExecEvalParamExec | | ExecMakeFunctionResultNoSets | | ExecQual | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --44.67%-- ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --4.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 | --- 0xffffffffff60018e 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSetParamPlan ExecEvalParamExec ExecMakeFunctionResultNoSets ExecQual ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0xffffffffff600183 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSetParamPlan ExecEvalParamExec ExecMakeFunctionResultNoSets ExecQual 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 ExecHashJoin ExecProcNode ExecAgg ExecProcNode | |--66.80%-- ExecSetParamPlan | ExecEvalParamExec | ExecMakeFunctionResultNoSets | ExecQual | 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.20%-- ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0xffffffffff600191 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSetParamPlan ExecEvalParamExec ExecMakeFunctionResultNoSets ExecQual ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0xffffffffff60019e 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSetParamPlan ExecEvalParamExec ExecMakeFunctionResultNoSets ExecQual 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.17% 49 postgres [kernel.kallsyms] [k] copy_user_generic_string | --- copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 5.54% 44 postgres postgres [.] ExecScanHashBucket | --- ExecScanHashBucket ExecHashJoin ExecProcNode ExecAgg ExecProcNode | |--52.34%-- ExecSetParamPlan | ExecEvalParamExec | ExecMakeFunctionResultNoSets | ExecQual | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --47.66%-- ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 4.28% 34 postgres postgres [.] ExecHashJoin | --- ExecHashJoin | |--97.06%-- ExecProcNode | ExecAgg | ExecProcNode | | | |--54.48%-- ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --45.52%-- ExecSetParamPlan | ExecEvalParamExec | ExecMakeFunctionResultNoSets | ExecQual | 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.94%-- 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.52% 28 postgres [mmfs26] [k] 0x50ac9 | --- 0xffffffffa05e1d4d __GI___read | --- 0xffffffffa0553d70 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0514a41 0xffffffffa05701ef 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0553d0a 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa054ba60 0xffffffffa04aea2b 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05e1d6a __GI___read | --- 0xffffffffa0571539 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa051f317 0xffffffffa0560b17 0xffffffffa04aeb14 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0551578 0xffffffffa0553de1 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa053b09f 0xffffffffa0541341 0xffffffffa0570c42 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa056f17c 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05373b8 0xffffffffa0551586 0xffffffffa0553de1 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0534192 0xffffffffa0551537 0xffffffffa0553de1 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05341e3 0xffffffffa0551537 0xffffffffa0553de1 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0541904 0xffffffffa05718be 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05d75aa 0xffffffffa05540c2 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0560ac9 0xffffffffa04aeb14 0xffffffffa04c602f 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 | --- 0xffffffffa0560af1 0xffffffffa04aeb14 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0570c17 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0553cbe 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0553a92 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05718d4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 2.89% 23 postgres postgres [.] CHashBucketScan | --- CHashBucketScan | |--56.56%-- CHashSearch | BufTableLookup | ReadBuffer_common | ReadBufferExtended | heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | | | |--53.82%-- ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --46.18%-- ExecSetParamPlan | ExecEvalParamExec | ExecMakeFunctionResultNoSets | ExecQual | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --43.44%-- 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 2.64% 21 postgres postgres [.] slot_getattr | --- slot_getattr | |--90.46%-- ExecHashGetHashValue | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | | | |--57.83%-- ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --42.17%-- ExecSetParamPlan | ExecEvalParamExec | ExecMakeFunctionResultNoSets | ExecQual | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --9.54%-- ExecMakeFunctionResultNoSets ExecQual ExecScanHashBucket ExecHashJoin ExecProcNode ExecAgg ExecProcNode | |--50.01%-- ExecSetParamPlan | ExecEvalParamExec | ExecMakeFunctionResultNoSets | ExecQual | 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%-- ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 2.52% 20 postgres postgres [.] slot_deform_tuple | --- slot_deform_tuple | |--85.01%-- slot_getattr | ExecHashGetHashValue | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | | | |--53.01%-- ExecSetParamPlan | | ExecEvalParamExec | | ExecMakeFunctionResultNoSets | | ExecQual | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --46.99%-- ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --14.99%-- slot_getsomeattrs ExecProject ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 2.52% 20 postgres postgres [.] InstrStopNode | --- InstrStopNode | |--95.02%-- ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | | | |--52.57%-- ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --47.43%-- ExecSetParamPlan | ExecEvalParamExec | ExecMakeFunctionResultNoSets | ExecQual | 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.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 2.26% 18 postgres [kernel.kallsyms] [k] page_fault | --- page_fault | |--94.44%-- copy_user_generic_string | 0xffffffffa04bfedc | 0xffffffffa04c021c | 0xffffffffa0553f90 | 0xffffffffa05715f4 | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --5.56%-- 0x6777d7 StrategyGetBuffer 2.14% 17 postgres postgres [.] heapgettup_pagemode | --- heapgettup_pagemode | |--88.24%-- heap_getnext | SeqNext | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | | | |--53.43%-- ExecSetParamPlan | | ExecEvalParamExec | | ExecMakeFunctionResultNoSets | | ExecQual | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --46.57%-- ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --11.76%-- 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 2.14% 17 postgres [mmfslinux] [k] 0x20066 | --- 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 | --- 0xffffffffa04aa75c 0xffffffffa04c01d0 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04a89d8 0xffffffffa054b712 0xffffffffa056f34a 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 2.01% 16 postgres postgres [.] hash_uint32 | --- hash_uint32 | |--87.50%-- ExecHashGetHashValue | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | | | |--71.37%-- ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --28.63%-- ExecSetParamPlan | ExecEvalParamExec | ExecMakeFunctionResultNoSets | ExecQual | 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.50%-- FunctionCall1Coll ExecHashGetHashValue ExecHashJoin ExecProcNode ExecAgg ExecProcNode | |--50.12%-- ExecSetParamPlan | ExecEvalParamExec | ExecMakeFunctionResultNoSets | ExecQual | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.88%-- ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.89% 15 postgres postgres [.] ExecHashGetHashValue | --- ExecHashGetHashValue ExecHashJoin ExecProcNode ExecAgg ExecProcNode | |--59.93%-- ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --40.07%-- ExecSetParamPlan ExecEvalParamExec ExecMakeFunctionResultNoSets ExecQual 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.76% 14 postgres postgres [.] ExecProcNode | --- ExecProcNode | |--57.13%-- ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | | | |--50.07%-- ExecSetParamPlan | | ExecEvalParamExec | | ExecMakeFunctionResultNoSets | | ExecQual | | 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%-- ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--28.56%-- ExecProcNode | ExecAgg | ExecProcNode | | | |--50.08%-- ExecSetParamPlan | | ExecEvalParamExec | | ExecMakeFunctionResultNoSets | | ExecQual | | 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%-- ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --14.31%-- ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.74% 7 postgres [kernel.kallsyms] [k] zap_pte_range | --- zap_pte_range unmap_page_range unmap_vmas exit_mmap mmput exit_mm do_exit do_group_exit sys_exit_group system_call_fastpath 0x7fb873d90a38 1.64% 13 postgres postgres [.] InstrStartNode | --- InstrStartNode ExecProcNode | |--92.31%-- ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | | | |--66.61%-- ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --33.39%-- ExecSetParamPlan | ExecEvalParamExec | ExecMakeFunctionResultNoSets | ExecQual | 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%-- 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.63% 13 postgres postgres [.] ExecScan | --- ExecScan | |--53.86%-- ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | | | |--57.05%-- ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --42.95%-- ExecSetParamPlan | ExecEvalParamExec | ExecMakeFunctionResultNoSets | ExecQual | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --46.14%-- ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.51% 12 postgres postgres [.] CHashInsert | --- CHashInsert BufTableInsert 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 1.38% 11 postgres postgres [.] heap_getnext | --- heap_getnext SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode | |--54.49%-- ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --45.51%-- ExecSetParamPlan ExecEvalParamExec ExecMakeFunctionResultNoSets ExecQual 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.13% 9 postgres postgres [.] heap_page_prune_opt | --- heap_page_prune_opt | |--88.89%-- heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | | | |--75.03%-- ExecSetParamPlan | | ExecEvalParamExec | | ExecMakeFunctionResultNoSets | | ExecQual | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --24.97%-- ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --11.11%-- 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 1.02% 6 postgres [kernel.kallsyms] [k] mem_cgroup_update_page_stat | --- mem_cgroup_update_page_stat | |--73.85%-- __do_fault | handle_pte_fault | do_page_fault | page_fault | copy_user_generic_string | 0xffffffffa04bfedc | 0xffffffffa04c021c | 0xffffffffa0553f90 | 0xffffffffa05715f4 | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --26.15%-- zap_pte_range unmap_page_range unmap_vmas exit_mmap mmput exit_mm do_exit do_group_exit sys_exit_group system_call_fastpath 0x7fb873d90a38 1.01% 8 postgres postgres [.] LWLockAttemptLock | --- LWLockAttemptLock LWLockAcquire | |--87.48%-- heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | | | |--71.36%-- ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --28.64%-- ExecSetParamPlan | ExecEvalParamExec | ExecMakeFunctionResultNoSets | ExecQual | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --12.52%-- StartBufferIO 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 1.01% 8 postgres postgres [.] hash_search_with_hash_value | --- hash_search_with_hash_value LookupTupleHashEntry ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.88% 7 postgres postgres [.] SeqNext | --- SeqNext | |--71.46%-- ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | | | |--59.93%-- ExecSetParamPlan | | ExecEvalParamExec | | ExecMakeFunctionResultNoSets | | ExecQual | | 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.07%-- ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --28.54%-- ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode | |--50.01%-- ExecSetParamPlan | ExecEvalParamExec | ExecMakeFunctionResultNoSets | ExecQual | 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%-- ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.88% 7 postgres postgres [.] heapgetpage | --- heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode | |--57.09%-- ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --42.91%-- ExecSetParamPlan ExecEvalParamExec ExecMakeFunctionResultNoSets ExecQual ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.84% 1 postgres [kernel.kallsyms] [k] mem_cgroup_count_vm_event | --- mem_cgroup_count_vm_event handle_mm_fault do_page_fault page_fault | |--84.99%-- 0x7fb873d619d3 | _int_malloc | (nil) | --15.01%-- copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.77% 1 psql ld-2.11.3.so [.] strcmp | --- strcmp 0x2e34362d3638782d 0.76% 1 psql [kernel.kallsyms] [k] __lru_cache_add | --- __lru_cache_add do_wp_page handle_pte_fault do_page_fault page_fault 0x7f0de5d86938 _dl_map_object_from_fd _dl_map_object 0x3031676f6c0036 0.76% 6 postgres postgres [.] ExecHashGetSkewBucket | --- ExecHashGetSkewBucket ExecProcNode ExecAgg ExecProcNode | |--66.62%-- ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --33.38%-- ExecSetParamPlan ExecEvalParamExec ExecMakeFunctionResultNoSets ExecQual ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.73% 1 psql [kernel.kallsyms] [k] current_kernel_time | --- current_kernel_time current_fs_time touch_atime generic_file_mmap mmap_region sys_mmap_pgoff system_call_fastpath 0x7f512ad971da mmap 0x39000 0.67% 6 mmfsd [unknown] [.] 0x78aeff | --- 0x78aeff 0x3000000000 | --- 0x5d4311 0xbf850fc68941 | --- 0x931b4b 0x7ffb78c1d478 (nil) (nil) 0.63% 5 postgres postgres [.] ExecStoreTuple | --- ExecStoreTuple | |--60.04%-- SeqNext | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSetParamPlan | ExecEvalParamExec | ExecMakeFunctionResultNoSets | ExecQual | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --39.96%-- ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode | |--50.07%-- ExecSetParamPlan | ExecEvalParamExec | ExecMakeFunctionResultNoSets | ExecQual | 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%-- ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.63% 5 postgres postgres [.] XidInMVCCSnapshot | --- XidInMVCCSnapshot HeapTupleSatisfiesMVCC heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode | |--60.08%-- ExecSetParamPlan | ExecEvalParamExec | ExecMakeFunctionResultNoSets | ExecQual | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --39.92%-- ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.63% 5 postgres postgres [.] ExecEvalScalarVarFast | --- ExecEvalScalarVarFast | |--40.02%-- ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | | | |--50.11%-- ExecSetParamPlan | | ExecEvalParamExec | | ExecMakeFunctionResultNoSets | | ExecQual | | 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.89%-- ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--20.06%-- ExecHashGetHashValue | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSetParamPlan | ExecEvalParamExec | ExecMakeFunctionResultNoSets | ExecQual | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--19.97%-- 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 | --19.95%-- 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.57% 1 postgres [kernel.kallsyms] [k] find_get_page | --- find_get_page find_lock_page shmem_getpage_gfp shmem_fault __do_fault handle_pte_fault do_page_fault page_fault | |--88.75%-- copy_user_generic_string | 0xffffffffa04bfedc | 0xffffffffa04c021c | 0xffffffffa0553f90 | 0xffffffffa05715f4 | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --11.25%-- 0x4a8afe _bt_checkpage _bt_relandgetbuf _bt_getroot _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.51% 4 postgres postgres [.] StrategyGetBuffer | --- StrategyGetBuffer | |--75.18%-- 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 | --24.82%-- 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.50% 4 postgres postgres [.] PinBuffer | --- PinBuffer ReadBuffer_common ReadBufferExtended heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSetParamPlan ExecEvalParamExec ExecMakeFunctionResultNoSets ExecQual ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.50% 4 postgres [kernel.kallsyms] [k] _raw_spin_unlock_irqrestore | --- _raw_spin_unlock_irqrestore | |--74.97%-- 0xffffffffa04a89cf | 0xffffffffa051f54e | | | |--66.74%-- 0xffffffffa054182c | | 0xffffffffa05718be | | 0xffffffffa04c61ab | | vfs_read | | sys_read | | system_call_fastpath | | 0x7fb873db55d0 | | __GI___read | | | --33.26%-- 0xffffffffa053ac4a | 0xffffffffa051f34a | 0xffffffffa0560b17 | 0xffffffffa04aeb14 | 0xffffffffa04c602f | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --25.03%-- 0xffffffffa053ac7c 0xffffffffa051f34a 0xffffffffa0560b17 0xffffffffa04aeb14 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.40% 3 postgres [kernel.kallsyms] [k] page_remove_rmap | --- page_remove_rmap zap_pte_range unmap_page_range unmap_vmas exit_mmap mmput exit_mm do_exit do_group_exit sys_exit_group system_call_fastpath 0x7fb873d90a38 0.40% 3 postgres postgres [.] GetPrivateRefCountEntry | --- GetPrivateRefCountEntry | |--68.24%-- ReleaseBuffer | | | |--53.61%-- ExecClearTuple | | BitmapHeapNext | | ExecScan | | ExecProcNode | | ExecNestLoop | | 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 | | | --46.39%-- 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 | --31.76%-- PinBuffer_Locked 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.39% 3 postgres postgres [.] hash_any | --- hash_any | |--67.36%-- 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 | --32.64%-- CHashInsert BufTableInsert 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.38% 1 psql [kernel.kallsyms] [k] do_brk | --- do_brk set_brk load_elf_binary search_binary_handler do_execve_common sys_execve stub_execve 0x7ffa11853a57 0x7ffa11853a57 0.38% 3 postgres postgres [.] MemoryContextReset | --- MemoryContextReset | |--34.39%-- ExecHashGetHashValue | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--32.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 | --32.80%-- ExecProcNode ExecHashJoin ExecProcNode ExecAgg 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% 3 postgres [kernel.kallsyms] [k] do_page_fault | --- do_page_fault page_fault | |--65.84%-- copy_user_generic_string | 0xffffffffa04bfedc | 0xffffffffa04c021c | 0xffffffffa0553f90 | 0xffffffffa05715f4 | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --34.16%-- 0x782d0f CHashBucketScan 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.38% 3 postgres postgres [.] hash_seq_search | --- hash_seq_search ExecAgg 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% 3 postgres postgres [.] LockBuffer | --- LockBuffer | |--66.62%-- 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.38%-- heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSetParamPlan ExecEvalParamExec ExecMakeFunctionResultNoSets ExecQual ExecAgg 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% 3 postgres postgres [.] CheckForSerializableConflictOut | --- CheckForSerializableConflictOut | |--33.38%-- heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSetParamPlan | ExecEvalParamExec | ExecMakeFunctionResultNoSets | ExecQual | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--33.38%-- BitmapHeapNext | ExecScan | ExecProcNode | ExecNestLoop | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSetParamPlan | ExecEvalParamExec | ExecMakeFunctionResultNoSets | ExecQual | 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.24%-- 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.38% 3 postgres postgres [.] TransactionIdPrecedes | --- TransactionIdPrecedes HeapTupleSatisfiesMVCC heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode | |--66.78%-- ExecSetParamPlan | ExecEvalParamExec | ExecMakeFunctionResultNoSets | ExecQual | 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.22%-- ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.38% 3 postgres postgres [.] ExecHashGetBucketAndBatch | --- ExecHashGetBucketAndBatch ExecHashJoin ExecProcNode ExecAgg 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% 3 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.38% 1 ksoftirqd/8 [kernel.kallsyms] [k] 0xffffffff81102c04 | --- __free_pages rb_free rcu_do_batch rcu_process_callbacks __do_softirq run_ksoftirqd kthread kernel_thread_helper 0.38% 3 postgres postgres [.] heap_fill_tuple | --- heap_fill_tuple heap_form_minimal_tuple 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.38% 3 postgres libc-2.11.3.so [.] __gettimeofday_internal | --- __gettimeofday_internal ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode | |--66.56%-- ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --33.44%-- ExecSetParamPlan ExecEvalParamExec ExecMakeFunctionResultNoSets ExecQual ExecAgg 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% 1 mmfsd [kernel.kallsyms] [k] find_busiest_group | --- find_busiest_group load_balance idle_balance thread_return 0xffffffffa04a8b7d 0xffffffffa05bf0f1 0xffffffffa05c0478 0xffffffffa0605afe 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0x7ffb6402db80 0.32% 2 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.30% 1 postgres postgres [.] VirtualXactLockTableInsert | --- VirtualXactLockTableInsert StartTransactionCommand InitPostgres PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.25% 1 postgres [kernel.kallsyms] [k] release_pages | --- release_pages free_pages_and_swap_cache tlb_flush_mmu | |--50.19%-- 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.81%-- tlb_finish_mmu unmap_region do_munmap sys_munmap system_call_fastpath 0x7fb873dbfc87 __munmap 0xcaf060 0.25% 2 postgres postgres [.] gettimeofday@plt | --- gettimeofday@plt ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSetParamPlan ExecEvalParamExec ExecMakeFunctionResultNoSets ExecQual ExecAgg 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% 2 postgres postgres [.] FunctionCall1Coll | --- FunctionCall1Coll ExecHashGetHashValue ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSetParamPlan ExecEvalParamExec ExecMakeFunctionResultNoSets ExecQual ExecAgg 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% 2 postgres postgres [.] ExecStoreMinimalTuple | --- ExecStoreMinimalTuple ExecAgg 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% 2 postgres postgres [.] ReadBufferExtended | --- ReadBufferExtended heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSetParamPlan ExecEvalParamExec ExecMakeFunctionResultNoSets ExecQual ExecAgg 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% 2 postgres postgres [.] LWLockRelease | --- LWLockRelease heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode | |--50.01%-- ExecSetParamPlan | ExecEvalParamExec | ExecMakeFunctionResultNoSets | ExecQual | 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%-- ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.25% 2 postgres postgres [.] ExecSeqScan | --- ExecSeqScan | |--50.03%-- ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSetParamPlan | ExecEvalParamExec | ExecMakeFunctionResultNoSets | ExecQual | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.97%-- ExecHashJoin ExecProcNode ExecAgg 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% 2 postgres postgres [.] pgstat_end_function_usage | --- pgstat_end_function_usage ExecQual | |--50.06%-- ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.94%-- 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.25% 2 postgres [kernel.kallsyms] [k] unlock_page | --- unlock_page __do_fault handle_pte_fault do_page_fault page_fault copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.25% 2 postgres [kernel.kallsyms] [k] __do_fault | --- __do_fault handle_pte_fault do_page_fault page_fault copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.25% 2 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 copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.25% 2 postgres postgres [.] AllocSetAlloc | --- AllocSetAlloc palloc0 heap_form_minimal_tuple 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.20% 15 swapper [kernel.kallsyms] [k] intel_idle | --- intel_idle cpuidle_idle_call cpu_idle 0.17% 1 postgres postgres [.] PageIsVerified | --- PageIsVerified ReadBufferExtended BitmapHeapNext ExecScan ExecProcNode ExecNestLoop 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.15% 1 postgres [kernel.kallsyms] [k] __task_pid_nr_ns | --- __task_pid_nr_ns 0xffffffffa04bfec2 0xffffffffa04c021c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.13% 1 postgres [kernel.kallsyms] [k] handle_mm_fault | --- handle_mm_fault do_page_fault page_fault | |--94.81%-- copy_user_generic_string | 0xffffffffa04bfedc | 0xffffffffa04c021c | 0xffffffffa0553f90 | 0xffffffffa05715f4 | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --5.19%-- 0x7fb8746ef3f5 do_lookup_x 0.13% 1 postgres postgres [.] ExecMakeFunctionResultNoSets | --- ExecMakeFunctionResultNoSets ExecMakeFunctionResultNoSets ExecProject advance_aggregates ExecAgg ExecProcNode ExecSetParamPlan ExecEvalParamExec ExecMakeFunctionResultNoSets ExecQual ExecAgg 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 postgres libc-2.11.3.so [.] __GI___isnan | --- __GI___isnan float8gt ExecMakeFunctionResultNoSets ExecQual ExecAgg 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 postgres postgres [.] slot_getsomeattrs | --- slot_getsomeattrs advance_aggregates ExecAgg ExecProcNode ExecSetParamPlan ExecEvalParamExec ExecMakeFunctionResultNoSets ExecQual ExecAgg 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 postgres postgres [.] ResourceOwnerEnlargeBuffers | --- ResourceOwnerEnlargeBuffers IncrBufferRefCount ExecStoreTuple SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSetParamPlan ExecEvalParamExec ExecMakeFunctionResultNoSets ExecQual ExecAgg 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 postgres postgres [.] ExecProject | --- ExecProject ExecProcNode ExecAgg ExecProcNode ExecSetParamPlan ExecEvalParamExec ExecMakeFunctionResultNoSets ExecQual ExecAgg 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 postgres postgres [.] Float8GetDatum | --- Float8GetDatum ExecMakeFunctionResultNoSets ExecProject advance_aggregates ExecAgg ExecProcNode ExecSetParamPlan ExecEvalParamExec ExecMakeFunctionResultNoSets ExecQual ExecAgg 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 postgres postgres [.] hashint4 | --- hashint4 FunctionCall1Coll ExecHashGetHashValue ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSetParamPlan ExecEvalParamExec ExecMakeFunctionResultNoSets ExecQual ExecAgg 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 postgres [kernel.kallsyms] [k] file_update_time | --- file_update_time __do_fault handle_pte_fault do_page_fault page_fault copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.13% 1 postgres postgres [.] LWLockAcquire | --- LWLockAcquire StartBufferIO 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.13% 1 postgres postgres [.] check_stack_depth | --- check_stack_depth ExecMakeFunctionResultNoSets ExecMakeFunctionResultNoSets ExecProject advance_aggregates ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.13% 1 postgres [kernel.kallsyms] [k] shmem_getpage_gfp | --- shmem_getpage_gfp shmem_fault __do_fault handle_pte_fault do_page_fault page_fault copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.13% 1 postgres postgres [.] pgstat_init_function_usage | --- pgstat_init_function_usage ExecMakeFunctionResultNoSets ExecProject advance_aggregates ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.13% 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.13% 1 postgres postgres [.] i4tod | --- i4tod ExecMakeFunctionResultNoSets ExecProject advance_aggregates ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.13% 1 postgres libc-2.11.3.so [.] __GI___isinf | --- __GI___isinf ExecMakeFunctionResultNoSets ExecProject advance_aggregates ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.13% 1 postgres [kernel.kallsyms] [k] __mem_cgroup_commit_charge | --- __mem_cgroup_commit_charge mem_cgroup_charge_common do_anonymous_page do_page_fault page_fault 0x7fb873d6b652 __GI_memset heap_form_minimal_tuple 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.13% 1 postgres [kernel.kallsyms] [k] error_entry | --- error_entry copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.13% 1 postgres [kernel.kallsyms] [k] find_lock_page | --- find_lock_page shmem_getpage_gfp shmem_fault __do_fault handle_pte_fault do_page_fault page_fault copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.13% 1 postgres postgres [.] _mdfd_getseg | --- _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.13% 1 postgres [kernel.kallsyms] [k] __inc_zone_page_state | --- __inc_zone_page_state page_add_file_rmap __do_fault handle_pte_fault do_page_fault page_fault copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.13% 1 postgres libc-2.11.3.so [.] __GI_memcpy | --- __GI_memcpy BufTableInsert 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.13% 1 postgres [kernel.kallsyms] [k] vfs_read | --- vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.13% 1 postgres [kernel.kallsyms] [k] _raw_spin_lock | --- _raw_spin_lock __do_fault handle_pte_fault do_page_fault page_fault 0x782d0f CHashBucketScan 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.13% 1 postgres [kernel.kallsyms] [k] getnstimeofday | --- getnstimeofday 0xffffffffa04a8d10 0xffffffffa0554088 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.13% 1 postgres postgres [.] ReadBuffer_common | --- 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.13% 1 postgres [kernel.kallsyms] [k] system_call | --- system_call StrategyGetBuffer 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.13% 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.13% 1 postgres [kernel.kallsyms] [k] security_file_permission | --- security_file_permission rw_verify_area vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.13% 1 postgres [kernel.kallsyms] [k] _raw_spin_lock_irqsave | --- _raw_spin_lock_irqsave up 0xffffffffa056f364 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.13% 1 postgres postgres [.] ExecAgg | --- ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.13% 1 postgres [kernel.kallsyms] [k] __memcpy | --- __memcpy 0xffffffffa04aeab2 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.13% 1 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 0x7fb873d6b652 __GI_memset heap_form_minimal_tuple 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.10% 8 postgres postgres [.] SyncOneBuffer | --- SyncOneBuffer BgBufferSync BackgroundWriterMain AuxiliaryProcessMain StartChildProcess reaper __restore_rt PostmasterMain main __libc_start_main 0.04% 1 irqbalance [kernel.kallsyms] [k] show_interrupts | --- show_interrupts seq_read proc_reg_read vfs_read sys_read system_call_fastpath 0x7f398a1965d0 0x7f398a1965d0 0.03% 1 postgres postgres [.] BgBufferSync | --- BgBufferSync BackgroundWriterMain AuxiliaryProcessMain StartChildProcess reaper __restore_rt PostmasterMain main __libc_start_main 0.02% 1 postgres [kernel.kallsyms] [k] netif_rx | --- netif_rx loopback_xmit dev_hard_start_xmit 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.02% 1 kworker/11:1 [kernel.kallsyms] [k] find_busiest_group | --- find_busiest_group load_balance idle_balance thread_return worker_thread kthread kernel_thread_helper 0.02% 1 kworker/2:1 [igb] [k] igb_update_stats | --- igb_update_stats igb_watchdog_task process_one_work worker_thread kthread kernel_thread_helper 0.02% 2 swapper [kernel.kallsyms] [k] cpuidle_idle_call | --- cpuidle_idle_call cpu_idle 0.01% 1 swapper [kernel.kallsyms] [k] ret_from_intr | --- ret_from_intr intel_idle cpuidle_idle_call cpu_idle 0.01% 1 swapper [kernel.kallsyms] [k] _mix_pool_bytes | --- _mix_pool_bytes add_interrupt_randomness handle_irq_event_percpu handle_irq_event handle_edge_irq handle_irq do_IRQ ret_from_intr intel_idle cpuidle_idle_call cpu_idle 0.01% 1 psql libpq.so.5.8 [.] PQmblen | --- PQmblen print_aligned_text printTable printQuery SendQuery MainLoop process_file main __libc_start_main 0.01% 4 fail2ban-server [unknown] [.] 0x7f4657d48496 | --- 0x7f4657d52659 0x14042 | --- 0x7f4657d81766 | --- 0x7f4657d48496 | --- 0x7f4657d5f58e 0.01% 1 psql [kernel.kallsyms] [k] __d_lookup_rcu | --- __d_lookup_rcu do_lookup link_path_walk path_openat do_filp_open do_sys_open system_call_fastpath 0x7fcf1df821e0 __GI___open64 0.00% 1 swapper [kernel.kallsyms] [k] irq_entries_start | --- irq_entries_start intel_idle cpuidle_idle_call cpu_idle 0.00% 1 fail2ban-server [kernel.kallsyms] [k] link_path_walk | --- link_path_walk path_lookupat do_path_lookup user_path_at_empty vfs_fstatat sys_newstat system_call_fastpath 0x7f4657157765 0x7f4657157765 0x602010 0x602010 0x602010 0x602010 0x602010 0x602010 0.00% 1 swapper [kernel.kallsyms] [k] select_nohz_load_balancer | --- select_nohz_load_balancer tick_nohz_restart_sched_tick cpu_idle 0.00% 1 kworker/2:1 [kernel.kallsyms] [k] update_shares | --- update_shares idle_balance thread_return worker_thread kthread kernel_thread_helper 0.00% 1 mmfsd [kernel.kallsyms] [k] enqueue_task | --- enqueue_task ttwu_activate ttwu_do_activate 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 swapper [kernel.kallsyms] [k] cascade | --- cascade 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] hrtimer_interrupt | --- hrtimer_interrupt smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 2 swapper [kernel.kallsyms] [k] __hrtimer_start_range_ns | --- __hrtimer_start_range_ns | |--65.86%-- tick_nohz_restart | tick_nohz_restart_sched_tick | cpu_idle | --34.14%-- tick_nohz_stop_sched_tick cpu_idle 0.00% 1 mmfsd [kernel.kallsyms] [k] __sk_mem_schedule | --- __sk_mem_schedule tcp_sendmsg sock_sendmsg ___sys_sendmsg __sys_sendmsg system_call_fastpath 0x7ffb7cb55dfd 0x7ffb7cb55dfd 0.00% 1 postgres [kernel.kallsyms] [k] do_poll | --- do_poll do_sys_poll sys_poll system_call_fastpath 0x7fb873db9b8f __libc_poll 0.00% 1 kworker/3:1 [kernel.kallsyms] [k] drain_array | --- drain_array cache_reap process_one_work worker_thread kthread kernel_thread_helper 0.00% 1 swapper [ixgbe] [k] ixgbe_clean_rx_irq | --- ixgbe_clean_rx_irq ixgbe_poll net_rx_action __do_softirq call_softirq do_softirq irq_exit do_IRQ ret_from_intr intel_idle cpuidle_idle_call cpu_idle 0.00% 1 mmfsd [iptable_nat] [k] nf_nat_out | --- nf_nat_out nf_iterate nf_hook_slow ip_output ip_queue_xmit tcp_transmit_skb tcp_write_xmit __tcp_push_pending_frames tcp_sendmsg sock_sendmsg ___sys_sendmsg __sys_sendmsg system_call_fastpath 0x7ffb7cb55dfd 0x7ffb7cb55dfd 0.00% 1 fail2ban-server [kernel.kallsyms] [k] sys_futex | --- sys_futex system_call_fastpath 0x7f4657a90a40 0x7f4657a90a40 (nil) 0.00% 1 kworker/1:1 [kernel.kallsyms] [k] cache_reap | --- cache_reap process_one_work worker_thread kthread kernel_thread_helper 0.00% 2 swapper [kernel.kallsyms] [k] rcu_check_callbacks | --- rcu_check_callbacks update_process_times tick_sched_timer __run_hrtimer hrtimer_interrupt smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 postgres libc-2.11.3.so [.] __libc_poll | --- __libc_poll PgstatCollectorMain pgstat_start reaper __restore_rt PostmasterMain main __libc_start_main 0.00% 1 mmfsd [kernel.kallsyms] [k] pick_next_task_rt | --- pick_next_task_rt thread_return schedule_hrtimeout_range_clock ep_poll sys_epoll_wait system_call_fastpath 0x7ffb7c127723 0x7ffb7c127723 0x800000000 0.00% 1 mmfsd [kernel.kallsyms] [k] __task_pid_nr_ns | --- __task_pid_nr_ns 0xffffffffa04c2645 0xffffffffa0605ae4 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 0x7ffb6c014ad0 0.00% 1 swapper [kernel.kallsyms] [k] irq_enter | --- irq_enter smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] native_write_msr_safe | --- native_write_msr_safe native_apic_msr_write smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 kworker/1:1 [kernel.kallsyms] [k] native_sched_clock | --- native_sched_clock sched_clock idle_balance thread_return worker_thread kthread kernel_thread_helper 0.00% 1 swapper [kernel.kallsyms] [k] apic_timer_interrupt | --- apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] ktime_get_real | --- ktime_get_real intel_idle cpuidle_idle_call cpu_idle 0.00% 1 postgres [kernel.kallsyms] [k] remove_wait_queue | --- remove_wait_queue poll_freewait do_sys_poll sys_poll system_call_fastpath 0x7fb873db9b8f __libc_poll 0.00% 1 swapper [kernel.kallsyms] [k] __math_state_restore | --- __math_state_restore __switch_to thread_return 0xffff883f728e0000 0.00% 1 fail2ban-server [kernel.kallsyms] [k] find_busiest_group | --- find_busiest_group load_balance idle_balance thread_return schedule_hrtimeout_range_clock poll_schedule_timeout do_select core_sys_select sys_select system_call_fastpath 0x7f465715f393 0x7f465715f393 0x7f4657ff0b30 0x7f4658007d80 0.00% 1 fail2ban-server [kernel.kallsyms] [k] __d_lookup_rcu | --- __d_lookup_rcu do_lookup link_path_walk path_lookupat do_path_lookup user_path_at_empty vfs_fstatat sys_newstat system_call_fastpath 0x7f4657157765 0x7f4657157765 0x602010 0x602010 0x602010 0x602010 0x602010 0x602010 0.00% 1 swapper [kernel.kallsyms] [k] tick_check_oneshot_broadcast | --- tick_check_oneshot_broadcast tick_check_idle irq_enter smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] native_apic_msr_write | --- native_apic_msr_write smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] update_ts_time_stats | --- update_ts_time_stats tick_nohz_stop_idle tick_check_idle irq_enter smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] enqueue_entity | --- enqueue_entity enqueue_task_fair ttwu_activate ttwu_do_activate try_to_wake_up __queue_work call_timer_fn run_timer_softirq __do_softirq call_softirq do_softirq irq_exit smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] save_args | --- save_args intel_idle cpuidle_idle_call cpu_idle # # (For a higher level overview, try: perf report --sort comm,dso) #