# Events: 990 cycles # # Overhead Samples Command Shared Object Symbol # ........ .......... ............... ................. ............................... # 24.97% 249 postgres postgres [.] ExecHashTableInsert | --- ExecHashTableInsert MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 7.12% 71 postgres postgres [.] HeapTupleSatisfiesMVCC | --- HeapTupleSatisfiesMVCC | |--97.18%-- heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --2.82%-- heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 4.91% 49 postgres [ipt_REJECT] [.] 0x5ef30188 | --- 0xffffffffff600188 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode | |--97.37%-- MultiExecHash | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --2.63%-- ExecAgg ExecProcNode ExecSetParamPlan ExecEvalParamExec ExecIndexEvalRuntimeKeys ExecReScanBitmapIndexScan ExecReScan MultiExecBitmapIndexScan BitmapHeapNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0xffffffffff600186 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0xffffffffff60018e 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0xffffffffff60019e 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0xffffffffff60018c 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 4.41% 44 postgres [vdso] [.] 0x7fffe8fff8f5 | --- 0x7fffe8fff8f5 __gettimeofday_internal ExecProcNode | |--88.88%-- MultiExecHash | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --11.12%-- ExecAgg ExecProcNode ExecSetParamPlan ExecEvalParamExec ExecIndexEvalRuntimeKeys ExecReScanBitmapIndexScan ExecReScan MultiExecBitmapIndexScan BitmapHeapNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff662 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode | |--83.33%-- MultiExecHash | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --16.67%-- ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff604 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff60a 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff6ae 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff6a5 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff8b0 ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff8c4 __gettimeofday_internal ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff677 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff648 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff8e1 __gettimeofday_internal ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff90a __gettimeofday_internal ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff626 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff8b6 __gettimeofday_internal ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff657 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff8f9 __gettimeofday_internal ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff640 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff8fc __gettimeofday_internal ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff900 __gettimeofday_internal ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main | --- 0x7fffe8fff8dd __gettimeofday_internal ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 2.41% 24 postgres postgres [.] slot_deform_tuple | --- slot_deform_tuple | |--83.33%-- slot_getsomeattrs | ExecProject | | | |--85.00%-- ExecScan | | ExecProcNode | | MultiExecHash | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | |--10.00%-- advance_aggregates | | ExecAgg | | ExecProcNode | | ExecSetParamPlan | | ExecEvalParamExec | | ExecIndexEvalRuntimeKeys | | ExecReScanBitmapIndexScan | | ExecReScan | | MultiExecBitmapIndexScan | | BitmapHeapNext | | ExecScan | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --5.00%-- ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--12.50%-- ExecProject | ExecScan | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --4.17%-- slot_getattr ExecHashGetHashValue ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 2.11% 1 postgres [kernel.kallsyms] [k] page_fault | --- page_fault | |--57.05%-- 0x7a5772 | HeapTupleSatisfiesMVCC | | | |--91.67%-- heapgetpage | | heapgettup_pagemode | | heap_getnext | | SeqNext | | ExecScan | | ExecProcNode | | MultiExecHash | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --8.33%-- MultiExecHash | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--19.02%-- 0x49f6c7 | heap_page_prune_opt | | | |--50.00%-- heapgetpage | | heapgettup_pagemode | | heap_getnext | | SeqNext | | ExecScan | | ExecProcNode | | MultiExecHash | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --50.00%-- MultiExecHash | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--9.51%-- 0x674c50 | PinBuffer | MultiExecHash | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--4.76%-- 0x49d348 | heap_hot_search_buffer | BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSetParamPlan | ExecEvalParamExec | ExecIndexEvalRuntimeKeys | ExecReScanBitmapIndexScan | ExecReScan | MultiExecBitmapIndexScan | BitmapHeapNext | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--4.76%-- 0x5bc4c5 | ExecHashTableInsert | heapgetpage | 0xcbda01 | 0xcb6b90 | |--4.75%-- 0x68ef14 | LWLockAttemptLock | heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main --0.16%-- [...] 2.11% 21 postgres postgres [.] ExecHashGetHashValue | --- ExecHashGetHashValue | |--90.47%-- MultiExecHash | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --9.53%-- ExecHashJoin ExecProcNode 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.91% 19 postgres postgres [.] heap_form_minimal_tuple | --- heap_form_minimal_tuple ExecFetchSlotMinimalTuple ExecHashTableInsert MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.91% 19 postgres postgres [.] InstrStopNode | --- InstrStopNode ExecProcNode | |--94.74%-- MultiExecHash | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --5.26%-- ExecAgg ExecProcNode ExecSetParamPlan ExecEvalParamExec ExecIndexEvalRuntimeKeys ExecReScanBitmapIndexScan ExecReScan MultiExecBitmapIndexScan BitmapHeapNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.91% 19 postgres postgres [.] ExecProject | --- ExecProject | |--94.74%-- ExecScan | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --5.26%-- ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.70% 17 postgres postgres [.] heapgettup_pagemode | --- heapgettup_pagemode | |--88.23%-- heap_getnext | SeqNext | ExecScan | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --11.77%-- SeqNext ExecScan ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.60% 16 postgres postgres [.] heap_fill_tuple | --- heap_fill_tuple heap_form_minimal_tuple ExecFetchSlotMinimalTuple ExecHashTableInsert MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.50% 6 postgres [kernel.kallsyms] [k] mem_cgroup_update_page_stat | --- mem_cgroup_update_page_stat | |--52.72%-- 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 | |--40.23%-- __do_fault | handle_pte_fault | do_page_fault | page_fault | | | |--50.00%-- 0x49f6c7 | | heap_page_prune_opt | | | | | |--66.68%-- heapgetpage | | | heapgettup_pagemode | | | heap_getnext | | | SeqNext | | | ExecScan | | | ExecProcNode | | | MultiExecHash | | | ExecHashJoin | | | ExecProcNode | | | ExecAgg | | | ExecProcNode | | | ExecSort | | | ExecProcNode | | | standard_ExecutorRun | | | ExplainOnePlan | | | ExplainOneQuery | | | ExplainQuery | | | standard_ProcessUtility | | | PortalRunUtility | | | FillPortalStore | | | PortalRun | | | exec_simple_query | | | PostgresMain | | | ServerLoop | | | PostmasterMain | | | main | | | __libc_start_main | | | | | --33.32%-- BitmapHeapNext | | ExecScan | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSetParamPlan | | ExecEvalParamExec | | ExecIndexEvalRuntimeKeys | | ExecReScanBitmapIndexScan | | ExecReScan | | MultiExecBitmapIndexScan | | BitmapHeapNext | | ExecScan | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --50.00%-- 0x7a5772 | HeapTupleSatisfiesMVCC | heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --7.05%-- 0xffff883fbfb12ae8 1.40% 14 postgres postgres [.] ExecScan | --- ExecScan | |--92.86%-- ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --7.14%-- MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.40% 14 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 | |--57.14%-- 0x7a5772 | HeapTupleSatisfiesMVCC | heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --42.86%-- 0x49f6c7 heap_page_prune_opt | |--66.67%-- heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --33.33%-- BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSetParamPlan ExecEvalParamExec ExecIndexEvalRuntimeKeys ExecReScanBitmapIndexScan ExecReScan MultiExecBitmapIndexScan BitmapHeapNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.30% 13 postgres postgres [.] CHashBucketScan | --- CHashBucketScan CHashSearch BufTableLookup | |--92.28%-- ReadBuffer_common | ReadBufferExtended | | | |--91.67%-- heapgetpage | | heapgettup_pagemode | | heap_getnext | | SeqNext | | ExecScan | | ExecProcNode | | MultiExecHash | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --8.33%-- _bt_getbuf | _bt_steppage | _bt_next | btgetbitmap | FunctionCall2Coll | index_getbitmap | MultiExecBitmapIndexScan | BitmapHeapNext | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --7.72%-- PrefetchBuffer BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSetParamPlan ExecEvalParamExec ExecIndexEvalRuntimeKeys ExecReScanBitmapIndexScan ExecReScan MultiExecBitmapIndexScan BitmapHeapNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.30% 13 postgres postgres [.] MultiExecHash | --- MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.10% 11 postgres [kernel.kallsyms] [k] clear_page_c | --- clear_page_c | |--72.73%-- prep_new_page | get_page_from_freelist | __alloc_pages_nodemask | alloc_pages_vma | do_anonymous_page | do_page_fault | page_fault | | | |--75.02%-- 0x5bc4c5 | | ExecHashTableInsert | | MultiExecHash | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | |--12.50%-- 0x7fb873d6c787 | | __GI_memcpy | | MultiExecHash | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --12.47%-- 0x7fb873d6c7b7 | __GI_memcpy | MultiExecHash | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --27.27%-- clear_huge_page __do_huge_pmd_anonymous_page do_page_fault page_fault 0x7fb873d6bdbe __GI_memset ExecHashTableCreate ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.01% 10 postgres postgres [.] heap_hot_search_buffer | --- heap_hot_search_buffer BitmapHeapNext ExecScan ExecProcNode | |--59.78%-- ExecHashJoin | ExecProcNode | 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.22%-- ExecAgg ExecProcNode ExecSetParamPlan ExecEvalParamExec ExecIndexEvalRuntimeKeys ExecReScanBitmapIndexScan ExecReScan MultiExecBitmapIndexScan BitmapHeapNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.00% 10 postgres postgres [.] hash_uint32 | --- hash_uint32 ExecHashGetHashValue MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 1.00% 10 postgres postgres [.] AllocSetFree | --- AllocSetFree ExecClearTuple ExecProject ExecScan ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.90% 9 postgres postgres [.] AllocSetAlloc | --- AllocSetAlloc | |--77.78%-- palloc0 | heap_form_minimal_tuple | ExecFetchSlotMinimalTuple | ExecHashTableInsert | MultiExecHash | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --22.22%-- heap_form_minimal_tuple ExecFetchSlotMinimalTuple ExecHashTableInsert MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.90% 9 postgres postgres [.] heapgetpage | --- heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.90% 9 postgres libc-2.11.3.so [.] __GI_memset | --- __GI_memset | |--55.54%-- ExecHashTableCreate | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --44.46%-- heap_form_minimal_tuple ExecFetchSlotMinimalTuple ExecHashTableInsert MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.89% 1 postgres [kernel.kallsyms] [k] zap_pte_range | --- zap_pte_range unmap_page_range unmap_vmas | |--72.95%-- exit_mmap | mmput | exit_mm | do_exit | do_group_exit | sys_exit_group | system_call_fastpath | 0x7fb873d90a38 | --27.05%-- unmap_region do_munmap sys_munmap system_call_fastpath 0x7fb873dbfc87 __munmap 0x3241 0.80% 8 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 | |--75.00%-- 0x7a5772 | HeapTupleSatisfiesMVCC | heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --25.00%-- 0x49f6c7 heap_page_prune_opt heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.80% 8 postgres postgres [.] InstrStartNode | --- InstrStartNode | |--87.50%-- ExecProcNode | | | |--85.72%-- MultiExecHash | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --14.28%-- ExecAgg | ExecProcNode | ExecSetParamPlan | ExecEvalParamExec | ExecIndexEvalRuntimeKeys | ExecReScanBitmapIndexScan | ExecReScan | MultiExecBitmapIndexScan | BitmapHeapNext | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --12.50%-- ExecAgg ExecProcNode ExecSetParamPlan ExecEvalParamExec ExecIndexEvalRuntimeKeys ExecReScanBitmapIndexScan ExecReScan MultiExecBitmapIndexScan BitmapHeapNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.71% 12 swapper [kernel.kallsyms] [k] intel_idle | --- intel_idle cpuidle_idle_call cpu_idle | --100.00%-- start_kernel x86_64_start_kernel 0.70% 7 postgres postgres [.] FunctionCall1Coll | --- FunctionCall1Coll | |--85.71%-- ExecHashGetHashValue | | | |--83.33%-- MultiExecHash | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --16.67%-- ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --14.29%-- MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.70% 7 postgres postgres [.] slot_getattr | --- slot_getattr | |--71.43%-- ExecHashGetHashValue | MultiExecHash | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --28.57%-- MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.70% 7 postgres postgres [.] ExecStoreTuple | --- ExecStoreTuple | |--57.14%-- SeqNext | ExecScan | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --42.86%-- ExecScan ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.69% 1 postgres [kernel.kallsyms] [k] 0xffffffff81105f26 | --- release_pages free_pages_and_swap_cache tlb_flush_mmu zap_pte_range unmap_page_range unmap_vmas exit_mmap mmput exit_mm do_exit do_group_exit sys_exit_group system_call_fastpath 0x7fb873d90a38 0.60% 6 postgres postgres [.] heap_page_prune_opt | --- heap_page_prune_opt | |--66.60%-- heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --33.40%-- BitmapHeapNext ExecScan ExecProcNode | |--50.16%-- ExecAgg | ExecProcNode | ExecSetParamPlan | ExecEvalParamExec | ExecIndexEvalRuntimeKeys | ExecReScanBitmapIndexScan | ExecReScan | MultiExecBitmapIndexScan | BitmapHeapNext | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.84%-- ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.60% 6 postgres postgres [.] heap_getnext | --- heap_getnext | |--66.67%-- SeqNext | ExecScan | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --33.33%-- ExecScan ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.60% 6 postgres postgres [.] SeqNext | --- SeqNext | |--50.00%-- ExecScan | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --50.00%-- ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.60% 6 postgres postgres [.] ExecClearTuple | --- ExecClearTuple | |--66.67%-- ExecProject | ExecScan | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --33.33%-- ExecScan ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.60% 6 postgres libc-2.11.3.so [.] __GI_memcpy | --- __GI_memcpy MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.60% 6 postgres postgres [.] heap_compute_data_size | --- heap_compute_data_size heap_form_minimal_tuple ExecFetchSlotMinimalTuple ExecHashTableInsert MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.57% 1 swapper [kernel.kallsyms] [k] tick_check_idle | --- tick_check_idle irq_enter smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.56% 1 mmfsd [mmfslinux] [k] 0x89f0 | --- 0xffffffffa04a89f0 0x7ffb7c11f3d7 0x7ffb6c4f61e0 0.55% 1 mmfsd [kernel.kallsyms] [k] find_pid_ns | --- find_pid_ns 0xffffffffa04a772a 0xffffffffa0607efc 0xffffffffa0605a42 0xffffffffa04c3c65 do_vfs_ioctl sys_ioctl system_call_fastpath 0x7ffb7c11f3d7 0x7ffb7c11f3d7 (nil) 0.53% 1 fail2ban-server [kernel.kallsyms] [k] idle_balance | --- idle_balance thread_return schedule_hrtimeout_range_clock poll_schedule_timeout do_select core_sys_select sys_select system_call_fastpath 0x7f465715f393 0x7f465715f393 0x645c5b5c203a6c65 0x7f4658007d80 0.50% 1 swapper [kernel.kallsyms] [k] nohz_idle_balance | --- nohz_idle_balance __do_softirq call_softirq do_softirq irq_exit smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.50% 5 postgres [kernel.kallsyms] [k] __rmqueue | --- __rmqueue get_page_from_freelist __alloc_pages_nodemask alloc_pages_vma do_anonymous_page do_page_fault page_fault | |--60.00%-- 0x5bc4c5 | ExecHashTableInsert | MultiExecHash | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--20.00%-- 0x7fb873d6c787 | __GI_memcpy | MultiExecHash | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --20.00%-- 0x7fb873d6c7ba __GI_memcpy MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.50% 5 postgres postgres [.] slot_getsomeattrs | --- slot_getsomeattrs | |--80.00%-- ExecProject | ExecScan | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --20.00%-- ExecScan ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.50% 5 postgres postgres [.] dense_alloc | --- dense_alloc | |--80.00%-- ExecHashTableInsert | MultiExecHash | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --20.00%-- MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.50% 5 postgres postgres [.] palloc0 | --- palloc0 | |--80.00%-- heap_form_minimal_tuple | ExecFetchSlotMinimalTuple | ExecHashTableInsert | MultiExecHash | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --20.00%-- ExecFetchSlotMinimalTuple ExecHashTableInsert MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.48% 1 mmfsd [unknown] [.] 0x5e1bfd | --- 0x5e1bfd 0x3600000000 (nil) 0x1ba4a7e01 0.41% 4 postgres postgres [.] hash_any | --- hash_any | |--48.74%-- CHashSearch | BufTableLookup | | | |--50.01%-- PrefetchBuffer | | BitmapHeapNext | | ExecScan | | ExecProcNode | | ExecHashJoin | | ExecProcNode | | ExecAgg | | ExecProcNode | | ExecSort | | ExecProcNode | | standard_ExecutorRun | | ExplainOnePlan | | ExplainOneQuery | | ExplainQuery | | standard_ProcessUtility | | PortalRunUtility | | FillPortalStore | | PortalRun | | exec_simple_query | | PostgresMain | | ServerLoop | | PostmasterMain | | main | | __libc_start_main | | | --49.99%-- ReadBuffer_common | ReadBufferExtended | heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--26.89%-- hash_search | tbm_get_pageentry | tbm_add_tuples | btgetbitmap | FunctionCall2Coll | index_getbitmap | MultiExecBitmapIndexScan | BitmapHeapNext | ExecScan | ExecProcNode | ExecAgg | ExecProcNode | ExecSetParamPlan | ExecEvalParamExec | ExecIndexEvalRuntimeKeys | ExecReScanBitmapIndexScan | ExecReScan | MultiExecBitmapIndexScan | BitmapHeapNext | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --24.37%-- hashtext FunctionCall1Coll TupleHashTableHash hash_search LookupTupleHashEntry ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.40% 4 postgres postgres [.] tbm_iterate | --- tbm_iterate BitmapHeapNext ExecScan ExecProcNode | |--75.22%-- ExecAgg | ExecProcNode | ExecSetParamPlan | ExecEvalParamExec | ExecIndexEvalRuntimeKeys | ExecReScanBitmapIndexScan | ExecReScan | MultiExecBitmapIndexScan | BitmapHeapNext | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --24.78%-- ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.40% 4 postgres postgres [.] BitmapHeapNext | --- BitmapHeapNext ExecScan ExecProcNode | |--50.37%-- ExecAgg | ExecProcNode | ExecSetParamPlan | ExecEvalParamExec | ExecIndexEvalRuntimeKeys | ExecReScanBitmapIndexScan | ExecReScan | MultiExecBitmapIndexScan | BitmapHeapNext | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.63%-- ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.40% 4 postgres [kernel.kallsyms] [k] set_page_dirty | --- set_page_dirty zap_pte_range unmap_page_range unmap_vmas exit_mmap mmput exit_mm do_exit do_group_exit sys_exit_group system_call_fastpath 0x7fb873d90a38 0.40% 3 postgres [kernel.kallsyms] [k] release_pages | --- release_pages free_pages_and_swap_cache tlb_flush_mmu zap_pte_range unmap_page_range unmap_vmas | |--74.87%-- unmap_region | do_munmap | sys_brk | system_call_fastpath | 0x7fb873dbb2aa | __brk | 0x7fb874057aa0 | 0x834800000000ba00 | --25.13%-- exit_mmap mmput exit_mm do_exit do_group_exit sys_exit_group system_call_fastpath 0x7fb873d90a38 0.40% 4 postgres postgres [.] PinBuffer | --- PinBuffer ReadBuffer_common ReadBufferExtended | |--74.98%-- heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --25.02%-- BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSetParamPlan ExecEvalParamExec ExecIndexEvalRuntimeKeys ExecReScanBitmapIndexScan ExecReScan MultiExecBitmapIndexScan BitmapHeapNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.40% 4 postgres postgres [.] ExecScanHashBucket | --- ExecScanHashBucket ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.40% 4 postgres postgres [.] hashint4 | --- hashint4 ExecHashGetHashValue MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.40% 4 postgres [kernel.kallsyms] [k] mem_cgroup_charge_common | --- mem_cgroup_charge_common do_anonymous_page do_page_fault page_fault | |--50.00%-- 0x5bc4c5 | ExecHashTableInsert | MultiExecHash | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--25.00%-- 0x7fb873d6c7ba | __GI_memcpy | MultiExecHash | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --25.00%-- 0x7fb873d619d3 _int_malloc (nil) 0.40% 4 postgres postgres [.] ExecFetchSlotMinimalTuple | --- ExecFetchSlotMinimalTuple ExecHashTableInsert MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.40% 4 postgres postgres [.] ExecProcNode | --- ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.40% 4 postgres [kernel.kallsyms] [k] find_vma | --- find_vma do_page_fault page_fault | |--50.00%-- 0x5bc4c5 | ExecHashTableInsert | MultiExecHash | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--25.01%-- 0x7a5772 | HeapTupleSatisfiesMVCC | heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --24.99%-- 0x7fb873d6c7b7 __GI_memcpy MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.36% 3 postgres postgres [.] hash_search_with_hash_value | --- hash_search_with_hash_value tbm_get_pageentry tbm_add_tuples btgetbitmap FunctionCall2Coll index_getbitmap MultiExecBitmapIndexScan BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSetParamPlan ExecEvalParamExec ExecIndexEvalRuntimeKeys ExecReScanBitmapIndexScan ExecReScan MultiExecBitmapIndexScan BitmapHeapNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.33% 1 ksoftirqd/1 [kernel.kallsyms] [k] __free_pages | --- __free_pages rb_free rcu_do_batch rcu_process_callbacks __do_softirq run_ksoftirqd kthread kernel_thread_helper 0.32% 3 postgres postgres [.] LWLockAttemptLock | --- LWLockAttemptLock LWLockAcquire | |--61.91%-- heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --38.09%-- _bt_getbuf _bt_steppage _bt_next btgetbitmap FunctionCall2Coll index_getbitmap MultiExecBitmapIndexScan BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSetParamPlan ExecEvalParamExec ExecIndexEvalRuntimeKeys ExecReScanBitmapIndexScan ExecReScan MultiExecBitmapIndexScan BitmapHeapNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.30% 3 postgres postgres [.] ExecStoreVirtualTuple | --- ExecStoreVirtualTuple | |--33.34%-- ExecAgg | ExecProcNode | ExecSetParamPlan | ExecEvalParamExec | ExecIndexEvalRuntimeKeys | ExecReScanBitmapIndexScan | ExecReScan | MultiExecBitmapIndexScan | BitmapHeapNext | ExecScan | ExecProcNode | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--33.33%-- ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --33.33%-- ExecScan ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.30% 3 postgres postgres [.] CheckForSerializableConflictOut | --- CheckForSerializableConflictOut | |--66.66%-- heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --33.34%-- heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.30% 3 postgres [kernel.kallsyms] [k] __do_fault | --- __do_fault | |--66.67%-- handle_pte_fault | do_page_fault | page_fault | 0x7a5772 | HeapTupleSatisfiesMVCC | heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --33.33%-- 0x100073 HeapTupleSatisfiesMVCC heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.30% 3 postgres postgres [.] MemoryContextReset | --- MemoryContextReset | |--66.67%-- ExecHashGetHashValue | MultiExecHash | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --33.33%-- ExecScan ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.30% 3 postgres [kernel.kallsyms] [k] error_exit | --- error_exit 0x49f6c7 heap_page_prune_opt heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.24% 2 postgres [kernel.kallsyms] [k] __tlb_remove_page | --- __tlb_remove_page zap_pte_range unmap_page_range unmap_vmas exit_mmap mmput exit_mm do_exit do_group_exit sys_exit_group system_call_fastpath 0x7fb873d90a38 0.21% 1 postgres [kernel.kallsyms] [k] __mem_cgroup_commit_charge | --- __mem_cgroup_commit_charge mem_cgroup_charge_common do_anonymous_page do_page_fault page_fault | |--48.85%-- 0x5bc4c5 | ExecHashTableInsert | MultiExecHash | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | |--48.85%-- 0x7fb873d6c7ba | __GI_memcpy | MultiExecHash | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --2.30%-- 0x7fb873d619d3 _int_malloc (nil) 0.20% 2 postgres libc-2.11.3.so [.] __gettimeofday_internal | --- __gettimeofday_internal ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.20% 2 postgres postgres [.] pfree | --- pfree | |--50.00%-- ExecProject | ExecScan | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --50.00%-- ExecClearTuple ExecProject ExecScan ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.20% 2 postgres [kernel.kallsyms] [k] error_entry | --- error_entry | |--50.00%-- 0x7fb873d6c787 | __GI_memcpy | heapgetpage | 0xcbda01 | 0xcb6b90 | --50.00%-- 0x7a5772 HeapTupleSatisfiesMVCC MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.20% 2 postgres [kernel.kallsyms] [k] handle_mm_fault | --- handle_mm_fault do_page_fault page_fault 0x7a5772 HeapTupleSatisfiesMVCC heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.20% 2 postgres [kernel.kallsyms] [k] down_read_trylock | --- down_read_trylock do_page_fault page_fault | |--50.00%-- 0x49f6c7 | heap_page_prune_opt | heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --50.00%-- 0x49d348 heap_hot_search_buffer BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSetParamPlan ExecEvalParamExec ExecIndexEvalRuntimeKeys ExecReScanBitmapIndexScan ExecReScan MultiExecBitmapIndexScan BitmapHeapNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.20% 2 postgres postgres [.] memcpy@plt | --- memcpy@plt MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.20% 2 postgres [kernel.kallsyms] [k] do_page_fault | --- do_page_fault page_fault | |--50.00%-- 0x7fb873d6c7ba | __GI_memcpy | MultiExecHash | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --50.00%-- 0x7fb873d6c7b7 __GI_memcpy MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.20% 2 postgres [kernel.kallsyms] [k] __alloc_pages_nodemask | --- __alloc_pages_nodemask | |--50.00%-- alloc_pages_vma | do_anonymous_page | do_page_fault | page_fault | 0x7fb873d6c7b7 | __GI_memcpy | MultiExecHash | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --50.00%-- alloc_pages_current pte_alloc_one __pte_alloc handle_mm_fault do_page_fault page_fault 0x7a5772 HeapTupleSatisfiesMVCC heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.20% 2 postgres postgres [.] ExecHashGetSkewBucket | --- ExecHashGetSkewBucket ExecHashJoin ExecProcNode ExecAgg 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% 2 postgres postgres [.] ResourceOwnerRememberBuffer | --- ResourceOwnerRememberBuffer ReadBuffer_common ReadBufferExtended | |--50.00%-- heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --50.00%-- BitmapHeapNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.20% 2 postgres postgres [.] texteq | --- texteq FunctionCall2Coll | |--50.01%-- execTuplesMatch | TupleHashTableMatch | hash_search_with_hash_value | LookupTupleHashEntry | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.99%-- _bt_checkkeys _bt_readpage _bt_steppage _bt_next btgetbitmap FunctionCall2Coll index_getbitmap MultiExecBitmapIndexScan BitmapHeapNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.20% 2 postgres [kernel.kallsyms] [k] unlock_page | --- unlock_page __do_fault handle_pte_fault do_page_fault page_fault 0x7a5772 HeapTupleSatisfiesMVCC heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.20% 2 postgres [kernel.kallsyms] [k] _raw_spin_lock | --- _raw_spin_lock __do_fault handle_pte_fault do_page_fault page_fault 0x7a5772 HeapTupleSatisfiesMVCC heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.20% 2 postgres [kernel.kallsyms] [k] mem_cgroup_count_vm_event | --- mem_cgroup_count_vm_event handle_mm_fault do_page_fault page_fault | |--50.01%-- 0x7a5772 | HeapTupleSatisfiesMVCC | heapgetpage | heapgettup_pagemode | heap_getnext | SeqNext | ExecScan | ExecProcNode | MultiExecHash | ExecHashJoin | ExecProcNode | ExecAgg | ExecProcNode | ExecSort | ExecProcNode | standard_ExecutorRun | ExplainOnePlan | ExplainOneQuery | ExplainQuery | standard_ProcessUtility | PortalRunUtility | FillPortalStore | PortalRun | exec_simple_query | PostgresMain | ServerLoop | PostmasterMain | main | __libc_start_main | --49.99%-- 0x49d348 heap_hot_search_buffer BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSetParamPlan ExecEvalParamExec ExecIndexEvalRuntimeKeys ExecReScanBitmapIndexScan ExecReScan MultiExecBitmapIndexScan BitmapHeapNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.19% 1 ksoftirqd/14 [xt_state] [k] state_mt_exit | --- state_mt_exit ipt_do_table nf_iterate nf_hook_slow __ip_local_out ip_local_out ip_queue_xmit tcp_transmit_skb tcp_delack_timer call_timer_fn run_timer_softirq __do_softirq run_ksoftirqd kthread kernel_thread_helper 0.16% 1 swapper [kernel.kallsyms] [k] native_sched_clock | --- native_sched_clock sched_clock update_rq_clock enqueue_task ttwu_activate ttwu_do_activate 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.10% 1 postgres postgres [.] tbm_comparator | --- tbm_comparator pg_qsort pg_qsort pg_qsort pg_qsort pg_qsort pg_qsort pg_qsort tbm_begin_iterate BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSetParamPlan ExecEvalParamExec ExecIndexEvalRuntimeKeys ExecReScanBitmapIndexScan ExecReScan MultiExecBitmapIndexScan BitmapHeapNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.10% 1 postgres [kernel.kallsyms] [k] __set_page_dirty_no_writeback | --- __set_page_dirty_no_writeback zap_pte_range unmap_page_range unmap_vmas exit_mmap mmput exit_mm do_exit do_group_exit sys_exit_group system_call_fastpath 0x7fb873d90a38 0.10% 1 postgres postgres [.] advance_transition_function | --- advance_transition_function advance_aggregates ExecAgg ExecProcNode ExecSetParamPlan ExecEvalParamExec ExecIndexEvalRuntimeKeys ExecReScanBitmapIndexScan ExecReScan MultiExecBitmapIndexScan BitmapHeapNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.10% 1 postgres postgres [.] ReleaseBuffer | --- ReleaseBuffer ExecStoreTuple BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSetParamPlan ExecEvalParamExec ExecIndexEvalRuntimeKeys ExecReScanBitmapIndexScan ExecReScan MultiExecBitmapIndexScan BitmapHeapNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.10% 1 postgres postgres [.] check_stack_depth | --- check_stack_depth ExecProject ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.10% 1 postgres postgres [.] ExecEvalScalarVarFast | --- ExecEvalScalarVarFast ExecHashGetHashValue MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.10% 1 postgres postgres [.] UnpinBuffer | --- UnpinBuffer ExecStoreTuple SeqNext ExecScan ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.10% 1 postgres [kernel.kallsyms] [k] retint_swapgs | --- retint_swapgs 0x49f6c7 heap_page_prune_opt heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.10% 1 postgres postgres [.] med3 | --- med3 pg_qsort pg_qsort pg_qsort pg_qsort pg_qsort pg_qsort tbm_begin_iterate BitmapHeapNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.10% 1 postgres libc-2.11.3.so [.] _int_malloc | --- _int_malloc 0x7fb87405c648 0x7fb87405c638 0x7fb87405c628 0x7fb87405c618 0x7fb87405c608 0x7fb87405c5f8 0x7fb87405c5e8 0x7fb87405c5d8 0x7fb87405c5c8 0x7fb87405c5b8 0x7fb87405c5a8 0x7fb87405c598 0x7fb87405c588 0x7fb87405c578 0x7fb87405c568 0x7fb87405c558 0x7fb87405c548 0x7fb87405c538 0x7fb87405c528 0x7fb87405c518 0x7fb87405c508 0x7fb87405c4f8 0x7fb87405c4e8 0x7fb87405c4d8 0x7fb87405c4c8 0x7fb87405c4b8 0x7fb87405c4a8 0x7fb87405c498 0x7fb87405c488 0x7fb87405c478 0x7fb87405c468 0x7fb87405c458 0x7fb87405c448 0x7fb87405c438 0x7fb87405c428 0x7fb87405c418 0x7fb87405c408 0x7fb87405c3f8 0x7fb87405c3e8 0x7fb87405c3d8 0x7fb87405c3c8 0x7fb87405c3b8 0x7fb87405c3a8 0x7fb87405c398 0x7fb87405c388 0x7fb87405c378 0x7fb87405c368 0x7fb87405c358 0x7fb87405c348 0x7fb87405c338 0x7fb87405c328 0x7fb87405c318 0x7fb87405c308 0x7fb87405c2f8 0x7fb87405c2e8 0x7fb87405c2d8 0x7fb87405c2c8 0xbec9a0 0x3d1 0.10% 1 postgres postgres [.] TransactionIdPrecedes | --- TransactionIdPrecedes XidInMVCCSnapshot HeapTupleSatisfiesMVCC heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.10% 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 0x49f6c7 heap_page_prune_opt heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.10% 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 0x7a5772 HeapTupleSatisfiesMVCC heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.10% 1 postgres [kernel.kallsyms] [k] perf_event_mmap | --- perf_event_mmap do_brk sys_brk system_call_fastpath 0x7fb873dbb2aa __brk 0.10% 1 postgres [kernel.kallsyms] [k] prep_new_page | --- prep_new_page get_page_from_freelist __alloc_pages_nodemask alloc_pages_vma do_anonymous_page do_page_fault page_fault 0x5bc4c5 ExecHashTableInsert MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.10% 1 postgres [kernel.kallsyms] [k] page_add_new_anon_rmap | --- page_add_new_anon_rmap do_anonymous_page do_page_fault page_fault 0x7fb873d6c787 __GI_memcpy MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.10% 1 postgres postgres [.] gettimeofday@plt | --- gettimeofday@plt ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.10% 1 postgres [mmfslinux] [k] 0x13d04 | --- 0xffffffffa04b3d04 0xffffffffa0546edd 0xffffffffa05540de 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.10% 1 postgres postgres [.] GetPrivateRefCountEntry | --- GetPrivateRefCountEntry ReleaseBuffer heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.10% 1 postgres [kernel.kallsyms] [k] lookup_page_cgroup | --- lookup_page_cgroup mem_cgroup_update_page_stat __do_fault handle_pte_fault do_page_fault page_fault 0x7a5772 HeapTupleSatisfiesMVCC heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.10% 1 postgres postgres [.] CHashSearch | --- CHashSearch BufTableLookup ReadBuffer_common ReadBufferExtended heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.10% 1 postgres postgres [.] ResourceOwnerEnlargeBuffers | --- ResourceOwnerEnlargeBuffers ReadBuffer_common ReadBufferExtended heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.10% 1 postgres postgres [.] FunctionCall2Coll | --- FunctionCall2Coll _bt_readpage _bt_steppage _bt_next btgetbitmap FunctionCall2Coll index_getbitmap MultiExecBitmapIndexScan BitmapHeapNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.10% 1 postgres postgres [.] ReadBufferExtended | --- ReadBufferExtended heapgetpage heapgettup_pagemode heap_getnext SeqNext ExecScan ExecProcNode MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.10% 1 postgres postgres [.] float48gt | --- float48gt FunctionCall2Coll _bt_checkkeys _bt_readpage _bt_steppage _bt_next btgetbitmap FunctionCall2Coll index_getbitmap MultiExecBitmapIndexScan BitmapHeapNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.10% 1 postgres [mmfs26] [k] 0x36cd0 | --- 0xffffffffa0546cd0 0xffffffffa05540de 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.10% 1 postgres postgres [.] nocache_index_getattr | --- nocache_index_getattr _bt_checkkeys _bt_readpage _bt_steppage _bt_next btgetbitmap FunctionCall2Coll index_getbitmap MultiExecBitmapIndexScan BitmapHeapNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.10% 1 postgres postgres [.] memset@plt | --- memset@plt heap_form_minimal_tuple ExecFetchSlotMinimalTuple ExecHashTableInsert MultiExecHash ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.10% 1 postgres [kernel.kallsyms] [k] __dec_zone_page_state | --- __dec_zone_page_state page_remove_rmap zap_pte_range unmap_page_range unmap_vmas exit_mmap mmput exit_mm do_exit do_group_exit sys_exit_group system_call_fastpath 0x7fb873d90a38 0.10% 1 postgres postgres [.] float4_accum | --- float4_accum advance_transition_function advance_aggregates ExecAgg ExecProcNode ExecSetParamPlan ExecEvalParamExec ExecIndexEvalRuntimeKeys ExecReScanBitmapIndexScan ExecReScan MultiExecBitmapIndexScan BitmapHeapNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.10% 1 postgres [kernel.kallsyms] [k] shmem_fault | --- shmem_fault __do_fault handle_pte_fault do_page_fault page_fault 0x49d348 heap_hot_search_buffer BitmapHeapNext ExecScan ExecProcNode ExecAgg ExecProcNode ExecSetParamPlan ExecEvalParamExec ExecIndexEvalRuntimeKeys ExecReScanBitmapIndexScan ExecReScan MultiExecBitmapIndexScan BitmapHeapNext ExecScan ExecProcNode ExecHashJoin ExecProcNode ExecAgg ExecProcNode ExecSort ExecProcNode standard_ExecutorRun ExplainOnePlan ExplainOneQuery ExplainQuery standard_ProcessUtility PortalRunUtility FillPortalStore PortalRun exec_simple_query PostgresMain ServerLoop PostmasterMain main __libc_start_main 0.10% 1 postgres [kernel.kallsyms] [k] free_pcppages_bulk | --- free_pcppages_bulk free_hot_cold_page __pagevec_free release_pages free_pages_and_swap_cache tlb_flush_mmu zap_pte_range unmap_page_range unmap_vmas unmap_region do_munmap sys_brk system_call_fastpath 0x7fb873dbb2aa __brk 0x7fb874057aa0 0x834800000000ba00 0.10% 1 postgres [kernel.kallsyms] [k] __mem_cgroup_uncharge_common | --- __mem_cgroup_uncharge_common page_remove_rmap zap_pte_range unmap_page_range unmap_vmas unmap_region do_munmap sys_brk system_call_fastpath 0x7fb873dbb2aa __brk 0x7fb874057aa0 0x834800000000ba00 0.02% 1 postgres postgres [.] LWLockRelease | --- LWLockRelease LockRelease UnlockRelationId relation_close vac_update_datfrozenxid do_autovacuum AutoVacWorkerMain StartAutoVacWorker sigusr1_handler __restore_rt PostmasterMain main __libc_start_main 0.02% 1 swapper [kernel.kallsyms] [k] update_shares | --- update_shares rebalance_domains run_rebalance_domains __do_softirq call_softirq do_softirq irq_exit smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.01% 2 postgres [kernel.kallsyms] [k] nf_iterate | --- nf_iterate nf_hook_slow __ip_local_out ip_local_out ip_send_skb udp_send_skb udp_sendmsg sock_sendmsg sys_sendto system_call_fastpath 0x7fb873dc4075 __GI___send 0.01% 1 kworker/2:1 [kernel.kallsyms] [k] module_put | --- module_put __cpufreq_driver_getavg dbs_check_cpu do_dbs_timer process_one_work worker_thread kthread kernel_thread_helper 0.01% 1 postgres [kernel.kallsyms] [k] load_balance | --- load_balance idle_balance thread_return schedule_hrtimeout_range_clock poll_schedule_timeout do_poll do_sys_poll sys_poll system_call_fastpath 0x7fb873db9b8f __libc_poll 0.01% 1 postgres [kernel.kallsyms] [k] get_page_from_freelist | --- get_page_from_freelist __alloc_pages_nodemask alloc_pages_vma do_anonymous_page do_page_fault page_fault copy_user_generic_string 0xffffffffa04bfedc 0xffffffffa04c021c 0xffffffffa0553f90 0xffffffffa05715f4 0xffffffffa04c61ab vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0x100000000 0.01% 5 postgres postgres [.] SyncOneBuffer | --- SyncOneBuffer BgBufferSync BackgroundWriterMain AuxiliaryProcessMain StartChildProcess reaper __restore_rt PostmasterMain main __libc_start_main 0.00% 1 swapper [kernel.kallsyms] [k] rcu_needs_cpu | --- rcu_needs_cpu tick_nohz_stop_sched_tick irq_exit do_IRQ ret_from_intr intel_idle cpuidle_idle_call cpu_idle 0.00% 1 perf [kernel.kallsyms] [k] generic_exec_single | --- generic_exec_single smp_call_function_single perf_event_disable perf_event_for_each_child perf_ioctl do_vfs_ioctl sys_ioctl system_call_fastpath 0x7f464c79a3d7 __ioctl 0.00% 1 fail2ban-server [kernel.kallsyms] [k] find_busiest_group | --- find_busiest_group load_balance idle_balance thread_return schedule_hrtimeout_range_clock poll_schedule_timeout do_select core_sys_select sys_select system_call_fastpath 0x7f465715f393 0x7f465715f393 0x7f4657ff0b30 0x7f4658007d80 0.00% 1 swapper [kernel.kallsyms] [k] run_timer_softirq | --- run_timer_softirq __do_softirq call_softirq do_softirq irq_exit smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle start_kernel x86_64_start_kernel 0.00% 1 swapper [kernel.kallsyms] [k] pm_qos_request | --- pm_qos_request menu_select cpuidle_idle_call cpu_idle start_kernel x86_64_start_kernel 0.00% 1 kworker/2:1 [kernel.kallsyms] [k] native_read_tsc | --- native_read_tsc delay_tsc igb_read_phy_reg_mdic igb_read_phy_reg_82580 igb_update_stats igb_watchdog_task process_one_work worker_thread kthread kernel_thread_helper 0.00% 1 postgres [kernel.kallsyms] [k] cp_new_stat | --- cp_new_stat sys_newfstat system_call_fastpath 0x7fb873db47d4 __GI___fxstat (nil) 0.00% 1 swapper [kernel.kallsyms] [k] find_busiest_group | --- find_busiest_group load_balance rebalance_domains run_rebalance_domains __do_softirq call_softirq do_softirq irq_exit smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] _raw_spin_unlock_irqrestore | --- _raw_spin_unlock_irqrestore try_to_wake_up __queue_work call_timer_fn run_timer_softirq __do_softirq call_softirq do_softirq irq_exit smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 postgres [kernel.kallsyms] [k] rw_verify_area | --- rw_verify_area vfs_read sys_read system_call_fastpath 0x7fb873db55d0 __GI___read 0.00% 1 postgres [kernel.kallsyms] [k] up | --- up 0xffffffffa05bf269 0xffffffffa05bfd6f 0xffffffffa051298d 0xffffffffa053faf2 0xffffffffa0583688 0xffffffffa04b9b97 __dentry_open do_last path_openat do_filp_open do_sys_open system_call_fastpath 0x7fb873db51e0 __GI___open64 0x626f6c672f706d74 0.00% 1 swapper [kernel.kallsyms] [k] hrtimer_interrupt | --- hrtimer_interrupt smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 swapper [kernel.kallsyms] [k] exit_idle | --- exit_idle smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle start_kernel x86_64_start_kernel 0.00% 1 swapper [kernel.kallsyms] [k] enqueue_entity | --- enqueue_entity enqueue_task_fair ttwu_activate ttwu_do_activate try_to_wake_up __queue_work call_timer_fn run_timer_softirq __do_softirq call_softirq do_softirq irq_exit smp_apic_timer_interrupt apic_timer_interrupt intel_idle cpuidle_idle_call cpu_idle 0.00% 1 kworker/10:1 [kernel.kallsyms] [k] dequeue_task | --- dequeue_task __schedule worker_thread kthread kernel_thread_helper # # (For a higher level overview, try: perf report --sort comm,dso) #