# Events: 1K cycles # # Overhead Samples Command Shared Object Symbol # ........ .......... ............... ................. ............................... # 5.24% 60 postgres postgres [.] bttextfastcmp_c | --- bttextfastcmp_c | |--96.67%-- comparetup_heap | | | |--98.28%-- qsort_tuple | | qsort_tuple | | | | | |--94.74%-- qsort_tuple | | | | | | | |--88.89%-- qsort_tuple | | | | | | | | | |--87.50%-- qsort_tuple | | | | | | | | | | | |--76.19%-- qsort_tuple | | | | | | | | | | | | | |--65.62%-- qsort_tuple | | | | | | | | | | | | | | | |--66.67%-- qsort_tuple | | | | | | | | | | | | | | | | | |--78.57%-- qsort_tuple | | | | | | | | | | | | | | | | | | | |--63.64%-- tuplesort_performsort | | | | | | | | | | ExecSort | | | | | | | | | | ExecProcNode | | | | | | | | | | ExecAgg | | | | | | | | | | ExecProcNode | | | | | | | | | | ExecSort | | | | | | | | | | ExecProcNode | | | | | | | | | | standard_ExecutorRun | | | | | | | | | | ExplainOnePlan | | | | | | | | | | ExplainOneQuery | | | | | | | | | | ExplainQuery | | | | | | | | | | standard_ProcessUtility | | | | | | | | | | PortalRunUtility | | | | | | | | | | FillPortalStore | | | | | | | | | | PortalRun | | | | | | | | | | exec_simple_query | | | | | | | | | | PostgresMain | | | | | | | | | | ServerLoop | | | | | | | | | | PostmasterMain | | | | | | | | | | main | | | | | | | | | | __libc_start_main | | | | | | | | | | | | | | | | | | | --36.36%-- qsort_tuple | | | | | | | | | | | | | | | | | | | |--75.00%-- tuplesort_performsort | | | | | | | | | | ExecSort | | | | | | | | | | ExecProcNode | | | | | | | | | | | | | | | | | | | | | |--66.67%-- ExecAgg | | | | | | | | | | | ExecProcNode | | | | | | | | | | | ExecSort | | | | | | | | | | | ExecProcNode | | | | | | | | | | | standard_ExecutorRun | | | | | | | | | | | ExplainOnePlan | | | | | | | | | | | ExplainOneQuery | | | | | | | | | | | ExplainQuery | | | | | | | | | | | standard_ProcessUtility | | | | | | | | | | | PortalRunUtility | | | | | | | | | | | FillPortalStore | | | | | | | | | | | PortalRun | | | | | | | | | | | exec_simple_query | | | | | | | | | | | PostgresMain | | | | | | | | | | | ServerLoop | | | | | | | | | | | PostmasterMain | | | | | | | | | | | main | | | | | | | | | | | __libc_start_main | | | | | | | | | | | | | | | | | | | | | --33.33%-- standard_ExecutorRun | | | | | | | | | | ExplainOnePlan | | | | | | | | | | ExplainOneQuery | | | | | | | | | | ExplainQuery | | | | | | | | | | standard_ProcessUtility | | | | | | | | | | PortalRunUtility | | | | | | | | | | FillPortalStore | | | | | | | | | | PortalRun | | | | | | | | | | exec_simple_query | | | | | | | | | | PostgresMain | | | | | | | | | | ServerLoop | | | | | | | | | | PostmasterMain | | | | | | | | | | main | | | | | | | | | | __libc_start_main | | | | | | | | | | | | | | | | | | | --25.00%-- qsort_tuple | | | | | | | | | qsort_tuple | | | | | | | | | tuplesort_performsort | | | | | | | | | ExecSort | | | | | | | | | ExecProcNode | | | | | | | | | ExecAgg | | | | | | | | | ExecProcNode | | | | | | | | | ExecSort | | | | | | | | | ExecProcNode | | | | | | | | | standard_ExecutorRun | | | | | | | | | ExplainOnePlan | | | | | | | | | ExplainOneQuery | | | | | | | | | ExplainQuery | | | | | | | | | standard_ProcessUtility | | | | | | | | | PortalRunUtility | | | | | | | | | FillPortalStore | | | | | | | | | PortalRun | | | | | | | | | exec_simple_query | | | | | | | | | PostgresMain | | | | | | | | | ServerLoop | | | | | | | | | PostmasterMain | | | | | | | | | main | | | | | | | | | __libc_start_main | | | | | | | | | | | | | | | | | --21.43%-- tuplesort_performsort | | | | | | | | ExecSort | | | | | | | | ExecProcNode | | | | | | | | ExecAgg | | | | | | | | ExecProcNode | | | | | | | | ExecSort | | | | | | | | ExecProcNode | | | | | | | | standard_ExecutorRun | | | | | | | | ExplainOnePlan | | | | | | | | ExplainOneQuery | | | | | | | | ExplainQuery | | | | | | | | standard_ProcessUtility | | | | | | | | PortalRunUtility | | | | | | | | FillPortalStore | | | | | | | | PortalRun | | | | | | | | exec_simple_query | | | | | | | | PostgresMain | | | | | | | | ServerLoop | | | | | | | | PostmasterMain | | | | | | | | main | | | | | | | | __libc_start_main | | | | | | | | | | | | | | | --33.33%-- tuplesort_performsort | | | | | | | ExecSort | | | | | | | ExecProcNode | | | | | | | ExecAgg | | | | | | | ExecProcNode | | | | | | | ExecSort | | | | | | | ExecProcNode | | | | | | | standard_ExecutorRun | | | | | | | ExplainOnePlan | | | | | | | ExplainOneQuery | | | | | | | ExplainQuery | | | | | | | standard_ProcessUtility | | | | | | | PortalRunUtility | | | | | | | FillPortalStore | | | | | | | PortalRun | | | | | | | exec_simple_query | | | | | | | PostgresMain | | | | | | | ServerLoop | | | | | | | PostmasterMain | | | | | | | main | | | | | | | __libc_start_main | | | | | | | | | | | | | --34.38%-- tuplesort_performsort | | | | | | ExecSort | | | | | | ExecProcNode | | | | | | ExecAgg | | | | | | ExecProcNode | | | | | | ExecSort | | | | | | ExecProcNode | | | | | | standard_ExecutorRun | | | | | | ExplainOnePlan | | | | | | ExplainOneQuery | | | | | | ExplainQuery | | | | | | standard_ProcessUtility | | | | | | PortalRunUtility | | | | | | FillPortalStore | | | | | | PortalRun | | | | | | exec_simple_query | | | | | | PostgresMain | | | | | | ServerLoop | | | | | | PostmasterMain | | | | | | main | | | | | | __libc_start_main | | | | | | | | | | | --23.81%-- tuplesort_performsort | | | | | ExecSort | | | | | ExecProcNode | | | | | 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%-- tuplesort_performsort | | | | ExecSort | | | | ExecProcNode | | | | | | | | | |--83.33%-- ExecAgg | | | | | ExecProcNode | | | | | ExecSort | | | | | ExecProcNode | | | | | standard_ExecutorRun | | | | | ExplainOnePlan | | | | | ExplainOneQuery | | | | | ExplainQuery | | | | | standard_ProcessUtility | | | | | PortalRunUtility | | | | | FillPortalStore | | | | | PortalRun | | | | | exec_simple_query | | | | | PostgresMain | | | | | ServerLoop | | | | | PostmasterMain | | | | | main | | | | | __libc_start_main | | | | | | | | | --16.67%-- standard_ExecutorRun | | | | ExplainOnePlan | | | | ExplainOneQuery | | | | ExplainQuery | | | | standard_ProcessUtility | | | | PortalRunUtility | | | | FillPortalStore | | | | PortalRun | | | | exec_simple_query | | | | PostgresMain | | | | ServerLoop | | | | PostmasterMain | | | | main | | | | __libc_start_main | | | | | | | --11.11%-- tuplesort_performsort | | | ExecSort | | | ExecProcNode | | | ExecAgg | | | ExecProcNode | | | ExecSort | | | ExecProcNode | | | standard_ExecutorRun | | | ExplainOnePlan | | | ExplainOneQuery | | | ExplainQuery | | | standard_ProcessUtility | | | PortalRunUtility | | | FillPortalStore | | | PortalRun | | | exec_simple_query | | | PostgresMain | | | ServerLoop | | | PostmasterMain | | | main | | | __libc_start_main | | | | | --5.26%-- tuplesort_performsort | | ExecSort | | ExecProcNode | | 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.72%-- med3_tuple | qsort_tuple | qsort_tuple | qsort_tuple | qsort_tuple | qsort_tuple | qsort_tuple | qsort_tuple | qsort_tuple | qsort_tuple | tuplesort_performsort | ExecSort | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --3.33%-- qsort_tuple qsort_tuple qsort_tuple qsort_tuple qsort_tuple | |--50.00%-- qsort_tuple | qsort_tuple | tuplesort_performsort | ExecSort | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --50.00%-- tuplesort_performsort ExecSort ExecProcNode 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.05% 58 postgres [kernel.kallsyms] [k] copy_user_generic_string | --- copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c | |--82.77%-- 0xffffffffa0553f90 | 0xffffffffa05715f4 | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --17.23%-- 0xffffffffa0554e96 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 4.45% 51 postgres postgres [.] nocachegetattr | --- nocachegetattr | |--96.08%-- comparetup_heap | | | |--93.88%-- qsort_tuple | | qsort_tuple | | | | | |--93.48%-- qsort_tuple | | | | | | | |--97.67%-- qsort_tuple | | | | | | | | | |--80.95%-- qsort_tuple | | | | | | | | | | | |--76.47%-- qsort_tuple | | | | | | | | | | | | | |--69.23%-- qsort_tuple | | | | | | | | | | | | | | | |--61.11%-- qsort_tuple | | | | | | | | | | | | | | | | | |--90.91%-- qsort_tuple | | | | | | | | | | | | | | | | | | | |--60.00%-- qsort_tuple | | | | | | | | | | | | | | | | | | | | | |--83.33%-- qsort_tuple | | | | | | | | | | | | | | | | | | | | | | | |--60.00%-- qsort_tuple | | | | | | | | | | | | | | | | | | | | | | | | | |--66.66%-- tuplesort_performsort | | | | | | | | | | | | | ExecSort | | | | | | | | | | | | | ExecProcNode | | | | | | | | | | | | | ExecAgg | | | | | | | | | | | | | ExecProcNode | | | | | | | | | | | | | ExecSort | | | | | | | | | | | | | ExecProcNode | | | | | | | | | | | | | standard_ExecutorRun | | | | | | | | | | | | | ExplainOnePlan | | | | | | | | | | | | | ExplainOneQuery | | | | | | | | | | | | | ExplainQuery | | | | | | | | | | | | | standard_ProcessUtility | | | | | | | | | | | | | PortalRunUtility | | | | | | | | | | | | | FillPortalStore | | | | | | | | | | | | | PortalRun | | | | | | | | | | | | | exec_simple_query | | | | | | | | | | | | | PostgresMain | | | | | | | | | | | | | ServerLoop | | | | | | | | | | | | | PostmasterMain | | | | | | | | | | | | | main | | | | | | | | | | | | | __libc_start_main | | | | | | | | | | | | | | | | | | | | | | | | | --33.34%-- qsort_tuple | | | | | | | | | | | | tuplesort_performsort | | | | | | | | | | | | ExecSort | | | | | | | | | | | | ExecProcNode | | | | | | | | | | | | ExecAgg | | | | | | | | | | | | ExecProcNode | | | | | | | | | | | | ExecSort | | | | | | | | | | | | ExecProcNode | | | | | | | | | | | | standard_ExecutorRun | | | | | | | | | | | | ExplainOnePlan | | | | | | | | | | | | ExplainOneQuery | | | | | | | | | | | | ExplainQuery | | | | | | | | | | | | standard_ProcessUtility | | | | | | | | | | | | PortalRunUtility | | | | | | | | | | | | FillPortalStore | | | | | | | | | | | | PortalRun | | | | | | | | | | | | exec_simple_query | | | | | | | | | | | | PostgresMain | | | | | | | | | | | | ServerLoop | | | | | | | | | | | | PostmasterMain | | | | | | | | | | | | main | | | | | | | | | | | | __libc_start_main | | | | | | | | | | | | | | | | | | | | | | | --40.00%-- tuplesort_performsort | | | | | | | | | | | ExecSort | | | | | | | | | | | ExecProcNode | | | | | | | | | | | ExecAgg | | | | | | | | | | | ExecProcNode | | | | | | | | | | | ExecSort | | | | | | | | | | | ExecProcNode | | | | | | | | | | | standard_ExecutorRun | | | | | | | | | | | ExplainOnePlan | | | | | | | | | | | ExplainOneQuery | | | | | | | | | | | ExplainQuery | | | | | | | | | | | standard_ProcessUtility | | | | | | | | | | | PortalRunUtility | | | | | | | | | | | FillPortalStore | | | | | | | | | | | PortalRun | | | | | | | | | | | exec_simple_query | | | | | | | | | | | PostgresMain | | | | | | | | | | | ServerLoop | | | | | | | | | | | PostmasterMain | | | | | | | | | | | main | | | | | | | | | | | __libc_start_main | | | | | | | | | | | | | | | | | | | | | --16.67%-- tuplesort_performsort | | | | | | | | | | ExecSort | | | | | | | | | | ExecProcNode | | | | | | | | | | ExecAgg | | | | | | | | | | ExecProcNode | | | | | | | | | | ExecSort | | | | | | | | | | ExecProcNode | | | | | | | | | | standard_ExecutorRun | | | | | | | | | | ExplainOnePlan | | | | | | | | | | ExplainOneQuery | | | | | | | | | | ExplainQuery | | | | | | | | | | standard_ProcessUtility | | | | | | | | | | PortalRunUtility | | | | | | | | | | FillPortalStore | | | | | | | | | | PortalRun | | | | | | | | | | exec_simple_query | | | | | | | | | | PostgresMain | | | | | | | | | | ServerLoop | | | | | | | | | | PostmasterMain | | | | | | | | | | main | | | | | | | | | | __libc_start_main | | | | | | | | | | | | | | | | | | | --40.00%-- tuplesort_performsort | | | | | | | | | ExecSort | | | | | | | | | ExecProcNode | | | | | | | | | ExecAgg | | | | | | | | | ExecProcNode | | | | | | | | | ExecSort | | | | | | | | | ExecProcNode | | | | | | | | | standard_ExecutorRun | | | | | | | | | ExplainOnePlan | | | | | | | | | ExplainOneQuery | | | | | | | | | ExplainQuery | | | | | | | | | standard_ProcessUtility | | | | | | | | | PortalRunUtility | | | | | | | | | FillPortalStore | | | | | | | | | PortalRun | | | | | | | | | exec_simple_query | | | | | | | | | PostgresMain | | | | | | | | | ServerLoop | | | | | | | | | PostmasterMain | | | | | | | | | main | | | | | | | | | __libc_start_main | | | | | | | | | | | | | | | | | --9.09%-- tuplesort_performsort | | | | | | | | ExecSort | | | | | | | | ExecProcNode | | | | | | | | ExecAgg | | | | | | | | ExecProcNode | | | | | | | | ExecSort | | | | | | | | ExecProcNode | | | | | | | | standard_ExecutorRun | | | | | | | | ExplainOnePlan | | | | | | | | ExplainOneQuery | | | | | | | | ExplainQuery | | | | | | | | standard_ProcessUtility | | | | | | | | PortalRunUtility | | | | | | | | FillPortalStore | | | | | | | | PortalRun | | | | | | | | exec_simple_query | | | | | | | | PostgresMain | | | | | | | | ServerLoop | | | | | | | | PostmasterMain | | | | | | | | main | | | | | | | | __libc_start_main | | | | | | | | | | | | | | | --38.89%-- tuplesort_performsort | | | | | | | ExecSort | | | | | | | ExecProcNode | | | | | | | ExecAgg | | | | | | | ExecProcNode | | | | | | | ExecSort | | | | | | | ExecProcNode | | | | | | | standard_ExecutorRun | | | | | | | ExplainOnePlan | | | | | | | ExplainOneQuery | | | | | | | ExplainQuery | | | | | | | standard_ProcessUtility | | | | | | | PortalRunUtility | | | | | | | FillPortalStore | | | | | | | PortalRun | | | | | | | exec_simple_query | | | | | | | PostgresMain | | | | | | | ServerLoop | | | | | | | PostmasterMain | | | | | | | main | | | | | | | __libc_start_main | | | | | | | | | | | | | --30.77%-- tuplesort_performsort | | | | | | ExecSort | | | | | | ExecProcNode | | | | | | ExecAgg | | | | | | ExecProcNode | | | | | | ExecSort | | | | | | ExecProcNode | | | | | | standard_ExecutorRun | | | | | | ExplainOnePlan | | | | | | ExplainOneQuery | | | | | | ExplainQuery | | | | | | standard_ProcessUtility | | | | | | PortalRunUtility | | | | | | FillPortalStore | | | | | | PortalRun | | | | | | exec_simple_query | | | | | | PostgresMain | | | | | | ServerLoop | | | | | | PostmasterMain | | | | | | main | | | | | | __libc_start_main | | | | | | | | | | | --23.53%-- tuplesort_performsort | | | | | ExecSort | | | | | ExecProcNode | | | | | 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.05%-- tuplesort_performsort | | | | ExecSort | | | | ExecProcNode | | | | | | | | | |--87.50%-- 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%-- standard_ExecutorRun | | | | ExplainOnePlan | | | | ExplainOneQuery | | | | ExplainQuery | | | | standard_ProcessUtility | | | | PortalRunUtility | | | | FillPortalStore | | | | PortalRun | | | | exec_simple_query | | | | PostgresMain | | | | ServerLoop | | | | PostmasterMain | | | | main | | | | __libc_start_main | | | | | | | --2.33%-- tuplesort_performsort | | | ExecSort | | | ExecProcNode | | | ExecAgg | | | ExecProcNode | | | ExecSort | | | ExecProcNode | | | standard_ExecutorRun | | | ExplainOnePlan | | | ExplainOneQuery | | | ExplainQuery | | | standard_ProcessUtility | | | PortalRunUtility | | | FillPortalStore | | | PortalRun | | | exec_simple_query | | | PostgresMain | | | ServerLoop | | | PostmasterMain | | | main | | | __libc_start_main | | | | | --6.52%-- tuplesort_performsort | | ExecSort | | ExecProcNode | | 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.12%-- med3_tuple | qsort_tuple | qsort_tuple | qsort_tuple | qsort_tuple | qsort_tuple | | | |--66.67%-- qsort_tuple | | tuplesort_performsort | | ExecSort | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --33.33%-- tuplesort_performsort | ExecSort | ExecProcNode | 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.92%-- qsort_tuple qsort_tuple qsort_tuple qsort_tuple tuplesort_performsort ExecSort ExecProcNode 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.23% 46 postgres [mmfs26] [k] 0x2b0bd | --- 0xffffffffa05e1d4d | |--77.50%-- __GI___read | --22.50%-- posix_fadvise | --- 0xffffffffa053b0bd 0xffffffffa0541341 0xffffffffa0560b7f 0xffffffffa04aeb14 0xffffffffa04b9a42 __dentry_open do_last path_openat do_filp_open do_sys_open system_call_fastpath 0x7fb873db51e0 __GI___open64 0x6e7265746e695f67 | --- 0xffffffffa05d7594 0xffffffffa0555063 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0541834 0xffffffffa051f20f 0xffffffffa05a170c 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa0553dcf 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0541802 0xffffffffa05718be 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0553af6 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0551743 0xffffffffa0553de1 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0541379 0xffffffffa0560b7f 0xffffffffa04aeb14 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0603245 0xffffffffa056f3d9 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0551673 0xffffffffa0554cba 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05701df 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0560b17 0xffffffffa04aeb14 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0553d0a 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0534220 0xffffffffa0551537 0xffffffffa0553de1 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa052c606 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa05c31b9 0xffffffffa0553f55 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0537370 0xffffffffa0553de1 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05341ec 0xffffffffa0551537 0xffffffffa0553de1 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05ba691 0xffffffffa05341d7 0xffffffffa0551537 0xffffffffa0553de1 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa051f2c1 0xffffffffa0560b17 0xffffffffa04aeb14 0xffffffffa04c602f 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 | --- 0xffffffffa0554ec6 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0560b28 0xffffffffa04aeb14 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05e0937 0xffffffffa0551724 0xffffffffa0553de1 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0560b7f 0xffffffffa04aeb14 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0541939 0xffffffffa05718be 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0554c13 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05e096b 0xffffffffa0551724 0xffffffffa0553de1 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0551656 0xffffffffa0553de1 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa056f14a 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0553f84 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0551df9 0xffffffffa04aad43 0xffffffffa052df93 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa0551df5 0xffffffffa04c006c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0551e07 0xffffffffa04c006c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa0541993 0xffffffffa05718be 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa05a1885 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise 4.01% 46 postgres postgres [.] pg_detoast_datum_packed | --- pg_detoast_datum_packed | |--73.92%-- comparison_shim | comparetup_heap | qsort_tuple | | | |--82.35%-- qsort_tuple | | | | | |--82.14%-- qsort_tuple | | | | | | | |--69.57%-- qsort_tuple | | | | | | | | | |--56.24%-- tuplesort_performsort | | | | | ExecSort | | | | | ExecProcNode | | | | | 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.76%-- qsort_tuple | | | | | | | | | |--71.43%-- qsort_tuple | | | | | | | | | | | |--80.00%-- qsort_tuple | | | | | | | | | | | | | |--50.00%-- qsort_tuple | | | | | | | | | | | | | | | |--50.00%-- qsort_tuple | | | | | | | | qsort_tuple | | | | | | | | tuplesort_performsort | | | | | | | | ExecSort | | | | | | | | ExecProcNode | | | | | | | | ExecAgg | | | | | | | | ExecProcNode | | | | | | | | ExecSort | | | | | | | | ExecProcNode | | | | | | | | standard_ExecutorRun | | | | | | | | ExplainOnePlan | | | | | | | | ExplainOneQuery | | | | | | | | ExplainQuery | | | | | | | | standard_ProcessUtility | | | | | | | | PortalRunUtility | | | | | | | | FillPortalStore | | | | | | | | PortalRun | | | | | | | | exec_simple_query | | | | | | | | PostgresMain | | | | | | | | ServerLoop | | | | | | | | PostmasterMain | | | | | | | | main | | | | | | | | __libc_start_main | | | | | | | | | | | | | | | --50.00%-- tuplesort_performsort | | | | | | | ExecSort | | | | | | | ExecProcNode | | | | | | | ExecAgg | | | | | | | ExecProcNode | | | | | | | ExecSort | | | | | | | ExecProcNode | | | | | | | standard_ExecutorRun | | | | | | | ExplainOnePlan | | | | | | | ExplainOneQuery | | | | | | | ExplainQuery | | | | | | | standard_ProcessUtility | | | | | | | PortalRunUtility | | | | | | | FillPortalStore | | | | | | | PortalRun | | | | | | | exec_simple_query | | | | | | | PostgresMain | | | | | | | ServerLoop | | | | | | | PostmasterMain | | | | | | | main | | | | | | | __libc_start_main | | | | | | | | | | | | | --50.00%-- tuplesort_performsort | | | | | | ExecSort | | | | | | ExecProcNode | | | | | | ExecAgg | | | | | | ExecProcNode | | | | | | ExecSort | | | | | | ExecProcNode | | | | | | standard_ExecutorRun | | | | | | ExplainOnePlan | | | | | | ExplainOneQuery | | | | | | ExplainQuery | | | | | | standard_ProcessUtility | | | | | | PortalRunUtility | | | | | | FillPortalStore | | | | | | PortalRun | | | | | | exec_simple_query | | | | | | PostgresMain | | | | | | ServerLoop | | | | | | PostmasterMain | | | | | | main | | | | | | __libc_start_main | | | | | | | | | | | --20.00%-- tuplesort_performsort | | | | | ExecSort | | | | | ExecProcNode | | | | | ExecAgg | | | | | ExecProcNode | | | | | ExecSort | | | | | ExecProcNode | | | | | standard_ExecutorRun | | | | | ExplainOnePlan | | | | | ExplainOneQuery | | | | | ExplainQuery | | | | | standard_ProcessUtility | | | | | PortalRunUtility | | | | | FillPortalStore | | | | | PortalRun | | | | | exec_simple_query | | | | | PostgresMain | | | | | ServerLoop | | | | | PostmasterMain | | | | | main | | | | | __libc_start_main | | | | | | | | | --28.57%-- tuplesort_performsort | | | | ExecSort | | | | ExecProcNode | | | | ExecAgg | | | | ExecProcNode | | | | ExecSort | | | | ExecProcNode | | | | standard_ExecutorRun | | | | ExplainOnePlan | | | | ExplainOneQuery | | | | ExplainQuery | | | | standard_ProcessUtility | | | | PortalRunUtility | | | | FillPortalStore | | | | PortalRun | | | | exec_simple_query | | | | PostgresMain | | | | ServerLoop | | | | PostmasterMain | | | | main | | | | __libc_start_main | | | | | | | --30.43%-- tuplesort_performsort | | | ExecSort | | | ExecProcNode | | | ExecAgg | | | ExecProcNode | | | ExecSort | | | ExecProcNode | | | standard_ExecutorRun | | | ExplainOnePlan | | | ExplainOneQuery | | | ExplainQuery | | | standard_ProcessUtility | | | PortalRunUtility | | | FillPortalStore | | | PortalRun | | | exec_simple_query | | | PostgresMain | | | ServerLoop | | | PostmasterMain | | | main | | | __libc_start_main | | | | | --17.86%-- tuplesort_performsort | | ExecSort | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --17.65%-- tuplesort_performsort | ExecSort | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--6.52%-- comparetup_heap | qsort_tuple | qsort_tuple | qsort_tuple | | | |--66.66%-- qsort_tuple | | | | | |--50.00%-- qsort_tuple | | | qsort_tuple | | | qsort_tuple | | | qsort_tuple | | | tuplesort_performsort | | | ExecSort | | | ExecProcNode | | | ExecAgg | | | ExecProcNode | | | ExecSort | | | ExecProcNode | | | standard_ExecutorRun | | | ExplainOnePlan | | | ExplainOneQuery | | | ExplainQuery | | | standard_ProcessUtility | | | PortalRunUtility | | | FillPortalStore | | | PortalRun | | | exec_simple_query | | | PostgresMain | | | ServerLoop | | | PostmasterMain | | | main | | | __libc_start_main | | | | | --50.00%-- tuplesort_performsort | | ExecSort | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --33.34%-- tuplesort_performsort | ExecSort | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--6.52%-- bttextfastcmp_c | comparetup_heap | | | |--66.66%-- qsort_tuple | | | | | |--50.02%-- qsort_tuple | | | qsort_tuple | | | qsort_tuple | | | qsort_tuple | | | qsort_tuple | | | qsort_tuple | | | qsort_tuple | | | tuplesort_performsort | | | ExecSort | | | ExecProcNode | | | ExecAgg | | | ExecProcNode | | | ExecSort | | | ExecProcNode | | | standard_ExecutorRun | | | ExplainOnePlan | | | ExplainOneQuery | | | ExplainQuery | | | standard_ProcessUtility | | | PortalRunUtility | | | FillPortalStore | | | PortalRun | | | exec_simple_query | | | PostgresMain | | | ServerLoop | | | PostmasterMain | | | main | | | __libc_start_main | | | | | --49.98%-- tuplesort_performsort | | ExecSort | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --33.34%-- med3_tuple | qsort_tuple | qsort_tuple | qsort_tuple | qsort_tuple | qsort_tuple | qsort_tuple | qsort_tuple | qsort_tuple | tuplesort_performsort | ExecSort | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--6.52%-- bpcharcmp | comparison_shim | comparetup_heap | qsort_tuple | qsort_tuple | qsort_tuple | | | |--66.67%-- qsort_tuple | | qsort_tuple | | qsort_tuple | | qsort_tuple | | qsort_tuple | | | | | |--50.00%-- qsort_tuple | | | tuplesort_performsort | | | ExecSort | | | ExecProcNode | | | ExecAgg | | | ExecProcNode | | | ExecSort | | | ExecProcNode | | | standard_ExecutorRun | | | ExplainOnePlan | | | ExplainOneQuery | | | ExplainQuery | | | standard_ProcessUtility | | | PortalRunUtility | | | FillPortalStore | | | PortalRun | | | exec_simple_query | | | PostgresMain | | | ServerLoop | | | PostmasterMain | | | main | | | __libc_start_main | | | | | --50.00%-- tuplesort_performsort | | ExecSort | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --33.33%-- tuplesort_performsort | ExecSort | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--4.35%-- texteq | FunctionCall2Coll | execTuplesMatch | 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.16%-- ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode 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.84% 44 postgres postgres [.] varstr_cmp | --- varstr_cmp | |--95.46%-- bpcharcmp | comparison_shim | comparetup_heap | qsort_tuple | | | |--88.10%-- qsort_tuple | | | | | |--78.38%-- qsort_tuple | | | | | | | |--79.31%-- qsort_tuple | | | | | | | | | |--60.87%-- qsort_tuple | | | | | | | | | | | |--71.43%-- qsort_tuple | | | | | | | | | | | | | |--70.00%-- qsort_tuple | | | | | | | | | | | | | | | |--57.14%-- tuplesort_performsort | | | | | | | | ExecSort | | | | | | | | ExecProcNode | | | | | | | | ExecAgg | | | | | | | | ExecProcNode | | | | | | | | ExecSort | | | | | | | | ExecProcNode | | | | | | | | standard_ExecutorRun | | | | | | | | ExplainOnePlan | | | | | | | | ExplainOneQuery | | | | | | | | ExplainQuery | | | | | | | | standard_ProcessUtility | | | | | | | | PortalRunUtility | | | | | | | | FillPortalStore | | | | | | | | PortalRun | | | | | | | | exec_simple_query | | | | | | | | PostgresMain | | | | | | | | ServerLoop | | | | | | | | PostmasterMain | | | | | | | | main | | | | | | | | __libc_start_main | | | | | | | | | | | | | | | --42.86%-- qsort_tuple | | | | | | | | | | | | | | | |--66.66%-- tuplesort_performsort | | | | | | | | ExecSort | | | | | | | | ExecProcNode | | | | | | | | ExecAgg | | | | | | | | ExecProcNode | | | | | | | | ExecSort | | | | | | | | ExecProcNode | | | | | | | | standard_ExecutorRun | | | | | | | | ExplainOnePlan | | | | | | | | ExplainOneQuery | | | | | | | | ExplainQuery | | | | | | | | standard_ProcessUtility | | | | | | | | PortalRunUtility | | | | | | | | FillPortalStore | | | | | | | | PortalRun | | | | | | | | exec_simple_query | | | | | | | | PostgresMain | | | | | | | | ServerLoop | | | | | | | | PostmasterMain | | | | | | | | main | | | | | | | | __libc_start_main | | | | | | | | | | | | | | | --33.34%-- qsort_tuple | | | | | | | tuplesort_performsort | | | | | | | ExecSort | | | | | | | ExecProcNode | | | | | | | ExecAgg | | | | | | | ExecProcNode | | | | | | | ExecSort | | | | | | | ExecProcNode | | | | | | | standard_ExecutorRun | | | | | | | ExplainOnePlan | | | | | | | ExplainOneQuery | | | | | | | ExplainQuery | | | | | | | standard_ProcessUtility | | | | | | | PortalRunUtility | | | | | | | FillPortalStore | | | | | | | PortalRun | | | | | | | exec_simple_query | | | | | | | PostgresMain | | | | | | | ServerLoop | | | | | | | PostmasterMain | | | | | | | main | | | | | | | __libc_start_main | | | | | | | | | | | | | --30.00%-- tuplesort_performsort | | | | | | ExecSort | | | | | | ExecProcNode | | | | | | ExecAgg | | | | | | ExecProcNode | | | | | | ExecSort | | | | | | ExecProcNode | | | | | | standard_ExecutorRun | | | | | | ExplainOnePlan | | | | | | ExplainOneQuery | | | | | | ExplainQuery | | | | | | standard_ProcessUtility | | | | | | PortalRunUtility | | | | | | FillPortalStore | | | | | | PortalRun | | | | | | exec_simple_query | | | | | | PostgresMain | | | | | | ServerLoop | | | | | | PostmasterMain | | | | | | main | | | | | | __libc_start_main | | | | | | | | | | | --28.57%-- tuplesort_performsort | | | | | ExecSort | | | | | ExecProcNode | | | | | 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.13%-- tuplesort_performsort | | | | ExecSort | | | | ExecProcNode | | | | ExecAgg | | | | ExecProcNode | | | | ExecSort | | | | ExecProcNode | | | | standard_ExecutorRun | | | | ExplainOnePlan | | | | ExplainOneQuery | | | | ExplainQuery | | | | standard_ProcessUtility | | | | PortalRunUtility | | | | FillPortalStore | | | | PortalRun | | | | exec_simple_query | | | | PostgresMain | | | | ServerLoop | | | | PostmasterMain | | | | main | | | | __libc_start_main | | | | | | | --20.69%-- tuplesort_performsort | | | ExecSort | | | ExecProcNode | | | ExecAgg | | | ExecProcNode | | | ExecSort | | | ExecProcNode | | | standard_ExecutorRun | | | ExplainOnePlan | | | ExplainOneQuery | | | ExplainQuery | | | standard_ProcessUtility | | | PortalRunUtility | | | FillPortalStore | | | PortalRun | | | exec_simple_query | | | PostgresMain | | | ServerLoop | | | PostmasterMain | | | main | | | __libc_start_main | | | | | --21.62%-- tuplesort_performsort | | ExecSort | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --11.90%-- tuplesort_performsort | ExecSort | ExecProcNode | 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.54%-- comparison_shim comparetup_heap qsort_tuple qsort_tuple | |--50.03%-- qsort_tuple | qsort_tuple | qsort_tuple | qsort_tuple | tuplesort_performsort | ExecSort | ExecProcNode | 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%-- tuplesort_performsort ExecSort ExecProcNode 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.67% 42 postgres postgres [.] comparetup_heap | --- comparetup_heap | |--97.62%-- qsort_tuple | | | |--90.24%-- qsort_tuple | | | | | |--91.89%-- qsort_tuple | | | | | | | |--91.18%-- qsort_tuple | | | | | | | | | |--90.32%-- qsort_tuple | | | | | | | | | | | |--82.14%-- qsort_tuple | | | | | | | | | | | | | |--82.61%-- qsort_tuple | | | | | | | | | | | | | | | |--68.42%-- qsort_tuple | | | | | | | | | | | | | | | | | |--53.85%-- qsort_tuple | | | | | | | | | | | | | | | | | | | |--57.14%-- qsort_tuple | | | | | | | | | | | | | | | | | | | | | |--50.00%-- qsort_tuple | | | | | | | | | | | tuplesort_performsort | | | | | | | | | | | ExecSort | | | | | | | | | | | ExecProcNode | | | | | | | | | | | ExecAgg | | | | | | | | | | | ExecProcNode | | | | | | | | | | | ExecSort | | | | | | | | | | | ExecProcNode | | | | | | | | | | | standard_ExecutorRun | | | | | | | | | | | ExplainOnePlan | | | | | | | | | | | ExplainOneQuery | | | | | | | | | | | ExplainQuery | | | | | | | | | | | standard_ProcessUtility | | | | | | | | | | | PortalRunUtility | | | | | | | | | | | FillPortalStore | | | | | | | | | | | PortalRun | | | | | | | | | | | exec_simple_query | | | | | | | | | | | PostgresMain | | | | | | | | | | | ServerLoop | | | | | | | | | | | PostmasterMain | | | | | | | | | | | main | | | | | | | | | | | __libc_start_main | | | | | | | | | | | | | | | | | | | | | --50.00%-- tuplesort_performsort | | | | | | | | | | ExecSort | | | | | | | | | | ExecProcNode | | | | | | | | | | ExecAgg | | | | | | | | | | ExecProcNode | | | | | | | | | | ExecSort | | | | | | | | | | ExecProcNode | | | | | | | | | | standard_ExecutorRun | | | | | | | | | | ExplainOnePlan | | | | | | | | | | ExplainOneQuery | | | | | | | | | | ExplainQuery | | | | | | | | | | standard_ProcessUtility | | | | | | | | | | PortalRunUtility | | | | | | | | | | FillPortalStore | | | | | | | | | | PortalRun | | | | | | | | | | exec_simple_query | | | | | | | | | | PostgresMain | | | | | | | | | | ServerLoop | | | | | | | | | | PostmasterMain | | | | | | | | | | main | | | | | | | | | | __libc_start_main | | | | | | | | | | | | | | | | | | | --42.86%-- tuplesort_performsort | | | | | | | | | ExecSort | | | | | | | | | ExecProcNode | | | | | | | | | 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.15%-- tuplesort_performsort | | | | | | | | ExecSort | | | | | | | | ExecProcNode | | | | | | | | 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.58%-- tuplesort_performsort | | | | | | | ExecSort | | | | | | | ExecProcNode | | | | | | | ExecAgg | | | | | | | ExecProcNode | | | | | | | ExecSort | | | | | | | ExecProcNode | | | | | | | standard_ExecutorRun | | | | | | | ExplainOnePlan | | | | | | | ExplainOneQuery | | | | | | | ExplainQuery | | | | | | | standard_ProcessUtility | | | | | | | PortalRunUtility | | | | | | | FillPortalStore | | | | | | | PortalRun | | | | | | | exec_simple_query | | | | | | | PostgresMain | | | | | | | ServerLoop | | | | | | | PostmasterMain | | | | | | | main | | | | | | | __libc_start_main | | | | | | | | | | | | | --17.39%-- tuplesort_performsort | | | | | | ExecSort | | | | | | ExecProcNode | | | | | | ExecAgg | | | | | | ExecProcNode | | | | | | ExecSort | | | | | | ExecProcNode | | | | | | standard_ExecutorRun | | | | | | ExplainOnePlan | | | | | | ExplainOneQuery | | | | | | ExplainQuery | | | | | | standard_ProcessUtility | | | | | | PortalRunUtility | | | | | | FillPortalStore | | | | | | PortalRun | | | | | | exec_simple_query | | | | | | PostgresMain | | | | | | ServerLoop | | | | | | PostmasterMain | | | | | | main | | | | | | __libc_start_main | | | | | | | | | | | --17.86%-- tuplesort_performsort | | | | | ExecSort | | | | | ExecProcNode | | | | | | | | | | | |--80.00%-- ExecAgg | | | | | | ExecProcNode | | | | | | ExecSort | | | | | | ExecProcNode | | | | | | standard_ExecutorRun | | | | | | ExplainOnePlan | | | | | | ExplainOneQuery | | | | | | ExplainQuery | | | | | | standard_ProcessUtility | | | | | | PortalRunUtility | | | | | | FillPortalStore | | | | | | PortalRun | | | | | | exec_simple_query | | | | | | PostgresMain | | | | | | ServerLoop | | | | | | PostmasterMain | | | | | | main | | | | | | __libc_start_main | | | | | | | | | | | --20.00%-- standard_ExecutorRun | | | | | ExplainOnePlan | | | | | ExplainOneQuery | | | | | ExplainQuery | | | | | standard_ProcessUtility | | | | | PortalRunUtility | | | | | FillPortalStore | | | | | PortalRun | | | | | exec_simple_query | | | | | PostgresMain | | | | | ServerLoop | | | | | PostmasterMain | | | | | main | | | | | __libc_start_main | | | | | | | | | --9.68%-- tuplesort_performsort | | | | ExecSort | | | | ExecProcNode | | | | ExecAgg | | | | ExecProcNode | | | | ExecSort | | | | ExecProcNode | | | | standard_ExecutorRun | | | | ExplainOnePlan | | | | ExplainOneQuery | | | | ExplainQuery | | | | standard_ProcessUtility | | | | PortalRunUtility | | | | FillPortalStore | | | | PortalRun | | | | exec_simple_query | | | | PostgresMain | | | | ServerLoop | | | | PostmasterMain | | | | main | | | | __libc_start_main | | | | | | | --8.82%-- tuplesort_performsort | | | ExecSort | | | ExecProcNode | | | ExecAgg | | | ExecProcNode | | | ExecSort | | | ExecProcNode | | | standard_ExecutorRun | | | ExplainOnePlan | | | ExplainOneQuery | | | ExplainQuery | | | standard_ProcessUtility | | | PortalRunUtility | | | FillPortalStore | | | PortalRun | | | exec_simple_query | | | PostgresMain | | | ServerLoop | | | PostmasterMain | | | main | | | __libc_start_main | | | | | --8.11%-- tuplesort_performsort | | ExecSort | | ExecProcNode | | 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.76%-- tuplesort_performsort | ExecSort | ExecProcNode | 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.38%-- med3_tuple qsort_tuple qsort_tuple qsort_tuple qsort_tuple qsort_tuple qsort_tuple qsort_tuple qsort_tuple qsort_tuple tuplesort_performsort ExecSort ExecProcNode 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.48% 40 postgres postgres [.] ExecScanHashBucket | --- ExecScanHashBucket ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 3.22% 37 postgres [ipt_REJECT] [.] 0x5ef30188 | --- 0xffffffffff600188 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode | |--86.20%-- ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --13.80%-- ExecSort ExecProcNode 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 ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0xffffffffff600180 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecHashJoin ExecProcNode ExecSort ExecProcNode 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 ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0xffffffffff60018c 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0xffffffffff600191 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecHashJoin ExecProcNode ExecSort ExecProcNode 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.54% 29 postgres postgres [.] slot_deform_tuple | --- slot_deform_tuple | |--65.74%-- slot_getattr | | | |--47.77%-- ExecEvalFuncArgs | | ExecEvalScalarArrayOp | | ExecQual | | BitmapHeapNext | | ExecScan | | ExecProcNode | | MultiExecHash | | ExecHashJoin | | ExecProcNode | | ExecSort | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | |--41.79%-- execTuplesMatch | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --10.44%-- ExecMakeFunctionResultNoSets | ExecQual | ExecScanHashBucket | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --34.26%-- slot_getsomeattrs ExecProject | |--89.97%-- ExecSubPlan | ExecEvalNot | ExecQual | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --10.03%-- 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 2.35% 27 postgres postgres [.] InstrStopNode | --- InstrStopNode ExecProcNode | |--62.95%-- ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--18.54%-- ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--14.81%-- ExecSort | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --3.70%-- MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode 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.27% 26 postgres [vdso] [.] 0x7fffe8fff8d8 | --- 0x7fffe8fff8f5 __gettimeofday_internal ExecProcNode | |--79.99%-- ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --20.01%-- ExecSort ExecProcNode 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 | |--50.03%-- 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 ExecSort ExecProcNode 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 | |--50.04%-- ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.96%-- ExecSort ExecProcNode 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 ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff665 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff657 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff677 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff619 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecHashJoin ExecProcNode ExecSort ExecProcNode 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 ExecSort ExecProcNode 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 ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff60a 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecSort ExecProcNode 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 ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff6ae 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode ExecHashJoin ExecProcNode ExecSort ExecProcNode 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 ExecSort ExecProcNode 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 MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode 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.83% 21 postgres [mmfslinux] [k] 0x15493 | --- 0xffffffffa04c0066 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04c0001 | |--66.63%-- 0xffffffffa0553f90 | 0xffffffffa05715f4 | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --33.37%-- 0xffffffffa0554e96 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04bfff1 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04b5493 read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise | --- 0xffffffffa04c6159 vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04c0217 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04aeb0c 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04bfebd 0xffffffffa04c021c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04c5f9b vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04a5403 0xffffffffa0546e9d 0xffffffffa055508c 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04c005a 0xffffffffa0554e96 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04b3d04 0xffffffffa0546edd 0xffffffffa05540de 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04aeabb 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read | --- 0xffffffffa04a057f 0xffffffffa051f536 0xffffffffa054182c 0xffffffffa05718be 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 1.75% 20 postgres postgres [.] bcTruelen | --- bcTruelen | |--75.00%-- bpcharcmp | comparison_shim | comparetup_heap | | | |--93.33%-- qsort_tuple | | | | | |--78.57%-- qsort_tuple | | | | | | | |--90.91%-- qsort_tuple | | | | qsort_tuple | | | | | | | | | |--80.00%-- qsort_tuple | | | | | | | | | | | |--75.00%-- qsort_tuple | | | | | | qsort_tuple | | | | | | | | | | | | | |--50.00%-- qsort_tuple | | | | | | | | | | | | | | | |--66.67%-- qsort_tuple | | | | | | | | qsort_tuple | | | | | | | | | | | | | | | | | |--50.00%-- qsort_tuple | | | | | | | | | tuplesort_performsort | | | | | | | | | ExecSort | | | | | | | | | ExecProcNode | | | | | | | | | ExecAgg | | | | | | | | | ExecProcNode | | | | | | | | | ExecSort | | | | | | | | | ExecProcNode | | | | | | | | | standard_ExecutorRun | | | | | | | | | ExplainOnePlan | | | | | | | | | ExplainOneQuery | | | | | | | | | ExplainQuery | | | | | | | | | standard_ProcessUtility | | | | | | | | | PortalRunUtility | | | | | | | | | FillPortalStore | | | | | | | | | PortalRun | | | | | | | | | exec_simple_query | | | | | | | | | PostgresMain | | | | | | | | | ServerLoop | | | | | | | | | PostmasterMain | | | | | | | | | main | | | | | | | | | __libc_start_main | | | | | | | | | | | | | | | | | --50.00%-- tuplesort_performsort | | | | | | | | ExecSort | | | | | | | | ExecProcNode | | | | | | | | ExecAgg | | | | | | | | ExecProcNode | | | | | | | | ExecSort | | | | | | | | ExecProcNode | | | | | | | | standard_ExecutorRun | | | | | | | | ExplainOnePlan | | | | | | | | ExplainOneQuery | | | | | | | | ExplainQuery | | | | | | | | standard_ProcessUtility | | | | | | | | PortalRunUtility | | | | | | | | FillPortalStore | | | | | | | | PortalRun | | | | | | | | exec_simple_query | | | | | | | | PostgresMain | | | | | | | | ServerLoop | | | | | | | | PostmasterMain | | | | | | | | main | | | | | | | | __libc_start_main | | | | | | | | | | | | | | | --33.33%-- tuplesort_performsort | | | | | | | ExecSort | | | | | | | ExecProcNode | | | | | | | ExecAgg | | | | | | | ExecProcNode | | | | | | | ExecSort | | | | | | | ExecProcNode | | | | | | | standard_ExecutorRun | | | | | | | ExplainOnePlan | | | | | | | ExplainOneQuery | | | | | | | ExplainQuery | | | | | | | standard_ProcessUtility | | | | | | | PortalRunUtility | | | | | | | FillPortalStore | | | | | | | PortalRun | | | | | | | exec_simple_query | | | | | | | PostgresMain | | | | | | | ServerLoop | | | | | | | PostmasterMain | | | | | | | main | | | | | | | __libc_start_main | | | | | | | | | | | | | --50.00%-- tuplesort_performsort | | | | | | ExecSort | | | | | | ExecProcNode | | | | | | ExecAgg | | | | | | ExecProcNode | | | | | | ExecSort | | | | | | ExecProcNode | | | | | | standard_ExecutorRun | | | | | | ExplainOnePlan | | | | | | ExplainOneQuery | | | | | | ExplainQuery | | | | | | standard_ProcessUtility | | | | | | PortalRunUtility | | | | | | FillPortalStore | | | | | | PortalRun | | | | | | exec_simple_query | | | | | | PostgresMain | | | | | | ServerLoop | | | | | | PostmasterMain | | | | | | main | | | | | | __libc_start_main | | | | | | | | | | | --25.00%-- tuplesort_performsort | | | | | ExecSort | | | | | ExecProcNode | | | | | ExecAgg | | | | | ExecProcNode | | | | | ExecSort | | | | | ExecProcNode | | | | | standard_ExecutorRun | | | | | ExplainOnePlan | | | | | ExplainOneQuery | | | | | ExplainQuery | | | | | standard_ProcessUtility | | | | | PortalRunUtility | | | | | FillPortalStore | | | | | PortalRun | | | | | exec_simple_query | | | | | PostgresMain | | | | | ServerLoop | | | | | PostmasterMain | | | | | main | | | | | __libc_start_main | | | | | | | | | --20.00%-- tuplesort_performsort | | | | ExecSort | | | | ExecProcNode | | | | ExecAgg | | | | ExecProcNode | | | | ExecSort | | | | ExecProcNode | | | | standard_ExecutorRun | | | | ExplainOnePlan | | | | ExplainOneQuery | | | | ExplainQuery | | | | standard_ProcessUtility | | | | PortalRunUtility | | | | FillPortalStore | | | | PortalRun | | | | exec_simple_query | | | | PostgresMain | | | | ServerLoop | | | | PostmasterMain | | | | main | | | | __libc_start_main | | | | | | | --9.09%-- tuplesort_performsort | | | ExecSort | | | ExecProcNode | | | ExecAgg | | | ExecProcNode | | | ExecSort | | | ExecProcNode | | | standard_ExecutorRun | | | ExplainOnePlan | | | ExplainOneQuery | | | ExplainQuery | | | standard_ProcessUtility | | | PortalRunUtility | | | FillPortalStore | | | PortalRun | | | exec_simple_query | | | PostgresMain | | | ServerLoop | | | PostmasterMain | | | main | | | __libc_start_main | | | | | --21.43%-- tuplesort_performsort | | ExecSort | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --6.67%-- med3_tuple | qsort_tuple | qsort_tuple | qsort_tuple | qsort_tuple | qsort_tuple | qsort_tuple | qsort_tuple | qsort_tuple | qsort_tuple | tuplesort_performsort | ExecSort | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--20.00%-- comparison_shim | comparetup_heap | qsort_tuple | | | |--75.00%-- qsort_tuple | | qsort_tuple | | | | | |--66.67%-- qsort_tuple | | | qsort_tuple | | | tuplesort_performsort | | | ExecSort | | | ExecProcNode | | | ExecAgg | | | ExecProcNode | | | ExecSort | | | ExecProcNode | | | standard_ExecutorRun | | | ExplainOnePlan | | | ExplainOneQuery | | | ExplainQuery | | | standard_ProcessUtility | | | PortalRunUtility | | | FillPortalStore | | | PortalRun | | | exec_simple_query | | | PostgresMain | | | ServerLoop | | | PostmasterMain | | | main | | | __libc_start_main | | | | | --33.33%-- tuplesort_performsort | | ExecSort | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --25.00%-- tuplesort_performsort | ExecSort | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --5.00%-- bpchareq FunctionCall2Coll execTuplesMatch ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.66% 19 postgres postgres [.] ExecProject | --- ExecProject | |--63.13%-- ExecSubPlan | ExecEvalNot | ExecQual | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--10.54%-- ExecScan | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--10.54%-- 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 | |--10.52%-- ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --5.27%-- ExecEvalNot ExecQual ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecSort ExecProcNode 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.57% 18 postgres postgres [.] slot_getattr | --- slot_getattr | |--27.77%-- TupleHashTableHash | hash_search | FindTupleHashEntry | ExecSubPlan | ExecEvalNot | ExecQual | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--22.26%-- execTuplesMatch | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--22.20%-- ExecHashGetHashValue | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--16.66%-- ExecEvalFuncArgs | ExecEvalScalarArrayOp | ExecQual | BitmapHeapNext | ExecScan | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--5.56%-- ExecMakeFunctionResultNoSets | ExecQual | ExecScanHashBucket | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --5.55%-- ExecQual ExecScanHashBucket ExecHashJoin ExecProcNode ExecSort ExecProcNode 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.48% 17 postgres postgres [.] hash_search_with_hash_value | --- hash_search_with_hash_value FindTupleHashEntry ExecSubPlan ExecEvalNot ExecQual ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecSort ExecProcNode 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.48% 17 postgres postgres [.] ExecHashJoin | --- ExecHashJoin | |--94.12%-- ExecProcNode | ExecSort | ExecProcNode | 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.88%-- ExecSort ExecProcNode 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.39% 16 postgres postgres [.] ExecSubPlan | --- ExecSubPlan | |--93.74%-- ExecEvalNot | ExecQual | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --6.26%-- ExecQual ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.31% 15 postgres postgres [.] ExecStoreMinimalTuple | --- ExecStoreMinimalTuple | |--80.05%-- tuplesort_gettupleslot | ExecSort | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--13.28%-- ExecScanHashBucket | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --6.67%-- ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.31% 15 postgres postgres [.] hash_uint32 | --- hash_uint32 | |--46.65%-- TupleHashTableHash | hash_search | FindTupleHashEntry | ExecSubPlan | ExecEvalNot | ExecQual | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--26.69%-- FunctionCall1Coll | TupleHashTableHash | hash_search | FindTupleHashEntry | ExecSubPlan | ExecEvalNot | ExecQual | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --26.66%-- ExecHashGetHashValue ExecHashJoin ExecProcNode ExecSort ExecProcNode 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.23% 14 postgres [kernel.kallsyms] [k] page_fault | --- page_fault copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c | |--85.05%-- 0xffffffffa0553f90 | 0xffffffffa05715f4 | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --14.95%-- 0xffffffffa0554e96 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 1.22% 14 postgres postgres [.] CHashBucketScan | --- CHashBucketScan | |--64.28%-- CHashDelete | BufTableDelete | ReadBuffer_common | ReadBufferExtended | | | |--66.69%-- heapgetpage | | heapgettup_pagemode | | heap_getnext | | SeqNext | | ExecScan | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecSort | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --33.31%-- BitmapHeapNext | ExecScan | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --35.72%-- CHashSearch BufTableLookup | |--60.02%-- ReadBuffer_common | ReadBufferExtended | heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --39.98%-- PrefetchBuffer BitmapHeapNext ExecScan ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode 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.15% 13 postgres postgres [.] BitmapHeapNext | --- BitmapHeapNext ExecScan ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode 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% 13 postgres postgres [.] heapgettup_pagemode | --- heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecSort ExecProcNode 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.05% 12 postgres postgres [.] InstrStartNode | --- InstrStartNode | |--91.67%-- ExecProcNode | | | |--72.76%-- ExecHashJoin | | ExecProcNode | | ExecSort | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --27.24%-- ExecSort | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --8.33%-- ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.96% 11 postgres postgres [.] comparison_shim | --- comparison_shim | |--90.91%-- comparetup_heap | qsort_tuple | | | |--70.00%-- qsort_tuple | | | | | |--85.71%-- qsort_tuple | | | | | | | |--83.33%-- qsort_tuple | | | | | | | | | |--60.00%-- qsort_tuple | | | | | qsort_tuple | | | | | qsort_tuple | | | | | | | | | | | |--66.66%-- qsort_tuple | | | | | | | | | | | | | |--50.00%-- tuplesort_performsort | | | | | | | ExecSort | | | | | | | ExecProcNode | | | | | | | ExecAgg | | | | | | | ExecProcNode | | | | | | | ExecSort | | | | | | | ExecProcNode | | | | | | | standard_ExecutorRun | | | | | | | ExplainOnePlan | | | | | | | ExplainOneQuery | | | | | | | ExplainQuery | | | | | | | standard_ProcessUtility | | | | | | | PortalRunUtility | | | | | | | FillPortalStore | | | | | | | PortalRun | | | | | | | exec_simple_query | | | | | | | PostgresMain | | | | | | | ServerLoop | | | | | | | PostmasterMain | | | | | | | main | | | | | | | __libc_start_main | | | | | | | | | | | | | --50.00%-- qsort_tuple | | | | | | qsort_tuple | | | | | | qsort_tuple | | | | | | tuplesort_performsort | | | | | | ExecSort | | | | | | ExecProcNode | | | | | | ExecAgg | | | | | | ExecProcNode | | | | | | ExecSort | | | | | | ExecProcNode | | | | | | standard_ExecutorRun | | | | | | ExplainOnePlan | | | | | | ExplainOneQuery | | | | | | ExplainQuery | | | | | | standard_ProcessUtility | | | | | | PortalRunUtility | | | | | | FillPortalStore | | | | | | PortalRun | | | | | | exec_simple_query | | | | | | PostgresMain | | | | | | ServerLoop | | | | | | PostmasterMain | | | | | | main | | | | | | __libc_start_main | | | | | | | | | | | --33.34%-- tuplesort_performsort | | | | | ExecSort | | | | | ExecProcNode | | | | | ExecAgg | | | | | ExecProcNode | | | | | ExecSort | | | | | ExecProcNode | | | | | standard_ExecutorRun | | | | | ExplainOnePlan | | | | | ExplainOneQuery | | | | | ExplainQuery | | | | | standard_ProcessUtility | | | | | PortalRunUtility | | | | | FillPortalStore | | | | | PortalRun | | | | | exec_simple_query | | | | | PostgresMain | | | | | ServerLoop | | | | | PostmasterMain | | | | | main | | | | | __libc_start_main | | | | | | | | | --40.00%-- tuplesort_performsort | | | | ExecSort | | | | ExecProcNode | | | | ExecAgg | | | | ExecProcNode | | | | ExecSort | | | | ExecProcNode | | | | standard_ExecutorRun | | | | ExplainOnePlan | | | | ExplainOneQuery | | | | ExplainQuery | | | | standard_ProcessUtility | | | | PortalRunUtility | | | | FillPortalStore | | | | PortalRun | | | | exec_simple_query | | | | PostgresMain | | | | ServerLoop | | | | PostmasterMain | | | | main | | | | __libc_start_main | | | | | | | --16.67%-- tuplesort_performsort | | | ExecSort | | | ExecProcNode | | | ExecAgg | | | ExecProcNode | | | ExecSort | | | ExecProcNode | | | standard_ExecutorRun | | | ExplainOnePlan | | | ExplainOneQuery | | | ExplainQuery | | | standard_ProcessUtility | | | PortalRunUtility | | | FillPortalStore | | | PortalRun | | | exec_simple_query | | | PostgresMain | | | ServerLoop | | | PostmasterMain | | | main | | | __libc_start_main | | | | | --14.29%-- tuplesort_performsort | | ExecSort | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --30.00%-- tuplesort_performsort | ExecSort | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --9.09%-- qsort_tuple qsort_tuple qsort_tuple qsort_tuple tuplesort_performsort ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.96% 11 postgres postgres [.] ExecEvalScalarArrayOp | --- ExecEvalScalarArrayOp ExecQual BitmapHeapNext ExecScan ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.78% 9 postgres postgres [.] MemoryContextReset | --- MemoryContextReset | |--44.44%-- ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--33.33%-- ExecHashGetHashValue | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--11.12%-- ExecProcNode | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --11.11%-- ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.78% 9 postgres postgres [.] ExecHashGetHashValue | --- ExecHashGetHashValue ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg 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% 8 postgres postgres [.] CHashInsert | --- CHashInsert BufTableInsert ReadBuffer_common ReadBufferExtended | |--52.15%-- BitmapHeapNext | ExecScan | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | 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.85%-- heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.70% 8 postgres postgres [.] qsort_tuple | --- qsort_tuple qsort_tuple | |--87.50%-- qsort_tuple | | | |--71.43%-- qsort_tuple | | | | | |--80.01%-- qsort_tuple | | | | | | | |--75.00%-- qsort_tuple | | | | qsort_tuple | | | | | | | | | |--66.67%-- qsort_tuple | | | | | | | | | | | |--50.00%-- tuplesort_performsort | | | | | | ExecSort | | | | | | ExecProcNode | | | | | | ExecAgg | | | | | | ExecProcNode | | | | | | ExecSort | | | | | | ExecProcNode | | | | | | standard_ExecutorRun | | | | | | ExplainOnePlan | | | | | | ExplainOneQuery | | | | | | ExplainQuery | | | | | | standard_ProcessUtility | | | | | | PortalRunUtility | | | | | | FillPortalStore | | | | | | PortalRun | | | | | | exec_simple_query | | | | | | PostgresMain | | | | | | ServerLoop | | | | | | PostmasterMain | | | | | | main | | | | | | __libc_start_main | | | | | | | | | | | --50.00%-- qsort_tuple | | | | | tuplesort_performsort | | | | | ExecSort | | | | | ExecProcNode | | | | | ExecAgg | | | | | ExecProcNode | | | | | ExecSort | | | | | ExecProcNode | | | | | standard_ExecutorRun | | | | | ExplainOnePlan | | | | | ExplainOneQuery | | | | | ExplainQuery | | | | | standard_ProcessUtility | | | | | PortalRunUtility | | | | | FillPortalStore | | | | | PortalRun | | | | | exec_simple_query | | | | | PostgresMain | | | | | ServerLoop | | | | | PostmasterMain | | | | | main | | | | | __libc_start_main | | | | | | | | | --33.33%-- tuplesort_performsort | | | | ExecSort | | | | ExecProcNode | | | | ExecAgg | | | | ExecProcNode | | | | ExecSort | | | | ExecProcNode | | | | standard_ExecutorRun | | | | ExplainOnePlan | | | | ExplainOneQuery | | | | ExplainQuery | | | | standard_ProcessUtility | | | | PortalRunUtility | | | | FillPortalStore | | | | PortalRun | | | | exec_simple_query | | | | PostgresMain | | | | ServerLoop | | | | PostmasterMain | | | | main | | | | __libc_start_main | | | | | | | --25.00%-- tuplesort_performsort | | | ExecSort | | | ExecProcNode | | | ExecAgg | | | ExecProcNode | | | ExecSort | | | ExecProcNode | | | standard_ExecutorRun | | | ExplainOnePlan | | | ExplainOneQuery | | | ExplainQuery | | | standard_ProcessUtility | | | PortalRunUtility | | | FillPortalStore | | | PortalRun | | | exec_simple_query | | | PostgresMain | | | ServerLoop | | | PostmasterMain | | | main | | | __libc_start_main | | | | | --19.99%-- tuplesort_performsort | | ExecSort | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --28.57%-- tuplesort_performsort | ExecSort | ExecProcNode | 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%-- tuplesort_performsort ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.70% 8 postgres postgres [.] bpcharcmp | --- bpcharcmp | |--75.00%-- comparison_shim | comparetup_heap | qsort_tuple | | | |--83.33%-- qsort_tuple | | qsort_tuple | | | | | |--80.00%-- qsort_tuple | | | qsort_tuple | | | | | | | |--50.01%-- tuplesort_performsort | | | | ExecSort | | | | ExecProcNode | | | | 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%-- qsort_tuple | | | qsort_tuple | | | qsort_tuple | | | | | | | |--50.00%-- qsort_tuple | | | | qsort_tuple | | | | tuplesort_performsort | | | | ExecSort | | | | ExecProcNode | | | | ExecAgg | | | | ExecProcNode | | | | ExecSort | | | | ExecProcNode | | | | standard_ExecutorRun | | | | ExplainOnePlan | | | | ExplainOneQuery | | | | ExplainQuery | | | | standard_ProcessUtility | | | | PortalRunUtility | | | | FillPortalStore | | | | PortalRun | | | | exec_simple_query | | | | PostgresMain | | | | ServerLoop | | | | PostmasterMain | | | | main | | | | __libc_start_main | | | | | | | --50.00%-- tuplesort_performsort | | | ExecSort | | | ExecProcNode | | | ExecAgg | | | ExecProcNode | | | ExecSort | | | ExecProcNode | | | standard_ExecutorRun | | | ExplainOnePlan | | | ExplainOneQuery | | | ExplainQuery | | | standard_ProcessUtility | | | PortalRunUtility | | | FillPortalStore | | | PortalRun | | | exec_simple_query | | | PostgresMain | | | ServerLoop | | | PostmasterMain | | | main | | | __libc_start_main | | | | | --20.00%-- tuplesort_performsort | | ExecSort | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --16.67%-- tuplesort_performsort | ExecSort | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --25.00%-- comparetup_heap qsort_tuple | |--50.00%-- qsort_tuple | qsort_tuple | qsort_tuple | qsort_tuple | qsort_tuple | qsort_tuple | qsort_tuple | qsort_tuple | qsort_tuple | tuplesort_performsort | ExecSort | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --50.00%-- tuplesort_performsort ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.70% 8 postgres postgres [.] ExecClearTuple | --- ExecClearTuple | |--75.05%-- ExecProject | | | |--49.98%-- ExecSubPlan | | ExecEvalNot | | ExecQual | | ExecScan | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecSort | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | |--33.35%-- 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 | | | --16.67%-- ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --24.95%-- ExecEvalNot ExecQual ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.70% 8 postgres postgres [.] ExecEvalScalarVarFast | --- ExecEvalScalarVarFast | |--25.08%-- ExecEvalFuncArgs | ExecEvalScalarArrayOp | ExecQual | BitmapHeapNext | ExecScan | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--24.95%-- ExecEvalScalarArrayOp | ExecQual | BitmapHeapNext | ExecScan | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | 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%-- ExecHashGetHashValue | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | 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%-- ExecMakeFunctionResultNoSets | ExecQual | ExecScanHashBucket | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | 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.49%-- ExecQual | ExecScanHashBucket | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | 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.48%-- ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.70% 8 postgres postgres [.] ExecStoreTuple | --- ExecStoreTuple | |--62.52%-- SeqNext | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --37.48%-- ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.70% 8 postgres postgres [.] slot_getsomeattrs | --- slot_getsomeattrs | |--87.52%-- ExecProject | | | |--85.69%-- ExecSubPlan | | ExecEvalNot | | ExecQual | | ExecScan | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecSort | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --14.31%-- 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 | --12.48%-- ExecSubPlan ExecEvalNot ExecQual ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.70% 8 postgres postgres [.] heapgetpage | --- heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.66% 7 postgres postgres [.] hash_search | --- hash_search | |--39.42%-- FindTupleHashEntry | ExecSubPlan | ExecEvalNot | ExecQual | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | 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.40%-- ExecSubPlan | ExecEvalNot | ExecQual | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --21.18%-- tbm_mark_page_lossy tbm_add_page bringetbitmap FunctionCall2Coll index_getbitmap MultiExecBitmapIndexScan BitmapHeapNext ExecScan ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.66% 1 postgres [kernel.kallsyms] [k] 0xffffffff8111da49 | --- __tlb_remove_page zap_pte_range unmap_page_range unmap_vmas exit_mmap mmput exit_mm do_exit do_group_exit sys_exit_group system_call_fastpath 0x7fb873d90a38 0.61% 7 postgres postgres [.] ExecEvalNot | --- ExecEvalNot | |--57.11%-- ExecQual | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --42.89%-- ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.61% 7 postgres [kernel.kallsyms] [k] __memcpy | --- __memcpy 0xffffffffa04aaf69 0xffffffffa052df93 0xffffffffa059f09d 0xffffffffa05a18a9 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise 0.61% 7 postgres postgres [.] int4eq | --- int4eq ExecQual BitmapHeapNext ExecScan ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.61% 7 postgres postgres [.] ExecProcNode | --- ExecProcNode | |--42.83%-- ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--28.59%-- ExecSort | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --28.58%-- ExecProcNode | |--50.02%-- ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.98%-- ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.61% 7 postgres postgres [.] HeapTupleSatisfiesMVCC | --- HeapTupleSatisfiesMVCC heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.52% 6 postgres postgres [.] btint4fastcmp | --- btint4fastcmp | |--50.00%-- qsort_ssup | | | |--66.67%-- qsort_ssup | | tuplesort_performsort | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --33.33%-- tuplesort_performsort | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--33.33%-- qsort_tuple | qsort_tuple | qsort_tuple | qsort_tuple | qsort_tuple | qsort_tuple | qsort_tuple | qsort_tuple | | | |--50.01%-- qsort_tuple | | tuplesort_performsort | | ExecSort | | ExecProcNode | | 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%-- tuplesort_performsort | ExecSort | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --16.67%-- tuplesort_performsort ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.52% 6 postgres postgres [.] heap_fill_tuple | --- heap_fill_tuple heap_form_minimal_tuple | |--83.35%-- copytup_heap | tuplesort_puttupleslot | ExecSort | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --16.65%-- ExecFetchSlotMinimalTuple ExecHashTableInsert MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.52% 6 postgres postgres [.] FunctionCall1Coll | --- FunctionCall1Coll | |--33.38%-- ExecHashGetHashValue | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--33.30%-- TupleHashTableHash | hash_search | FindTupleHashEntry | ExecSubPlan | ExecEvalNot | ExecQual | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--16.68%-- hash_search | FindTupleHashEntry | ExecSubPlan | ExecEvalNot | ExecQual | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --16.65%-- ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.52% 6 postgres postgres [.] LWLockAttemptLock | --- LWLockAttemptLock LWLockAcquire | |--66.65%-- heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --33.35%-- StartBufferIO ReadBuffer_common ReadBufferExtended heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.51% 6 fail2ban-server [unknown] [.] 0x7f4657d8e1a7 | --- 0x7f4657d5f58e | --- 0x7f4657d484bd | --- 0x7f4657cde610 0x602010 0x602010 0x602010 0x602010 0x602010 | --- 0x7f4657d6ec40 0x6c894cfd8948f024 0.50% 2 swapper [kernel.kallsyms] [k] __schedule | --- __schedule cpu_idle | --100.00%-- start_kernel x86_64_start_kernel 0.49% 1 fail2ban-server [kernel.kallsyms] [k] timerqueue_add | --- timerqueue_add enqueue_hrtimer __hrtimer_start_range_ns schedule_hrtimeout_range_clock poll_schedule_timeout do_select core_sys_select sys_select system_call_fastpath 0x7f465715f393 0x7f465715f393 0x7f4657ff0b30 0x7f4658007d80 0.45% 5 swapper [kernel.kallsyms] [k] intel_idle | --- intel_idle cpuidle_idle_call cpu_idle | --100.00%-- start_kernel x86_64_start_kernel 0.44% 1 swapper [kernel.kallsyms] [k] __inet_lookup_established | --- __inet_lookup_established tcp_v4_rcv ip_local_deliver_finish __netif_receive_skb netif_receive_skb napi_skb_finish ixgbe_clean_rx_irq ixgbe_poll net_rx_action __do_softirq call_softirq do_softirq irq_exit do_IRQ ret_from_intr intel_idle cpuidle_idle_call cpu_idle 0.44% 5 postgres postgres [.] lc_collate_is_c | --- lc_collate_is_c bpcharcmp comparison_shim comparetup_heap qsort_tuple qsort_tuple qsort_tuple | |--80.00%-- qsort_tuple | qsort_tuple | | | |--75.00%-- qsort_tuple | | qsort_tuple | | | | | |--66.67%-- qsort_tuple | | | qsort_tuple | | | | | | | |--50.00%-- qsort_tuple | | | | tuplesort_performsort | | | | ExecSort | | | | ExecProcNode | | | | ExecAgg | | | | ExecProcNode | | | | ExecSort | | | | ExecProcNode | | | | standard_ExecutorRun | | | | ExplainOnePlan | | | | ExplainOneQuery | | | | ExplainQuery | | | | standard_ProcessUtility | | | | PortalRunUtility | | | | FillPortalStore | | | | PortalRun | | | | exec_simple_query | | | | PostgresMain | | | | ServerLoop | | | | PostmasterMain | | | | main | | | | __libc_start_main | | | | | | | --50.00%-- tuplesort_performsort | | | ExecSort | | | ExecProcNode | | | ExecAgg | | | ExecProcNode | | | ExecSort | | | ExecProcNode | | | standard_ExecutorRun | | | ExplainOnePlan | | | ExplainOneQuery | | | ExplainQuery | | | standard_ProcessUtility | | | PortalRunUtility | | | FillPortalStore | | | PortalRun | | | exec_simple_query | | | PostgresMain | | | ServerLoop | | | PostmasterMain | | | main | | | __libc_start_main | | | | | --33.33%-- tuplesort_performsort | | ExecSort | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --25.00%-- tuplesort_performsort | ExecSort | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --20.00%-- tuplesort_performsort ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.44% 5 postgres postgres [.] ExecScan | --- ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.44% 5 postgres postgres [.] heap_getnext | --- heap_getnext | |--80.04%-- SeqNext | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --19.96%-- ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.44% 5 postgres postgres [.] ExecHashTableInsert | --- ExecHashTableInsert | |--79.95%-- MultiExecHash | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --20.05%-- ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.42% 1 swapper [kernel.kallsyms] [k] ttwu_stat | --- ttwu_stat try_to_wake_up hrtimer_wakeup __run_hrtimer hrtimer_interrupt smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.41% 1 mmfsd [kernel.kallsyms] [k] local_bh_enable | --- local_bh_enable tcp_recvmsg inet_recvmsg sock_recvmsg sys_recvfrom system_call_fastpath 0x7ffb7cb55bb1 0x7ffb7cb55bb1 0x552a68a8 0.39% 3 postgres [kernel.kallsyms] [k] mem_cgroup_update_page_stat | --- mem_cgroup_update_page_stat | |--66.37%-- __do_fault | handle_pte_fault | do_page_fault | page_fault | copy_user_generic_string | 0xffffffffa04bfedc | 0xffffffffa04c021c | | | |--66.73%-- 0xffffffffa0554e96 | | 0xffffffffa056facb | | 0xffffffffa04c61ab | | vfs_read | | sys_read | | system_call_fastpath | | 0x7fb873db55d0 | | __GI___read | | | --33.27%-- 0xffffffffa0553f90 | 0xffffffffa05715f4 | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --33.63%-- 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.35% 4 postgres postgres [.] qsort_ssup | --- qsort_ssup | |--75.00%-- tuplesort_performsort | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --25.00%-- qsort_ssup tuplesort_performsort ExecAgg 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% 4 postgres postgres [.] bpchareq | --- bpchareq FunctionCall2Coll execTuplesMatch ExecAgg 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% 4 postgres postgres [.] GetPrivateRefCountEntry | --- GetPrivateRefCountEntry | |--75.00%-- IncrBufferRefCount | ExecStoreTuple | | | |--66.64%-- BitmapHeapNext | | ExecScan | | ExecProcNode | | MultiExecHash | | ExecHashJoin | | ExecProcNode | | ExecSort | | ExecProcNode | | 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.36%-- SeqNext | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --25.00%-- ReleaseBuffer ExecStoreTuple SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg 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% 4 postgres postgres [.] ExecHashGetSkewBucket | --- ExecHashGetSkewBucket ExecProcNode ExecSort ExecProcNode ExecAgg 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% 4 postgres postgres [.] palloc0 | --- palloc0 | |--50.02%-- heap_form_minimal_tuple | copytup_heap | tuplesort_puttupleslot | ExecSort | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--25.04%-- tuplesort_begin_datum | initialize_aggregates | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --24.95%-- copytup_heap tuplesort_puttupleslot ExecSort ExecProcNode ExecAgg 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% 4 postgres postgres [.] TupleHashTableHash | --- TupleHashTableHash hash_search FindTupleHashEntry ExecSubPlan ExecEvalNot ExecQual ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg 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% 4 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 copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c | |--75.01%-- 0xffffffffa0553f90 | 0xffffffffa05715f4 | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --24.99%-- 0xffffffffa0554e96 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.35% 4 postgres postgres [.] heap_compute_data_size | --- heap_compute_data_size heap_form_minimal_tuple copytup_heap tuplesort_puttupleslot ExecSort ExecProcNode ExecAgg 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% 4 postgres postgres [.] XidInMVCCSnapshot | --- XidInMVCCSnapshot | |--50.01%-- heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | 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%-- HeapTupleSatisfiesMVCC | |--50.09%-- BitmapHeapNext | ExecScan | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.91%-- heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.28% 5 mmfsd [unknown] [.] 0x5d436c | --- 0x8f5f4a | --- 0x5d436c | --- 0x5d4347 | --- 0x5d4367 0x946349fffffc38e9 | --- 0x92efe9 (nil) 0.27% 3 postgres postgres [.] bpcharne | --- bpcharne ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.26% 3 postgres [kernel.kallsyms] [k] down_read_trylock | --- down_read_trylock do_page_fault page_fault | |--66.19%-- copy_user_generic_string | 0xffffffffa04bfedc | 0xffffffffa04c021c | | | |--50.01%-- 0xffffffffa0554e96 | | 0xffffffffa056facb | | 0xffffffffa04c61ab | | vfs_read | | sys_read | | system_call_fastpath | | 0x7fb873db55d0 | | __GI___read | | | --49.99%-- 0xffffffffa0553f90 | 0xffffffffa05715f4 | 0xffffffffa04c61ab | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --33.81%-- 0x7fb873d6c834 __GI_memcpy MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.26% 3 postgres postgres [.] hashint4 | --- hashint4 | |--33.54%-- ExecHashGetHashValue | MultiExecHash | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--33.27%-- FunctionCall1Coll | ExecHashGetHashValue | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | 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.19%-- TupleHashTableHash hash_search FindTupleHashEntry ExecSubPlan ExecEvalNot ExecQual ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.26% 3 postgres postgres [.] execTuplesMatch | --- execTuplesMatch | |--66.67%-- ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --33.33%-- ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.26% 3 postgres postgres [.] texteq | --- texteq | |--66.67%-- FunctionCall2Coll | execTuplesMatch | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --33.33%-- execTuplesMatch ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.26% 3 postgres postgres [.] copytup_heap | --- copytup_heap | |--66.65%-- ExecSort | ExecProcNode | | | |--50.05%-- standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --49.95%-- ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --33.35%-- tuplesort_puttupleslot ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.26% 3 postgres postgres [.] CheckForSerializableConflictOut | --- CheckForSerializableConflictOut heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.26% 3 postgres postgres [.] ExecMakeFunctionResultNoSets | --- ExecMakeFunctionResultNoSets ExecQual | |--66.71%-- ExecScanHashBucket | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --33.29%-- ExecScan ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.26% 3 postgres [kernel.kallsyms] [k] clear_page_c | --- clear_page_c | |--66.66%-- prep_new_page | get_page_from_freelist | __alloc_pages_nodemask | alloc_pages_vma | do_anonymous_page | do_page_fault | page_fault | | | |--50.08%-- 0x798fd8 | | palloc0 | | heap_form_minimal_tuple | | copytup_heap | | tuplesort_puttupleslot | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --49.92%-- 0x7fb873d6c83c | __GI_memcpy | MultiExecHash | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --33.34%-- clear_huge_page __do_huge_pmd_anonymous_page do_page_fault page_fault 0x79e8c8 puttuple_common tuplesort_puttupleslot ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.26% 3 postgres postgres [.] StrategyGetBuffer | --- StrategyGetBuffer ReadBuffer_common ReadBufferExtended | |--66.62%-- BitmapHeapNext | ExecScan | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | 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 ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.26% 3 postgres libc-2.11.3.so [.] __gettimeofday_internal | --- __gettimeofday_internal ExecProcNode ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.26% 3 postgres postgres [.] ReleaseBuffer | --- ReleaseBuffer | |--66.67%-- ExecClearTuple | BitmapHeapNext | ExecScan | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --33.33%-- BitmapHeapNext ExecScan ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg 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% 1 ksoftirqd/8 [kernel.kallsyms] [k] free_pcppages_bulk | --- free_pcppages_bulk free_hot_cold_page rb_free rcu_do_batch rcu_process_callbacks __do_softirq run_ksoftirqd kthread kernel_thread_helper 0.18% 2 postgres postgres [.] ReadBuffer_common | --- ReadBuffer_common ReadBufferExtended | |--50.38%-- BitmapHeapNext | ExecScan | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | 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.62%-- heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.17% 2 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.17% 2 postgres postgres [.] advance_aggregates | --- advance_aggregates ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.17% 2 postgres postgres [.] ExecSort | --- ExecSort ExecProcNode | |--50.02%-- standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.98%-- ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.17% 2 postgres postgres [.] LWLockRelease | --- LWLockRelease | |--50.01%-- ReadBuffer_common | ReadBufferExtended | BitmapHeapNext | ExecScan | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | 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%-- heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.17% 2 postgres [kernel.kallsyms] [k] __mem_cgroup_commit_charge | --- __mem_cgroup_commit_charge __mem_cgroup_commit_charge_lrucare mem_cgroup_cache_charge add_to_page_cache_locked add_to_page_cache add_to_page_cache_lru read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise 0.17% 2 postgres [kernel.kallsyms] [k] handle_mm_fault | --- handle_mm_fault do_page_fault page_fault copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.17% 2 postgres postgres [.] SeqNext | --- SeqNext | |--50.04%-- ExecProcNode | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.96%-- ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.17% 2 postgres postgres [.] UnpinBuffer | --- UnpinBuffer | |--50.05%-- SeqNext | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | 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%-- ExecStoreTuple SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.17% 2 postgres postgres [.] FindTupleHashEntry | --- FindTupleHashEntry ExecSubPlan ExecEvalNot ExecQual ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.17% 2 postgres postgres [.] puttuple_common | --- puttuple_common | |--50.08%-- tuplesort_putdatum | 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 | --49.92%-- ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.17% 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.17% 2 postgres postgres [.] ExecStoreVirtualTuple | --- ExecStoreVirtualTuple | |--50.10%-- 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%-- ExecSubPlan ExecEvalNot ExecQual ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.17% 2 postgres postgres [.] check_stack_depth | --- check_stack_depth ExecMakeFunctionResultNoSets ExecQual ExecScanHashBucket ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.17% 2 postgres postgres [.] ExecQual | --- ExecQual ExecScan ExecProcNode | |--50.08%-- ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | 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%-- MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.17% 2 postgres postgres [.] ExecEvalConst | --- ExecEvalConst | |--50.07%-- ExecQual | ExecScan | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecSort | ExecProcNode | 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%-- ExecEvalScalarArrayOp ExecQual BitmapHeapNext ExecScan ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.17% 2 postgres [kernel.kallsyms] [k] do_page_fault | --- do_page_fault page_fault copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.17% 2 postgres libc-2.11.3.so [.] __GI_memcpy | --- __GI_memcpy heap_form_minimal_tuple copytup_heap tuplesort_puttupleslot ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.17% 2 postgres postgres [.] ExecCopySlotMinimalTuple | --- ExecCopySlotMinimalTuple tuplesort_puttupleslot ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.17% 2 postgres postgres [.] heap_form_minimal_tuple | --- heap_form_minimal_tuple | |--50.10%-- copytup_heap | tuplesort_puttupleslot | ExecSort | ExecProcNode | 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%-- ExecHashTableInsert MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.17% 2 postgres [kernel.kallsyms] [k] _raw_spin_lock_irqsave | --- _raw_spin_lock_irqsave | |--50.08%-- down | 0xffffffffa04a89cf | 0xffffffffa051f54e | 0xffffffffa053ac4a | 0xffffffffa051f34a | 0xffffffffa0560b17 | 0xffffffffa04aeb14 | 0xffffffffa04c602f | vfs_read | sys_read | system_call_fastpath | 0x7fb873db55d0 | __GI___read | --49.92%-- up 0xffffffffa0570c42 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.09% 1 kworker/2:1 [igb] [k] igb_watchdog_task | --- igb_watchdog_task process_one_work worker_thread kthread kernel_thread_helper 0.09% 1 postgres postgres [.] PredicateLockTuple | --- PredicateLockTuple BitmapHeapNext ExecScan ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.09% 1 postgres postgres [.] SearchCatCache | --- SearchCatCache get_typlenbyval tuplesort_begin_datum initialize_aggregates ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.09% 1 postgres postgres [.] tuplesort_end | --- tuplesort_end ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.09% 1 postgres postgres [.] int8inc_any | --- int8inc_any ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.09% 1 postgres libc-2.11.3.so [.] _int_free | --- _int_free MemoryContextDelete ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.09% 1 postgres postgres [.] MemoryContextCreate | --- MemoryContextCreate AllocSetContextCreate tuplesort_begin_common tuplesort_begin_datum initialize_aggregates ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.09% 1 postgres postgres [.] tuplesort_getdatum | --- tuplesort_getdatum ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.09% 1 kworker/1:1 [kernel.kallsyms] [k] cache_reap | --- cache_reap process_one_work worker_thread kthread kernel_thread_helper 0.09% 1 postgres postgres [.] toast_raw_datum_size | --- toast_raw_datum_size texteq FunctionCall2Coll execTuplesMatch ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.09% 1 postgres [kernel.kallsyms] [k] 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.09% 1 postgres postgres [.] LWLockAcquire | --- LWLockAcquire StartBufferIO ReadBuffer_common ReadBufferExtended heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.09% 1 postgres postgres [.] tuplesort_gettuple_common | --- tuplesort_gettuple_common tuplesort_gettupleslot ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.09% 1 postgres [kernel.kallsyms] [k] getnstimeofday | --- getnstimeofday 0xffffffffa04a8d10 0xffffffffa0554088 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.09% 1 postgres [kernel.kallsyms] [k] rw_verify_area | --- rw_verify_area vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.09% 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.09% 1 postgres [kernel.kallsyms] [k] fget_light | --- fget_light sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.09% 1 postgres postgres [.] gettimeofday@plt | --- gettimeofday@plt ExecProcNode ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.09% 1 postgres [kernel.kallsyms] [k] mem_cgroup_split_huge_fixup | --- mem_cgroup_split_huge_fixup __split_huge_page_refcount __split_huge_page split_huge_page __split_huge_page_pmd move_page_tables move_vma do_mremap sys_mremap system_call_fastpath 0x7fb873dc38ea __mremap 0x18000200040000 0.09% 1 postgres [kernel.kallsyms] [k] unlock_page | --- unlock_page __do_fault handle_pte_fault do_page_fault page_fault copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0554e96 0xffffffffa056facb 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.09% 1 postgres postgres [.] IsCatalogClass | --- IsCatalogClass heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.09% 1 postgres [kernel.kallsyms] [k] rcu_check_callbacks | --- rcu_check_callbacks update_process_times tick_sched_timer __run_hrtimer hrtimer_interrupt smp_apic_timer_interrupt apic_timer_interrupt 0x4906f1 hashint4 TupleHashTableHash hash_search FindTupleHashEntry ExecSubPlan ExecEvalNot ExecQual ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.09% 1 postgres postgres [.] SB_MatchText | --- SB_MatchText textnlike ExecMakeFunctionResultNoSets ExecQual ExecScan ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.09% 1 postgres postgres [.] ReadBufferExtended | --- ReadBufferExtended heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.09% 1 postgres [kernel.kallsyms] [k] page_add_file_rmap | --- 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.09% 1 postgres [kernel.kallsyms] [k] cap_capable | --- cap_capable apparmor_capable ns_capable 0xffffffffa04aeaeb 0xffffffffa04c602f vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.09% 1 postgres [kernel.kallsyms] [k] current_kernel_time | --- current_kernel_time current_fs_time file_update_time __do_fault handle_pte_fault do_page_fault page_fault copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.09% 1 postgres postgres [.] IncrBufferRefCount | --- IncrBufferRefCount BitmapHeapNext ExecScan ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.09% 1 postgres postgres [.] IsCatalogRelation | --- IsCatalogRelation heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.09% 1 postgres postgres [.] FileSeek | --- FileSeek mdread ReadBuffer_common ReadBufferExtended heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.09% 1 postgres [kernel.kallsyms] [k] __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.09% 1 postgres postgres [.] RecoveryInProgress | --- RecoveryInProgress heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.09% 1 postgres [kernel.kallsyms] [k] find_vma | --- find_vma do_page_fault page_fault copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.09% 1 postgres postgres [.] ExecHashGetBucketAndBatch | --- ExecHashGetBucketAndBatch ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.09% 1 postgres postgres [.] ArrayGetNItems | --- ArrayGetNItems ExecEvalScalarArrayOp ExecQual BitmapHeapNext ExecScan ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.09% 1 postgres [kernel.kallsyms] [k] 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.09% 1 postgres [kernel.kallsyms] [k] kfree | --- kfree 0xffffffffa05a17f1 0xffffffffa05a1a2d 0xffffffffa04b565a read_pages __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise 0.09% 1 postgres [kernel.kallsyms] [k] __set_page_dirty_no_writeback | --- __set_page_dirty_no_writeback __do_fault handle_pte_fault do_page_fault page_fault copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.09% 1 postgres [kernel.kallsyms] [k] __zone_watermark_ok | --- __zone_watermark_ok get_page_from_freelist __alloc_pages_nodemask alloc_pages_current __do_page_cache_readahead force_page_cache_readahead sys_fadvise64_64 system_call_fastpath 0x7fb873db9e5d posix_fadvise 0.09% 1 postgres postgres [.] CHashDelete | --- CHashDelete BufTableDelete ReadBuffer_common ReadBufferExtended heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.09% 1 postgres [kernel.kallsyms] [k] 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.09% 1 postgres postgres [.] pgstat_end_function_usage | --- pgstat_end_function_usage ExecQual ExecScan ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.09% 1 postgres postgres [.] AllocSetAlloc | --- AllocSetAlloc palloc0 heap_form_minimal_tuple copytup_heap tuplesort_puttupleslot ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.09% 1 postgres libc-2.11.3.so [.] posix_fadvise | --- posix_fadvise BitmapHeapNext ExecScan ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.09% 1 postgres postgres [.] slot_attisnull | --- slot_attisnull ExecSubPlan ExecEvalNot ExecQual ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.09% 1 postgres libc-2.11.3.so [.] __GI_memset | --- __GI_memset heap_form_minimal_tuple copytup_heap tuplesort_puttupleslot ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.09% 1 postgres postgres [.] ResourceOwnerEnlargeBuffers | --- ResourceOwnerEnlargeBuffers IncrBufferRefCount ExecStoreTuple BitmapHeapNext ExecScan ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.09% 1 postgres [kernel.kallsyms] [k] system_call_after_swapgs | --- system_call_after_swapgs __GI___read 0.09% 1 postgres postgres [.] CHashAddToGarbage | --- CHashAddToGarbage CHashDelete BufTableDelete ReadBuffer_common ReadBufferExtended BitmapHeapNext ExecScan ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.09% 1 postgres [kernel.kallsyms] [k] _raw_spin_unlock_irqrestore | --- _raw_spin_unlock_irqrestore 0xffffffffa0570c42 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.09% 1 postgres [kernel.kallsyms] [k] sys_read | --- sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.09% 1 postgres libc-2.11.3.so [.] __GI___read | --- __GI___read mdread ReadBuffer_common ReadBufferExtended heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.09% 1 postgres postgres [.] PrefetchBuffer | --- PrefetchBuffer BitmapHeapNext ExecScan ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecSort ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.04% 1 postgres postgres [.] SyncOneBuffer | --- SyncOneBuffer BgBufferSync BackgroundWriterMain AuxiliaryProcessMain StartChildProcess reaper __restore_rt PostmasterMain main __libc_start_main 0.01% 1 irqbalance [kernel.kallsyms] [k] find_inode_fast | --- find_inode_fast iget_locked proc_get_inode proc_lookup_de d_alloc_and_lookup do_lookup link_path_walk path_openat do_filp_open do_sys_open system_call_fastpath 0x7f398a1961e0 0x7f398a1961e0 0xffffd374ffffd374 0.01% 1 irqbalance [kernel.kallsyms] [k] vm_normal_page | --- vm_normal_page zap_pte_range unmap_page_range unmap_vmas unmap_region do_munmap sys_munmap system_call_fastpath 0x7f398a1a0c87 0x7f398a1a0c87 (nil) 0.01% 1 psql libpq.so.5.8 [.] pg_ascii_mblen | --- pg_ascii_mblen print_aligned_text printTable printQuery SendQuery MainLoop process_file main __libc_start_main 0.01% 1 kworker/3:1 [kernel.kallsyms] [k] find_busiest_group | --- find_busiest_group load_balance idle_balance thread_return worker_thread kthread kernel_thread_helper 0.01% 1 fail2ban-server [kernel.kallsyms] [k] core_sys_select | --- core_sys_select sys_select system_call_fastpath 0x7f465715f393 0x7f465715f393 0x310000002e 0.00% 1 irqbalance [kernel.kallsyms] [k] inode_init_always | --- inode_init_always alloc_inode iget_locked proc_get_inode proc_lookup_de proc_root_lookup d_alloc_and_lookup do_lookup link_path_walk path_openat do_filp_open do_sys_open system_call_fastpath 0x7f398a1961e0 0x7f398a1961e0 0xffffd374ffffd374 0.00% 1 swapper [kernel.kallsyms] [k] menu_select | --- menu_select cpuidle_idle_call cpu_idle 0.00% 1 swapper [ixgbe] [k] ixgbe_clean_tx_irq | --- ixgbe_clean_tx_irq ixgbe_poll net_rx_action __do_softirq call_softirq do_softirq irq_exit do_IRQ ret_from_intr intel_idle cpuidle_idle_call cpu_idle 0.00% 1 irqbalance [kernel.kallsyms] [k] find_next_bit | --- find_next_bit kstat_irqs show_stat seq_read proc_reg_read vfs_read sys_read system_call_fastpath 0x7f398a1965d0 0x7f398a1965d0 0x7f398ad0a730 0.00% 1 kworker/3:1 [kernel.kallsyms] [k] free_pcppages_bulk | --- free_pcppages_bulk drain_zone_pages refresh_cpu_vm_stats vmstat_update process_one_work worker_thread kthread kernel_thread_helper 0.00% 1 kworker/8:1 [kernel.kallsyms] [k] worker_thread | --- worker_thread kthread kernel_thread_helper 0.00% 1 irqbalance [kernel.kallsyms] [k] format_decode | --- format_decode vsnprintf seq_printf show_stat seq_read proc_reg_read vfs_read sys_read system_call_fastpath 0x7f398a1965d0 0x7f398a1965d0 0x7f398ad0a730 0.00% 1 fail2ban-server [kernel.kallsyms] [k] system_call | --- system_call 0x7f4657157765 0x602010 0x602010 0.00% 1 mmfsd [kernel.kallsyms] [k] find_next_bit | --- find_next_bit cpumask_next_and find_busiest_group load_balance idle_balance thread_return schedule_hrtimeout_range_clock ep_poll sys_epoll_wait system_call_fastpath 0x7ffb7c127723 0x7ffb7c127723 0x800000000 0.00% 1 kjournald [kernel.kallsyms] [k] mempool_alloc | --- mempool_alloc bio_alloc_bioset bio_alloc _submit_bh journal_submit_data_buffers journal_commit_transaction kjournald kthread kernel_thread_helper 0.00% 1 kjournald [kernel.kallsyms] [k] bmap | --- bmap journal_bmap journal_get_descriptor_buffer journal_commit_transaction kjournald kthread kernel_thread_helper # # (For a higher level overview, try: perf report --sort comm,dso) #